Instructor for this course
more

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

Learning Objectives

  • 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

 

Last updated/reviewed: June 28, 2017

5 Reviews (19 ratings)Reviews

4
Member's Profile
The course is well structured for non-financial managers to understand. It is particularly important for people that need to fully understand how the business is performing.
3
Anonymous Author
Simple model. Some of the information regarding cash flow is incorrect. For instance, capital expenditures should not be offset against disposals in a cash flow statement.
4
Anonymous Author
Effective presentation with real advice on how to enhance the quality of integrated reporting. Most finance professionals and beginners would benefit greatly.
5
Member's Profile
Great pointers, such as linking cash to the cash flow statement and not plugging the balance sheet.
5
Member's Profile
A lot covered in 1 hour. Looking forward to more in the series.

Prerequisites

Course Complexity: Intermediate

No Advanced Preparation or Prerequisites are needed for this course.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  3:46Introduction to Integrated Financial Models In Excel - Core Course
Integrated Financial Models in Excel
  8:43The Income Statement
  11:21The Balance Sheet
  9:49The Cash Flow Statement
  7:19Closing the Loop and Error Checking
CONCLUSION
  6:19Constructing a Simple Scenario
Continuous Play
  47:17Integrated Financial Models in Excel- Core Course
SUPPORTING MATERIALS
  PDFSlides: Integrated Financial Models in Excel – Core Course
  PDFIntegrated Financial Models in Excel – Core Course Glossary/Index
  XLSXWorkbook: Integrated Financial Model - Core (Start)
REVIEW and TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM