Explore

Building Excel-Based Integrated Financial Models

1 hour on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

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

Description

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.

Requirements

Requirements
No advanced preparation or prerequisites are needed for this course but experience with Excel is helpful.

Recommended for you

The Advanced Real Estate Development Modeling Master Class

A Complete Guide To Building Real Estate Development Pro Forma Models From Scratch For Commercial Real Estate Investing At the end of this course, you will be able to:...

Save Course

The Advanced Real Estate Equity Waterfall Modeling Class

A Step-by-Step Guide To Modeling Catch-Ups, Clawbacks, Cash-on-Cash Waterfalls, and More For Real Estate Investors And with so many different structures out there, it can get overwhelming really quickly....

Save Course

Introduction to Financial Modeling

Learn to build a simple integrated financial statement model. It is designed for those new to financial models. The first video provides a quick overview of the process....

Save Course