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
certified

Three Statement Financial Excel Model

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

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

Acquire business license for $10.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Deepak Sharma923(last updated: 25/01/2021 09:19)
  • Joseph Casabona(last updated: 27/07/2020 17:15)
    three-statement-financial-excel-model/details
    1. Probably better suited as a 10 yr Model.2. Somewhat "elementary" in detail.3. Too many "tabs" which do not add much.
  • Gerald Minster(last updated: 20/04/2020 17:21)
    Great Template
    Great Template
  • Andreas Pungkar(last updated: 23/03/2020 22:42)
  • rams yavz(last updated: 27/10/2019 12:40)
  • E. Jon Garcia(last updated: 24/10/2019 23:55)
  • Brando Hayden(last updated: 07/08/2019 14:58)
    Intuitive model with good graphics.
    I found the model easy to use. The graphics were also on point.
  • Kevin Klarnet, CFA(last updated: 25/07/2019 01:30)
  • Henry Sheykin(last updated: 24/07/2019 14:36)
    Great work!
    Would love to see more high-quality tools like this at eloquens! Thank you!

keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Three Statement Financial Excel Model

The user community and author are here to help. Go ahead!

  • Brando Hayden
    Hi Alexandr...great sheet. How do I input the purchase of company (minority equity position) in the assumptions? Thank you...BH
    arrow_drop_uparrow_drop_downReply reply
    • Alexandr Marchenko
      Hi Brando. This model is not provided the minority equity recognizing.
      But because it is modular, it will be easy to add the appropriate categories to the financial statements
      -1arrow_drop_uparrow_drop_downReply reply


    4.4 / 5 (9 votes)

    please wait...