A Visual Look at the Time Value of Money

Compound interest is the eight wonder of the world – Albert Einstein

In Finance 101, you learn about the time value of money and the power of compounding.  Basically delaying instant gratification, in exchange for a greater return in the future. Many calculators online let you plug in variables and spit out a number for you.  Basically Einstein thought this was pretty cool stuff, and he was a smart dude with stylish hair.

I thought it would be useful to have something a little more interactive for people to play with.  Below, in Excel format, is  a future value interest factor of an annuity (FVIFA) calculator which also has a visual component to it.  Not only does it show the year by year figures plotted out, it visually shows the impact time can have on your money.

Basically you can plug in and play with a few variables.

Cell A2 is the interest rate.  I defaulted to 10% for an all stock portolio.

Cell D2 is the annual amount you save.  I default to $10,000 just as a nice round number.

For Age in Cell B2, I am basically assuming someone starts at age 25 working after finishing college.  A few things to notice when looking at the default variables.  After 4 years of investing, the return you’ve made on your investment is actually greater than 1 years worth of saving, pretty quick wasn’t it (cell G5).  Investing $10,000 and earning a 10% annual return would have you crossing the million dollar marker at the age of 49 or 25 years of investing (cell E26).  Something else to notice, this is based off saving $10,000 per year, that isn’t even maxing out your 401(k).  Looking at the chart, you see over time the blue section of the chart gradually becomes the smaller part of the bar.  Basically your principal is becoming less of a factor for you and your returns are making up the greater component of your future assets.  I often refer to this as my money working harder than I do.

Want to hit FI or retire early, change cell D2 to $18,500.  Suddenly, you’re hitting the 2 comma club after 19 years of investing.

Hope you find this useful to play around with.  Feel free to download the file to mess around with it.  Just remember, this is a calculator, you still have to actually take action on your part.


Follow me on the social medias:

Readers Comments (28)

  1. Hmm is anyone else having problems with the pictures
    on this blog loading? I’m trying to find out if its a problem on my end or
    if it’s the blog. Any suggestions would be greatly appreciated.

  2. I must thank you for the efforts you have put in penning this website.
    I really hope to check out the same high-grade content by
    you later on as well. In truth, your creative writing abilities has motivated me to get my
    own website now 😉

  3. Hi there, I discovered your site by means of Google whilst
    looking for a comparable topic, your web site
    got here up, it seems to be great. I’ve bookmarked it in my google bookmarks.

    Hello there, just turned into alert to your weblog via Google, and located that it is truly informative.

    I’m gonna be careful for brussels. I’ll appreciate if you proceed this in future.

    A lot of people will be benefited out of your writing.
    Cheers! http://antiibioticsland.com/Amoxil.htm

  4. You suggested it wonderfully! https://www.kamagramama.com kamagra how long to work Ykshh49

  5. I got this web page from my friend who informed me on the topic of this website and now this time I
    am visiting this website and reading very informative content at this place. https://cialis.lm360.us/tadalafil

  6. Wonderful facts. Appreciate it. where can i buy viagra without a script – how to recover from erectile dysfunction

  7. When someone writes an paragraph he/she maintains the thought of a user in his/her brain that how a
    user can know it. So that’s why this post is perfect.

  8. I blog quite often and I truly appreciate your information. The article has really peaked my interest.
    I am going to bookmark your blog and keep checking for new details about once per week.
    I opted in for your RSS feed as well. http://herreramedical.org/hydroxychloroquine

  9. online apotheke vardenafil – vardenafil price levitra online

  10. sildenafil price mexico – best price viagra uk viagra tablets online

  11. what is vardenafil used for – buy vardenafil us buy vardenafil online cheap

  12. female viagra canadian pharmacy – cheap sildenafil citrate uk viagra cost usa

  13. furosemide 40 for sale – lasix drug price cheap generic lasix

  14. pharmacy price comparison viagra – viagra brand canada where can i buy viagra pills over the counter

  15. furosemide without prescription – clomid tablets furosemide 20 mg tablet cost

  16. buy tadalafil pills – tadalafil citrate tadalafil generic

  17. order viagra from canadian pharmacy – brand viagra purchase female viagra online

  18. viagra San Jose – Generic viagra canadian viagra south africa

  19. generic ivermectin – ivermectin 6mg for humans for sale ivermectin 3 mg over counter

  20. http://www.lasixotc.com how do you coorect erectile dysfunction

Comments are closed.