Your Cart
Loading

Annual Financial Planning and Budget Model (Excel)

On Sale
£59.00
£59.00
Added to cart

A 12-month budget built for how a competition business really earns and spends, with a cash view and a VAT reserve.

For UK prize-draw and competition operators. Enter your monthly draw plan (draws closing, average prize, entry price, entry cap, expected sell-through, other direct costs per draw), your overheads in eight categories, opening cash, the cash buffer you want to keep, a VAT scenario, your free-entry share and card fees. The model shows you:

  • A monthly profit and loss: ticket income, gross margin and net result before corporation tax
  • Monthly cash flow and closing cash, checked against your cash buffer
  • A VAT reserve line: the cash to set aside each month and the quarterly payment months
  • Budget vs actual: type in your actuals as each month closes and see the variance in pounds and percent, by month and to date
  • A dashboard with revenue, gross margin, net result, your lowest cash month, warnings and two charts

What's inside

  • 6 sheets: Start Here, Inputs, Monthly Plan, Budget, Budget vs Actual, Dashboard
  • A VAT setting for ticket income (none, or 20% VAT included in the entry price; the rate can be changed)
  • A check on every setting and plan cell; calculation sheets protected (no password)
  • Plain-English definitions and a fictional worked example

Who built it

Ivan Soloviov, The Lottery CFO. 18 years in lottery finance. Former CFO, European national lottery operator. Earlier at IGT/GTECH.

Format

.xlsx file for Microsoft Excel on desktop. Not built for Google Sheets or Excel online. Version 1.0, November 2026. Instant download after payment.

Please note

This is a planning tool, not tax, legal or financial advice. The VAT setting is a modelling choice only and does not say which treatment applies to you: confirm that with a qualified tax adviser. Corporation tax is not modelled. Each draw is counted in the month it closes. Results depend on the figures and forecasts you enter.

Refunds: because this is an instant digital download, refunds aren’t offered once the file has been downloaded. If the file is faulty or won’t open, email ivan@thelotterycfo.com and I’ll fix it or refund you.

Rather have a person check your numbers? A Health Check of selected draws, from £495: thelotterycfo.com/health-check

You will get a XLSX (31KB) file