Financial Analysis Masterclass for Financial Analysts
3.2 (20 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,735 students enrolled

Financial Analysis Masterclass for Financial Analysts

Master Financial Statement Analysis, Financial Projections (Revenues, BS, Cash flow, Order) and Equity Value Projections
3.2 (20 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,735 students enrolled
Last updated 12/2018
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand the valuation technique like forward P/E to project the equity value per share
  • Understand the valuation process of any company from Economy, Industry to Company (EIC framework)
Requirements
  • Basic Accounting and MS Excel Knowledge
  • Passion to learn
Description

In this course, we will first understand about the company’s different business lines. Post which we will understand different factors, which can affect the revenue of the company in the long run. As Praj is involved into the ethanol segment so we will understand how ethanol is made and then we will project the demand of petrol. This will help us to project the demand of ethanol and expected order flows into the country. Once we will understand the ethanol projections, we will start creating assumption sheet, wherein we will project order flows for ethanol, brewery and emerging segment for the company over the period of next 2 years. Further, we will project revenues for each segment based on book to bill and execution ratio of the company. Thereafter, we will start projecting the operating margins through top down approach and will go through the conference transcript of the company to understand the expectation of management for OPM over the period of next 2 years. We will also create Asset schedule and debt schedule to project depreciation and interest cost. Once we will complete the projection of depreciation and interest cost, we will finally project other income. Other income will be calculated based on Cash yield. Post completing the projection of income statement, we will project working capital and complete the projection for balance sheet and thereby cash flow statement. At last, we will project the target value of the stock through forward P/E, for which we will understand how to create 1 year and 2 year forward P/E chart.We have used company’s result press releases and investor presentation to find out relevant data, hence this can assure the reliability of any past data and future projections.

Who this course is for:
  • Students who are pursuing CFA, MBA (finance), CA
  • Professionals in the field of investment banking/equity research
Course content
Expand all 49 lectures 07:34:00
+ Financial Statement Analysis
13 lectures 02:02:42
Punching Qtrly Consol Income Statement (IS)
10:29
Management Highlights
06:13
Quarterly Income Statement Analysis
07:22
Key Developments
10:41
Punching Quarterly Standalone Income Statement
09:06
Punching Quarterly Standalone Income Statement Continues
11:29
Linkages of Console Yearly Income
10:54
More on Console Yearly Income Statement
09:40
Calculating Total Revenue
05:06
Punching Consolidated Balance Sheet items
07:38
Punching Consolidated Balance Sheet items Continues
11:29
Punching Consolidated Cash Flow Items
11:21
Projecting Actual FY16 Cash Flow without Annual Report
11:14
+ Ethanol Demand and Order Flows Projections
5 lectures 51:33
Projections of Petrol Demand in India
09:11
Petroleum Planning and Analysis Cell
09:59
Projections of Ethanol Demand
09:12
Incremental Order Flows for EPC Players
10:58
Sensitivity Analysis for Overall Order Flows
12:13
+ Brewery and Emerging Market Order Flows Projections
3 lectures 24:48
Projection of Brewery Order Flows
08:44
Console Assumption Sheet
04:34
Projection of Emerging Market Order Flows
11:30
+ Projection of Revenues
13 lectures 01:55:35
Projections of Revenues
11:03
More on Projections of Revenues
09:07
Projection of Operating Cost
07:43
Projection of Operating Cost Continues
08:01
Operating Margins
08:45
Linking Operating Margins
07:05
How to Calculate Forex Gain or Loss
07:55
How to Calculate Forex Gain or Loss Continues
08:29
Projection of Other Income
06:53
Projection of Depreciation
10:23
Projection of Amortization
08:10
Projection of Finance Cost
11:07
Projection other Income Statement Items
10:54
+ Projection of Balance Sheet
3 lectures 29:32
Projection of Balance Sheet Items
11:59
Projection of Balance Sheet Items Continues
11:02
Calculating Trade Payable
06:31
+ Projection of Cash Flows
2 lectures 16:11
Projection of Cash Flow Statement
07:58
Projection of Cash Flow Statement Continues
08:13
+ Projections of Equity Value Per Share
3 lectures 25:07
How to Draw 1 Year Rolling PE Chart
10:19
How to Draw 1 Year Rolling PE Chart Continues
04:41
How to Draw 2 year Rolling PE Chart
10:07
+ Preparing Summary Sheet
2 lectures 20:54
Preparation of Summary Sheet
10:12
Preparation of Summary Sheet Continue
10:42