Brochure
Enquire- 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.
- Home
- IMS Proschool
- Courses
- Financial Modeling Course
Financial Modeling Course
BY
IMS Proschool
Learn how to analyse an organisation’s performance by looking into their historical information with the Financial ...Read more
Online
2 Months
₹ 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
| Head | Amount 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
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
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.
Articles
Popular Articles
prev
next
