Investment analysis
Demo analysisThis 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)
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 dealDiscussion
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.