3 Statement Integrated Financial Modeling
What Will I Learn?
- Reading 3 important financial statements
- Establishing the linkages between financial statements
- Calculating key financial ratios
- Forecasting techniques for business metrics
- Projecting financial statements
- Linkage between Income Statement and Balance Sheet
- Linkage between Balance Sheet and Cash Flows Statement
- Linkage between Income Statement and Cash Flows Statement
Course Content
Financial Modeling – Build a forward looking integrated financial model of a company
-
01:07
-
02:11
-
01:14
-
Download the illustration exercise for the course
-
The six steps to forecasting a financial model
02:57 -
Step 1: Capturing historical IS & BS
08:01 -
Step 2a: Calculating historical IS ratios
12:21 -
Step 2b: Calculating historical BS ratios
06:40 -
Step 3a: Extrapolating future IS ratios
10:17 -
Step 3b: Extrapolating future BS ratios
05:01 -
Quick recap of what we have do so far
01:28 -
Step 4a: Forecasting future income statement
12:01 -
Step 4b: Forecasting future balance sheet – assets side
07:17 -
Step 4c: Forecasting the future balance sheet – liabilities side
12:57 -
What are the components of cash flow statement?
06:18 -
Step 5a: Calculating the cash flow from operations
13:54 -
Step 5b: Calculating the cash flow from investments
07:34 -
Step 5c: Calculating the cash flow from financing
07:53 -
Step 5d: Calculating the cash balance at end of year
03:04 -
Step 6: Integrating the balance sheet with cash flows statement
02:20 -
Recap: What did we learn in this module?
01:49 -
Practice Assignment #1: DIFFICULTY LEVEL – HARD
00:00 -
Solution to Practice Assignment #1
00:00
About the instructor
33 Courses
207 students
I like it
Great way of giving an introduction to projection and financial modelling. Enjoyed it
Good
I recently completed the "3 Statement Integrated Financial Modeling" course, and it has been an outstanding learning experience that has significantly enhanced my financial modeling skills. This course is a must for anyone looking to excel in financial analysis and modeling.
I recently completed the "3 Statement Integrated Financial Modeling" course, and it was a highly informative and practical learning experience. The course provided a comprehensive understanding of financial modeling, particularly the integration of income statements, balance sheets, and cash flow statements. The instructors were knowledgeable and conveyed complex concepts effectively
"3 Statement Integrated Financial Modeling" course. This comprehensive course provides an exceptional learning experience for finance professionals, analysts, and anyone looking to master the art of building integrated financial models.
Step by Step to Clear Explanation of the Course
I am thrilled to share my enthusiastic review of the "3 Statement Integrated Financial Modeling" course. This comprehensive course provides an exceptional learning experience for finance professionals, analysts, and anyone looking to master the art of building integrated financial models. The course content, expert instruction, and practical application make it an invaluable resource for those aiming to create accurate and robust financial models.
Good integrated financial model explained step by step