Charles Street Mansion Reunification
1816 · 1818 · 1820 N. Charles Street, Station North — 18 fully furnished apartments (9 with private decks and outdoor kitchens) and 4 ground-floor commercial spaces. Move the inputs below; every figure on this page recalculates from the same model as the Excel workbook.
Scenario inputs
Rents are Year 1 (2029) stabilized. The NIIF loan re-sizes to the lesser of the DSCR, LTV and $3M limits unless you hold it fixed.
Capital stack & costs
Phase 2 capital stack — 1818 + 1820
Share of total phase cost, by source type
Development cost by parcel
Total uses, $ thousands
Operations & coverage
Net operating income vs. debt service
Consolidated, $ thousands per year
NIIF DSCR — residential rent change × NIIF rate
1818 + 1820 only, loan held at the current amount. Red cells fall below the covenant.
Sources & uses
Stress tests
Each row re-runs the full model with the NIIF loan held at the base amount. The capacity column shows what NIIF could lend if it re-sized the loan for that scenario.
10-year pro forma
Rent roll — target vs. market
Assumptions & justification
Base-case values. The Excel workbook's Assumptions tab carries the same list, and the research folder has full citations.