Summary: The Numbers That Matter

A one-page property summary consolidates market comps, financial projections, and stress tests into a single decision document. If the numbers work on this sheet, you have a deal worth pursuing.

Key takeaways

• The summary sheet is your decision tool, not a pitch document. It must be brutally honest.
• Include five sections: (1) Property/market assumptions, (2) Financial snapshot (year 1 and year 10), (3) Stress test results, (4) Go/no-go criteria check, (5) Risk factors.
• A deal must pass all three gates (8% CCR, 1.25x DSCR, 8x equity multiple) and survive reasonable stress scenarios.
• The summary sheet takes 2–3 hours to prepare but saves weeks of wasted time on deals that don't work.
• Use the same template for every property you analyze, enabling comparison across deals.

Section 1: Property and market assumptions

Property information:

• Address, type (multifamily, office, retail, industrial), units/rentable SF
• Year built, last major renovation, current condition (A/B/C)
• Number of units by bedroom (if residential) or square footage by class (if office/retail)
• Current owner/operator, management quality

Acquisition assumptions:

• Offering price
• Financing structure (down payment, loan amount, rate, term)
• Cap rate at entry (sale price / year-1 NOI)
• Equity investment (down payment + costs)

Market assumptions (with sources):

• Market rent per unit/SF (source: Zillow, Rentometer, on-the-ground survey)
• Market occupancy rate (typical for submarket)
• Market cap rate for this property type (source: recent sales comps)
• Population growth rate, employment trends, supply pipeline

Example:

Property: 50-unit multifamily, Denver, Colorado
Address: 123 Main Street, Denver, CO 80205
Year Built: 2008 | Renovations: None significant | Condition: Class B

Offering Price: $2,100,000
Down Payment: $525,000 (25%) | Loan: $1,575,000 at 5.75% / 30-year
Entry Cap Rate: 4.9%

Market Rent: $1,200/unit/month (validated: Zillow $1,180, Rentometer median $1,210, on-ground surveys $1,210)
Market Occupancy: 94% (typical for Class B Denver apartments)
Market Cap Rate: 5.0–5.2% (from three recent sales, 2024)
Market Growth: Denver population +2% annually, strong supply constraints

Sources: Zillow, Rentometer, broker interviews with three recent deals, CoStar market report

Section 2: Financial snapshot (Year 1 and Year 10)

Year 1:

• Potential gross income (units × monthly rent × 12)
• Vacancy loss at market occupancy
• Effective rental income
• Operating expenses (and as % of ERI)
• Net Operating Income (NOI)
• Debt service
• Equity cash flow (annual)
• Cash-on-cash return
• Debt service coverage ratio (NOI / debt service)

Year 10:

• NOI (after rent growth, expense growth, and occupancy stabilization)
• Property value (NOI / exit cap rate)
• Loan balance (remaining after paydown)
• Equity at exit (property value − loan balance − sale costs)
• Cumulative cash flow (years 1–10)
• Total equity gain (cash flows + exit equity − initial investment)
• Levered IRR
• Equity multiple

Example:

YEAR 1 (Base Case)
Potential Gross Income: 50 units × $1,200/month × 12 = $720,000
Vacancy Loss (6%): −$43,200
Effective Rental Income: $676,800
Operating Expenses (35% of ERI): −$236,880
Net Operating Income: $439,920
Debt Service: −$100,500
Equity Cash Flow: $339,420
Cash-on-Cash Return: $339,420 / $525,000 = 64.7%  ← FLAG: seems high
DSCR: $439,920 / $100,500 = 4.38x  ← Healthy

YEAR 10
Rents (3% annual growth): $1,200 × 1.03^9 = $1,565
Potential Gross Income: $942,000
NOI (35% expense ratio): $612,300
Debt Service: $97,200 (remaining balance lower, but higher rate at refi)
Equity Cash Flow: $515,100

Exit Cap Rate: 5.0% (base case)
Exit Value: $612,300 / 0.05 = $12,246,000  ← This seems optimistic
Remaining Loan Balance: $1,450,000
Sale Costs (6%): $734,760
Net Exit Proceeds: $10,061,240

