Restaurant Financial Analysis Template

The restaurant income statement not only measures income but it is also a great tool for managing the business.

Restaurant financial analysis template. A pro forma profit and loss statement. We will go through a restaurant income statement and perform some detailed analysis. This downsized publicly traded restaurant serves the seattle market with more than 80 dishes that include international national and local species of seafood. Download free financial analysis templates in excel.

The restaurant financials template starts with the number of seats in the restaurant and estimates food revenue based on the daily customer turnover and average cover price. What is important in a restaurant financial plan. It helps you to make your analysis with various price and sales volume scenarios yearly quarterly or monthly. Now you can use ms excel to do the complete financial analysis such as horizontal analysis vertical analysis break even analysis sales revenue analysis and more.

This is also known as a pro forma income statement and is simply a statement of revenue and expenses that are made by the business. 82 break even analysis for our break even analysis we assume running costs include our full payroll rent and utilities and an estimation of other running costs. Heres how to populate each sheet to get the most accurate financial projections for your restaurant. After that you can manage your budget assumptions in order to get to the positive side of break even.

These four spreadsheets work together to create a financial forecast spreadsheet that will give you full visibility into how you can expect your restaurant to perform. This excel restaurant financial plan template does it for you automatically. It is normal to include. Annual financial analysis restaurant.

Gabris restaurant lounge is a fine dining establishment in long branch new jersey. Gabris restaurant lounge fine dining restaurant business plan financial plan. The template estimates drink revenue using total customers including bar customers at an average drinks price. In addition to fish they offer beef salads and pasta dishes.

We will explore all possible revenue and cost areas so that you can customize it for your own use. Lets look at a sample template that can be used for a restaurants income statement. Annual financial analysis restaurant.