Solve using excel (show work) What is the total future value of the following cash flows: a.) $10,000 invested today for 20 years at an annual rate of 4.7% b.) $25,000 invested for 6 years at 6% c.) $50,000 invested for 15 years at 2.8% d.) Which of the above is the best investment? Why?

    1

    Future treasure = exhibit treasure*(1+ rebuke)^time
    Future treasure = 10000*(1+0.047)^20
    Future treasure = 25057.26

    2.

    Future treasure = exhibit treasure*(1+ rebuke)^time
    Future treasure = 25000*(1+0.06)^6
    Future treasure = 35462.98

    3.

    Future treasure = exhibit treasure*(1+ rebuke)^time
    Future treasure = 50000*(1+0.028)^15
    Future treasure = 75660.07

    $25,000 invested restraint 6 years at 6% is best as it has highest interest rebuke