Financial Modeling Course

BY
IMS Proschool

Learn how to analyse an organisation’s performance by looking into their historical information with the Financial Modeling Course on Proschool.

Mode

Online

Duration

2 Months

Fees

₹ 40000

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom +1 more
Mode of Delivery Video and Text Based
Frequency of Classes Weekdays, Weekends

Course overview

Financial modelling is a core skill required in almost all business fields and professions, such as entrepreneurs, equity analysts, and investment bankers. Financial Modeling Course training is a joint venture of NSE, NSDC, and IMS Proschool wherein you will learn about the various aspects of financial modelling. 

The financial Modeling Course by Proschool will teach you how to analyze the historical performance of an enterprise and build financial models using relevant financial parameters. This analysis will help you understand the company’s performance and how it can be improved. This knowledge is useful in various applications such as equity research, project finance, corporate finance, investment banking, credit rating, etc. 

The Financial Modeling Course has three learning modes, depending on whether you want in-person training, live online classes, or distance learning. You can receive the certification once you complete all the internal assessments and quizzes. Moreover, you can also appear for the NSE certificate using this training.  

The highlights

  • Three learning modes
  • Placement assistance
  • Joint certification from NSE, IMS Proschool, NSDC
  • 24*7 access to online material
  • 75+ hours training
  • Training by Industry experts 
  • Additional certification option
  • Projects, quizzes, assessments

Program offerings

  • 24*7 access to online material
  • 70+ hours training
  • Additional certification option
  • Three learning modes
  • Certification training
  • Placement assistance
  • Industry experts
  • Projects
  • Quizzes
  • Assessments
  • Jv of nse
  • Ims proschool and nsdc.

Course and certificate fees

Fees information
₹ 40,000

Financial Modeling Course fee structure

HeadAmount in INR
Offline Classes
₹50,000
Online Classes
₹40,000


certificate availability

Yes

certificate providing authority

National Stock Exchange of India Ltd +2 more

Eligibility criteria

You can secure your Financial Modeling Course certification by completing all the internal quizzes and exams. 

What you will learn

Presentation skills Decision making skills Analytical skills Critical thinking Knowledge of excel

statements, Excel

After concluding your training in the Financial Modeling Course programme, you will learn about: 

  • Excel
  • Financial statements
  • Critical thinking
  • Advance Excel
  • Financial management and ratio analysis
  • Analytical skills
  • Financial modelling
  • Valuation methods
  • Decision making 
  • Report writing
  • Presentation skills 

The syllabus

Foundation

  • Intro to Financial Modelling: Basic concepts of Financial Modelling, accounting concepts and processes, sources of data, application of modelling.
  • Income Statement, Balance Sheet: Familiarization with IS and BS, revenue recognition, application of matching, conservatism, materiality, and other concepts.
  • Cash Flow, EPS: Understanding and interpreting CFS, EPS and diluted EPS, differences in IFRS and US GAAP.
  • Ratios: Role of ratios in financial analysis, groupings and interpretation of ratios, comparisons across companies & sectors.

Advanced Excel

  • Essential functions: Basics, average, sum, sum if, product, count, Pivot, Slicers, data cleaning.
  • Advanced functions: Goal seek, scenario analysis, index, lookup, matching, PV, FV, NPer, Rate, GPT add-in.
  • Visualization: Formatting, Charts, Dashboards.
  • Presentation/ Summative case: Group Presentations.

Power BI

  • BI basics: Intro, Setup, Data Ingestion, UI Navigation, Basic Charts.
  • BI reports / Power Query Editor: PQE, Visualizations, UI, Geolocation, & Other Graphs.
  • Dashboard Development: Calculated Fields, Dynamic Dashboards.
  • Case work: Dynamic Dashboard & Group Presentations.

Financial Statements Analysis (FSA)

  • FSA in Excel: Building And Interpreting IS, BS, And CF In Excel, Formatting & Cell Referencing.
  • Ratio analysis in Excel: Calculate and interpret over 60 ratios in Excel, including DuPont analysis.
  • Corp finance concepts: TVM, Cost of capital, Capital budgeting – NPV and IRR, FCFF and FCFE.

Project Modelling

  • Basic modelling: Build 3-statement financial model with sensitivity analysis to take investment decision.
  • Intermediate modelling: Build 4-statement financial model for manufacturing, including debt and asset schedules and tax.
  • Complex modelling: Build 4-statement financial model, including hard and soft costs, advanced debt schedules, multi-sheet referencing

Equity Modelling & Report writing

  • Data gathering & input: Source and create complete financial statements for a listed company (IT sector).
  • Forecasting: Interpret revenue & cost drivers, evaluate various forecasting approaches, project financial statements for the next five years.
  • Analysis & sensitivity: Apply DCF valuation, trend analysis, impact of economic parameters, arrive at intrinsic value.
  • Recommendation and reports: Relative valuation of companies, peer analysis, recommendations on price range, report writing & visualization.

Admission details

  • You can start your process for the Financial Modeling programme’s admission by visiting the official site.
  • Use the ‘Enroll Login’ tab on the top of the weblink. 
  • Enter your login details. In case you are visiting IMS Proschool for the first time, click on ‘Register.’
  • A registration form will appear. Fill in all the necessary details such as your full name, phone number, gender, email address, a password of your choice, name on AADHAR, date of birth, your preferred learning mode, your preferred IMS school centre, nationality, address, your highest qualification and your current work profile if any.  Click ‘Enter’.
  • Pay the necessary fee as per your choice of learning mode. Once completed, you can begin learning. 

Filling the form

The Financial Modeling Course has a detailed application form that you need to fill as part of your admission process. Proschool asks for these details to complete your registration cum application form: your full name, name on AADHAR, phone number, gender, date of birth, email address, your preferred IMS school centre, a password of your choice, your preferred learning mode, address, your highest qualification, nationality, and your current work profile if any.  

Evaluation process

The Financial Modeling Course also offers an opportunity to receive an NSE Academy certificate. For this, you need to pay Rs. 1,700+ GST at the end of the course and attend the exam at IT centres. Once you have passed, you will receive your NSE Academy certificate.

How it helps

Financial Modeling Course certification offers three learning modes so that you can decide the best-suited one for you. You also get in-depth knowledge of a core skill that will help you in your career prospects. Moreover, the certificate and placement assistance offered by the course will help you get a job.  

Instructors

Mr Mihir Kapuria
Freelancer
Freelancer

Mr Akshay Tiwari
Freelancer
Freelancer

FAQs

What are the three learning modes of the Financial Modeling Course programme?

The three learning modes are ‘Classroom Program’, ‘Live Online Training’ and ‘Distance Learning.’

Will the course have separate training for the NSE certificate?

Yes. There are three additional modules in the syllabus to help you prepare for the NSE certificate exam.

How many modules are there in this course?

There are six compulsory modules and three additional modules in this course. 

Will I learn Excel formulae and features in the course?

Yes. You will learn about Vlookup, pivot tables, data filter and sort, charts and graphs and lots more. 

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books