Financial modeling: Build a forward looking financial model
4.5 (46 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,332 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Financial modeling: Build a forward looking financial model to your Wishlist.

Add to Wishlist

Financial modeling: Build a forward looking financial model

Learn to create an integrated forward looking Income Statement, Balance Sheet and CF statement of a company
4.5 (46 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,332 students enrolled
Created by Skillfin Learning
Last updated 12/2016
English
Current price: $12 Original price: $20 Discount: 40% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Build an integrated forward looking financial model of a company
View Curriculum
Requirements
  • Students will need to know some basics of financial statements
Description

What this course is about?

This course is a practical one where we teach you how to make a financial model for projecting the financial position of a company in the future. In particular we look at estimating the income statement, balance sheet and cash flows statement and establish the linkage between them

What kind of materials that you will find?

There is a video that consists of a recorded exercise that we go through to understand the course. In the video, we are working through an excel spreadsheet which will be also be available to you for your practice.

How long will the course take to complete?

The course will take around 1 hour to finish. But we strongly recommend that you practice the exercises on your own to understand the model and be able to do it on your own.


How is the course structured?

The course is structured in a series of lectures. In each lecture, we look at one critical aspect of financial modeling before we move to the next one. Hence, it is recommended that you watch the videos in a sequence and not jump from one to another.

Why take this course?

This course is meant for both entrepreneurs who are looking to make their financial statements to secure funding from bank or investors. The course is also useful for current and prospective analysts with consulting, private equity, investment banking, equity research, corporate planning profiles.


Who is the target audience?
  • Business and finance students
  • Financial Analysts
  • Job seekers
Compare to Other Financial Modeling Courses
Curriculum For This Course
23 Lectures
02:11:51
+
How to make an integrated financial model?
23 Lectures 02:11:51



Download the illustration exercise for the course
00:02


Step 1: Capturing the historical IS & BS
08:00

Step 2a: Calculating historical IS ratios
12:20

Step 2b: Calculating historical BS ratios
06:39

Step 3a: Extrapolating future IS ratios
10:17

Step 3b: Extrapolating future BS ratios
05:01

Quick recap so far
01:27

Step 4a: Forecasting the future IS statement
12:01

Step 4b: Forecasting the future BS - assets side
07:17

Step 4c: Forecasting the future BS - liabilities side
12:56

What are the components of a CF statement
06:18

Step 5a: Forecast CF from operations
13:54

Step 5b: Forecasting the CF from investments
07:34

Step 5c: Forecasting CF from financing
07:53

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

Step 6: Integrating CF statement with BS
02:19

Recap: What did we learn in the course?
01:49

Practice Assignment : DIFFICULTY LEVEL - HARD
00:37

Contact us

Queries
00:12
About the Instructor
Skillfin Learning
4.5 Average rating
355 Reviews
9,421 Students
11 Courses
Building skills for business and finance careers

SKILLFIN LEARNING is a leading online training provider of business and finance courses. We have a number of online courses in the area of financial modelling and business analytics enrolled into by thousands of students globally. 

Our courses provide on the job like training to help your professional advancement. Our students have successfully cracked their job interviews based on the content learning in these courses. 

The courses are very practical and are full of real life illustrations. The courses are curated by professionals who are experts in the field of finance and analytics having worked with companies like McKinsey and BlackRock globally.