Free Excel templates

A free bar financial model in Excel, with a full worked case

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.

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 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.

The book behind this model

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

What is in the file

Six tabs. Blue cells are inputs; every other cell is a formula.

Inputs
Days open and guests per day; the item mix and menu prices; keg, case, liter and bottle costs, pours, mixers and modifiers; variance by product; happy hour; card fees and tips; hours and wages by role and burden; the manager’s market salary; rent, charges, utilities, insurance and other costs; the owner’s actual pay and loan payments; the buyers’ multiples; three stress factors.
Pour Costs
The theoretical cost of each item, its price, its pour cost and its contribution: a pint at $1.49, a mixed drink at $1.20 and a house cocktail at $3.06 in the case.
P&L
Guests, units, sales at menu prices, happy hour discounts, revenue, theoretical cost, variance and actual cost of goods, labor and the tax on tips, prime cost, occupancy, insurance, card fees and other costs, adjusted EBITDA, reported EBITDA and SDE ($292,462).
Break-Even and Stress
Contribution per guest ($17.41), the costs that do not move with guests, the break-even in guests per day with and without loan payments, and what one bartender shift must bring.
Value
An individual buyer’s offer on SDE with an SBA loan and its coverage, and a hospitality group’s offer on adjusted EBITDA.
Checks
A comparison with the figures printed in the book: with the case’s inputs every line reads OK.

Three things to try

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.

Questions

What does a guest leave in the case?

$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.

Does it use macros?

No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.

Can I use it for my own bar?

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.

Related reading