# PV and FV of Single Sum, Annuity and Perpetuity

1. Present value of single sum problem

You are going to be given $100,000 in 12 years. Assuming an inflation rate of 3.5%, what is the present value of this amount?

2. Perpetuity problem

What is the value of a perpetuity with an annual payment of $100 and a discount rate of 6%?

3. Future value of single sum problem

You put $2,000 in an investment account today which will earn 8% over the next 14 years, what is the future value?

4. Present value of single sum problem

You are going to be given $45,000 in 7 years. Assuming an inflation rate of 2.5%, what is the present value of this amount?

5. Present value of annuity problem

You will receive $1,200 at the end of the next 15 years, assuming an 8% discount rate, what is the present value of the cash flows?

© BrainMass Inc. brainmass.com June 1, 2020, 11:49 pm ad1c9bdddfhttps://brainmass.com/business/annuity/pv-and-fv-of-single-sum-annuity-and-perpetuity-503836

#### Solution Summary

This solution illustrates how to solve numerous time value of money problems using Excel functions. It also explains each function and how to translate a problem into each function.