ILLUSTRATIVE SAMPLE — NOT A REAL PROPERTY OR OFFER.  A fabricated deal built to lightly demonstrate Rook's deal-analysis & modeling product. With a client's real data room, the depth and specificity of a full engagement increase substantially. Not investment advice.
Rook
ROOK
REAL ESTATE DEAL ANALYSIS & FINANCIAL MODELING

Cumberland Crossing — 36-Unit Value-Add Multifamily

“Below replacement cost, below the CMA midpoint — a 37% NOI lift does the rest.”
SUBMARKETAntioch · Nashville MSA, TN
PRIMARY PRICE$6,250,000 · $173,611/unit
BASE-CASE LP IRR / EM15.6% · 2.52x
HOLD / EXIT CAP7 years · 5.65%
§1 · Investment Highlights

Why this deal, in six lines

$173,611 / unit — below replacement cost
6.30% in-place cap, above Nashville's stabilized clearing level
NOI climbs 37%: $394K → $539K over the hold
15.6% LP IRR · 2.52x equity multiple · 7-year hold
5.65% exit cap — no cap-rate compression assumed
Agency-financeable (Freddie SBL) at stabilization
§2 · Executive Thesis

Buy mismanaged, below-market workforce housing in the most-favored U.S. multifamily market

The deal in one paragraph. Cumberland Crossing is a 1995-vintage, 36-unit garden community in Antioch (Nashville MSA), acquired below replacement-cost-new and below stabilized value at a 6.30% in-place cap — a premium to Nashville's stabilized clearing level that reflects below-market rents, not asset impairment. A $500K interior/exterior renovation, full utility-reimbursement (RUBS) capture, and economic-vacancy compression lift NOI 37% to a $478,795 Year-3 stabilized figure, exiting Year 7 at a conservative 5.65% cap.

Hold & Distribute

Stabilize via renovation and RUBS capture; distribute a growing cash yield through the hold.

Refinance & Hold

Agency (Freddie SBL) cash-out refi at stabilization returns ~56% of LP capital while holding to Year 10 at a 2.91x multiple.

Value-Add Exit

Dispose into the deep secondary-market buyer pool at a 5.65% cap on stabilized NOI — the base-case driver.
§3 · Headline Returns — Base Case

A 15.6% LP IRR and 2.52x equity multiple, clearing every institutional hurdle

LP IRR
15.6%
Hurdle ≥ 14%
LP Equity Multiple
2.52x
7-year hold
Project IRR
16.0%
> LP IRR
DSCR · Year 3
1.36x
stabilized
Entry Cap
6.30%
Year-1 in-place
Exit Cap
5.65%
disposition
§4 · Value Creation

A 37% NOI lift — not cap-rate compression — drives the return

NOI grows from $393,831 (Year 1, in-place) to $478,795 (Year 3, stabilized) to $538,888 (Year 7) — a 37% lift funded by a $500K renovation, full utility-reimbursement capture, and economic-vacancy compression.
NOI bridgeYear 1 (in-place)Year 3 (stabilized)Year 7 (exit)Lift
Net Operating Income$393,831$478,795$538,888+37%

Capital Stack — total project cost $6,995,000 · 68.0% loan-to-cost

Senior Debt (68% LTC)
$4,757,000 · 68%
LP Equity (90%)
$2,014,200 · 29%
GP Co-Invest (10%)
$223,800 · 3%

Sources & Uses

UsesAmount
Purchase Price$6,250,000
Closing & Acquisition$125,000
Renovation Capex$500,000
Operating Reserve$120,000
Total Uses$6,995,000
SourcesAmount
Senior Debt (68% LTC)$4,757,000
LP Equity (90%)$2,014,200
GP Co-Invest (10%)$223,800
Total Sources$6,995,000
§5 · Scenario Matrix — Six Capital & Exit Cases

The same acquisition under six structures — base, upside, downside, all-cash, refinance-and-hold, and early exit

One asset, modeled six ways. The base case clears all hurdles; the downside stress (rents −5%, exit 6.15%) still returns an 11.5% LP IRR and a 2.0x multiple; the all-cash case isolates the unlevered yield; the cash-out refinance returns ~56% of LP capital at Year 3 while compounding to a 2.91x multiple over a ten-year hold.

