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.

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.

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

I am evaluating a growing perpetuity product from a large financial services firm. The product promises an initial payment of $24,000 at the end of this year and subsequent payments that will thereafter grow at a rate of 0.02% annually. If you use a discount rate of 0.07% for investment products, what is the presentvalue of thi

I would like to have the solution to the following sample problems in EXCEL format so that I can see the formulas used. Thanks
1. What is the presentvalue of a series of payments received each year for 9 years, starting with $300 paid one year from now and the payment growing in each subsequent year by 3%? Assume a discount

What is the relationship between the PVIFi,n (Table 5-4) and the PVIFAi,n (Table 5-8)? What is the PVIFA10%,10yrs? Add up the values of the PVIF10%,n for n = 1, ..., 10. What is this value? Why do these values have the relationship they do?
Please see the attached Tables

Find:
- the presentvalue of $300,000 annuity at 6% for 20 years
- the presentvalue of $500,000 deferred annuity at 6% for 20 (21-40) years
- the presentvalue of 50,000 annuity at 6% for 40 years
- the presentvalue of 75 million paid at the end of 40 years
- the presentvalue of 300,000 annuity at 11% for 20 years
- th

you have applied for a job at a local bank. as part of its evaluation process, you must take an examination on time value of money analysis covering the following...
b. 1) whats the future value of $100 after 3 years if it earns 10% annual compounding?
2) whats the presentvalue of $100 to be received in 3 years if the

I just bought a 10 year ordinary annuity that promises to pay 1,500 at the end of each next 10 years. If the appropriate interest rate for this annuity is 7.8% what is the presentvalue of this annuity?
If I want to extend my annuity another ten years, if I pay more money today, I can continue to receive $1,500 per year for

Please include in your response the formulas required for this problem, along with a detailed explanation of how it is solved.
AnnuityValues.
a) What is the presentvalue of a 3-year annuity of $100 if the discount rate is 6 percent?
b) What is the presentvalue of the annuity from part (a) of this question if you have

How much would you have to invest today to receive:
a. $15,000 in 8 years at 10 percent?
b. $20,000 in 12 years at 13 percent?
c. $6,000 each year for 10 years at 9 percent?
d. $50,000 each year for 50 years at 7 percent?

You have been offered two annuities for the same price. Annuity 1 pays $50,000 per year at the end of the year for 10 years. Annuity 2 pays $40,000 per year at the end of the year for 20 years. If your cost of capital is 10%, which of these two annuities is a better deal, why?