Common Timing and Sign Errors in Loan Changes

Why Timing and Signs Matter

Loan-change calculations often use familiar interest and payment formulas, yet a result can still be wrong because a cash flow was placed on the wrong date or given the wrong sign. An extra payment made just after a scheduled installment is not equivalent to one made a month earlier. A missed installment is not a payment made on its due date. A refinancing fee paid in cash is not the same transaction as a fee added to the replacement loan.

The reliable first step is to fix a viewpoint and draw a timeline. This tutorial uses the borrower’s viewpoint: money received by the borrower is positive, and money paid by the borrower is negative. For an outstanding loan balance, however, it is usually clearest to write the balance as a positive amount owed and subtract each payment when it is actually made.

Definition: Let $B_t$ denote the outstanding loan balance at time $t$, measured immediately after any payment specified to occur at time $t$. If the effective interest rate per payment period is $i$, and a payment $R$ is made at the end of the period, then the balance changes from $B_{t-1}$ to $B_t=B_{t-1}(1+i)-R$. If more than one payment occurs on that date, subtract each payment on that date, unless the problem specifies a different contractual order.

The timing convention in the definition matters: a balance immediately before a payment and a balance immediately after it differ by the payment amount. State which one is being used. If the problem does not specify the order of simultaneous transactions, do not silently assume a particular order; identify the convention required for the calculation.

A Timeline Method for Loan Changes

For a loan with a constant effective rate per period, interest first grows the balance from one payment date to the next. Payments then reduce the balance on the dates they are made. The following process keeps those operations in order.

Mark the valuation date.
Write down whether the stated balance is before or after a scheduled payment, and identify the exact date of each change.

Grow the debt between dates.
Apply the interest accumulation factor for the elapsed time. Use the rate and time unit specified by the problem.

Subtract only actual payments.
At each payment date, reduce the balance by the amount actually paid. A missed or delayed payment cannot be subtracted on its original due date.

Separate debt from cash flow.
For refinancing, calculate the new loan principal and transaction-date cash flows separately. State whether each fee is paid upfront or financed.

Check the result.
Confirm the balance changes in the expected direction and that the cash-flow signs match the chosen viewpoint.

This approach is aligned with the SOA Exam FM (Financial Mathematics) syllabus. It is especially useful when a problem combines regular installments with an extra payment, a late installment, or a refinancing transaction.

Why the Balance Recurrence Works

Suppose a balance $B$ is measured immediately after one payment. During the next full payment period, the debt accumulates interest at effective rate $i$. Just before the next payment, the debt is therefore $B(1+i)$. If a payment $R$ is then made, the amount still owed is the pre-payment debt less the payment.

B_{\text{after}}=B(1+i)-R

The formula follows from the timing of the transactions, not merely from a convention about signs. If no payment is made, set $R=0$, so the debt grows to $B(1+i)$. If a payment is made, subtract it at its actual date. When an additional payment $E$ is made on that same date after the regular payment, the balance becomes $B(1+i)-R-E$.

For a payment delayed by one period, the key comparison is between paying it on its due date and paying it one period later. If the delayed amount is $D$, the amount of additional debt attributable to the delay after that extra period is $D(1+i)-D=Di$, assuming the payment would otherwise have reduced the loan balance on the due date. This comparison requires the same rate and the same other cash flows in both cases.

Worked Example: Extra Payment on the Scheduled Payment Date

A hypothetical loan has a balance of $10,000 immediately after the payment at time 0. The effective monthly interest rate is 1%. The borrower pays $1,000 at the end of each month. At the end of month 2, the borrower makes an additional $500 after the scheduled payment. Find the balance immediately after the regular and extra payments at month 2, and immediately after the regular payment at month 4. Ignore fees and assume the loan remains outstanding at the stated rate.

Method. Apply interest for each month, then subtract the payment or payments made at that month-end. This avoids treating the extra payment as if it were made on an earlier date.

At the end of month 1, interest on $10,000 is $10{,}000(0.01)=\$100$. After the $1,000 payment, the balance is

B_1=10{,}000(1.01)-1{,}000=10{,}100-1{,}000=\$9{,}100.

At the end of month 2, interest is $9{,}100(0.01)=\$91$. The balance immediately before the scheduled payment is $9,191. Subtract the regular payment first, then the extra payment:

