Knowledge Base: 3-Statement Model Tutorials

A 3-statement model links the income statement, balance sheet, and cash flow statement into one dynamically connected financial model.

3-STATEMENT MODEL TUTORIALS

Hello, and welcome to our first sample case study. This is a three-statement modeling case study and we’re using this company, Illinois Tool Works, which is an industrials or a manufacturing company. We’re given a set of assumptions here and we are given historical statements over the past three years as of the time of this case study for this company. Our task will be to project the three statements over the next five years shown in this Excel file.

Hello, and welcome to our first sample case study. This is a three-statement modeling case study and we’re using this company, Illinois Tool Works, which is an industrials or a manufacturing company. We’re given a set of assumptions here and we are given historical statements over the past three years as of the time of this case study for this company. Our task will be to project the three statements over the next five years shown in this Excel file.

  • LBO (Leveraged Buyout)
  • LBO (Leveraged Buyout)
play icon Created with Sketch.

3-Statement Model Case Study (30 Minutes) (Illinois Tool Works, Industrials, Manufacturing) (34:34)

In this tutorial, you’ll learn how to complete a three-statement modeling case study for an industrials company (Illinois Tool Works) under extreme time pressure – 30 minutes – and you’ll get the key tips, tricks, mistakes to avoid, and suggested completion order.

play icon Created with Sketch.

Balance Sheet Forecast: How to Project the Balance Sheet (19:03)

In this tutorial, you will learn which Income Statement line items should be linked to […]

play icon Created with Sketch.

IB Case Studies: 3-Statement Modeling Test (26:05)

Table of Contents: 3:34 – Step 1: Fill Out All the Assumptions (if possible) 11:34 […]

play icon Created with Sketch.

Revenue Model 101

What You’ll Learn

In this lesson, you’re going to learn how to create a revenue model that projects a company’s sales figures in more detail.

play icon Created with Sketch.

Revenue Model Example – Tops-Down Forecasting

You’ll learn the 3 major methodologies you can use to project revenue in this lesson, and then you’ll use a tops-down approach to estimate Yahoo’s Search Advertising revenue based on Comscore data and market size and share expectations.

play icon Created with Sketch.

Subscription Revenue Model (Netflix) (17:37)

You’ll learn how to project subscription revenue for a Software as a Service (SaaS) or other subscription-based company in this tutorial, which is based on a case study of Netflix.

Special Pricing for Group Licenses

Single User3-9 Users10-14 Users15+ Users

Percentage Discount on Courses and Packages:

Percentage Discount on Courses and Packages:

No DiscountSave 10%Save 25%Ask About a Deal
(Save 35%+)

Price per User for a $197 Course:

Price per User for a $197 Course:

$197$177$148Ask About a Deal
(Save 35%+)

Price per User for a $347 Course:

Price per User for a $347 Course:

$347$313$261Ask About a Deal
(Save 35%+)

Image Heading

3-STATEMENT MODEL TUTORIALS

Hello, and welcome to our first sample case study. This is a three-statement modeling case study and we’re using this company, Illinois Tool Works, which is an industrials or a manufacturing company. We’re given a set of assumptions here and we are given historical statements over the past three years as of the time of this case study for this company. Our task will be to project the three statements over the next five years shown in this Excel file.