Your Cart
Loading

Break-Even and Sales Scenario Calculator (Excel)

On Sale
£29.00
£29.00
Added to cart

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

You will get a XLSX (22KB) file