🏗️ HSRE Deal Calculator
Assumptions
📋 Deal Info
▾
Project Name
Entity
Deal Type
Location
🏔️ Land
▾
Land Value
$
Land Area
ac
Land Contribution
🏗️ Development Budget
▾
Unit Count
units
Hard Cost / Unit
$
Soft Cost % of Hard
%
Pre-Dev / Other Costs
$
Contingency %
%
💵 Revenue
▾
Avg Unit SF
sf
Avg Rent / Unit / Mo
$
Annual Rent Growth
%
Vacancy %
%
OpEx % of EGI
%
🏦 Financing
▾
Construction Loan LTC
%
Construction Loan Rate
%
Construction Loan Term
mo
🚪 Exit
▾
Exit Cap — Low
%
Exit Cap — Mid
%
Exit Cap — High
%
Hold Period
mo
Selling Costs
%
💰 Fees
▾
Acquisition Fee
%
Disposition Fee
%
Asset Mgmt Fee
%
Construction Mgmt Fee
%
GP Promote
%
Preferred Return
%
Scenario:
Total Dev Cost
—
NOI (Stabilized)
—
LP IRR
—
Mid Scenario
Equity Multiple
—
Mid Scenario
Hold Period
—
Units
—
Capital Stack
Land—
Hard Costs—
Soft Costs—
Pre-Dev Costs—
Contingency—
Financing (Interest)—
Acq. Fee—
TOTAL—
Returns Comparison
Low Mid High
Cap Rate — — —
LP IRR — — —
Multiple — — —
Equity In — — —
Equity Out — — —
Development Budget Detail
Land—
Hard Costs (units × cost/unit)—
Soft Costs (% of hard)—
Pre-Dev / Other Costs—
Contingency—
Construction Loan Interest—
Acquisition Fee—
TOTAL DEV COST—
Cost per Unit—
Cost per SF—
Scenario:

Exit Waterfall

Gross Proceeds at Exit (Stabilized Value)
—
Less Selling Costs
—
Net Proceeds
—
Less Debt Payoff
—
Net Equity at Exit
—
Less Return of Capital (LP)
—
Less Preferred Return
—
Remaining Profit
—
GP Promote
—
LP Net Return (profit share)
—
LP IRR (CAGR)
—
LP Equity Multiple
—

Scenario Comparison

Metric Low Mid High
Cap Rate———
Stabilized Value———
Net Proceeds———
Net Equity———
LP IRR———
LP Multiple———

💡 $100K Example Investment

Investment$100,000
Preferred Return Earned—
LP Profit Share—
—
—× return on $100K

LP IRR Sensitivity: Exit Cap Rate vs. Rent Growth

Color: Green >20% · Yellow 15–20% · Red <15%

Based on Mid scenario cap rate ± 0.50% in 0.25% steps. Uses current assumptions for all other inputs.

📐 Built by Atlas · HSRE Hub · v1.1 (fixed) · For internal use only · Not for distribution
Atlas
Hub Assistant