Building Excel-Based Integrated Financial Models

Building Excel-Based Integrated Financial Models

This course is designed to take users through the process of building the fundamental financial statements in Excel; income statement, balance sheet and cashflow statement.

The statements are built from basics using key assumptions and/or linking related items together e.g. accounts receivable and revenue. Key assumptions and model inputs are made explicit to allow for subsequent scenario building. Once completed, the statements are tied together through the cash movement with error checks being added to reduce mistakes.  

The resulting model, while basic, provides a framework which can be expanded to add more detail, greater complexity, alternative financial structures or any other business specific features that need to be incorporated. Later courses look at some examples to build onto this core course.

An accurate and reliable financial model provides an invaluable tool for planning, budgeting, scenario analysis and predicting future financial performance and is an invaluable skill for many users in the financial function as the logic and comprehension can be applied to many other modeling situations..

If you would like Continuing Education Credit (e.g. CPE, CE, CPD, etc.) for this course, it is available if you take this course on the Illumeo dot com platform under course title: Integrated Financial Models in Excel – Core Course. Illumeo is certified to provide CPE in over two dozen different professional certifications covering finance, accounting, treasury, internal audit, HR, and more. However, in order to receive CPE credit the courses must be taken on an ‘approved-by-the-governing-body’ CPE platform, and for over two dozen corporate professional certifications, that is the Illumeo platform. Go to Illumeo dot com to learn more.

This course takes users through the process of building the fundamental financial statements in Excel.

Url: View Details

What you will learn

• Explore how to construct the three financial statements from scratch.
• Explore how to link related items in the financial statements.
• Identify and recognize how to make explicit key inputs and assumptions.

Rating: 4.05

Level: Intermediate Level

Duration: 1 hour

Instructor: Illumeo Learning