Financial Modeling Course with Certification from NSE India

Financial Modeling Course

IMS Proschool in association with NSE India offers Financial Modeling Certification course . It helps you to to make or enhance career in the field of Equity research, investment banking, corporate finance, Project finance, credit rating etc.We offer courses on financial modeling using Excel through classrooms , distance learning & live classrooms.

What is Financial Modeling?

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.

For more click here

Applications of Financial Modeling on Excel:

• 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.
• Equity Research : 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.
• 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
• Mergers & Acquisitions: 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
• Corporate Finance: Financial Modeling helps companies in assessing their own finances & build financial models for their on projects. & in creating a funding plan through debt and equity components

To see the power point presentation on Financial Modeling & its application in Equity Research, Investment Banking, Project Finance, Credit Rating etc: Click here

Courses we offer

Weekend classroom training 1. Learn modeling from scratch. 2. Learn 8  financial models 3. Get certification from NSE India. 4. Get trained by Industry experts 5. Get online study material 6. Get step by step book on Financial modeling 7. 12 weeks weekend program For more, click here

Distance Learning – Self Study 1. Get step by step 100 hrs of audia-video files 2. Learn 6 financial models 3. Get certification from NSE India. 4. Get step by step book on Financial modeling 5. Live forum to solve doubts 6. Get online study material For more, click here

Distance learning – Live Virutal classroom 1. Audio – Video enabled “Live & Interactive training program 2. Clear your subject doubts face-to-face with experts 3. Learn modeling from scratch. 4. Learn 8 financial models 5. Get certification from NSE India. 6. Get trained by Industry experts 7. Get online study material 8. Get step by step book on Financial modeling For more, click here

Sorry, either Adobe flash is not installed or you do not have it enabled

To see sample financial models prepared by IMS Proschool click here

Who Should Take This Course?

Description Candidates with following educational background interested in working for Financial Research firms, investment banking, Project Finance firms ,equity firms, Financial KPOs based in India:

1. Commerce Graduate with Excellent Accounting Skills
2. CA Inter (and above) passed
3. ICWA
4. Graduates/Post Graduates in Economics with first class
5. MBA’s with excellent accounting skills

Description

In financial modeling you learn to gather historical information on companies and analyze company / industry performance on various financial parameters. This analysis is then used to build a companies financial model, which in turn is key to projecting a future financial performance. Based on this model companies / investors can arrive at a suitable valuation for the companies.

The program conducted by Proschool comprises of the following courses. Each course includes topics which are relevant providing conceptual as well as practical knowledge required for the job.

1. 1. 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

   2. Economic Analysis
      

      Introduction – Relevance of Economics Microeconomics Macroeconomics

   3. 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

   4. Financial Markets
      

      Financial Markets & Intermediaries Equity Market Structure Equity Market Analysis Portfolio Management

   5. Excel Proficiency
      

      Formatting of Excel Sheets Use of Excel Formulae Function Advanced Modeling Techniques Data Filter and Sort Charts and Graphs Table formula and Scenario building Introduction to macros

   6. Financial Modeling & Valuation and Sector Overview
      

      Introduction to Data Gathering and Financial Modeling Prepare an Income Statement Prepare a Balance Sheet Prepare YTD Cash Flow Statement Prepare Geographic Revenue Sheet Prepare Segment Revenue Sheet Prepare Cost Statement Prepare Debt Sheet Analyze Revenue Drivers Forecast Geographic Revenues Forecast Segment Revenues Forecast Cost Statement Forecast Debt Proforma Adjustments Income Statement – Compute Margins Forecast Income Statement – Part A Forecast Income Statement – Part B Balance Sheet -Compute Ratios Forecast Balance Sheet Quarterly CFS and schedules CFS Projection CFS Projection – Part A CFS Projection – Part B Basics Of Valuation Valuation- Discounted Cash Flow Method (DCF) Valuation – Relative Valuation Valuation – Assumptions for Valuation Model Prepare Valuation Model Prepare Valuation Model – Part A Prepare Valuation Model – Part B Prepare Valuation Model – Part C Prepare Presentation Sheet(PS) Prepare Presentation Sheet(PS) -Part A Prepare Company Overview (CO) Prepare Company Overview (CO) – Part A Sector Overview

   7. Report Writing

Report Writing

Eligibility

Education: Candidate must be at least a graduate or equivalent. Those in the final year will receive the certification only after they provide the proof of graduation. All candidates should undergo the training program of IMS Proschool and successfully complete the online quizzes

How to enroll for the program?

1	Enroll with IMS Proschool	Enroll with IMS Proschool for study support. To take enrollment click here
2	Submit the Project	Submit the project at least 30 days  before the exam
2	Register for NSE EXam	Register for NSE India by sending Exam forms 30 days before the exam at IMS Proschool.
4	Take the exam	Take the Exam at NSE India Centre

About the NSE India – Financial Modeling Certification Examination

• The Certification Examination will be conducted at NSE Centres in select cities
• The Exams are conducted by NSE India after every quarter ( in the month of Feb, May, August & November)
• The examination is a computer based test and will comprise of multiple choice questions. The exact paper structure will be communicated to the students by IMS Proschool before every exam since the structure is subject to change.
• The students will receive their scores immediately after the exam.

Ask a query

Have a call to you

Download Prospectus

To know more about our course and cost click here.