Commercial Underwriting Formulas Guide

Commercial underwriting is a clinical assessment of an asset's ability to withstand economic duress. Lenders do not underwrite to "expected" cases; they underwrite to "worst-case" scenarios to protect their position in the capital stack. For the professional investor, mastering these formulas is not about passing a test; it is about quantifying risk and ensuring the deal can survive a market contraction. Use this guide as the master technical cheat sheet for all institutional-grade commercial underwriting.

1. Debt Service Coverage Ratio (DSCR)

DSCR is the primary measure of cash flow cushion. It represents the ratio of net operating income to the total debt service (principal and interest). Lenders use this to ensure that even with a significant drop in income, the property can still cover its mortgage.

Lender Target: 1.20x to 1.35x. A 1.25x DSCR implies a 25% margin of safety. If interest rates rise or vacancy increases, this buffer prevents technical default.

Mathematical Example: A property produces $250,000 in NOI with an annual debt service of $190,000.
Calculation: $250,000 / $190,000 = 1.31x DSCR.

2. Loan-to-Value (LTV)

LTV measures the lender's exposure relative to the asset's liquidation value. While DSCR focuses on the income statement, LTV focuses on the balance sheet. It determines the "Senior Debt" proceeds based on the lower of the purchase price or appraised value.

Lender Target: 65% to 75% for most asset classes. Multifamily may reach 80% under Agency (Fannie/Freddie) programs. LTVs exceeding 75% typically trigger higher spreads or "Mezzanine" requirements.

Mathematical Example: A property is appraised at $5,000,000. The lender offers a loan of $3,750,000.
Calculation: ($3,750,000 / $5,000,000) × 100 = 75% LTV.

3. Debt Yield

Debt Yield emerged as the most critical risk metric post-2008 because it is interest-rate agnostic. It calculates the lender's "Cash-on-Cash" return if they were to foreclose on day one. It ignores amortization and interest rates, focusing purely on the relationship between loan proceeds and property income.

Lender Target: 8% to 11%. CMBS and Life Companies often floor their underwriting at a 10% Debt Yield. If the market cap rate is 7% and the debt yield is 7%, the lender is effectively over-leveraged.

Mathematical Example: A retail center produces $400,000 in NOI. The requested loan is $4,000,000.
Calculation: ($400,000 / $4,000,000) × 100 = 10% Debt Yield.

4. Operating Expense Ratio (OER)

The OER is a technical pulse check on management efficiency. Underwriters use this to benchmark a property against market standards. If a property's OER is significantly lower than its peers, an underwriter will "normalize" the expenses upward, reducing the NOI and the supportable loan amount.

Lender Target: 35% to 45% for Multifamily (excluding utilities); 25% to 35% for Triple-Net (NNN) properties where tenants pay most costs. Anything outside these bands triggers a deep audit of the T12 (Trailing 12-month) statement.

Mathematical Example: A building has $1,000,000 in Effective Gross Income and $420,000 in expenses.
Calculation: ($420,000 / $1,000,000) × 100 = 42% OER.

5. Breakeven Occupancy

Breakeven Occupancy determines the "Cliff" of the investment—the point at which the property no longer generates enough cash to pay both its operating expenses and its mortgage. This is the ultimate stress test for a deal's viability.

Lender Target: 75% to 85%. A 70% breakeven is considered conservative, meaning the property can lose 30% of its tenants before it becomes cash-flow negative. Lenders view a breakeven over 90% as high-risk.

Mathematical Example: A property has $500,000 in potential rent, $150,000 in expenses, and $200,000 in debt service.
Calculation: (($150,000 + $200,000) / $500,000) × 100 = 70% Breakeven.

The Underwriter’s Hierarchy

In practice, a lender will run all five of these formulas and "proceed" based on the most conservative result. If the LTV allows for a $2M loan but the DSCR only supports $1.7M, the property is "Debt Service Constrained," and the lower amount is used. Mastering the interaction of these metrics allows an investor to anticipate lender "push-back" and structure their capital stack with mathematical certainty.

The "Constraining Factor" Analysis

Institutional underwriters are trained to identify the single metric that limits loan proceeds—the "Binding Constraint." In low-interest-rate cycles, the binding constraint is almost always the LTV cap. However, as interest rates transition from zero-bound to historic norms, the DSCR frequently takes over as the limiting factor. This creates a "Proceeds Gap," where the sponsor is forced to contribute more equity than originally modeled.

Mitigating the Proceeds Gap

When an underwriting audit reveals a DSCR or Debt Yield constraint that lowers expected proceeds, professional investors have three primary levers:

• Interest-Only Periods: Negotiating for 12-36 months of IO can artificially inflate the day-one DSCR, although most lenders will still size the loan based on the eventual amortizing payment.
• Capex Reserving: By funding renovation costs up-front to drive higher future NOI, an investor can support a larger loan amount through an "earn-out" or "future funding" structure.
• Subordinated Debt: If the senior lender is constrained by LTV but the cash flow is strong, a "Mezzanine" loan or "Preferred Equity" can fill the gap, albeit at a significantly higher cost of capital.

Strategic Conclusion

Underwriting is a defensive discipline. By applying these formulas with the same rigor as a bank credit committee, you move from "chasing deals" to "quantifying risk." A deal that passes the 10% Debt Yield test, the 1.25x DSCR stress test, and the 75% Breakeven test is an asset that can survive the full duration of a market cycle. Underwrite for the downside, and the equity returns will follow.