FINANCIAL MODELLING PROGRAM

 

COURSE OBJECTIVE

Financial modelling based on advance excel expertise , this program useful for Fundamental Analysis like Equity valuation , investment research, Company valuation, Hedge fund investment , corporate finance, Merger & acquisitions. Financial Modelling 2 months Module program is both an academic learning process and a hands-on practical exposure to Advance excel. This course provides modeling experience that begins with construction of a basic financial model on excel spreadsheet and ends with completion of a full-scale forecasted model with valuation components. This course provides practical modelling knowledge and techniques as well as valuation tools for valuing Company  with and analysis of Economy & industries and determining the effects of mergers and acquisitions. Actual company financial statements are used.

 

Classes in Two Mode :

  • Face to Face Classes
  • Online Recorded plus intractive sessions - Join

 

 

Demo Video in Hindi : -

 

1. Fundamental of Excel

 

  • What is financial modelling?
  • Application of Excel
  • Excel Keywords shortcut

 

2. Tools of Financial Modelling

 

  • Data tables
  • Excel function
  • Excel formula
  • Chart

 

3. Data Summarize & Formatting

 

  • V lookup
  • H lookup
  • Pivot table

 

4. Risk & Return Modelling

 

  • Return
  • Beta, standard deviation, variance
  • Correlation, Covariance
  • Systematic risk, Unsystematic risk

 

5. Advance Excel Spreadsheet

 

  • VBA
  • Visual basic
  • Macros, Modules

 

6. Valuation Modelling

 

 

Part 1 Financial Statement Analysis

 

  • Prepare an Income Statement
  • Prepare a Balance sheet
  • Prepare Cash flow statement
  • Case study: financial statement of Particular Company
  • Cost of equity, cost of debt, cost of capital
  • Weighted Average Cost of capital WACC
  • Time value of Money-PVIF, PVIFA, FVIF, FVIFA

 

Part 2 Company Valuation

 

  • Ratio Analysis on spreadsheet
  • COMPANY valuation
  • DCF-FCFE, FCFF, DDM, EVA, MVA

Part 3 ROE Analysis & Relative Valuation

  • DuPont Analysis-ROE Analysis
  • Relative Valuation- P/EPS, P/SALE, P/BV

 

7. Merger & Acquisition (M&A) Analysis

 

  • Leverage Buyout Valuation
  • Merger & acquisition model


STUDENTS WILL BE ABLE TO:

 

  • Learning different modeling techniques
  • Developing hands-on Excel modeling skills
  • Understanding and selecting appropriate true value drivers
  • Building and forecasting an integrated set of financial statements
  • Analyzing different valuation approaches
  • Developing complete Discounted Cash Flow (DCF) valuation models
  • Incorporating elements, such as risk and sensitivity, into financial models
  • Fixing modeling problems, such as circular references
  • Producing high-quality, accurate financial reports

 

PLACEMENT ASSISTANCE:

 

After completing FINANCIAL MODELLING course lot of jobs available in financial services industry like.

  • Financial Analyst
  • Research Associate
  • Investment Analyst
  • Equity Research Analyst
  • Private Equity Analyst
  • Derivative Analyst
  • Fixed Income Analyst
  • Credit Analyst
  • Receivable Analyst

 

FEE STRUCTURE

 

Training program

DURATION

FEE

Financial modelling

3 months

35000/-

 

 

Keywords - financial modelling course in delhi, financial modelling classes in delhi, financial modelling fees in delhi, financial modelling institute in delhi