Bar Financial Projection Template
Originally published: 06/10/2020 09:08
Last version published: 13/11/2020 22:48
Publication number: ELQ-14684-2
View all versions & Certificate

Bar Financial Projection Template

A financial projection template built specifically for bars

Build realistic projections for your business with this Excel Template catered specifically to bars.
How to use this template:
1) Download our fully unlocked and ready-to-use Excel file.
2) Insert your business’ information on these various input tabs:
- Revenue model enables you to predict your bar’s revenue and costs of goods sold for both direct food, alcohol, and labour costs over a period of five years through predicting the total capacity of the bar and how it will grow over time. Expected spend on food and drinks per customer at various times of the day can also be input. As you input your figures, your cost of goods sold on the financial statement is updated.
-You will be prompted to input your expenses to the operating expense model. This generates the expenses and cash flows on your financial statements. You can input your fixed monthly expenses or monthly expenses as a percentage of revenue for variable items, it’s up to you! Also, you can enter start-up expenses as the first 3 months of the template are broken down individually.
-The general assumptions model is where the hard calculations will be done for you, such as loan amortization, interest, depreciation expenses etc. All you have to do is input information from your balance sheet and the rest is done for you!
-Calculate monthly salaries, taxes and benefits expenses with the salaries and distribution model. It also in turn enables you to plan for distributions to owners.

3) Then, these various output tabs will be automatically updated:
-The ‘at-a-glance’ tab gives a snapshot via financial charts, graphs and ratios that are ready to be used in your pitch deck.
-The financial statements tab containing income statement, cash flow statement and balance sheet (which always automatically balance). Each statement also has monthly breakdowns.
-See how sensitive your model is to a change in certain variables without altering your data with the Investor Dashboard tab. This tab displays your models’ income statement along with a modified income statement that updates as you alter the main assumptions.
If you need a hand with anything, feel free to reach out! We are always happy to answer any queries or questions you may have and can modify any of the templates we distribute.
If this model doesn’t work for you, let us know and we can find a solution to meet your needs

This Best Practice includes
1 Excel File

Acquire business license for $99.00

Add to cart

Add to bookmarks


Further information

Template to create a financial projection for bars

Startup and existing bars seeking investment or loan funding


  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Adam Hoeksema

See all

Any questions on Bar Financial Projection Template?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...