Tutorials › Exam FM - Financial Mathematics › Transaction-Date Value Equations for Loan Changes

Exam FM · Loan Changes and Refinancing · Tutorial 307 of 998

Transaction-Date Value Equations for Loan Changes

Set the value of the existing loan obligation equal to the transaction-date value of revised cash flows, and solve for a payment or balloon without mixing dates or interest bases.

Intermediate 12 min read

What You'll Learn

  • Define the transaction date and the interest basis used to value both sides of a loan change.
  • Write the existing obligation as a value at the modification date.
  • Include revised installments, immediate lump sums, and balloons at their correct times.
  • Move all cash flows to a common date to derive an equivalent value equation.
  • Solve for an unknown revised payment and check the equation using a second valuation date.
  • Avoid discounting a payment already made at the transaction date.

Why a Loan Change Needs a Value Equation

When a loan is modified, the parties may replace the remaining installments with a different payment pattern. The revised terms might include a payment on the modification date, new installments, or a final balloon. To compare these terms with the existing obligation, every amount must be valued at the same date using the same interest basis. Otherwise, the comparison can confuse a change in timing with a change in value.

This tutorial treats the value of the existing obligation at the transaction date as either given or as the present value of its remaining contractual payments under an explicitly stated basis. It then equates that value to the value of the revised payments. It does not assume that an accounting balance, a payoff quote, or a principal amount automatically equals this transaction-date value; the applicable agreement or problem statement must specify the amount and valuation basis.

Definition: A transaction-date value equation equates the value, at the loan modification date, of the existing obligation with the value at that same date of the revised cash flows. The equation must include every amount exchanged as part of the modification and must value all future payments on one consistent interest basis.

Let \(O_T\) denote the agreed value of the existing obligation at the modification date \(T\). If revised payments \(R_j\) are due \(t_j\) years after that date, and \(i\) is the effective annual rate used for the comparison, then the revised payments have transaction-date value \( \sum_j R_jv^{t_j} \), where \(v=1/(1+i)\). A payment at the transaction date has \(t_j=0\), so its value is the payment itself. A final balloon is simply another future payment, due at its stated time.

$$ O_T=\sum_j R_jv^{t_j}, \qquad v=\frac{1}{1+i}. $$

This form assumes that the stated effective annual rate applies consistently over the relevant periods, that the time measurements are expressed in years, and that the specified payments occur at the stated dates. If the problem instead supplies a transaction-date value directly, use that amount as \(O_T\); do not add the original scheduled payments again. Fees or other amounts exchanged at modification belong in the revised cash flows if they are part of the transaction.

Why Valuing at a Common Date Works

The equation is a statement of equivalence under the chosen interest basis, not a claim that the two payment schedules are identical. The justification is that equal amounts at one date remain equal when accumulated or discounted by the same factor. Thus, a transaction-date equation can be checked by moving every term to a later common date.

1
Choose the date and basis.
Set the modification date as time zero and identify the effective annual rate used to compare the obligations.
2
List each cash flow once.
Separate the existing obligation from the revised payments. Record whether each revised amount is paid immediately or at a future time.
3
Value both sides at the transaction date.
Discount each future revised payment by \(v^{t_j}\); do not discount a payment made at time zero.
4
Solve and verify.
Rearrange the equation for the unknown amount, then accumulate or discount both sides to another common date as a check.

To see the mathematical reason, suppose all cash flows occur no later than time \(n\). Accumulating a transaction-date equation to time \(n\) multiplies both sides by \((1+i)^n\). A payment \(R_j\) originally due at time \(t_j\) becomes \(R_j(1+i)^{n-t_j}\) at time \(n\). Therefore, equality at the transaction date gives equality at time \(n\) as well:

$$ O_T=\sum_jR_j(1+i)^{-t_j} \quad\Longrightarrow\quad O_T(1+i)^n=\sum_jR_j(1+i)^{n-t_j}. $$

The reverse implication also holds because \((1+i)^n\) is positive, so dividing an equality at time \(n\) by that factor returns the transaction-date equation. The key condition is that the same rate basis is used to value both sides. If a contract specifies different rates for different periods, each applicable period must be handled according to those terms; a single-rate formula cannot be used without justification.

Worked Examples

Worked Example: Replacing Two Installments With a Lump Sum and New Payments

At a loan modification date, the existing obligation is the two remaining payments of $550 one year from now and $605 two years from now. Use an effective annual interest rate of 10% to compare the existing and revised terms. The borrower proposes paying $200 immediately, followed by $440 at the end of year 1 and $484 at the end of year 2. Are the revised terms equivalent on this basis?

Method. Value each schedule at the transaction date. The effective annual rate is \(i=0.10\), so \(v=1/1.10\).

The existing obligation has value \(550v+605v^2\). Since \(v=1/1.10\) and \(v^2=1/1.21\),

$$ 550v+605v^2 =\frac{550}{1.10}+\frac{605}{1.21} =500+500 =1{,}000. $$

The revised payments have value

$$ 200+440v+484v^2 =200+\frac{440}{1.10}+\frac{484}{1.21} =200+400+400 =1{,}000. $$

The values are equal, so the proposed revised terms are equivalent under the specified 10% basis. As a check, accumulate both sides to the end of year 2. The existing payments accumulate to \(550(1.10)+605=1{,}210\). The revised amounts accumulate to \(200(1.21)+440(1.10)+484=242+484+484=1{,}210\).

Common mistake avoided: The $200 is paid on the transaction date, so it is not discounted. Treating it as if due one year later would give a revised value of \(200v+440v+484v^2=181.82+400+400=981.82\), which incorrectly changes its timing. The correct transaction-date value is $200.

Worked Example: Solving for a Balloon at the End of Year 3

The agreed value of an existing obligation at a modification date is $2,500. The revised terms call for payments of $600 at the end of year 1 and $600 at the end of year 2, plus a balloon \(B\) at the end of year 3. The comparison uses an effective annual interest rate of 8%. Find the balloon.

Method. Accumulate both sides to the end of year 3. This avoids separately rounding three discount factors. The existing obligation accumulates to

$$ 2{,}500(1.08)^3 =2{,}500(1.259712) =3{,}149.28. $$

The year-1 payment accumulates for two years: \(600(1.08)^2=600(1.1664)=699.84\). The year-2 payment accumulates for one year: \(600(1.08)=648\). The balloon is already due at the chosen common date, so its accumulated value is \(B\).

$$ 3{,}149.28=699.84+648+B, \qquad B=3{,}149.28-1{,}347.84=1{,}801.44. $$

The balloon is $1,801.44. Check by discounting the revised payments to the transaction date: \(600/1.08=555.555\ldots\), \(600/1.08^2=514.403\ldots\), and \(1{,}801.44/1.08^3=1{,}430.041\ldots\). Their sum is $2,500.00, to the nearest cent. The unrounded values sum to exactly $2,500.

Common mistake avoided: The balloon occurs at the end of year 3, not at the transaction date. It must either be discounted by \(v^3\) in a transaction-date equation or left undiscounted when both sides are accumulated to year 3.

Worked Example: Including an Immediate Payment in a Four-Year Restructuring

A lender and borrower agree that the existing obligation has a transaction-date value of $4,000. The revised arrangement requires $250 on the modification date, payments of $900 at the ends of years 1, 2, and 3, and a balloon \(B\) at the end of year 4. Use an effective annual rate of 5%. Find \(B\), rounding only the final answer to the nearest cent.

Method. Accumulate every amount to the end of year 4. At 5%, \((1.05)^2=1.1025\), \((1.05)^3=1.157625\), and \((1.05)^4=1.21550625\). The existing obligation becomes

$$ 4{,}000(1.05)^4=4{,}000(1.21550625)=4{,}862.025. $$

The immediate $250 accumulates for four years: \(250(1.21550625)=303.8765625\). The year-1 payment accumulates for three years: \(900(1.157625)=1{,}041.8625\). The year-2 payment accumulates for two years: \(900(1.1025)=992.25\). The year-3 payment accumulates for one year: \(900(1.05)=945\). The year-4 balloon remains \(B\).

