This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Do you want to get into Investment banking/Equity Research/Portfolio Management i.e into Core Finance ?
Are you about to graduate from university and start looking for your first job?
Are you a young professional looking to establish yourself in your new position in Finance Domain ?
Would you like to become your team’s go-to person when it comes to Financial Modeling in Excel?
If you answered yes to any of these, then this is the right course for you!
CA Devang Maheshwari (The Instructor) of this course has extensive experience in Financial Modeling:
-
Worked as Senior Analyst in ICICI Securities & Purnartha Investment Advisory thus making & updating models all day
-
Experience in making financial Modeling for various clients at Job work
-
Handled more than 400 Cr during the Job tenure
Learn the basics of Financial Modeling from someone who has walked the same path. Beat the learning curve and stand out from your colleagues.
A comprehensive guide to Financial Modeling in Excel:
-
Become an Excel expert (From Basics to Pro)
-
Learn how to build sound Financial Models and stand out among your colleagues
-
Gain an in-depth understanding of the mechanics of Company Valuation using various methods like DCF/Relative Valuations/DDM
-
Gain in depth understanding of how to make Financial Statements & also How to forecast it
-
Portfolio Management
-
Fundamental Analysis
-
Report Writing
-
Sector Analysis
-
COVERS ALL TYPES OF VALUATION METHODS
-
Be prepared from day one for your Investment Banking, Financial Advisory or Consulting career
What we offer:
-
Well-designed and easy-to-understand videos FOCUSED ON INDIAN LISTED COMPANY
-
Detailed explanations with comprehensible case studies based on real situations
-
Downloadable course materials
-
25 hrs of intensive training
By completing this course, you will:
-
Be able to work comfortably with Microsoft Excel and many of its advanced features
-
Become one of the top Excel users in your team
-
Be able to build a P&L statement from a raw data extraction
-
Be able to build a cash flow statement
-
Know how to value a company using different valuation methods
-
Know how to calculate WACC & forecast financials in real life situations
-
Be able to build a valuation model from scratch
-
Know how to create a model with multiple scenarios
-
Know how to manage a portfolio
-
Know how to write a research report
About the course:
-
No significant previous experience is needed to understand the course properly and benefit from its content
-
Unlimited access to all course materials for lifetime
-
Emphasis on learning by doing
-
Our goal is to take your Microsoft Excel and Financial Modeling skills to the next level
Make an investment that will be highly rewarded in career prospects, positive feedback, and personal growth.
This course is suitable for graduates who aspire to become investment bankers as it includes a well-structured DCF model and goes through the theoretical concepts behind it. Moreover, it will encourage you to be more confident when coping with daily tasks and will give you the edge when the firm must decide whether to take you on for a full-time position.
People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills.
Go ahead and subscribe to this course! If you don’t acquire these skills now, you will miss an opportunity to separate yourself from others. Don’t risk your future success! Let’s start learning together now!
Who this course is for:
-
Graduate students who aspire to become investment bankers, financial advisory professionals, consultants etc.
-
Business and finance practitioners who are eager to improve their Excel and Financial Modeling skills
Thank You
CA Devang Maheshwari
Stock Market Basics & Indices
Excel
Financial Modeling Process
-
11Excel basics 1
-
12Excel basics II
-
13Excel basics III
-
14Excel Intermediate
-
15V Look up / Paste Special
-
16If Function
-
17Time value of Money -1
-
18Time Value of Money - 2 (PV/NPV/IRR)
-
19Amortization (PMT/IPMT/PPMT)
-
20Auditing/Data Tools/What If Analysis
-
21Protect / Text to Column / Pivot
-
22Chart /Sum if /Count if /Printing
-
23Home tab revision & conditional Formatting
-
24Macros
Step 3 - Introduction to company
-
25Financial Modeling Intro
-
26Step1 Understanding Source of Info
-
27Step-2 Measures of Corporate Performance - How Business Runs
-
28Measure 1 - P&L Statement
-
29Measure 2 - Balance Sheet
-
30Terminologies 1 - Deferred Tax
-
31Terminologies 2 - Minority Interest
-
32Terminologies 3 - JV & Associates
-
33Terminologies 4 - EPS & Other Comprehensive Income
-
34Measure 3 - Cash Flow Statement
Step 4 - Inputting Data
Step 5 - Analysis
Step 6 - Sector Analysis & Sources
Forecasting
Valuations
Report Writing
-
54Valuations & Cost of Equity
-
55Calculating Cost of Equity
-
56Calculation of growth rate for valuation model
-
57Suitability of DDM
-
58Calculating final Price Per Share (Example)
-
59Free Cash flow model & differences from DDM
-
60FCFF Calculations & Intrinsic value
-
61Sensitivity Analysis & How to use it
-
62Relative Valuation - 1
-
63Relative Valuation-2 Calculations
The final model is attached for reference. Kindly do not use this & claim own work. The purpose of this is to help you out in case you are stuck somewhere. The excel sheet is the property of CA Devang Maheshwari & the excel has been tagged from behind. Any authorized us is prohibited & can be traced easily