A free wedding venue booking revenue and break-even calculator in Excel
Type your available dates, site fees, dates used and guests for five kinds of date, the bar package, liquor cost, service charge and caterer's commission per guest, staff and cleaning per event, your fixed costs and your debt service: the sheet returns events a year, revenue and contribution per event, EBITDA, the break-even in events, the coverage of your loans and two what-ifs, with three checks.
The worked example is the book's fictional venue, a converted barn, on its FY2026 figures: 17 peak-season Saturdays at $9,800, 18 shoulder-season Saturdays at $7,500, 70 Fridays and Sundays at $5,400, 51 off-season weekend days at $3,400 and 209 weekdays at $2,000, each at its own share of dates used (events held over available dates) and guest count. The calculator books 83.9 events a year at $11,218.86 of revenue and $8,022.11 of contribution each, for EBITDA of $307,459 against $365,596 of fixed costs: a break-even of 45.6 events and a coverage of 1.96 on $156,468 of debt service.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 166 free models.
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This model goes with The Wedding Venue Owner, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 167 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
3 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
Inputs
Available dates, site fee, dates used (events held / available dates) and average guests for each of five kinds of date; bar package, liquor cost, service charge and the share paid as wages, payroll burden, caterer's commission or in-house food and its margin per guest; staff (bartenders and crew with their burden) and cleaning per event; fixed costs; debt service; the site fee increase to test.
Results
Events, revenue and contribution per event by kind of date and in total, EBITDA, break-even events, debt service coverage, the shoulder-season Saturdays left open and what filling them adds, and what the site fee increase adds.
Checks
Three tests on dates used between 0 and 100 percent, booked dates not above available dates and a positive contribution before a break-even is shown, and an All checks cell.
What the worked case returns
Measure
Value
Events a year
83.9
Revenue per event
$11,218.86
Contribution per event
$8,022.11
EBITDA
$307,459
Break-even events a year
45.6
Debt service coverage
1.96
EBITDA added by filling the shoulder-season Saturdays left open
$43,271
EBITDA added by $500 more on every Saturday's site fee
$14,000
Every figure is a teaching assumption of the book's fictional case, not a market norm. The calculator uses averages by category and leaves out cancellations, postponement fees and unpaid invoices: on the book's case it gives $307,459 of EBITDA where the model, which follows every contract, gives $330,726.
How to use it on your own case
Count your available dates for each kind of date in the year and type the site fee, the share of those dates you expect to hold and the average guests.
Type the bar package, liquor cost, service charge and the caterer's commission per guest, then staff and cleaning per event.
Enter your fixed costs a year and the annual payments on your loans.
Read events a year, revenue and contribution per event, EBITDA, the break-even, the coverage, the two what-ifs and the checks.
Questions people ask about it
How many events does a wedding venue need to break even?
Fixed costs divided by the contribution of the average event. On the book's case this calculator gives 45.6 events a year; the model, which follows every contract, gives 45.3.
Why does the calculator split the dates into five kinds?
Because a peak-season Saturday and a weekday do not earn the same: on the book's case at FY2026 prices, this calculator gives $13,881.30 for a peak-season Saturday and $2,644.92 for a weekday (Results sheet; the book's full model, on each event's own staffing, gives $13,599 and $3,028). A single average date hides the mix.
Why does the what-if stop at the open Saturdays?
Because a lever cannot sell dates the calendar does not have. In the case, 18 shoulder-season Saturdays were available and 14 held, so filling the 4 held by no event (3 never sold, 1 canceled and not resold) adds $43,271 and nothing more.
Is this calculator really free?
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Go further
The free workbooks of The Wedding Venue Owner go further: the full companion set, blank models and the worked cases of the book.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.