Building Excel-Based Integrated Financial Models

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

4.00 (19 reviews)
Udemy
platform
English
language
Financial Modeling & Ana
category
Building Excel-Based Integrated Financial Models
66
students
1 hour
content
Sep 2017
last update
$39.99
regular price

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.

Explore how to link the financial statements together to create a dynamic model.

Discover how to build in appropriate error checks.

Explore how to construct a simple scenario within the model.

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.

Content

Introduction

Introduction to Integrated Financial Models In Excel - Core Course
The Income Statement
The Balance Sheet
The Cash Flow Statement
Closing the Loop and Error Checking
Constructing a Simple Scenario

Supporting Materials

Slides: Integrated Financial Models in Excel – Core Course
Integrated Financial Models in Excel – Core Course Glossary/Index
Workbook: Integrated Financial Model - Core (Start)

Review and Test

Review Questions
FINAL EXAM

Reviews

Gary
May 6, 2020
Not that explanatory regarding the derivation of the figures (input) needed to create the fin. statements. Very generic based models, containing very little information.
Steven
October 26, 2019
I'm a programmer and analyst. It's been a while since I was in an accounting course. This course is very good about declaring its scope and really delivering what it says it will. It's clear. As a programmer, I can very much appreciate the instructor sharing the system he uses for identifying at a glance what values are calculated, input, brought in via reference from within the sheet, brought in by reference to another spreadsheet. Additionally, the spreadsheet provided helps you to just focus on what is being presented and working alongside the instructor as opposed to being burdened with trying to go through all the simple task work of putting together a framework before being able to work the lessons. Outstanding. Very much appreciate the extent to which this course was thought out and executed. Thank you

Charts

Price

Building Excel-Based Integrated Financial Models - Price chart

Rating

Building Excel-Based Integrated Financial Models - Ratings chart

Enrollment distribution

Building Excel-Based Integrated Financial Models - Distribution chart
1334640
udemy ID
8/29/2017
course created date
11/22/2019
course indexed date
Bot
course submited by