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
Offline Classes
Rs.50,000
Online Classes
Rs. 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

Module 1 - Syllabus for the foundation module

  • Introduction to financial modelling
    • Basic concepts
    • Accounting concepts and process
    • Sources of data
    • Modelling applications
  • Income statement and balance sheet
    • Understanding the two concepts
    • Revenue recognition principles
    • Application of the matching principle
    • Concepts of conservatism and materiality
    • Overview of other key accounting concepts
  • Cash flow and EPS
    • Analysis and interpretation of the cash flow statement
    • EPS and diluted EPS
    • Key differences between IFRS and US GAAP
  • Ratios
    • Role of ratios in financial analysis
    • Groupings and interpretation of ratios
    • Comparison across companies and sectors

Module 2 - Syllabus for 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.
  • Visualisation
    • Formatting, charts, dashboards.
  • Presentation/Summative case
    • Group presentations.

Module 3 - Syllabus for Power BI

  • BI basics
    • Intro, setup, data ingestion, UI navigation, basic charts.
  • BI reports / Power query editor
    • PQE, visualisations, UI, geolocation and other graphs.
  • Dashboard development
    • Calculated fields and dynamic dashboards.
  • Case work
    • Dynamic dashboards and group presentations.

Module 4 - Syllabus for financial statement analysis (FSA)

  • FSA using Excel
    • Creating and analysing the income statement, balance sheet, and cash flow statement in Excel with proper formatting and cell referencing.
  • Ratio analysis in Excel
    • Calculate and analyse 60+ financial ratios, including DuPont analysis, to evaluate company performance.
  • Corp finance concepts
    • Understand concepts such as TVM, cost of capital, capital budgeting metrics (NPV and IRR), and FCFF and FCFE for practical decision-making.

Module 5 - Syllabus for project modelling

  • Basic modelling
    • Build 3-statement financial models with integrated sensitivity analysis to support informed investment decisions.
  • Intermediate modelling
    • Create 4-statement financial models for manufacturing projects, including detailed debt and asset schedules and tax computations.
  • Complex modelling
    • Develop complex 4-statement financial models, including hard and soft costs, sophisticated debt schedules, and multi-sheet referencing for dynamic scenario analysis.

Module 6 - Syllabus for equity modelling and report writing

  • Data gathering & input
    • Source and create complete financial statements for listed companies, such as those in the IT sector.
  • Forecasting
    • Analyse revenue and cost drivers, evaluate multiple forecasting methodologies and project financial statements over a five-year period.
  • Analysis and sensitivity
    • Conduct DCF valuation and trend analysis, assess the impact of key economic variables and determine intrinsic value.
  • Recommendation and reports
    • Relative valuation of companies, peer analysis, recommendations on price range, report writing and visualisation.

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