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
Asked Sep 17, 2019
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

Expert Answer

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.

help_outline

Image Transcriptionclose

|=FV| FV(rate, nper, pmt, [pv], [type]) | =FV(10%,4,50000,0) ($232,050.00)

fullscreen
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 ...

help_outline

Image Transcriptionclose

PMT PMT(rate, nper, pv, [fv], [type]) =PMT(10%,15,,232050) (S7,303.49)

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Business

Finance

Related Finance Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: You have $5,000 invested in a bank account that pays a 6percent nominal annual interest with daily c...

A: Amount invested, PV = $ 5,000Interest rate = 6% annual interest rate compounded daily.Hence, interes...

question_answer

Q: A bond with a coupon rate of 7.30% has a price that today equals $868.92. The $1,000 face value bond...

A: Calculation of Yield to Maturity of the Bond:

question_answer

Q: Discuss the pros and cons of a 30 year, fixed rate loan.  In addition, should Congress and state leg...

A: The following are some pros of a 30-year fixed rate loan:Higher tax deduction: The present tax laws ...

question_answer

Q: Yield to Maturity and Yield to Call Arnot International's bonds have a current market price of $1,25...

A: First three subparts will be answered as per our policies.1)Coupon = 10% of Face value = 10% of 1000...

question_answer

Q: Modern Artifacts can produce keepsakes that will be sold for $60 each. Nondepreciation fixed costs a...

A: Your answers to part (a), (b) and (c) are correct. Hence, I am not solving them again. Further you h...

question_answer

Q: Use the following information to find dividends paid to common stockholders during 2021. (Enter your...

A: Retained earnings refers to the cumulative net profits (that a firm accumulates) after paying the di...

question_answer

Q: Suppose that C is the price of a European call option to purchase a security whose present price is ...

A: As a first step, let's assimilate the information given to us:Current stock price is SC is the price...

question_answer

Q: The Maurer Company has a long-term debt ratio of .27 and a current ratio of 1.30. Current liabilitie...

A: Net fixed assets are recorded in the books at purchase price after deducting accumulated depreciatio...

question_answer

Q: Suppose that, in each period, the cost of a security either goes up by a factor of 2 or goes down by...

A: We have two options here, first is doubling and second is moving down by half. We assume that the pr...