Comparing a requested refinance loan with several rate assumptions
A guide to preparing a refinance gap analysis worksheet that compares current loan terms, projected exit conditions, and several rate scenarios. Includes a concrete evidence checklist and instructions for distinguishing OCC guidance from borrower assumptions.
A guide to preparing a refinance gap analysis worksheet that compares current loan terms, projected exit conditions, and several rate scenarios. Includes a concrete evidence checklist and instructions for distinguishing OCC guidance from borrower assumptions.
What refinance gap analysis is and why it matters
Refinance gap analysis is a tool to test whether a property's projected income can support a new loan under several interest rate assumptions before you approach lenders. The OCC defines refinance risk as the risk that borrowers will not be able to replace existing debt at a future date under reasonable terms and prevailing market conditions . For a sponsor with a maturing loan, this analysis helps identify which rate scenarios create a debt service shortfall and which assumptions need to be tested against real lender quotes.
Prepare a refinance gap analysis worksheet
Create a single-page worksheet with the following sections. Record actual numbers from your current loan and property operating statement; do not estimate.
Current loan terms
- Original loan amount
- Current outstanding principal balance
- Maturity date
- Current interest rate and whether fixed or floating
- Current monthly or annual debt service (principal and interest)
- Any prepayment penalty, yield maintenance, or defeasance terms [1]
Property operating history (trailing 12 months)
- Gross potential rent
- Vacancy and collection loss (expressed separately; note that vacancy and collection loss is not effective gross income)
- Effective gross income (collected income after vacancy and collection loss)
- Operating expenses (itemized: taxes, insurance, utilities, management, repairs, reserves)
- Net operating income (NOI), calculated as effective gross income minus operating expenses (excluding debt service)
- Capital expenditures incurred (non-operating expenses for major repairs or improvements)
- Debt service paid (principal and interest payments)
- Net cash flow to equity, calculated as NOI minus debt service and capital expenditures
Underwritten net operating income (stabilized year)
- Projected stabilized occupancy percentage
- Projected effective gross income
- Projected operating expenses (include replacement reserves)
- Projected net operating income
Rate assumption scenarios
Test several interest rate assumptions reflecting current market conditions and potential variations. For each scenario, calculate: - Estimated loan amount based on the lender's actual loan-to-value test or the sponsor's documented assumption - Estimated annual debt service using the assumed interest rate and loan amortization terms - Debt service coverage ratio calculated as the underwritten net operating income divided by the annual debt service, using the lender's required minimum coverage ratio as a benchmark - Debt yield calculated as the underwritten net operating income divided by the loan amount - Surplus or shortfall compared to the current debt service, expressed in qualitative terms rather than specific amounts
How the analysis affects the financing discussion
Permanent lenders typically size a loan using multiple underwriting tests simultaneously: a maximum loan-to-value ratio, a minimum debt service coverage ratio, and often a minimum debt yield [1]. The most restrictive of these tests generally determines the maximum loan amount [1]. Use your worksheet to identify which rate assumptions cause the debt service coverage ratio to fall below the lender's required minimum for your property type and market. Consult the lender directly to confirm their specific underwriting criteria.
Distinguish OCC guidance from borrower assumptions
The OCC bulletin provides supervisory guidance for banks on managing refinance risk, not rules that bind every borrower or nonbank lender . Key points to understand: - The OCC identifies external factors that affect refinance risk: investor risk appetite and market liquidity; the current interest rate environment; inflation; or supply chain effects on the costs of goods, services, or labor . These are factors you should monitor, not predict. - The OCC notes that refinance risk primarily affects loans with principal balances remaining at maturity and borrowers who rely on recurring debt to finance their capital structure or business operations . If your loan has a balloon payment, this applies directly. - The OCC encourages banks to work proactively and prudently with borrowers who are, or may be, unable to meet their contractual payment obligations during periods of financial stress . This does not guarantee that your lender will offer a workout.
Evidence checklist for the refinance gap analysis
Before you submit a financing request, gather these documents: - Current promissory note and loan agreement (to confirm prepayment terms, maturity date, and any covenants) - Trailing 12-month operating statement (T-12) showing actual income and expenses by month; specify whether the T-12 is on a cash or accrual basis and distinguish historical reporting from actual collections - Current rent roll (a snapshot of in-place tenants, lease terms, and rents) - Year-to-date operating statement - Prior two years of tax returns for the property (Schedule E if applicable) - Appraisal or broker price opinion (if available) - Environmental report (Phase I or Phase II, if required by lender) - Property condition report (if required by lender) - Sponsor financial statement (balance sheet, liquidity, net worth)
Reconcile timing differences in operating reports
The current rent roll is a snapshot of today's occupancy and rents. The T-12 shows twelve historical months of actual income and expenses [1]. These two reports may not match because the rent roll reflects current terms while the T-12 includes periods when vacancy or rents were different. When comparing totals, note the date of each report and explain any material differences (for example, a lease-up period included in the T-12 that is now complete). Remember that the rent roll reflects current contractual rents and occupancy, while the T-12 reflects historical performance on a cash or accrual basis.
Distinguish income and expense line items
- Gross rent: total scheduled rent before vacancy and collection loss
- Collected income: gross rent minus vacancy and collection loss; note that vacancy and collection loss is not effective gross income but a deduction from gross rent
- Net operating income (NOI): effective gross income minus operating expenses (excluding debt service)
- Capital expenditures (capex): major repairs or improvements that are not operating expenses
- Debt service: principal and interest payments on the loan
- Equity cash flow: NOI minus debt service and capital expenditures
Three common questions about refinance gap analysis
What if my property's NOI is lower than the debt service at every rate assumption?
That indicates a refinance gap. You should discuss options with your current lender about a possible extension or modification before the maturity date. The OCC encourages banks to work proactively and prudently with borrowers who are, or may be, unable to meet their contractual payment obligations during periods of financial stress . You may also explore whether alternative loan structures, such as longer amortization or interest-only periods, could address the gap.
Do I need to prepare a new appraisal for this analysis?
Not for the worksheet itself. You can use the most recent appraisal or broker price opinion to estimate the property value. The lender will order its own appraisal if you proceed to a term sheet [1].
How often should I update the refinance gap analysis?
Update the worksheet whenever market interest rates change significantly or when the property's occupancy or net operating income changes materially. The OCC notes that refinance risk increases in rising interest rate environments , so more frequent updates may be prudent during such periods.
Suggested next step
Submission is a preliminary request and does not constitute an engagement or lender submission. The website provides the call to action.
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.
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.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).