Publication number: ELQ-54531-1
View all versions & Certificate
The 4 Financial Spreadsheets Your Restaurant Needs
Collection of 4 Spreadsheets to help you manage your restaurant's financial projections.
Well thought out, structured, and balanced financial spreadsheets will massively help with the health of your restaurant business. It's important to know not only the current state of your business, but also what your finances will look like in the future. If only looking at the present day, you are not getting insight into the whole story. As a restaurant owner or manager, it's vital that you're consistently updating your financial projections so that you're able to:
Get on top of things early and take measures if you're experiencing low profits
Get an idea of how to plan for investments in the future
Set your business revenue targets that are realistic
Change things for max efficiency before you encounter trouble
Your financial projections- NOT your profit and loss statement- look into the future of your business to help you estimate how much revenue you'll earn and how much you're going to spend on operations.
Whether you're new to the industry or have plenty of experience, you'll want to ensure that you are projecting your expenses and revenue properly. These 4 Financial Spreadsheets (including formulas) that work together will help you to do so!
Revenue spreadsheet template
Controllable costs spreadsheet template
Financial forecast spreadsheet template
Startup costs spreadsheet template
These 4 spreadsheets work in conjunction with eachother to build a financial forecast spreadsheet that gives you complete visibility into how you should expect your business to perform. Here's how you use each sheet to ensure that you get the most accurate projections possible for your restaurant.
1. REVENUE SPREADSHEET TEMPLATE
This spreadsheet will show you
1. Total expected revenue
2. The revenue split between drinks and food
Step 1: Input the amount of days throughout the week you're open.
Step 2: Beneath 'weekends and holidays,' input the holiday and weekend days that you're open
Step 3: Input your average sales for a day midweek
Step 4: The spreadsheet will automatically multiply by 2 your midweek sales number to work out the holiday and weekend sales number. Feel free to change this number based on your own holiday and weekend sales.
Step 5: Input the % of sales that is attributed to food and drink.
2. CONTROLLABLE COSTS SPREADSHEET TEMPLATE
The revenue number calculated in your first worksheet will be transferred over to this worksheet; the controllable costs worksheet. This worksheet can also be referred to as your "prime costs." It shows you:
1. How much you spend on food and drink
2. How much you spend on staff
3. The operational profit margin of your restaurant
Step 1: Work out the Cost of Goods Sold- this should work out a % figure for your food and drink. (Generally, 24-40% is a good ratio for food cost, whilst 20-35% is a good ratio for drink cost.)
Step 2: Input the food cost % and your drink cost %
Step 3: Tally up your costs of labor separately for your front of house, kitchen, and management. You should be able to work out a % of labor costs based on your sales.
Step 4: Input your percentages for labor for your front of house and your kitchen staff.
Step 5: Input the amount you usually spend on management staff in dollars.
3. FINANCIAL FORECAST SPREADSHEET TEMPLATE
Your gross profit, your total revenue, and your operating profit % will be carried over from the first 2 spreadsheets. This financial forecast spreadsheet template will show you:
1. How much you spend on expenses that are "controllable," for example, marketing
2. How much you spend on expenses that are "non-controllable," for expenses utilities and rent
3. How much you're left with that you can call profit after these expenses are deducted
Step 1: Work out % for how much you're spending on promotion and advertising, restaurant and kitchen supplies, and credit card fees based on your revenue currently.
Step 2: Input all % where has been indicated.
Step 3: Input amounts for all the other expenses that have been indicated on the sheet.
The 2 lines at the bottom will be your restaurant's total income amount and your profit margin.
4. STARTUP COSTS SPREADSHEET TEMPLATE
This is a bonus spreadsheet. If you're just starting and you're pre-opening stage, this additional spreadsheet has been created to help you keep an eye on your costs. Starting up a restaurant is a huge undertaking, so you'll want to be conscious of your costs from the get go to ensure that you're spending your startup capital correctly.
While this may not be the most fun part of opening a restaurant, up-to-date financial projections will make so much difference when it comes to making big decisions about your business. Figure out your numbers in advance to avoid emergency money situations as much as you can.
*Originally shared on restaurantsuccess.touchbistro.com*
This Best Practice includes
4 Financial Projection Spreadsheet Templates in Excel
Tiffany Regaudie offers you this Best Practice for free!
download for free
Add to bookmarks
4.1 / 5 (26 votes)
- Rate this Downloadable Tool
Write a review
- Yển Cổn(last updated: 14/04/2020 14:03)
- Rayan(last updated: 23/03/2020 10:59)
- Philippe Haddad(last updated: 02/02/2020 00:03)
- Shepherd Musona(last updated: 13/01/2020 21:54)
- jean-cluade losilo nipyo(last updated: 06/12/2019 11:14)
- Nikhil Munjal(last updated: 30/10/2019 17:06)
- mohamad ashraff zamharir(last updated: 20/08/2019 13:23)
- ChCa(last updated: 23/06/2019 08:44)
- Sanjay Rathi(last updated: 27/05/2019 06:00)
- paul michael sy(last updated: 18/05/2019 10:44)
- A Algamri(last updated: 24/04/2019 12:28)
- Luis Manuel González Nieto(last updated: 06/02/2019 12:37)
- vinh trinh(last updated: 20/01/2019 16:07)
- Ala'a Al Rifai(last updated: 14/01/2019 20:36)
- Najam Us Saqib(last updated: 24/12/2018 08:07)
- Hisham Khayat(last updated: 18/12/2018 11:28)
- HospitalityProfessional(last updated: 29/11/2018 08:53)
- Paul Otieno(last updated: 18/10/2018 11:07)
- aggi nauval(last updated: 18/10/2018 00:06)
- Hassan Tolis(last updated: 09/10/2018 13:05)
- Ch Mehraj Khalid(last updated: 05/09/2018 14:34)
- Ms.Jen(last updated: 15/07/2018 21:27)
- Chris Lazorcheck(last updated: 11/07/2018 22:46)
- samuel sithole(last updated: 11/07/2018 15:27)
- Andre Roos(last updated: 04/07/2018 04:32)
- Anastassiya Pereverzeva(last updated: 07/06/2018 09:26)
People using this Best Practice also downloaded
Restaurant Financial Projections Excel WorkbookFive Sheet Financial Projections workbook in excel for a Restaurant business.projectionsfinanceexpensesfinancial projectionsrestaurant4,014add_shopping_cartfreeby Kartik Srinivasan
Mobile App Startup Excel Financial Model TemplateA complete mobile app startup financial model excel template for you to build your own from.business planstartupfinancial projectionsfinancial modelingfinancial statements2,869add_shopping_cart$89.00by Mahender K. Punhani
Startup Hiring Plan & Financial Projections Mini CourseA startup financial model, powerpoint, and video. Headcount tab included. Use to plan your hiring for the next 3 years.financestartupexcelheadcountspreadsheet655add_shopping_cart$9.00by Mike Lingle
Financial Model for Mobile Payment StartupIncludes assumptions page, income statement, balance sheet, cash flow statement and valuation sheet.income statementfinancemodelbalance sheetstartup3,092add_shopping_cartfreeby Tayfun Uslu
Retailer's BundleA collection of professional MS Excel tools designed to meet your retail industry needs.budgetfinanceprofitabilityexcelretail115add_shopping_cart
10-Year Financial Projections (by month) Excel ModelThis is a highly detailed financial projection model for a 10-year period with monthly detailing.businessp&lfinancemodelcash flow108add_shopping_cart
Commercial Real Estate Valuation Model - LockedAdvanced Real Estate Model, that allows a professional DCF Valuation for Office, Retail or Industrial Propertiesfinancevaluationreal estateexcelcommercial real estate119add_shopping_cartfreeby Julian Scheeff
Financial Planning for SaaS StartupsHow to create a financial plan for an early stage SaaS company.planfinancestartupsaas826add_shopping_cartfreeby Nikos Moraitakis
Saving Interest Calculator Spreadsheet with Variable Interest RatesWith variable savings options and interest rates - Excel Spreadsheetfinanceexcelcompound interest43add_shopping_cartfreeby Dan Solomon
How to make Financial Models Easier to Understand, Use and Audit (5 tips)A guide with 5 tips to build Financial Models easy to Understand, Use and Audit.guidebest practicetipsfinancial modelingfinancial modelling182add_shopping_cartfreeby Matthew Bernath
Discussion feed for The 4 Financial Spreadsheets Your Restaurant Needs
The user community and author are here to help. Go ahead!