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)

Debt schedule:

Fixed Asset Schedule which includes 5 assets categories.

Ordinary Equity Schedule and dividends planing

Financial Analysis:

A summary and financial charts with a quick glance at the company’s key highlights.

Summary contains:
- 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
- OPEX
- EBITDA margin
- EBIT margin
- Net Income margin

Workbook Structure:

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.

Знімок екрана 2021-08-12 о 16.15.06.png
Знімок екрана 2021-08-12 о 16.15.37.png
Знімок екрана 2021-08-12 о 16.15.06.png