Mô tả

Hey, welcome to our best-selling Finance Training for Financial Analysts course.

We are glad to see you visit this course. 

If only we could shake hands!

What is this course about?

In this course, we will teach you the comprehensive skills needed to be a Financial Analyst.

We will illustrate the following broad content topics in great detail in this course:

1) Excel

2) Accounting

3) Financial statement analysis

4) Forecasting financial statements

5) Business valuation

6) PowerPoint

It is a very comprehensive course that will teach you the complete skills of a Financial Analyst.

How is this course useful for YOUR purpose?

Hey, did you watch the promo video? If not, please do. 

If you are looking to be a Financial Analyst, then this course will prepare you for the job.

Look, the Financial Analyst jobs are high paying ones. 

So your employer will want you to be on ready to work on a real project on Day 1!

Our course does exactly that - we make you job ready for your professional work.

The course provides all the practical training of a Financial Analyst.

You can crack your upcoming interviews easily with the learning from this course.

You have lifetime access to the course once you enroll. 

So even if you don't plan to start now, you can still enroll and come back anytime later.

What makes this course different than others?

This course content is unique!

You will learn exactly what you are required to do in your daily work.

You get access to practical real life illustrations of all key skills to be a Financial Analyst.

It is a completely hands-on course.

You need to carry out the illustrations in the course along with the instructor.

We provide you the same set up as the instructor. 

All illustration spreadsheets can be downloaded at your end.

You will feel as if somebody is guiding you step by step in all illustrations.

It is a very practical on the job training for you.

You are going to love our instructor's teaching style. 

He makes it very engaging and fun learning experience.

You will have practice assignments to test your learning from the course

The Practice Assignments are marked with varying difficulty levels - High, Medium and Low.

You will have unlimited access to our support.

Our support team responds to any course queries within 24 hours of your request. 

There are manually edited hand typed captions added on all lectures of this course. 

Feel free to refer to them in case you feel the need.

And of course, the price is competitive. 

What are other students saying about this course?

Check our our reviews below.

Read what student Rameez Akhtar wrote - 

"THE COURSE COVERS ALMOST EVERYTHING THAT WILL GIVE A YOUNG ASPIRING FINANCIAL ANALYST ALL THE TOOLS TO LAND A SUITABLE JOB IN THIS COMPETITIVE WORLD."

Go to the reviews section below to read more such stories.


What if YOU do not like the course?

Well, we will be very sad to hear that you did not like the course.

But you are well protected.

You have a 30 day money back guarantee in case you are not happy with the course.

No questions asked.

But we sincerely hope, you will definitely like the course!

What  next?

If there are any doubts, don't hesitate to reach out to us.

Start learning now.

See you inside the course.

Bạn sẽ học được gì

Undertake data analysis and manipulation in Excel

Make flexible and dynamic financial models

Create data visualization charts in Excel

Prepare the accounting statements of any company

Create income statement, balance sheet and cash flows statement from scratch

Perform ratio analysis on company financials

Compare the performance of different companies using a framework

Create a forward looking integrated financial model

Extrapolate and forecast forward looking financial ratios

Apply the Discounted Cash Flows valuation technique on a real company

Apply the Multiples valuation technique on a real company

Use PowerPoint for creating business presentations

Yêu cầu

  • Absolutely none. We will teach everything from scratch.

Nội dung khoá học

12 sections

Introduction to the FAST course

1 lectures
Welcome to the course
05:34

Module 1: Basic excel functions to analyze large data

17 lectures
Introduction to Module 1
03:44
Download the excel spreadsheet illustration for this module
00:34
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
Practice Assignment 1: DIFFICULTY LEVEL - MEDIUM
00:24
SOLUTION TO PRACTICE ASSIGNMENT 1
00:04
Lecture 17: End of Module 1
00:02

Module 2: Basics of financial accounting statements

18 lectures
Introduction to Module 2
01:43
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:07
Illustration of transaction 8
01:52
Illustration of transaction 9
01:34
Illustration of transaction 10
01:54
Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM
00:24
SOLUTION TO PRACTICE ASSIGNMENT #2
00:02
End of Module 2
00:06

Module 3: Financial performance analysis of companies

20 lectures
Introduction to Module 3
01:54
Introduction to financial performance analysis
02:24
Download the excel spreadsheet illustration for this module
00:34
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:27
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
Practice Assignment #3: DIFFICULTY LEVEL - EASY
00:25
SOLUTION TO PRACTICE ASSIGNMENT #3
00:02
End of Module 3
00:05
Please provide us your valuable feedback on the course thus far
00:25

Module 4: Forecasting an integrated financial model

24 lectures
Introduction to Module 4
02:10
Illustration for this module
01:13
Download the illustration exercise for the course
00:34
The six steps to forecasting a financial model
02:57
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
Practice Assignment #4: DIFFICULTY LEVEL - HARD
00:25
SOLUTION TO PRACTICE ASSIGNMENT #4
00:02
End of Module 4
00:06
Please provide us your valuable feedback on the course thus far
00:25

Module 5: Conceptual understanding of Discounted Cash Flow valuation technique

11 lectures
Introduction to Module 5
01:49
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
Please provide us your valuable feedback on the course thus far
00:25

Module 6: Step by step illustration of DCF valuation technique

20 lectures
Introduction to Module 6
02:45
5 steps to doing a DCF valuation
01:38
Download the illustration exercise for the module
00:34
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
Practice Assignment #5: DIFFICULTY LEVEL - EASY
00:25
SOLUTION TO PRACTICE ASSIGNMENT #5
00:02
End of Module 6
00:07

Module 7: Conceptual understanding of the multiples based valuation technique

16 lectures
Introduction to Module 7
02:04
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
Please provide us your valuable feedback on the course thus far
00:25

Module 8: Practical application of the multiples based valuation

8 lectures
Introduction to Module 8
03:33
Download the illustration exercise for this module
00:34
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
Practice Assignment #6: DIFFICULTY LEVEL - EASY
00:25
SOLUTION TO PRACTICE ASSIGNMENT #6
00:02
End of Module 8
00:06
Please provide us your valuable feedback on the course thus far
00:25

Module 9: Advanced excel functions to analyze large data

13 lectures
Introduction to Module 9
02:57
Download the excel template for this module
00:34
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:25
SOLUTION TO PRACTICE ASSIGNMENT #7
00:08
Please provide us your valuable feedback on the course thus far
00:43
End of Module 9
00:07

End of the course - What did we learn?

1 lectures
Quick Recap
02:44

COURSE CHALLENGE #1 - DIFFICULTY LEVEL : EASY

1 lectures
Please provide us your valuable feedback
00:43

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.