Finding the Loan Term From the Payment

Why the Loan Term Can Be Solved From the Payment

A loan’s term is often given as part of the contract, but it can also be inferred from the amount borrowed, the interest rate, and the level payment. This is useful when comparing a quoted payment with a proposed borrowing amount or checking whether a payment schedule can eventually repay a debt. The key is to measure the rate and the term in the same payment periods.

The equation gives a real-valued term. If that value is not an integer, it does not mean that a lender collects a fraction of a scheduled payment period. Instead, it indicates that the loan can be repaid with several full level payments and a smaller final payment at the next payment date.

Definition: Consider a loan with principal $L$, a positive effective interest rate $i$ per payment period, and level payments $R$ made at the end of each period. The theoretical term is the real number $n$ satisfying $L=R a_{\overline{n}|}$, where $a_{\overline{n}|}=(1-v^n)/i$ and $v=1/(1+i)$. The actual schedule ordinarily uses whole payment periods; if $n$ is not an integer, the last payment is adjusted.

This model assumes a fixed rate per payment period, end-of-period payments, no fees or additional borrowing, and no rounding of scheduled payments during the calculation. The principal and payment must use the same currency units. The formula below assumes $i>0$; the zero-interest case requires a separate equation.

Deriving the Term Formula

At the loan date, the principal must equal the present value of the payments. For $n$ level payments of $R$, each made at the end of a period, the present value is $R a_{\overline{n}|}$. Thus,

L=R\frac{1-v^n}{i}

To isolate $n$, multiply by $i/R$, then rearrange:

\frac{iL}{R}=1-v^n \qquad\Longrightarrow\qquad v^n=1-\frac{iL}{R}

Since $v=1/(1+i)$, taking natural logarithms gives $n\ln(v)=-\ln(1-iL/R)$. Also, $\ln(v)=-\ln(1+i)$. Therefore:

n=\frac{-\ln\left(1-\dfrac{iL}{R}\right)}{\ln(1+i)}

For this expression to give a finite positive term, $R$ must exceed the interest due on the initial balance, $iL$. If $R=iL$, the first payment exactly covers the interest and the balance stays level, so the loan is not repaid. If $R<iL$, the first payment is less than the interest and the balance grows. In either case, there is no finite amortization term under the stated level-payment model.

Theorem: For a positive rate per payment period and level end-of-period payments, a finite amortization term exists exactly when $R>iL$. In that case, $n=-\ln(1-iL/R)/\ln(1+i)$. If $n$ is an integer, the level payments repay the loan at that payment date. If $n$ is not an integer, the schedule has $\lfloor n\rfloor$ full level payments followed by a smaller final payment at payment date $\lceil n\rceil$, assuming the schedule is not rounded along the way.

The condition $R>iL$ is a useful check before taking logarithms. It also gives a practical interpretation: at the start of the loan, the payment must exceed the first period’s interest charge for any principal to be repaid. When $R$ is only slightly greater than $iL$, the principal falls slowly and the resulting term can be very long.

Match the periods.
Use the effective rate per payment period and express the term in payment periods.

Check the first payment.
Compute $iL$. A finite term requires $R>iL$.

Solve for the theoretical term.
Substitute $L$, $R$, and $i$ into the logarithm formula, retaining precision during the calculation.

Interpret the result.
If the term is noninteger, count the full scheduled payments and recognize that the next payment is a smaller final payoff.

Worked Examples

Worked Example: Four Full Payments and a Smaller Final Payment

A borrower receives $L=\$8{,}000$. The loan charges an effective annual rate of $i=0.04$, and the borrower makes annual payments of $R=\$2{,}000$ at each year-end. Find the theoretical term and determine the actual number of full payments. Then calculate the final payoff at the fifth payment date. Assume no payment rounding until the final answer.

Method and feasibility check. The first year’s interest is $iL=0.04(\$8{,}000)=\$320$, which is less than the payment of $\$2{,}000$. A finite term is possible.

Substitute into the term formula. The ratio inside the logarithm is $1-iL/R=1-(0.04)(8{,}000)/2{,}000=0.84$. Thus:

n=\frac{-\ln(0.84)}{\ln(1.04)} =\frac{0.1743533871}{0.0392207132} \approx 4.4454415\text{ years}

There are four full annual payments, followed by a smaller payoff at the fifth year-end. To calculate it, first find the balance immediately after four $\$2{,}000$ payments. The balance recurrence, applied four times, gives $B_4=L(1+i)^4-Rs_{\overline{4}|}$. Here, $(1.04)^4=1.16985856$ and $s_{\overline{4}|}=((1.04)^4-1)/0.04=4.246464$. Therefore:

B_4 =8{,}000(1.16985856)-2{,}000(4.246464) =9{,}358.86848-8{,}492.928 =\$865.94048

One more year of interest accrues before the fifth payment date. The exact payoff then is $B_4(1.04)=\$865.94048(1.04)=\$900.5780992$, or $\$900.58$ to the nearest cent. The full payments total $\$8{,}000$, and the smaller fifth payment clears the remaining balance. The term formula’s noninteger result is therefore consistent with the actual payment schedule.

Common mistake avoided: Treating $4.4454415$ as four payments plus a payment equal to $0.4454415R$ is incorrect. Payments occur on the annual dates; the fifth payment is the outstanding balance with one more year of interest, not a fraction of the scheduled payment.

Worked Example: A Monthly Loan With a Long Noninteger Term

