The template will take your unique bar inputs and assumptions to automatically calculate and build your Income Statement (Profit & Loss), Balance Sheet, and Cash Flow statement. Any change you make on the input tabs will automatically be calculated and updated on your financial statements making for easy changes and experimentation. The financial statements are easily exported or printed for lenders.

Financial Statements Included:

• 5 Year Income Statement Annual Summary
• 5 Year Income Statement Monthly Breakdown
• 5 year Cash Flow Statement Annual Summary
• 5 year Cash Flow Statement Monthly Breakdown
• 5 Year Projected Balance Sheet Annual Summary
• 5 Year Projected Balance Sheet Monthly Breakdown

The At-A-Glance tab serves up a comprehensive financial snapshot. Visualize your data with key financial ratios, startup cost estimations, and break-even points. Infographics, charts, and summaries will enhance your presentations, making them compelling for stakeholders, lenders, or investors.

Tables, charts, graphs and dashboards include:

• Profit and loss summary
• Bar startup cost graph
• Key industry financial ratios ​​
• Cash flow from operations graph
• 5 years of monthly and annual profit and loss, cash flow and balance sheet forecasts

Our revenue section helps you create income projections from scratch based on the numbers you know about your bar instead of just guessing what your monthly revenue will be.

• Personalize projections based on capacity, patronage, average spend per customer on alcohol
• Also create a custom food menu to estimate average customer spend on non-drink items
• Factor in takeout items, pricing, and average orders
• Automatically calculate and integrate these revenue forecasts into the financial statements

Direct Costs:

• Estimate the average cost of per food and drink menu item sold to ensure a minimum margin on raw materials
• Calculate the cost of direct labor for servers, bartenders, and kitchen staff, and any other hourly employee

Operating Expenses:

• Begin with a common list of bar and restaurant expenses and adjust to your operation's reality including items like insurance, rent, utilities, and more
• The first 3 months are split out so you can account for higher start up expenses and no recurring operating costs

‍‍
Salaried Employee Expenses:

• Budget efficiently for any salaried employees such as managers, supervisors, and owner compensation
• Include comprehensive employment costs like salary, taxes, benefits, and annual raises and the template will automatically calculate and input the information on the income statement and cash flow statements

In the general assumptions tab, you will input important details like fixed assets to be purchased like the building, furniture, signage, kitchen equipment, and leasehold improvements. As well as loans, investments, and more. The template will automatically calculate some difficult numbers like interest expense and depreciation and then build your balance sheet which will always balance.