Back to Tools
— Tool

Deal Screener.

Plug in a few key numbers on any multifamily opportunity and see how it screens as an investment — IRR, cash flow, debt coverage, and an at-a-glance verdict.

Deal Screener
Deal Inputs
$
$/mo
%
Financing & Exit
%
%
%
yrs
Projected IRR
19.15%
5-yr hold
Equity Multiple
2.29x
Going-In Cap
6.53%
Cash-on-Cash (Y1)
4.07%
DSCR
1.23
Tight
Price / Unit
$120,000
Year 1 NOI
$783,750
Down Payment
$3,600,000
Loan Amount
$8,400,000
Annual Debt Service
$637,125
— Return Profile
Appreciation-Driven

Cash flow is tight, but IRR and equity multiple are solid — most of the return is realized at exit.

DSCR of 1.23 is acceptable but offers limited buffer. Most agency lenders want 1.25+.

Cash-on-cash of 4.1% is modest. Total return relies more on appreciation than current yield.

Over 79% of total return comes from the sale — IRR is sensitive to the 6% exit cap assumption.

2.29x equity multiple over 5 years means investors nearly double their money — strong on absolute return.

Assumes 5% vacancy, 3% annual NOI growth, 30-year amortization. For screening only — full underwriting requires market comps, T-12, rent roll, and detailed capex modeling.

— How this is calculated

The math behind the numbers.

Every metric above is derived from the inputs on the left. Here's exactly how each number is built — no black box.

Step 1 · Net Operating Income
Gross Potential Income
100 units × $1,250 × 12 months
$1,500,000
Less: Vacancy
5% of GPI
($75,000)
Effective Gross Income
$1,425,000
Less: Operating Expenses
45% of EGI
($641,250)
Net Operating Income (Y1)
$783,750
Step 2 · Debt
Loan Amount
70% LTV
$8,400,000
Annual Debt Service
6.5% rate · 30-yr amortization
$637,125
DSCR (NOI ÷ Debt Service)
1.23
Step 3 · Year 1 Returns
NOI
$783,750
Less: Debt Service
($637,125)
Cash Flow (Y1)
$146,625
Cash-on-Cash (CF ÷ Equity)
$146,625 ÷ $3,600,000
4.07%
Step 4 · Exit Value
NOI at Year 5
Y1 NOI grown at 3% per year
$908,581
Sale Price
Exit NOI ÷ 6% exit cap
$15,143,018
Less: Loan Balance at Exit
Remaining after 5 yrs of amortization
($7,863,322)
Net Sale Proceeds
$7,279,695
Step 5 · IRR Cash Flows

The IRR is solved from this cash flow stream — initial equity out, annual cash flow in, plus net sale proceeds at exit.

Year
NOI
Cash Flow
Net to Investor
0
($3,600,000)
1
$783,750
$146,625
$146,625
2
$807,263
$170,138
$170,138
3
$831,480
$194,356
$194,356
4
$856,425
$219,300
$219,300
5·exit
$882,118
$244,993
$7,524,688
Solved IRR
19.15%
Equity Multiple
2.29x
— Fixed Assumptions
5% vacancy — economic vacancy applied to gross potential income.
3% annual NOI growth — applied each year through the hold period.
30-year amortization — interest-only and other structures not modeled here.

This is a screening tool, not full underwriting. Real deals require T-12s, rent rolls, capex budgets, market comps, and stress testing.

— Why this matters

Conservative underwriting isn't pessimism. It's protection.

The difference between a deal that returns 18% IRR and one that wipes out investor equity is rarely the headline metrics. It's the assumptions buried inside them. A pro forma is just math, and math will give you any answer you want, depending on the inputs you feed it.

Where underwriting goes wrong

Aggressive rent growth assumptions

Underwriting 5% annual rent growth into year 3 of a 5-year hold can mask a deal that doesn't pencil at market-rate growth of 2-3%. A 200 bps miss compounds quickly across 250 units.

Exit cap compression

Assuming you sell at the same cap rate you bought is risky. Real underwriting stresses the exit cap 50-100 bps higher than today's market, and the deal should still work.

Underestimating expenses

Insurance in Texas alone has doubled in many markets over the past three years. Taxes reassess at sale. Payroll, R&M, and turn costs are all up. A 45% expense ratio that ignores these realities will blow up Year 1.

Thin debt coverage cushion

A DSCR of 1.20 looks fine until occupancy drops 3 points or rates reset on a bridge loan. Conservative operators target 1.30+ at close, with stress tests at 1.15 or better.

— The stakes

A single optimistic assumption, whether a half-point on the exit cap, a percent on rent growth, or a missed line item on insurance, can erase millions in equity over a hold period. In multifamily, you're not just risking returns. You're risking capital calls, forced refinances, and in the worst case, losing the deal.

The best operators we know underwrite to a base case that already assumes things go sideways. If the deal works on conservative assumptions, the upside is a bonus. If it only works on aggressive ones, you don't have a deal. You have a hope.

Disclaimer

This screener is provided for illustrative and educational purposes only. The outputs are based on simplified assumptions and do not constitute investment advice, an offer to sell securities, or a recommendation to buy, sell, or hold any specific property. Actual investment performance depends on dozens of variables not modeled here, including market comps, T-12 financials, rent rolls, capex requirements, debt terms, tax treatment, insurance, and local market conditions. Before committing capital to any real estate opportunity, you should conduct comprehensive, third-party-verified underwriting and consult qualified legal, tax, and financial professionals. Momentum Multifamily makes no representations or warranties as to the accuracy, completeness, or suitability of any output from this tool.