Tutorials › VEE Accounting and Finance › Deriving the Level Loan Payment

VEE Accounting and Finance · Interest Rates and Loan Cash Flows · Tutorial 359 of 996

Deriving the Level Loan Payment

Learn to derive and apply the level-payment formula by equating a loan’s principal to the present value of its scheduled installments.

Intermediate 10 min read

What You'll Learn

  • State the assumptions required for the standard level-payment formula.
  • Derive the ordinary-annuity factor from the present values of individual installments.
  • Solve for a fixed installment using the rate per payment period and total number of payments.
  • Check a calculated payment by valuing its installments at the loan date.
  • Recognize errors involving payment timing, rate periods, and zero interest.

Why the Level Payment Has a Formula

A level-payment loan has the same scheduled installment at each payment date. The installment must cover the financing cost over time and repay the full principal by the final payment date. To find it, value all scheduled payments at the date the loan is issued and set that present value equal to the amount borrowed.

This is a present-value calculation for an ordinary annuity: payments occur at the end of each equal-length period. Earlier material on annuities supplies the valuation framework; here, the central task is deriving the installment from the loan principal. The result is valid only when the payment amount, payment interval, and interest rate per interval remain consistent throughout the term.

Definition: A fully amortizing level-payment loan is a loan of principal \(L\) repaid by \(n\) equal installments \(R\), with the final scheduled installment reducing the loan obligation to zero. For the standard formula, assume payments are made at the end of each period, the effective interest rate per payment period is a constant \(i\), and there are no fees, skipped payments, extra payments, or separate final payment.

The rate \(i\) in this formula is the rate for one payment period, not necessarily an annual rate. If there are monthly payments, use the effective monthly rate; if there are quarterly payments, use the effective quarterly rate. Rate conversion is required when the quoted rate and payment interval differ.

Deriving the Installment Formula

At the loan date, the first installment is one period away, the second is two periods away, and the final installment is \(n\) periods away. With a constant effective rate \(i\), a dollar due in \(k\) periods has present value \(v^k\), where \(v=1/(1+i)\). Thus the present value of the \(k\)-th installment is \(Rv^k\). Adding the values of all installments gives the principal:

$$ L=Rv+Rv^2+\cdots+Rv^n =R\sum_{k=1}^{n}v^k =R a_{\overline{n}|}. $$

The annuity-immediate factor is the sum of the discount factors for payments at the ends of periods 1 through \(n\). For \(i\ne 0\), the terms form a geometric series. Since \(v=1/(1+i)\), the finite geometric-series identity gives:

$$ a_{\overline{n}|} =\sum_{k=1}^{n}v^k =\frac{v(1-v^n)}{1-v} =\frac{1-v^n}{i} =\frac{1-(1+i)^{-n}}{i}. $$

For the third equality, \(1-v=i/(1+i)=iv\); therefore \(v/(1-v)=1/i\). Solving \(L=R a_{\overline{n}|}\) for \(R\) produces the level installment:

$$ \boxed{ R=\frac{L}{a_{\overline{n}|}} =\frac{Li}{1-(1+i)^{-n}} } $$

This derivation explains why the installment is the principal divided by an annuity factor: the factor measures the present value of one dollar paid at each scheduled date. Multiplying that factor by the installment gives the present value of the full payment stream.

Special case: If \(i=0\), the expression with \(i\) in the denominator is not used. Each installment has present value \(R\), so \(L=nR\) and \(R=L/n\). This is also the limit of the standard formula as \(i\) approaches zero.

Applying the Formula

A reliable calculation has four parts: identify the principal, identify the effective rate per payment period, count the payments, and use the ordinary-annuity formula only if the installments occur at period ends. Retain precision through the calculation and round the money amount only at the final step.

Worked Example: Monthly Installments on a Fixed-Rate Loan

A borrower receives a hypothetical loan of $24,000. The effective monthly interest rate is 0.5%, and the loan is repaid by 36 equal monthly installments at each month-end. Find the installment to the nearest cent.

Method and assumptions. This is a fully amortizing ordinary annuity with \(L=24{,}000\), \(i=0.005\) per month, and \(n=36\) monthly payments. There are no fees or other cash flows.

First calculate the annuity factor:

$$ a_{\overline{36}|} =\frac{1-(1.005)^{-36}}{0.005} \approx 32.8710. $$

Then divide the principal by that factor:

$$ R=\frac{24{,}000}{32.8710} \approx 730.13. $$

The monthly installment is $730.13, rounded to two decimal places. As a check, using the unrounded annuity factor and unrounded installment gives \(R a_{\overline{36}|}=24{,}000\), up to numerical precision. The result is also in a plausible range: 36 installments of $730.13 total about $26,284.68, exceeding the amount borrowed because the installments include interest.

