Home>Templates>Restaurant Business Plan: 35-File Starter Templates Kit
Templates

Restaurant Business Plan: 35-File Starter Templates Kit

Most restaurant business plan drafts fail the same way: they open with a sales number that nobody can trace back to a guest sitting at a table. The Restaurant Business Starter Templates Kit starts at the other end. It is 35 files in nine folders: a 44-slide PowerPoint business plan, a 13-section Word plan, 26 numbered Excel workbooks, three ready-made tools, an SOP and food safety plan, a restaurant opening checklist and a PDF guide. The five-year financial model at its centre derives every number from covers.

That matters because covers are the real ceiling on a restaurant. Cover demand times the share you actually seat and serve gives covers; covers divided by party size gives checks; each check carries its food and beverage cost, waste, card and delivery fees, and the discounts and staff meals you give away. In this article I walk through every part of the kit, what each workbook does, and the few decisions that decide whether a new restaurant makes money.

Table of Contents

Watch the Restaurant Business Plan: 35-File Starter Templates Kit walkthrough

In under a minute:

Restaurant business plan presentation cover

Key Features of the Restaurant Business Plan Kit

The kit is built around one fictional worked example, Copper Hearth Kitchen & Bar LLC, a wood-fired, scratch-kitchen neighborhood restaurant and bar in a leased 4,400 sq ft unit, so the presentation, the Word plan and the workbooks agree with each other to the dollar. Think of it as a complete restaurant business plan example you overwrite with your own numbers. Every figure is an illustrative planning assumption, not an industry benchmark.

  • Covers drive everything. Sales come from cover demand, the served rate and the average check for each daypart, not from a guessed growth rate.
  • Year 1 is allowed to lose money. The example takes $1,777,708 in Year 1 with $60,243 of EBITDA and a ($26,790) net loss, then reaches $2,822,927 revenue, $394,449 EBITDA (14.0%) and $230,897 net profit by Year 5.
  • Break-even is explicit. About $1,825k of revenue, 144 covers a day or 23,469 paid checks a year at Year 1 economics, reached in Year 2.
  • Prime cost is on every screen. Food and beverage cost plus labor is the number a restaurant lives on, and the dashboard, the KPI workbook and the weekly flash report all track it.
  • Excel 2013 and later. No XLOOKUP, no dynamic arrays, no add-ins.

Every File in the Restaurant Business Plan Template, Explained

The kit ships in nine folders: presentation, Word plan, financial planning, sales and marketing, operations, people and HR, admin and compliance, business tools and instructions. The READ ME gives a ten-step order that follows how the numbers depend on each other.

The 44-slide PowerPoint business plan

Seven sections: the business, the market, menu and operations, sales and marketing, organization, the financial plan and execution, with native editable charts and tables and speaker notes on 35 slides. It is written to be presented to a lender, an investor or a landlord.

How a guest becomes a paid check

The cover funnel slide breaks the sale into six steps: cover demand, seated and served, check opened, cooked and plated, paid at the table, and comped or voided. Every step has a cost: marketing at the top, the team in the middle, food, waste, fees and comps at the end.

Restaurant business plan cover funnel

The Year 1 ramp-up

Revenue does not start at the run rate. Month 1 is about $125,257 against a December peak of $193,683, and the covers-served rate climbs from 86.0% to 92.5% as the kitchen gets faster. A plan that shows a flat first year is not credible to an experienced lender.

Restaurant Year 1 revenue ramp-up

Menu pricing and engineering

Prices are built from the recipe cost, not guessed. Dinner contributes $72.70 a check at a 29.0% food cost, the bar lifts the dinner check, delivery is priced for the platform commission, and every dish is plotted as a star, plowhorse, puzzle or dog.

Restaurant menu pricing and engineering slide

Restaurant startup costs

$613,846 in total including a 6.0% contingency. The kitchen (oven, line, hood and refrigeration) is the largest share at 33.5%, followed by the dining room and bar and a $70,000 working capital reserve.

Restaurant startup costs slide

Five-year profit and loss

Revenue grows from $1,777,708 to $2,822,927. Year 1 is a loss, and the slide says so; contribution margin holds near 58.5% and the profit after that comes from operating leverage.

Restaurant five-year profit and loss

Working capital and the cash cycle

A restaurant is paid at the table before it pays for the food, so the cash conversion cycle is negative (minus 9 days in the example). The real cash risk is the opening months, when payroll and rent run ahead of covers.

Restaurant working capital and cash cycle

