Return to flip book view

INFLOWSJavier's Gross Salary 64,500.00$ Sofia's Taxable Income 82,000.00$ Taxable distributions from Investments 1,445.00$ Total Inflows 147,945.00$ OUTFLOWSTaxesFederal 19,084.91$ State 7,397.25$ FICA (SS & Med) 16,520.48$ Total Tax 43,002.64$ Savings401(k) Contribution (Javier) 2,580.00$ SIMPLE IRA Contribution (Sofia) 4,100.00$ Roth IRA Contribution (Sofia) 1,000.00$ 529 Plan Contribution (Projected)General non-qualified savings (Joint) 2,400.00$ Total Withholdings 10,080.00$ Insurance and other taxesHomeowners Insurance 800.00$ Real Estate Tax 3,136.00$ Auto Insurance 2,000.00$ Personal Property Tax 721.00$ Health Insurance 4,200.00$ Total Fixed Expenses 10,857.00$ Contractual ExpensesMortgage 6,789.00$ Truck Loan 5,823.80$ Credit CardNew car loan (Projected)Total Contractual Exp 12,612.80$ Variable ExpensesGroceries 12,500.00$ Entertainment (Dining, movies, etc.) 2,200.00$ Auto maintenance and gas 4,650.00$ Utilities (gas, elec, water, cell, cable) 5,760.00$ Personal Hygiene 800.00$ Clothing 2,500.00$ Javier & Sofia Garcia 2020 Income and Expense Statement

Subscriptions (online and print) 350.00$ Travel Expenses (Vacations) 4,580.00$ Gifts 2,000.00$ Child care 9,600.00$ Untracked credit card expenses 4,200.00$ Untracked cash expenses 3,750.00$ Total Variable Expenses 52,890.00$ Total Outflows 129,442.44$ Discretionary CF 18,502.56$

% of Income12.9%5.0%11.2%29.1%1.7%2.8%0.7%0.0%1.6%6.8%0.5%2.1%1.4%0.5%2.8%7.3%4.6%3.9%0.0%0.0%8.5%8.4%1.5%3.1%3.9%0.5%1.7%

0.2%3.1%1.4%6.5%2.8%2.5%35.7%87.5%

Cash/Cash EquivalentsJoint Checking 7,100.00$ Joint Savings 7,500.00$ Total 14,600.00$ Investment Accounts - TaxableJoint BrokerageTotal -$ Retirement AccountsJavier Rollover IRA 37,500.00$ Javier Current 401 (k) 86,935.00$ Sofia Roth IRASofia SIMPLE IRA 45,000.00$ Total 169,435.00$ Real EstateJoint Personal Residence 360,000.00$ Total 360,000.00$ Personal UseJoint 2011 Dodge Grand Caravan 4,000.00$ Joint 2016 Ram Quad Cab Big Horn 18,000.00$ Total 22,000.00$ Total Assets 566,035.00$ Current-term LiabilitiesJoint Visa Credit CardTotal -$ Long-term LiabilitiesJoint Vehicle LoanJoint MortgageTotal -$ Total Liabilities -$ Net Worth 566,035.00$ Javier & Sofia Garcia 2020 Balance Sheet

Use the two loan sheets to complete. Select the ending balance from Jan 2020

Region Asset ClassAverage Annual ReturnSuggested Allocation WeightDomestic (U.S.) StocksLarge-Cap StocksMid-Cap StocksSmall-Cap StocksBondsCorporate Inv Grade BondsCorporate Hi-Yield BondsTreasuriesCommoditiesReal EstateCash (Money Market Funds)International Developed Markets StocksEmerging Markets StocksCorporate BondsThis box must equal 100% -> 0.00%You can put the data in the yellow cells

Return by Asset ClassDon't change this column0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% = Total Portfolio Return

You can input the case data in the yellow cellsTerm yearsInt / Year APRPayment / year PMT / monthOriginal LoanBeg Balance PMT INT PRIN End Balance2/1/20163/1/20164/1/20165/1/20166/1/20167/1/20168/1/20169/1/201610/1/201611/1/201612/1/20161/1/20172/1/20173/1/20174/1/20175/1/20176/1/20177/1/20178/1/20179/1/201710/1/201711/1/201712/1/20171/1/20182/1/20183/1/20184/1/20185/1/20186/1/20187/1/20188/1/20189/1/201810/1/201811/1/201812/1/20181/1/20192/1/20193/1/20194/1/2019

5/1/20196/1/20197/1/20198/1/20199/1/201910/1/201911/1/201912/1/20191/1/20202/1/20203/1/20204/1/20205/1/20206/1/20207/1/20208/1/20209/1/202010/1/202011/1/202012/1/20201/1/20212/1/20213/1/20214/1/20215/1/20216/1/20217/1/20218/1/20219/1/202110/1/202111/1/202112/1/20211/1/202211/1/202112/1/20211/1/20222/1/20223/1/20224/1/20225/1/20226/1/20227/1/20228/1/20229/1/202210/1/202211/1/202212/1/2022

