Key Takeaways
- Mixed-use properties require analyzing each component (retail, office) with appropriate market comparables.
- Value-add CRE deals generate returns through leasing vacant space, renovating to market standards, and stabilizing NOI.
- Always calculate yield on total cost (including renovation and closing costs) — not just cap rate on purchase price.
- Risk mitigation for value-add deals includes pre-leasing, phased renovation, and adequate debt service reserves.
- The gap between going-in cap rate and stabilized yield on cost represents the value-add opportunity.
This case study applies CRE analysis skills to a realistic mixed-use property scenario, requiring evaluation of multiple tenant types, lease structures, and a value-add renovation opportunity. Working through this analysis builds the integrative thinking needed for real-world CRE investment decisions.
Property Overview and Current Performance
Maple Street Commerce Center is a 15,000 SF mixed-use property consisting of 10,000 SF of ground-floor retail and 5,000 SF of second-floor office space, located in a growing suburban market. The property was built in 1998 and is currently 75% occupied. Asking price: $1,650,000.
Current rent roll: Tenant 1 — coffee shop, 2,500 SF, $18/SF NNN, 4 years remaining. Tenant 2 — insurance agency, 2,500 SF office, $14/SF modified gross, 2 years remaining. Tenant 3 — boutique retail, 3,000 SF, $16/SF NNN, 1 year remaining. Tenant 4 — vacant, 2,000 SF retail. Tenant 5 — vacant, 5,000 SF office (second floor, entire suite). Total occupied income: $129,000/year. Market retail rents: $20-$22/SF NNN. Market office rents: $18-$20/SF modified gross.
Financial Analysis and Value-Add Scenario
Current NOI analysis: Gross income from occupied space = $129,000. Operating expenses (landlord responsibility — management 6%, insurance, reserves) = approximately $18,000. Current NOI = $111,000. Cap rate at asking price = $111,000 / $1,650,000 = 6.73%. However, this reflects 75% occupancy — there is significant upside from leasing vacant space.
Value-add scenario: Invest $150,000 in renovating the second-floor office suite (new HVAC, updated finishes, modern lighting) and $30,000 refreshing the vacant retail space. Lease the office suite at $19/SF ($95,000/year) and the retail space at $21/SF ($42,000/year). Stabilized gross income = $129,000 + $95,000 + $42,000 = $266,000. Stabilized operating expenses (management, insurance, reserves at higher scale) = $32,000. Stabilized NOI = $234,000. Stabilized cap rate on total cost ($1,650,000 + $180,000 renovation + $50,000 closing costs = $1,880,000) = $234,000 / $1,880,000 = 12.45%.
Risk Assessment and Decision Framework
Several risks require consideration before proceeding. Lease rollover risk: the boutique retail tenant (21% of current income) expires in 1 year and may not renew. Leasing risk: the second-floor office suite represents the largest vacant space and may take 6-12 months to lease, during which renovation costs accrue without income. Market risk: if the suburban office market softens, the $19/SF office rent assumption may be optimistic.
Mitigation strategies include: negotiating a price reduction to account for current vacancy and near-term rollover risk, securing pre-leasing interest for the office suite before closing, building 12 months of debt service reserves into the capital budget, and structuring the renovation in phases to align spending with leasing progress. The investment thesis is compelling if you can execute the value-add plan — the gap between current cap rate (6.73%) and stabilized yield on cost (12.45%) provides significant margin for execution challenges.
Case Study: Building a Value-Add Capital Budget
You are proceeding with the Maple Street Commerce Center acquisition and need to build a detailed capital budget for the renovation.
- 1Office suite renovation (5,000 SF): HVAC replacement $45,000, flooring $25,000, lighting $15,000, paint/finishes $20,000, restroom update $15,000, contingency 20% = $24,000. Total: $144,000.
- 2Retail space refresh (2,000 SF): paint $4,000, flooring $8,000, storefront update $10,000, contingency 20% = $4,400. Total: $26,400.
- 3Common area improvements: lobby refresh $8,000, signage $5,000, parking lot seal/stripe $6,000. Total: $19,000.
- 4Soft costs: architectural/engineering $12,000, permits $3,000, leasing commissions (6% of year 1 rent) = ~$8,200. Total: $23,200.
- 5Total renovation budget: $212,600. Add closing costs (~$50,000) for total capital requirement of $262,600 beyond down payment.
- 6Maintain $80,000 in debt service reserves (6 months at estimated $13,300/month) for a total equity requirement of approximately $900,000.
A detailed capital budget reveals the true equity requirement ($900K vs. a naive estimate of $577K based on 65% LTV alone) and provides the framework for construction management and investor reporting.
Key Takeaways
- ✓Mixed-use properties require analyzing each component (retail, office) with appropriate market comparables.
- ✓Value-add CRE deals generate returns through leasing vacant space, renovating to market standards, and stabilizing NOI.
- ✓Always calculate yield on total cost (including renovation and closing costs) — not just cap rate on purchase price.
- ✓Risk mitigation for value-add deals includes pre-leasing, phased renovation, and adequate debt service reserves.
- ✓The gap between going-in cap rate and stabilized yield on cost represents the value-add opportunity.
Sources
- CBRE Value-Add Investment Strategy Research(2025-01-15)
- CoStar Group — Mixed-Use Property Analytics(2025-01-15)
Common Mistakes to Avoid
Evaluating value-add deals using cap rate on purchase price rather than yield on total cost.
Consequence: A property purchased at a 6.5% cap rate may appear modestly priced, but after $200,000 in renovation the total invested capital is much higher, reducing the actual return well below expectations.
Correction: Always calculate yield on total cost (stabilized NOI / total investment) for value-add deals. This metric captures the full capital commitment and provides a realistic return assessment.
Underestimating lease-up timelines for vacant commercial space.
Consequence: Second-floor office space and specialty retail may take 6-12 months to lease, during which renovation costs accrue without income, depleting reserves and potentially causing debt service stress.
Correction: Budget realistically for lease-up timelines: 3-6 months for retail in strong markets, 6-12 months for office space. Structure renovations in phases aligned with leasing progress to manage cash flow.
Test Your Knowledge
1.What metric should be used to evaluate value-add CRE deals rather than cap rate on purchase price?
2.In the Maple Street case study, what was the stabilized yield on cost?
3.Which risk mitigation strategy is most appropriate for a value-add CRE deal with significant vacant space?