Loan Term from Payment
Solve repayment duration from balance, rate and payment.
Your numbers
Modeled repayment time
Educational estimate using your entered assumptions; no live prices, tax rules or guaranteed returns.
Scenario comparison
Up to three snapshots in this tab. Loading one replaces the current inputs.
Formula
r=R/1200; r>0: n=−ln(1−Pr/A)/ln(1+r); r=0: n=P/A
Solve repayment duration from balance, rate and payment.
Worked example
- Loan balance
- 12000
- Monthly payment
- 1000
- Nominal annual rate (%)
- 0
- Modeled repayment time
- 12 months
- Number of payments, final payment may be smaller
- 12 payments
Scope and limitations
Educational estimate using your entered assumptions; no live prices, tax rules or guaranteed returns.
Inputs are checked for missing values and allowed ranges. A result outside the finite numeric range is not displayed. Rounding affects display, while the calculation uses the model’s numeric precision.
Check your units and assumptions before relying on a result. Changing a label does not convert a currency or physical unit.
Formula version: 6ec7a9de2a28 · Example checked: