The Financial Analyst Skills Training (FAST) course
4.4 (51 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.
677 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Financial Analyst Skills Training (FAST) course to your Wishlist.

Add to Wishlist

The Financial Analyst Skills Training (FAST) course

Learn excel functions, accounting, financial statements analysis, forecasting financial statements and valuations
4.4 (51 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.
677 students enrolled
Created by Skillfin Learning
Last updated 7/2017
English
Curiosity Sale
Current price: $10 Original price: $100 Discount: 90% off
30-Day Money-Back Guarantee
Includes:
  • 10 hours on-demand video
  • 22 Articles
  • 15 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Students will be able to build a complete financial model on their own
  • Students will be able to compare financial performance of companies
  • Students will be able to do data analysis in Excel
View Curriculum
Requirements
  • You should have basic familiarity with Excel
  • You should have basic familiarity of financial statements
Description

                **************************    AUGUST 1, 2017 UPDATE **************************

We would like to let you know that we have updated all the Practice Assignments in The Financial Analyst Skills Training course 2017 . The newly updated assignments will further help to strengthen your understanding of the different modules of the course through practical real life case examples. 

For your ease, we have also earmarked the updated Practice Assignments into varying DIFFICULTY levels i.e. EASY, MEDIUM, HARD. As usual, we will be reviewing individual assignments and provide direct feedback.

We cant wait to see your professional development and progress.

               ****************************************************************************************

Master the financial modeling skills with this comprehensive Financial Analyst online course.

  • Excel functions to analyze and manipulate data
  • Preparing financial statements
  • Analyzing the performance of companies
  • Forecasting a financial model
  • DCF and multiples based valuation

Financial analysts play a very important role in a business organization.

Finance is one of the key departments of an organization covering a range of activities from basic bookkeeping to providing relevant, reliable, timely and accurate financial information in the form of various financial reports to assist management in the process of strategic decision making. The financial information in turn forms a basis for financial analysis. In this way, financial analyst plays a vital role in a business organization.

How is our course different from others in this topic?

  • The courses are taught by global experts in the field of corporate finance who have worked for large consulting and financial services companies (McKinsey and BlackRock)
  • Comprehensive course that covers ALL what you need to know in excel, financial analysis and valuation related topics. ALL in 1 course
  • There are real life illustration in all modules that imparts on the job like training (updated Aug 1 2017)
  • There are practice exercises at end of each module to test your learning
  • Our faculty is responsive 24x7 in resolving all your queries related to the course

So dont wait further. Enrol now. Look to see you inside the course.

Who is the target audience?
  • 1) Financial analysts i.e. investment banking analyst, research analysts, business analysts, accountants, etc.
  • 2) Job aspirants in financial analyst roles and
  • 3) Graduate and post graduate students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
138 Lectures
09:55:49
+
Introduction to the FAST course
1 Lecture 05:34
+
Module 1: Basic excel functions to analyze large data
17 Lectures 01:59:36

Download the excel template for this module
00:34

Download the excel spreadsheet illustration for this module
00:01

Lets look at the data for the illustration exercises
02:55

Extraction of data: understanding the SUMIF function
08:14

Extraction of data: calculating growth rates
03:58

Extraction of data: understanding the VLOOKUP function
11:40

Extraction of data: understanding the HLOOKUP function
09:31

Extraction of data: understanding the INDEX and MATCH function
13:56

Extraction of data: understanding the IF, COUNTIF and COUNTIFS function
09:09

Presentation of data: understanding the LINE chart
12:33

Presentation of data: understanding the PIE chart
11:45

Presentation of data: understanding the COLUMN chart
13:03

Presentation of data: understanding the STACKED COLUMN chart
10:56

Presentation of data: understanding the CONDITIONAL FORMATTING function
06:58

This brings us to the end of module 1 in which we looked at key excel functions to analyze large data.

Lecture 17: End of Module 1
00:02

Practice Assignment 1: DIFFICULTY LEVEL - MEDIUM
00:37
+
Module 2: Basics of financial accounting statements
17 Lectures 31:18

What is accounting and why we need it?
04:18

Key financial statements: Income statement
03:30

Key financial statements: Balance sheet
03:14

Illustration for this module
00:49

Illustration of transaction 1
00:40

Illustration of transaction 2
01:03

Illustration of transaction 3
01:35

Illustration of transaction 4
02:21

Illustration of transaction 5
01:55

Illustration of transaction 6
01:59

Illustration of transaction 7
02:08

Illustration of transaction 8
01:52

Illustration of transaction 9
01:34

Illustration of transaction 10
01:54

This brings us at the end of the module 2 in which we learnt how to prepare the financial accounting statements of a company.

End of Module 2
00:06

Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM
00:37
+
Module 3: Financial performance analysis of companies
19 Lectures 01:10:41

Introduction to financial performance analysis
02:24

Basic financial accounting statements
06:46

Download the excel spreadsheet illustration for this module
00:03

Illustration for this module
05:06

How to measure the performance of companies?
03:20

What are the key metrics for measuring performance of companies?
09:26

Calculation of operating metrics for Company 1
05:39

Calculation of financing metrics for Company 1
03:43

Calculation of operating and financing metrics for Company 2
05:05

Calculation of operating and financing metrics for Company 3 and Company 4
00:43

Calculation of averages for all metrics across companies
06:50

Visual representation of metrics across companies
01:44

Ranking of operating metrics
06:15

Ranking of financing metrics
05:34

Choosing the best company
03:12

Quick recap: What did we learn?
02:14

End of Module 3
00:05

Practice Assignment #3: DIFFICULTY LEVEL - EASY
00:37
+
Module 4: Forecasting an integrated financial model
23 Lectures 02:11:45

What are the key financial statements we need to forecast?
05:53

Illustration for this module
01:13

Download the illustration exercise for the course
00:02

The six steps to forecasting a financial model
02:56

Step 1: Capturing 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 of what we have do so far
01:27

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:56

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:03

Step 6: Integrating the balance sheet with cash flows statement
02:19

Recap: What did we learn in this module?
01:49

End of Module 4
00:06

Practice Assignment #4: DIFFICULTY LEVEL - HARD
00:37
+
Module 5: Conceptual understanding of Discounted Cash Flow valuation technique
10 Lectures 20:34

What is valuation?
02:09

What does the Discounted Cash Flow technique estimate?
02:58

Calculation of Free Cash Flows
04:56

Free Cash flows are calculated for the future
01:44

Calculation of the discount rate or WACC?
02:31

Discounting future cash flows to calculate present value
02:19

Calculation of Terminal Value
01:12

Calculation of enterprise value and equity value
00:47

End of Module 5
00:09
+
Module 6: Step by step illustration of DCF valuation technique
19 Lectures 01:02:49

5 steps to doing a DCF valuation
01:38

Download the illustration exercise for the module
00:03

Lets look at the data for the illustration in this module
04:55

Step 1a: Calculating EBIT
05:47

Step 1b: Calculating post tax operating cash profits
05:53

Step 1c: Calculating capex
05:50

Step 1d: Calculating operating cash investments
03:10

Step 1e: Calculating Free Cash Flows to Firm (FCFF)
02:52

Step 2a: Calculating WACC
06:15

Understanding the concept of discounting
03:06

Step 2b: Discounting future cash flows to present value terms
04:12

Step 3: Calculating Terminal Value
04:33

Step 4: Calculating Enterprise Value
00:58

Step 5: Calculating equity value and share price
01:40

Sensitivity analysis on share price
07:13

Recap of what we learnt in this module
01:15

End of Module 6
00:07

Practice Assignment #5: DIFFICULTY LEVEL - EASY
00:37
+
Module 7: Conceptual understanding of the multiples based valuation technique
15 Lectures 55:18

What are the different techniques of equity valuation?
05:11

A very brief overview of Discounted cash flow technique
01:48

Multiples based valuation: What is a multiple?
02:35

Multiples based valuation: what does a multiple denote?
01:32

Multiples based valuation: What are the different types of multiples used?
03:21

Illustration for this module
02:22

Financial statements supplements to the illustration
02:44

Steps to do a multiples based valuation
04:46

step 1: choosing the right peers
06:34

Step 2: Calculating the peer multiples
04:25

Step 3: Calculating the target value
06:18

So what is the best multiple to use?
07:51

Recap: What did we learn in this module?
03:40

End of Module 7
00:07
+
Module 8: Practical application of the multiples based valuation
6 Lectures 21:40

Download the illustration exercise for this module
00:03

How to do a sum of the parts valuation using multiples (1/2)
11:53

How to do a sum of the parts valuation using multiples (2/2)
05:27

End of Module 8
00:06

Practice Assignment #6: DIFFICULTY LEVEL - EASY
00:37
+
Module 9: Advanced excel functions to analyze large data
11 Lectures 01:16:32

Please download this excel template in this module

Download the excel template for this module
00:04

Understanding the LIST function
05:45

Understanding the OFFSET function
08:30

Understanding the SUMPRODUCT function
08:24

Understanding the GOAL SEEK function
08:29

Understanding the INDEX-MATCH function
18:54

Understanding the PIVOT function
11:14

Understanding the INDIRECT function
11:31

Practice Assignment #7: DIFFICULTY LEVEL - MEDIUM
00:37

End of Module 9
00:07
1 More Section
About the Instructor
Skillfin Learning
4.5 Average rating
332 Reviews
9,262 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.