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 business tool includes
4 Financial Projection Spreadsheet Templates in Excel
Tiffany Regaudie offers you this business tool for free!
download for free
Add to bookmarks
- 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 tool also downloaded
Restaurant Financial Projections Excel WorkbookFive Sheet Financial Projections workbook in excel for a Restaurant business.projectionsfinanceexpensesfinancial projectionsrestaurant2,642free by Kartik Srinivasan
Financial Model for Mobile Payment StartupIncludes assumptions page, income statement, balance sheet, cash flow statement and valuation sheet.income statementfinancemodelbalance sheetstartup2,083free by Tayfun Uslu
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.financestartupexcelheadcountspreadsheet380$9.00 by Mike Lingle
Retailer's BundleA collection of professional MS Excel tools designed to meet your retail industry needs.budgetfinanceprofitabilityexcelretailNew!
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 flowNew!
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 statements770$89.00 by Mahender K. Punhani
Hotel Investment Appraisal Excel Model TemplateDownload this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.investmentfinanceexcelspreadsheethotel410$49.00 by Mahender K. Punhani
Excel ShortcutsExcel shortcuts are exceptionally useful! In this attachment, I’ve compiled some of my most commonly used shortcuts.tipsfinancial modelingexcelspreadsheetsproductivity46free by Matthew Bernath
Client Corporate Excel DashboardA neat corporate summary report which can be easily adapted to incorporate financial and non financial data.companycorporatefinancedashboardexcel856$99.00 by Marcus Small
SaaS/Subscription Financial Excel ModelRobust financial model/budget for any SaaS or subscription businessfinancemodelaccountingfinancial modelstartup88$20.00 by Evan Diaz de Arce
Discussion feed for The 4 Financial Spreadsheets Your Restaurant Needs
The user community and author are here to help. Go ahead!