Cumulative Cash Flows (Years 1–10): ~$3,500,000
Total Equity Gain: ($3,500,000 + $10,061,240) − $525,000 = $13,036,240
Equity Multiple: $13,036,240 / $525,000 = 24.8x  ← Suspicious; likely error in assumptions
Levered IRR: ~45%  ← Unrealistic; indicates model error

Reality check: The Year 1 cash-on-cash and levered IRR in the above are implausibly high. This signals:

1. The property is being bought well below fair market value.
2. The rent or occupancy assumptions are unrealistic.
3. There's an error in the model.

Recheck all assumptions. High returns on paper are often phantoms.

Section 3: Stress test results

50 bps cap rate expansion stress:

• Exit cap rate: Entry + 50 bps
• Year-10 property value: lower (by ~10%)
• Equity gain: reduced
• Levered IRR: X% (vs. Y% base case)
• Interpretation: ✓ (acceptable) or ✗ (critical)

90% occupancy stress:

• Occupancy dropped to 90% (from market 94%)
• Year-1 and year-10 NOI: lower
• Equity cash flows: reduced
• Levered IRR: X% (vs. Y% base case)
• Interpretation: ✓ or ✗

200 bps interest rate stress (refi in year 5):

• Refinance rate: Entry + 200 bps
• New debt service (year 6–10): higher
• Equity cash flows (year 6–10): reduced
• Levered IRR: X% (vs. Y% base case)
• DSCR at refi: acceptable (≥1.25) or problematic (<1.25)
• Interpretation: ✓ or ✗

Example stress summary:

Stress Test Results

50 bps Cap Rate Expansion (Exit at 5.5%):
  Year-10 IRR: 11.2% (vs. 13.5% base) → 83% of base case ✓

90% Occupancy (sustained):
  Year-1 IRR: 9.8% (vs. 14.0% base) → 70% of base case ⚠
  Still positive, but vulnerable

200 bps Interest Rate Shock (Refi Year 5):
  Year 6 DSCR: 1.18x (vs. 3.0x year 1) → Below 1.25 threshold ✗
  RED FLAG: Cannot refinance at 200 bps higher rates

Section 4: Go/no-go criteria checklist

Rate each criterion:

Criterion	Required	Actual	Pass?
Year-1 Cash-on-Cash	≥8%	9.2%	✓
Debt Service Coverage (Year 1)	≥1.25x	1.50x	✓
Equity Multiple (Year 10)	≥8x	5.2x	✗
Base Case Levered IRR	≥12%	10.8%	✗
50 bps Stress Test IRR	≥9.6% (80% of 12%)	8.5%	✗
90% Occupancy Stress IRR	≥9.6%	7.2%	✗
200 bps Rate Shock DSCR	≥1.25x	1.12x	✗

Decision: This deal fails three out of seven criteria. It's a no-go unless:

1. You renegotiate the price down 15–20%.
2. You reduce leverage (larger down payment, smaller loan).
3. You have a specific operational improvement plan (e.g., cost reduction, rent upside not modeled).

Without one of these, walking away is prudent.

Section 5: Risk factors and mitigants

For each major risk, note the severity and any mitigating factors:

Risk Factor	Severity	Mitigation
Market rent below comps	Medium	Recent comps confirm $1,210 market; subject at $1,200 is conservative
Occupancy dependent on job growth	High	Denver has low unemployment (3%), strong employment growth expected
Refinancing in Year 5	High	Model only 100 bps rate shock; hope rates don't exceed that. No true mitigation.
Operating expenses rising 5% not 4%	Medium	Built-in buffer; cash flows still positive even at 5% growth
Deferred maintenance	Low	Recent inspection shows property in good condition

Bottom line: The deal's largest risks are refinancing and equity multiple. If rates rise more than modeled, the refinancing fails. If exit cap rate expands 75+ bps, equity multiple falls further. These are market risks, not operational risks—hard to mitigate.

