Your Cart
Loading

Prize-Draw Profitability Model (Excel)

On Sale
£49.00
£49.00
Added to cart

Check whether a prize draw is likely to make money before you launch it.

Built by Ivan Soloviov: 18 years in lottery finance, former CFO of a European national lottery operator.

For UK prize-draw and competition operators. Enter your ticket price, ticket cap, expected sales, prizes, payment fees, marketing and running costs. The model shows you:

  • Gross ticket revenue, net revenue and draw profit (before tax)
  • Operating margin and prize-cost ratio
  • How many tickets you must sell to break even, and what % of the draw that is
  • Results at sell-through from 25% to 100%, and at five ticket prices (−20% to +20%, same number of tickets sold)
  • The same draw under three VAT scenarios side by side: no VAT on tickets, 20% standard rate, or a rate you choose

What's inside

  • 13 sheets: Start Here, Business Setup, Assumptions, Ticket Revenue, Prize Costs, Payment Fees, Marketing, Operating Costs, VAT Scenarios, Profitability, Break-Even, Sensitivity, Dashboard
  • Every number the model uses on one sheet (Assumptions), with a check next to each one
  • Dashboard warnings: missing inputs, a loss at your expected sales, break-even above 100%, prizes costing more than your takings
  • Calculation sheets protected so formulas aren't typed over by accident (no password)
  • Plain-English definitions and a fictional worked example to show the format

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 (Windows or Mac). It uses standard Excel formulas only, so it works in Excel 2010 or later, including Microsoft 365. 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 sheet shows scenarios only. It does not say which VAT treatment applies to your draw. Confirm that with a qualified tax adviser. Results depend on the figures 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

You will get a XLSX (43KB) file