Financialmodelling Course

Complete A-Z of Financial Modelling (India Focused)

Last updated 2022-01-10 | 4.4

- Financial Modeling from Scratch
- Fundamental Analysis
- Excel Expert

What you'll learn

Financial Modeling from Scratch
Fundamental Analysis
Excel Expert
Company Valuations - All Type
Ratio Analysis
Portfolio Management
Report Writing
Forecasting Financial Statement
Industry Analysis
Competitor Analysis

* Requirements

* No

Description

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

Who this course is for:

  • Graduates/Post Graduates/CA/CFA

Course content

12 sections • 68 lectures

What is Financial Modeling? Preview 11:59

Why Financial Modeling ? Preview 05:00

Structure of Doing Business in India Preview 09:11

Equity basics Preview 18:45

Listing & Exchanges Intro Preview 16:18

IPO Preview 09:49

NSE/BSE - The exchanges Preview 10:42

Changing Prices & Indices Preview 19:35

Indices 2 Preview 08:41

Nifty 50 Preview 17:53

Excel basics 1 Preview 35:04

Excel basics II Preview 22:15

Excel basics III Preview 11:13

Excel Intermediate Preview 33:27

V Look up / Paste Special Preview 38:54

If Function Preview 15:20

Time value of Money -1 Preview 58:27

Time Value of Money - 2 (PV/NPV/IRR) Preview 29:15

Amortization (PMT/IPMT/PPMT) Preview 18:40

Auditing/Data Tools/What If Analysis Preview 24:08

Protect / Text to Column / Pivot Preview 24:55

Chart /Sum if /Count if /Printing Preview 28:44

Home tab revision & conditional Formatting Preview 27:09

Macros Preview 15:46

Financial Modeling Intro Preview 05:02

Step1 Understanding Source of Info Preview 48:49

Step-2 Measures of Corporate Performance - How Business Runs Preview 18:14

Measure 1 - P&L Statement Preview 17:52

Measure 2 - Balance Sheet Preview 35:30

Terminologies 1 - Deferred Tax Preview 18:57

Terminologies 2 - Minority Interest Preview 12:07

Terminologies 3 - JV & Associates Preview 09:21

Terminologies 4 - EPS & Other Comprehensive Income Preview 14:24

Measure 3 - Cash Flow Statement Preview 49:12

A) Common Size Statements Preview 18:55

B) Introduction to Ratios Preview 08:08

Liquidity ratios & Calculations Preview 31:32

Solvency ratios Preview 21:37

Activity ratios Preview 27:08

Profitability Ratios Preview 17:04

Ratio's & Business Understanding Preview 06:03

Competitor Analysis Preview 05:01

How to forecast sales Volumes Preview 17:42

How to Forecast selling price Preview 06:30

Model Sales Forecast Preview 36:57

P&L Forecast Preview 09:43

Fixed Asset Schedule & debt Schedule Preview 14:52

Balance Sheet Forecasting Preview 27:36

Debt Schedule & Balance Sheet Adjustment Preview 24:20

Valuations & Cost of Equity Preview 36:38

Calculating Cost of Equity Preview 34:13

Calculation of growth rate for valuation model Preview 23:12

Suitability of DDM Preview 26:10

Calculating final Price Per Share (Example) Preview 14:12

Free Cash flow model & differences from DDM Preview 35:25

FCFF Calculations & Intrinsic value Preview 25:46

Sensitivity Analysis & How to use it Preview 21:58

Relative Valuation - 1 Preview 21:19

Relative Valuation-2 Calculations Preview 57:16

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

Portfolio Management Preview 19:52

Calculating Portfolio Risk & Return Preview 16:38

Calculating Portfolio Risk & return -2 Preview 20:22