Systems · Helm demo

Development model

A working pro forma for a ground-up rental project: budget, construction draws, the construction loan and its interest reserve, lease-up, a refinance at stabilization and a sale. Change any assumption and every number, chart and table below recalculates.

Mill Creek Residences is an invented project and every figure is made up. The model is the one inside Helm, an example of a custom system that can be built.

Showing the demo assumptions.

Total development cost

$14.8M

$246,351 per unit

Yield on cost

6.89%

6.33% untrended

Development spread

164 bps

over a 5.25% cap

Levered IRR

20.1%

12.7% unlevered

Equity multiple

2.12x

$5.8M profit

Value at stabilization

$19.4M

$4.6M over cost

60 UNITS · 50,700 NRSF · EAST AUSTIN, TX (FICTIONAL)

Schedule

  1. PredevelopmentJan 2025 – Feb 2025
  2. ConstructionMar 2025 – Aug 2026
  3. Lease-upSep 2026 – May 2027
  4. Stabilized holdJun 2027 – Dec 2029
  5. Milestones
  • Construction loan closes · Mar 2025
  • Refinance · Jun 2027
  • Sale · Dec 2029

Sources and uses

Uses of funds
USESAMOUNTPER UNITSHARE
Land and closing$2,749,950$45,83318.6%
Hard costs$9,103,500$151,72561.6%
Hard cost contingency$455,175$7,5863.1%
Soft costs$1,037,799$17,2977.0%
Marketing and lease-up$213,000$3,5501.4%
Developer fee$351,308$5,8552.4%
Construction loan fee$96,077$1,6010.7%
Interest reserve and lease-up carry$774,278$12,9055.2%
Total development cost$14,781,087$246,351$248/GSF

SOURCES

  • Equity $5.2M
  • Construction loan $9.6M
Equity, drawn first
$5,173,380 · 35%
Construction loan
$9,607,707
Peak loan balance
$9,607,707
Interest and lease-up carry
$774,278

Capital in the deal

Equity invested and debt outstanding, by monthEquity investedDebt outstanding
$0$5M$10M$15M20252026202720282029

Equity is drawn first, reaching $5.2M by Aug 2025. The construction loan peaks at $9.6M and is refinanced in Jun 2027 with a $11.6M permanent loan; the asset sells in Dec 2029.

Operations

Effective gross income and NOI, by monthEffective gross incomeNOI
-$50K$0$50K$100K$150K$200K202620282029

Income starts at completion in Sep 2026 and ramps through lease-up to stabilization in Jun 2027, when forward 12-month NOI is $1.0M.

