Explore BrainMass
Share

Present Value of Growing Annuity

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Jane has a child and wishes to begin saving for college expenses. Child will enter college in 6 years. Assume child will spend 4 years in college, that the real (ie: inflation adjusted) annual cost of a college education will remain at $24,000, that the nominal interest rate is 4.55%, that the expected rate of inflation is 2.0%, and that the first college payment is due at time 6 and the last payment is due at time 9. Jane wants to make 9 annual investments (beginning 1 year from now and ending 9 years from now) such that the savings will cover the cost of college. Her first investment (at 1) will be $A (in real terms) and subsequent investments will grow (in real terms) by 1% per year.

NEED TO SHOW EXCEL FORMULAS:
1) What is the nominal growth rate in her investment amount?

2) What initial nominal investment, A, will be required, at time 1, if Ms. Wells wishes to exactly cover the college expenses? Show your logic.

3) What is the nominal amount of your last investment, in year 9?

4) What is the real amount invested in year 1 and in year 9?

5) Now assume that she wants to pay off the college over 12 years rather than 9 years. When she had less money than needed to pay for college, she needs to take out a loan at an interest rate of 7.10%. Answer (2) and (3) for this scenario.

© BrainMass Inc. brainmass.com October 25, 2018, 10:14 am ad1c9bdddf
https://brainmass.com/business/the-time-value-of-money/present-value-growing-annuity-603402

Solution Preview

Please refer to the attachments for full solution.

Posting ID: 603402
Category: Business / Finance / The Time Value of Money Wrong category? Edit It Level: Year 2
College Savings
Jane has a child and wishes to begin saving for college expenses. Child will enter college in 6 years. Assume child will spend 4 years in college, that the real (ie: inflation adjusted) annual cost of a college education ...

Solution Summary

The solution shows all the steps to compute the annuity using the formula for the present value of growing annuity. It also distinguishes between real and nominal growth, and interest rates.

$2.19
See Also This Related BrainMass Solution

Present Value of Growing Annuity vs Ordinary Annuity

The city of Cincinnati gave up the right to collect parking fees over a 30-year period in exchange for a lump sum of $92 million plus a 30-year annuity of $3 million. Suppose that if the city had not entered into that arrangement, it would have collected parking fees the following year of $6 million (net of operating costs), and those fees would have grown at a steady 3% for the next 30 years. At an interest rate of 4%, what is the present value of the parking revenue that the city could have collected? Using the same 4% to value the payments that the city was set to receive in their privatization deal, do you think that the city made the correct decision? Why or why not?

View Full Posting Details