Back to All Courses

Financial Statement Modeling Course

4 Hours
71 Lessons

Go from novice to financial statement modeling wizard in this comprehensive and engaging online course with 60 mini-lessons. Learning how to build a 3 statement model is a foundational skill in investment banking, private equity, corporate finance, hedge funds, equity research, corporate development, management consulting and more. Once you learn how to link up the 3 statements in Excel, balance your balance sheet and complete this course, you will be ready for some of our more advanced financial modeling courses.

Course Progress

71 lessons left to complete 0%
Banana Reward

Purchase the course to get rewarded! 0%

Reward #1

View your certificate

Module 1: Getting Started

1.1 - Introduction & Course Overview

(04:12)
1.2 - The Big Picture

(05:02)
1.3 - Setup for Mac Users

(05:10)

Module 2: Fundamental Concepts

2.1 - Introduction

(01:08)
2.2 - Excel Proficiency

(01:09)
2.3 - Shortcuts

(02:32)
2.4 - Hotkeys

(02:25)
2.5 - Excel Settings - Hotkey Practice

(02:31)
2.6 - If your Excel skills need work...

(00:41)
2.7 - Formatting Best Practices

(04:16)
2.8 - Simple Is Better - Inputs

(00:52)
2.9 - Hard-Coding Formulas

(01:00)
2.10 - Simple Is Better - Leaving Comments

(01:02)
2.11 - Simple Is Better - Grouping

(02:09)
2.12 - Using Common Sense

(01:51)
2.13 - Designing For Convenience

(01:41)
2.14 - Designing to Prevent Errors

(01:56)
2.15 - Fundamental Concepts Exercise Download
2.16 - Fundamental Concepts Exercise: Answer

(07:09)
2.17 - Module 2 Quiz

Module 3: The Income Statement

3.1 - Income Statement Intro

(03:06)
3.2 - Date Headers

(06:03)
3.3 - Historical Income Statement

(02:52)
3.4 - Income Statement Drivers

(03:41)
3.5 - Income Statement Projections

(07:28)
3.6 - Module 3 Quiz

Module 4: Working Capital

4.1 - The Balance Sheet

(02:37)
4.2 - Historical Balance Sheet

(03:48)
4.3 - Accounts Receivable

(07:11)
4.4 - Inventories

(02:49)
4.5 - Prepaid Expenses

(01:12)
4.6 - Payables and Accrued Liabilities

(03:02)
4.7 - Wrapping Up

(03:51)
4.8 - Module 4 Quiz

Module 5: PP&E and Intangibles

Module 5: PP&E And Intangibles

5.5 - Module 5 Quiz

Module 6: The Cash Flow Statement

6.1 - Introduction

(01:48)
6.2 - Cash Flow From Operations

(02:54)
6.3 - Cash Flow From Investing

(01:02)
6.4 - The Equity Schedule

(01:14)
6.5 - Calculating Dividends

(01:48)
6.6 - Calculating Stockholder's Equity

(01:47)
6.7 - Linking to the CFS

(02:07)
6.8 - Module 6 Quiz

Module 7: Debt & Interest Schedule

7.1 - Introduction

(00:49)
7.2 - Cash Available for Debt Paydown

(05:28)
7.3 - Long Term Debt

(03:16)
7.4 - Revolver

(07:15)
7.5 - Interest

(04:03)
7.6 - Circularity

(07:53)
7.7 - Module 7 Quiz

Module 8: Finishing Your Model

8.1 - Historical Basic Shares

(02:29)
8.2 - Historical Dilutive Securities

(02:12)
8.3 - EPS Calculation

(01:21)
8.4 - Projected Shares Outstanding

(01:06)
8.5 - Share Repurchase

(02:22)
8.6 - New Circular Reference

(03:22)
8.7 - Option Proceeds

(03:32)
8.8 - Wrapping Up

(01:10)
8.9 - Module 8 Quiz

Module 9: Bonus

Module 10: Final Assessment

10.1 - Final Assessment

6,177 Investment Banking Interviews

Goldman Sachs

1,017 interviews at Goldman Sachs

Morgan Stanley

805 interviews at Morgan Stanley

JPMorgan Chase

734 interviews at JPMorgan Chase

Citigroup

701 interviews at Citigroup

Bank of America Merrill Lynch

685 interviews at Bank of America Merrill Lynch

Credit Suisse

503 interviews at Credit Suisse

Barclays

484 interviews at Barclays

Wells Fargo and Company

442 interviews at Wells Fargo and Company

Houlihan Lokey

421 interviews at Houlihan Lokey

Deutsche Bank

385 interviews at Deutsche Bank

See more interviews