Final Payments, Rounding, and Schedule Reconciliation

Why a Final Payment May Differ

A level-payment loan is often calculated using a payment with more than two decimal places, while actual installments are stated in cents. If the scheduled payment is rounded, the amount paid over the loan’s term may not exactly equal the amount required to repay principal and interest. A small balance can therefore remain—or the scheduled payment can be slightly more than is needed for the last installment.

There is a second source of difference: a lender’s schedule may round periodic interest to cents at every step, or it may carry fractional cents internally and round only cash payments. These conventions can produce different ending balances. A schedule is reconciled only when the final payment agrees with the balance calculated under the convention actually being used.

Definition: Let $B_k$ denote the outstanding loan balance immediately after the payment at the end of period $k$. Let $i$ be the effective interest rate per payment period, $n$ the number of periods, and $R$ the regular end-of-period installment. A adjusted final payment is the amount required at the final payment date to clear the balance after interest for that period has accrued. It need not equal $R$.

The formulas below assume payments occur at the end of each period, interest accrues at a constant effective rate per period, and there are no fees, missed payments, or extra principal payments. If the contract specifies a different interest-rounding rule, that rule governs the ledger calculation.

Balance Recurrence and Rounding Rules

With no rounding during the schedule, the balance recurrence is $B_k=(1+i)B_{k-1}-R$, with $B_0=L$, where $L$ is the original loan principal. If interest is rounded to cents each period, first calculate that period’s interest, round it, and then update the balance. In the examples, rounding to cents means rounding to the nearest cent, with half-cent amounts rounded up.

\begin{aligned} \text{Unrounded interest:}\qquad &B_k=(1+i)B_{k-1}-R,\\ \text{Interest rounded to cents:}\qquad &I_k=\operatorname{round}_{0.01}(iB_{k-1}),\\ &B_k=B_{k-1}+I_k-R. \end{aligned}

Here $I_k$ is the interest charged for period $k$. The first recurrence carries any fractional cent in the balance calculation. The second rounds interest before adding it to the balance. Do not mix the two methods within one schedule unless the contract or stated procedure requires it.

If $B_{n-1}$ is the balance after the penultimate payment, the amount due at the final date is the balance plus the final period’s interest. With rounded interest, use the rounded interest for that period; with unrounded interest, use $iB_{n-1}$ and round the cash amount as required.

\text{Final amount due} = B_{n-1}+\text{interest accrued in period }n

Why the Exact Payment Formula Reconciles

For an original principal $L$, an exact level payment $R$ over $n$ periods satisfies the ordinary-annuity present-value equation. The notation $a_{\overline{n}|i}$ denotes the present value of one unit paid at the end of each of $n$ periods at rate $i$.

L=R a_{\overline{n}|i} \qquad\Longrightarrow\qquad R=\frac{L}{a_{\overline{n}|i}}

To see why the recurrence gives the same result, start with $B_0=L$ and apply $B_k=(1+i)B_{k-1}-R$ repeatedly. Each payment is made at a different time, so the balance after $k$ periods is the accumulated principal less the accumulated value of the payments.

B_k=L(1+i)^k-Rs_{\overline{k}|i}

At $k=n$, the exact payment formula makes $B_n=0$. But if the actual installment is a rounded amount $C$, rather than the exact $R$, the balance generally will not be zero. Under unrounded interest, the final amount due after $n-1$ regular installments is $(1+i)B_{n-1}$. If $C$ is too small, that amount exceeds $C$; if $C$ is too large, it is less than $C$. This is why the final installment should be calculated from the actual ledger balance, not assumed to equal the regular installment.

Worked Example: Rounding the Level Installment

A borrower takes a hypothetical loan of $1,000, repaid with three end-of-month installments. The effective monthly interest rate is 10%. The lender rounds each period’s interest to the nearest cent and rounds the regular payment to cents. Find the adjusted third payment.

Method. Calculate the exact level payment, round it to cents for the first two installments, and then use the rounded-interest recurrence to find the amount due at the third payment date.

First calculate the annuity factor:

a_{\overline{3}|0.10} =\frac{1}{1.10}+\frac{1}{1.10^2}+\frac{1}{1.10^3} =0.9090909+0.8264463+0.7513148 =2.4868520

The exact level installment is $1000/2.4868520=402.1148$, so the regular installment rounded to cents is $402.11.

Period 1. Interest is $1000(0.10)=$100.00$. After the $402.11 installment, the balance is $1000.00+100.00-402.11=$697.89$.

Period 2. Interest is $697.89(0.10)=$69.789$, which rounds to $69.79. The balance after the second installment is $697.89+69.79-402.11=$365.57$.

Period 3. Interest on $365.57 is $36.557, rounded to $36.56. The amount needed to clear the loan is $365.57+36.56=$402.13$. Thus the adjusted final installment is $402.13, not $402.11.

Check. Total paid is $2(402.11)+402.13=$1,206.35$. Total interest charged is $100.00+69.79+36.56=$206.35$, so total payments equal the $1,000 principal plus the interest charged.

Rounding Interest at Each Step Versus Carrying Cents

Rounding only the final cash amount and rounding interest every period are different accounting procedures. With the first procedure, fractional cents can accumulate in the balance calculation. With the second, each period’s interest is fixed to a cent before the next balance is calculated. A small per-period difference can affect the final payoff, even when the regular payments are identical.

