Rustomjee PredictiveFlow

A dynamic cash-flow simulation platform that replaces the manual re-plotting of 20 to 30 large project workbooks. Sales, construction, approvals and finance data feed a typed calculation engine, so leadership can drag a project launch or milestone on a visual timeline and see every dependent demand letter, vendor bill and contractor payout cascade downstream. A what-if sandbox tests scenarios such as material costs up 5 percent or sales slower by 20 percent and shows the net cash curve and term-loan requirement update side by side. The Balmoral FY 26-27 master workbook is the baseline schema, with inflow mechanics (payment-plan matrix, demand realisation lag, cumulative milestone catch-up) and outflow mechanics (work-to-cash bridge, vendor credit lag, fixed and variable costs) modelled to match Rustomjee's exact conventions.

Specifications

Features

• 01Interactive GANTT timeline: drag a launch or milestone and cascade the time-delta across all dependent child wings
• 02Inflow engine: old-sales backlog and new-sales pipeline with a configurable payment-plan matrix and a 15-day demand realisation offset
• 03Cumulative milestone gateways that meet payment gates without overbilling
• 04Outflow engine: a construction work-to-cash bridge on a 30-day vendor credit lag, with fixed overheads split from variable activity costs
• 05Copy-on-write what-if sandbox with sliders for construction delay, sales velocity and material cost inflation
• 06Portfolio consolidation of 20 to 30 project cash vectors into a group net cash flow and loan requirement forecast
• 07Deficit and covenant-breach flags projected at least two quarters ahead

Architecture