The Effect of Rounded Installments on Balances

Why Rounded Installments Change a Loan Balance

A level-payment loan can have a mathematically exact installment with more than two decimal places. In practice, a borrower may pay an amount rounded to the nearest cent. The resulting difference is small per installment, but it changes the cash flows used to calculate the outstanding balance. A balance based on the installments actually paid is not necessarily the same as one calculated from the exact, unrounded installment.

The key is to keep the loan’s interest rate and its actual payments consistent in the calculation. If the task is to find the balance immediately after a payment, the retrospective method accumulates the original principal and subtracts each actual payment accumulated to the balance date. The earlier material on outstanding balances gives the general balance methods; here the essential point is that a rounded installment is an actual cash flow, not an exact annuity amount.

Definition: The actual payment is the amount paid on a payment date, including any rounding applied to the scheduled installment. If a loan begins with principal $P$, earns an effective rate $i$ per payment period, and actual payments $C_1,\ldots,C_k$ are made at the ends of periods $1,\ldots,k$, the retrospective balance immediately after payment $k$ is $$ B_k=P(1+i)^k-\sum_{j=1}^{k}C_j(1+i)^{k-j}. $$

The model assumes that interest is credited at the same effective rate $i$ in every period shown, that payments occur at the specified period ends, and that each $C_j$ is the cash amount actually paid. If the rate changes or dates are irregular, the accumulation factors must reflect those rates or dates instead; one constant-rate formula cannot simply be carried over unchanged.

Deriving the Retrospective Formula

To see why the formula works, move every cash flow to time $k$, immediately after the $k$th payment. The original principal has accumulated for $k$ periods. A payment made at time $j$ has accumulated for the remaining $k-j$ periods. Subtracting the accumulated payments from the accumulated principal leaves the amount still owed at time $k$.

Accumulate the original loan.
The principal $P$ grows to $P(1+i)^k$ at the balance date.

Accumulate each actual payment.
Payment $C_j$ is made at time $j$, so it earns interest for $k-j$ periods and is worth $C_j(1+i)^{k-j}$ at time $k$.

Subtract payments from the accumulated loan.
The difference is the retrospective balance immediately after payment $k$.

If each of the first $k$ payments is the same actual amount $C$, the accumulated-payment sum is a geometric series:

C\left[1+(1+i)+\cdots+(1+i)^{k-1}\right] =C\,s_{\overline{k}|}, \qquad s_{\overline{k}|}=\frac{(1+i)^k-1}{i}.

Thus $B_k=P(1+i)^k-C\,s_{\overline{k}|}$. This uses the actual rounded amount $C$. It does not use the unrounded installment merely because that amount was used to design the original schedule.

Worked Example: A Rounded Level Installment

A loan of $5,000 has five annual payments. The effective annual interest rate is 4%, and the exact level installment is rounded to the nearest cent for payment. Find the retrospective balance immediately after the third actual payment of $1,123.14.

Method. Use the retrospective method with the actual payment $C=$1,123.14$. The exact level installment is $5000/a_{\overline{5}|}$, where $a_{\overline{5}|}=[1-(1.04)^{-5}]/0.04$. Since $a_{\overline{5}|}\approx4.451822$, the exact installment is approximately $1,123.136, which rounds to $1,123.14.

At time 3, the principal has accumulated to $5000(1.04)^3=5000(1.124864)=$5,624.32$. The first payment has accumulated for two periods, the second for one period, and the third for none. Equivalently, $s_{\overline{3}|}=[(1.04)^3-1]/0.04=3.1216$. The accumulated value of the three actual payments is $1123.14(3.1216)=$3,505.993824$.

Therefore, $B_3=5624.32-3505.993824=$2,118.326176$, or $2,118.33 to the nearest cent. This is the balance derived from the principal and the three payments actually made. The method avoids silently substituting the unrounded installment for those cash flows.

Check. The balance is positive, as expected: three of five installments have been made, and two remain. The rounding difference is small, but the calculation has retained it rather than assuming that the original exact schedule was followed to infinite precision.

Using Actual Amounts When Payments Differ

A rounded payment schedule need not consist of identical amounts. For example, a borrower might make payments that differ because of a correction, an agreed extra amount, or a final settlement. In that case, use the general sum and enter each actual payment with its own accumulation period. Do not average the payments or replace them with a nominal level amount unless the problem explicitly asks for an approximation.

Worked Example: Two Actual Payments and a Later Payoff

A hypothetical loan begins at $5,000 and accrues interest at 3% per period. The borrower makes actual payments of $1,800.00 at the ends of periods 1 and 2. Find the balance immediately after payment 2 and the amount required one period later to clear it, assuming no intervening payment.

Method. Accumulate the original principal for two periods. Accumulate the first payment for one period, but do not accumulate the second payment because it is made on the balance date.

The accumulated principal is $5000(1.03)^2=5000(1.0609)=$5,304.50$. The first payment is worth $1800(1.03)=$1,854.00$ at time 2, and the second is worth $1,800.00. Hence $B_2=5304.50-1854.00-1800.00=$1,650.50$.

