How the balance is calculated
APY (annual percentage yield) already includes compounding, so we convert it to the equivalent monthly rate. That way a lump sum grows by exactly the APY each year: $10,000 at 4% APY becomes $10,400 after 12 months.
i = (1 + APY)^(1/12) โ 1 FV = Dโ(1 + i)โฟ + M ร ((1 + i)โฟ โ 1) / i
Where Dโ is the initial deposit, M is the monthly deposit, n is the number of months and i is the monthly rate. Deposits are assumed to be made at the end of each month.
Worked example
You open an account with $5,000, add $250 at the end of every month and earn 4.5% APY for 3 years (36 months).
- Monthly rate: 1.045^(1/12) โ 1 โ 0.003675, or about 0.3675% a month.
- Growth factor over 36 months: 1.045ยณ โ 1.14117.
- Initial deposit: 5,000 ร 1.14117 โ $5,705.83.
- Monthly deposits: 250 ร (1.14117 โ 1) รท 0.003675 โ $9,603.64.
- Final balance: 5,705.83 + 9,603.64 โ $15,309.47. You deposited $14,000, so interest earned is about $1,309.47.
How $200 a month grows at different APYs
| APY | 1 year | 5 years | 10 years | 20 years |
|---|---|---|---|---|
| 1% | $2,411 | $12,298 | $25,224 | $53,087 |
| 3% | $2,433 | $12,916 | $27,890 | $65,371 |
| 4% | $2,444 | $13,236 | $29,339 | $72,768 |
| 5% | $2,455 | $13,563 | $30,873 | $81,161 |
Over one year the APY barely matters, because most of the balance is your own deposits. Over 20 years the gap between 1% and 5% is about $28,000 on the same $48,000 of deposits. The rate matters more the longer the money stays put.
Tips for using the result
- Run a lower rate too. Savings rates are variable, so test the APY you get today and a lower one to see a realistic range.
- Set a goal backwards. If you need $10,000 in two years, adjust the monthly deposit until the final balance reaches it.
- Compare like with like. Use APY for every account you compare, not a mix of APY and APR.
Things the calculator does not include
- Rate changes: savings rates are usually variable and can go up or down.
- Taxes on interest, which depend on where you live and your income.
- Account fees, withdrawals or balance caps on promotional rates.
- Inflation, which reduces what the final balance will buy.