L$25$

$f_x$

A

B

C

D

$E$

$F$

G

$H$

$3$

Atticus Finch is creating a college fund for his two kids, Jem and Scout, ages $5$ and $3,$ respectively. To take over the family law practice, they will start college at $18$ years old. Today, Maycomb University costs $$25,000,$ per student, and this cost is expected to increase by $5\%$ each year. Atticus plans to make $19$ annual contributions to the college fund, and he plans to increase the contributions by $8\%$ each year to combat inflation. The first contribution of $$8,656\mathrm{.}37$ will be made today. The last disbursement from the college fund will be on Scout's $21$st birthday. On that day, also, the last payment must be made for his last year of college. As Mr$.$ Finch's investment advisor, you promised he will earn $3\mathrm{.}7\%$ return on his contributions. Using the above information, fill in the Table below. $($Useful Hint: You will need to drawdown on the college fund acccount to pay for tuition once the kids are in college. Moreover, look out for the years when they are both in school$)$

$\backslash$table$[[$Deposit Amount,$$8,656\mathrm{.}37]]$

$\backslash$table$[[$Interest Rate,$3\mathrm{.}7\%],[$College Cost This Year,$$25,000\mathrm{.}00],[$Cost Growth Rate,$5\mathrm{.}0\%],[$Contribution Growth Rate,$8\mathrm{.}0\%],[$Value of Last Contribution,$$34,591\mathrm{.}02]]$

$\backslash$table$[[$Year$,$Jem's Age,Scout's Age,Tuition Costs,Deposits,Balance$],[0,5,3,$$$25,000\mathrm{.}00,$$$8,656\mathrm{.}37,$$$8,656\mathrm{.}37],[1,6,4,$$$26,250\mathrm{.}00,$$$9,348\mathrm{.}88,$$$18,325\mathrm{.}54],[2,7,5,$$$27,562\mathrm{.}50,$$$10,096\mathrm{.}79,$$$29,100\mathrm{.}37],[3,8,6,$$$28,940\mathrm{.}63,$$$10,904\mathrm{.}53,$$$41,081\mathrm{.}62],[4,9,7,$$$30,387\mathrm{.}66,$$$11,776\mathrm{.}90,$$$54,378\mathrm{.}53],[5,10,8,$$$31,907\mathrm{.}04,$$$12,719\mathrm{.}05,$$$69,109\mathrm{.}59],[6,11,9,$$$33,502\mathrm{.}39,$$$13,736\mathrm{.}57,$$$85,403\mathrm{.}21],[7,12,10,$$$35,177\mathrm{.}51,$$$14,835\mathrm{.}50,$$$103,398\mathrm{.}63],[8,13,11,$$$36,936\mathrm{.}39,$$$16,022\mathrm{.}34,$$$123,246\mathrm{.}71],[9,14,12,$$$38,783\mathrm{.}21,$$$17,304\mathrm{.}12,$$$145,110\mathrm{.}97],[10,15,13,$$$40,722\mathrm{.}37,$$$18,688\mathrm{.}45,$$$169,168\mathrm{.}52],[11,16,14,$$$42,758\mathrm{.}48,$$$20,183\mathrm{.}53,$$$195,611\mathrm{.}29],[12,17,15,$$$44,896\mathrm{.}41,$$$21,798\mathrm{.}21,$$$224,647\mathrm{.}12],[13,18,16,$$$47,141\mathrm{.}23,$$$23,542\mathrm{.}07,$$$209,359\mathrm{.}90],[14,19,17,$$$49,498\mathrm{.}29,$$$25,425\mathrm{.}43,$$$193,033\mathrm{.}37],[15,20,18,$$$51,973\mathrm{.}20,$$$27,459\mathrm{.}47,$$$123,688\mathrm{.}66],[16,21,19,$$$54,571\mathrm{.}86,$$$29,656\mathrm{.}23,$$$48,777\mathrm{.}64],[17,22,20,$$$57,300\mathrm{.}46,$$$32,028\mathrm{.}73,$$$25,310\mathrm{.}68],[18,23,21,$$$60,165\mathrm{.}48,$$$34,591\mathrm{.}02,$$$672\mathrm{.}72]]$

Hint: The ending account balance should be zero $($or very close to zerc

RED is incorrect$*$