The one-page template

Professional underwriters use a single template for all properties:

INVESTMENT SUMMARY: [Property Name], [City]

PROPERTY:
- Address, type, units, year built
- Current state, recent improvements

ACQUISITION:
- Price, down payment, financing terms
- Entry cap rate, equity investment

MARKET:
- Market rent (sources), market occupancy, market cap rate
- Growth trends, supply/demand

YEAR 1 SNAPSHOT:
- Potential income, effective income, NOI
- Cash-on-cash return, DSCR

YEAR 10 SNAPSHOT:
- Exit value, exit proceeds
- Levered IRR, equity multiple

STRESS TESTS:
- 50 bps cap expansion: IRR X%
- 90% occupancy: IRR X%
- 200 bps rate shock: DSCR X%

GO/NO-GO CHECKLIST:
- CCR ≥ 8%? ✓
- DSCR ≥ 1.25%? ✓
- Multiple ≥ 8x? ✗
- All stresses survivable? ✗

DECISION: NO-GO unless price reduced 15%

KEY RISKS:
1. Refinancing rate shock
2. Cap rate expansion risk
3. Equity multiple below target

PREPARED BY: [Name], [Date]

When to use the summary sheet

1. Early stage: After preliminary rent/value comps, but before detailed financial modeling.
2. Bidding: Present to your investment committee or financing team to get buy-in.
3. Closing prep: Final summary before hard commitment (loan approval, earnest money).
4. Post-purchase: Archive as a record of your original thesis; compare actuals against projections annually.

What the summary reveals

A well-prepared summary sheet forces clarity. It reveals whether a deal is:

• Fundamentally sound: Passes all go/no-go gates and stress tests. Buy with confidence.
• Viable but risky: Passes gates but sensitive to certain stresses (e.g., rate shock). Buy only if you have conviction on the risk.
• Overleveraged: Fails stress tests. Walk, or renegotiate down leverage.
• Overpriced: Fails equity multiple or IRR gate. Walk, or renegotiate price.
• Operationally dependent: Passes financials but depends on successful business plan execution (renovation, rent growth, cost control). Buy only if operator is strong.

Example: comparing two deals

Use the same summary template for two competing opportunities:

Deal A: Stabilized multifamily, 4% cap rate, built 2015, strong market

• Year-1 CCR: 7.8%
• DSCR: 1.30x
• Equity multiple: 8.2x
• Levered IRR: 12.1%
• Stress tests: all pass
• Decision: ✓ Buy

Deal B: Value-add multifamily, 6% cap rate, built 2000, secondary market

• Year-1 CCR: 5.2% (underlevered for value-add)
• DSCR: 1.50x (very conservative)
• Equity multiple: 9.5x (assumes cost-cutting and rent growth)
• Levered IRR: 13.8%
• Stress tests: 90% occupancy fails; rate shock fails
• Decision: ✗ Too risky; better opportunity elsewhere

Comparison: Deal A is safe and hits all thresholds. Deal B is higher-return but dependent on execution in a weak market. Unless you specialize in value-add, Deal A is the better choice.

The discipline of one-page summaries

Using a one-page template for every deal instills discipline:

1. Comparability: You can quickly rank deals against each other.
2. Consistency: You apply the same criteria to each deal, reducing emotional bias.
3. Transparency: A summary sheet forces you to make assumptions explicit. Hidden assumptions surface.
4. Accountability: A year later, you can compare projections to actuals and learn what you got right and wrong.

Most failed real estate investments were rejected or accepted based on gut feeling, not systematic analysis. The summary sheet prevents both errors.

Summary decision flowchart

Related concepts

• The Go/No-Go Criteria
• Comp-Based Rent Estimation
• Comp-Based Value Estimation

Next

This concludes Chapter 5. You now have the complete property analysis toolkit: market assessment, financial modeling, stress testing, and decision criteria. In the next chapter, we'll apply this framework to specific property types and markets, starting with multifamily apartments.