Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Equity Valuation Risk And Investment A Practitioners Roadmap

Authors: Peter C. Stimes

1st Edition

0470226404, 9780470226407

More Books

Students also viewed these Finance questions