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

Reconciling an existing payoff statement with a refinance model

A practical guide to comparing your current loan's payoff requirements with a proposed permanent loan structure, including a concrete workpaper to identify gaps in debt service coverage, prepayment costs, and timing.

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

A practical guide to comparing your current loan's payoff requirements with a proposed permanent loan structure, including a concrete workpaper to identify gaps in debt service coverage, prepayment costs, and timing.

When refinancing a commercial property, the existing payoff statement and the proposed permanent loan model must be reconciled to avoid surprises at closing. This guide provides a step-by-step approach to compare the two documents, identify discrepancies, and prepare for lender underwriting.

Comparing the payoff statement and the refinance model

Start by obtaining the current lender's payoff statement, which shows the outstanding principal balance, accrued interest, prepayment penalty (if any), and any other fees required to release the lien. Then, prepare a refinance model that estimates the new loan amount, terms, and monthly payments. The key is to reconcile the total funds needed to pay off the old loan with the proceeds from the new loan. This includes comparing the payoff amount to the new loan's maximum allowable amount based on loan-to-value and debt service coverage tests [1].

Identifying prepayment penalties and exit costs

Prepayment terms on the existing loan can significantly affect the net proceeds available for refinancing. If the current loan has yield maintenance or defeasance provisions, the cost to exit early may be substantial [1]. Record the exact prepayment penalty from the payoff statement and compare it to any prepayment terms on the new loan. This comparison helps determine whether refinancing makes financial sense and whether the new loan's terms are more favorable for your hold period.

Reconciling debt service coverage between loans

Permanent lenders often size a loan using a minimum debt service coverage ratio, among other tests, as described in S2. To reconcile, calculate the DSCR for both the existing loan and the proposed loan using the same NOI figure. If the new loan's DSCR is lower than the lender's minimum, the lender may adjust the loan amount or require additional equity, but this is not specified in S2. This step is critical because refinance risk increases when borrowers cannot service debt at higher interest rates .

Adjusting for timing differences in income and expense reports

The payoff statement reflects a snapshot of the loan balance as of a specific date, while the refinance model uses historical income and expense data. A current rent roll shows present occupancy and rents, while a trailing twelve-month (T-12) report shows actual collections over the past year [1]. Reconciling these requires adjusting for timing: the T-12 may include periods when the property was leasing up or had higher vacancy. Compare gross rent, collected income, NOI, capital expenditures, debt service, and equity cash flow separately to ensure the refinance model reflects the property's stabilized performance.

Preparing a refinance gap analysis workpaper

Create a simple spreadsheet or table with the following columns: existing loan payoff amount, prepayment penalty, total funds needed to close, new loan amount (based on LTV and DSCR tests), equity required, and net cash to borrower. Then, list the property's NOI, proposed annual debt service, and DSCR for both loans. This workpaper helps you identify whether the new loan covers the payoff and whether the property's income supports the new debt. It also highlights any shortfall that may require additional equity or a different loan structure.

Asking the actual lender about underwriting assumptions

No guide can replace direct communication with the lender. Use the workpaper to ask specific questions: What NOI figure is being used? What vacancy and expense assumptions are applied? Is the DSCR based on net operating income or net cash flow? What is the maximum loan-to-value and minimum debt yield? These questions help you understand how the lender's model differs from your own and where adjustments may be needed [1]. The OCC guidance emphasizes that banks should assess refinance risk during underwriting and ongoing monitoring .

Reconciling the sponsor's financial position

Lenders also evaluate the sponsor's net worth, liquidity, and track record [1]. If the refinance model shows a gap, the sponsor may need to contribute additional equity or provide a guarantee. Record your available liquidity and net worth, and compare them to the lender's requirements. This step is especially important if the existing loan is recourse and the new loan is non-recourse, or vice versa, as the shift in liability affects the sponsor's risk.

Frequently asked questions

What is the most important number to reconcile between the payoff statement and the refinance model? The total funds needed to close, which includes the payoff amount, prepayment penalty, accrued interest, and closing costs. This must be less than or equal to the new loan proceeds plus any equity you contribute.

How do I handle a prepayment penalty that makes refinancing uneconomical? Consider waiting until the penalty period expires, or negotiate with the current lender for a waiver. Some lenders may allow a partial prepayment or a loan modification that avoids the penalty. Always ask the current lender directly about options.

What if the new loan's debt service coverage is below the lender's minimum? You may need to reduce the loan amount, increase equity, or improve the property's NOI through rent increases or expense reductions. The lender may also accept a higher interest rate or a shorter amortization period to improve coverage.


To get started, share the property details, your business plan, the desired loan amount, and your target timeline. Submit your request through the website to begin the process. Submission is a preliminary request, not an engagement or lender submission.

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