Calculate the present value of a growing annuity at a discount rate of 9% per year....

Calculate the present value of a growing annuity at a discount rate of 9% per year. The growth rate (constant) of the annuity is 4% per year. the life of the annuity is 10 years. the first annuity payment is $2000 occurring at the end of year one.

Calculate using Excel please.

Solutions

Expert Solution

The formula for Cashflow is mentioned in cell C2 [=B2*(1+$B$5)] and we can drag this formula to other cells till year 10.

Year 1 Cashflow is 2000 and since it is a growing annuity so, Year 2 Cashflow will be C₂ = (1+4%)*2000 = 2080

Now, the formula to calculate the present value of different cashflows is mentioned in the below screenshot.

The formula used in the cell B3 is =B2/(1+$B$6)^B1. Basically, we are using the formula to calculate the present Value of the cash-flows. A cashflow C(n) occurring at the nth period is given by:

PV = C(n)/(1+r)ⁿ where r is the discount rate.

So, the present value of the annuity is 14989.15269

Answer -> 14989.15269

jeff jeffy answered 7 months ago

Next > < Previous

Related Solutions

What is the present value of a perpetuity of $80 per year if the discount rate...

What is the present value of a perpetuity of $80 per year if the discount rate is 11%?

a) What is the present value of $1,200 per year, at a discount rate of 8...

a) What is the present value of $1,200 per year, at a discount rate of 8 percent, if the first payment is received 9 years from now and the last payment is received 28 years from now? b) ABC Co. wants to sell you an annuity that will pay you $500 per quarter for 25 years. You want to earn a minimum rate of return of 5.1 percent. What is the most you are willing to pay today to buy...

What is the present value of $2,625 per year at a discount rate of 8%, if...

What is the present value of $2,625 per year at a discount rate of 8%, if the first payment is received six years from now and the last payment is received 20 years from now? PLEASE USE excel

What happens to the present value of an annuity if the discount rate is increased? Why?...

What happens to the present value of an annuity if the discount rate is increased? Why? What about its future value? 2. Assume an athlete signs ten year contracts that pay out a total of $25 million over the life of the contracts. One contract will pay $4.8 million per year over 5 years and 2.4 million the last 5 years. Another contract will pay $4 million per year over 10 years. The last and third contract option is a...

What is the present value of $1,700 per year, at a discount rate of 10 percent,...

What is the present value of $1,700 per year, at a discount rate of 10 percent, if the first payment is received 4 years from now and the last payment is received 21 years from now? Multiple Choice $2,625.04 $10,475.13 $14,042.40 $10,265.63 $10,245.41

What is the present value of $1,200 per year, at a discount rate of 8 percent,...

What is the present value of $1,200 per year, at a discount rate of 8 percent, if the first payment is received 9 years from now and the last payment is received 28 years from now?

Calculate the present value of the following cash flows given a discount rate of 12%: Year...

Calculate the present value of the following cash flows given a discount rate of 12%: Year 1 Year 2 Year 3 Year 4 Cash Flows $1,500 $4,500 $8,500 $12,000

At a discount rate of 11.00%, find the present value of a perpetual payment of $6,500 per year.

At a discount rate of 11.00%, find the present value of a perpetual payment of $6,500 per year. If the discount rate were lowered to 5.50%, half the initial rate, what would be the value of the perpetuity? a. If the discount rate were 11.00%, the present value of the perpetuity is (Round to the nearest cent )

7. What is present value of perpetuity of $100 per year if appropriate discount rate is...

7. What is present value of perpetuity of $100 per year if appropriate discount rate is 5%? If discount rate is increased to 15% what is the present value of the perpetuity?

Suppose the present vaule of a 5 year ordinary annuity is $528, if the discount rate...

Suppose the present vaule of a 5 year ordinary annuity is $528, if the discount rate is 14%, what must the annual cash flow be?

Subjects