Break-Even and Sales Scenario Calculator (Excel)
Know how many tickets your prize draw has to sell before it makes a penny, before you launch it.
You enter your ticket price, ticket cap, free postal entries, expected sales, payment fees, refunds, commission, prizes, marketing and running costs. The calculator shows you:
• break-even tickets, and what % of the draw that is
• your safety margin above break-even
• draw profit and operating margin at your expected sales
• the ticket price you'd need to break even at your expected sales
• profit at 25%, 50%, 60%, 70%, 80%, 90% and 100% sold (you can change the levels)
• three VAT scenarios: none, 20% included in the price, or a rate you choose
Every input has a check beside it, and the dashboard warns you if the draw loses money at your expected sales or needs more than 100% to break even. 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. The VAT scenarios don't say which treatment applies to you.
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