Explore BrainMass
Share

Explore BrainMass

    PV and FV of Single Sum, Annuity and Perpetuity

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

    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 ad1c9bdddf
    https://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.

    $2.19

    ADVERTISEMENT