Financial Modeling Program

The Financial Modeling Certification course helps one to make or enhance career in the field of Equity research, investment banking, corporate finance, Project finance, credit rating etc. Financial Modeling is a key skill with application in several areas within banking and finance industry as well as in large corporations. Individuals with financial modeling skills can work in the areas of investment banking / equity research/trading, financial KPOs that are assisting investment bankers / equity research firms, financial advisory firms, project finance and in the area of performance tracking and MIS for companies themselves.

In general candidates with following educational background interested in working for Financial Research firms, investment banking, Project Finance firms, equity firms, Financial KPO’s based in India

Heighlights Of The Program

1. Your gate way to career in Equity Research, Investment banking, Credit Research, project finance & business Analysis.

2. Learn excel Modeling for analyzing Forecasting & valuing different companies.

3. Prepare financial research snapshots & Evaluating different sectors.

Financial Modeling helps the companies in access the value of the company which they want to merge or acquire by forecasting the revenues, preparing debt schedule, by doing competitor analysis

Financial Modeling enables analyst in examining an organization's financial projections, competitor's projections and other dynamics to determine whether it is a smart or a risky investment

Financial Modeling helps Investment Banker in Valuing the company by forecasting the revenues. On the basis of Valuation they recommend the buyer or seller on acquisition of new funds or investments in new funds respectively.

Financial Modeling equips Credit Analysts in collecting historical information & , outstanding debts and forecasting future growth on excel sheet to determine the degree of risk factor , which helps him/her in giving rating

Financial Modeling helps in assessing the financial viability of a project and creating a funding plan through debt and equity components

Syllabus

  Accounting fundamentals
  • Introduction to Accounting
  • Basic Accounting Principles
  • Income Statement, Balance Sheet
  • Cash Flow Statement
  • Financial Ratio Analysis
  • Reading the Annual Report
  • International Accounting Standards
  Economic Analysis
  • Introduction - Relevanceof Economics
  • Microeconomics
  • Macroeconomics
  Financial Management
  • Time value of money
  • Long term financing
  • Cost of capital
  • Risk and return
  • Capital Structure
  • Dividend Policy
  • Working Capital Requirements
  • Equity and Industry Analysis
  Financial Market
  • Financial Markets &Intermediaries
  • Equity Market Structure
  • Equity Market Analysis
  • Derivatives
  • Fixed Income
  • Portfolio Management

Three Level Of Testing

Level-I

  • Module wise testing
  • Candidates must score 100% before proceeding to next module

Level-II

  • Spread Sheet Skills
  • Preparation of Model for a Live Company
  • Candidates must submit a model for evaluation, Viva on the model submitted by you

Level-III

  • Applications of Concepts

EXCEL PROFECIENCY

  • Formatting of Excel Sheets
  • Use of Excel
  • Formulae Function
  • Advanced Modeling Techniques
  • Data Filter & Sort
  • Charts & Graphs
  • Table Formula & Scenario Building
  • Introduction to Macros

EXCEL PROFECIENCY

  • Prepare an Income Statement
  • Balance sheet
  • Cash Flow Statement
  • Geographic Revenue Sheet
  • Segment Revenue Sheet
  • Cost Statement
  • Debt Sheet
  • Analyze Revenue Drivers Forecast Geographic Revenues
  • Segment Revenues
  • Geographic Revenues
  • Income Statement

EXCEL PROFECIENCY

  • Balance Sheet and Cash Flow Statement
  • Performa Adjustments
  • Income Statement - Compute Margins
  • Balance Sheet - Compute Ratios Cash Flow Statement Projection
  • Valuation- Discounted Cash Flow Method (DCF)
  • Valuation -Relative Valuation Valuation -Assumptions for Valuation Model
  • Prepare Valuation Model
  • Prepare Presentation Sheet
  • Prepare Company Overview
  • Sector Overview

FINANCIAL MODELING

  • FINANCIAL MODELING

Eligibility

Anyone who is interested in making career in Core Finance and want to gain some practical exposure before getting in to the industry can go for Financial Modeling programs. Minimum Eligibility: 12th pass outs or pursuing under graduation or any professional programs.

Duration of the Program

Mode: 1. Internship or a regular (45 days to 2 months, 400 hours) Timing morning 10:00 am to 7:00 pm 2. Regular (3 months to 6 month, 400 hours) Timing 3 hours a day as per the scheduled decided. "It takes nearly about 400 hours for successfully completions of Financial Modeling Training."

Job Oppertunities

"In India generally the average salary of a Financial Modeling Trainee is in the range of Approximate 2.8 to 5.0 lakhs per annum, and they can easily find placements in Multinational Banks, KPO's, Research House, Investment Banks etc."

Note: placement packages may be vary as per the degree they are pursuing or completed