Illustration for this module - skillfine

Course Content

Financial Modeling – Build a forward looking integrated financial model of a company

0/23

Meet Your Instructor

Introduction to the course

Illustration for this module

Download the illustration exercise for the course

The six steps to forecasting a financial model

Step 1: Capturing historical IS & BS

Step 2a: Calculating historical IS ratios

Step 2b: Calculating historical BS ratios

Step 3a: Extrapolating future IS ratios

Step 3b: Extrapolating future BS ratios

Quick recap of what we have do so far

Step 4a: Forecasting future income statement

Step 4b: Forecasting future balance sheet – assets side

Step 4c: Forecasting the future balance sheet – liabilities side

What are the components of cash flow statement?

Step 5a: Calculating the cash flow from operations

Step 5b: Calculating the cash flow from investments

Step 5c: Calculating the cash flow from financing

Step 5d: Calculating the cash balance at end of year

Step 6: Integrating the balance sheet with cash flows statement

Recap: What did we learn in this module?

Practice Assignment #1: DIFFICULTY LEVEL – HARD

Solution to Practice Assignment #1

Go to Course Home

Illustration for this module

To download this file, click here

No Attachment Found

No Attachment Found

← Previous Next →

0% Complete