A hypothetical lender advances $\$15{,}000$ at an effective monthly rate of $0.75\%$. The borrower will pay $\$180$ at the end of each month. Find the theoretical term in months and interpret it as a payment schedule. Assume exact, unrounded payments until the final payment.

Method and feasibility check. The rate and payment are both monthly. The first month’s interest is $(0.0075)(\$15{,}000)=\$112.50$, so the $\$180$ payment exceeds the interest by $\$67.50$. The loan can amortize.

The term formula’s logarithm argument is $1-iL/R=1-(0.0075)(15{,}000)/180=1-112.5/180=0.375$. Using $-\ln(0.375)=0.980829253$ and $\ln(1.0075)=0.0074720148$:

n=\frac{-\ln(0.375)}{\ln(1.0075)} =\frac{0.980829253}{0.0074720148} \approx 131.26704\text{ months}

There are 131 full monthly payments of $\$180$, followed by a smaller payoff at the 132nd payment date. The calculation gives a term in months, not years; converting the result to years is unnecessary for interpreting the monthly schedule. The theoretical term is not rounded to 131 months, because doing so would imply that the loan is exactly repaid by 131 full payments.

Common mistake avoided: Applying an annual rate to a monthly payment would make the rate and term periods inconsistent. Here the stated effective monthly rate is used directly, so the logarithm denominator is $\ln(1.0075)$.

Worked Example: Distinguishing Amortization From an Interest-Only Payment

A borrower owes $\$5{,}000$ at an effective rate of $1\%$ per payment period. First consider a payment of $\$50$. Then suppose the payment is increased to $\$60$. Determine what happens in each case and, for the $\$60$ payment, find the theoretical term.

Method and feasibility check. The interest due on the initial balance is $iL=(0.01)(\$5{,}000)=\$50$. With a $\$50$ payment, the entire payment covers interest, leaving the balance at $\$5{,}000$. There is no finite term. With a $\$60$ payment, $R>iL$, so a finite term exists.

For the $\$60$ payment, $iL/R=50/60=5/6$, so $1-iL/R=1/6$. The term is:

n=\frac{-\ln(1/6)}{\ln(1.01)} =\frac{\ln(6)}{\ln(1.01)} =\frac{1.791759469}{0.0099503309} \approx 180.0703\text{ periods}

The $\$60$ schedule therefore has 180 full payments and a smaller final payoff at the 181st payment date. The distinction is important: the $\$50$ payment maintains the balance, while the $\$60$ payment reduces it.

Common mistake avoided: A payment equal to the first period’s interest does not gradually repay the principal. Here, both are exactly $\$50$, so the balance remains level—not growing and not declining.

Common Mistakes and Practical Checks

Solving for the term requires attention to both the algebra and the payment convention. The following checks catch frequent errors:

Using the wrong rate period. If payments are monthly, use the effective rate per month. The term returned by the formula is in those same periods.
Skipping the feasibility check. Confirm $R>iL$ before evaluating the logarithm. At equality the balance remains level; below the threshold it grows.
Rounding the term to get a payment count. Keep the theoretical term unrounded until the calculation is complete. For a noninteger term, the number of full payments is its integer part, and the final payment occurs at the next payment date.
Assuming the final payment equals the scheduled payment. A fractional term generally indicates that the scheduled payment would exceed the remaining balance at the final payment date. The final payoff is therefore smaller.
Mixing payment timing conventions. The equation here assumes payments at the end of each period. It does not apply unchanged to payments made at the beginning of periods.

The term calculation is also a useful reasonableness check. A payment barely above the interest charge should produce a long term; a substantially larger payment should produce a shorter one. If the calculated result contradicts that direction, recheck the rate period, the principal, and the logarithm argument.

Key takeaway: For a fixed positive rate per payment period and level end-of-period payments, first check $R>iL$, then solve $n=-\ln(1-iL/R)/\ln(1+i)$. A noninteger $n$ describes a schedule of $\lfloor n\rfloor$ full payments followed by a smaller final payoff at the next payment date.

Check Your Understanding

For each problem, use the rate per payment period and distinguish the theoretical term from the number of full scheduled payments.

A loan of $\$6{,}000$ charges an effective annual rate of $5\%$ and requires annual end-of-year payments of $\$900$. Find the theoretical term and state how many full payments precede the final payoff. (Answer: $8.310$ years; 8 full payments, then a smaller ninth payment.)
A balance of $\$15{,}000$ accrues interest at $0.75\%$ per month. Monthly end-of-month payments are $\$180$. Find the theoretical term in months and interpret it. (Answer: $131.267$ months; 131 full payments, then a smaller 132nd payment.)
A loan has an initial balance of $\$10{,}000$, a rate of $1\%$ per payment period, and a level payment of $\$100$ per period. Does it amortize? State what happens to the balance after the first payment. (Answer: It does not amortize; the $\$100$ payment equals the $\$100$ interest charge, so the balance remains $\$10{,}000$.)
A borrower receives $\$24{,}000$ at an effective rate of $2\%$ per payment period and pays $\$600$ at each period-end. Find the theoretical term and the number of full payments before the final payoff. (Answer: $81.274$ periods; 81 full payments, then a smaller 82nd payment.)
A loan of $\$12{,}000$ accrues interest at $1\%$ per month. The borrower proposes a monthly payment of $\$120$. Determine whether the loan has a finite amortization term and explain why. (Answer: No finite term; the first month’s interest is $\$120$, equal to the payment, so the balance remains level.)

What You'll Learn