Question: please assist with excel function or calculator QUESTION 37 5 John and Daphne are saving for their daughter Ellen's college education. Ellen just turned 10
QUESTION 37 5 John and Daphne are saving for their daughter Ellen's college education. Ellen just turned 10 (at t-0), and she will be entering college 8 years from now (att-S). College tuition and expenses at State U. are currently S14,500 a year, but they are expected to increase at a rate of 3.5% a year. Ellen should graduate in 4 years if she takes longer or wants to go tograduate school, she will be on her own. Tution and other costs will be due at the beginning ofeach school year (at 8, 9, 10, and 11). So far, John and Daphne have accumulated S15,000 in their college savings account (att-0). Their long-run financial plan is to add an additional $5,000 in each of the next 4 years (at t 1,2, 3, and 4). Then they plan to make 3 equal annual contributions in each ofthe following years, t 5, 6, and 7. They expect their mestment account to earn 900 How large must the annual payments at t 5, 6, and 7 be to cover Ellen's anticipated college costs? O S2,292.12 O $1,965.21 $2,177.51 O S2,412.76 O $2,068.64
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
