Why Integrated Loan Changes Require a Timeline
A loan change can involve several amounts with different dates: principal outstanding, installments that were missed, a cash payment made at modification, refinancing costs, and payments under a revised schedule. The main task is to bring each amount to one transaction date before combining it. An amount due earlier is accumulated to that date; an amount due later is discounted to it.
The transaction-date value equation is the organizing check. It helps distinguish the old obligation being settled from fees charged for changing the financing, and it reveals whether a missed installment has been counted once or twice. The calculations below assume payments occur at the ends of their stated monthly periods. Rates are effective monthly rates unless stated otherwise.
Set Up the Obligation Before Recalculating Payments
First establish what is owed at the transaction date under the old arrangement. Keep principal, arrears, penalties, and refinancing costs separate until their amounts and treatment are clear. In particular, the statement “the outstanding balance is $7,000” may exclude installments that are already due but unpaid. The loan terms or problem must determine how those arrears accumulate; do not assume they are automatically included in the principal balance.
A useful accounting identity is:
A fee paid in cash is an additional cash outflow, not part of the new loan principal. A fee financed into the replacement loan increases that principal. Either way, state the treatment explicitly. Once the new principal has been established, value its future installments and balloon at the transaction date using the new loan’s rate.
Draw a timeline and identify the transaction date. Convert any quoted rate to the effective rate per payment period before accumulating or discounting.
Bring the outstanding principal, missed installments, and any applicable charges to the transaction date. Include only amounts specified by the loan terms.
Subtract a lump-sum payment that reduces principal. Add costs only if they are financed; record costs paid upfront separately.
Discount each new payment and any balloon at the new effective rate to the transaction date. Compare that value with the revised principal.
Why the Transaction-Date Equation Holds
Suppose the new loan principal at the transaction date is \(L\), the effective rate per payment period is \(j\), and payments \(C_k\) are due \(k\) periods after that date. If a balloon \(B\) is due at period \(n\), the value equation is:
This follows directly from the accumulation model. Accumulating each future payment to period \(n\) gives \(C_k(1+j)^{n-k}\), while the balloon is already valued at period \(n\). The balance accumulated from the transaction date is \(L(1+j)^n\). Equating the amounts at period \(n\) and dividing by \((1+j)^n\) gives the displayed equation. It applies when the stated effective rate \(j\) is used for all periods in the new schedule and the payment dates match the periods shown. It does not justify using one rate for arrears if the old contract specifies a different rate or treatment.
Worked Example: Missed Installments, a Lump Sum, and a New Balloon
At a modification date, a loan has outstanding principal of $7,000 immediately after the third scheduled payment. The next two monthly installments of $500 are missed. For this calculation, the principal accrues at 1% effective monthly, and each missed installment accrues at the same rate from its due date. At the modification date the borrower pays $2,000, and a $100 fee is financed. The revised rate is 0.5% effective monthly. The revised schedule requires five payments of $1,000 at the ends of months 1 through 5 and a balloon at the end of month 6. Find the balloon. Ignore any other charges.
Method. Accumulate the old principal and each arrear to the modification date, then add the financed fee and subtract the lump-sum payment.
The $7,000 principal accumulates for two months: \(7{,}000(1.01)^2=7{,}141.40\). The installment missed one month before the modification date accumulates for one month, giving \(500(1.01)=505\). The installment due on the modification date is $500. Thus the old obligation at the transaction date is:
After the $2,000 payment and the financed fee, the revised principal is: \(8{,}146.40-2{,}000+100=\$6{,}246.40\). At the new rate, \((1.005)^6=1.030377509\). Accumulating the revised principal to month 6 gives: \(6{,}246.40(1.005)^6=\$6{,}436.15\), rounded to cents.
The five installments accumulate to month 6. Their accumulation factor is \(\big((1.005)^6-1.005\big)/0.005=5.075501879\), so their accumulated value is \(1{,}000(5.075501879)=\$5{,}075.50\). Therefore:
Transaction-date check. Discounting the five installments and the balloon at 0.5% per month gives \(1{,}000a_{\overline{5}|}+1{,}360.65(1.005)^{-6}\), which equals $6,246.40 to the nearest cent. The accumulation calculation and the transaction-date value agree, subject to rounding.
Mistake avoided. Adding two missed $500 installments without accumulating the earlier one would understate the old obligation by $5. Conversely, adding the arrears to a balance that already includes them would double-count them.
Refinance Payoff, Fees, and a Changed Payment Pattern
In a refinancing, the old loan payoff and the replacement loan are separate calculations. The payoff is valued under the old contract at the transaction date. The replacement loan is then valued under its own rate and payment schedule. A fee may be paid upfront or financed; those choices have different loan principals and cash flows, so label which one applies.
Worked Example: Refinancing Arrears With a Financed Fee
At a transaction date, a borrower has $15,000 of outstanding principal. A $500 installment due one month earlier is unpaid and accrues at the old loan’s effective monthly rate of 1%. A $50 late charge is also due. A replacement loan is used to pay off the old obligation and finance a $445 refinancing fee. Its monthly rate is 1%. The borrower will make seven payments of $2,000 at the ends of months 1 through 7, followed by a balloon at the end of month 8. Find the balloon and verify the new loan principal.
Method. First value the old payoff at the transaction date. Then add the financed fee to determine the replacement principal.
The missed installment accumulates for one month to \(500(1.01)=\$505\). Thus the old payoff is: \(15{,}000+505+50=\$15{,}555\). Adding the financed fee gives replacement principal \(15{,}555+445=\$16{,}000\). The transaction-date funding identity is \(15{,}555+445=16{,}000\).
At month 8, the replacement principal accumulates to \(16{,}000(1.01)^8=16{,}000(1.082856706)=\$17{,}325.71\). The seven installments accumulate to month 8 with factor \(\big((1.01)^8-1.01\big)/0.01=7.285670563\). Their accumulated value is \(2{,}000(7.285670563)=\$14{,}571.34\). Hence:
Transaction-date check. The new principal equals the value of its payments and balloon: \(2{,}000a_{\overline{7}|}+2{,}754.37(1.01)^{-8}=\$16{,}000\), to the nearest cent. If the $445 fee were paid upfront instead, the replacement principal would be $15,555, and the borrower would separately pay $445 at the transaction date. The fee must not be both financed and added again as an upfront payment.
Mistake avoided. The $500 arrear is due one month before the transaction date, so its value is $505, not $500. The $50 charge is included once, and the refinancing fee is financed once.
Upfront Costs and the Revised Obligation
A transaction-date value check is also useful when fees are paid in cash. In that case, calculate the revised principal from the old obligation and the lump-sum principal reduction; do not add the upfront fee to that principal. The fee still matters when comparing the borrower’s total cost, but it does not change the loan balance unless it is financed.
Worked Example: Recasting After a Rate Change With an Upfront Fee
At a transaction date, a loan has principal of $9,600. A $400 installment due one month earlier is unpaid and accumulates at 1% effective monthly. A $20 charge is payable at the transaction date. The borrower pays $1,500 toward the old obligation, and pays a separate $80 modification fee in cash. The revised monthly rate is 0.75%. The new schedule consists of eight payments of $900 at the ends of months 1 through 8 and a balloon at the end of month 9. Find the balloon and check the revised principal.
Method. Accumulate the arrear, include the charge due now, and subtract the principal-reducing payment. Keep the separately paid fee out of the revised principal.
The arrear at the transaction date is \(400(1.01)=\$404\). The old obligation is therefore \(9{,}600+404+20=\$10{,}024\). After the $1,500 lump sum, the revised principal is \(10{,}024-1{,}500=\$8{,}524\). The $80 fee is an additional cash cost, not a financed amount.
At 0.75% monthly, \((1.0075)^9=1.069560839\). The revised principal accumulated to month 9 is \(8{,}524(1.069560839)=\$9{,}116.94\). The eight payments accumulated to month 9 have factor \(\big((1.0075)^9-1.0075\big)/0.0075=8.274778533\). Their accumulated value is \(900(8.274778533)=\$7{,}447.30\). Thus:
Transaction-date check. At the modification date, \(900a_{\overline{8}|}+1{,}669.64(1.0075)^{-9}=\$8{,}524.00\), to the nearest cent. The old obligation is accounted for by the $1,500 payment and the $8,524 replacement principal. The $80 fee is paid separately.
Mistake avoided. Adding the $80 cash fee to the replacement principal would wrongly treat an upfront cost as financed. If the agreement instead financed that fee, the revised principal would be $8,604 and the payment-and-balloon schedule would have to be recalculated.
Common Traps in Multi-Stage Loan Changes
Several errors recur when a problem combines old and new loan terms. A clean timeline is more reliable than trying to do all the arithmetic in one line.
- Using the new rate for old arrears. Accumulate each old obligation using the rate and convention specified for the old loan. Use the replacement rate only for cash flows under the revised loan.
- Ignoring the due date of an arrear. A payment due two periods earlier accumulates for two periods, while one due on the transaction date does not accumulate.
- Counting an installment twice. Check whether the quoted outstanding balance already includes unpaid installments before adding arrears.
- Misclassifying a fee. A financed fee increases the new principal; an upfront fee is a separate cash outflow.
- Discounting or accumulating from the wrong date. A transaction-date equation is valid only when every cash flow is valued at the same date and at the appropriate rate.
- Forgetting the balloon date. A balloon due one period after the final scheduled installment must be discounted or accumulated for that additional period.
For a revised schedule with payments \(C_k\) and a balloon \(B\) at period \(n\), the final check is to compare the revised principal with the discounted cash flows at the new rate. If the two sides differ beyond rounding, revisit the timeline, rate conversion, arrears, and fee treatment before accepting the result.
Check Your Understanding
For each problem, put all amounts on the stated transaction date and use the specified monthly effective rate. Round money to the nearest cent.
- A loan has principal of $5,000 at the transaction date. A $300 installment due one month earlier accumulates at 2% monthly, and a $10 charge is due now. The borrower pays $1,000 toward the obligation, with no financed fee. Find the revised principal. (Answer: $4,316.00)
- A replacement loan has principal of $10,200 and a monthly effective rate of 1%. It requires payments of $2,500 at the ends of months 1, 2, and 3, followed by a balloon at the end of month 4. Find the balloon. (Answer: $2,963.16)
- At a transaction date, principal is $12,000. Two installments of $400 are unpaid: one due two months earlier and one due one month earlier. Both accrue at 0.5% monthly. A $50 charge is due now, the borrower pays $1,000, and a $100 fee is financed. Find the revised principal. (Answer: $11,956.01)
- A replacement loan has principal of $8,000 at a 0.5% monthly effective rate. Four payments of $1,500 are due at the ends of months 1 through 4, with a balloon at the end of month 5. Find the balloon. (Answer: $2,126.63)