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

Why a refinance model should separate requested and supported loan amounts

A refinance gap analysis helps sponsors identify the difference between the loan amount they want and the amount a permanent lender can support based on the property's actual cash flow. This guide provides an evidence checklist and a concrete workpaper to prepare before approaching lenders.

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

A refinance gap analysis helps sponsors identify the difference between the loan amount they want and the amount a permanent lender can support based on the property's actual cash flow. This guide provides an evidence checklist and a concrete workpaper to prepare before approaching lenders.

Prepare a refinance gap workpaper

A refinance gap workpaper is a single document that lists the requested loan amount and the supported loan amount side by side, with each figure traced to its source. The requested amount is what you need to repay existing debt, cover closing costs, and fund any planned reserves or equity takeout. The supported amount is what the property's underwritten net operating income can carry under typical permanent loan tests.

To build the workpaper, start with the property's current rent roll and trailing twelve months of operating history. The rent roll is a snapshot of in-place leases and unit rents as of today. The trailing twelve months, often called a T-12, shows actual revenue and expenses for the past twelve calendar months. The two reports cover different periods, so do not compare totals directly without reconciling the timing difference. Record both the gross rent from the rent roll and the collected income from the T-12, then explain any variance in a short note.

Distinguish the cash flow layers

Permanent lenders underwrite the property's in-place cash flow, adjusted for vacancy, expenses, and reserves. The key layers are:

  • Gross rent: total scheduled rent from all occupied and vacant units or spaces.
  • Collected income: gross rent minus concessions, bad debt, and free rent periods.
  • Net operating income (NOI): collected income minus operating expenses, excluding debt service.
  • Debt service: annual principal and interest payments on the proposed loan.
  • Equity cash flow: NOI minus debt service, sometimes called cash flow after debt service.

Record each layer for the most recent twelve-month period and for the projected stabilized year. If the property is still leasing up, the trailing twelve months may show lower income than the rent roll suggests. Lenders underwrite based on in-place cash flow, and the sponsor should be prepared to explain any differences between the two reports. [1]

Identify the supported loan amount

The supported loan amount is the most restrictive result from three common tests:

  1. Maximum loan-to-value: multiply the appraised value by the lender's maximum LTV ratio.
  2. Minimum debt service coverage: divide the underwritten NOI by the annual debt service for the requested loan amount. If the result is below the lender's minimum, reduce the loan amount until the ratio meets the threshold.
  3. Minimum debt yield: divide the underwritten NOI by the loan amount. If the result is below the lender's minimum, reduce the loan amount until the yield meets the threshold.

Each test produces a maximum loan amount. The lowest of the three is the supported amount. Record each test result in the workpaper. If the requested amount exceeds the supported amount, the gap is the difference. [1]

Assess refinance risk with the gap

The OCC's commercial lending guidance identifies refinance risk as a concern for loans that leave a principal balance at maturity, especially in rising interest rate environments. If a borrower cannot refinance under current market conditions, a lender could be burdened with an underperforming or nonperforming loan.

A refinance gap analysis addresses this risk at the transaction level. When the requested amount exceeds the supported amount, the sponsor must either reduce the request, contribute additional equity, or accept a shorter-term or interest-only structure that increases the refinance risk at maturity. Lenders may stress-test the property's NOI under various scenarios to assess whether the supported amount changes. If the property cannot support the loan under stressed conditions, the lender may decline the request or require additional covenants or reserves.

Compare the gap across lender types

Different permanent lenders apply the three tests with different thresholds. Bank loans are often full or partial recourse, with shorter terms and more flexible prepayment. Life insurance company loans are typically lower leverage, longer term, and fixed rate. CMBS loans are typically non-recourse apart from customary carve-outs. Fannie Mae and Freddie Mac multifamily loans are typically non-recourse apart from customary carve-outs and are made through their approved lenders. [1]

Record the requested and supported amounts for each lender type in the workpaper. If a life insurance company's supported amount is lower than a bank's, the sponsor may need to choose between a smaller loan or a different lender. The workpaper helps the sponsor ask the actual lender for its specific thresholds rather than assume all lenders use the same tests.

Prepare the evidence checklist

The evidence checklist supports the workpaper with source documents. Lenders typically review the following items, and borrowers should be prepared to provide them:

  • Current rent roll with unit mix, lease start and end dates, rent amounts, and concessions.
  • Trailing twelve months of operating statements showing revenue, expenses, and NOI.
  • Reconciliation of the rent roll and T-12 totals with a written explanation of any differences.
  • Appraisal report with the appraiser's opinion of value and capitalization rate.
  • Property condition report and environmental assessment if available.
  • Sponsor's net worth and liquidity statement.
  • Business plan describing the hold period, exit strategy, and any planned capital improvements.

Each document should be current, typically within six to twelve months of the loan request. Older reports may require updates or a letter from the preparer confirming no material changes. [1]

Ask the actual lender for its tests

The workpaper and checklist prepare the sponsor for a productive conversation with lenders, not a guarantee of approval. Lenders set their own LTV, debt service coverage, and debt yield minimums based on their risk appetite and portfolio limits. The OCC notes that banks should have processes to identify, measure, monitor, and control refinance risk at both the transaction and portfolio levels.

When the sponsor presents the workpaper, the lender can see the gap and discuss options: a lower loan amount, additional equity, interest-only terms, or a different lender type. The sponsor should ask the lender for its specific underwriting thresholds and whether the property's cash flow supports the requested amount under those thresholds.

Frequently asked questions

What is the difference between a rent roll and a T-12?

A rent roll is a snapshot of current leases and rents as of today. A T-12 is a report of actual revenue and expenses for the past twelve months. The two cover different periods, so compare them by reconciling the timing difference rather than assuming they should match.

Does a refinance gap mean the loan will not close?

No. A gap means the requested amount exceeds the supported amount under the lender's tests. The sponsor can reduce the request, add equity, or choose a different lender with higher thresholds. The workpaper helps identify the gap before the lender does.

Who sets the LTV, debt service coverage, and debt yield minimums?

Each lender sets its own minimums based on its risk appetite, portfolio limits, and regulatory guidance. The sponsor should ask the actual lender for its specific thresholds rather than assume industry averages.


Submit your property, business plan, amount, and timing through the website to start a preliminary discussion. A 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