Stabilized NOI, next 12 months
$1,018,644
Untrended NOI (today's rents and costs)
$935,621
Average rent
$2,269/mo · $32/SF/yr
Yield on cost
6.89%
Untrended yield on cost
6.33%
Building efficiency (NRSF / GSF)
86.8%

Refinance

Value at 5.25% cap
$19,402,749
Max at 60% LTV
$11,641,649
Max at 1.25x DSCR
$14,552,062
Permanent loan (sized by LTV)
$11,641,649
Construction loan payoff
($9,607,707)
Closing costs
($116,416)
Cash returned to equity
$1,917,526
LTV · DSCR · debt yield
60.0% · 1.56x · 8.8%

Sale

Forward NOI after Dec 2029
$1,099,475
Price at 5.50% cap
$19,990,456
Selling costs
($299,857)
Loan payoff
($11,641,649)
Net proceeds to equity
$8,048,950
Equity in · out
$5.2M · $11.0M
Levered IRR · multiple
20.1% · 2.12x
Unlevered IRR
12.7%

$ THOUSANDS · CALENDAR YEARS

Annual cash flow

Annual cash flow in thousands of dollars
YEARDEV. SPENDFEES + INTERESTINCOMEEXPENSESNOIDEBT SERVICETO EQUITY
2025(9,280)(148)––––(5,173)
2026(4,534)(595)151(199)(48)––
2027(97)(308)1,566(734)832(380)2,141
2028––1,812(775)1,036(652)384
2029––1,866(799)1,067(652)8,464
Total(13,911)(1,050)5,395(2,507)2,888(1,684)5,817

To equity: contributions, operating cash flow after debt service, the refinance and the sale. Fees and interest before stabilization are paid from the loan's interest reserve.

LEVERED IRR

Sensitivity

Levered IRR by exit cap rate and hard cost change
EXIT CAP ↓ · HARD COSTS →-10%-5%BASE+5%+10%
5.00%29.8%27.1%24.5%22.1%19.7%
5.25%27.7%24.9%22.3%19.8%17.5%
5.50%25.6%22.8%20.1%17.6%15.2%
5.75%23.5%20.6%18.0%15.4%13.0%
6.00%21.5%18.6%15.8%13.2%10.8%
Monthly detail (60 months)
Monthly cash flow in thousands of dollars
MONTHPHASESPENDEQUITYLOANDEBT BAL.OCC.NOITO EQUITY
Jan 2025predevelopment(2,906)2,906––––(2,906)
Feb 2025predevelopment(156)156––––(156)
Mar 2025construction(116)212––––(212)
Apr 2025construction(264)264––––(264)
May 2025construction(405)405––––(405)
Jun 2025construction(536)536––––(536)
Jul 2025construction(651)651––––(651)
Aug 2025construction(748)44704704––(44)
Sep 2025construction(823)–8281,531–––
Oct 2025construction(875)–8852,416–––
Nov 2025construction(901)–9163,332–––
Dec 2025construction(901)–9224,255–––
Jan 2026construction(875)–9025,157–––
Feb 2026construction(823)–8566,013–––
Mar 2026construction(748)–7876,800–––
Apr 2026construction(651)–6957,495–––
May 2026construction(536)–5848,079–––
Jun 2026construction(405)–4588,537–––
Jul 2026construction(283)–3388,875–––
Aug 2026construction(135)–1929,067–––
Sep 2026lease-up(19)–1109,17710%(32)–
Oct 2026lease-up(19)–979,27521%(19)–
Nov 2026lease-up(19)–859,35931%(5)–
Dec 2026lease-up(19)–729,43142%8–
Jan 2027lease-up(19)–599,49053%21–
Feb 2027lease-up(19)–469,53663%35–
Mar 2027lease-up(19)–339,56974%48–
Apr 2027lease-up(19)–199,58884%62–
May 2027lease-up(19)–199,60895%7614
Jun 2027stabilized–––11,64295%841,947
Jul 2027stabilized–––11,64295%8430
Aug 2027stabilized–––11,64295%8430
Sep 2027stabilized–––11,64295%8430
Oct 2027stabilized–––11,64295%8530
Nov 2027stabilized–––11,64295%8530
Dec 2027stabilized–––11,64295%8531
Jan 2028stabilized–––11,64295%8531
Feb 2028stabilized–––11,64295%8531
Mar 2028stabilized–––11,64295%8631
Apr 2028stabilized–––11,64295%8632
May 2028stabilized–––11,64295%8632
Jun 2028stabilized–––11,64295%8632
Jul 2028stabilized–––11,64295%8632
Aug 2028stabilized–––11,64295%8732
Sep 2028stabilized–––11,64295%8733
Oct 2028stabilized–––11,64295%8733
Nov 2028stabilized–––11,64295%8733
Dec 2028stabilized–––11,64295%8833
Jan 2029stabilized–––11,64295%8833
Feb 2029stabilized–––11,64295%8834
Mar 2029stabilized–––11,64295%8834
Apr 2029stabilized–––11,64295%8834
May 2029stabilized–––11,64295%8934
Jun 2029stabilized–––11,64295%8935
Jul 2029stabilized–––11,64295%8935
Aug 2029stabilized–––11,64295%8935
Sep 2029stabilized–––11,64295%9035
Oct 2029stabilized–––11,64295%9035
Nov 2029stabilized–––11,64295%9036
Dec 2029stabilized––––95%908,085