Expense and Cash Flow Ratio Benchmarks
These benchmark each cost line and cash flow as a percent of revenue. For expenses, lower is better. For cash flow, higher is better.
Debt Service Schedule
| Property |
Line |
Monthly |
Status |
Note |
Sanitized schedule only. Portal logins, account numbers, routing numbers, and passwords stay out of the repo and dashboard.
Current Month Progress
| Month |
Revenue vs Target |
Cash Flow vs Model |
OpEx |
FINEX |
CapEx |
Read |
End-of-Year Run Rate
The target model assumes full collection on the Dec rent roll. At 95% collection, cash flow drops below the red-line floor while heat loans remain active.
| Line |
H1 Actual/mo |
Dec Target/mo |
Target Margin |
Annualized |
$100K Cash Flow Target
Cash flow is after debt. The target is measured weekly: $100K/year equals about $8,333/month or $1,923/week.
| Year |
Revenue |
Cash Flow |
Margin |
Krystel EudyCR Funnel
| Weekly Proof |
Green |
Red |
Source |
Krystel's job is to make sure the numbers are correct through the funnel: rents current, rents collected, OpEx/CapEx/FinEx on track, cash flow produced.
Rent Roll Path
| Property |
Units |
Current/mo |
Dec Reachable/mo |
Stabilized Underwrite/mo |
Dec Lift/mo |
Dec reachable is constrained by the lease calendar. Stabilized underwrite is the rent basis for new underwriting and 2027 renewals.
Rent Increase Tracker
| Wave |
Due |
Effective |
Unit |
Current |
Target |
Lift/mo |
Status |
Owner |
Weekly Check |
This is the weekly lease-up / rent-reset tracker. Replace or extend the CSV when Krystel has a richer lease-up and turn spreadsheet.
Monthly Targets To Hold
| Metric |
Owner |
Current/mo |
Target |
Green |
Red |
Cost Breakdown
| Top 2026 Cost Driver | Property | Date | Amount |
|---|
Monthly Actuals
June includes the lead/capex spike. The dashboard should judge the business against the Dec target model, not last year's rent roll.
Automation
Local cron: Monday scorecard refresh and Thursday L10 preflight:
0 12 * * 1 /Users/muhan/Documents/providence-ceos/scripts/refresh.sh >> /tmp/pvd-refresh.log 2>&1
0 7 * * 4 /Users/muhan/Documents/providence-ceos/scripts/refresh.sh >> /tmp/pvd-refresh.log 2>&1
Manual refresh when a new AppFolio export lands:
cd /Users/muhan/Documents/providence-ceos
python3 scripts/ingest_appfolio.py
open dashboard/portfolio-dashboard.html