Explore BrainMass

Explore BrainMass

    How do you calculate the annuity due using Excel?

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

    Terry Austin is 30 years old and is saving for her retirement. She is planning on making 36 contributions to her retirement account at the beginning of each of the next 36 years. The first contribution will be made today (t = 0) and the final contribution will be made 35 years from today (t = 35). The retirement account will earn a return of 10 percent a year. If each contribution she makes is $3,000, how much will be in the retirement account 35 years from now (t = 35)?
    Use Excel.

    © BrainMass Inc. brainmass.com June 3, 2020, 7:18 pm ad1c9bdddf
    https://brainmass.com/business/the-time-value-of-money/calculate-annuity-due-excel-92752

    Solution Preview

    Please see attached file
    Terry Austin is 30 years old and is saving for her retirement.  She is planning on making 36 contributions to her retirement account at the beginning of each of the next 36 years.  The first contribution will be made today (t = 0) and the final contribution will be made 35 years from today (t = 35).  The retirement ...

    Solution Summary

    The solution shows how to calculate the future value of an annuity due in Excel.

    $2.19

    ADVERTISEMENT