Reconstructing Loan Schedules From Irregular Payment Histories

Why Irregular Payment Histories Need a Ledger

A standard amortization schedule has payments at regular intervals, often with the same amount each time. Actual loan histories can be less regular: a borrower may receive additional advances, make payments of different sizes, or transact at dates that do not match the original schedule. The reliable approach is to reconstruct the balance transaction by transaction, using the time between dates to determine interest.

The key distinction is between interest accrued and interest paid. If accrued interest is greater than a payment, the payment cannot cover all the interest; the remainder stays in the balance under the capitalization model used here. If the payment exceeds accrued interest, the remainder reduces principal. These rules make it possible to handle both ordinary and irregular payments consistently.

Definition: A loan ledger records, in chronological order, the balance immediately after each transaction. Between transaction dates, the balance accumulates interest. At a transaction date, an advance increases the balance and a payment decreases it. Unless stated otherwise, assume a constant effective annual interest rate $i$, compound accumulation over elapsed time, no fees or penalties, and that unpaid interest is added to the balance. If the elapsed time is $t$ years, the accumulation factor is $(1+i)^t$.

The Balance Recurrence and Payment Split

Let $B$ be the balance immediately after the previous transaction, and let $\Delta t$ be the time in years until the next transaction. If the rate is constant over that interval, the balance just before transactions on the next date is

B_{\text{before}}=B(1+i)^{\Delta t}.

The accrued interest over the interval is $I=B_{\text{before}}-B$. Suppose an advance of $A$ and a payment of $C$ occur on the new date, with the advance posted before the payment. The closing balance is

B_{\text{after}}=B+I+A-C.

For the payment allocation, assume the payment does not exceed the total amount owed at that date. The amount of the payment allocated to interest is $\min(C,I)$; unpaid interest is $\max(I-C,0)$; and principal reduction is $\max(C-I,0)$. The payment may reduce principal advanced on the same date once accrued interest has been covered. Under this convention, the full payment—not just its principal component—is subtracted in the balance recurrence.

Important condition: The recurrence assumes interest accrues only on funds already advanced by the start of an interval. An advance made on a transaction date earns no interest before that date. If a contract specifies a different order, rate convention, or treatment of unpaid interest, use that contract’s terms instead.

The recurrence follows directly from the cash-flow accounting. Starting from $B$, interest adds $I$, an advance adds $A$, and a payment removes $C$. Thus the balance after the transactions is $B+I+A-C$. The payment allocation does not change this total: it explains how much of $C$ covers interest and how much reduces principal. It is a useful check on the ledger, not a second adjustment to add to it.

A Reliable Reconstruction Procedure

Sort all events by date.
Record each advance and payment, and state how same-date transactions are ordered. Begin with the balance immediately after the initial advance or other starting event.

Accrue interest to the next event.
Multiply the current balance by the accumulation factor for the actual elapsed time. Subtract the opening balance from the resulting amount to find accrued interest.

Post advances and payments.
Add advances and subtract the full payment. Allocate the payment to accrued interest first, then to principal; if it is too small to cover interest, carry the unpaid amount in the balance.

Verify the closing balance.
Check that opening balance plus accrued interest plus advances minus payments equals the balance after the date’s transactions.

Worked Applications

Worked Example: Unequal Payments and a Later Advance

A hypothetical loan has an initial advance of $12,000 at time $t=0$. The effective annual interest rate is 10%. The borrower pays $4,000 at $t=1$. At $t=3$, the lender first makes a further $2,000 advance and the borrower then pays $5,000. Find the interest and principal portions of both payments and the balance after each payment.

Method. Move from date to date, accruing interest on the balance outstanding during each interval. The $t=1$ to $t=3$ interval is two years, so its factor is $(1.10)^2=1.21$.

At $t=1$. The opening balance is $12,000. Interest for one year is $12{,}000(0.10)=\$1{,}200$, so the amount due before the payment is $12{,}000+1{,}200=\$13{,}200$. The $4,000 payment covers $1,200 of interest and reduces principal by $4{,}000-1{,}200=\$2{,}800$. The closing balance is $12{,}000+1{,}200-4{,}000=\$9{,}200$.

From $t=1$ to $t=3$. The opening balance is $9,200. The balance just before the $t=3$ transactions is $9{,}200(1.21)=\$11{,}132$, so accrued interest is $11{,}132-9{,}200=\$1{,}932$.

At $t=3$. Post the $2,000 advance before the payment. The $5,000 payment covers $1,932 of accrued interest; the remaining $5{,}000-1{,}932=\$3{,}068$ reduces principal. The closing balance is $9{,}200+1{,}932+2{,}000-5{,}000=\$8{,}132$.

Check. The amount after interest and the advance is $11{,}132+2{,}000=\$13{,}132$; subtracting the full $5,000 payment gives $8,132. The calculation avoids treating the two-year gap as a one-year interval.

Worked Example: A Payment Smaller Than Accrued Interest

A hypothetical loan balance of $10,000 accrues interest at an effective annual rate of 20%. After one year, the borrower pays $600. One year later, the borrower pays $2,000. Find the interest paid, any unpaid interest, the principal reduction, and the balance after each payment.

After the first year. Accrued interest is $10{,}000(0.20)=\$2{,}000$. Since the payment is only $600, interest paid is $\min(600,2{,}000)=\$600$, and unpaid interest is $2{,}000-600=\$1{,}400$. Principal reduction is zero because the payment does not cover all accrued interest. The balance is $10{,}000+2{,}000-600=\$11{,}400$.

