FREE WORKBOOK
Rolling 12 Month Forecast
Enter actuals as months close and every remaining month re-projects from the latest one, so the full-year number is alive instead of a January guess.
Join dozens who use this
Who this workbook is for
Anyone whose budget stopped being believed by March
The budget is not deleted, it is demoted: it stays on the sheet as the yardstick the living year is measured against, and the gap between the two is a number with a date on it. The roll is what you steer by; the budget is what you answer for. They are different jobs and this sheet does both.
Anyone who finds out in month eleven
Every month after the months-closed counter re-projects from the latest actual, so one soft month reprices the whole year the day it lands. On the demo, month three comes in soft, months four to twelve re-anchor on it, and the sheet shows the year still beating the £328,800 budget, known in month three rather than discovered in month eleven.
Anyone who wants a forecast that takes ten minutes a month
The routine is three moves: type the closed month’s revenue and costs, nudge the counter on by one, and glance at the growth, margin and fixed-cost dials if you have learned something new. Closed months are facts and never move; everything else follows the dials. That is the entire process, which is why it actually happens monthly.
