Three Statement Financial Model
The highlights of this financial model are:
Forecast of Income Statement, Balance Sheet, Cash Flow Statement and Financial Ratios over the next 5 years
Detailed breakdowns to estimate sales, COGS, gross profit, and operating costs
Assumptions block for revenue contains four categories of revenue, GOGS assumptions have four categories too. Selling, General & Administrative Expenses consist of Sales & Marketing, Wages and Salaries, General & Administrative Expenses with own subcategories.
Working Capital Forecast (Accounts Receivable, Inventory and Accounts Payable)
Fixed Asset Schedule which includes 5 assets categories.
Ordinary Equity Schedule and dividends planing
A summary and financial charts with a quick glance at the company’s key highlights.
- Income Statement
- Balance Sheet
- Cash Flow Statement
- Five-Year Performance Summary infographic
- Revenue Chart
- Cumulative Revenue chart which allows setting the performance year via a dropdown.
- Operating Expenditure chart
- Cash Flow Chart
- Cash at Bank Chart
Financial Charts contain:
- Sales & GP margin
- Sales growth & Opex growth
- EBITDA margin
- EBIT margin
- Net Income margin
Every workbook that contains multiple sheets should contain a separate overview sheet as the first sheet in the workbook.
Every workbook that contains multiple sheets containing similar or related types of information should be separated into sections.
A section cover starts the of each section in a workbook.