$$ \begin{aligned} 4{,}862.025 &=303.8765625+1{,}041.8625+992.25+945+B,\\ B&=4{,}862.025-3{,}282.9890625\\ &=1{,}579.0359375. \end{aligned} $$

Rounded to the nearest cent, the balloon is $1,579.04. The check is that both sides accumulate to $4,862.025 at year 4 before rounding. In particular, the $250 is included once as a time-zero payment; it is not both subtracted from the existing obligation and included again among the future payments.

Common mistake avoided: Do not add the immediate payment to the year-1 payment as though both occur at the same time. Their accumulated values differ because the immediate amount earns interest for four years, while the year-1 amount earns interest for three.

Reading and Checking a Transaction-Date Equation

A useful first step is to make a timeline. Put the modification date at time zero, then mark each revised payment at its actual time. Separate amounts already due at the transaction date from future installments. The following table summarizes the value assigned to each type of revised cash flow under a constant effective annual rate \(i\).

Cash flowTime from modification dateTransaction-date value
Immediate lump sum \(L\)0\(L\)
Installment \(R\)\(t\) years\(Rv^t\)
Balloon \(B\)\(n\) years\(Bv^n\)
Several payments\(t_1,t_2,\ldots,t_k\)\(\sum_{j=1}^k R_jv^{t_j}\)

A balloon is not a special kind of value: it is a payment with a particular amount and due date. Likewise, an immediate fee or lump-sum prepayment belongs in the equation at time zero if it is exchanged as part of the modification. The equation describes equivalence under the stated comparison assumptions. It does not by itself establish whether a proposed change is legally permitted or whether a particular fee is appropriate.

Be especially careful when a problem gives both an original schedule and an existing obligation value. If the value is already specified at the modification date, that value is the left-hand side; the original schedule may explain how it was determined, but should not be counted a second time. When the existing obligation must instead be valued from its remaining payments, discount those payments to the modification date on the stated basis and then equate the result to the revised-payment value.

Common Exam Traps

  • Mixing valuation dates. Do not add a transaction-date lump sum directly to a future balloon without first moving both amounts to the same date.
  • Discounting an immediate payment. A payment at time zero has factor \(v^0=1\); it is not discounted.
  • Using inconsistent interest rates. Applying one rate to the old obligation and another to the revised cash flows does not produce a valid equivalence equation unless the problem explicitly defines such a comparison and specifies how each side is valued.
  • Using the wrong time unit. A payment due in two years uses \(v^2\), not \(v\). If dates are expressed in another unit, convert the time and rate consistently.
  • Counting a payment twice. A lump sum made at modification is one cash flow, whether it is described as a prepayment, fee, or immediate settlement amount.
Key takeaway: State the transaction date, identify the agreed value of the existing obligation, and place every revised payment at its actual time. Equate the two sides using one consistent interest basis, solve for the unknown, and verify by moving both sides to another common date.

Check Your Understanding

For each problem, use the stated effective annual rate and value the revised cash flows on the same basis as the existing obligation.

  1. An existing obligation is worth $1,000 at the modification date. At 5% effective annual interest, revised terms require $300 immediately, $400 at the end of year 1, and a balloon \(B\) at the end of year 2. Find \(B\). (Answer: $351.75)
  2. An existing obligation is worth $1,500 at the modification date. At 6% effective annual interest, the borrower pays $200 immediately and $500 at the end of year 1, followed by \(X\) at the end of year 2. Find \(X\). (Answer: $930.68)
  3. An existing obligation is worth $2,000 at the modification date. At 10% effective annual interest, revised terms are $100 immediately, $600 at the end of year 1, $700 at the end of year 2, and a balloon \(B\) at the end of year 3. Find \(B\). (Answer: $1,032.90)
  4. An existing obligation is worth $1,200 at the modification date. At 8% effective annual interest, revised terms are $300 immediately, $400 at the ends of years 1 and 2, and a balloon \(B\) at the end of year 3. Find \(B\). (Answer: $235.18)
  5. An existing obligation is worth $1,000 at the modification date. At 10% effective annual interest, the revised future payments are $500 at the end of year 1 and $605 at the end of year 2. What immediate payment \(L\) makes the revised terms equivalent? (Answer: $45.45)
Clinical Biostats