Yield Maintenance Calculator & Loan Prepayment Planner
Compare two authored full-prepayment scenarios under one fixed-rate note. Enter the remaining whole yield-maintenance months, unpaid principal, corresponding benchmark yield and the minimum premium that applies. See the signed yield-maintenance amount, the applied premium, and modeled payoff cash. The sensitivity view tracks the yield where the minimum starts to apply under the selected method.
Compare the yield amount and contract minimum
Enter the payoff balance, remaining whole months and contractual yield for two scenarios. Calculate the premium and see where the minimum starts to apply.
Set the shared note terms
Use the whole-month full-prepayment formula illustrated by Fannie Mae’s April 2003 note example. Enter the minimum applicable under your own note in both scenarios.
Applied to the entered principal. Enter zero only for a scenario without a minimum under the terms used.
Premium and modeled payoff cash
Applied premiums. Scenario A $556,982.37. Scenario B $240,044.51.
Scenario A
Applied prepayment premium
$556,982.37
Yield-maintenance amount applies
- Yield-maintenance amount
- $556,982.37
- Entered contract minimum
- $61,613.29
- Modeled payoff cash
- $6,718,311.37
- First whole-bp yield with minimum or tie
- 5.19%
Scenario B
Applied prepayment premium
$240,044.51
Yield-maintenance amount applies
- Yield-maintenance amount
- $240,044.51
- Entered contract minimum
- $60,000.00
- Modeled payoff cash
- $6,240,044.51
- First whole-bp yield with minimum or tie
- 4.97%
Modeled cash adds the premium, entered principal and other charges. Include any relevant interest or fees in other charges. The amounts depend on the contract inputs and values you enter.
Enter the two payoff scenarios
See when the minimum applies
Scenario A · cash scale from -$203,426.24 to $920,091.80. The dark marker shows the selected yield.
2.08% benchmark yield. $556,982.37 yield amount · $61,613.29 floor · $556,982.37 applied premium.
| Benchmark yield | Yield amount | Contract minimum | Applied premium |
|---|---|---|---|
| 0.00% | $920,091.80 | $61,613.29 | $920,091.80 |
| 2.08% | $556,982.37 | $61,613.29 | $556,982.37 |
| 5.18% | $62,945.35 | $61,613.29 | $62,945.35 |
| 5.19% | $61,436.09 | $61,613.29 | $61,613.29 |
| 5.60% | $0.00 | $61,613.29 | $61,613.29 |
| 7.00% | -$203,426.24 | $61,613.29 | $61,613.29 |
The sensitivity changes only the preview yield. The scenario results and export keep the entered assumptions.
Reconcile the calculation
Scenario A
Note rate less benchmark yield: 3.52 percentage points.
Present value factor for 32 months: 2.568174.
$6,161,329.00 principal + $556,982.37 premium + $0.00 other charges = $6,718,311.37 modeled payoff cash.
Scenario B
Note rate less benchmark yield: 2.50 percentage points.
Present value factor for 20 months: 1.600297.
$6,000,000.00 principal + $240,044.51 premium + $0.00 other charges = $6,240,044.51 modeled payoff cash.
Export terms and results
Save the entered terms, premium components, payoff cash and reference sensitivity yields.
Download yield maintenance CSVSelectable yield maintenance CSV copy
How to use this calculator
- Load the published full-prepayment example or Yield above the note rate. Enter the note rate and the minimum percentage used in both scenarios.
- Enter the unpaid balance, whole yield-maintenance months and applicable benchmark yield for each full payoff.
- Enter separate charges from your scenario, and verify yield amount, contractual minimum and applied premium.
- Select a scenario on the sensitivity chart and adjust the preview yield. Review the first whole-basis-point yield that produces the minimum or a tie.
- Reconcile the formula components, then download the CSV with the entered terms and reference sensitivities.
The Formula
The mathematical logic powering this calculation is:
Use the whole-month full-prepayment method shown in Fannie Mae’s published example for note versions as of April 2003. Enter the full unpaid principal balance, the contract’s benchmark yield and the remaining whole months for each scenario. This worksheet uses the same note rate and minimum percentage for both scenarios. Select the applicable method, remaining months, yield and minimum using the note. The worked example uses a 1% minimum.
Let c be the annual note rate as a decimal, r the entered annual benchmark yield as a decimal, n the remaining months and B the unpaid principal. The present value factor is [1 − (1 + r)^(−n/12)] ÷ r. If the note permits an entered zero yield, use the limiting factor n/12. Yield-maintenance amount = B × (c − r) × factor. The signed amount remains visible even when r is above c.
Minimum premium = B × entered minimum percentage. The applied premium is the greater of the two cash legs after rounding each to cents. Each amount rounds to the nearest cent with half cents away from zero. The discounted leg uses a stable floating-point exponential formula and the zero-yield case uses exact integer arithmetic. The discounted cash amount is a model estimate. If zero months are entered, the yield amount is zero and any entered minimum is still applied. Enter a zero minimum only for a scenario where the modeled terms set it to zero.
Modeled payoff cash = unpaid principal + applied premium + entered other payoff charges. You supply other charges, including accrued interest where relevant. The worksheet does not infer balances or charges from dates and does not select a loan’s yield source.
The sensitivity view holds principal, months, note rate and floor fixed. The floor boundary is the first nonnegative whole basis-point benchmark yield where the rounded yield amount is no greater than the rounded minimum. One basis point is 0.01 percentage point. The preview changes the benchmark yield for the chart and sampled table. It leaves scenario inputs, headline results and CSV reference samples intact.
Enter unpaid principal from $0.01 to $100,000,000. Enter other charges from $0 to $100,000,000 and remaining months from 0 to 360. The note rate is 0% to 40%, minimum rate 0% to 10% and benchmark yield 0% to 50%. Amounts accept up to two decimal places and rates up to four. Negative benchmark yields and other note versions are outside this model. The lender or servicer can provide the official payoff under the actual documents.Worked Example
If you input:
- Common note rate and minimum: 5.600% and 1%
- Scenario A principal, months and yield: $6,161,329.00, 32 months, and 2.080% (Fannie Mae published inputs)
- Scenario B principal, months and yield: $6,000,000.00, 20 months, and 3.10% (hypothetical)
- Other payoff charges: $0 in both scenarios
Result:
For Scenario A, the present-value factor is about 2.568174, and the note rate exceeds the entered yield by 3.52 percentage points. Yield maintenance is $556,982.37, which exceeds the $61,613.29 minimum. Modeled payoff cash is $6,718,311.37. Scenario B has a premium of $240,044.51 and modeled payoff cash of $6,240,044.51 under its separately entered assumptions.
Frequently Asked Questions
Does this work for every yield maintenance clause?
Use it when your full-prepayment clause follows the whole-month formula illustrated by the published example. Other provisions can use different yield sources, dates, day counts, minimums or methods.
Should I use the loan maturity date to calculate remaining months?
Use the remaining whole yield-maintenance months specified by your documents. The end of the yield-maintenance period can differ from loan maturity.
Why does the signed yield amount become negative?
The yield amount includes the note rate minus the entered benchmark yield. That spread turns negative above the note rate. The model then applies the nonnegative entered minimum.
What happens when there are zero remaining months?
The modeled yield amount is zero. The entered minimum remains part of the comparison, including a zero minimum if that is what applies under the terms you are using.
What yield should I enter?
Use the benchmark value and convention called for by your note, or enter a hypothetical value for sensitivity. The worksheet has no market feed and does not select a security, publication or observation date.
Does a lower payoff cash estimate mean an earlier payoff is cheaper?
The displayed cash uses the entered balance, fees and yield for each scenario. Payments between the dates, other opportunity costs and refinancing terms require a separate comparison.
Similar Calculators
Loan Amortization Schedule Calculator
Build a payment-by-payment loan amortization schedule with extra payments and total interest savings.
DSCR Loan Calculator
Compare DSCR loan capacity, LTV limits, interest-only payment changes and balloon repayments across property-income scenarios. Inspect schedules and export the full plan.
Commercial Interest Rate Cap Calculator & Cash Planner
Compare floating loan interest with an entered cap premium and strike. Project cap settlements, mismatched notionals and premium recovery across two rate scenarios.
Mortgage Discount Points Calculator
Compare mortgage points and lender credits across multiple quotes. Visualize payment savings, remaining debt, holding-period costs and discounted break-even paths.
