What you'll learn
Finding real world cost of capital and business value of companies
Build projected income statement, balance sheet and cash flow statement for Caterpillar Inc
Find the intrinsic value so that Buy/Sell recommendation for shares can be given
Master the financial modeling for real world companies
Design Professional and good-looking charts to advance your career
Direct Important discussion, no unnecessary stuff – so that your time can be saved
Requirements
Very basic knowledge of finance
Description
**Updated for 2022** Are you a person who want to apply your brain in Real world Financial Modeling and Valuation?Are you really looking for a course which can advance your knowledge of Financial Modeling?Are you graduate looking for starting your first job in finance world?Are you a professional looking for a pay hike or new position?Would you like to be your team lead in financial modelling projects?If answers to above questions is yes, then this is the perfect course for you !Experience of InstructorMr. CA Sanjeev Mittal had worked with Treasury and Finance department of multiple listed companies for more than 7+ years.He is having experience of taught more than 15,000+ students online and offline both.He had advised multiple companies on their financial model and Business valuation.Learn the advance Financial Modeling from the expert who had walked on the same path several times in the past.You shall get the best understanding of:Building sound financial model for real world company Caterpillar IncGain and learn in-depth understanding of company valuation and Intrinsic value of SharesDemonstrate superior skills at Work or UniversityGet ready for Investment Banking, Consulting career or any job InterviewYou will get the best:Understanding of Material and well-structured courseDetailed Explanation and Downloadable ResourcesRegular Course update as requiredAfter completing this course, you will be great at:Build Real world Projected Income Statement, Balance Sheet and Cash Flow Statement for any companyKnow the Real intrinsic value of a companyCreate Financial Model for a Company based upon real dataAbout the Course:Very Basic understanding of finance is needed to start this course.Unlimited access to all resources, excel files, sheets, links and much more.Learning by doingYou can contact us in message and we shall clarify your queries free of charge.Are you ready to make a choice of higher return on investment by purchasing this course? Still there is an unconditional 30 days money back guarantee, because we believe in quality content and client satisfaction. Go ahead and subscribe this course so that you don't miss the opportunity to separate yourself from others and get to the top of your career. Let's start learning together.
Overview
Section 1: Introduction to Financial Modeling
Lecture 1 Overview of entire financial modeling course
Lecture 2 Best way to take this course
Section 2: Analyzing Caterpillar Inc's Cost of Equity using Gordon's Growth Model
Lecture 3 Learning outcomes from this module
Lecture 4 Basic understanding of Gordon's Growth Model
Lecture 5 Downloading Historical Dividend Details of Caterpillar Inc
Lecture 6 Calculating Dividend Growth Rate for Caterpillar Inc.
Lecture 7 Finding Caterpillar Inc's Cost of Equity using Gordon's Growth Model
Section 3: Analyzing Caterpillar Inc's Cost of Equity using CAPM Model
Lecture 8 Learning outcomes from this module
Lecture 9 Understanding Basics of Capital Assets Pricing Model (CAPM)
Lecture 10 Downloading historical market price of S&P 500
Lecture 11 Understanding Expected Return on Market
Lecture 12 Computing Caterpillar Inc's expected return on market (general method)
Lecture 13 Computing Caterpillar Inc's expected return on Market using special method
Lecture 14 Understanding Basics about Beta
Lecture 15 Downloading historical data for Beta calculation
Lecture 16 Computing Caterpillar Inc's Beta in excel - Method 1
Lecture 17 Computing Caterpillar Inc's Beta in Excel - Method 2
Lecture 18 Calculating Caterpillar Inc's Cost of Equity using CAPM Model
Section 4: Computing Caterpillar Inc's Cost of Debt
Lecture 19 Learning Outcomes of this module
Lecture 20 Understanding Basics of Cost of Debt
Lecture 21 Calculating Caterpillar Inc's Cost of Debt (Before Tax)
Lecture 22 Analyzing tax rate of Caterpillar Inc
Lecture 23 Calculating Caterpillar Inc's Cost of Debt (After Tax)
Section 5: Computing Weighted Average Cost of Capital (WACC) for caterpillar Inc
Lecture 24 Learning outcomes of this module
Lecture 25 Understanding Basics of Weighted Average Cost of Capital (WACC)
Lecture 26 Calculating WACC for Caterpillar Inc
Section 6: Preparing historical financial data for modeling of Caterpillar Inc
Lecture 27 Learning outcomes of this module
Lecture 28 Understanding basic format of Income Statement for Caterpillar Inc
Lecture 29 Downloading Annual Report for Projection
Lecture 30 Preparing Historical Income Statement in excel model
Lecture 31 Understanding basic format of cash flow statement of Caterpillar Inc
Lecture 32 Preparing cash flow statement for excel model
Lecture 33 Understanding basic format of Balance Sheet of Caterpillar Inc
Lecture 34 Preparing Balance-Sheet for financial model in excel
Lecture 35 Rewriting Balance-Sheet for Financial Modeling
Section 7: Modeling multiple financial ratios
Lecture 36 Learning outcomes of this section
Lecture 37 Modeling Sales Revenue
Lecture 38 Modeling Current Assets and Current Liabilities to Sales ratio
Lecture 39 Modeling operating cost to sales ratio
Lecture 40 Modeling fixed assets to sales ratio for caterpillar Inc
Lecture 41 Modeling dividend for Caterpillar Inc
Lecture 42 Modeling taxes for Caterpillar Inc
Section 8: Preparing proforma financial model
Lecture 43 Learning outcomes of this module
Lecture 44 Structured proforma model
Section 9: Projecting Income Statement and Balance Sheet
Lecture 45 Learning outcomes of this module
Lecture 46 Important note
Lecture 47 Sales Projection
Lecture 48 Cost of goods sold projection
Lecture 49 Cash and Marketable Securities projection
Lecture 50 Operating current assets projection
Lecture 51 Fixed assets and depreciation projection
Lecture 52 Long term receivables projection
Lecture 53 Deferred income tax and intangible assets projection
Lecture 54 Current liabilities projection
Lecture 55 Post retirement benefits projection
Lecture 56 Other current liabilities projection
Lecture 57 Debt projection
Lecture 58 Common stock projection
Lecture 59 Cost of goods sold projection
Lecture 60 Interest on debt projection
Lecture 61 Interest on Marketable securities projection
Lecture 62 Profit before tax projection
Lecture 63 Tax projection
Lecture 64 Profit after tax projection
Lecture 65 Dividend projection
Lecture 66 Retained earnings projection
Lecture 67 Profit employed in the business projection
Lecture 68 Treasury stock projection
Section 10: Projected Free Cash Flow for the Firm
Lecture 69 Learning outcomes of this module
Lecture 70 Basic format for free cash flow for the firm
Lecture 71 Understanding PAT details in Free Cash Flow for the Firm
Lecture 72 Understanding depreciation details in Free Cash Flow for the Firm
Lecture 73 Current assets details in Free Cash Flow for the Firm
Lecture 74 Current liabilities treatment in Free Cash Flow for the Firm
Lecture 75 Capital expenditure treatment in free cash flow for the firm
Lecture 76 Adjustment of interest after tax in Free Cash Flow for the Firm
Lecture 77 Final projected free cash flow for the firm
Section 11: Intrinsic value of shares and buy or sell recommendation
Lecture 78 Learning outcomes of this module
Lecture 79 Long term growth rate and terminal value
Lecture 80 Intrinsic value and Buy/Sell recommandation
Section 12: Bonus section - Free Course on Technical Analysis of Shares of Global companies
Lecture 81 Fundamental Vs. Technical Analysis
Lecture 82 Types of Charts
Lecture 83 Types of Trends
Lecture 84 Trend Within a Trend
Lecture 85 Stages of Market
Lecture 86 Time Frame for Trading
Lecture 87 Trend Lines
Lecture 88 Long Term Trend Lines
Lecture 89 Trading View Platform
Lecture 90 Support and Resistance
Lecture 91 Demand and Supply with Support and Resistance
Lecture 92 Volume
Lecture 93 Candlestick Chart Patterns
Lecture 94 EMA
Lecture 95 MACD
Lecture 96 RSI Charts
Lecture 97 Stochastic Charts
Lecture 98 Divergance in Stock Market
Lecture 99 Bollinger Bands
Lecture 100 Fibonacci Levels
Lecture 101 Stocastic RSI
Lecture 102 Chaikin Oscilator
Lecture 103 VWMA
Lecture 104 Parabolic SAR
Lecture 105 SMI Ergodic
Lecture 106 Supertrends
Lecture 107 Choppyness Index
Lecture 108 Multicolinarity problem solve
Lecture 109 Gaps in stock market
Graduate students who want to become investment bankers, consultants or financial advisors.,Real world business and finance practitioners who are eager to take a step ahead and learn real world companies financial modeling skills


Homepage

https://www.udemy.com/course/practical-real-companys-financial-modeling-and-valuation/