Tracking Net Principal Exposure During the Loan

Why Track Net Principal Exposure?

A borrower with a sinking fund may owe principal under a loan contract while also holding an asset intended to provide money for repayment. These amounts answer different questions. The contractual loan balance measures the principal still owed to the lender. A net principal exposure measure also recognizes the value accumulated in the fund. A fund deposit can reduce the borrower’s net exposure without reducing the principal legally owed.

The distinction matters whenever the loan and fund are tracked side by side. For example, a borrower may still owe a fixed principal amount on a bullet loan even after several years of deposits. The fund may cover part—or eventually all—of that principal, but it does not become a principal repayment unless the loan terms say that it does.

Definition: At a specified date, net principal exposure is the outstanding loan principal less the value of the sinking-fund asset available at that date. If $B_k$ is the contractual principal outstanding and $F_k$ is the fund value at time $k$, then $N_k=B_k-F_k$. A positive $N_k$ is an unfunded net principal amount; a negative $N_k$ indicates a fund surplus relative to principal.

This is an analytical comparison, not automatically a legal or accounting offset. Unless the contract explicitly permits it, a lender’s claim remains the contractual loan balance, not that balance minus the borrower’s separate fund. The calculations below assume the fund is available at its accumulated value, with no withdrawal charges, taxes, transaction costs, or restrictions. They also exclude accrued but unpaid interest and fees from net principal exposure.

Tracking the Two Balances

Use a consistent valuation date for both amounts. Let $B_0$ be the initial loan principal, $F_0$ the initial fund balance, and $D_k$ a fund deposit made at the end of period $k$. If the fund earns an effective rate $j$ per period, and deposits are made at period-end, its recurrence is $F_k=F_{k-1}(1+j)+D_k$. A deposit at the end of the period does not earn interest during that period.

For the loan, let $C_k$ be a scheduled principal repayment made at the end of period $k$. If loan interest is paid as it falls due rather than added to principal, the outstanding principal follows $B_k=B_{k-1}-C_k$. In a bullet loan, there are no principal repayments before redemption, so $C_k=0$ and $B_k=B_0$ until the redemption date.

F_k=F_0(1+j)^k+\sum_{t=1}^{k}D_t(1+j)^{k-t}, \qquad B_k=B_0-\sum_{t=1}^{k}C_t, \qquad N_k=B_k-F_k

The fund formula assumes a constant effective rate $j$ per period. The final deposit, $D_k$, has exponent zero because it is made at the valuation date. If the fund yield changes, each deposit must instead be accumulated using the rates that apply over the periods after that deposit. Likewise, if loan interest is capitalized rather than paid, the simple balance formula for $B_k$ does not apply; the capitalized interest must be included in the contractual balance.

Why the Net-Exposure Formula Works

At each period-end, the fund starts with $F_{k-1}$. It earns $jF_{k-1}$ over the period, then receives the deposit $D_k$. Thus its new value is the old value plus earnings plus the deposit. Meanwhile, a principal repayment $C_k$ reduces the loan balance, while interest paid separately does not change principal.

F_k=F_{k-1}+jF_{k-1}+D_k

Subtract the updated fund from the updated loan balance. This shows how net exposure changes: a principal repayment reduces it, while fund earnings and deposits also reduce it. In particular, a fund deposit reduces net exposure but does not reduce $B_k$.

\begin{aligned} N_k &=B_k-F_k\\ &=(B_{k-1}-C_k)-\bigl(F_{k-1}+jF_{k-1}+D_k\bigr)\\ &=N_{k-1}-C_k-jF_{k-1}-D_k \end{aligned}

This period-by-period result is useful as a check on a balance calculation. For a bullet loan, $C_k=0$: net exposure falls by the fund’s interest earnings and the new deposit, even though the contractual principal stays constant. For a loan with principal repayments, both the repayments and the fund’s growth contribute to the decline in net exposure.

Worked Example: A Bullet Loan With a Fully Accumulated Fund