Break-even

Break-even is stated five ways: revenue, covers per day (144 against 140 planned), paid checks (23,469), share of the Year 1 plan and RevPASH. The levers that move it most are serving more of the demand already booking and a faster lunch turn.

Restaurant break-even analysis

Implementation roadmap slide

From forming the company to the grand opening in about six months: finance and legal, lease and licenses, build-out, menu and suppliers, hiring and training, and opening.

Restaurant implementation roadmap slide

Workbook 02: the restaurant financial model in Excel

The Financial Plan Dashboard tells you in one screen whether the plan works: Year 1 and Year 5 revenue, contribution margin, EBITDA, net profit, closing cash and break-even revenue, plus revenue per cover, seat turns, RevPASH, food and beverage cost, labor cost and prime cost.

Restaurant financial model dashboard in Excel

The Planning Assumptions sheet

Yellow cells are yours, white cells are formulas. Cover demand by year, the Year 1 ramp, and the three dayparts (lunch, dinner and bar, and takeout, delivery and catering) with their share of covers, party size, average check, food and beverage cost, packaging, waste, fees and discount allowances all live here.

Restaurant planning assumptions sheet

Profit and loss, month by month

Year 1 month by month, then Years 1 to 5, with check cost split from marketing and fixed operating expenses so you can see exactly where the opening-year loss comes from.

Restaurant monthly profit and loss

Cash flow forecast

Receivables, food and beverage stock and supplier payables every month, then the cash movement and the working capital line held in reserve.

Restaurant cash flow forecast

Workbook 01: startup cost and funding plan

Every cost from an empty unit to the first guest seated: kitchen equipment, the dining room and bar, POS and technology, and brand, with useful life and share of the total. Subtotals recalculate as you type.

Restaurant startup costs workbook

Workbook 05: catering and private event quote calculator

One event, here a rehearsal dinner for 36 guests, is priced from the menu package, the bar package, event staff, room hire and the minimum spend, then service charge, tax and the deposit. The quote comes to $4,481.16, and the margin check shows a 67.9% contribution margin before you send it.

Catering quote calculator in Excel

Workbook 07: covers, table turns and labor planner

Cover demand turns into covers served by daypart month by month, then seats, table turns, RevPASH and labor hours. Labor runs at 45.7% of sales in January and falls below 30% in December, which is exactly why the opening months need funding.

Restaurant covers and labor planner

Workbook 09: restaurant KPI dashboard

Covers served, average check, prime cost, food cost, labor cost and RevPASH against target, then every KPI listed with its status. Comps and voids stand out as off target in the example.

Restaurant KPI dashboard in Excel

Workbook 10: implementation roadmap and risk register

Every task by phase, owner, start and due date, with status and days remaining that update themselves, plus a risk register and a weekly action list.

Restaurant implementation roadmap workbook

The rest of the 26 workbooks

Financial planning: break-even and contribution analysis, loan and working capital planner, expense tracker and petty cash, receivables and payables ageing, budget vs actual, prime cost and weekly flash report, and daily sales takings and till reconciliation. Sales and marketing: local marketing, catering and events plan, invoice and quotation, and a customer master and enquiry tracker. Operations: food and beverage inventory and par levels, supplier master and purchase orders, recipe costing cards and menu engineering, and a food waste and spoilage log. People and admin: employee master, attendance and leave, payroll, server sales and tip pool tracker, asset register and depreciation, license, permit and compliance tracker, and an allergen matrix with food safety temperature logs.

Word documents, PDF guide and bundled tools

The 13-section Word business plan, a restaurant SOP and food safety plan, a six-phase restaurant opening checklist, the READ ME, a sheet-by-sheet PDF guide, plus an organization chart, a QC checklist and a financial planning calendar.

Restaurant Business Plan Kit vs. a Business Plan Writer vs. LivePlan: Feature Comparison

Feature This starter kit Freelance business plan writer LivePlan / Bizplan
Cost One-time purchase $500 to $3,000 per plan $20 to $50 / month, ongoing
Files you own Excel, PowerPoint, Word Whatever they send back Browser only
Setup time Under an hour to your own numbers 2 to 6 weeks Several hours of form filling
Restaurant-specific model Covers, dayparts, checks, prime cost, RevPASH Depends on the writer Generic revenue lines
Recipe costing and catering quotes Included Not included Not included
Tools after opening Till reconciliation, tip pool, payroll and more Not included Not included
Lender-ready presentation 44 editable slides Usually a document only Template export

