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

Rook Opportunity Fund I — Value-Add Mfu

“Four Sun Belt value-add assets, one European waterfall — diversification plus a 33% blended NOI lift.”
MARKETDiversified Sun Belt value-add multifamily · 4-asset fund
PRIMARY PRICE$44,000,000 · $48.0M total capitalization
BASE-CASE LP IRR / EM15.1% · 2.44x
HOLD / EXIT CAP7 years · 5.75%
§1 · Investment Highlights

Why this deal, in six lines

$18.0M LP raise · $48.0M total capitalization
Four metros: Nashville, Charlotte, Tampa, San Antonio
5.73% blended in-place → 7.64% stabilized on cost
15.2% LP IRR · 2.44x; GP promote above 15%
European waterfall, 8% pref, aligned GP co-invest
Exit at 5.75% on $3.78M stabilized NOI
§2 · Executive Thesis

Diversify single-market risk across four Sun Belt value-add multifamily assets

The deal in brief. Rook Opportunity Fund I is a $18.0M LP equity vehicle deploying into a diversified four-asset Sun Belt value-add multifamily portfolio ($48.0M total capitalization). A portfolio renovation program lifts blended NOI from ~$2.52M to ~$3.36M stabilized; under a European waterfall the fund returns a 15.15% LP IRR and 2.44x equity multiple over a 7-year hold, with the GP earning promote only above the hurdles.

Diversified Hold & Distribute

Four-asset Sun Belt portfolio reduces single-market risk and delivers a blended, growing distributable yield through the hold.

Value-Add Execution

A portfolio renovation program marks blended rents to market, lifting NOI from ~$2.52M (Year 1) to ~$3.36M (Year 3 stabilized).

Aligned Promote

European waterfall returns all LP capital and an 8% pref before the GP earns promote — institutional LP protection with GP upside above the hurdles.
§3 · Headline Returns — Base Case

Base-case returns, clearing the institutional hurdle

LP IRR
15.1%
Hurdle ≥ 12%
LP Equity Multiple
2.44x
7-year hold
Project IRR
15.5%
> LP IRR
DSCR · Year 3
1.56x
stabilized
Entry Cap
5.73%
in-place
Exit Cap
5.75%
disposition
§4 · Value Creation

A portfolio renovation lifts blended NOI from $2.52M to $3.36M

A $2.4M portfolio renovation marks blended rents to market, lifting fund NOI from $2.52M (Year 1) to $3.36M (Year 3, stabilized) — a 33% lift diversified across four metros.
NOI bridgeYear 1Year 3 (stab.)Year 7 (exit)Lift
Net Operating Income$2,520,000$3,360,000$3,781,710+50%

Capital Stack — total project cost $48,000,000 · 62.5% loan-to-cost

Senior Debt
$30,000,000 · 62%
LP Equity
$16,200,000 · 34%
GP Co-Invest
$1,800,000 · 4%

Sources & Uses

UsesAmount
Purchase Price$44,000,000
Closing & Acquisition$880,000
Portfolio Renovation Program$2,400,000
Reserve$720,000
Total Uses$48,000,000
SourcesAmount
Senior Debt$30,000,000
LP Equity$16,200,000
GP Co-Invest$1,800,000
Total Sources$48,000,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, an upside and a downside stress, an unlevered all-cash case, a cash-out refinance-and-hold, and an early exit. The spread frames the risk envelope around the base case.

ScenarioStructure / ExitLP IRRLP EMProject IRRDSCRHold
Base CaseLevered 62% LTC · sell Year 7 · exit 5.75%15.1%2.44x15.5%1.56x7-yr
UpsideIncome +4% · exit 5.50% · Year 717.2%2.71x18.0%1.62x7-yr
Downside / StressIncome -5% · exit 6.25% · Year 711.5%1.99x11.4%1.48x7-yr
All-Cash (unlevered)No debt · sell Year 7 · exit 5.75%10.5%1.84x10.2%n/a7-yr
Refinance & HoldCash-out refi Year 3 · hold to Year 1015.5%2.84x16.0%1.27x10-yr
Early ExitLevered · sell Year 5 · exit 5.75%16.2%2.01x16.7%1.56x5-yr
Read-through. Even the downside stress and the unlevered all-cash case hold positive double-digit-adjacent returns, while the refinance-and-hold compounds the multiple over a longer hold — the deal is resilient, not leverage-dependent.
§6 · Replacement-Cost Arbitrage — Cost-to-Build vs. Acquisition

Acquired below the cost to build it new

Replacement-cost-new indicates a $46,800,000–$57,700,000 band (mid $51,700,000), before any value for the in-place income or operating platform. At $44,000,000 the buyer acquires -15% versus mid replacement cost — structural downside protection independent of the income thesis.

ComponentLowMidHighBasis
Asset 1 — Nashville MFU$14,500,000$16,000,000$17,800,000Replacement cost new
Asset 2 — Charlotte MFU$12,500,000$13,800,000$15,400,000Replacement cost new
Asset 3 — Tampa MFU$11,000,000$12,200,000$13,600,000Replacement cost new
Asset 4 — San Antonio MFU$8,800,000$9,700,000$10,900,000Replacement cost new
Total Replacement Cost (new)$46,800,000$51,700,000$57,700,000Sum, undepreciated
Acquisition Price$44,000,000$44,000,000$44,000,000Rook primary offer
Acquisition vs. Replacement Cost$-2,800,000 (-6%)$-7,700,000 (-15%)$-13,700,000 (-24%)Green = below replacement (value); red = above
Why it matters. Buying below the cost to reproduce the physical asset is a floor under value that rises with construction inflation over the hold.
§7 · Market Overview

Sun Belt multifamily: in-migration, fading supply, four-metro diversification

