The basic math: what you need to know
Future value is the amount of money you will have in your savings account at a specific date in the future. To calculate it, you need three pieces of information: how much you have now, how much interest the bank pays you, and how long you leave the money there.
The simplest version works like this: if you put $1,000 in an account that pays 4% interest per year, and you leave it untouched for one year, you will have $1,040. The bank paid you $40 in interest. That $40 is your earnings — money the bank gave you for letting them use your money.
Most savings accounts pay compound interest, which means the bank pays interest not just on your original deposit, but also on the interest you already earned. This makes your money grow faster than straightforward math suggests. Understanding how compound interest works is the key to predicting what your account will actually hold.
Key Takeaways
- Future value depends on three things: your starting balance, the interest rate your bank pays, and how long the money stays in the account.
- Compound interest means you earn interest on your interest, which makes your balance grow faster than it would with straightforward interest alone.
- You can calculate future value using a formula, a spreadsheet, or an online calculator — all three give the same answer.
- The longer your money sits in the account and the higher the interest rate, the more your balance will grow.
- Interest rates change over time, so a rate your bank offers today may be different next month or next year.
The formula for compound interest
The standard formula for future value with compound interest is:
FV = PV × (1 + r)^n
Here is what each letter means:
- FV = Future Value (the amount you will have)
- PV = Present Value (the amount you have now)
- r = Interest rate per period (usually per year, written as a decimal)
- n = Number of periods (usually years)
Let's use a real example. You deposit $5,000 in a savings account that pays 3.5% interest per year. You plan to leave it there for 5 years without adding or withdrawing money. First, convert the interest rate to a decimal: 3.5% becomes 0.035. Then plug the numbers in:
FV = $5,000 × (1 + 0.035)^5 FV = $5,000 × (1.035)^5 FV = $5,000 × 1.1877 FV = $5,938.50
After 5 years, your $5,000 will grow to $5,938.50. You earned $938.50 in interest. The longer you leave money in the account, the larger that number becomes — that is compound interest at work.
Using a spreadsheet to calculate future value
If math formulas feel uncomfortable, a spreadsheet does the work for you. Both Microsoft Excel and Google Sheets have a built-in function called FV that calculates future value automatically.
In Google Sheets, the formula looks like this:
=FV(rate, nper, pmt, pv)
For the same example above ($5,000 at 3.5% for 5 years), you would type:
=FV(0.035, 5, 0, -5000)
The spreadsheet returns 5938.50. The negative sign in front of 5000 tells the spreadsheet that money is leaving your pocket (your deposit). The zero in the middle means you are not adding money each month — you are just letting the original amount sit.
If you add money regularly — say, $100 every month — you would replace the zero with -100, and the spreadsheet would calculate how much you will have when you combine your monthly deposits with the compound interest. This is useful for planning how much you can save over time.
What happens when interest compounds more than once a year
Most savings accounts compound interest monthly or daily, not just once a year. This means the bank calculates and adds interest to your account 12 times a year (or 365 times a year) instead of once. More frequent compounding means your money grows slightly faster.
When compounding happens more than once a year, the formula changes slightly:
FV = PV × (1 + r/m)^(n×m)
The new letter m represents how many times per year interest compounds. For monthly compounding, m = 12. For daily compounding, m = 365.
Using the same $5,000 example, but with monthly compounding at 3.5% for 5 years:
FV = $5,000 × (1 + 0.035/12)^(5×12) FV = $5,000 × (1.002917)^60 FV = $5,000 × 1.1907 FV = $5,953.50
With monthly compounding, you end up with $5,953.50 instead of $5,938.50 — an extra $15. That difference grows larger the longer your money sits in the account. Daily compounding would give you slightly more still, but the difference is usually small for savings accounts.
How interest rates affect your future balance
The interest rate your bank pays makes a huge difference in how much your money grows. Even a difference of 1% per year adds up significantly over time.
Compare two scenarios: $10,000 in an account for 10 years. In the first, the bank pays 2% per year. In the second, the bank pays 3% per year.
- At 2%: $10,000 grows to $12,190
- At 3%: $10,000 grows to $13,439
That 1% difference in rate results in $1,249 more in your account. This is why it matters to compare interest rates when you are choosing a savings account. A bank offering 4.5% will grow your money much faster than one offering 2%, even though both are legitimate savings accounts.
Interest rates change frequently — sometimes weekly. When you calculate future value, use the rate your bank is currently offering, but understand that the actual rate you earn may be different if the bank changes its rate during your savings period. Most savings accounts do not lock in a rate; the bank can lower it at any time.
The impact of time on your savings
Time is one of the most powerful tools in saving. The longer your money stays in the account, the more compound interest has a chance to work. This is sometimes called the "snowball effect" — your interest earns interest, which earns more interest, and so on.
Here is how $5,000 grows at 3.5% interest over different time periods:
| Years | Future Value | Interest Earned |
|---|---|---|
| 1 year | $5,175 | $175 |
| 5 years | $5,939 | $939 |
| 10 years | $7,070 | $2,070 |
| 20 years | $9,974 | $4,974 |
Notice that the interest you earn in the second 10 years ($2,070 from year 10 to year 20) is more than double what you earned in the first 10 years. That is compound interest accelerating. The longer you leave money untouched, the more powerful this effect becomes.
Frequently Asked Questions
What if I add money to my savings account each month?
The formula becomes more complex because each deposit earns interest for a different length of time. A spreadsheet is the easiest tool — use the FV function and replace the zero with your monthly deposit amount (as a negative number). The spreadsheet will calculate the total including both your deposits and the compound interest on all of them.
How do I know what interest rate to use for my calculation?
Check your bank's website or your account statement for the current Annual Percentage Yield (APY). This is the actual rate you earn when compounding is included. Do not use the Annual Percentage Rate (APR) — that is different and used for loans, not savings.
Will my actual balance match my calculation?
It should be very close, but not exact. Banks may round interest, change rates during your savings period, or charge fees that reduce your balance. Your calculation shows what will happen if the rate stays the same and you make no withdrawals — real life may vary slightly.
Does it matter if I use a calculator or do the math by hand?
No. A calculator, spreadsheet, and the formula all give the same answer. Use whichever method feels most comfortable to you. Online future value calculators exist if you want to avoid typing the formula yourself.
What if the interest rate changes during my savings period?
You would need to calculate in sections. Calculate the future value for the period when the first rate applied, then use that result as the starting amount for the next period with the new rate. Most people estimate using the current rate as a rough guide, understanding that the actual result may differ.