How this instrument works
Continuous compounding is the limit of ordinary compound interest as the number of compounding periods per year grows without bound. Split a year into two, twelve, or 365 pieces and each split hands back a slightly larger balance from the same nominal rate; keep splitting toward infinitely many, infinitesimally short periods and the growth factor stops moving — it settles on e^(rt), where e is the constant near 2.71828 that falls out of that limiting process. A = Pe^(rt) is that settled answer, not an approximation reaching toward it.
Retail banks never quote this rate. Savings accounts, CDs and mortgages post daily or monthly schedules because those match how a ledger actually records entries. Continuous compounding shows up instead in quantitative finance: the Black-Scholes options-pricing model discounts and grows values continuously because calculus on a smooth exponential curve is far simpler than calculus on a stair-stepped one, actuaries call the identical rate the force of interest when they price insurance reserves, and bond desks quote continuously compounded yields because those add cleanly across overlapping time periods in a way period-based yields do not. Someone modeling growth that compounds every instant, rather than on a statement date, reaches for this formula instead of the monthly one.
The instrument holds P, r and t fixed and returns one number; it says nothing about a rate that drifts mid-term, a deposit added partway through, or the tax the interest attracts once it is realized. It is also worth being honest about the size of the effect versus a real account: at ordinary rates, the continuous limit beats daily compounding by fractions of a cent per thousand dollars a year. The reason to reach for e^(rt) is mathematical convenience, not extra yield — a continuously compounded rate adds across time the way a monthly one cannot, which is why it survives in models that stack many periods together.
- Enter the starting sum in Principal, $ — a single amount, not a running total of deposits made over time.
- Type the annual rate in Annual rate, % as a whole number: 5 for five percent, not 0.05.
- Set Years to how long the money compounds, continuously, without a pause between periods.
- Read Final balance for A = Pe^(rt), computed exactly rather than approximated with a period count.
Worked example — $1,000 at 5% for 10 years
Set Principal, $ to 1000, Annual rate, % to 5, and Years to 10 — the defaults on this sheet. The exponent is r·t = 0.05 × 10 = 0.5, so the growth factor is e^0.5, which comes out to approximately 1.6487212707. Multiply that by the principal and Final balance reads $1,648.72, the exact value the instrument returns: A = 1000 × e^0.5 = 1648.7212707.
That figure sits just above what monthly compounding gives for the identical rate and term: about $1,647.01 for the same $1,000 at 5% over 10 years, a gap of roughly $1.71. Push the compounding frequency higher still — weekly, daily, hourly — and the monthly figure keeps climbing toward $1,648.72 without ever quite reaching it from below. Continuous compounding is the ceiling every finer schedule approaches but never overshoots.
Questions
What does continuous compounding actually mean?
It means the rate is applied at every instant rather than at fixed intervals like monthly or daily. Instead of adding interest in discrete steps, the balance grows smoothly along the curve A = Pe^(rt), with each infinitesimal moment contributing its share of growth immediately instead of waiting for a period to close.
Why does the formula use e instead of a period count?
Because e is what a period count converges to. Ordinary compound interest raises (1 + r/n) to the power n·t; as n grows toward infinitely many periods a year, that expression converges exactly to e^(rt), a result from calculus rather than a rounding trick. The constant e, near 2.71828, is simply the number that limit settles on.
Who actually uses continuous compounding?
Quantitative finance more than retail banking. The Black-Scholes options-pricing formula discounts continuously, actuaries price insurance reserves with what they call the force of interest, and bond desks quote continuously compounded yields because those combine cleanly across overlapping time periods. Consumer savings and loan products almost never compound this way.
How much more does continuous compounding earn than daily compounding?
Very little at realistic rates. On $1,000 at 5% for a year, both round to $1,051.27; carried to fractions of a cent, daily gives $1,051.2675 and continuous gives $1,051.2711 — about a third of a cent apart. The gap widens with rate and term, but for ordinary savings-account numbers it stays too small to matter; the formula earns its keep mathematically, not financially.
Should I use this to check my bank's advertised rate?
No — use a sheet with a compounding-frequency field set to your bank's actual schedule instead. Banks post interest daily or monthly, never continuously, so this instrument's answer runs a fraction of a cent ahead of any real statement. Treat A = Pe^(rt) as the theoretical ceiling those schedules approach, not a figure your bank will match to the cent.
Does the rate have to stay fixed for the whole term?
Yes, in this formula. A = Pe^(rt) assumes one constant rate applied across the whole span entered in Years; a rate that changes mid-term, a deposit added partway through, taxes on the interest, and account fees all sit outside the arithmetic and would need separate modeling or a sheet run in segments.
References
- SEC Investor.gov — Compound interest calculator
- NYU Stern School of Business (Damodaran) — corporate finance teaching notes
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.