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.


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. At times models need to be created from scratch or sometimes maintaining and updating the existing financial models. This helps arrive at optimal business solutions by analysing various parameters.

The EduPristine Advanced Certificate in Financial Modeling (ACFM) course will teach you the use of MS Excel functions 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 analyse a company from multiple standpoints: operations, investment, financing and valuation.

Earn Advanced Certificate in Financial Modeling (ACFM) with us in the classroom environment with hands on experience. So that initially you can make a model, and then understand how to use that model for various purposes like projections, evaluations etc.


  • Building Primary & Secondary Axis in a Chart
  • Creating Flexible Charts Using Form Controls
  • Tracking the progress of the construction of the commercial property: Radar Charts
  • Breakup of the Funding for Renewable Energy project: Creating Waterfall Charts
  • Breakup of the Funding for Renewable Energy project: Creating Waterfall Charts
  • Breakup of the Funding for Renewable Energy project: Creating Waterfall Charts
  • Track the Project Progress : Creating Gantt Chart
  • Equity Valuation: Application & Process
  • Return Concepts: CAPM Model, Fama-French Model, Pastor-Stambaugh Model and Multifactor Models
  • Return Concepts: CAPM Model, Fama-French Model, Pastor-Stambaugh Model and Multifactor Models
  • Dividend Discounted Valuation: Gordon Growth Model, H-Model, Multistage stage-DDM, PVGO and SGR
  • Free Cash Flow Valuation: Approaches To Calculate Free Cash Flow to the Firm (FCFF), Free Cash Flow to the Firm (FCFE)
  • Market Based Valuation: Price & Enterprise Value Multiples
  • Residual Income Valuation: Residual Income Model Vs. DDM & Free Cash Flow Model
  • Private Company Valuation: Methods Of Private Company Valuation
  • Basic Analysis of the Case Study
  • Building the Historical Statements
  • Calculating Growth Drivers and Future Assumptions
  • Revenue Build-Up - Projecting the Future Revenues
  • Cost Build-Up - Projecting the Future Cost
  • Asset and Depreciation Schedule
  • Debt and Interest Schedule
  • Retained Earning Schedule
  • Modeling the Projected P/L and BS
  • Modeling the Projected Cash Flow Statement
  • Performing Ratio Analysis
  • Understanding the Circularity in Financial Models
  • WACC and Cost of Equity Analysis
  • WACC and Cost of Equity Analysis
  • Sensitivity/Scenario Analysis using Data Table
Sector Study
  • Growth drivers
  • Competition
  • Impact of change in technology and consumer behaviour

Company study
  • SWOT
  • Sustainable competitive advantages / Moats
  • Value creation
  • Signs of value destruction
  • Retained Earning Schedule
  • Degree of cyclicality
  • Data Collection from Public Sources
  • Understanding the Business Profile of the Company
  • Modeling Revenue & Expenses Drivers
  • Modeling Net Income
  • Modeling Implied EBITDA
  • Income Statement and Balance Sheet Projection
  • Cash Flow Statement Projection
  • DCF and DDM Valuation and Sensitivity Analysis
  • Calculating Enterprise Value and Implied Market capitalization
  • Usage of Equity Research Reports
  • Sell Side v/s Buy Side
  • Types of reports
  • Components of an equity research report
  • Macroeconomic Landscape
  • Risks to Investment Recommendation
  • Summary / Investment Thesis
  • Merger Analysis - key Drivers and Inputs
  • Synery and Accretion/Dilution Analysis
  • Merger Plan - Ownership Vs Deal Price
  • Merger Plan - Ownership Vs Deal Price
  • Performing Sensitivity Analysis on Acquirer's EPS
  • Performing Contribution Analysis
  • Introduction to Databases
  • Introduction to Pitchbook
  • Parts of a Pitchbook
  • Key Sources of Information
  • Best practices for Preparing Pitchbook
  • Introduction to Credit Research
  • Usage of Credit Ratings
  • Credit Rating Agencies
  • Approach to Rating
  • Overall Scoring Methodology
  • Financial Risk Evaluation
  • Industry Risk Evaluation
  • Management Risk Evaluation
  • Business Risk Evaluation
  • Modeling Using Named Ranges, Revenue Matching (Index Match)
  • Credit Transition Analysis (Array Functions and Lookups)
  • Portfolio Analysis (Sum Product)
  • Generating Scenarios (Offset function)
  • Building Flexible & Growing Models (Offset, Index)
  • Valuation of Startup in e-commerce (Goal Seek)
  • Synergy Modeling (Solver)
  • Modeling Deferred Taxes and Loss Carried Forward (Max, Min)
  • Introduction to Macros
  • Automatic formatting of charts
  • Form controls and Active X controls
  • Understanding VBA - Sub & Functions
  • Understanding the relevant language constructs
  • IDC implementation using Macros
  • Breaking circular loops in Financial Models
  • Monte Carlo Simulation
  • Basics of Debugging VBA Code
  • Understanding circular loops in Excel
  • Interest During Construction
  • Cash Distribution and Tranches
  • Modeling Delays in Project
  • Escalation Frequency Implementation
  • Understanding Modeling Approach and Steps
  • Understanding Business Situation
  • Modeling Area Parameters
  • Modeling EPC and Capex
  • Modeling Financing Schedule and Revenue & Cost Buildup
  • Calculating Interest During Construction
  • Understanding Common Terminology
  • IRR Hurdles: Compounding and Period Selection
  • Modeling Levered & Unlevered IRR
  • Pre-Money and Post Money Valuation
  • Modeling Cash Flow Waterfall Structures in Private Equity Deals
  • Modeling Derivatives, Modeling the payoffs of Call and Put Options
  • Valuing Options: Binomial Pricing Model and Black Scholes Model
  • Options Trading Strategies: Modeling Protective Put, Covered Call, Strangle, Straddle, Bull Call, Bull Put, Bear Call/Put, Butterfly, Box Spread, and Condor Strategies

