Skip to main content
Skip to content
03

Financial modeling

Underwriting analyst

How do operating, capital, debt, and exit assumptions change returns?

Debt Sizing · Eastside Yards

construction facility · LTC / DSCR / debt-yield → $46.0M

Constraints

Stabilized NOI$3,640,000
Total dev cost$74,800,000
Target LTC62%
Min DSCR1.15x
Min debt yield6.5%
All-in rate8.10%
AmortizationIO (0-yr amort)
Term / IO3yr / 36mo

On an IO construction facility the DSCR / debt-yield maxes sit right at the sizing, so loan-to-cost binds. An amortizing 30-yr take-out raises the constant → maxByDSCR falls and DSCR could bind instead.

Sized loan · IO construction

Max by LTC (62% of cost)$46,376,000
Max by DSCR (1.15x)$39,076,758◀ Binding
Max by debt yield (6.5%)$56,000,000
Loan amount$39,076,758
Implied LTC52.2%
Implied DSCR1.15x
Implied debt yield9.3%
Annual debt service$3,165,217 (IO)
✓ loanAmount = min(LTC, DSCR, debt-yield) = $39.08M · DSCR-binding

Lender quotes

4 competing term sheets · click to load terms