Occupancy / stabilized
Stabilized occupancy
OM p. 12 | Rent roll implies 91.8%
- Value
- 94.0%
- Review
- Medium
A static view of source-linked assumptions, reviewer status, deterministic checks, and Excel underwriting output.
Deal file
Illustrative multifamily acquisition
Sources
5 indexed
Open variances
3
Reviewer gate
VP / Director
Output
House model or Keelmark proforma
OM - sample multifamily.pdf
42 pages
IndexedRent Roll - 03.31.26.xlsx
Unit-level occupancy
VarianceT12 Operating Statement.xlsx
NOI baseline
Tie-out issueARGUS Export - Base Case.xlsx
Rollover schedule
MappedSponsor Model v4.xlsx
Growth assumptions
Reviewer holdOccupancy / stabilized
OM p. 12 | Rent roll implies 91.8%
Occupancy / in-place
Rent Roll tab | Matches occupied units
NOI / year 1
T12 / Sponsor Model | Sponsor case is +6.4%
Exit / cap rate
Sponsor Model tab | No third-party support
Capex / reserve
Internal assumption | House policy
Debt / interest rate
Internal debt case | Current debt memo
Revenue / rent growth
Sponsor model / broker memo | Internal case is 2.5%
| Model field | Assumption and source | Value | Status |
|---|---|---|---|
| Occupancy / stabilized | Stabilized occupancyOM p. 12 | Rent roll implies 91.8% | 94.0% | Resolve |
| Occupancy / in-place | In-place occupancyRent Roll tab | Matches occupied units | 91.8% | Review |
| NOI / year 1 | Year 1 NOIT12 / Sponsor Model | Sponsor case is +6.4% | $4.8M | Variance |
| Exit / cap rate | Exit cap rateSponsor Model tab | No third-party support | 5.25% | Review |
| Capex / reserve | Capex reserveInternal assumption | House policy | $350/unit | Approved |
| Debt / interest rate | Debt interest rateInternal debt case | Current debt memo | 5.85% | Approved |
| Revenue / rent growth | Market rent growthSponsor model / broker memo | Internal case is 2.5% | 3.0% | Review |
OM shows 94.0%. Rent roll implies 91.8% occupied units.
Sponsor Year 1 NOI is 6.4% above T12-derived run rate.
ARGUS rollover timing differs from sponsor model schedule.
Inputs!D18
OM / Rent Roll
Approved value
Pending
Inputs!D31
Sponsor Model
Approved value
5.25%
Inputs!D44
Internal assumption
Approved value
$350/unit
Debt!F12
Internal debt case
Approved value
5.85%
Inputs!D22
T12 / Sponsor Model
Approved value
Pending
| Cell | Input field | Approved value | Source | Reviewer status |
|---|---|---|---|---|
| Inputs!D18 | Stabilized occupancy | Pending | OM / Rent Roll | Reviewer gate |
| Inputs!D31 | Exit cap rate | 5.25% | Sponsor Model | Reviewer gate |
| Inputs!D44 | Capex reserve | $350/unit | Internal assumption | Approved |
| Debt!F12 | Debt interest rate | 5.85% | Internal debt case | Approved |
| Inputs!D22 | Year 1 NOI | Pending | T12 / Sponsor Model | Variance review |
Three assumptions remain gated before model export: stabilized occupancy, Year 1 NOI, and rollover timing. Capex reserve and debt rate are approved for model output.
Keelmark can map approved assumptions into an existing team Excel model, or into professionally structured Keelmark proformas for portfolios and deal types without a clean in-house template.