The ‘FV’ function can come in handy here. FV is short for Future Value. On the Excel screen, it can be found using the command fx and under the category ‘Financial’.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Excel as a Comprehensive Financial Planning Tool Excel’s “What-If Analysis” tools, combined with the FV and PMT functions, provide a comprehensive solution for financial planning.

Unfortunately, if you're using Excel 2019 or earlier, you won't be able to create your own functions using the methods described in this guide.