Explore BrainMass

# Calculating Present Values and Growing Annuity Perpetuity

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

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 present value 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 rate of 5%.

2. What is the present value of a series of payments received each year for 6 years, starting with \$500 paid one year from now and the payment growing in each subsequent year by 5%? Assume a discount rate of 8%.

3. What is the present value of a series of payments received each year forever, starting with \$100 paid one year from now and the payment growing in each subsequent year by 6%? Assume a discount rate of 9%.

4. What is the present value of a series of payments received each year forever, starting with \$400 paid one year from now and the payment growing in each subsequent year by 9%? Assume a discount rate of 11%.