New Draw Financial Feasibility Model (Excel)
Find out whether a new draw's numbers work before you launch it: one clear verdict, Go, Rethink or No-go.
For UK prize-draw and competition operators planning a new draw. Enter your prize cost, entry price, entry cap, free-entry share, card fees, marketing and platform costs, a VAT scenario and your expected sell-through. The model shows you:
- Break-even paid entries, and break-even as a share of the places you can actually sell
- Your expected result, and your result if the draw sells out
- Your result at every sell-through level from 25% to 100%
- Your margin of safety, and a verdict against Go / No-go thresholds you set yourself
- A sensitivity table: expected result for 7 prize levels against 7 entry prices
What's inside
- 5 sheets: Start Here, Inputs, Calculations, Sensitivity, Dashboard
- A VAT setting for ticket income (none, or VAT included in the entry price at a rate you set)
- A check on every input and dashboard warnings; 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 of one draw, 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