Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Modeling Skills - Integrated Financial Model
Financial Modeling - Build a forward looking integrated financial model of a company
Lecture 1: Introduction to the course (2:10)
Lecture 2: Illustration for this module (1:13)
Lecture 3: Download the illustration exercise for the course (0:34)
Lecture 4: The six steps to forecasting a financial model (2:57)
Lecture 5: Step 1: Capturing historical IS & BS (8:00)
Lecture 6: Step 2a: Calculating historical IS ratios (12:20)
Lecture 7: Step 2b: Calculating historical BS ratios (6:39)
Lecture 8: Step 3a: Extrapolating future IS ratios (10:17)
Lecture 9: Step 3b: Extrapolating future BS ratios (5:01)
Lecture 10: Quick recap of what we have do so far (1:27)
Lecture 11: Step 4a: Forecasting future income statement (12:01)
Lecture 12: Step 4b: Forecasting future balance sheet - assets side (7:17)
Lecture 13: Step 4c: Forecasting the future balance sheet - liabilities side (12:56)
Lecture 14: What are the components of cash flow statement? (6:18)
Lecture 15: Step 5a: Calculating the cash flow from operations (13:54)
Lecture 16: Step 5b: Calculating the cash flow from investments (7:34)
Lecture 17: Step 5c: Calculating the cash flow from financing (7:53)
Lecture 18: Step 5d: Calculating the cash balance at end of year (3:03)
Lecture 19: Step 6: Integrating the balance sheet with cash flows statement (2:19)
Lecture 20: Recap: What did we learn in this module? (1:49)
Lecture 21: Practice Assignment #1: DIFFICULTY LEVEL - HARD
Lecture 22: Solution to Practice Assignment #1
Lecture 23: End of course
Lecture 24: Please provide us your valuable feedback on the course thus far
Lecture 5: Step 1: Capturing historical IS & BS
Complete and Continue