Explore BrainMass

Explore BrainMass

    How Long to Double Your Money?

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    You deposit $1,000 in an account that pays 8% interest, compounded annually. How long will it take to double your money?

    Now I already know the answer is 9 years by using the rule of 72 however I am trying to find a formula in excel that proves this answer to be correct and I am coming up with nothing. I need help with the formula in excel for this.

    Thanks!

    © BrainMass Inc. brainmass.com March 4, 2021, 11:21 pm ad1c9bdddf
    https://brainmass.com/business/interest-rates/long-double-money-415898

    Solution Preview

    I would suggest using the NPER Function in Excel for this. The format is:

    =NPER(RATE, PMT, PV, FV, [TYPE]), where

    NPER = Number of compounding ...

    Solution Summary

    This solution discusses how to use Excel to find out how long it would take to double one's investment.

    $2.49

    ADVERTISEMENT