Your Cart
Loading

VAT and Tax Scenario Modeller (Excel)

On Sale
£39.00
£39.00
Added to cart

See what the same prize draw earns under different VAT assumptions before you set your price.

For UK prize-draw and competition operators. Enter one draw (ticket price, tickets, expected sales, prize, other costs, payment fees) and set up three VAT scenarios side by side. For each one, the tool shows you:

  • Draw profit before tax, margin and net VAT due for the draw
  • Break-even tickets and break-even sell-through
  • The ticket price you would need to keep the same profit as your first scenario (assuming you sell the same number of tickets)
  • Profit at sell-through from 25% to 100%
  • The year: profit before tax, UK corporation tax (small profits rate, main rate and marginal relief) and profit after tax
  • Whether yearly ticket takings would pass the VAT registration threshold

What's inside

  • 5 sheets: Start Here, Inputs, Scenarios, Sell-Through, Dashboard
  • Each scenario set by three choices: the VAT rate inside the ticket price, the share of VAT on costs you can reclaim, and whether ticket income counts towards VAT registration
  • Corporation tax rates, limits and the VAT threshold in blue cells you can update (checked against GOV.UK, November 2026)
  • Dashboard warnings: missing inputs, a loss at your expected sales, break-even above your expected sales
  • Calculation sheets protected so formulas aren't typed over by accident (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. It compares the effect of assumptions you choose. It does not say which VAT treatment applies to your draw: confirm that with a qualified tax adviser. HMRC's stated position (letters to operators, July 2026) is that paid entries to draws with a free entry route are standard-rated at 20%; some advisers dispute this. The no-VAT scenario is there for comparison. Corporation tax applies to limited companies only and is worked out for a single company on draw profits; sole traders' income tax is not modelled. 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 (25KB) file