Practical Real Company'S Financial Modeling + Valuation 2021

You will be most preferable candidate for getting a job/advance your career in Financial Modeling from the day 1!

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