Download 05 Forecast & Outlook
When the sales plan changes, profit, cash and inventory move by different amounts. Switch between Base, Upside and Downside and read all three together.
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
- Reconcile Opening to the latest actual month first. If the starting balances are wrong, the whole forecast is wrong.
- On Assumptions, pick case 1 Base, 2 Upside or 3 Downside, then adjust the drivers: volume, price, cost, collection days (DSO) and inventory days (DIO).
- Read Outlook for profit together with cash and the balance sheet, not profit alone.
- Before passing the file on, open Checks. If a line fails, do not send it yet.
Read the guide to this report first →
What you need before using it on your own company
- Latest month-end balances for cash, receivables, inventory, payables and fixed assets.
- A monthly sales plan split into volume and price.
- Cost, collection-day and inventory-day assumptions you can explain.
Check the file against the original
The SHA-256 values below come from the pack’s FILE_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 05_Forecast_and_Outlook_TH.xlsx SHA256sha256sum 05_Forecast_and_Outlook_TH.xlsx| File | bytes | SHA-256 |
|---|---|---|
| 05_Forecast_and_Outlook_TH.xlsx | 133,203 | f5b12f989f03fc6e642a3814fc216de1e7568a36954168f27456b27ba389742a |
| 05_Forecast_and_Outlook_EN.xlsx | 126,835 | 569a001f4bf937bda8f29e8c17d0554a1b10f3ea7422e266e27015b27fd2824d |
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.