The pour cost of every drink, the mix and the average check, happy hour and variance, labor and tips, rent, insurance and other costs, a P&L with adjusted EBITDA and SDE, the break-even in guests per day, stress tests and two offers for the bar.
The file follows the Haverline, a fictional neighborhood bar of 2,600 square feet. It serves 140 guests a day at an average spend of $25.08, takes in $1,257,010, earns adjusted EBITDA of $227,462 (18.1%) after a market salary for its manager and breaks even at 103 guests a day. Every figure in the book comes from the full model; this simplified version keeps the same logic and the same results.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Bar_Model_Haverline_Tavern.xlsx (15 KB)
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.
This file is the worked case of The Bar Owner. The book explains every assumption and every tab: what a pour costs, how the average check is built, whether happy hour pays, what the weekly count finds, what a shift must bring, how tips are shared and reported, what the license is worth, why cash falls in January, whether a patio pays, and how two buyers would value the bar.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Six tabs. Blue cells are inputs; every other cell is a formula.
Open a new bar two blocks away. Set the guests factor to 0.88: revenue falls, the schedule, the rent and the insurance do not, and adjusted EBITDA drops to $122,777.
Let the distributors raise prices. Set the beverage cost factor to 1.10 with the menu unchanged: adjusted EBITDA falls to $204,100. Then find the price rise per drink that brings it back.
Count before you trust. Change the spirits variance on the Inputs tab from your own weekly count and watch the pour cost and the year’s EBITDA move.
$17.41 of contribution after goods, card fees, supplies and the employer’s tax on tips, before labor, rent, insurance and the other fixed costs. That is why the bar needs 103 guests a day to break even.
No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.
Yes: replace every blue input, starting with your guests, mix, prices, product costs and pours. The Haverline and every figure in it are fictional case assumptions, not market data.