Model assumptions
Filter: Status = Open only. Won, Lost, and Abandoned deals excluded.
Implementation fees: Each deal is assigned a flat one-time fee (adjustable above, default $10k). The fee is multiplied by the stage probability and then spread evenly across every month in the deal's close window. For example, a Proposing deal (50%) with a $10k fee spread across 5 months contributes $1,000/mo in weighted implementation revenue.
Platform MRR: Each deal's ACV is divided by 12 to get monthly recurring revenue, then multiplied by the stage probability and spread across the close window — the same weighting as implementation fees. Once MRR lands in a month it accumulates forward, so a deal closing in July adds weighted MRR to July and every month after. No churn is modelled.
Close timing: Stage-based forward windows — Contracting months 0–2, Proposing months 1–5, Qualifying months 3–9, Keep Warm months 7–15, To Prioritise months 8–18.
Probabilities: Contracting 80%, Proposing 50%, Qualifying 20%, Keep Warm 8%, To Prioritise 5%.
Growth model: From the selected growth start month, monthly value replaced with prior month's base × (1 + rate)^n.