B_2=9{,}100(1.01)-1{,}000-500 =9{,}191-1{,}000-500 =\$7{,}691.

At the end of month 3, interest is $7{,}691(0.01)=\$76.91$, so

B_3=7{,}691(1.01)-1{,}000 =7{,}767.91-1{,}000 =\$6{,}767.91.

At the end of month 4, interest is $6{,}767.91(0.01)=\$67.6791$. Before rounding, the balance after the regular payment is

B_4=6{,}767.91(1.01)-1{,}000 =6{,}835.5891-1{,}000 =\$5{,}835.5891.

Rounded to the nearest cent, $B_2=\$7{,}691.00$ and $B_4=\$5{,}835.59$. As a check, without the extra payment the month-2 balance after the regular payment would be $8,191.00. The extra $500 paid at month 2 reduces the month-4 balance by $500(1.01)^2=\$510.05$, and $6{,}345.6391-510.05=5{,}835.5891$, matching the calculation.

Common mistake. Treating the extra $500 as paid at the end of month 1 would give it an additional month to reduce interest. Its effect by month 4 would then be $500(1.01)^3=\$515.1505$, not $510.05. The payment date in the problem is month 2, so the earlier-date calculation is incorrect.

Missed Payments and Accrued Interest

A missed installment affects the loan balance because the debt remains outstanding while the payment is not made. When the installment is later paid, subtract it on the later date. Do not subtract it from the balance at the original due date unless the problem explicitly says that the payment was made then.

The calculation also depends on the stated contract. A problem may specify a late fee, a distinct rate on overdue amounts, or a particular interest method. Those terms must be included if given. The example below assumes there are no late fees and all outstanding debt accumulates at the same effective monthly rate.

Worked Example: Paying a Missed Installment One Month Late

A hypothetical loan balance is $20,000 immediately after a payment date. The effective monthly interest rate is 1%, and the scheduled payment is $600 at each month-end. The month-1 payment is missed. At month 2, the borrower pays the missed $600 installment and the regular $600 installment due then, for a total payment of $1,200. There are no late fees, and the entire outstanding balance accumulates at 1% per month. Find the balance immediately after the month-2 payment.

Method. Accumulate the unpaid balance for both months, then subtract the actual $1,200 paid at month 2. No payment is subtracted at month 1 because none was made.

After month 1, the balance is $20{,}000(1.01)=\$20{,}200$. No payment is made, so that full amount remains. After another month of interest, the balance immediately before the month-2 payment is

20{,}200(1.01)=\$20{,}402.

The actual month-2 payment is $600+600=\$1{,}200$. Therefore, the balance immediately afterward is

B_2=20{,}402-1{,}200=\$19{,}202.

As a check on the timing, if the first $600 had actually been paid at month 1, the balance after the month-1 payment would have been $20{,}200-600=\$19{,}600$. At month 2 it would grow to $19{,}600(1.01)=\$19{,}796$, and after the regular $600 payment it would be $19,196. The difference is $19{,}202-19{,}196=\$6$, exactly one month’s interest on the delayed $600: $600(0.01)=\$6$.

Common mistake. Subtracting $600 at month 1 even though it was not paid gives the $19,196 balance for a different cash-flow history. The correction is to leave the installment in the debt until the date it is actually paid.

Refinancing Fees and Borrower Cash-Flow Signs

On a refinancing date, keep three quantities distinct: the payoff of the old loan, the principal of the replacement loan, and any fee. A fee paid upfront is an immediate borrower cash outflow. A fee financed as part of the replacement loan increases the new principal and is repaid under that loan’s terms.

With the borrower’s viewpoint, a new loan provides positive cash to the borrower, while paying off the old debt and paying an upfront fee are negative cash flows. The new loan principal is still a positive liability amount owed. These two descriptions are not contradictory: a loan can be a positive inflow on the transaction date and a positive amount of debt afterward.

Worked Example: Checking the Signs of a Financed Fee

On a refinancing date, the payoff required to settle a hypothetical old loan is $12,400. A refinancing fee is $300. In option A, the replacement lender finances the fee along with the payoff. In option B, the borrower pays the fee upfront and borrows only enough to cover the payoff. Ignore all other transaction costs. For each option, determine the replacement-loan principal and the borrower’s net cash flow on the transaction date, assuming the replacement loan proceeds are received on that date.

