*** Proof of Product ***
Exploring the Essential Features of “Jeff Schmidt – Introduction to 3-Statement Modeling – CFI Education”
Introduction to 3-Statement Modeling
The three-statement financial model is a foundational model upon which many other types of models and analyses are built. Mastering this model is an absolutely critical skill for many finance and accounting roles.
- How the three core financial statements link together
- Financial model-building best practices
- How to build a financial projection model using a company’s historical data and various assumptions about the future performance of the company
Overview
Introduction to 3-Statement Modeling Course Overview
The three-statement financial model forms the foundation on which almost all other types of models and analyses are built, and creating one is a crucial skill for many finance professionals. In this course, we will build a three-statement model from scratch and then review and audit it to make sure it’s working properly.
3-Statement Modeling Learning Objectives
Upon completing this course, you will be able to:
- How the three core financial statements link together
- Financial model-building best practices
- How to build a financial projection model using a company’s historical data and various assumptions about the future performance of the company
- Finding the right balance between a highly complex model and an overly simplistic one
- Thinking about crafting assumptions and various forecasting methods
- How to review your model and audit it for potential errors
Who Should Take This Course?
This course is designed for beginner-level investment or commercial bankers, beginner-level equity or credit research analysts, corporate development professionals, and financial planning and analysis (FP&A) professionals.
Courses we recommend you take in advance
These prerequisite courses are optional, but we recommend you complete the stated prep course(s) or possess the equivalent knowledge prior to enrolling in this course:
- Accounting Fundamentals
- Excel Fundamentals
What you’ll learn
3-Statement Modeling
Introduction
Downloadable Files
Model Overview
Types of Models
3-Statement is the Foundation
Interactive Exercise 1
Modeling Best Practices
Modeling Structure
Modeling Best Practices
Number Sign Convention
Complex vs Simple Models
Model Inputs
Model Processing
Model Outputs
Structure and Layout
Interactive Exercise 2
Model Framework
Financial Forecasting Framework
Interactive Exercise 3
Model Setup and Assumptions
The Case Study
Downloadable Files
Historical Data Walkthrough
Different Forecasting Methods
Model Assumptions and Drivers
Income Statement Historical Metrics
Historical Metrics vs Guidance Review
Interactive Exercise 4
Forecasting Revenues Down to EBITDA
Forecasting Methods
Forecasting Revenue
Forecasting Gross Margin and Expenses
Forecasting to EBITDA
Interactive Exercise 5
Forecasting Working Capital and PP&E
Working Capital Overview
Accounts Receivable
Accounts Payable
Inventory
Calculating Working Capital Metrics
Working Capital Scheduling
Forecasting Capital Assets
PP&E Schedule
Interactive Exercise 6
Forecasting Capital Structure
Forecasting Debt and Equity
Introduction to Capital Structure
Debt Corkscrew and Interest Expense
Common Stock Corkscrew with Retained Earnings
Interactive Exercise 7
Complete the Cash Flow Statement
Intro to the Cash Flow Statement
Cash from Operating Activities
Cash from Investing and Financing Activities
Cash Flow from Statement Walkthrough
Interactive Exercise 8
Review and Audit
Auditing and Reviewing Techniques
Auditing and Reviewing the Model Part 1
Auditing and Reviewing the Model Part 2
Linking Chart Data
Interactive Exercise 9
Course Summary
Downloadable Files
Final Thoughts
Modular Approach
Next Steps
Qualified Assessment
Qualified Assessment
Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/