A borrower has a hypothetical $33,100 bullet loan. The loan rate is 8% effective annually, and the borrower pays interest annually without reducing principal. At each year-end, the borrower deposits $10,000 into a sinking fund earning 10% effective annually. Find the contractual balance, fund value, and net principal exposure immediately after each of the first three deposits.

Method. Keep the bullet loan balance separate from the fund accumulation. The loan interest is $0.08(33{,}100)=\$2{,}648$ each year, paid separately, so it does not change the principal. Use $F_k=1.10F_{k-1}+10{,}000$, with $F_0=0$.

After year 1. The deposit is made at the valuation date, so it earns no fund interest yet. The fund is $F_1=1.10(0)+10{,}000=\$10{,}000$. The loan balance is $B_1=\$33{,}100$, and net exposure is $N_1=33{,}100-10{,}000=\$23{,}100$.

After year 2. The year-1 fund earns $0.10(10{,}000)=\$1{,}000$. Add the second deposit: $F_2=10{,}000+1{,}000+10{,}000=\$21{,}000$. The loan balance remains $B_2=\$33{,}100$, so $N_2=33{,}100-21{,}000=\$12{,}100$.

After year 3. The year-2 fund earns $0.10(21{,}000)=\$2{,}100$. After the third deposit, $F_3=21{,}000+2{,}100+10{,}000=\$33{,}100$. Thus $B_3=\$33{,}100$ and $N_3=33{,}100-33{,}100=\$0$.

Check. The fund exactly matches principal after the third deposit, as intended by the data. The contractual balance is still $33,100 at that date; only redemption under the loan contract would discharge the debt. The common mistake to avoid is subtracting a deposit from the loan balance as if it were a principal repayment.

When the Loan Also Has Principal Repayments

Some arrangements reduce the loan principal directly while also accumulating a separate fund. In that case, do not assume that the initial principal remains outstanding. First calculate the contractual balance using the principal repayments actually applied to the loan. Then calculate the fund at the same date and subtract the fund value from that balance.

Worked Example: Principal Repayments Alongside Fund Deposits

A hypothetical $80,000 loan has a 6% effective annual rate. The borrower pays each year’s interest separately and repays $10,000 of principal at the end of each of the first two years. In addition, the borrower deposits $5,000 into a separate fund at each year-end. The fund earns 4% effective annually and starts at zero. Find the loan balance, fund value, and net principal exposure immediately after the second-year deposit.

Method. Calculate interest on the principal outstanding during each year, reduce principal only by the stated repayment, and accumulate the fund separately. In year 1, loan interest is $0.06(80{,}000)=\$4{,}800$; after the $10,000 principal repayment, $B_1=80{,}000-10{,}000=\$70{,}000$. In year 2, interest is $0.06(70{,}000)=\$4{,}200$; after the next repayment, $B_2=70{,}000-10{,}000=\$60{,}000$.

The year-1 fund deposit earns $0.04(5{,}000)=\$200$ during year 2. The year-2 deposit is made at the valuation date, so $F_2=5{,}000+200+5{,}000=\$10{,}200$. The net principal exposure is $N_2=60{,}000-10{,}200=\$49{,}800$.

Check. The loan balance fell by $20,000 through repayments, while the fund grew by $10,200. Their combined effect reduced net exposure from $80,000 to $49,800. The common mistake is to subtract only the fund from the original $80,000 and overlook the principal repayments already made.

Valuation Timing and Fund Surpluses

The date of a deposit matters. A fund balance immediately before a deposit differs from its balance immediately after that deposit, even though the contractual loan balance may be identical at both instants. If a date falls between deposits, accumulate only the deposits already made and apply the fund yield for the elapsed time since each one. State whether a value is before or after a scheduled deposit whenever timing could affect the answer.

A negative net exposure is also possible. It means the assumed fund value exceeds the outstanding principal. It does not mean that the lender owes the borrower the difference: access to the fund and the treatment of any surplus depend on the contract. For the calculation, a negative result simply identifies that the fund exceeds the principal amount being compared.

