Can I Afford This Property?Commercial real estate financing, worked out

How to update a refinance model after receiving a new payoff quote

A practical guide for sponsors to compare a new payoff quote against their existing underwriting model, identify gaps in debt service coverage, leverage, and liquidity, and prepare a refinance package that addresses lender concerns about refinance risk.

Source: CodexTopic: Refinance gap analysis1259 wordsUpdated 2026-11-19

A practical guide for sponsors to compare a new payoff quote against their existing underwriting model, identify gaps in debt service coverage, leverage, and liquidity, and prepare a refinance package that addresses lender concerns about refinance risk.

Introduction: why a new payoff quote changes your refinance model

A payoff quote from your existing lender states the exact amount needed to retire the current loan, including principal, accrued interest, prepayment penalty or yield maintenance, and any fees. That number is rarely the same as the original loan balance. Once you have it, your refinance model must be updated because the new loan must cover that payoff amount, plus any closing costs, reserves, or capital improvements you plan to include. The updated model becomes the basis for showing a prospective lender that the property can support the new debt.

Step 1: record the payoff components and compare with your original assumptions

Your old model probably assumed a simple principal balance. The payoff quote will break out several items: unpaid principal, per diem interest through the closing date, any prepayment premium (yield maintenance, defeasance cost, or step-down penalty), and lender or legal fees. Record each component separately. Then compare the total payoff to what you had in your original sources-and-uses table. If the payoff is higher than expected, the new loan request must increase by that difference, which will affect debt service coverage and loan-to-value.

Step 2: rebuild the debt service coverage calculation with the new loan size

Permanent lenders typically size a loan with several tests at once: a maximum loan-to-value, a minimum debt service coverage ratio (the lender's underwritten net operating income or net cash flow divided by annual debt service) and, often, a minimum debt yield (underwritten net operating income divided by the loan amount). The most restrictive test generally sets the maximum loan amount [1].

To update your model, take the new requested loan amount (payoff plus costs) and estimate annual debt service at the quoted interest rate and amortization period. Divide your underwritten net operating income by that annual debt service. If the ratio falls below a threshold the lender considers acceptable, you have a coverage gap. The same new loan amount affects debt yield: divide underwritten NOI by the new loan amount. A declining debt yield signals higher leverage and may push the loan outside a lender's policy.

Step 3: check the loan-to-value test with the updated payoff

The new payoff quote may change your requested loan amount enough to push loan-to-value above a lender's maximum. Obtain a current appraised value or use the most recent third-party appraisal. Divide the new requested loan amount by that value. If the ratio exceeds the lender's stated maximum, the loan request must be reduced, which means you will need additional equity or a different source for closing costs.

Step 4: identify whether refinance risk has increased

Refinance risk is the risk that borrowers will not be able to replace existing debt at a future date under reasonable terms and prevailing market conditions. Refinance risk increases in rising interest rate environments and can be amplified by large volumes of loans set to mature in underperforming markets .

When you update your model with the new payoff, you are essentially stress-testing the borrower's ability to meet refinancing requirements if the borrower's financial condition declines or market conditions deteriorate (e.g., interest rates increase, market terms tighten, expenses increase, or collateral values fall) . Record the following borrower-specific factors that affect refinance risk: high leverage, constrained liquidity, a significant volume of near-term maturities, poor financial performance, or unpopular market sentiment . If any of these apply, the updated model should include a sensitivity analysis showing debt service coverage at a higher interest rate (e.g., 200 basis points above the quoted rate).

Step 5: prepare a refinance package that addresses the gaps

A prudent assessment of refinance risk includes a borrower's refinancing needs, the performance of the underlying project or asset, the timing of a refinancing transaction (e.g., maturity), the amount and maturity dates of other debt, current market liquidity, and the cost of refinancing . Your updated model should be accompanied by:

  • A current rent roll (snapshot of in-place rents and occupancy)
  • A trailing twelve months (T-12) operating statement showing historical income and expenses
  • A reconciliation of the rent roll to the T-12, explaining any difference between gross rent potential and collected income
  • A calculation of net operating income (NOI), capital expenditures, debt service, and equity cash flow
  • The sponsor's net worth and liquidity statement
  • Third-party reports: appraisal, property condition, and environmental [1]

Do not equate a cap rate with a debt constant. The cap rate is used to value the property; the debt constant is the annual debt service divided by the loan amount. They measure different things and should not be compared directly.

Step 6: ask the actual lender about underwriting standards

The tools to monitor refinance risk should be tailored to the bank's size, complexity, risk profile, and types of lending . While you can prepare a model using common benchmarks, only the lender can confirm its specific minimum debt service coverage, maximum loan-to-value, and minimum debt yield. Include in your package a clear statement of the requested loan amount, term, amortization, interest rate type (fixed or floating), and prepayment terms. Permanent lenders differ on term, amortization, interest-only periods, recourse, prepayment, and whether the loan can be assumed by a buyer [1].

Step 7: prepare a worksheet to compare quotes side by side

When you receive multiple payoff quotes or lender term sheets, create a worksheet that compares:

  • Total payoff amount (broken out by component)
  • New loan amount requested
  • Interest rate and type (fixed or floating)
  • Amortization period and interest-only period
  • Annual debt service
  • Underwritten NOI
  • Debt service coverage ratio
  • Loan-to-value ratio
  • Debt yield
  • Prepayment terms (yield maintenance, defeasance, step-down, or open)
  • Recourse vs. non-recourse (with carve-outs)
  • Reserve requirements
  • Lender fees and third-party costs

This worksheet allows you to identify which lender's terms produce a feasible structure and which gaps remain.

FAQs

How do I reconcile the rent roll to the T-12 when updating my model?

The current rent roll is a snapshot of today's in-place rents and occupancy. The T-12 is twelve historical months of income and expenses. To reconcile, compare the rent roll's gross rent potential to the T-12's gross collected income. The difference is typically due to vacancy, concessions, bad debt, or timing. Explain each variance in a short narrative. Then calculate NOI from the T-12, adjust for known changes (e.g., a new lease at higher rent), and use that adjusted NOI in your debt service coverage calculation.

What if the updated debt service coverage falls below a lender's threshold?

A coverage gap means the property's income may not support the requested loan. Options include: reducing the loan amount (and bringing additional equity), extending the amortization period (if the lender allows), negotiating a lower interest rate, or improving NOI through rent increases or expense reductions. Present the gap to the lender along with your proposed remedy. The lender may accept a lower coverage ratio if other factors (low leverage, strong sponsor, long-term fixed rate) mitigate refinance risk.

Does a higher payoff always mean the loan request must increase?

Not necessarily. If the payoff is higher than expected, you can reduce other uses (closing costs, reserves, capital improvements) to keep the total loan request the same. Alternatively, you can contribute additional equity to cover the difference. The updated model should show the revised sources and uses so the lender can see that the borrower is not simply increasing leverage.

Model this deal and request financing

Run a refinance model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.

Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.

Open the refinance model

Talk through your financing

Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. Wraith permanent loans