1/1/20232/1/20233/1/20234/1/20235/1/20236/1/20237/1/20238/1/20239/1/202310/1/202311/1/202312/1/20231/1/20242/1/20243/1/20244/1/20245/1/20246/1/20247/1/20248/1/20249/1/202410/1/202411/1/202412/1/20241/1/20252/1/20253/1/20254/1/20255/1/20256/1/20257/1/20258/1/20259/1/202510/1/202511/1/202512/1/20251/1/20262/1/20263/1/20264/1/20265/1/20266/1/20267/1/20268/1/20269/1/202610/1/202611/1/2026

12/1/20261/1/20272/1/20273/1/20274/1/20275/1/20276/1/20277/1/20278/1/20279/1/202710/1/202711/1/202712/1/20271/1/20282/1/20283/1/20284/1/20285/1/20286/1/20287/1/20288/1/20289/1/202810/1/202811/1/202812/1/20281/1/20292/1/20293/1/20294/1/20295/1/20296/1/20297/1/20298/1/20299/1/202910/1/202911/1/202912/1/20291/1/20302/1/20303/1/20304/1/20305/1/20306/1/20307/1/20308/1/20309/1/203010/1/2030

11/1/203012/1/20301/1/20312/1/20313/1/20314/1/20315/1/20316/1/20317/1/20318/1/20319/1/203110/1/203111/1/203112/1/20311/1/20322/1/20323/1/20324/1/20325/1/20326/1/20327/1/20328/1/20329/1/203210/1/203211/1/203212/1/20321/1/20332/1/20333/1/20334/1/20335/1/20336/1/20337/1/20338/1/20339/1/203310/1/203311/1/203312/1/20331/1/20342/1/20343/1/20344/1/20345/1/20346/1/20347/1/20348/1/20349/1/2034

10/1/203411/1/203412/1/20341/1/20352/1/20353/1/20354/1/20355/1/20356/1/20357/1/20358/1/20359/1/203510/1/2035

You can input the case data in the yellow cellsTerm years monthsInt / Year APR EPRPayment / year PMT / monthOriginal LoanBeg Balance PMT INT PRIN End Balance1/1/20112/1/20113/1/20114/1/20115/1/20116/1/20117/1/20118/1/20119/1/201110/1/201111/1/201112/1/20111/1/20122/1/20123/1/20124/1/20125/1/20126/1/20127/1/20128/1/20129/1/201210/1/201211/1/201212/1/20121/1/20132/1/20133/1/20134/1/20135/1/20136/1/20137/1/20138/1/20139/1/201310/1/201311/1/201312/1/20131/1/20142/1/20143/1/2014

4/1/20145/1/20146/1/20147/1/20148/1/20149/1/201410/1/201411/1/201412/1/20141/1/20152/1/20153/1/20154/1/20155/1/20156/1/20157/1/20158/1/20159/1/201510/1/201511/1/201512/1/20151/1/20162/1/20163/1/20164/1/20165/1/20166/1/20167/1/20168/1/20169/1/201610/1/201611/1/201612/1/20161/1/20172/1/20173/1/20174/1/20175/1/20176/1/20177/1/20178/1/20179/1/201710/1/201711/1/201712/1/20171/1/20182/1/2018

3/1/20184/1/20185/1/20186/1/20187/1/20188/1/20189/1/201810/1/201811/1/201812/1/20181/1/20192/1/20193/1/20194/1/20195/1/20196/1/20197/1/20198/1/20199/1/201910/1/201911/1/201912/1/20191/1/20202/1/20203/1/20204/1/20205/1/20206/1/20207/1/20208/1/20209/1/202010/1/202011/1/202012/1/20201/1/20212/1/20213/1/20214/1/20215/1/20216/1/20217/1/20218/1/20219/1/202110/1/202111/1/202112/1/20211/1/2022

2/1/20223/1/20224/1/20225/1/20226/1/20227/1/20228/1/20229/1/202210/1/202211/1/202212/1/20221/1/20232/1/20233/1/20234/1/20235/1/20236/1/20237/1/20238/1/20239/1/202310/1/202311/1/202312/1/20231/1/20242/1/20243/1/20244/1/20245/1/20246/1/20247/1/20248/1/20249/1/202410/1/202411/1/202412/1/20241/1/20252/1/20253/1/20254/1/20255/1/20256/1/20257/1/20258/1/20259/1/202510/1/202511/1/202512/1/2025

1/1/20262/1/20263/1/20264/1/20265/1/20266/1/20267/1/20268/1/20269/1/202610/1/202611/1/202612/1/20261/1/20272/1/20273/1/20274/1/20275/1/20276/1/20277/1/20278/1/20279/1/202710/1/202711/1/202712/1/20271/1/20282/1/20283/1/20284/1/20285/1/20286/1/20287/1/20288/1/20289/1/202810/1/202811/1/202812/1/20281/1/20292/1/20293/1/20294/1/20295/1/20296/1/20297/1/20298/1/20299/1/202910/1/202911/1/2029

12/1/20291/1/20302/1/20303/1/20304/1/20305/1/20306/1/20307/1/20308/1/20309/1/203010/1/203011/1/203012/1/2030

Annual Inflation Rate = Years until first year of college = Current Cost Future CostYear 1 = Year 2 = Year 3 = Year 4 = Total cost starting today $0.00 Total cost starting in years = $0.00Enter this value in Table??? How much could a college education cost - fill in the yellow cells ???