Commercial Real Estate Refinance Analysis: Modeling a Loan Maturity Before It Arrives

Why commercial real estate refinance analysis starts with a re-underwrite

It is a Tuesday in the quarter your loan matures, and the lender's term sheet for the replacement loan has just landed. The new proceeds figure is lower than the balance you owe. Your partners want to know whether this is a rounding issue or a capital call, and your original underwriting file cannot answer, because it priced the property at closing and never re-sized the debt.

That is the core problem with maturity planning. The balance you owe is a fixed number, but the loan you can get is the output of constraints that move with rates, NOI and valuation. A maturing loan is a fresh credit decision made under today's conditions, not a renewal of yesterday's.

The scale of the issue is large and rising. Industry lenders and data providers have been tracking a heavy volume of commercial mortgages coming due across the next several years, and the exact figures differ by publisher. We don't print an unsourced number here; for your own planning, confirm the current maturity estimate with the primary publisher.

This walkthrough shows how to run commercial real estate refinance analysis before the maturity date: re-size the new loan on three constraints, measure any equity gap, and compare the result against a sale.

Step one: re-size the new loan on three constraints

Lenders size a refinance on several tests at once, and the smallest answer wins. The three that matter most are debt service coverage, loan-to-value and debt yield. Your model should compute all three side by side and flag the binding one.

• DSCR is NOI ÷ annual debt service. Rearranged, the maximum annual debt service is NOI ÷ the minimum DSCR, and the maximum loan is that debt service divided by the loan constant (annual payment per dollar borrowed). Our walkthrough of DSCR in real estate covers the definition, and the max loan amount by DSCR piece covers the algebra.
• LTV is loan ÷ value. Maximum loan is the maximum LTV times the value the lender will accept, which typically comes from an appraisal at a cap rate they choose, not the one you underwrote.
• Debt yield is NOI ÷ loan. Maximum loan is NOI ÷ the minimum debt yield. It ignores rate and amortization entirely, which is why it tends to bind when rates are high.

For the full sizing logic across all three, see the loan sizing calculator guide. The point here is the discipline: never assume the new loan equals the old one.

Each lender sets its own minimums and its own valuation view. Treat every threshold in the example below as an input you replace with the quote you actually hold, and confirm terms with your lender or broker.

Worked example: where the loan lands and the gap appears

Every number in this section is an example input chosen to show the method. None is a market statement.

Example inputs: in-place NOI of $600,000; a lender valuation cap rate of 7.5%; a maximum LTV of 65%; a minimum DSCR of 1.25x; a minimum debt yield of 10%; a 7.0% interest rate on a 25-year amortization; and an existing loan balance of $5,900,000.

Step 1: value. $600,000 ÷ 0.075 = $8,000,000.

Step 2: each constraint.

Step 3: pick the minimum. LTV binds at $5,200,000. At that loan, annual debt service is about $441,000, so DSCR is about 1.36x, comfortably above the example minimum.

Step 4: measure the gap. The existing balance of $5,900,000 minus new proceeds of $5,200,000 leaves $700,000 the borrower must cover. If closing costs run at an example 1% of the new loan, that adds $52,000, for a total cash-in requirement of about $752,000.

Notice what drove the answer. NOI never changed, yet the loan fell short because valuation and leverage limits, not coverage, set the ceiling. A model that only checks DSCR would have told you the deal refinances.

Stress the refinance DSCR test and the rate

The binding constraint can switch as inputs move, which is why one scenario is never enough. Rerun the example with a higher rate and watch the DSCR test take over.

At an example 8.0% rate on the same 25-year amortization, the loan constant rises to about 9.26%. The DSCR-sized loan becomes $480,000 ÷ 9.26%, or about $5,182,000. That is now just below the LTV limit, so the refinance DSCR test binds and the cash-in requirement grows to roughly $718,000 before closing costs.

Two lessons follow. First, a small rate move can change which constraint governs, so you need to see all three limits at once. Second, NOI is the lever you can still influence before maturity; each dollar of NOI raises the DSCR and debt-yield limits and, through valuation, the LTV limit.

Build this as a grid, not a single case. A 5×5 table of rate against NOI, or rate against valuation cap rate, shows where the gap opens and how fast it grows. The sensitivity analysis in Excel guide explains the grid conventions and how to read them.

Cover or close the gap: your options