ScenarioStructure / ExitLP IRRLP EMProject IRRDSCR Y3Hold
Base CaseLevered 68% LTC · sell Year 7 · exit 5.65%15.6%2.52x16.0%1.36x7-yr
UpsideRents +4% · exit 5.40% · sell Year 717.9%2.84x18.9%1.42x7-yr
Downside / StressRents −5% · exit 6.15% · sell Year 711.5%2.00x11.3%1.29x7-yr
All-Cash (unlevered)No debt · sell Year 7 · exit 5.65%10.4%1.83x10.1%n/a7-yr
Refinance & HoldCash-out refi Year 3 · hold to Year 1015.9%2.91x16.5%1.18x10-yr
Early ExitLevered · sell Year 5 · exit 5.65%16.8%2.06x17.5%1.36x5-yr
Read-through. The spread from downside (11.5%) to upside (17.9%) LP IRR is tight for a value-add deal — a function of the below-market basis and the conservative 5.65% base-case exit. Even the unlevered all-cash case clears a 10% return, confirming the deal is not leverage-dependent.
§6 · Replacement-Cost Arbitrage — Cost-to-Build vs. Acquisition

Acquired at or below the cost to build it new

Replacement-cost-new across the four physical components indicates a $6,097,200–$7,697,400 band (mid $6,897,300), before any value for the in-place income or operating platform. At the $6,250,000 primary price the buyer acquires 647,300 below mid replacement cost (-9%) and ~19% below the high estimate; at the conservative low estimate the entry is roughly at replacement. The renovation then drives NOI 37% higher — value creation layered on a near- or below-replacement entry.

ComponentLowMidHighBasis
Land / Site (2.5 ac)$1,020,000$1,200,000$1,380,000Infill multifamily land, $/ac band
Buildings / Units (34,740 SF)$4,516,200$5,037,300$5,558,400$130–$160/SF replacement cost new
Site Improvements$408,000$480,000$552,000Parking, drives, landscape, amenity (new)
FF&E$153,000$180,000$207,000Appliances, fixtures, common-area (new)
Total Replacement Cost (new)$6,097,200$6,897,300$7,697,400Sum of components, undepreciated
Acquisition Price (primary)$6,250,000$6,250,000$6,250,000Rook primary offer
Acquisition vs. Replacement Cost$152,800 (+3%)$-647,300 (-9%)$-1,447,400 (-19%)Green = below replacement (value); red = above
Why it matters. Buying at or below the cost to reproduce the physical asset is structural downside protection independent of the rent thesis: the floor under value is the cost to build, which rises with construction inflation over the hold.
§7 · Market Overview — Nashville Multifamily

Nashville: supply fading, demand durable, ranked the most appealing U.S. multifamily market

Macro & regional. Nashville enters mid-2026 as one of the most favorably positioned U.S. multifamily markets. After peak completions in 2023–2024 pushed vacancy higher and flattened rents, deliveries and absorption are converging; market vacancy holds near 8.5% while stabilized assets run ~94.3% occupancy. The Arbor-Chandan matrix ranked Nashville the single most appealing multifamily market for investors.

Antioch submarket. Antioch is a workforce-housing corridor in southeast Davidson County; average apartment rent runs ~$1,465 and the 2-bedroom average clusters at $1,500–$1,560, below the metro asking average of ~$1,643 — the affordability gap the value-add program is designed to close.

Supply & demand. Trailing-12 absorption reached ~8,700 units, nearly matching new supply, and forward supply is decelerating sharply: units under construction are down ~25% and annual permits off more than 50%, with deliveries projected to fall a third consecutive year. The competitive lease-up supply that pressured 2024–2025 rents is structurally diminishing into the hold.

Transaction climate & exit liquidity. Cap rates have normalized to the mid-5% range overall (Class A 4–5%; value-add/core-plus 6–7%). Tennessee's no-income-tax in-migration and ~24,000 projected new jobs support demand. A renovated, stabilized Class B asset exits into the deepest, most liquid buyer pool in the asset class — private syndicators, regional funds, and agency-financed operators.

Cap-Rate Framework — Nashville (Tier 2)

Nashville (Tier 2) MultifamilyStabilized CapValue-Add In-Place
Class A — new construction / luxury4.75 – 5.50%
Class B — 1990–2010 vintage5.50 – 6.25%6.00 – 6.50%
Class C — pre-1990 workforce6.25 – 7.25%6.50 – 7.50%
Subject — Class B value-add5.65% exit6.30% in-place
What the market says about the price. Acquiring a Class B asset at a 6.30% in-place cap is a premium to the stabilized mid-5% clearing level — the buyer is paid for taking below-market rents and execution risk, not for impaired quality. The 5.65% exit assumes no compression; the return is earned through NOI growth.
§8 · Highest & Best Use

Value-add renovation hold is maximally productive

Value-Add Renovation Hold

