Anatomy of a value-add multifamily deal: hypothetical

The renovation works. Rents go up. Net operating income improves. The deal is still mediocre.

That is the hypothetical we are going to underwrite. Value-add education shows new countertops, jumps to higher rent, and lets the purchase price leave the room.

Every property, dollar, lease, and outcome below is invented. This is not a real offering, a past PRSE deal, or investment advice. It is a teaching file built to expose how a believable business plan can produce a thin result.

In the fictional investment meeting, the renovation slide gets nods. Then the underwriter walks to the whiteboard and writes one question:

What did we pay to create the improvement?

The room gets quieter. Good. Now the case can begin.

Cedar Row gets one whiteboard

Our fictional property is Cedar Row, a 96-unit apartment community. It is 94% physically occupied. Average in-place rent is $1,150. Seventy-two units have older interiors. The broker says renovated competitors achieve $1,375.

The asking price is $9,600,000, or $100,000 per unit. The proposed loan is 70% of purchase price: $6,720,000 at 7.25% interest-only. Annual debt service is $487,200.

“Enough coverage?” someone asks.

At the start, yes. Initial debt-service coverage is about 1.37x. The phrase after the number is the important one: if the plan behaves.

The trailing file produces this starting income:

Starting operation	Annual amount
Gross potential rent: 96 x $1,150 x 12	$1,324,800
Collected rent after vacancy, concessions, and bad debt	$1,218,816
Other income	$69,120
Effective gross income	$1,287,936
Operating expenses	($620,000)
Starting NOI	$667,936

Initial debt-service coverage is about 1.37x: $667,936 of NOI divided by $487,200 of debt service.

The renovation slide wins the first round

The operator plans to renovate 72 units over 24 months as residents naturally move out. Interior work is budgeted at $18,000 per unit:

72 x $18,000 = $1,296,000

Exterior, mechanical, and common-area work adds $420,000. A 15% construction contingency adds $257,400. Total planned capital is $1,973,400.

If all 72 renovated units earn the full $225 monthly premium, annual gross rent increases by $194,400. After a 5% allowance for vacancy and collection loss, the modeled net rent increase is $184,680. New fees add $28,800. Stabilized operating expenses rise $85,000 because payroll, repairs, taxes, insurance, and turnover do not freeze while rents grow.

The projected stabilized NOI is therefore:

$667,936 + $184,680 + $28,800 - $85,000 = $796,416

The work created $128,480 of NOI. Real improvement.

The operator points to that number. The underwriter circles the total cost instead. Both numbers belong in the same story.

Count the full cost before the vote

Add $250,000 of closing and due-diligence costs plus $1,973,400 of capital work:

All-in basis	Amount
Purchase price	$9,600,000
Closing and due diligence	$250,000
Renovation and contingency	$1,973,400
Total cost before financing carry	$11,823,400

At a 6.25% exit cap, $796,416 of NOI implies $12,742,656 of value. The spread over cost is $919,256. After a hypothetical 2% sale cost, roughly $664,000 remains before financing carry, taxes, compensation, or construction misses.

Now move one assumption. At a 6.75% exit cap, the same stabilized NOI is worth about $11,798,756. That is less than the all-in cost before financing carry.

At a 6.25% exit cap, the room is still talking. At 6.75%, it stops.

The apartments performed. The buyer paid too much for the work.

That is value-add risk in plain English: execution can succeed while the investment fails.

The file that gets to disagree

The broker deck gets you oriented. It does not earn your trust. For this hypothetical, the useful evidence would be:

• the current rent roll with unit number, floor plan, lease dates, actual rent, concessions, deposits, and delinquency;
• sampled signed leases, 36 months of operating statements, bank deposits, and general-ledger detail;
• trailing three-month collections, bad debt, concessions, notices, move-outs, and vacancy loss;
• competitor leases or rent evidence adjusted for size, finish, fees, location, and concessions;
• a property-condition assessment, unit walk notes, roof and HVAC ages, plumbing history, code notices, and open work orders;
• contractor scopes with labor, materials, exclusions, schedule, retainage, warranty, and change-order rules;
• current tax assessments, post-sale tax analysis, binding insurance quotes, utility bills, and payroll detail;
• the lender term sheet, rate-cap quote, reserve requirements, covenants, extension tests, and maturity date;
• appraisal, survey, title, zoning, and Phase I environmental reports; and
• the operating agreement and offering documents showing who funds overruns, controls a sale, and gets paid before investors.

Fannie Mae’s guidance is useful even when the loan is not a Fannie Mae loan. Its cash-flow framework calls for objective measures, historical statements, vacancy, concessions, bad debt, line-item expenses, and reserves. The framework makes each claim bring identification.

Three good leases try to speak for seventy-two units

The cleanest trick takes three successful renovations and lets them speak for every classic unit on a perfect schedule. Reality sends renewals, plumbing surprises, a missing crew, and an insurance increase.

Other failure modes are just as ordinary:

• the “comp” is newer, larger, better located, or offering six weeks free;
• physical occupancy is quoted while collections and bad debt deteriorate;
• the capex budget covers surfaces but not roofs, sewer lines, electrical panels, or drainage;
• renovated units are offline longer than the model allows;
• taxes are held at the seller’s assessment and insurance at an expiring premium;
• the loan matures before the property is seasoned enough to refinance; or
• the exit cap is tighter than the going-in cap because the model needs a rescue.

Red flags are not merely low numbers. They are missing connections. Slow down when the rent premium is not tied to signed leases, the construction schedule is not tied to cash burn and unit downtime, or the refinance is not tied to a lender’s DSCR and LTV tests.

The questions asked before the vote

Ask the operator:

• How many renovated leases, at what effective rent after concessions, support the $225 premium?
• What happens if only 45 units turn during the hold?
• Which capital items came from the property-condition report rather than the seller’s budget?
• What are taxes and insurance after acquisition, not last year?
• How low does NOI fall while units are offline, and what is DSCR in that month?
• Who funds the first $300,000 overrun, and what do the documents permit?
• What value results from a 6.75% exit cap and a $75 rent premium instead of $225?
• Can the loan be extended, at what cost, and under which tests?

Give the deal worse weather

Before the fictional committee votes, it takes the operator’s stabilized NOI and divides it by an exit cap rate 0.50 percentage points higher than the base case. Then it subtracts purchase price, closing costs, capital work, financing carry, and disposition costs.

If that one move erases the profit, label the deal correctly: not broken, not fraudulent, just priced with no room for weather.

Authoritative reading behind the exercise

• Fannie Mae: Underwritten Net Cash Flow, including historical operations, vacancy, concessions, bad debt, expenses, and reserves.
• Fannie Mae: Property Condition Assessment Underwriting Guidance, covering inspections, deferred maintenance, life-safety items, and replacement needs.
• Fannie Mae: Refinance Risk Analysis, a useful reference for testing refinance DSCR, LTV, interest rate, and reversion cap assumptions.
• EPA: All Appropriate Inquiries, the federal framework behind pre-acquisition environmental inquiry and current Phase I standards.

Cedar Row does not exist. The arithmetic does.

The transferable rule is to judge value-add on the spread between total cost and downside value—not on the beauty of the renovated units. If execution succeeds and the deal still cannot clear its all-in basis at a slightly wider exit cap, the buyer is doing the work while the seller keeps the margin.