PURPOSE OF MODEL
Highly versatile and user-friendly Excel model for the preparation of a rolling 3 statement (Income Statement, Balance Sheet and Cash flow Statement) financial projection for a startup or existing restaurant business offering both deliveries / takeaways and dine-in options.
The model follows best practice financial modelling principles and includes instructions, line item explanations, checks and input validations.
KEY OUTPUTS
The key outputs include:
- Projected full financial statements (Income Statement, Balance Sheet and Cash flow Statement) presented on a quarterly basis across up to 5 years and summarised on an annual basis.
- Dashboard with:
- Summarised projected Income Statement and Balance Sheet;
- Compounded Annual Growth rate (CAGR) for each summarised income statement and Balance Sheet line item;
- List of key ratios including average revenue growth, average profit margins, average return on assets and equity and average debt to equity ratio;
- Bar charts summarising income statement and Balance Sheet projections;
- Chart presenting total delivery / takeaway orders across projection months;
- Chart presenting total filled and unfilled capacity across projection months;
- Gross profit by menu category.
KEY INPUTS
Inputs are split into Income Statement and Balance Sheet Inputs. Most inputs include user-friendly line item explanations and input validations to help users understand what the input is for and populate correctly.
Setup Inputs:
- Name of business;
- Currency;
- First projection year and quarter;
- Naming for menu categories, other income, variable costs, staff cost, fixed costs, fixed assets and borrowings;
- Sales tax applicability for revenue and cost categories;
Actuals Inputs:
- Opening balance sheet (for existing businesses);
- Income Statement actuals (for trend analysis);
Projection Inputs:
- Takeaway/Delivery Revenue inputs including:
- Number of orders per day split between weekdays and weekends
- Average menu selection per order
- Delivery method (Customer pick-up vs Delivery)
- DineIn Revenue inputs including
- Days open per week
- Average turnover per seat
- Number of seats
- Filled capacity
- Average menu selection per cover
- Average price per menu category
- Other income inputs including
- Volume
- Revenue per unit
- Cost of goods sold inputs including:
- percentage of revenue;
- Safety stock percentage;
- Average credit terms;
- Other cost inputs including
- Other variable costs
- Marketing costs
- Staff costs
- Other costs
- Sales and corporate tax inputs including rate and payment periods;
- Dividend inputs including amount or percentage of retained earnings and frequency;
- Fixed Assets including addition amounts and useful life;
- Borrowings including addition/redemption amounts and interest rate;
- Share Capital additions.
MODEL STRUCTURE
The model comprises of 9 tabs split into input ('i_'), calculation ('c_'), output ('o_’) and system tabs. The tabs to be populated by the user are the input tabs ('i_Setup', ‘i_Actuals’ and 'i_Assumptions'). The calculation tab uses the user-defined inputs to calculate and produce the projection outputs which are presented in 'o_Fin Stats', ‘o_Charts’ and ‘o_DCF’.
System tabs include:
- A 'Front Sheet' containing a disclaimer, instructions and contents;
- A Checks dashboard containing a summary of checks by tab.
KEY FEATURES
Other key features of this model include the following:
- The model follows best practice financial modelling guidelines and includes instructions, line item explanations, checks and input validations;
- The model is not password protected and can be modified as required following download;
- The model contains a dynamic timeline that allows for a mix of actual and forecast periods across a 5-year period allowing projections to be rolled forward from month to month;
- Timeline is split on a monthly basis and summarised on an annual basis;
- Apart from restaurant revenue, the model allows the user to model 5 additional income categories and their related costs;
- Costs are split into: variable and fixed for better driver-based forecasting;
- The model allows for the following number of underlying categories for each line item (these can be easily expanded if required):
- Menu categories – 10 types;
- Other Income – 5 categories
- Cost of goods sold – 15 categories (10 menu categories + 5 other income categories)
- Other variable costs – 6 categories
- Staff costs – 8 categories;
- Marketing costs – 5 categories;
- Other expenses – 15 categories;
- Fixed Assets – 5 categories;
- Borrowings – 3 facilities;
- Apart from projecting revenue and costs the model includes the possibility to model inventory, deferred income, payables, fixed assets, borrowings, dividends, corporate tax and sales tax;
- The model included an integrated discounted cash flow valuation using the projected cash flow outputs;
- Business Name, currency, starting projection period are fully customisable;
- Revenue, Cost, Fixed Asset and Borrowing category descriptions are fully customisable;
- The model includes instructions, line item explanations, checks and input validations to help ensure input fields are populated accurately;
- The model includes a checks dashboard which summarises all the checks included in the various tabs making it easier to identify any errors.
MODIFICATIONS & SUPPORT
If you require any be-spoke modifications or support, we are more than happy to assist. Please send us a message below or contact us on hello@useprojectify.com
Delivery/Takeaway Restaurant Business Financial Projection - Excel Models
Link to Model Video
Download Details
1 Populated Excel Model and 1 Unpopulated Excel Model