Once the gap is a number, the decision becomes concrete. A cash-in refinance calculation compares the capital required against the alternatives, so list the paths side by side.

1. Cash-in refinance. Pay down the balance to the new proceeds and close. The model needs the gap, closing costs and the new debt service, and a view of what that fresh equity earns going forward.
2. Extension or modification. Some loans carry extension options with their own tests; others can be negotiated with the existing lender. Read the loan documents, since conditions vary, and confirm terms with the lender.
3. Bridge or mezzanine debt. Higher-cost capital can fill the gap, but it raises blended cost and lowers coverage. Run the blended debt service through the same DSCR test.
4. Preferred equity or new partners. Outside equity fills the gap at a cost that shows up in the waterfall.
5. Sell. A sale repays the existing loan from proceeds, which removes the maturity risk altogether.

For the sale path, use the same example. At a sale at the $8,000,000 value, with an example 3% in selling costs ($240,000), proceeds before taxes are $7,760,000, and repaying $5,900,000 leaves about $1,860,000. Compare that against the cash-in path on a like-for-like basis: after-tax cash, remaining hold period and risk. Our piece on whether to sell a rental property walks through that comparison. Tax consequences differ by situation, so confirm them with your CPA or tax advisor.

Common errors in commercial real estate refinance analysis

Most refinance surprises trace back to a short list of modeling mistakes. Check your file against each before you show it to a partner or lender.

Using the underwritten cap rate for valuation. Your acquisition model used the cap rate you believed at purchase. The lender's appraiser uses the cap rate the market supports today. If the two differ, the LTV test moves even though the property did not.

Sizing on projected NOI. Lenders generally size on in-place or trailing income, not on the stabilized figure in your business plan. Run the sizing on the income a lender will actually credit, and treat your projected NOI as an upside case.

Ignoring the amortization assumption. The loan constant depends on both the rate and the amortization schedule. An interest-only period changes the picture again, because the first-year coverage looks better than the long-run coverage. Test both.

Forgetting costs. Origination fees, legal costs, prepayment or defeasance charges on the old loan, and reserves can all add to the cash needed at closing. We have used a single example percentage above; replace it with the actual quotes and the payoff terms in your existing loan documents.

Treating the gap as a one-time check. Maturity wall underwriting is a monitoring process. The gap you computed twelve months ago is stale once rates, NOI or lender appetite change, so keep the model live and update it on a fixed schedule.

Each of these is a matter of inputs and discipline rather than complicated math. A cre loan maturity refinance model that separates the inputs, flags the binding constraint and carries a downside case will catch all five.

What to gather before you approach a lender

A clean package shortens the conversation and surfaces problems while you still have time to act. Assemble the documents first, then run the model against them.

Start with the trailing operating statements and a current rent roll, since these set the NOI a lender will credit. Add the existing loan agreement, which governs the payoff amount, any prepayment terms, and any extension conditions. Pull recent capital expenditure records and a schedule of lease expirations, because rollover risk in the next few years affects how a lender views the income.

Then ask for indicative terms from more than one source. Compare the maximum LTV, minimum DSCR, minimum debt yield, amortization and recourse terms across quotes rather than headline rate alone. Enter each quote as its own scenario in the model so you can see which one yields the smallest gap.

Finally, decide in advance how much additional equity your partners are willing to commit and under what return expectations. Having that answer before the quotes arrive turns the gap from a crisis into a decision you already prepared for.

Build the maturity model before the maturity arrives

The analysis above is only useful if it runs early. A workable cadence is to re-size the loan at least a year before maturity, then again at each rate or valuation change, so a gap never arrives as a surprise.

Your model should carry, at a minimum:

• the existing balance and amortization at the maturity date;
• NOI at maturity, with a downside case;
• lender valuation cap rate, maximum LTV, minimum DSCR and minimum debt yield as separate inputs;
• a rate scenario set, with the binding constraint flagged for each;
• the cash-in gap, closing costs and the sale comparison in one view.

Treat the rate and spread assumptions as placeholders until you hold a live quote, and label them as such in the file so a partner reading it knows what is a fact and what is an assumption.

If you would rather not rebuild this in a blank workbook, the DSCR & Debt Underwriting Calculator is an institutional-grade DSCR calculator with debt sizing and interest rate sensitivity, delivered as a fully unlocked Excel file with methodology documentation. To see how an unlocked, documented model is laid out first, download the free Starter Pro Forma and work through its three tabs on one of your own deals.