support@edupristine.com1800 200 5835Request a Call
Call Me

Buy Course Convenient Evening Sessions
Classes on Tue & Wed
Time: 6.30 PM to 9.30 PM
Weekday Batch on 13th Oct
Contact Us

Executive program in Financial Modeling (New Delhi)

Financial Modeling Course Training
Unlike most of the other businesses, all finance professionals have to continuously work with large amount of numbers. Almost everyone uses MS Excel to create financial models to analyse and project financial statements. A mastery over financial modeling will give all the professionals an edge over others as they can do their work faster and with more accuracy.

What is Financial Modeling?

Financial Modeling is one of the most fundamental and widely sought after skills in the finance industry. It is the art of building a model to depict financial statements and investment analysis using MS Excel. This helps arrive at optimal business solutions by analyzing various parameters. At the end of the course,You will be able to do the task of building a model depicting financial statements/business model, which helps in decision making.

The EduPristine Financial Modeling course will teach you the basic of MS Excel all the way to creating successful Financial Models. By the end of the course, you will be able to independently build models that are robust and provide dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.

Learn Financial Modeling with us in the classroom environment with hands on experience. The first module is Equity Evaluations and the second module teaches advanced Excel. So you can make a model firstly, and then understand how to use that model for various purposes like projections, evaluations etc.

Course Modules

  • Module 1
    • Excel as a tool for financial modeling
    • Building financial models best practices
    • Modeling growth drivers, depreciation, cost drivers, asset & debt schedules
  • Module 2
    • Projecting cash flow statement
    • Circular references and handling them
    • Financial ratio analysis
    • Valuation using DCF & Comps
    • Scenario analysis and Building valuation dashboards
    • Scenario Analysis and Building Dashboards
  • Module 3
    • Advanced Tools in Excel for Auditing Financial Models
    • Auditing Large Models and Complicated Formulas
    • Advanced Excel Functions to Create Flexible Financial Models
    • Using Index, Match and Offset Functions to create Flexible Models
    • Mastering Financial Functions – Lease Analysis for Facebook
    • Advanced Charting Techniques in Excel – Creating Football Field
    • Creating Dashboard for Financial Data
  • Module 4
    • Understanding Macros
    • Creating Flexible Dashboards & Charts Using Form Controls
    • Introduction to VBA for Financial Modeling
    • Recording Macros to Break Circular References
    • Implementing Monte Carlo Simulation for Revenue Analysis –I
    • Implementing Monte Carlo Simulation for Revenue Analysis –II
    • Summarization and Concluding Session of first 4 Modules
  • Module 5
    • Overall all picture of Financial Modeling for Real Life Company
    • Data Collection from Public Sources
    • Understanding the Business Profile of the Company
    • Modeling Revenue & Expenses Drivers
    • Modeling Income Statement
    • Modeling Implied EBITDA
    • Analyzing Data Collected so far
  • Module 6
    • Compiling the data collected
    • Balance Sheet Projections
    • Cash Flow Statement Projection
    • Performing Valuation & Sensitivity Analysis
    • Calculating Enterprise Value
    • Calculating Implied Market Capitalization
    • Concluding Financial Modeling for Real life Company

Excel in the financial world

The course will enable you to
  • Value and analyze Firms, IPOs and FPOs in Financial Modeling.
  • Investments in nascent stages can be valued with accuracy with hands on Financial Modeling for eg. Private Equity/ Venture Capital Investing
  • Build your own financial models

The ideal candidate for financial modeling

This program is suitable for students and professionals related to Investment, Equity Research, Credit, Project, Mergers & Acquisition, Corporate Finance, Critical Thinking and analytical skills. It is also ideal for CA, CFA Program candidates, FRM, MBA Finance, B TECH and Commerce Graduates who want a career in any of the above profiles.

Financial Modeling is also a suitable choice for those in non-finance related careers such as in the preparation of Business Plan, working on Excel, decision making and mapping theory to practical.


Commercial Banks use Financial Modeling for disbursing loans for the projects; Project Management uses it for performance tracking of on-going projects. 

Financial Modeling concepts can be applied to any industry. Individuals who hold an MBA and also possess knowledge of Financial Modeling have an advantageous edge over others.


Students should have hands-on experience with Excel and a brief idea about Finance, Balance Sheets and Cash Flow Models.

Course Highlights

Extensive Classroom Training
24 days (48 hrs.) Get trained by topic experts with interactive learning.
Excel Workbooks
Create models following a step-by-step approach devised by professionals. These workbooks have been specially designed to ensure you incorporate best industry practices of financial modeling.
Live Webinar
14 days Online Lectures with Recordings for all the topics.
Comprehensive study notes
Download complete course material for future reference and to understand concepts better.
Case Study Approach(Using models for analysis, including valuations)
Appreciate the concepts by working on case studies derived from real-life situations.
EduPristine& BSE brings Financial Modeling Joint Certificate Program
24x7 Online Access
24x7 Online Access* to Course Material (Unlocked Excel Models, Presentations, etc.)
Doubt Solving By Experts
Write to us and get your doubts solved by our experts within 2 business days. You can also initiate a discussion by posting it on active forums.

Financial Modeling Course Batch Dates and Venue

Executive program in Financial Modeling 13th Oct
Weekday Batch
EduPristine, #44,2nd Floor Regal Complex Outer Circle Connaught Place 9717466552
Executive program in Financial Modeling 16th Aug
Weekend Batch(Sunday)
EduPristine, #44,2nd Floor Regal Complex Outer Circle Connaught Place 9717466552
Financial Modeling Training Highlights
24 days Classroom Training (48 hrs)
Webinar Video Recordings for each topics
Downloadable Financial Models for Various Companies
Day wise Topic Access Materials & Downloadable Financial Models
Case Studies Sessions
Access for Downloading Many Sample Models
Access Step by Step Model Templets
Study Notes: Downloadable Complete Course Material
Domain Specific MS Excel Workbook and Practice
Lecture Handout
Certificate of Participation / Excellcence
24 * 7 Access to Online Materials
Discussion Forum
I found the Financial Modeling course offered by Edupristine as knowledge enriching. Course content and lectures were good and helped in understanding complex financial models and improved efficiency at work.
EduPrisitine's faculty is awesome. The classroom sessions from industry practioners gave a deep understanding of the topics. As a PMO Lead, I expected more on project finance with advanced excel tricks but I got a lot great stuff to learn apart from it. I thanks Pristine faculty for this. Looking forward for continual relation with Pristine.
I am a rookie with MS Excel. Will it be difficult to learn Financial Modeling? Difference between learning MS Excel and Financial Modeling? What career can I build by learning Financial Modeling?

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

DM_course_detail.php Post ID = 78166