
List fixed and per-attendee costs, set the ticket price and fees, and see the break-even attendance, the break-even ticket price, and profit or loss at every attendance level up to capacity.
Most event budgets list costs and hope ticket sales cover them. The question organisers actually need answered is how many tickets have to sell, at what price, before the event stops losing money, and what happens if attendance falls short.
This planner separates fixed costs (venue, speakers, insurance) from per-attendee costs (catering, badges, swag), takes sponsorship off the fixed costs, and works out net revenue per ticket after percentage and per-ticket fees. It shows the contribution each attendee makes, the break-even attendance, the ticket price that breaks even at your expected attendance, and profit at ten attendance levels up to capacity.
Use it before you sign the venue contract and again before you set early-bird prices.
1) On Settings, enter the ticket price, your ticketing provider's percentage fee and per-ticket fee, sponsorship and other fixed income, expected attendance and venue capacity. 2) On Costs, list each cost with its type: Fixed (paid however many attend) or Per attendee. 3) Read Summary for the break-even attendance and price, and Attendance for profit at each level.
Price: $12, one-time. Download: event_budget_ticket_breakeven_planner.xlsx (Settings, Costs, Attendance, Summary) and this guide. Works in Excel 2016 or later, Excel for Mac and Excel on the web; opens in Google Sheets and LibreOffice.
New product, listed 2026-10-29: no sales or reviews yet. Example figures in the workbook are illustrative.
This workbook is a planning tool, not financial, tax or legal advice. Ticketing fees, taxes and venue terms vary; check them with your ticketing provider, venue and accountant before you set prices.