A free winery cost per bottle and break-even calculator in Excel
Type your cases sold by channel, retail price, club discount and distributor share, acres, vineyard costs and yields, grapes bought, winemaking and bottling costs, excise net of the credit, card fees, shipping not charged, tasting room visitors, fees and hours, fixed costs and debt service: the sheet returns the cost per bottle and per case, the margin a bottle and a case in each channel, EBITDA, the break-even in cases, the coverage of your loans and two what-ifs, with three checks.
The worked example runs on simplified inputs the book draws from its fictional estate winery's FY2026: 6,314 cases sold through the tasting room, the club, direct shipping and one distributor, a $36.60 retail price, 32 acres at $7,284 of vineyard costs an acre and 2.89 tons an acre, 18 tons of grapes bought at $2,500, $41.89 of winemaking and $30.45 of bottling a case. The calculator costs a bottle at $9.53, and a case leaves $213.59 in the club against $105.07 with the distributor. It shows EBITDA of $608,549 against $604,304 of fixed costs: a break-even of 2,697.8 cases and a coverage of 1.20 on $507,601 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 191 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 Winery Owner, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 192 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
Cases sold by channel; retail price, club discount and distributor share; estate acres, vineyard costs an acre and tons an acre; tons and price of grapes bought; cases a ton; winemaking and bottling a case; excise a gallon net of the credit; card fees; shipping not charged a club and a direct shipping case; visitors, tasting fee and bottles poured; hours open and the staff cost an hour with burden; fixed costs; debt service; the two what-ifs.
Results
Cost a case and a bottle, margins a bottle and a case by channel, the year line by line (revenue by channel, tasting fees, shipping, cost of bottles sold, pours, excise, card fees, tasting room staff), EBITDA, contribution a case, break-even cases, debt service coverage and the two what-ifs.
Checks
Three tests that return TRUE or FALSE (shares between 0 and 100 percent, cases a ton and tons an acre above zero before a cost is shown, a positive contribution a case before a break-even is shown), and an All checks line.
What the worked case returns
Measure
Value
Cost a bottle
$9.53
Margin a case, tasting room
$311.50
Margin a case, direct shipping
$278.50
Margin a case, club
$213.59
Margin a case, distributor
$105.07
EBITDA
$608,549
Break-even cases a year
2,697.8
Debt service coverage
1.20
EBITDA added by moving 500 cases from the distributor to the club
$54,260
EBITDA added by $2 more on every bottle's retail price
$100,400
Every pre-filled figure is the calculator's, on inputs simplified from the book's fictional case, a teaching assumption and not a market norm. The calculator costs every bottle at what the frost-hit 2026 harvest will cost and uses one retail price for every channel: it gives $608,549 of EBITDA where the book's case, which follows every bottle and vintage, gives $736,957 for FY2026 (chapter 15 bridges the two).
How to use it on your own case
Type your cases sold in each channel, your retail price, club discount and distributor share.
Type your acres, vineyard costs, yields, grapes bought, cases a ton, winemaking and bottling costs a case.
Enter excise net of the credit, card fees, shipping not charged, the tasting room's visitors, fee and hours, your fixed costs and your loan payments.
Read the cost per bottle, the margins by channel, EBITDA, the break-even, the coverage, the two what-ifs and the checks.
Questions people ask about it
How many cases does a winery need to sell to break even?
Fixed costs, plus tasting room staff, less tasting fees net, divided by the contribution of the average case sold. On its pre-filled inputs this calculator gives 2,697.8 cases a year; the book's case, on its own method, gives 2,844.5.
Why does a club case earn more than a distributor case?
The club pays retail less its discount, the distributor half of retail. On the pre-filled inputs this calculator gives $213.59 a club case against $105.07 a distributor case (Results sheet), after cost, excise, card fees and shipping not charged.
Why is the calculator's EBITDA lower than the book's case?
It costs every bottle at what the 2026 harvest will cost, after a spring frost, $9.53 a bottle, while the case sold older vintages at older costs; it also uses one retail price for every channel. Chapter 15 of the book bridges the two line by line, and chapter 16 restates the case's own EBITDA to the cost of its next vintage, $591,058, before it values the winery.
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 Winery 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.