Common mistake avoided. Dividing by a prematurely rounded annuity factor can shift the final cents. In particular, the factor is approximately 32.8710 and the resulting installment is approximately $730.13—not $730.23. Keep the factor unrounded until the final payment rounding.

Worked Example: Two End-of-Year Installments

A hypothetical firm borrows $28,800 at an effective annual rate of 25%. It will make two equal payments, each at the end of a year. Find the annual payment and verify that its present value equals the principal.

Method and assumptions. Payments are annual and made at year-end, so the effective annual rate is also the rate per payment period. Thus \(L=28{,}800\), \(i=0.25\), and \(n=2\).

The two discount factors are:

$$ v=\frac{1}{1.25}=0.8, \qquad v^2=0.8^2=0.64. $$

Therefore the annuity factor and payment are:

$$ a_{\overline{2}|}=0.8+0.64=1.44, \qquad R=\frac{28{,}800}{1.44}=20{,}000. $$

The required annual installment is $20,000. Check the valuation directly: the first payment has present value \(20{,}000(0.8)=16{,}000\), and the second has present value \(20{,}000(0.64)=12{,}800\). Their sum is \(16{,}000+12{,}800=28{,}800\), equal to the amount borrowed.

Common mistake avoided. The first payment is one year away, not at the loan date. Discounting it by \(v^0=1\) would treat the loan as receiving a payment immediately and would not match the stated year-end timing.

Worked Example: Monthly Rate and Twelve Monthly Payments

A hypothetical equipment loan has principal $12,000. The contract specifies an effective monthly rate of 1.00% and 12 equal month-end installments. Find the payment to the nearest cent.

Method and assumptions. The rate is already stated per payment period, so use \(i=0.01\), not an annual rate divided by 12. There are \(n=12\) payments, all at month-end, and no other cash flows.

Calculate the annuity factor using the monthly rate:

$$ a_{\overline{12}|} =\frac{1-(1.01)^{-12}}{0.01} \approx \frac{1-0.8874492}{0.01} \approx 11.2550775. $$

Now solve for the installment:

$$ R=\frac{12{,}000}{11.2550775} \approx 1{,}066.1855. $$

Rounded to two decimal places, the monthly payment is $1,066.19. As a valuation check, the unrounded installment multiplied by the unrounded factor is approximately \(1{,}066.1855(11.2550775)=12{,}000\). The small difference that may appear if $1,066.19 is used instead comes from rounding the installment to cents.

Common mistake avoided. Treating the stated 1.00% monthly rate as an annual rate and dividing it by 12 would apply a different rate. The rate and payment period must refer to the same interval.

Timing, Rates, and the Scope of the Result

The standard formula is compact, but its assumptions carry important meaning. The number \(n\) counts actual installments, not years unless there is exactly one payment per year. The \(i\) used in the formula is the effective rate from one installment date to the next. If a rate is quoted on another basis, convert it to the payment interval before calculating the annuity factor.

The formula also assumes payments are at period-end. If a problem says that a payment is made immediately when the loan is issued, its present value is not discounted by one full period. The ordinary-annuity equation above would then misstate the timing. Likewise, a loan with a changing rate, unequal installments, fees included in the financed amount, or a separate balloon payment is not described by this simple level-payment model without additional cash-flow terms.

The formula matters because it turns a loan’s principal, rate, and term into a single scheduled payment that can be compared with a budget or financing limit. But a calculated level installment does not by itself describe how much of each payment is interest versus principal. It establishes the payment amount from the loan-date present value; the payment-by-payment allocation is a separate calculation.

Key takeaway: For \(n\) equal end-of-period payments at constant effective rate \(i\) per period, equate principal to the present value of the payments: \(L=R a_{\overline{n}|}\). Then \(R=L/a_{\overline{n}|}\). Confirm the timing, rate period, and payment count before substituting values.

Check Your Understanding

For each problem, use the stated payment timing and rate basis. Answers are rounded to the nearest cent where applicable.

  1. A hypothetical interest-free loan of $15,000 is repaid by five equal annual payments at each year-end. Find each payment. (Answer: $3,000.00)
  2. A loan of $20,000 is repaid by two equal annual payments at each year-end. The effective annual interest rate is 10%. Find the payment. (Answer: $11,523.81)
  3. A hypothetical firm borrows $14,400 at an effective annual rate of 25% and makes two equal year-end payments. Find the payment and state the present-value factors for the two payments. (Answer: $10,000.00; factors 0.80 and 0.64)
  4. A $30,000 loan has an effective annual rate of 21% and is repaid by six equal semiannual payments at period-end over three years. Convert to the rate per half-year and find the payment. (Answer: 10.00% per half-year; $6,888.22)
  5. A loan of $4,521.55 is repaid by three equal annual payments, with the first payment at the end of year 2 and the remaining payments at the ends of years 3 and 4. The effective annual rate is 10%. Find the payment, treating each payment at its stated date. (Answer: $2,000.00)
Clinical Biostats