Who Should Use This Restaurant Business Plan Template

  • Founders opening an independent full-service restaurant, bistro, gastropub or restaurant and bar.
  • Owners preparing a bank loan, SBA, investor or landlord application.
  • Existing operators who want menu costing, labor, prime cost and cash planning in one place.
  • Consultants and bookkeepers who build plans for hospitality clients.

It is not a point-of-sale system: sales and covers are typed or pasted in from your POS reports.

Real-World Use Cases

Elena is opening a neighborhood bistro. She prices her menu from recipe cards first, then sees in the covers and labor planner that the quiet January rota, not the rent, decides how much cash she needs to raise. She takes the funding plan and five-year model to her bank instead of paying a consultant.

Daniel runs a restaurant and wants to grow private events. The catering quote calculator shows the margin on every event before he sends the quote, and the weekly flash report tells him each Monday whether prime cost stayed on target.

Grace is a bookkeeper with three restaurant clients. She reuses the till reconciliation, tip pool, payroll and budget vs actual workbooks for each client.

Advantages of the Restaurant Business Starter Templates Kit

  • One story across 35 files: change the assumptions once and the model, dashboard and break-even follow.
  • An honest Year 1 that shows the opening loss and the cash it takes to survive it.
  • Margin leaks after the pass (waste, comps, voids, fees and staff meals) are in every check.
  • Operating tools you keep using after opening, as well as a plan for the bank.

Opportunities for Improvement

  • No live POS link: sales and covers are typed or pasted in from your till reports.
  • Single-site model; a group of restaurants would need one copy per site or a consolidation sheet.
  • The sample figures are illustrative and must be replaced with your own lease, wage and supplier quotes.
  • License, permit and food safety rules vary by state, county and city, so confirm them locally.

Best Practices

  • Cost five real dishes in the recipe costing workbook before you trust the model’s food cost.
  • Test a 10% drop in covers and check the lowest cash balance still holds.
  • Build the rota from opening hours, not covers: every person on it is a fixed cost.
  • Run the prime cost weekly flash every Monday from opening week.

Explore Relevant Templates

Once the restaurant is trading, the Restaurants & Food Services KPI Dashboard in Excel reports on KPIs, the free restaurant food cost report in Excel covers daily sales and food cost, and the Restaurant Management System V2.0 in Excel VBA handles orders and billing. Planning a different business? See the Retail Shop Business Plan Starter Templates Kit.

Frequently Asked Questions

What is included in the Restaurant Business Starter Templates Kit?

The kit contains 35 files in nine folders: a 44-slide PowerPoint business plan, a 13-section Word plan, 26 numbered Excel workbooks, three ready-made Excel tools, an SOP and food safety plan, a restaurant opening checklist, a READ ME and a PDF guide. Everything is editable, with no subscription.

How long does it take to set up?

Under an hour for the core model. The kit is driven from the Planning Assumptions sheet of the five-year model, so entering cover demand, dayparts, average checks and costs updates covers, profit, cash flow, break-even and the dashboard automatically.

Does it show restaurant startup costs?

Yes. Workbook 01 lists every restaurant startup cost by category with useful life, a contingency and the funding plan. The worked example totals $613,846.

How does this compare to LivePlan or a business plan writer?

A freelance writer charges $500 to $3,000 and takes two to six weeks. LivePlan is a subscription you lose access to when you stop paying. The kit is a one-time purchase, you keep the files and formulas, and the model is built for a restaurant.

Will it work in my version of Excel?

The workbooks work in Excel 2013 and later, including Microsoft 365. They avoid XLOOKUP and dynamic arrays, and none of the planning workbooks needs macros or add-ins.

Are the figures real industry benchmarks?

No. Copper Hearth Kitchen & Bar LLC is a fictional restaurant and every figure is an illustrative planning assumption. The numbers show how a complete plan fits together and must be replaced with your own research.

About the Author

Built by PK, Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.

Conclusion

A restaurant business plan is only as good as the link between the guest who sits down and the check that gets paid. The Restaurant Business Starter Templates Kit makes that link explicit, gives you the back-office tools to keep using after opening, and costs less than an hour of a consultant’s time.

👉 Click here to purchase the Restaurant Business Starter Templates Kit

Instant download · One-time payment · No subscription · Lifetime access

🎥 More tutorials: Youtube.com/@PKAnExcelExpert

Last updated: October 2026

PK
Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!
https://www.pk-anexcelexpert.com