Financial Model for a Restaurant

Unique financial excel model for restaurants with a strong focus on customer behavior, prices, and marketing.

It helps you to find out which marketing measures you can use to achieve a specific turnover and design a profitable marketing plan for your restaurant.

3-years of monthly statements for income, cash flow, and balance are included.

You´ve got to prepare, prepare, prepare!

I can't stress this enough. Preparation and planning are critical to starting a successful restaurant. And you need to focus on the right things. Today, you need to plan for on-premises and takeaway and delivery, even if you don't think about it right now.

Years of Experience

In the past 25 years, I developed many business plans and excel models for restaurants. I also helped bring a 7-employee café and restaurant out of a crisis, to turn it into a successful leading company with 50 employees and more than 2 million Euro in sales per year.

Questions that Need to be Solved

My model helps you to find answers to questions that have a significant impact on your chances of success:

o How much money do you need?
o How do you get enough customers?
o Which marketing is most effective?
o Should you use delivery apps?
o How profitable are apps like Doordash, Ubereats, or Grubhub?
o How vital are passers-by to get customers?
o How much revenue can you make by promoting on-premises, takeaway, or apps?
o Which results can you achieve with email marketing, online ads, flyers, social media, and direct mail?
o How much money do you need to set up a marketing system?
o What's the impact of upselling, customer behavior, prices, COGS, shrinkage, and theft on your bottom line?
o How many cooks, waiters, managers, and other employees do you need?
o Which costs do you need to consider?
o How many customers can a particular marketing campaign generate?
o How can you forecast sales?
o How much revenue do you need to achieve break-even?
o How can you calculate the prices for food and beverages?

The Structure

o This model is within Excel
o Easy-to-use navigation bar
o Free of macros - so no problems from this side
o Entirely open and has no password protection.
o All sheets are connected,
o The two bonus tools, "Recipe" and "Costing", are stand-alone solutions and are marked dark yellow
o Enter your assumptions in eight sheets. All input fields are marked light yellow.
o Results in ten output sheets, which are marked green.
o The model concludes with the classic three statements for income, cash flow, and balance.
o Optimized for printing
o Detailed glossary with more than one hundred explanations
o Input fields with helpful commentary
o Summary page with core financials and marketing results.

How to Use this Model

Enter your assumptions into the eight input sheets that are marked light yellow:
1. Business
2. Marketing
3. Conversion
4. Pricing
5. Personnel
6. Costs
7. Investment & Depreciation (I&D)
8. Financing
Then check the results and optimize until you are satisfied.

Industry Benchmarks

To help you with your assumptions, you will find several industry benchmarks as reference values.

My Input

My years of practical insights and experiences in the restaurant industry helped me to create a simple but spot-on financial model. Building this model took me more than one hundred hours of work - although I'm experienced with excel.