~15.6%
Maximally productive — rent-and-expense reset, agency-financeable.

Light Core-Plus Hold

~10–12%
Lower capital at risk; forgoes the rent reset.

Continue As-Is

~7–9%
Harvests in-place yield only; leaves the spread uncaptured.
§9 · Valuation — Triangulated CMA

Three approaches converge at $6.5M; we enter at $6.25M

Low
$6.10M
cost-floor weighted
Midpoint
$6.50M
reconciled opinion
High
$6.90M
sales-comp weighted

Income approach (55%) · Sales comparison (35%) · Cost (10%). Rook primary offer $6.25M, below the midpoint.

Comparable Sales — illustrative composites

#StatusLocationDetail$/UnitCapAdj. Note
1SoldAntioch, TN44 units · 1996$170,0005.7%Similar vintage; no adj.
2SoldMadison, TN60 units · 1985$155,0006.1%Older; +5% condition adj.
3SoldDonelson, TN32 units · 1999$185,0005.4%Superior location; −4% adj.
4SoldSE Nashville, TN50 units · 2003$195,0005.2%Newer; −7% vintage adj.
5ActiveAntioch, TN38 units · 1994$180,0005.6%Direct comp; list −3%.
6ActiveAntioch, TN28 units · 1990$175,0005.9%Smaller; +2% scale adj.
§10 · Financial Projections

Seven-year NOI, levered cash flow, and coverage

YearEGINOILevered CFDSCR
Year 1$672,067$393,831$96,5181.32x
Year 2$719,940$435,564$138,2521.47x
Year 3$754,008$478,795$127,3191.36x
Year 4$776,628$493,159$141,6831.40x
Year 5$799,927$507,954$156,4781.45x
Year 6$823,925$523,192$171,7161.49x
Year 7$848,643$538,888$187,4121.53x

Sensitivity — LP IRR by purchase price × exit cap

Price \ Exit Cap5.15%5.40%5.65%5.90%6.15%
$5,750,00020.1%19.1%18.1%17.2%16.3%
$6,000,00018.8%17.8%16.8%15.9%15.0%
$6,250,00017.6%16.6%15.6%14.6%13.5%
$6,500,00016.4%15.4%14.3%13.2%12.1%
$6,750,00015.3%14.1%13.0%11.8%10.7%

Green ≥ 14% · Yellow 10–14% · Red < 10%. Base case shaded center.

§11 · Annual Distributions to LP & GP

How the European waterfall splits each year's distributable cash

YearDistributableTo LPTo GP
Year 1$96,518$86,867$9,652
Year 2$138,252$124,426$13,825
Year 3$127,319$114,587$12,732
Year 4$141,683$127,515$14,168
Year 5$156,478$140,830$15,648
Year 6$171,716$154,544$17,172
Year 7$4,951,375$4,320,710$630,665
Total$5,783,341$5,069,480$713,862
§12 · LP Waterfall — European Structure

LP capital and an 8% preferred come first — the GP earns 19.7% only above the hurdles

TierMechanicsSplit (LP / GP)
1 · Return of CapitalPro-rata to LP & GP100% capital
2 · Preferred Return100% to LP until 8% LP IRR8% pref
3 · First PromoteTo a 15% LP IRR80 / 20
4 · Second PromoteTo a 20% LP IRR70 / 30
5 · ResidualThereafter60 / 40
Outcome. LP 15.6% IRR / 2.52x · GP 19.7% IRR / 3.19x (promote earned only above the hurdles) · Project 16.0% IRR. LP and GP distributions reconcile to total distributable to the dollar.
§13 · Risk Register

The five diligence items that move value most

Risk / ExposureAdverse ImpactMitigant
Renovation scope / cost−$250K to −$500KGMP contracting; phased deployment
In-place rent roll & loss-to-lease−$200K to −$450KHome-by-home market-rent verification
Property-tax reassessment on transfer−$120K to −$300KStepped-up basis reserved in stabilized opex
Deferred maintenance (roof/HVAC/plumbing)−$150K to −$350KPCA; capital reserve
Economic vacancy / collections−$80K to −$220KTrailing-12 collections review
§14 · Asset Inventory — Cost Approach

Depreciated component value — the floor beneath the income

ComponentDepreciated ValueBasis
Land / Site (2.5 ac)$1,200,000$480,000/ac infill multifamily land
Buildings / Units (depreciated)$4,130,586$145/SF replacement less 18% depreciation
Site Improvements$350,400Replacement less 27% depreciation
FF&E$180,000Market value
Total (cost approach)$5,860,986Floor beneath the income