Financial Modeling Program

What is 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.

Who should do Financial Modeling?

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

Financial Modeling : Rated 4.9/5 based on 548 reviews

Heighlights Of The Program

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

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

3. Prepare financial reserch snapshots & Evaluating different sectors.

Application of Financial Modeling

Mergers & Acquisition

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

Equity Research

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

Investment Banking

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.

Credit Rating

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

Project Finance

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
  • BasicAccounting Principles
  • Income Statement, Balance Sheet
  • Cash Flow Statement
  • Financial Ratio Analysis
  • Reading theAnnual 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

Content of the Program

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
  • Balnce sheet
  • Cash Flow Statement
  • Geographic Revenue Sheet
  • Segment Revenue Sheet
  • Cost Statement
  • Debt Sheet
  • Analyze Revenue Drivers Forecast Geographic Revenues
  • Segment Revenues
  • Geographic Revenues
  • Cost Statement
  • Debt
  • 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

  • Report Writing on the basis of
    Financial Modeling

Training Fees Of the Program

  • All Graduates or Graduation Pursuing Students


  •     INR 35,000 + Applicable Taxes (including 4000 Registration)

  • MBA | CA | CS | Working Professional or any Graduate with minimum 8 months of the work ex in the same field"

  •     INR 35000 + Applicable Taxes (including 3000 Registration)

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