Use case
Revenue forecasting with an explicit range for the board pack
Forecast monthly revenue from a CSV, separate recurring from one-time revenue, and present a median plan with an 80% range instead of a single number.
A revenue forecast is a communication tool as much as a planning tool. A single number invites either false confidence or an immediate argument about the assumptions. A median and a range make the assumptions visible: the plan is the median, the risk is the low band, the upside is the high band.
The sample is monthly revenue with a seasonal fourth quarter. For a subscription business, forecast recurring revenue and new bookings separately; blending them hides the churn assumption inside an average.
The sample series
The studio below is preloaded with this monthly revenue (usd) series and a 6-step horizon. It is an illustrative example, not a real company’s data. Replace it with your own CSV to run the same workflow.
Show the CSV
month,revenue 2024-01-01,93900 2024-02-01,87300 2024-03-01,82800 2024-04-01,71100 2024-05-01,67900 2024-06-01,65200 2024-07-01,66700 2024-08-01,76900 2024-09-01,84000 2024-10-01,97300 2024-11-01,127900 2024-12-01,132600 2025-01-01,107400 2025-02-01,104400 2025-03-01,89800 2025-04-01,81400 2025-05-01,77200 2025-06-01,77000 2025-07-01,78400 2025-08-01,85700 2025-09-01,101700 2025-10-01,105800 2025-11-01,152800 2025-12-01,151000