Deal Analyzer: Full Underwriting, One Input Set
Stop re-entering the same numbers five times. Run every core metric together, stress-test the deal, and export a clean summary.
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 Tool Does
Underwriting a real deal means looking at Cap Rate, Cash-on-Cash Return, DSCR, and Break-Even Ratio together — not one at a time. Deal Analyzer takes a single set of inputs (purchase price, income, expenses, financing terms) and calculates all four core metrics simultaneously, flags whether the deal clears typical lender thresholds, and lets you stress-test it against a tougher vacancy and rate environment before you commit. When you're done, export a one-page PDF summary to share with a partner or lender.
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%A Real Example
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.