Collective Cash Flow Strategy

Tracking March 2026 → September 2026 path to $330,000 net income across all 13 Collective-owned properties.

Live snapshot: May 11, 2026
Open in Cowork sidebar to refresh from AppFolio

Net Income Goal

$330,000

monthly target by Sept 2026

Last Closed (April)

−$89,398

from AM Deck Feed · March baseline: −$162,289

Gap to Close (monthly)

$492,289

goal − March actual

Total Identified Lift

$494,000

% of gap covered

Baseline Metrics (March 2026)

🔒 Locked baseline

Net Income

—

Rental Income (lot + home)

—

Concessions

—

Utility Income

—

Occupied Rental Units

—

Avg Combined Rent

—

Utility Expense

—

Leasing Agent Expense

—

Permanent baseline — locked at March 2026 and does not update with future months.

Path to Goal — Waterfall (monthly)

Each bar = monthly contribution. Green = revenue lift / expense reduction; blue = utility-related; gray = residual. Final bar is Sept goal.

Initiative Summary — September End Goals

Each card shows the September end-goal monthly total (March baseline + planned change). Residual shows the unallocated lift still to identify.

📅 Last Closed Month vs Baseline (Collective) Updates each month at P&L close

Compare the most recent closed-month totals to the March baseline. Currently showing April 2026 actuals from AM Deck Feed. Each tile shows variance from March baseline plus distance to Sept goal.

March 2026 → Live Side-by-Side

Rental income compares end-of-month rent roll snapshots. Concessions and utility income compare full March vs MTD posted in May.

1 · Vacant Rental Units — Target: $350,000/mo Live · AppFolio Report 612

Goal: 400 units rented at $875/mo combined rate = $350,000/month total. $875 = home rent + lot rent combined. Live columns highlighted in blue show data from May 11, 2026 snapshot. % to Goal cells turn green when hitting (≥100%) or red when missing.

Property	Baseline Occupied (Mar)	Goal: Units	Goal: Rate	Goal Income	Live: Vacant Units	Live: Rented Units	Live: Avg Rate	Live: Total Income	% to Goal

2 · Concessions Reduction — Target: $25,000/mo Live · AppFolio Report 614

March 2026 baseline: $49,971. Goal: reduce by $25k/month. "Live MTD" pulled from AppFolio charges.

Property	March Baseline	Goal Reduction	Target Concessions	Live MTD Concessions	Reduction vs March	% to Goal

3 · Leasing Agent Costs — Target: $8,000/mo 🔒 Locked · Updates monthly

Goal: reduce leasing agent expense by $8k/month. Defaults are even allocation. This metric updates from AM Deck Feed at month-end close.

Property	Baseline (March)	Reduction Goal	Sept Goal	Last Closed Month Expense	% to Goal	Notes

% to Goal = decrease achieved (baseline − last closed) ÷ reduction goal. Cell turns green when ≥100%, red when missing. Last Closed Month = April 2026 (from AM Deck Feed).

4 · Handyman Units (POH lot rent) — Target: $29,000/mo 📝 Manual · Per-asset breakdown TBD

50 handyman units at $575 lot rent = $28,750/mo. Incremental to rental homes above.

Property	Units Goal	Lot Rent	Goal Income	Actual Units MTD	Actual Income	% to Goal

5 · Utility Income — Target: $25,500/mo increase Live · AppFolio Report 614

Recapture income increase. "Live MTD Util Income" pulled from AppFolio Report 614.

Property	Baseline (March)	Increase Goal	Final Income Needed	Live MTD Income	% to Income Goal

% to Income Goal = Live MTD ÷ Final Income Needed (baseline + increase). Cell turns green when ≥100%, red when missing.

6 · Utility Expense — Target: $18,500/mo decrease 🔒 Locked · Updates monthly

Utility expense reduction goal. "Last Closed Month Expense" = April 2026 (from AM Deck Feed).

Property	Baseline (March)	Decrease Goal	Final Expense Needed	Last Closed Month Expense	% to Goal

% to Goal = decrease achieved (baseline − last closed) ÷ decrease goal. Cell turns green when ≥100%, red when missing.

7 · Remaining Delta to Solve — Target: $36,289/mo 📝 Manual

Auto-computed as Gap − sum of identified initiatives. Currently $36,289/mo still unidentified.

Initiative	Owner	Monthly Lift	Actual MTD	% to Goal	Status

Sum of line items vs gap remaining will be shown here as you edit.

Last Closed Month — All 13 Properties (with Variance to Goal)

Property	LCM NI	Var NI	LCM Rental Inc	Var Rental	LCM Occupied	Var Occ	LCM Handyman	Var HM	LCM Concessions	Var Conc	LCM Util Inc	Var Util Inc	LCM Util Exp	Var Util Exp	LCM Leasing	Var Leasing

LCM = Last Closed Month (April 2026, from AM Deck Feed). Variance cells turn green when at or beating the per-property Sept goal, red when missing. Variances are Δ vs goal — positive deltas are good for revenue/occupancy metrics, negative deltas are good for expense metrics.