Financial Modeling using Excel and VBA - Hyderabad Copy

Financial Modeling using Excel and VBA - Hyderabad Copy

 

  • Financial Modeling

    Sale Date Ended

    INR 12000
    Sold Out
  • All Modules 22% Disc

    Sale Date Ended

    INR 26000
    Sold Out
  • Equity Valuation

    Sale Date Ended

    INR 14000
    Sold Out
  • Financial Analysis

    Sale Date Ended

    INR 7000
    Sold Out

Invite friends

Contact Us

Page Views : 498

About The Event

JPFIS offers Classroom and LIVE instructor led online training program in Equity Valuation & Financial Modeling. The total duration of the program is 60 hours and is structured in three modules Equity Valuation, Financial Analysis using Excel and Financial Modeling. Delegates can choose any of the module or all three modules at a discount of 22%.

The Program is conducted keeping in mind schedule of working professionals, delegates can choose to attend Early morning or late evening sessions on weekdays or extended weekend sessions.

The principal aim of the program is to impart focused & practical skills in the area of Equity Research & Investment Banking, whether you are a finance graduate or an experienced professional seeking opportunity in Finance, JPFIS offers training to suit your academic or professional background along with respective real-life case studies making you a job-ready professional.

For a detailed structure of the program please download the brochure.

Training is conducted throughout, please contact us for details on start dates.

Equity Valuation (Theoretical Concepts) 15 Hours
Learning Objectives
- Understand the investment environment
- Understand the role of valuation in Investment Banking
- other area of Finance
- Perform microeconomic & industry analysis dynamics.
- Understand valuation of securities.
- Understand Financial statements
- Analyze financial performance & access earnings
- Conduct credit and equity analysis.
- Understand determinants of return on equity
- Apply & interpret financial statement ratios
- Forecast financial statements
- Understand & perform valuation.

Financial Analysis Using Excel 20 Hours
Learning Objectives
- Excel Environment and Useful Features
- Excel Functions & Useful Features
- Excel Techniques 1
- Excel Techniques 2
- Advance Functions
- Data / Financial Analysis
- Dynamic Sheets / User Controls
- VBA Introduction

Financial Modeling for Valuation 25 Hours
Learning Objectives
- Guidelines for setting up a Financial Model.
- Obtaining Source Financial Data
- Setting up model framework
- Historical Analysis
- Determining Growth drivers
- Arriving at key assumptions
- Forecasting Income Statement
- Modeling Fixed Assets
- Forecasting Balance Sheet
- Building cashflow statements
Valuation
- Estimating cost of equity
- Estimating discount rate/WACC
- Asset Based Valuation
- Multiplier Models
- Present Value Models
- Discounted Cash Flow
- Free Cash Flow to Firm
- Free Cash Flow to Equity
- Dividend Discount Models.

For a detailed structure of the program please download the brochure.
J P Financial & Investment Services
Website: www.jpfis.com ; Facebook: www.facebook.com/JPFIS

Venue Map