Commercial Real Estate Underwriting Lab

Cap Rate & Property Valuation Calculator

Model Net Operating Income (NOI), Capitalization Rates (Cap Rate), Effective Gross Income (EGI), Gross Rent Multipliers (GRM), and sensitivity schedules.

Capitalization Rate (Going-In)
6.02%
Core-Plus / Balanced Primary Market

1. Acquisition & Revenue Assumptions

$
Total asset purchase or acquisition capitalization cost.
$
Annual scheduled rent at 100% full tenant occupancy.
%
Expected uncollected rent from physical vacancy and bad debt.
$
Parking, storage, application fees, utility reimbursements (RUBS).

2. Operating Expenses & Disposition

$
Property taxes, insurance, management, maintenance, repairs (excl debt).
%
Basis points added to going-in cap rate for year 5/10 terminal exit.

Live Underwriting & Valuation Scorecard

Net Operating Income (NOI)
$301,000 / yr
Unleveraged cash flow
Effective Gross Income (EGI)
$476,000 / yr
Realized gross receipts
Operating Expense Ratio
36.8%
OpEx / EGI ratio
Gross Rent Multiplier (GRM)
10.42x
Price / Gross Rent
Implied Value @ 6.0% Cap
$5,016,667
Benchmark fair value
Terminal Exit Cap Rate
6.52%
Going-in + spread

Net Operating Income (NOI) Waterfall

Underwriting Line Item Annual Amount ($) % of GSI
Core Real Estate Underwriting Formulas:
• \(\text{Cap Rate} = \frac{\text{Net Operating Income (NOI)}}{\text{Purchase Price}}\)  |  \(\text{Asset Valuation} = \frac{\text{NOI}}{\text{Target Cap Rate}}\)
• \(\text{NOI} = \text{Gross Rent} - \text{Vacancy Loss} + \text{Other Income} - \text{Operating Expenses}\)
• \(\text{GRM} = \frac{\text{Purchase Price}}{\text{Gross Rent}}\)  |  \(\text{OER} = \frac{\text{Operating Expenses}}{\text{Effective Gross Income}}\)

Asset Valuation Matrix: NOI vs. Market Cap Rate ($)

Demonstrates the exponential impact of cap rate compression and expansion on commercial property valuation.

Valuation Sensitivity

Going-In Yield Matrix: Purchase Price vs. OpEx Inflation (%)

Shows how acquisition pricing power and expense overruns alter your realized unleveraged cap rate yield.

Yield Sensitivity

Commercial Real Estate Underwriting & Cap Rate Guide

Unleveraged Yield vs. Leveraged Cash-on-Cash

The capitalization rate is an unleveraged metric: it evaluates property earning power entirely independent of financing terms, mortgage interest rates, or loan-to-value (LTV) ratios. This enables direct, apples-to-apples performance comparisons between different properties across distinct markets before debt structure is layered on.

The Asymmetric Power of Cap Rate Compression

Because real estate valuation divides NOI by the capitalization rate (\(V = \text{NOI} / R\)), valuation sensitivity is hyperbolic. A 50-basis-point drop in cap rate from 5.0% to 4.5% expands valuation by +11.1%, whereas at higher cap rates (e.g., 9.0% to 8.5%), the same 50 bps produces only a +5.9% valuation increase.

1. Institutional Asset Classes

Multifamily and industrial logistics historically trade at tight cap rates (4.0% - 5.5%) due to durable tenant demand, while secondary office and non-anchored retail command higher cap rates (7.5% - 10.0%) to compensate for tenant renewal risk.

2. Below-the-Line Capital Reserves

Standard NOI excludes debt service and capital expenditures (CapEx/tenant improvements). Underwriters must review whether high reported NOI is masking deferred maintenance or leasing commission liabilities.

3. Positive vs. Negative Leverage

When property cap rates exceed borrowing interest rates, debt enhances investor equity returns (positive leverage). If debt costs exceed going-in cap rates, leverage dilutes equity yields, requiring NOI growth to break even.

Frequently Asked Questions

The capitalization rate is the ratio of a real estate property's annual Net Operating Income (NOI) to its current market value or purchase price: Cap Rate = NOI ÷ Property Asset Value. It represents the unleveraged, all-cash annual return an investor would earn on the property.

NOI starts with Gross Scheduled Potential Rent, deducts economic Vacancy and Credit Loss, adds Ancillary Income (parking, storage, laundry), and subtracts all direct Operating Expenses (property taxes, insurance, management, maintenance, utilities). Debt service and income taxes are excluded.

A higher cap rate (e.g., 7.5% - 9.0%) generally reflects higher perceived risk, older asset condition, tertiary market location, or shorter tenant lease terms. A lower cap rate (e.g., 4.0% - 5.5%) reflects high institutional demand, prime Class A urban location, credit tenants, and lower risk of vacancy.

Because Property Value = NOI ÷ Cap Rate, any decline in market cap rate (cap rate compression) exponentially magnifies asset value. For an asset generating $300,000 in NOI, a drop in market cap rate from 6.0% to 5.0% increases property valuation from $5.0M to $6.0M (+20% gain) with zero change in actual cash flow.

An exit cap rate (or terminal cap rate) is the projected capitalization rate at which the property is sold at the end of the holding period (typically year 5 or 10). Underwriters conservatively add a spread of 25 to 75 basis points above the going-in cap rate to reflect building aging and potential future macroeconomic rate expansion.

Related Commercial Real Estate & Valuation Labs

🏢 DSCR & Loan Underwriting Lab 📑 Commercial Lease & Rent Lab 🎯 Terminal Value Calculator 📈 CAGR & Growth Rate Lab 📊 IRR & Equity Hurdle Lab 💵 DCF Valuation Lab 📚 Complete Simulation Catalog