An underwriting model is the financial spreadsheet that converts a property's income, expense, and financing assumptions into the return and risk metrics used to price a commercial real estate deal. It takes the rent roll and operating statements as inputs and outputs net operating income, cap rate, debt service coverage, and internal rate of return.
How the Underwriting Model Works
An underwriting model works by chaining assumptions into outputs. It starts with gross potential rent, subtracts vacancy and credit loss, adds other income to reach effective gross income, then subtracts operating expenses to produce net operating income. NOI drives valuation through the cap rate, loan sizing through the debt service coverage ratio, and equity returns through the internal rate of return.
Per PropertyMetrics, a lender will almost always construct its own model rather than accept the borrower's, which can produce a different NOI. Every output is only as reliable as the input feeding it. Per The Cauble Group, the discipline is underwriting to what a property actually earns, not what it could earn under optimal conditions, so the model separates in-place performance from projected upside.
Model block | Drives |
Income to effective gross income | Revenue assumptions and vacancy |
Operating expenses to NOI | Valuation and loan sizing |
Debt and financing | Debt service coverage ratio, cash flow after debt |
Reversion and returns | Exit value, internal rate of return, equity multiple |
Why the Underwriting Model Matters
The underwriting model matters because every downstream decision runs off its outputs: the price a buyer offers, the loan a lender sizes, and the return an investor is promised. A model built on optimistic rent growth or thin vacancy makes a marginal deal look financeable. A single wrong assumption compounds through every output.
The lever with the most price sensitivity is the exit cap rate. Because value at sale equals projected NOI divided by the exit cap, a 50 basis point move in that single assumption can swing internal rate of return by several hundred basis points on a leveraged deal. Disciplined underwriters set the exit cap at or above the going-in cap and test the model against a downside scenario before trusting the base case.
Example
Consider a stabilized property with $1,000,000 of net operating income underwritten at a 6.0% going-in cap rate. That implies a purchase price of about $16,670,000. The buyer sizes a loan at 65% loan-to-value, or about $10,833,000, at a 6.5% interest-only rate, producing about $704,000 of annual debt service.
Metric | Calculation | Result |
Purchase price | $1,000,000 / 0.060 | $16,666,667 |
Loan amount (65% LTV) | $16,666,667 x 0.65 | $10,833,333 |
Annual debt service (6.5% IO) | $10,833,333 x 0.065 | $704,167 |
Debt service coverage ratio | $1,000,000 / $704,167 | 1.42x |
Debt yield | $1,000,000 / $10,833,333 | 9.2% |
At a 1.42x coverage ratio the deal clears the common 1.25x lender floor cited by Fannie Mae's DUS program. Now stress the model: if NOI comes in 10% light at $900,000, coverage falls to 1.28x and the debt yield drops to 8.3%, still bankable but with the margin nearly halved. The model shows the deal survives a 10% income miss, and that is the answer the committee needs.
Variations and Edge Cases
Underwriting models differ by property type and business plan. The table below shows the common variants and what changes in the model.
Variant | What the model emphasizes |
Stabilized acquisition | In-place NOI, going-in cap, straightforward loan sizing |
Value-add | A lease-up or renovation curve, separate stabilized pro forma, higher return targets |
Development | Hard and soft costs, a construction budget, a lease-up timeline, yield on cost |
Lender model | Conservatively adjusted income, stress tests, coverage and debt yield floors |
Underwriting Model vs Pro Forma
The underwriting model is often confused with the pro forma, but they are not the same thing. The pro forma is the multi-year projection of income, expenses, and cash flow. The underwriting model is the full spreadsheet that contains the pro forma and layers financing, returns, and sensitivity analysis on top of it. The pro forma is a component; the model is the whole tool.
Put another way, the pro forma answers what the property will earn, while the underwriting model answers what the deal is worth and whether it clears the firm's return and coverage thresholds. An analyst builds the pro forma first, then wraps it in debt, equity, and reversion assumptions to turn a cash flow projection into an investment decision.
Frequently Asked Questions
What is an underwriting model in commercial real estate?An underwriting model is the financial spreadsheet that converts a property's income, expense, and financing assumptions into return and risk metrics such as NOI, cap rate, debt service coverage ratio, and internal rate of return. It is the tool used to price a deal.
What is the difference between an underwriting model and a pro forma?The pro forma is the multi-year cash flow projection. The underwriting model is the full spreadsheet that contains the pro forma and adds financing, returns, and sensitivity analysis. The pro forma is a component of the model, not a substitute for it.
What outputs does an underwriting model produce?An underwriting model produces net operating income, the implied cap rate, the debt service coverage ratio, the debt yield, the internal rate of return, and the equity multiple. These outputs drive the offer price, loan size, and equity return.
Related Terms
Pro Forma
Net Operating Income
Debt Service Coverage Ratio
Internal Rate of Return
Rent Roll Analysis