Course curriculum

  • 1

    Introduction

    • Course Introduction

    • 3-Statement Modeling Course Slides

    • CFI Financial Modeling Guidelines

  • 2

    Model Theory

    • Company Health Check

    • Overview of Financial Statements

    • Role of Finance Professionals

  • 3

    Compact 3-Statement Model

    • Download Compact Model Template

    • Compact Model Tour & Shortcuts

    • Income Statement

    • Cash Flow Statement

    • Balance Sheet Assets

    • Balance Sheet Liabilities

    • Download Complete Compact Model

    • Balance Sheet Equity

    • Checkin 1

  • 4

    Model Design

    • The Importance of Design

    • Reverse Model Design

    • Designing For The Audience

  • 5

    Model Drivers

    • Defining Model Drivers

    • Download Full Model Template

    • Model Tour

    • Tips for Building

    • Choose Function

    • Index Function

    • Combo Box

    • Checkin 2

  • 6

    Operational Schedules

    • Overview of Schedules

    • Model Tour

    • Model Solution

    • Checkin 3

  • 7

    Capital Structure

    • Overview of Capital Stucture

    • Using Corkscrews

    • Model Tour

    • Debt Schedule

    • Equity Structure

    • Checkin 4

  • 8

    Financial Statements

    • Error Detection & Excel Settings

    • Tour of Statements

    • Income Statement

    • Cash Flow Statement

    • Balance Sheet

    • Revolver Overview

    • Revolver Model Tour

    • Revolver Solution

    • Complete the Statements

    • Cash Available for Revolver

    • Revolver Movements

    • Finding Hardcodes

    • Row Differences

    • Go to Precentent Cell

    • Missing Line Items

    • Incorrect Balance Sheet Wiring

    • Checkin 5

  • 9

    Circularity

    • Circularity

    • Financial Model Circularity

    • Switch Overview

    • Switch Installation

    • Crashing the Model

    • Checkin 6

  • 10

    Dashboard

    • Importance of Dashboards

    • Tour of Dashboard

    • Dashboard Solution

    • Checkin 7

  • 11

    Checks

    • Using Model Checks

    • Installing the Alerts

    • Checkin 8

  • 12

    Printing

    • Print Preview

    • Detailed Settings

    • Quick Access Toolbar

  • 13

    Summary

    • Course Summary

    • Download Complete Full Model

  • 14

    Qualified Assessment

    • Qualified Assessment