Passive Ownership & Active Monitoring: The 15-KPI Dashboard
Passive property ownership represents a myth. Even "truly passive" syndicated properties require active sponsor monitoring to ensure business plan execution and early problem detection. Direct ownership demands real-time KPI tracking to trigger operational adjustments, capital planning, and refinancing decisions. This guide identifies 15 critical KPIs every CRE owner should track monthly, ranked by materiality and decision impact. The core five metrics comprise the minimum monitoring dashboard; the additional ten provide granular operational visibility and tenant credit assessment.
The Core Dashboard: Five Essential Metrics
1. Occupancy Rate: Definition—occupied units/sqft ÷ total units/sqft. Proforma assumption typically 92–96% stabilized. Red flag if drop >3 percentage points from prior year or decline 2+ consecutive months. Action: declining occupancy suggests rent growth too aggressive, market downturn, or tenant quality issues. Investigate sublease market (tenants subleasing at discounts?) and tenant credit (problems hidden?). Example: proforma 94% occupancy (9,400 sqft of 10,000), month 1 actual 94.2% ✓, month 6 actual 91.5% ✗ (investigate 300 sqft shortfall).
2. Rent Collection Rate: Rent received ÷ rent due in month. Proforma 98–100% for stabilized investment-grade tenants. Red flag if <95% in any month, declining trend 2+ months, or specific tenant >30 days late. Collections <95% indicate tenant financial stress. Collections 85–90% suggest imminent default. Collections 70–80%+ indicate active default; begin eviction. Example: rent due $500K, received $492K (98.4%) ✓, received $445K (89%) ✗ (investigate single tenant in trouble).
3. NOI vs. Proforma (YTD): Actual (EGI - OpEx) ÷ proforma (EGI - OpEx). Proforma 100% of year 1 projection. Track YTD cumulative (smooths seasonality). Red flag if YTD >5% below proforma or month-over-month decline. Action: break out variance (occupancy-driven vs. expense-driven?). Example: YTD Jan–Jun proforma NOI $285K, actual $271K (95% of proforma) ✗. Variance: occupancy 92% vs. 94% proforma ($10K shortfall), expenses $157K vs. $150K ($7K overage).
4. Debt Service Coverage Ratio (DSCR): NOI ÷ annual debt service. Lender covenant 1.2–1.25x minimum. Track annualized (YTD NOI × 12 ÷ elapsed months ÷ annual debt service). Red flag if DSCR <1.3x (approaching lender minimum) or declining trend. Action: if declining, project whether covenant will breach. Model refinance options or operational improvements. Example: YTD 6 months NOI $271K, annualized $542K, debt service $330K, DSCR 1.64x ✓ (safe, cushion 0.39x above 1.25x minimum). If rent declines 10%, annualized NOI drops to $488K, DSCR becomes 1.48x (still safe, declining trend).
5. Expense Ratio: Operating expenses ÷ EGI. Proforma 40–50% for stabilized properties. Track YTD actual ÷ YTD EGI. Red flag if >proforma +2 percentage points or expense spikes in single category. Action: investigate variance by category. Proforma 42%, actual 43.5% ✗. Breakdown: labor +5% ($24K overage), utilities spike $8K (HVAC inefficiency). Action: negotiate labor contracts or reduce headcount; prioritize HVAC maintenance.
Operating & Tenant KPIs: Ten Additional Metrics
6. Tenant Rent Escalation Achievement: Actual rent increases on renewal ÷ proforma escalation. Quarterly tracking (at lease renewals). Red flag if <80% achievement. Example: 5 leases expiring Q2, proforma 2.5% escalation assumed, actual renewals 0%, +1.5%, +2.0%, +3.0%, +1.0% (average +1.5%). Achievement 60% ✗. Action: market rent growth weak; consider 1.5% assumption for remainder of year. 7. Tenant Turnover Rate: # leases expiring ÷ total leases. Proforma typically 10–15% annually. Red flag if actual >proforma by 5+ points. High turnover increases vacancy, TI costs, brokerage expenses. 8. CapEx Spend vs. Budget: YTD actual ÷ full-year budget. Red flag if YTD >120% of prorated budget. Overspending indicates hidden deferred maintenance. 9. Tenant Credit Score (Weighted): Quarterly tracking. Red flag if <650 average or deterioration >20 points YoY. Declining credit suggests portfolio default risk. 10. Top 5 Tenant Collections: Payment status by revenue percentile. Red flag if >30 days late. Concentration risk requires close monitoring. 11. Expense Variance by Category: Labor, utilities, property tax, insurance individually. Red flag if any >110% of proforma. 12. Debt Service Payment Status: 100% on-time; confirm payment by 5th of following month. Missing debt service is default. 13. Actual vs. Proforma Cash Flow: Monthly cash after debt service & capex. Red flag if <80% proforma consistently. 14. Refinance Readiness: Quarterly DSCR, LTV vs. lender requirements. 15. Compliance & Insurance: Quarterly (insurance current, tenant coverage, covenant compliance).
Dashboard Implementation: Build one-page Excel or Google Sheets dashboard tracking all 15 KPIs. Color-code: Green (on proforma or better), Yellow (2–5% below proforma; caution), Red (>5% below; investigate). Update monthly within 10 days of month-end. Review with property manager and lender quarterly, or if red flags emerge. This early warning system prevents $100K+ surprises and enables proactive capital planning.
Frequently Asked Questions
How often should I truly monitor KPIs?
Core 5 KPIs (occupancy, collection, NOI, DSCR, expense ratio): monthly. Operating KPIs (tenant credit, turnover, capex): quarterly. Refinance readiness: quarterly. Most property managers provide monthly reports; extract KPIs independently.
What if property manager data inconsistent?
Request standardized format. If PGI calculated differently each month, require lease-by-lease rent roll. If expenses lumped, request breakdown by category. Standardization prevents hidden variances.
Should I worry if DSCR 1.2x but trending stable?
Yes. 1.2x provides zero cushion; any rent decline or expense spike breaches covenant. Refinance or improve operations to 1.3x+ to create safety margin. 1.2x acceptable only if property rock-solid stable with zero execution risk.
How do I distinguish temporary vs. structural expense overruns?
Track 3–6 month trend. One-month spike could be timing (insurance premium quarterly). Three consecutive months above proforma suggests structural issue. Property tax increases structural; one-time repairs temporary. Investigate root cause for each overage.