Worked Example: Measuring Exposure Before the Next Deposit

A hypothetical $50,000 bullet loan charges 7% effective annual interest, paid annually without reducing principal. A separate fund starts with $4,000 and earns 5% effective annually. The borrower deposits $8,000 at the end of each of years 1 and 2. Find net principal exposure at the end of year 3, immediately before the year-3 deposit.

Method. Accumulate the initial fund balance for all three years. Accumulate the year-1 deposit for two years and the year-2 deposit for one year. No year-3 deposit is included because the valuation is immediately before it.

The initial $4,000 grows to $4{,}000(1.05)^3=\$4{,}630.50$. The year-1 deposit grows to $8{,}000(1.05)^2=\$8{,}820$. The year-2 deposit grows to $8{,}000(1.05)=\$8{,}400$. Therefore, immediately before the next deposit, $F_3=4{,}630.50+8{,}820+8{,}400=\$21{,}850.50$.

The loan’s annual interest payment is $0.07(50{,}000)=\$3{,}500$, but it is paid separately and does not change principal. Thus $B_3=\$50{,}000$, and $N_3=50{,}000-21{,}850.50=\$28{,}149.50$. Immediately after a year-3 deposit of $8,000, the fund would instead be $29,850.50 and net exposure would be $20,149.50.

Check. The before-deposit and after-deposit exposures differ by exactly $8,000, the deposit amount. The common mistake is to include the year-3 deposit in a value specified as immediately before that deposit.

Common Mistakes and a Practical Check

Net principal exposure is straightforward to calculate once the loan and fund are kept distinct. The main errors arise from using the wrong balance or the wrong date.

Treating a fund deposit as a loan repayment. Subtract deposits from $F_k$ through fund accumulation; subtract only contractual principal repayments from $B_k$.
Using the initial loan principal at every date. This works for a bullet loan before redemption, but not when scheduled repayments have reduced principal.
Giving a deposit a full period of interest when it is made at period-end. A period-end deposit has exponent zero at that date.
Mixing valuation dates. Compare the fund and loan at the same instant, and note whether a deposit has occurred.
Calling net exposure the amount legally owed. The contractual balance remains the loan principal owed under the agreement; the fund is a separate asset unless the terms provide otherwise.

A reliable calculation therefore has three checks: identify the contractual principal balance at the chosen date; accumulate only the fund amounts that exist by that date; and subtract those two values in the order $B_k-F_k$. If the result is negative, report a fund surplus relative to principal rather than changing the sign convention.

Check Your Understanding

For each problem, calculate at the date specified and distinguish the loan principal from the fund asset.

A $72,000 bullet loan has a separate fund earning 4% effective annually. Deposits of $15,000 are made at the end of each of years 1 and 2. Find net principal exposure immediately after the year-2 deposit. (Answer: $41,400)
A $90,000 loan has interest paid separately and principal repayments of $12,000 at the end of each of the first three years. A fund starts at $2,000 and earns 5% effective annually, with $5,000 deposited at each year-end. Find net principal exposure immediately after the third deposit. (Answer: $35,922.25)
A $120,000 bullet loan has a fund that starts at $10,000, earns 6% effective annually, and receives $20,000 deposits at the end of years 1 and 2. Find exposure immediately after the year-2 deposit. (Answer: $67,564)
A $100,000 loan has interest paid separately and principal repayments of $15,000 at the end of year 1 and $20,000 at the end of year 2. A zero-balance fund earns 8% effective annually and receives $10,000 at each of those year-ends. Find exposure immediately after the second deposit. (Answer: $44,200)
A $30,000 bullet loan has a fund starting at $5,000, earning 10% effective annually, with $15,000 deposited at each of the first two year-ends. Find net principal exposure immediately after the second deposit and interpret its sign. (Answer: $-\$7,550$, a fund surplus of $7,550 relative to principal)

What You'll Learn