With no payment between time 2 and time 3, this balance earns one period of interest. The payoff at time 3 is $1650.50(1.03)=$1,700.015$, which rounds to $1,700.02 to the nearest cent.

Check. The amount due is greater than the balance at time 2 because one period of positive interest has accrued. This calculation uses the actual payment dates and avoids treating the time-1 payment as though it were made at time 2.

Rounding Drift and the Final Payment

When a fixed installment is rounded and paid repeatedly, the difference from the exact installment accumulates with interest. If $R$ is the exact installment and $C$ is the rounded amount paid for each of the first $k$ periods, the difference between the retrospective balances under those two payment streams is

B_k(C)-B_k(R)=-(C-R)s_{\overline{k}|}.

This follows by subtracting the two retrospective formulas: the original principal terms cancel, leaving $-(C-R)$ times the accumulated-value factor for $k$ level payments. If $C>R$, the balance is lower than under the exact schedule; if $C<R$, it is higher. The sign is useful as a check, although the full balance still depends on the initial principal and all actual payments.

At the end of a loan, it is common to adjust the final installment rather than insist on paying the same rounded amount as every earlier installment. The payoff immediately before the final payment is the amount that must be settled on that date. Rounding that payoff to cents may leave a tiny residual, depending on how the contract handles fractional cents. State whether a reported amount is the unrounded mathematical payoff or the cash amount rounded to cents.

Worked Example: Adjusting the Last Installment

A hypothetical $1,000 loan is repaid monthly over 12 periods at an effective rate of 1% per month. Its exact level installment is rounded to the nearest cent, so the borrower pays $88.85 at the ends of months 1 through 11. Find the exact amount due at month 12 before rounding, then report it to the nearest cent.

Method. First identify the rounded regular payment. The exact installment is $1000/a_{\overline{12}|}$, with $a_{\overline{12}|}=[1-(1.01)^{-12}]/0.01\approx11.25508$. Thus the exact installment is approximately $88.8488, which rounds to $88.85.

Use the 11 actual payments to find the balance immediately after month 11. Here $1.01^{11}=1.1156683467$, so $s_{\overline{11}|}=(1.01^{11}-1)/0.01=11.5668346665$. The accumulated principal is $1000(1.1156683467)=$1,115.6683467$. The accumulated value of the 11 payments is $88.85(11.5668346665)=$1,027.7132601$.

The month-11 balance is therefore $1115.6683467-1027.7132601=$87.9550865$. One month of interest brings the amount due at month 12 to $87.9550865(1.01)=$88.8346374$.

The exact mathematical payoff is $88.8346374; to the nearest cent, it is $88.83. If only cent-denominated payments are accepted, paying $88.83 leaves about $0.0046374 before any contract-specific adjustment. Paying $88.84 instead exceeds the calculated payoff by about $0.0053626. The calculation has not assumed that 12 payments of $88.85 exactly amortize the loan.

Prospective Values and the Rounding Trap

A prospective calculation values the remaining actual payments at the balance date. It agrees with the retrospective balance when the initial principal and the complete cash-flow schedule are consistent at the stated interest rate. A small mismatch can arise if all scheduled installments are rounded but the original principal is still treated as exactly equal to the present value of the unrounded schedule. If a final payment is adjusted to settle the balance, include that actual final payment in the prospective cash flows.

A common mistake is to subtract the total of past payments from the accumulated principal without accumulating earlier payments to the balance date. For instance, suppose a loan of $5,000 earns 3% per period and actual payments of $1,800 are made at times 1 and 2. The incorrect calculation is $5000(1.03)^2-1800-1800=$1,704.50$. It wrongly treats both payments as if they were made at time 2. The correct calculation is $5000(1.03)^2-1800(1.03)-1800=$1,650.50$. The time-1 payment must be accumulated one period. This timing error is much larger than a typical cent-rounding effect, so check payment dates before interpreting a small difference as rounding drift.

Key takeaway: A balance calculation must use the cash flows that actually occurred. Accumulate each actual payment from its payment date to the balance date, and adjust the final payment if the rounded installments do not fully amortize the loan.

Check Your Understanding

For each problem, use the specified interest rate and actual payment amounts. Round only the requested final cash amount to cents.

A $2,400 loan earns 2% per period. Actual payments of $900 are made at the ends of periods 1 and 2. Find the balance immediately after payment 2. (Answer: $678.96)
A $8,000 loan earns 5% per period. Actual payments of $1,500 are made at the ends of periods 1, 2, and 3. Find the balance immediately after payment 3 and the payoff one period later if no payment is made in between. (Answer: Balance $4,532.25; payoff $4,758.86)
A $12,000 loan earns 3% per quarter. The actual quarterly installment is $1,640.00. Find the retrospective balance immediately after the fourth payment. (Answer: $6,644.96)
A $5,000 loan earns 4% per year. Actual payments of $1,300 are made at the ends of years 1, 2, and 3. Find the balance immediately after payment 3 and the amount due at the end of year 4 if there is no intervening payment. (Answer: Balance $1,566.24; amount due $1,628.89)

What You'll Learn