Question
3. Linda is 10 years old. Her parents want to save for 4 years of college, starting at 18. Her parents want to deposit X
3. Linda is 10 years old. Her parents want to save for 4 years of college, starting at 18. Her parents want to deposit X today and on birthdays 11,12, . 17. On birthdays 18, 19, 20, 21 they plan to take out $20,000 the total cost of education. How much do her parents need to save each year? Assume the discount rate is 10%. Solve the following ways: a. Using trial and error, is the $4,000/per year enough? b. Using Goal Seek, solve for the annual deposit necessary to meet their financial goals.
Can you show all work and excel functions please? Thank you.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started