Mixed use
Underwriting Mixed Use: Shops Below, Flats Above
Two income streams that behave nothing alike, priced by the market at two different rates, financed by one loan. Averaging them is how mixed use gets mispriced.
Open this deal in the model. It loads with the rent roll, the allowances, the capital plan and the loan already filled in. Change any number and the whole model re-runs as you type.
Open the mixed use template →The retail runs on a rent roll: leases, terms, escalations, recoveries, allowances at rollover. The residential runs on a unit mix: units, monthly rents, turnover, make-ready, per-unit operating expenses. They share a roof, a tax bill and a mortgage, and almost nothing else.
Two cap rates, not one
A buyer will not price the whole building at one rate. Flats in a decent location trade near multifamily pricing, transactional cap rates have sat around 5.6% to 5.7% for a long stretch, while the ground floor retail prices as retail, wider, depending on the covenant. Value each stream at its own rate and add them. Averaging the two rates and applying the result to the total income gives a different, wrong answer, and it is wrong in the seller’s favor more often than not.
The expenses do not share a basis either
Retail operating costs are quoted per square foot and largely recovered from tenants under net leases. Residential costs are quoted per unit per year and recovered from nobody, you pay the taxes, the insurance, the water, the payroll and the turnover, and you recover a slice through billbacks at best. Charging the residential floors a per-square-foot retail expense load, or the retail a per-unit residential one, quietly double counts the tax bill.
One loan, two coverage stories
The lender sizes against the whole building’s net operating income, so the stable residential income supports the retail and the higher retail rents support the residential. That is genuinely useful. It also means a retail vacancy shows up in a coverage test that the apartments are carrying, which is worth seeing before it happens.
What the template loads with
| Building | 12,000 SF retail, 26 apartments above |
| Purchase price | $11,600,000 |
| Retail | Four leases, $26 to $34 NNN and modified gross |
| Residential | 14 one-bed, 8 two-bed, 4 studio |
| Residential rents | $1,520 to $2,450 a month |
| Other residential income | $55 per unit per month |
| Turnover | 45% to 60% a year, 18 days vacant, $1,300 make-ready |
| Debt | Sized on all three lender tests, 6.60% fixed, 30-year amortization |
| Exit | Retail at 7.00%, residential at 5.50% |
| Blended entry cap | 6.74% |
| Levered IRR | 11.8% over a 7-year hold |
Nothing is stored anywhere. One subscription covers unlimited use; your account keeps your deals. Press Save link and the whole set of assumptions travels in the address bar, so you can paste it into your deal notes or send it to a partner.
Open the mixed use template →Related notes and models
- The Blended Cap Rate Is Not the Average of the Cap Rates , why two streams need two rates
- Turnover Is the Line Multifamily Pro Formas Understate , what a turn really costs
- The $15 Deal That Is Really a $12 Deal , face rent against net effective
- Multifamily template , a full apartment P&L