🏗️ 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