Executive Summary. The Sun Belt multifamily thesis rests on sustained domestic in-migration, job growth, and a moderating new-supply pipeline after the 2023–2024 delivery peak. A diversified four-metro fund (Nashville, Charlotte, Tampa, San Antonio) reduces single-market supply and concentration risk.

Cap-Rate Environment. Sun Belt value-add multifamily clears ~5.5–6.5% in-place with stabilized trades in the mid-5% range; cap rates have normalized from the 2021–2022 compression. Underwriting assumes no compression — exit at a 5.75% blended cap on stabilized NOI.

Supply & Demand. Forward supply is decelerating across Sun Belt metros as construction starts and permits retreat; absorption is recovering on job growth and no-/low-income-tax in-migration, tightening occupancy into the stabilization window.

Implication for the Fund. Diversification across four metros and a portfolio renovation program drive a blended NOI lift; the European waterfall aligns the GP to LP outperformance above an 8% pref, with the return earned through execution rather than cap-rate compression.

Cap-Rate Framework

Sun Belt (Tier 2) Multifamily — Fund LevelStabilizedValue-Add / In-Place
Sun Belt MFU — Class A4.50 – 5.25%
Sun Belt MFU — Class B5.50 – 6.25%6.00 – 6.50%
Sun Belt MFU — value-add (in-place)5.50 – 6.50%
Subject — blended 4-asset value-add fund5.75% exit5.73% in-place
§8 · Highest & Best Use

The maximally productive use

Diversified value-add MFU fund (7-yr)

~15.2%
Maximally productive — blended execution under aligned promote.

Single-market concentration

~14–16%
Higher idiosyncratic risk for similar return.

Core-plus stabilized fund

~10–12%
Lower risk; below the value-add hurdle.
§9 · Valuation — Triangulated CMA

Aggregate value reconciled at $50M; the fund acquires at $44M

Low
$45M
cost-floor weighted
Midpoint
$50M
reconciled opinion
High
$54M
stabilized-income weighted

Aggregate income approach (60%) · Sales comparison (30%) · Cost (10%). Fund total capitalization $48M.

Comparable Sales — illustrative composites

#StatusLocationDetail$/unitCapAdj. Note
1SoldNashville, TNvalue-add MFU, 220 units$182K/unit5.6%Blended comp.
2SoldCharlotte, NCvalue-add MFU, 180 units$175K/unit5.7%Blended comp.
3SoldTampa, FLvalue-add MFU, 160 units$190K/unit5.4%Blended comp.
4SoldSan Antonio, TXvalue-add MFU, 200 units$150K/unit6.0%Blended comp.
5ActiveSun Beltportfolio, 760 units$176K/unit5.6%Direct portfolio comp.
§10 · Financial Projections

NOI, levered cash flow, and coverage

YearEGI / RevenueNOILevered CFDSCR
Year 1$4,200,000$2,520,000$720,0001.40x
Year 2$4,900,000$2,940,000$1,140,0001.63x
Year 3$5,600,000$3,360,000$1,201,6181.56x
Year 4$5,768,000$3,460,800$1,302,4181.60x
Year 5$5,941,040$3,564,624$1,406,2421.65x
Year 6$6,119,272$3,671,563$1,513,1811.70x
Year 7$6,302,850$3,781,710$1,623,3281.75x

Sensitivity — LP IRR by price × exit cap

Price \ Exit Cap5.25%5.50%5.75%6.00%6.25%
$40,480,00019.2%18.3%17.5%16.7%15.9%
$42,240,00018.0%17.1%16.3%15.5%14.6%
$44,000,00016.9%16.0%15.1%14.2%13.3%
$45,760,00015.8%14.9%13.9%13.0%12.0%
$47,520,00014.8%13.7%12.7%11.7%10.8%

Green ≥ 12% · Yellow 8–12% · Red below. 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$720,000$648,000$72,000
Year 2$1,140,000$1,026,000$114,000
Year 3$1,201,618$1,081,456$120,162
Year 4$1,302,418$1,172,176$130,242
Year 5$1,406,242$1,265,618$140,624
Year 6$1,513,181$1,361,863$151,318
Year 7$37,502,825$32,962,086$4,540,738
Total$44,786,284$39,517,200$5,269,084
§12 · LP Waterfall — European Structure

All LP capital and an 8% preferred return before the GP earns a dollar of promote

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.1% IRR / 2.44x · GP 18.3% IRR / 2.93x (promote earned only above the hurdles) · Project 15.5% IRR. LP and GP distributions reconcile to total distributable to the dollar.
§13 · Risk Register

Portfolio renovation cost and blended rent achievability

Risk / ExposureAdverse ImpactMitigant
Asset-level renovation scope / cost (4 assets)−$1.2M to −$2.5MPortfolio capex is the largest swing.
Blended in-place rent roll & loss-to-lease−$900K to −$2.0MDrives stabilized NOI and exit across 4 assets.
Market concentration / submarket supply−$600K to −$1.5MSun Belt supply varies by metro.
Property-tax reassessment (4 jurisdictions)−$400K to −$1.0MEach asset reassesses on transfer.
Fund-level financing terms / rate−$500K to −$1.2MBlended agency execution at stabilization.
§14 · Asset Inventory

Component value — Aggregate Income Approach

ComponentValueBasis
Asset 1 — Value-add MFU (Nashville)$13,500,000Income approach, in-place
Asset 2 — Value-add MFU (Charlotte)$11,800,000Income approach, in-place
Asset 3 — Value-add MFU (Tampa)$10,400,000Income approach, in-place
Asset 4 — Value-add MFU (San Antonio)$8,300,000Income approach, in-place
Total$44,000,000