Welcome to Financial Corridor

FINANCIAL MODELLING PROGRAM

COURSE OBJECTIVE 

Financial modeling 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 Modeling 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 modeling 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.

1. Fundamental of Excel

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

2. Tools of Financial Modeling

  • Data tables
  • Excel function
  • Excel formula
  • Chart

3. Data Summarize & Formatting

  • V lookup
  • H lookup
  • Pivot table

4. Risk & Return Modeling

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

5. Advance Excel Spreadsheet

  • VBA
  • Visual basic
  • Macros, Modules

6. Valuation Modeling

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 MODELING 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

PAY NOW

Financial modelling

2 months

35400/-

                                                                                                                                               

 
Quick Query Online
 
 
All Rights Reserved 2014. Financial Corridor Design and Developed by: W4S