Prize-Fund Planning & Affordability Tool (Excel)
Find out how much you can afford to spend on prizes and still keep your margin, before you commit to them.
You enter your draw (price, cap, expected sales, fees, costs), your target profit margin and the prizes you're planning: main prize, cash alternative, instant wins, runners-up, delivery and insurance. The tool shows you:
• your prize budget at your target margin, and at break-even
• your planned prize fund, with the cash alternative weighted by how likely the winner is to take it
• the worst case if the winner picks the more expensive option
• headroom: how far under or over budget your prizes are
• how many tickets you need to hit your target margin with these prizes
• the prize budget at 25% to 100% sold
The DCMS voluntary code says operators should not cut the prize or cancel a draw because sales are slow, so treat the prize fund as a commitment. This tool tells you what you can afford to commit to. A fictional worked example is included.
Built by Ivan Soloviov, The Lottery CFO. 18 years in lottery finance. Former CFO, European national lottery operator. Earlier at IGT/GTECH.
Format: .xlsx for Microsoft Excel desktop. Not built for Google Sheets or Excel online.
Please note: a planning tool, not tax, legal or financial advice.
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