Method. First calculate the amount borrowed. Then list the date’s cash inflows and outflows from the borrower’s viewpoint. This prevents the fee from being omitted or counted twice.

Option A: fee financed. The replacement principal must cover both the $12,400 payoff and the $300 fee:

\text{New principal}=12{,}400+300=\$12{,}700.

The borrower receives $12,700 of proceeds, pays $12,400 to settle the old loan, and pays $300 for the fee. The transaction-date net cash flow is

+12{,}700-12{,}400-300=\$0.

Option B: fee paid upfront. The replacement loan covers only the old loan payoff, so its principal is $12,400. The borrower receives $12,400, pays $12,400 to settle the old loan, and pays the $300 fee from other funds. The net transaction-date cash flow is

+12{,}400-12{,}400-300=-\$300.

The check is that the financed-fee option leaves the borrower with $300 more debt and $300 less immediate cash outflow than the upfront-fee option. In either option, the old loan is settled for $12,400; the fee changes how much the borrower borrows or pays at the transaction date.

Common mistake. Adding the fee to the new principal and also treating it as an additional upfront cash payment would count the same $300 twice. Conversely, borrowing only $12,400 while assuming that the new loan also covers a $300 fee leaves the transaction short by $300.

Common Timing and Sign Traps

Before accepting a loan-change calculation, check the timeline and the meaning of every amount. The following errors are especially easy to make under time pressure.

Using a before-payment balance as an after-payment balance. If a balance is stated immediately before an installment, subtract the installment before using it as the starting balance for the next period.
Moving an extra payment to a convenient date. Interest savings depend on when the payment is actually made. A payment one period earlier has a different accumulated effect.
Subtracting a delinquent payment on its due date. Subtract it only when paid. If a contract applies a late fee or special rate, include that term as specified.
Mixing interest periods. A monthly effective rate applies to monthly intervals. Do not treat an annual rate as a monthly rate without conversion, or apply a full month’s interest to a shorter interval unless the problem’s convention supports it.
Switching sign viewpoints mid-calculation. Choose the borrower’s or lender’s viewpoint and keep it consistent. A payoff is an outflow for the borrower and an inflow for the lender.
Confusing a loan amount with net cash received. Fees and payoff amounts can use some or all of the new loan proceeds. State each transaction-date flow separately before netting.

Key takeaway: Write down the valuation date, state whether each balance is before or after the payment, and place every cash flow on its actual date. For a refinancing transaction, distinguish the amount of debt from the borrower’s net cash flow.

Check Your Understanding

For each problem, use the stated timing convention and keep the borrower’s cash-flow signs consistent.

A loan balance is $5,000 immediately after a payment date. The monthly effective rate is 2%. A $400 payment that was due at the end of month 1 is instead paid at the end of month 2. Relative to paying it at month 1, how much additional balance remains immediately after the month-2 payment, assuming all other payments are unchanged? (Answer: $8.00)
A loan balance is $6,000 immediately after a payment date. The effective monthly rate is 1%. At the end of month 1, the borrower pays the scheduled $800 and then an extra $250. What is the balance immediately afterward? (Answer: $5,010.00)
A hypothetical loan has a balance of $10,000 immediately after a payment date and an effective monthly rate of 0.5%. The borrower misses the $500 month-1 installment, then pays both the missed installment and the $500 month-2 installment at month 2. There are no fees, and all debt earns interest at the stated rate. Find the balance immediately after the month-2 payment. (Answer: $9,100.25)
An old loan’s transaction-date payoff is $9,800 and a $240 fee is financed into the replacement loan. The borrower receives all replacement-loan proceeds on that date and pays the payoff and fee from those proceeds. Find the new principal and the borrower’s net transaction-date cash flow. (Answer: New principal $10,040; net cash flow $0.)
A loan balance is $15,000 immediately after a payment date. The effective monthly rate is 1%. At the end of month 1, the borrower makes a scheduled $1,000 payment and then an extra $300 payment. Find the balance immediately after both payments. (Answer: $13,850.00)

What You'll Learn