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

EXCEL PROFECIENCY

EXCEL PROFECIENCY

FINANCIAL MODELING