Three Statement Financial Excel Model
Originally published: 24/07/2019 14:17
Last version published: 15/07/2021 12:39
Publication number: ELQ-46384-2
View all versions & Certificate

Three Statement Financial Excel Model

Forecast of Income Statement, Balance Sheet, Cash Flow Statement over the next 5 years.

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 on the company’s key highlight.

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
- 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.

This Best Practice includes
1 Excel worksheet + 1 Step-by-Step Methodology

Acquire business license for $10.00

Add to cart

Add to bookmarks


4.4 / 5 (9 votes)

please wait...