Commercial Real Estate Deal Analyzer
Evaluate commercial property ROI, debt coverage, and cash flow yields from a single set of assumptions.
Deal Analyzer: Comprehensive CRE Underwriting
One input set for Cap Rate, NOI, Cash-on-Cash, DSCR, and Break-Even Ratio.
1. Property & Acquisition Info
2. Annual Income & Expenses
3. Debt & Financing Terms
Healthy Deal
Key leverage metrics sit comfortably within standard lender thresholds (DSCR ≥ 1.25x & BER ≤ 85%).
Key leverage metrics sit comfortably within standard lender thresholds (DSCR ≥ 1.25x & BER ≤ 85%).
Underwriting Input Parameters
| Purchase Price: $2,800,000 | Closing Costs: 2% ($56,000) | Gross Income (GPI): $336,000 |
| Vacancy Rate: 5% ($16,800) | Effective Income (EGI): $319,200 | Operating Expenses: $92,000 |
| Down Payment: 25% ($700,000) | Loan Amount: $2,100,000 | Rate / Amortization: 6.5% / 25 Years |
Calculated Core CRE Metrics & Stress Test
| Core Metric | Base Case | Stressed Case (+5% Vac, +1% Rate) |
|---|---|---|
| Net Operating Income (NOI) | $227,200 | $210,400 |
| Cap Rate | 8.11% | 7.51% |
| Cash-on-Cash Return (CoC) | 7.55% | 3.20% |
| Debt Service Coverage Ratio (DSCR) | 1.34x | 1.13x |
| Break-Even Ratio | 82.13% | 92.01% |
| Annual Debt Service | $170,152 | $186,226 |
What This CRE Calculator Does
Underwriting a real deal requires looking at multiple performance metrics simultaneously. This commercial real estate investment calculator takes a single set of inputs and generates all core yields: Cap Rate, DSCR, Cash-on-Cash Return, and Break-Even Ratio (the minimum occupancy needed to pay all bills). Note that Cash-on-Cash calculates returns based on your total cash invested (down payment plus closing costs), while NOI explicitly excludes your debt service payments. Easily model a base scenario, then stress-test the underwriting against tougher vacancy and loan rate environments.
Core Underwriting Metrics & Formulas
• NOI = Effective Gross Income - Operating Expenses
• Cap Rate = NOI / Purchase Price × 100%
• Cash-on-Cash Return = (NOI - Annual Debt Service) / Total Cash Invested × 100%
• DSCR = NOI / Annual Debt Service
• Break-Even Ratio = (Operating Expenses + Annual Debt Service) / Effective Gross Income × 100%Worked Commercial Property Example
Consider a hypothetical 24-unit multifamily property with the following acquisition and operational assumptions:
- Purchase price: $2,800,000
- Gross potential income: $336,000
- Vacancy: 5%
- Operating expenses: $92,000
- Down payment: 25% ($700,000)
- Closing costs: 2% ($56,000)
- Commercial loan: 6.5% interest rate, 25-year amortization
First, deducting vacancy gives an Effective Gross Income (EGI) of $319,200. After subtracting operating expenses, we can calculate the property's NOI at $227,200. Based on the purchase price, this translates to an 8.11% unleveraged Cap Rate.
Based on the loan terms, the annual debt service is $170,152. By dividing the NOI by the debt service, we test the lender's DSCR threshold, resulting in a healthy 1.34x coverage. The pre-tax cash flow after debt is $57,048. Compared against the $756,000 total cash invested (down payment + closing costs), we measure cash return on invested equity, which yields 7.55%. Currently, the Break-Even Ratio is 82.13%.
The base case appears healthy, but what happens if vacancy rises to 10% and interest rates climb to 7.5%?
Annual debt service climbs to $186,225, while NOI drops to $210,400. In this scenario, the DSCR plummets to 1.13x (entering the warning zone for many lenders), and the Cash-on-Cash Return shrinks to 3.20%. The Break-Even Ratio also rises to a risky 82.80%. This demonstrates why it is crucial to fully underwrite a commercial real estate deal incorporating downside risk.
Institutional Underwriting Pitfalls & Common Mistakes
1. Overlooking Stress Testing: Underwriting only base-case pro-formas is dangerous. Always apply +5 percentage points vacancy and +100 bps interest rate stress to test debt coverage resilience.
2. Under-budgeting Replacement Reserves: Omitting capital expenditure reserves (e.g., $250-$350/unit/yr) creates artificially inflated initial cash flow.
Frequently Asked Questions
Why does this give different numbers than running each calculator separately?
It shouldn't — Deal Analyzer uses the exact same calculation logic as our individual Cap Rate, NOI, Cash-on-Cash, DSCR, and Break-Even Ratio calculators. The advantage here is entering your numbers once instead of five times, which also eliminates the risk of accidentally using slightly different inputs across separate tools.
What stress test assumptions does this use, and can I customize them?
By default, the stress test applies +5 percentage points of vacancy and +100 basis points of interest rate — a moderate, not worst-case, scenario. This matches the stress-testing approach described in our How to Underwrite a Deal guide. Custom stress scenarios may be added in a future update.
Is the PDF export suitable for a formal loan application?
No — treat it as a working summary for your own analysis or informal discussion with a partner or lender, not a substitute for the formal underwriting package (verified financials, appraisal, etc.) a lender will require.