Put excel cell equations in boxes

H9 A B . D E F G H Question 1: Growing Annuity 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.37 will be made today. The last disbursement from the college fund will be on Scout's 21st 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.7% return on his contributions. Using the above information, fill in the Table below. (Useful Hint: You will need to draw- down 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) Deposit Amount $8,656.37 Interest Rate College Cost This Year Cost Growth Rate Contribution Growth Rate Value of Last Contribution 3.7% $ 25,000.00 5.096 8.0% Tuition Costs Deposits Balance 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Year South's Age J-C's Age 0 5 3 1 6 4 2 7 5 3 8 6 4 9 7 5 10 8 6 11 9 7 12 10 13 11 9 14 12 10 15 13 11 16 14 12 172 15 Instructions Your Info H9 x fx D E F H B they are both in school) 4 Deposit Amount $8,656.37 Interest Rate College Cost This Year Cost Growth Rate Contribution Growth Rate Value of Last Contribution 3.7% $ 25,000.00 5.0% 8.0% Year South's Age J-C's Age Tuition Costs Deposits Balance 0 1 2 3 4 5 3 4 5 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 6 7 6 7 8 9 10 11 12 13 14 15 16 17 18 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Hint: The ending account