Portfolio Overview
Occupancy — Portfolioi
Weighted average physical occupancy by unit count across all stabilized properties.
—
Collections — Portfolioi
Portfolio-wide collections rate = 1 − (Total Delinquent / Monthly GPR).
—
New Lease Trade-Outi
Blended new lease trade-out % across the entire portfolio. Source: Snapshot_Tradeouts
—
Renewal Trade-Outi
Blended renewal trade-out % across the entire portfolio. Source: Snapshot_Tradeouts
—
Net Move-Ins (Month)i
Move-ins minus move-outs for the current month. Positive = growing occupancy. Source: Monthly_v2_Leasing
Delinquency (% GPR)i
Total delinquent amount as % of Gross Potential Rent. >10% = high risk (red), >3% = elevated (yellow).
Expiring Leases (Next 90 Days)i
Count of leases expiring in the next 90 days across all properties.
Renewal Ratio (Trailing 3 Months)i
Renewals / (Renewals + Move-outs). Higher = better retention.
Revenue Growth T-12 YoY
—
Rental Income Growth T-12 YoY
—
Ancillary Income Growth T-12 YoY
—
Expense Growth T-12 YoY
—
Controllable Expense T-12 YoY
—
Non-Controllable Expense T-12 YoY
—
NOI Growth T-12 YoY
—
Monthly NOI Trend i
Portfolio-level NOI by month, trailing 18 months. Source: Monthly_v2_GL
Revenue vs. Expenses i
Monthly total revenue (4xxx) and operating expenses (6xxx). Gap = NOI.
Occupancy Trend (12-Month + Projected) i
12-month trailing occupancy (monthly avg of weekly snapshots) + 3-month forward projection.
Portfolio Scorecard
| Metric |
|---|
| Property ⇅ | Fund ⇅ | Units ⇅ | Occupancy ⇅ | T-12 NOI ⇅ | NOI Trend | DQ % GPR ⇅ | DSCR ⇅ | Unit Exposure (Next 90 Days) ⇅ |
|---|
Fund I
Occupancy
—
Collections
—
New Lease Trade-Out
—
Renewal Trade-Out
—
Revenue Growth T-12 YoY
—
Rental Income Growth T-12 YoY
—
Ancillary Income Growth T-12 YoY
—
Expense Growth T-12 YoY
—
Controllable Expense T-12 YoY
—
Non-Controllable Expense T-12 YoY
—
NOI Growth T-12 YoY
—
Fund Scorecard
| Metric |
|---|
Fund Debt Matrix
Total Principal Balance
—
| Property | Origination Date | Current Principal Balance | Rate Type | Loan Maturity Date |
|---|
| 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)
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 | 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
Scorecard, Summary Data, Occupancy History, and Fund Assets in one workbook.
Waterfall Calculator
Fund Waterfall — Full Distribution Model
Development
Forecasting
Projected NOI (12m)
—
Projected Revenue (12m)
—
NOI Margin
—
Projected CFADS (12m)
—
NOI Trend — Actuals + Projections i
Trailing 12 months of actual NOI (solid) plus 12-month forward projection (dashed). Dotted line = budget.
Revenue Waterfall — Next 12 Months i
GPR → Vacancy → Concessions → Bad Debt → Other Income → Effective Gross Income (EGI)
Projected Expense Breakdown by Category i
Monthly stacked bar of operating expenses by controllable/non-controllable category.
Cash Flow Summary — Proforma
⚙ Assumptions — Revenue / NOI▼
Projected Occupancy (12m avg)
—
Renewal Rate
—
Projected Avg Rent
—
Lease Expirations (Next 6m)
—
Occupancy Trend — Actuals + Projections i
12-month trailing actual occupancy % (solid) + 12-month forward projection (dashed).
Lease Expiration Calendar (Next 12 Months) i
Monthly count of expiring leases. Red = high exposure (>10% of units).
Renewal Rate Trend
Trade-Out % — Renewals vs New Leases
Move-Ins / Move-Outs + Net Absorption
Average Rent Projection
Leasing Projection Summary
⚙ Assumptions — Occupancy & Leasing▼
Current Delinquency
—
Projected Delinquency (6m)
—
Collections Rate
—
Bad Debt Reserve
—
Delinquency Rate Trend — Actuals + Projections i
Total delinquent balance over time. Trailing actuals (solid) + 6-month projection (dashed).
Aging Bucket Breakdown — Stacked Area i
0-30, 31-60, 61-90, 90+ day aging buckets stacked. Watch for 90+ growth.
Delinquency Transition Matrix
iProbability of each aging bucket outcome next month (collected, stays, rolls forward, written off). Derived from trailing 6-month snapshots.
| From Bucket | Collected | Stays | Rolls Forward | Written Off |
|---|
Projected Collections vs Write-Offs
Bad Debt Reserve Trend
Delinquency Projection Summary
⚙ Assumptions — Delinquency & Collections▼
Data Management
Manual Inputs
| Property | Input Type | Value | As Of Date | Updated By | Notes |
|---|---|---|---|---|---|
| Loading... | |||||
Bulk Import (CSV / Excel)
Upload a CSV or Excel file to bulk-update manual inputs. Required columns: property_name (or property_id), input_type, value_numeric. Optional: as_of_date, notes.
📄
Drag & drop CSV/Excel file here, or click to browse
Supports .csv and .xlsx files
Quick Add / Edit
Record Property Disposition
Disposed Properties
| Property | Fund | Units | Sale Date | Sale Price | Dashboard Visibility | Actions |
|---|---|---|---|---|---|---|
| Loading... | ||||||
Audit Log
| When | Who | Action | Entity | Field | Old Value | New Value | Details |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||