Book · Julian R. Sterling
Cost per Barrel, Taproom and Wholesale Margins, Excise and Distribution, Capacity and Cash: Running the Numbers of an Independent Brewery
An independent brewery is four businesses under one roof: a small factory, a bar, a wholesale supplier and a borrower. This guide shows the owner how to run the numbers that tie them together: count in barrels before dollars, cost a barrel properly, rank the channels by what a barrel leaves behind, keep excise and the federal filings straight, read the cellar's real capacity, and plan the year to the bank covenant.
One fictional brewery runs through every chapter: Kettlewick Brewing Company, a production brewery with a taproom. It sells 3,600 barrels in 2024 and 3,900 in 2025, yet its EBITDA falls from $570,449 to $479,378 and its debt service coverage from 1.66 to 1.37 against a 1.25 covenant, while the fermenters run at 97.6 percent of practical capacity. On 9 December 2025 the owner chooses between three growth plans run in one model.
What is inside:
The five workbooks of Appendix A reproduce every figure of the case to the dollar: inputs in blue, formulas in black, no macro, no circular reference, a Checks tab in each file. The archive also holds the check-lists of Appendix B in an editable Word file. No sign-up.
The_Craft_Brewery_Owner_Companion_Files.zip (189 KB): Brewery_Cost_per_Barrel.xlsx, Brewery_Channel_Margins.xlsx, Brewery_Capacity_and_Tanks.xlsx, Brewery_Cash_and_Covenant.xlsx, Brewery_2026_Options.xlsx, Brewery_Checklists.docx.
Enter your barrels by channel, your prices and your costs: the calculator returns your cost per barrel, the contribution of each channel, EBITDA, the debt service coverage ratio and your break-even in barrels. Prefilled with the book's case; replace the blue cells with your own.
To read: How do you calculate a brewery's cost per barrel?
To read: How much is the federal excise tax on beer per barrel?
To read: Taproom vs distribution: how much does a brewery make per barrel?
The federal rules in the book are described as read in November 2026: the beer excise rates made permanent at the end of 2020, the excise bond and filing thresholds, the Brewer's Notice, label approval, the aluminum tariff schedule as restructured in April 2026, the 2025 tax law on bonus depreciation and section 179, and SBA SOP 50 10 8. State alcohol laws are not described. This page will note material changes.
Related titles. The full list is on the author page.