Skip to content

Investment analysis

Demo analysis

This is an example analysis published by the PropertyU Team to show how a completed underwriting looks. The property and numbers are illustrative.

Brookline Commons (Demo)

1820 Brookline Avenue · Columbus, OHMultifamily · 24 units$$2,640,000 purchase price
PTPropertyU TeamOfficial account at PropertyUPublished September 13, 2026
DecisionBuy

Key metrics

Purchase price
$2,640,000
Net operating income
$184,800
Cap rate
0.07%
Cash-on-cash return
0.08%
DSCR
1.38
IRR
0.15%
Equity multiple
1.94x

Investment thesis

A 1980s-vintage 24-unit in a stable Columbus submarket trading at $110,000 per unit, roughly 15% below recent comparable sales. In-place rents average $1,000 against a market of $1,125, so the upside comes from turning units at renewal rather than from aggressive market rent growth. At a 7.0% going-in cap with a 1.38x DSCR, the deal covers debt comfortably even if the lease-up of renovated units takes longer than planned.

Biggest risks

Payroll and insurance are the two expense lines most likely to run above underwriting; a 10% overrun cuts cash-on-cash by roughly a point. The exit assumes a 7.25% cap — a 50 basis point move costs about 250 basis points of IRR. Interior renovation costs of $6,500 per unit assume no plumbing surprises in a building of this age.

Key assumptions

Five-year hold. Rent growth 3% per year, expense inflation 3.5%, vacancy 6%. 75% LTV at 6.35% fixed, 30-year amortization, no interest-only period. Renovation of 12 units at $6,500 each, funded from reserves. Exit at a 7.25% cap on year-five NOI with 2% cost of sale.

Underwriting details

Supporting operating, financing, and exit figures from the completed underwriting.

Loan amount
$1,980,000
LTV
0.75%
Monthly cash flow
$5,017
Annual cash flow
$60,200
Operating expenses
$85,900
Annual debt service
$133,900
Break-even occupancy
0.77%
Exit cap rate
0.07%
Initial cash required
$743,000

About this analysis

This underwriting was built in the PropertyU Deal Lab. Every figure above comes from the author's own assumptions, and the written reasoning is theirs.

Analyze your own deal

Discussion

Ask the author a question or add your own read on the numbers.

PropertyU provides educational estimates, not personalized investment advice. Published analyses reflect the author's assumptions and opinions.