Comprehensive Restaurant Financial Excel Model Template (Pro Forma Statements for Business Plan)

Description
This MS-Excel workbook is designed to provide new and experienced restaurateurs with a comprehensive financial model to develop their restaurant's business plan. The model can be used for:

1. To determine how much funding you need to start your restaurant.
2. To raise funding from banks, investors or public/private grants.
2. Internal business and financial planning.

The workbook contains editable real-world revenue and expense figures and comprises the following templates:

1. Startup costs (including equipment, inventory, leasehold improvements, etc.)
2. Use of funds
3. Sources of funds
4. Depreciation calculation for fixed assets
5. Income statements (3 years), first year monthly annual for years two and three.
6. Cash flow statement (3 years), with accounts receivable and payables for key line items.
7. Balance sheets (3 years)
8. Breakeven analysis
9. Key business ratios
10. Sales and Profits Summary (Chart)
11. Daily sales projections and labour costing map - Summer (including patio and brunch modules).
12. Daily sales projections and labour costing map - Non-summer (with patio and brunch modules removed). The daily sales projections templates provide the user with a very easy to use format of estimating revenue projections and labour costs associated with the operation.

Each worksheet has clear instructions for use. The model can be customized to suit users needs.