REI Company Financial Dashboard and KPIs

Company-level KPIs provide a holistic view of business health. Revenue metrics: total monthly revenue by stream (wholesale, flip, rental, other), revenue growth rate (month-over-month and year-over-year), and revenue concentration (no single stream should exceed 60% of total). Profitability metrics: net operating income (revenue minus all operating expenses), profit margin by revenue stream, and return on invested capital (total profit divided by total capital deployed). Portfolio metrics: total units owned, portfolio equity, cash-on-cash return on the rental portfolio, and portfolio occupancy rate. Growth metrics: deals in pipeline by stage, average time from lead to close, and capital available for deployment. Cash position metrics: cash in each pool (operating, deal, reserve) relative to targets, and accounts receivable aging. These 15-20 KPIs should be updated monthly and reviewed on a dashboard that highlights metrics trending outside acceptable ranges with color-coded alerts.

Each revenue strategy has specific KPIs that drive performance. Wholesale KPIs: leads per month, cost per lead, contracts per month, assignment rate (contracts successfully assigned), average assignment fee, cost per deal, and net margin. Flip KPIs: projects in progress, average acquisition cost, average rehab cost, average hold time, average gross profit, average net profit after all costs, and ROI per project. Rental KPIs: total units, occupancy rate, average rent per unit, rent collection rate, operating expense ratio, net cash flow per unit, and cap rate. Note KPIs: total portfolio value, weighted average interest rate, delinquency rate, and yield. Monthly review of strategy-level KPIs identifies which strategies are performing and which need intervention. A sudden decline in wholesale lead volume, for example, requires immediate marketing assessment—before the impact flows through to revenue 30-60 days later.

Dashboard implementation follows a four-step process. Step 1: define the data sources—QuickBooks or bookkeeping software for financial data, CRM for deal pipeline data, property management software for rental portfolio data, and project management tool for flip project data. Step 2: establish a data collection workflow—who enters data, when, and into which system. Clean, timely data is the foundation; a dashboard built on stale or inaccurate data is worse than no dashboard. Step 3: build the dashboard—Google Sheets is sufficient for most REI companies (using data feeds from source systems), while larger operations may justify specialized tools like REI software platforms or custom Power BI dashboards. Step 4: establish the review cadence—daily glance at cash position and pipeline activity, weekly detailed review in the operations meeting, monthly deep-dive analysis with strategy adjustments, and quarterly strategic review with portfolio optimization decisions. The dashboard should evolve as the company grows—start with 10 core KPIs and add metrics as new strategies and complexity are introduced.