Three Statement Financial Excel Model

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

by Alexandr Marchenko
CFO/AccountantFollow

8 reviews220 views|2 comments|Bookmark Add to cart - $10.00

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

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