Whether you are estimating future living costs or wondering what your savings will be worth on retiring, you need a quick & easy way to translate today’s money into future dollars. As prices rise over the years, the value of money changes. A future amount may look larger, yet buy far less than expected. This is where many calculations fall short—they show growth, but not purchasing power.
WordLayouts’ PV to FV calculator not only calculates the future value of your money but also then adjusts that figure for inflation to reveal what the money will actually be worth in today’s terms.
So, if you are planning savings, estimating future costs, or setting long-term financial goals, this calculator helps you see beyond the compounding interest rates and plan realistically for your financial goals.
PV to FV Calculator: What We Offer
This calculator is a simple Excel sheet programmed to convert current figures into future values, adjusted for inflation. You can run a PV-to-FV calculation for any financial figure, including home expenses, outstanding debt balances, and income. savings, investments, or long-term goals like major purchases and retirement targets.
How to Use this PV to FV Calculator
This calculator uses a 2-step method to estimate the real Future Value of any amount you have invested. But before we dive into the math, let’s unpack what we mean by ‘real’.
When you talk about the future value of money, it’s not just about an increase in the monetary figure on paper; it’s about the expected loss or fall in purchasing power associated with money over time.
Let’s say you have $100 today, enough to buy a full tank of gas. Now fast-forward 20 years. Let’s say your money grows and you now have $180. Sounds great… but here’s the catch: gas prices have also gone up because of inflation. So even though you have more dollars, your money doesn’t buy more stuff.
That’s the difference between:
- Nominal value → the raw dollar amount ($180)
- Real value → what that money can actually buy
Now, let’s see how this sheet calculates these two future values for you.
Step 1: Add Your Data
This calculator relies on three different types of information from you: Present value, years from now, and the interest rate on your savings account. Let us look at these in detail:
Present value
Enter any dollar sum you plan to invest and whose value you want to see in the future. This could be the savings or investment account balance or the market value of a piece of property, etc.
Some examples of what can be added here:
- Savings account: Money you deposit today to earn interest.
- Bonds: The amount you pay now to buy a bond that will pay you in the future.
- Stocks or mutual funds: Money you invest today that you expect to grow over time.
- Certificates of Deposit (CDs): The amount you deposit today for a fixed term.
- Retirement fund contributions: Your current deposit to grow into a larger future value.
Just like PV tells you how much to invest today to reach a future goal, it can tell you how much to pay now to cover money you owe in the future. So if you have a debt or mortgage, you can put that value in the PV cell to calculate what it will actually be worth in the future.
Years from now
Enter how many years you want your investment to grow. Most retirement plans or investment schemes are designed with a long-term investment in mind, often spanning several decades.
In this cell of the calculator, simply add the number of years the amount has been invested for, such as 10 years, 25 years, etc.
Interest or growth rate
Enter the expected annual interest or price growth rate as a whole number. Do NOT include the % symbol—Excel will format it automatically.
In simple terms, this is the rate you expect the Present Value to increase by each year. For example, if your present value is the money you have in a savings account, you must enter the annual interest rate the bank is offering to compound your savings.
If you are projecting an outstanding debt, this will be the Annual Percentage Rate your lender charges you as the cost of borrowing.
Regardless of whether you are projecting savings or debts, the calculator uses this fixed annual rate to grow today’s value (PV) into its future cost (FV). Keep in mind that your Present Value is projected over the total number of years selected by the user in D9.
Future value or cost
After you have provided the above data, the PV to FV calculator calculates your money’s worth in the future.
Generally speaking, the higher the number of years you enter, the higher the Future Value, as the effects of compounding have more time to accumulate. Similarly, the higher the interest or growth rate, the greater the FV, since each year’s growth builds on the last.
Keep in mind that even small differences in the growth rate or time horizon can lead to meaningful changes in the final outcome due to the compounding effect.
For loans with daily compounding interest, try our Daily Compounding Loan Calculator to stay on top of how interest builds over time.
Step 2: Real Value Calculator
While most calculators stop at projecting the FV of your investments, this FV calculator goes a step further. Besides showing you the growth in interest, the calculator also helps you see the “real” value of your money by incorporating the effects of inflation.
Inflation rate
Enter the current inflation rate in your country.
In the United States, inflation is measured using the Consumer Price Index (CPI). Published every month by the Bureau of Labor Statistics, CPI tracks the cost of goods and services over time.
But first, let’s take a step back and ask ourselves…
What is inflation?
Inflation is the general increase in the prices of goods and services and a corresponding fall in the purchasing power of money over time.
What You Need To Do: In D12, specify the current inflation rate as it applies to you. Make sure your chosen percentage reflects an increase in prices over 12 months (annual). The ideal inflation rate is around 2-3% to ensure maximum employment and price stability, and is maintained through a combination of fiscal and monetary policy.
Real future value
Based on this inflation rate, as well as the nominal Future Value project in D11, the sheet calculates the real Future Value to show what your present investment (or debt) will be truly worth in the future in terms of purchasing power.
In reality, this is the figure you should place more weight on when planning for the future. Effective future planning is about what your money can buy—not just the size of the account balance. If your savings or investments fail to grow faster than inflation, your purchasing power is gradually eroding.
Quick Visual Aid
For enhanced visibility, we have also included a graph to show meaningful data at a glance. This simple pie chart shows Present Value against Real Future Value, so you can instantly see how much of the total value comes from your original amount versus growth over time. The chart dynamically responds to changes in all variables from the input table.
Personalize your chart view
Use basic Excel features to change colors, reposition the chart, or adjust other formatting elements as needed to match your preferences.
Disclaimer
This calculator is made for illustrative and educational purposes only and should only be used for planning and comparative estimates, not treated as professional advice. For that, you should consult a financial professional, such as an investment advisor, banking expert, financial planner, or other qualified professional.
Our figures do NOT promise accurate financial predictions of future performance for several reasons:
- Inflation rates are hardly constant for long durations. Because actual inflation can often vary significantly from year to year, real outcomes may be higher or lower than shown.
- Growth rates on investments or savings are not constant in real life.
- Lenders may charge penalties or set a higher APR, which can increase your debt balance faster than expected.
- We do not account for taxes, management fees, or other costs that may reduce actual returns in this FV calculator.
Related Templates
Note for Excel Beginners
Spreadsheets are fragile. Even if the file is error-free when you download it, it’s always possible to introduce mistakes later. If you need help fixing a broken formula, see Microsoft’s guide on “How to avoid broken formulas in Excel.”
New here?
WordLayouts is a free web resource for premium financial tools designed to help you put your finances in order. Whether you are preparing for retirement, saving for college, or managing the daily cost of running a home, we offer simple but effective Excel-based solutions to help you manage your finances. Explore our versatile suite of calculators and trackers, built for the US market, to help you manage your finances.
