Download 09 Rolling 12-month forecast
Close a new month, change one cell, and the forecast window and opening balances move with it.
What is inside the file
The sheet list below is read out of the actual workbook when this page is built, not typed. If the file changes, the list changes with it.
Where to look first
- On Assumptions, set K6 to the last fully closed month and pick the case in F6 (1 Base, 2 Upside, 3 Downside).
- Add one complete, non-duplicated row for the new month on Actuals.
- Read Forecast to trace the calculation, then Summary.
- Review Checks across all twelve months, especially negative purchases, cash or debt.
Read the guide to this report first →
What you need before using it on your own company
- Monthly actuals from closed books: revenue, costs, expenses and the key balances.
- Monthly assumptions for the next twelve months.
- Dated one-off items such as CAPEX or dividends.
The advanced reports use a new synthetic dataset. It is not a drop-in replacement for the original pack files, so the figures on this page cannot be compared with reports 01–07 even though the company name and currency are the same. This set also uses cash COGS with depreciation below EBITDA, a different cost definition from the core manufacturing model.
Check the file against the original
The SHA-256 values below come from the extension pack’s MANIFEST.json and are re-checked against the real files every time the site is built; a mismatch fails the build. To verify your copy yourself:
certutil -hashfile 09_Rolling_Forecast_TH.xlsx SHA256sha256sum 09_Rolling_Forecast_TH.xlsx| File | bytes | SHA-256 |
|---|---|---|
| 09_Rolling_Forecast_TH.xlsx | 77,304 | c119c08446ee7ff97e67267edd6553087d98fecd07914796a78d7c7ef28f484c |
| 09_Rolling_Forecast_EN.xlsx | 75,473 | 9eab5afaea74d3384d914f19243a7fde07699930cb948ef6720db41acf44b242 |
Use it in your work, change it, use it inside your company — no permission needed. The one ask is not to resell it as your own product. The figures are synthetic teaching data, not a real company’s results, and someone responsible for finance should review the formulas and costing policy before you run it on real numbers.
Download the workbook
What will you use this file for?
Optional. No personal details.
Thanks. This helps decide which files to build next.