Multi-Draw Portfolio Planner (Excel)
Every draw you've closed, are running or are planning, on one page and on the same basis.
For UK prize-draw and competition operators running more than one draw. Enter up to 20 draws (status, close date, ticket price, tickets, sales so far, expected final sell-through, prize and other costs) and your monthly business overheads. The planner shows you:
- Expected contribution, contribution margin, break-even tickets and break-even sell-through for each draw
- Where each live draw stands today, and the costs you are carrying on live draws until tickets sell
- A verdict and a rank for every draw: on track to cover its costs, expected loss, or can never break even
- A 12-month calendar: draws closing each month, expected contribution against overheads, and cumulative profit
- Dashboard warnings, including live draws past their close date
What's inside
- 6 sheets: Start Here, Settings, Draws, Draw Results, Calendar, Dashboard
- A VAT assumption for ticket income (none, 20%, or your own rate) and a payment fee %
- A check on every draw line; 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. It is a profit view, not a cash view. 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