Spreadsheet  Report Index:

• Set up Information
• Cover Page
• Company Information & Fact Sheet
• Summary
• Sources of Capital & Debt Service
• Use of Funding & Start-up Costs
• Menu and Average Check Calculation (Breakfast)
• 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)
• Monthly Cash Flow Statement
• Ramp up Cash Flow Statement
• Detail of Expenses Worksheets
• Break-Even Analysis & Scenario Worksheet
• Amortization and Depreciation Schedule
• Balance Sheet
• Loan Amortization Schedule(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

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 Excel97 formatted workbook. It is offered as is, with a very limited amount of support. You must have extensive experience using Excel to make good use of these.

This package is not offered for commercial use.
That is you may only use it for your own projects and not for sale or re-use to the public.

If all of the above is OK for you, I will be happy (for $250) to send you a working copy of the Financial Modeling Spreadsheets.

ORDER NOW

Home | Spreadsheets | Modeling Packages
Business Plan | Newsletter | Ordering | Pricing
Internet Services | About Us | Links | Contact  

Phone: 877 343 2469
Email: info1@virtualrestaurant.com

Web Design by Rasa,  Web Marketing by Aaxis