After the second year. Under the stated capitalization model, interest accrues on the full $11,400 balance. Accrued interest is $11{,}400(0.20)=\$2{,}280$. The $2,000 payment is entirely allocated to interest, leaving $2{,}280-2{,}000=\$280$ unpaid; there is no principal reduction. The closing balance is $11{,}400+2{,}280-2{,}000=\$11{,}680$.

Check. The balance increased by $1,400 after the first payment and by $280 after the second, exactly the unpaid interest at each date. A payment smaller than accrued interest cannot be assigned a negative principal reduction.

Worked Example: Solving for a Missing Irregular Payment

A hypothetical loan has an initial balance of $15,000 at $t=0$, with an effective annual interest rate of 10%. A $3,000 payment is made at $t=1$. At $t=2$, a $2,000 advance is made before an unknown payment $X$. At $t=4$, a $6,000 payment is made, after which the balance is $8,520. Find $X$ and the interest and principal components of the payments.

At $t=1$. Interest is $15{,}000(0.10)=\$1{,}500$. The $3,000 payment covers $1,500 of interest and reduces principal by $1,500. The balance becomes $15{,}000+1{,}500-3{,}000=\$13{,}500$.

At $t=2$, before the unknown payment. One year of interest on $13,500 is $13{,}500(0.10)=\$1{,}350$. Add the $2,000 advance, so the balance before payment $X$ is $13{,}500+1{,}350+2{,}000=\$16{,}850$. The balance immediately after that payment is $16{,}850-X$.

Use the final balance. From $t=2$ to $t=4$ is two years, with accumulation factor $(1.10)^2=1.21$. The balance after the final $6,000 payment satisfies $(16{,}850-X)(1.21)-6{,}000=8{,}520$. Adding $6,000 gives $(16{,}850-X)(1.21)=14{,}520$. Dividing by 1.21 gives $16{,}850-X=12{,}000$, and therefore $X=\$4{,}850$.

Payment components and check. At $t=2$, accrued interest is $1,350, so the $4,850 payment includes $1,350 interest and $4{,}850-1{,}350=\$3{,}500$ principal. The closing balance is $12,000. Over the next two years, interest is $12{,}000(1.21-1)=\$2{,}520$. The $6,000 payment therefore includes $2,520 interest and $3,480 principal. The final balance is $12{,}000+2{,}520-6{,}000=\$8{,}520$, as required.

The method is a dated balance ledger followed by an equation at the known final date. It avoids discounting every transaction separately when a forward balance calculation is more direct.

Common Mistakes and Checks

A frequent error is to subtract only a payment’s principal component in the balance recurrence after already adding accrued interest. That counts the interest twice. For example, in the first worked example, the correct balance after the $t=1$ payment is $12{,}000+1{,}200-4{,}000=\$9{,}200$. The payment’s principal component is $2,800, but $12{,}000+1{,}200-2{,}800=\$10{,}400$ is wrong: it leaves the payment’s $1,200 interest allocation in the balance even though that interest was already added and then paid.

Another error is to say that a payment smaller than interest has an interest component equal to all the accrued interest and a negative principal component. If accrued interest is $2,000 and the payment is $600, only $600 of interest is paid; $1,400 remains unpaid, and principal reduction is zero. The ledger balance rises by that unpaid amount.

Use the actual elapsed time. A two-year interval at 10% accumulates by $1.1^2$, not by $1.1$.
Respect transaction order. An advance made on a date does not accrue interest before that date under the model here.
Subtract the full payment once. Use opening balance plus interest plus advances minus payments for the closing balance.
Check payment capacity. The stated allocation rules assume a payment does not exceed the amount owed. If it does, the excess must be handled according to the loan terms.

Key takeaway: At each dated event, accrue interest over the preceding interval, add advances, subtract the full payment, and then verify the resulting balance. Allocate a payment to accrued interest first; any unpaid interest remains in the balance, while any excess payment reduces principal.

Check Your Understanding

For each problem, use the stated timing and capitalization assumptions. Amounts are in dollars.

A loan of $6,000 is advanced at $t=0$. The effective annual interest rate is 5%, and a $1,000 payment is made at $t=1$. Find the interest portion, principal reduction, and closing balance. (Answer: interest $300; principal $700; balance $5,300.)
A balance of $8,000 accrues interest at an effective annual rate of 21%. At $t=0.5$, the borrower pays $600. Use compound accumulation over fractional years. Find the interest accrued, unpaid interest, principal reduction, and closing balance. (Answer: accrued interest $800; interest paid $600; unpaid interest $200; principal reduction $0; balance $8,200.)
A $9,000 loan accrues interest at 10% effective annually. A $2,500 payment is made at $t=1$, and a $1,000 advance is made at $t=2$. A $3,000 payment is made at $t=3$. Find the interest and principal portions of the $t=3$ payment and the balance afterward. (Answer: interest $914; principal $2,086; balance $7,054.)
A $10,000 loan accrues interest at 10% effective annually. A $3,000 payment is made at $t=1$. At $t=2$, a $500 advance is made before an unknown payment $X$. At $t=3$, a $2,000 payment leaves a balance of $6,800. Find $X$. (Answer: $1,300.)
A $5,000 balance accrues interest at 20% effective annually. After one year the borrower pays $600. One year later, the borrower receives a $300 advance and then pays $2,000. Find the interest accrued during the second year, the interest and principal portions of that second payment, and the closing balance. (Answer: interest accrued $1,080; interest paid $1,080; principal reduction $920; balance $4,780.)

Careful ledger construction is aligned with the SOA Exam FM (Financial Mathematics) syllabus. It is especially useful when a problem combines nonlevel payments, unequal time intervals, and advances that do not match a regular schedule.

What You'll Learn