# Northeastern costs approximately \$50,000 per year for a four-year program, whether completed in four years or five. Assume that a student’s parents realized 15 years ago that college was going to cost \$50,000 per year for four years, and wondered how much they would have to save each year to have the money to pay for the student’s education. The assumption is that payments are made into the college fund each year (as an ordinary annuity), and payments are withdrawn from the fund at the end of the relevant years.The key information for this scenario is as follows:The number of years of contributions is 18.Assume for simplicity that the college payments will be made at the end of years 15, 16, 17, and 18, that is just after each deposit in those years.The interest rate is 10 percent.College costs are \$50,000 per year, and are assumed to be the same for each of the four years.Using the key information for the scenario above, how much would the parents have to save each year for 18 years to have exactly the amount of money needed to pay the student’s expenses? (Solve for the annual savings that will exactly match the amount saved to the amount needed for college.) Be sure to include your calculation formulas in your answer.

Question
16 views
1. Northeastern costs approximately \$50,000 per year for a four-year program, whether completed in four years or five. Assume that a student’s parents realized 15 years ago that college was going to cost \$50,000 per year for four years, and wondered how much they would have to save each year to have the money to pay for the student’s education. The assumption is that payments are made into the college fund each year (as an ordinary annuity), and payments are withdrawn from the fund at the end of the relevant years.

The key information for this scenario is as follows:
1. The number of years of contributions is 18.
2. Assume for simplicity that the college payments will be made at the end of years 15, 16, 17, and 18, that is just after each deposit in those years.
3. The interest rate is 10 percent.
4. College costs are \$50,000 per year, and are assumed to be the same for each of the four years.

Using the key information for the scenario above, how much would the parents have to save each year for 18 years to have exactly the amount of money needed to pay the student’s expenses? (Solve for the annual savings that will exactly match the amount saved to the amount needed for college.) Be sure to include your calculation formulas in your answer.

check_circle

star
star
star
star
star
1 Rating
Step 1

Cost of per year for four-year program (pmt) = \$50,000

Interest rate (rate) = 10%

Number of Years (nper) = 4

Calculation of total cost of four-year program (FV) using excel FV function:

To open the "FV function" window - MS-Excel --> Formulas --> Financials --> FV.

Step 2

The total amount that needed to pay for the four-year program is \$232,050.

Step 3

Total amount needed for the four-year program (FV) = \$232,050

Interest rate (rate) = 10%

Number of years (nper) = 15 years

Calculation of amount that needed to save each ...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in 