Business

FinanceQ&A LibraryNortheastern 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

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

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

Tagged in

Find answers to questions asked by student like you

Show more Q&A

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

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:

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

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

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

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

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

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

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