Worked Example: Reconciling Two Interest-Rounding Conventions

A hypothetical loan of $1,000 has a monthly effective interest rate of 0.5%. The borrower makes five end-of-month payments of $170, then pays the remaining amount at month six. Find the final amount under (a) interest rounded to cents every month and (b) interest carried without rounding until the final cash amount.

Method. In each version, apply the stated recurrence in sequence. Do not round balances in the unrounded-interest version.

(a) Round interest every month. The first five periods are:

\begin{aligned} B_1&=1000.00+5.00-170.00=835.00,\\ B_2&=835.00+4.18-170.00=669.18,\\ B_3&=669.18+3.35-170.00=502.53,\\ B_4&=502.53+2.51-170.00=335.04,\\ B_5&=335.04+1.68-170.00=166.72. \end{aligned}

The interest amounts are rounded from $5.00, $4.175, $3.3459, $2.51265, and $1.6752, respectively. In month six, interest is $166.72(0.005)=$0.8336$, rounded to $0.83. The payoff is therefore $166.72+0.83=\mathbf{$167.55}$.

(b) Carry fractional cents. Apply $B_k=1.005B_{k-1}-170$ without rounding the balance. This gives $B_1=835$, $B_2=669.175$, $B_3=502.520875$, $B_4=335.033479375$, and $B_5=166.708646772$. The month-six amount due is $166.708646772(1.005)=$167.542189006$, which rounds to $167.54.

Check. The two final amounts differ by one cent because the first method rounds five intermediate interest amounts. Each answer is correct under its stated convention; neither should be substituted for the other.

When the Final Installment Is Smaller

The adjusted final payment can also be smaller than the regular installment. For example, if rounding the regular installment upward means that the first $n-1$ payments have already repaid slightly more principal than the exact level schedule would, the final amount needed can be lower. The final payment is based on the actual remaining balance; it is not automatically increased to cover a shortfall.

Worked Example: A Final Payment Below the Regular Amount

A hypothetical zero-interest loan of $1,000.04 is to be repaid with three end-of-month payments. The exact level payment is rounded to cents for each of the first two installments. Calculate the adjusted third payment.

Method. At a zero interest rate, each payment reduces principal dollar for dollar. Calculate the exact installment, apply the rounded amount twice, and pay the remaining principal.

The exact installment is $1000.04/3=$333.346666\ldots$, which rounds to $333.35. After the first payment, the balance is $1000.04-333.35=$666.69$. After the second payment, it is $666.69-333.35=$333.34$. There is no interest, so the adjusted final payment is $333.34.

Check. The three payments total $333.35+333.35+333.34=$1,000.04$, exactly the original principal. Paying $333.35 for all three installments would overpay by one cent.

Common Mistake and Schedule Checks

A common mistake is to use the rounded regular installment as the final payment without checking the balance. In the first example, that incorrect calculation would charge $402.11 in month three. But the balance plus rounded final-period interest is $365.57+36.56=$402.13$; paying only $402.11 would leave $0.02 outstanding.

Another source of errors is inconsistent rounding. For instance, rounding interest in the first periods but carrying fractional cents in later periods does not follow either stated convention. A reliable reconciliation proceeds in order:

Identify the rate and period.
Use the effective rate for the interval between payments, not an annual rate as though it applied each month or quarter.

Apply the specified rounding rule.
Determine whether interest is rounded every period or fractional cents are carried through the balance calculation.

Calculate the balance after the penultimate payment.
Use the actual scheduled payments made, which may be rounded amounts.

Add the final period’s interest.
Round that interest only if the stated ledger convention requires it.

Verify the payoff.
Confirm that the adjusted final payment clears the balance and that the total payments reconcile to principal plus interest under the same convention.

This procedure matters wherever payments are processed in cents: a one-cent residual should be understood as a consequence of the ledger’s stated rounding policy, not silently ignored or treated as a new scheduled payment. If a schedule has been built with rounded interest, recomputing its final payment using a different convention will not reconcile it.

Key takeaway: The final payment is the actual balance immediately before that payment plus the final period’s interest, calculated under one consistent interest and rounding convention. Recalculate it from the schedule rather than assuming it equals the rounded regular installment.

Check Your Understanding

For each problem, use end-of-period payments and round periodic interest to the nearest cent unless the problem states otherwise.

A hypothetical $2,400 loan has a monthly effective rate of 0.5%. The borrower pays $810 at the end of each of the first two months. Find the amount due at the end of month three. (Answer: $804.01)
A hypothetical $1,200 loan has a monthly effective rate of 1%. The borrower pays $410 at the end of each of the first two months. Calculate the third and final payment. (Answer: $404.02)
A hypothetical $2,500 loan has a monthly effective rate of 0.4%. The borrower pays $640 at the end of each of the first three months. Calculate the payoff at the end of month four, showing the rounded interest in each period. (Answer: $604.84)
A hypothetical $10,000 loan has a quarterly effective rate of 2%. The borrower pays $2,650 at the end of each of the first three quarters. Find the adjusted fourth-quarter payment, and state why the monthly rate should not be used. (Answer: $2,552.06; use the stated quarterly rate because each payment period is one quarter.)

What You'll Learn