Portfolio Overview
Portfolio Occupancyi
Weighted average physical occupancy by unit count across all stabilized properties. Source: Snapshot_Occupancy
Portfolio NOI (T-12)i
Sum of trailing 12-month NOI across all stabilized properties. NOI = Revenue (4xxx) + Expenses (5xxx+). Source: Monthly_v2_GL
Gross Asset Valuei
Sum of Fair Market Values from most recent CBRE appraisals. Source: Static_ManualInputs
Delinquency (% GPR)i
Total delinquent amount as % of Gross Potential Rent. >10% = high risk (red), >3% = elevated (yellow). Source: Snapshot_Collections + Monthly_v2_GL
Total Unitsi
Sum of total units across all stabilized properties. Source: Static_Properties / Snapshot_Occupancy
Net Move-Ins (Month)i
Move-ins minus move-outs for the current month. Positive = growing occupancy. Source: Monthly_v2_Leasing
Occupancy by Property i
Color-coded occupancy: green >95%, yellow 90-95%, red <90%. Click a property for detailed trend.
180-Day Occupancy Trend i
90 days trailing (actual) + 90 days forward (projected from signed leases minus expiring). Source: Weekly_Occupancy, Monthly_v2_Leasing
Expiring Leases (Next 90 Days)i
Count of leases expiring in the next 90 days. Source: Monthly_v2_Leasing
Renewal Ratio (Trailing 3 Months)i
Renewals / (Renewals + Move-outs). Higher = better retention. Source: Monthly_v2_Leasing
| Property ⇅ | Fund ⇅ | Units ⇅ | Occupancy ⇅ | T-12 NOI ⇅ | NOI Trend | DQ % GPR ⇅ | DSCR ⇅ | Exposure ⇅ |
|---|
Fund I
Fund Occupancyi
Weighted avg occupancy by unit count within this fund. Source: Snapshot_Occupancy
Worst Occupancyi
Property with lowest occupancy in this fund.
Fund T-12 NOIi
Sum of T-12 NOI for fund properties. Source: Monthly_v2_GL
Fund GAVi
Sum of FMVs for fund properties. Source: Static_ManualInputs
Fund DSCRi
Sum T-12 NOI / Sum annual debt service. Source: Monthly_v2_GL + Static_ManualInputs
YTD NOIi
Revenue annualized minus T-12 expenses. Source: Monthly_v2_GL
| Property | Units | Ownership % | Occupancy | T-12 NOI | NOI Trend | DQ % GPR | DSCR | Exposure |
|---|
Monthly NOI by Property (Stacked)
Waterfall Summary (at Current GAV)
Property Name
Physical Occupancyi
Occupied units / total revenue units. Source: Snapshot_Occupancy
Economic Occupancyi
(GPR - Vacancy - Concessions - Bad Debt) / GPR. Source: Monthly_v2_GL
Exposurei
Vacant units + leases expiring in next 90 days without signed renewal.
T-12 NOIi
Revenue minus operating expenses, trailing 12 months. Source: Monthly_v2_GL
DSCRi
T-12 NOI / Annual Debt Service. Below 1.0 = property can't cover debt from operations.
Delinquency (% GPR)i
Total delinquent amount / GPR. >10% red, >3% yellow. Source: Snapshot_Collections + GL
LTVi
Loan to Value: abs(mortgage payable) / FMV. Source: Monthly_v2_BalanceSheet + Static_ManualInputs
Weekly Occupancy (30d trailing + 90d forward)
Month-End Occupancy (T-12)
Revenue Breakdown (T-12)
Monthly NOI Trend (T-12)
| Unit | Type | Prior Rent | New Rent | $ Change | % Change |
|---|
Delinquency Summaryi
Aging buckets: 0-30, 31-60, 61-90 days. No resident names shown. Source: Snapshot_Collections
Maintenance Summaryi
Open work orders, avg days to complete, top category. Source: Monthly_v2_WorkOrders
Work Orders — Trailing 6 Months
Operating Cash
Total Escrows
Replacement Reserves
Mortgage Balance (UPB)
Leads (Month)
Conversion Rate
Top Source
Revenue & Occupancy Analysis
| Property | Vacancy Loss % | Concession Loss % | Bad Debt Loss % | Total Leakage % | Economic Occ % |
|---|
Economic Vacancy Trend (12 Months)
GPR vs Effective Rent Trend
Budget & NOI Analysis
Budget vs Actual NOI
NOI Waterfall (Latest Quarter)
| Property | T-12 Revenue | T-12 Expenses | T-12 NOI | NOI Margin % | YoY NOI Growth |
|---|
Disposition Analysis
| Property | NOI Momentum (30%) | Debt Timing (30%) | Hold/IRR (25%) | Market Ready (15%) | Overall Score | Recommendation |
|---|
Disposition Scenario Tool
Prepayment Penalty Windows
Investor Returns & Waterfall
Fund Waterfall Calculator
Per-Property Waterfall (Multi-Fund Properties)
| Fund | Capital Deployed | Distributions to Date | Projected Proceeds | Projected MOIC | Est. IRR |
|---|
Loans & Debt
| Property | Lender | Loan Type | Principal | Current UPB | Rate | IO Expiration | Maturity | Amort | Recourse | DSCR | LTV |
|---|
| Property | Notional | Effective Date | Termination | Strike Rate | Index | Premium Paid | Provider |
|---|
| Facility | Principal | Rate | Maturity | Lender | Recourse | Notes |
|---|
| Property | Penalty Structure | Current Penalty Est. | Next Step-Down |
|---|
Loan Maturity & Rate Cap Timeline
SOFR Reference Rates
Quarterly Report Generator
Report Configuration
Waterfall Calculator
Fund Waterfall — Full Distribution Model
Development
Budget: Projected vs Actual
Units Completed / Planned
Lease-Up Progress
Lease-Up Timeline