Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions