Question: EXCEL HELP PLEASE! must include the formulas and functions and not just the answer. The orange cells need to be answered. Homework 1 Pa File

Homework 1 Pa File Home Insert Draw Page Layout Formulas Data Review View Help Calibri General 3 Cut Copy - Paste Format Painter Clipboard 12 AA 32 A. BIU. ab Wrap Text Merge & Center $ - % Font Alignment Numb H13 B D F G Question 1: Growing Annuity 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 4 the years when they are both in school) 5 6 Deposit Amount 8,656,37 7 8 Interest Rate 3.796 9 College Cost This Year $ 25,000.00 10 Cost Growth Rate 5.0% 11 Contribution Growth Rate 8.09 12 Value of Last Contribution 13 14 Year South's Age J-C's Age Tuition Costs Deposits Balance 15 0 5 Instructions Your Info Q1 Q2 Q3 Ready Scroll Lock Type here to search O DI Paste BE FE Insert Delete Format Format Printer BTU...A. Merge Center - $ -% , Opboard Alignment Number H13 f - Clear 1 Conditional Format a Cali Formatting table Styles Style Font Cell > D SON BON M Tuition Costs Deposits Balance J-CHA 3 -5 5 7 10 Cost Growth Rate 1 Contribution Growth Rate 12 Value of Last Contribution 10 16 Year South's Ace 15 0 16 2 17 2 2 10 1 8 4 9 20 5 10 21 6 11 22 2 12 23 8 9 25 10 15 20 11 16 27 12 17 1 18 20 14 10 30 15 20 11 16 21 2 12 22 13 18 > 14 9 10 LI 12 11 14 15 16 17 18 19 20 21 Mint the ending account balance should be ser for very done to you are doing it correctly
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
