The business plan is essential to any new restaurant venture.
Your odds of succeeding are greatly increased when you study and report your
idea. It is your business resume and map to success. It is the document that
most of the important startup connections will demand to see.
This is the set of linked Excel spreadsheets
that are used to generate the restaurant modeling reports. They were created
while building a business plan for a medium-size full-service operation. During
the construction we consulted with National Restaurant Association endorsed
accounting firms and top tax attorneys. These reports have been used
successfully in hundreds of business plans and have been scrutinized by bankers
and venture capitalists as well as private investors.
This package has
just been completely updated and expanded. Now easier to use with more features
and printable reports!
Below is a list of forms available in the
basic package. Since you have access to the formulas, these forms can be
infinitely customized to fit your project. New forms can be added, existing
forms can be modified, even whole new workbooks can be easily incorporated.
Other forms can be developed and added as needed.
Spreadsheet Report Index:
Click on the links to view a sample
sheet.
Note: The yellow cells are to coded to easily identify where to enter data (and
where not to). The yellow is automatically removed before printing. These are
actual samples from our Sample Business Plan.
Company Information & Fact Sheet
Sources of Capital & Debt Service
Use of Funding & Start-up Costs
Menu and Average Check Calculation
Menu and Average Check Calculation
(Lunch)
Menu and Average Check Calculation
(Dinner)
Gross Sales Calculation
Payroll Calculation
Income Statement (showing industry average expenses)
Income Statement (from client input)
Income Statement (five years)
Ramp up Cash Flow Statement (12
month)
Detail of Expenses Worksheets
Break-Even Analysis & Scenario Worksheet
Amortization and Depreciation Schedule
Balance Sheet
Loan Amortization Schedules (five year)
Chart Comparison of Income Statements
This set of charts, calculations, and
statements generated from Microsoft Excel and designed to give you a detailed
view of the present financial needs and potential performance of a typical
single restaurant operation.
It is sold as an MS Excel workbook (.xls)
and is available for any platform that supports Excel 97 or greater.
It is based on input from you (assumptions
about sales volume, pricing, payroll, etc.), and checked against industry
averages for accuracy. Starting with the individual menu item, we end up with a
full set of financial statements and powerful data reports for analysis and
decision making.
It is then easy to manipulate the key
assumptions to create new scenarios that may be more realistic or produce better
results. With this option you can quickly decide;
- If the start-up budget is adequate.
- About tax planning and corporate structure.
- Whether occupation costs are in line.
- If payroll is too high - and where.
- If debt service is too high.
- What kind of return you can realistically
promise investors.
- And much, much more.
This package is also very flexible. New
scenarios can be created quickly and inexpensively as circumstances change.
Projections for up to five years can be easily calculated.
This package is not a commercial
software application.
It is simply an MS Excel formatted workbook. There is help file that will guide
you through the construction of your workbook but you must know how to use MS
Excel to complete it.
This package is not offered for
resale commercial use.
That is you may only use it for your own projects and not for sale or re-use to
the public.