CREMODEL · Models

Mixed use

Underwriting Mixed Use: Shops Below, Flats Above

CREMODEL · underwriting notes

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

Building12,000 SF retail, 26 apartments above
Purchase price$11,600,000
RetailFour leases, $26 to $34 NNN and modified gross
Residential14 one-bed, 8 two-bed, 4 studio
Residential rents$1,520 to $2,450 a month
Other residential income$55 per unit per month
Turnover45% to 60% a year, 18 days vacant, $1,300 make-ready
DebtSized on all three lender tests, 6.60% fixed, 30-year amortization
ExitRetail at 7.00%, residential at 5.50%
Blended entry cap6.74%
Levered IRR11.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