This video demontrates how to use the Future Value (FV) function to calculate the value of an investment (for example, retirement fund), after a specified number of payments over a specified time.
Please support this channel:
Free Excel templates
Recommended reading:
Microsoft 365 Excel: The Only App That Matters by Mike Girvin
My online courses:
10 Excel Hacks That Will Make You a Workplace Hero (FREE COURSE!)
Introduction to Microsoft Access
…(read more)
LEARN MORE ABOUT: Retirement Annuities
REVEALED: How To Invest During Inflation
HOW TO INVEST IN GOLD: Gold IRA Investing
HOW TO INVEST IN SILVER: Silver IRA Investing
Can you please do an example like this with an increase in annual contributions by a certain %?
Thank you, good man for the calculation explanation!
Shouldn’t the quarter end tracker use the assumed growth rather than above inflation? As you track you current value you portfolio number would not reflect the real return as inflation is assumed in this situation.
a good follow up for this video would be to calculate how long would the "future value" last after the retirement day given as certain amount one is expecting to draw from the investments and assuming a certain amount of years to live after retiring.
If i am not wrong it would be essentially making the current future vale as present value, payment as a positive number and number of payments as the lexpected lifetime after retirement.