Real Estate Finance & Underwriting Lab

Commercial Real Estate & Cap Rate Lab

Calculate Net Operating Income (NOI), property market values, Debt Service Coverage Ratio (DSCR), and levered cash-on-cash yields.

Real Estate Model Cap Rate Sensitivity Underwriting Theory FAQ

Asset Class Presets

Load calibrated commercial properties.

Step 1: Revenue, OpEx & Financing Inputs

Property Pro-Forma & Debt Parameters

1. Revenue & Operating Expenses

$
Annual gross scheduled rent at 100% occupancy.
%
Anticipated uncollected rent & vacancy.
$
Parking, storage, utility reimbursements.
$
Taxes, insurance, management, maintenance.

2. Valuation & Cap Rate

%
Market capitalization rate for asset class.
%
Borrower debt leverage proportion.

3. Commercial Debt Financing

%
Annual borrowing coupon rate.
years
Loan amortization schedule.
Net Operating Income
$0 / Yr
Property Value
$0
DSCR Coverage
0.00x
Healthy
Cash-on-Cash Return
0.0%
Lender Debt Yield
0.0%

Step 2: Valuation Sensitivity Analysis

Cap Rate vs. Property Valuation & Equity Schedule

Illustrates how market cap rate expansion (e.g. rising interest rates) impacts property asset valuation and levered equity returns.

Market Cap Rate Implied Asset Value ($) Implied Equity ($) Cash-on-Cash Return (%)

Real Estate Investment Guide

Understanding commercial property underwriting

Commercial real estate valuation is anchored entirely in the property's ability to generate Net Operating Income (NOI).

  • The Cap Rate Dynamic: Cap Rate represents the unlevered annual yield. When cap rates compress (drop), property values rise; when cap rates expand (rise), values fall.
  • The 1.25x DSCR Hurdle: Banks require a minimum 1.25x Debt Service Coverage Ratio to provide a 25% cash cushion against tenant vacancy or expense spikes.
  • Positive vs. Negative Leverage: If property Cap Rate exceeds borrowing interest rate, leverage enhances Cash-on-Cash yield; if interest rate exceeds Cap Rate, debt destroys investor returns.

Evaluate hotel metrics in the Hospitality RevPAR Lab.

Underwriting Equations

Essential real estate formulas

Effective Gross Income = GPR × (1 − Vacancy %) + Other Income

Net Operating Income (NOI) = EGI − Operating Expenses

Property Value = NOI ÷ Cap Rate %

Debt Service Coverage Ratio (DSCR) = NOI ÷ Annual Debt Service

Cash-on-Cash Return (%) = (NOI − Debt Service) ÷ Equity Invested

Debt Yield (%) = (NOI ÷ Loan Amount) × 100%

Explore capital budgeting in the Capital Budgeting Lab.

FAQ

Commercial real estate and cap rate questions

What is Net Operating Income (NOI) in commercial real estate?

NOI measures a property's unlevered operating profitability: Effective Gross Income (Gross Potential Rent minus Vacancy plus Other Income) minus Operating Expenses (taxes, insurance, management, maintenance).

How is property value determined using a Capitalization Rate (Cap Rate)?

Property Value = Net Operating Income ÷ Cap Rate %. A lower cap rate implies higher asset valuation and lower risk; a higher cap rate implies a lower valuation multiple and higher perceived risk.

What is Debt Service Coverage Ratio (DSCR) and why do lenders require 1.25x?

DSCR = Net Operating Income ÷ Annual Debt Service. Commercial lenders typically require a minimum 1.25x DSCR to ensure the property generates at least 25% more cash flow than required to service mortgage payments.

What is the difference between Cap Rate and Cash-on-Cash Return?

Cap Rate is an unlevered yield on total property asset value (NOI ÷ Property Value). Cash-on-Cash return is the levered pre-tax yield on the actual equity cash invested: (NOI − Debt Service) ÷ Equity Invested.

Can I export real estate underwriting schedules to CSV?

Yes. You can export complete pro-forma NOI statements, DSCR benchmarks, loan amortization schedules, and Cap Rate sensitivity tables as a UTF-8 CSV spreadsheet with formula injection defense or print an executive brief.

Is this tool certified commercial appraisal or fiduciary investment advice?

No. This tool provides educational commercial real estate finance models for business training without certified appraisal licensing, formal underwriting guarantees, or fiduciary investment advice.

Continue Exploring Property & Finance Tools

Explore our Hospitality & Property Hub, model lodging ADR in the RevPAR Lab, analyze discount rates in the WACC Lab, or evaluate investments in the Capital Budgeting Lab.