If you want to know how to calculate compound interest monthly, the shortest answer is: convert your annual nominal rate to a monthly rate by dividing by 12, then use A = P × (1 + i)^m where i is that monthly rate and m is the number of months. For recurring deposits, you add a series term. I’ll walk through the manual math, clear up the n-versus-t confusion in the generic formula, and solve the exact “what is 6% compounded monthly” style questions people ask.
The Core Monthly Compounding Formula (and Why Most Variable Guides Confuse n and t)
Every compounding calculator spits out the same textbook equation: A = P(1 + r/n)^(nt). That formula is correct, but in my experience tutoring small-business owners, it’s where 90% of the confusion starts because r, n, and t are never tied to a calendar.
Here’s the plain-English translation I use when building models in Google Sheets:
- P (principal) – the starting lump sum today.
- r – the nominal annual interest rate as a decimal (6% = 0.06), not the APY.
- n – number of compounding periods per year. For monthly, n = 12.
- t – time in years. If you invest for 5 years, t = 5.
- A – the amount after compounding.
The thing nobody tells you about the textbook formula is that n and t are multipliers that simply produce the total number of compounding steps. When you compound monthly, you can skip n and t entirely and define i = r/12 and m = t×12. Then the cleaner, less error-prone version is A = P(1 + i)^m.
When I first tried to project a friend’s café savings account, I plugged r = 0.05, n = 1, t = 10 into the generic formula because I misread “n” as “years.” The result was off by nearly $800. The fix was recognizing that for monthly compounding, n is fixed at 12, and t stays in years only if you keep the original formula.
Rule of thumb: if you see “monthly compounding,” immediately rewrite the problem with i = annual rate ÷ 12 and m = months. Don’t juggle n and t unless a professor requires the textbook form.
For official terminology on effective rates, the Consumer Financial Protection Bureau distinguishes APY (effective annual yield) from the nominal rate that feeds the r variable above.
Step-by-Step Manual Calculation for a Lump Sum (No Calculator Needed)
Let’s calculate a $10,000 deposit at a nominal 6% compounded monthly for 5 years, by hand, to show the rhythm of the math.
Convert the annual rate to a monthly rate
Divide 0.06 by 12. You get i = 0.005 exactly. That’s $5 of interest per $1,000 of principal in the first month, before compounding.
Count the months
Five years × 12 = 60 months. So m = 60.
Apply the growth factor
Compute (1.005)^60. You can do this with a basic scientific calculator or by repeated multiplication. The factor comes out to approximately 1.34885.
Multiply by principal
$10,000 × 1.34885 = $13,488.50. Your compound interest earned is $3,488.50, not the $3,000 simple interest would give.
The most common mistake here is rounding i to 0.01 or 0.5% too early and then annualizing incorrectly. Keep at least 6 decimal places until the final step.
Now, to answer a question that shows up constantly: what is 6% compounded monthly? People usually mean “what effective annual return does a 6% nominal rate produce when compounded monthly?” The math is (1 + 0.06/12)^12 − 1 = 0.06168, or 6.168% APY. That extra 0.168% is the compounding tail you’d miss with simple interest.
What 12% compounded monthly looks like
Using the same logic, a nominal 12% rate divided by 12 gives i = 0.01. Over 12 months, (1.01)^12 − 1 = 0.12683, meaning 12% compounded monthly equals a 12.683% effective annual yield. If you ever compare a “12% APR” credit card to a “6% compounded monthly” savings account, the APY gap is larger than the headline numbers suggest.
Adding Recurring Monthly Contributions: The Part Calculators Hide
A lump sum is simple; real life is a paycheck depositing $200 every month. The formula for future value with end-of-month contributions is:
FV = P(1 + i)^m + PMT × [((1 + i)^m − 1) / i]
Where PMT is the monthly deposit. Notice the second term is a geometric series, not a single multiplier. Most online widgets hide this behind a button, but if you understand the series, you can audit any calculator output.
I learned this the hard way when building a client’s retirement plan in 2019. I used a tool that assumed contributions at the beginning of the month, which added an extra (1+i) factor. Over 30 years, that timing mismatch inflated the projection by $14,000. Always check whether your spreadsheet or calculator uses “begin” or “end” mode.
Converting a 5% APY to a monthly rate for deposits
APY is already effective, so you can’t just divide by 12. You must invert the compounding: i = (1 + APY)^(1/12) − 1. For 5% APY, i = 1.05^(1/12) − 1 ≈ 0.004074, or 0.4074% per month.
So what is 5% APY on $1000 monthly? If you mean a $1,000 starting balance earning 5% APY compounded monthly, the first month’s interest is $1,000 × 0.004074 = $4.07. If you mean depositing $1,000 every month at 5% APY, after 12 months the series factor [((1.004074)^12 −1)/0.004074] ≈ 12.272, so the contributions alone grow to about $12,272, plus the interest on earlier deposits. The exact first-year balance with a $1,000 initial and $1,000 monthly deposits would be roughly $13,329.
For a deeper dive on loan interest where only the principal balance accrues, see our Interest Only Loan Calculator to compare simple accrual versus compounding.
Converting Between Nominal Rates and APY (With Table)
Banks quote both. The nominal rate is what you divide by 12; the APY is what you actually earn after compounding. The conversion formula is APY = (1 + r/12)^12 − 1, and the reverse is r = 12 × [(1 + APY)^(1/12) − 1].
Below is a reference table I keep pinned in my workspace. It fills the gap left by calculator-only articles that never show the effective numbers side by side.
| Nominal Annual Rate | Monthly Rate (i) | Effective APY |
|---|---|---|
| 3% | 0.002500 | 3.042% |
| 5% | 0.004167 | 5.116% |
| 6% | 0.005000 | 6.168% |
| 8% | 0.006667 | 8.300% |
| 10% | 0.008333 | 10.471% |
| 12% | 0.010000 | 12.683% |
| 18% | 0.015000 | 19.562% |
Notice the spread widens as rates climb. At 18% nominal, monthly compounding pushes the effective cost to 19.56%. That’s why credit card statements feel heavier than the advertised APR.
One honest limitation: this table assumes 12 identical months and a 365-day year for the effective disclosure. Some institutional products use a 360-day basis, which slightly changes the effective yield. Always read the footnote in the offering document.
Using Google Sheets to Automate Monthly Compounding (With Template)
Manual math is great for understanding, but for ongoing projections you want a live model. I’ve built a free Google Sheets template that pairs with our Compound Interest Monthly Calculator; it lets you toggle contribution timing and see the month-by-month ledger.
Building the ledger from scratch
Open Sheets. In cell A1 type “Month”, B1 “Starting Balance”, C1 “Interest”, D1 “Deposit”, E1 “Ending Balance”. Row 2 is month 0: start with principal in B2, 0 interest, 0 deposit, ending = B2.
In row 3, set B3 = E2. C3 = B3 * $i$ (absolute reference to your monthly rate cell). D3 = your monthly deposit. E3 = B3 + C3 + D3. Drag down 360 rows for a 30-year plan. This reveals the curve: early months interest is tiny, later months interest dwarfs deposits.
Using the FV function as a check
Sheets has =FV(rate, nper, pmt, pv, type). For end-of-month deposits, type =FV(0.004074, 60, -200, -10000, 0). The result should match our manual series formula within a cent. If it doesn’t, you’ve mixed up sign conventions—pv and pmt should be negative because they are outflows from your pocket.
The thing most people don’t realize about spreadsheet compounding is that the FV function assumes constant periods. If your deposit schedule slips (e.g., a missed month), the formula silently overstates wealth. My template flags gaps with conditional formatting so you catch them.
Common Mistakes and Edge Cases I’ve Hit in Real Calculations
Even practitioners trip on edge cases. Here are four that have burned me or my clients:
- Day-count conventions: Daily compounding isn’t always 365. Some loans use 360. That changes the per-day rate from r/365 to r/360, a 1.4% higher accrual rate.
- Contribution timing: Beginning-of-month vs end-of-month shifts results by roughly one month’s interest on every deposit.
- Tax withholding: Compound interest in a taxable account is reduced by taxes each year; ignoring this overstates real growth by the tax rate applied to gains.
- Rate changes: A CD may compound monthly but reset the rate after 12 months. You must chain two separate (1+i)^m blocks; you cannot average the rates.
When I audited a nonprofit’s reserve fund, they had used a single 4% average for a ladder that actually paid 3% then 5%. The chained calculation showed $2,100 less after three years—material for their budgeting.
If the math feels too clean, check the assumptions. Compounding is precise, but the inputs are where models lie.
Worked Examples Solving the Questions People Actually Ask
Search engines surface specific scenarios. Rather than a detached FAQ, I’ll solve them inside the narrative so you see the mechanics.
What is 6% compounded monthly?
As shown earlier, nominal 6% becomes 6.168% APY. If you put $5,000 in for 1 year, the ending balance is $5,000 × (1.005)^12 = $5,308.39. Interest = $308.39, not $300. That $8.39 is the compounding premium.
What is 5% APY on $1000 monthly?
We covered the $4.07 first-month interest on a static $1,000. If the question means “I deposit $1,000 each month at 5% APY,” after 1 year the balance is about $12,272 from deposits plus $74 from interest on the early deposits, total ~$12,346 if starting from zero. The exact figure depends on beginning vs end timing; end-of-month yields slightly less.
How much interest would $1,000,000 earn at 5% compounded daily in one day?
This is a great test of rate conversion. If the 5% is a nominal daily-compounded rate, the daily rate is 0.05 ÷ 365 = 0.000136986. Multiply by $1,000,000 gives $136.99 for that single day. If instead 5% is the APY and compounding is daily, the daily rate is (1.05)^(1/365) − 1 ≈ 0.0001347, yielding $134.70. The difference is small per day but compounds to thousands over a year. Most banks quoting “5% compounded daily” mean nominal, so $136.99 is the safe answer.
What is 12% compounded monthly?
Nominal 12% becomes 12.683% APY. On $1,000 for one month, interest is $10. Over a year, $1,000 grows to $1,126.83. If you carry a loan at that rate, the effective cost is higher than the sticker.
When to Use Manual Calculation vs. a Calculator
Manual calculation by hand or with a simple ledger is best when you need to explain the result to a stakeholder or debug a model. It forces you to confront the i and m variables directly. Calculator widgets and Sheets are best for iteration, sensitivity analysis, and long horizons where 360 manual multiplications are impractical.
My recommendation: do one full manual lump-sum and one manual contribution example per year on any account you care about. Then use the Compound Interest Monthly Calculator for daily monitoring. That hybrid approach caught a 0.25% rate mismatch on my own mortgage escrow that a pure calculator habit had hidden.
The trade-off is time. Manual math takes 10 minutes; a spreadsheet takes 30 to set up but pays back over decades. Neither is a silver bullet—both require clean inputs.
A Plain-English Variable Glossary to Keep Handy
To close the instructional gap, here is the glossary I print for workshop attendees:
- Principal (P) – today’s money, before any interest.
- Nominal rate (r) – the advertised annual rate, unadjusted for compounding frequency.
- Compounding frequency (n) – how many times per year interest is added. Monthly = 12.
- Time (t) – years only in the generic formula; convert to months (m) for the simplified version.
- Monthly rate (i) – r ÷ 12, or (1+APY)^(1/12)−1 if starting from APY.
- Periods (m) – total months = years × 12.
- APY – the effective annual yield after compounding, required by Truth-in-Savings disclosures.
- PMT – recurring deposit or withdrawal per period.
Keep this list next to your worksheet. In my experience, half of all “calculator errors” are just someone using r where i was needed, or t where m was needed.
Final Takeaways for Monthly Compound Interest Mastery
You now have the simplified formula, the manual steps, the contribution series, the APY conversion table, and a spreadsheet blueprint. The next time someone asks how to calculate compound interest monthly, you can show them the month-by-month ledger instead of pointing at a widget.
Remember the practitioner’s mantra: convert to monthly, count the months, apply the factor, then add the series if money moves. Do that and the PAA questions—6%, 12%, 5% APY, even $1M daily—become routine arithmetic rather than mysteries.