Share
Explore BrainMass

Future value of single sum annuity using excel

1.) You put $5,000 in an investment account today which will earn 6% over the next 11 years, what is the future value?

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

3.) You deposit $5,000 into a retirement account at the end of the next 15 years earning 8% interest, what is the future value of your retirement after 15 years?

4.) What is the value of a perpetuity with an annual payment of $50 and a discount rate of 4%?

5.) You deposit $10,000 into a retirement account at the end of the next 10 years earning 9% interest, what is the future value of your retirement after 10 years?

Solution Summary

Your tutorial is in Excel and gives you the ingredients (p = , i = , pv/pmt = ) to use excel or a financial calculator to get desired amounts.

$2.19