Development Cashflow Monitor & Control Suite
Sunrise Gardens Phase 1
24-month modelLive from Google SheetsFunding gap monitoredAuto-updates every 5 min
Live dashboard
Loading...
Status
Risk
Trigger
Action
Funding position
Risk Level: —
Active risks: —
Top risk: —
Peak gap:
First positive:
Finance drawn:
Outlook
Capital Overview
Total Project Cost
KSh
Gross Revenue
KSh
Gross Margin
KSh — profit
Peak Funding Gap
Max cash shortfall
Facility Headroom
Facility minus peak gap
Collection Rate
Actual vs forecast
Cashflow Status
FUNDED
Receipts critical
Management Brief
Top Risk Driver
Collections below 6 units/month will trigger facility drawdown and reduce available headroom.
Recommended Action
Confirm drawdown availability with lender and review collections weekly. Any sustained run rate below target should trigger immediate intervention.
Management Priority
Maintain sales velocity and closely monitor active construction and market risks during the first 12 months.
Live Signals
Collections Signal
Forecast
Actual
Cum. Shortfall
Rate
Risk Signal
Active Risks
Top Score
Provision
Top Risk
Funding Structure
Facility
Peak Required
Headroom
Covered
Collection Variance
On plan
Actual vs forecast to date
Peak Gap Month
Worst funding gap
Max Monthly Outflow
Highest single month
Total Finance Drawn
KSh vs. facility
Monthly Inflows vs Outflows — 24-month project schedule
Bars show monthly cash movement · Line shows cumulative position · KSh ·  
Funding Gap — Month by Month (KSh)
Negative = cash shortfall ·
Inflow Composition by Type
Total across 24-month project period
Loading...
Monthly Cashflow Schedule — All 24 Months
Red = peak gap · Green = first recovery
MonthInflowsOutflowsNetEquity / FinanceCumulativeFunding Gap
Loading...
Project Assumptions
Loading...
Cost Tracker — Budget vs Actual
Update monthly in Google Sheets
Total Budget
Committed
Actual Spent
Utilisation
Remaining
CategoryBudget (KSh)CommittedActual SpentRemainingVariance %Status
Loading...