Sample Preview of our material: Quantitative Methods && Causes of Deadweight Loss


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


Advanced Certificate in Financial modeling is aimed at those people who need to build or run financial models. For those with no modelling experience, this course provides a solid introduction to real-world financial modelling. For experienced modellers, this course will help the quality and productivity of your modelling.

Professionals in corporate and financial institutions who wish to improve their financial valuation skills to a superior level - Bankers/Real Estate Finance Executives, Analysts, Financial Managers and Consultants, Fund Managers, Investment Bankers and Consultants, Lawyers and Accountants, Corporate Property Managers, Property Fund Management Staff, Property Analysts and Developers, Real Estate Investors, Insurance Professionals, Leasing Executives, Securitization Executives etc.


The Advanced Certificate in Financial Modeling will enable you to carve a niche for yourself in finance. It is widely used in investment banking, corporate banking, risk departments, etc. There is a wide range of opportunities and roles available after the completion of this course.

  • Financial Analyst
  • Financial Manager
  • Business Analyst
The average salary of a Financial Modelling professional is shown below:


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


Extensive Classroom Training

2.5 Months. 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.


70 hours of webinar recording covering all the course topics.

Comprehensive study notes

Topic wise study material is provided in the form of presentations

Case Study

Appreciate the concepts by working on case studies derived from real-life situations.


EduPristine provide Certification of Participation for Advanced Certificate in Financial Modeling course along with the Certificate of Excellence in collaboration with BSE Institute.

24*7 online access to study material

Unlocked excel models and presentations which you can access 24*7 hours.

Doubt Solving By Experts

We are having a forum where you can post your doubts and queries which will be resolved within 2 working days by experts.

ACFM Course batch dates and Duration

City Date Address Phone
(Toll Free)
ACFM Training in Delhi 18th Dec EduPristine, #44,2nd Floor Regal Complex Outer Circle Connaught Place 18002005835
ACFM course Highlights
Fulltime Weekday Classroom Training
price 65,000/
2.5 Months Classroom Training
Best Corporate combination- Blend your Theoretical Finance Knowledge with Practical Skills
Excel Based Learning
Day wise Topic Access Materials & Downloadable Financial Models
Learn with Real Life Examples: Experience the Real Life Industry Analysis & Business Modeling
Industry Approved Syllabus: Includes advanced concepts like private equity, project finance, derivative valuations , IPO modeling and preparing research reports
Certifications: Advanced Certificate in Financial Modeling from EduPristine
Study Notes: Downloadable Complete Course Material
Domain Specific MS Excel Workbook and Practice
Certificate of Participation / Excellcence
24 * 7 Access to Online Materials
Discussion Forum


The training was very insightful, it was well delivered and the trainer had a strong background in finance. Am now more efficient in what I do and I enjoy excel more.

The Training manual should be more elaborate. Training subject and content is excellent. The Trainer was good.

related links

For Corporate Enquiries

Popular Courses

GARP does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine of GARP Exam related information, nor does it endorse any pass rates that may be claimed by the Exam Prep 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. ERP®, 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® Program, CFA® Institute Investment Foundations 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.

dm_classroom_courses_offering.php Post ID = 84923