Compound Interest Calculator Resources
This page contains a comprehensive list of formulas for solving compound interest calculations. You can use these formulas to solve for principal, interest, rate, time, and total principal plus interest when doing calculations by hand, or when creating formulas to use in Excel or other spreadsheets. We include formulas for when compounding happens once per year, and also when compounding is continuous.
Compound Interest Reference Formulas
The compound interest formula A = P(1 + r/n)nt can be used to find any of the other variables. The tables below show the compound interest formula rewritten with the unknown variable on the left side of the equation.
Principal + Interest
Solve for P in terms of A
Solve for P in terms of I
Solve for I in terms of P
As a decimal
As a percent
Solve for t
ln is the natural logarithm
t = (ln(A) - ln(P)) / n(ln(1 + r/n))
(compounded once per period or unit t)
Principal + Interest
Solve for P in terms of A
Solve for P in terms of I
Solve for I in terms of P
As a decimal
As a percent
Solve for t
ln is the natural logarithm
t = (ln(A) - ln(P)) / ln(1 + r)
(n → ∞)
Principal + Interest
Solve for P in terms of A
Solve for P in terms of I
Solve for I in terms of P
As a decimal
ln is the natural logarithm
As a percent
Solve for t
ln is the natural logarithm
How to Derive A = Pert the Continuous Compound Interest Formula
A common definition of the constant e is that:
\[ e = \lim_{m \to \infty} \left(1 + \frac{1}{m}\right)^m \]With continuous compounding, the number of times compounding occurs per period approaches infinity or n → ∞. Then using our original equation to solve for A as n → ∞ we want to solve:
\[ A = P{(1+\frac{r}{n})}^{nt} \] \[ A = P \left( \lim_{n\rightarrow\infty} \left(1 + \frac{r}{n}\right)^{nt} \right) \]This equation looks a little like the equation for e. To make it look more similar so we can do a substitution we introduce a variable m such that m = n/r then we also have n = mr. Note that as n approaches infinity so does m.
Replacing n in our equation with mr and cancelling r in the numerator of r/n we get:
\[ A = P \left( \lim_{m\rightarrow\infty} \left(1 + \frac{1}{m}\right)^{mrt} \right) \]Rearranging the exponents we can write:
\[ A = P \left( \lim_{m\rightarrow\infty} \left(1 + \frac{1}{m}\right)^{m} \right)^{rt} \]Substituting in e from our definition above:
\[ A = P(e)^{rt} \]And finally you have your continuous compounding formula.
\[ A = Pe^{rt} \]Cite this content, page or calculator as:
Furey, Edward "Compound Interest Calculator Resources" at https://www.calculatorsoup.com/calculators/financial/compound-interest-calculator-resources.php from CalculatorSoup, https://www.calculatorsoup.com - Online Calculators