Question
Steve is a newborn. His parents are planning to contribute $6,000 a year (or possibly less) towards his college fund into an account that will
Steve is a newborn. His parents are planning to contribute $6,000 a year (or possibly less) towards his college fund into an account that will grow at a constant rate of 5% a year. Both parents work for the same company that offered to match parental contributions dollar for dollar for the first 6 parental deposits and 25 cents for every parental dollar for subsequent parental deposits, until Steve reaches 19. Once he reaches 19, both the company and parents stop their contributions. College costs are expected to be $55,000 a year and Steve spends 4 years in college once he reaches 19. Assume that the beginning account balance is $35,000 (a) What is the smallest amount parents should contribute each year to make Steve's college affordable?Solve on excel
b)What is the total amount both parents and the company contribute to college fund at age 2 when this problem is solved . c)Draw a graph that shows how the total amount in the account at the end of the year changes with Steve's age On the graph label X-axis "Steve's age", Y-axis "Amount in US dollars" and use graph title "Steve's college fund"
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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