ACFM Course

ACFM Course

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.

4834 Reviews

About COURSE

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. Read more

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

  • Classroom Training

    The program is conducted on Weekdays & Weekend. Duration: 32 hrs.

  • Industry Endorsed Curriculum

    Course contents vetted by leading companies - employability ready skills to work from day one

  • Our Faculty

    At EduPristine, we invite industry professionals to conduct training. Provided by Chartered Accountants with relevant experience (Topic Expert Model)

  • Additional Features

    Complimentary material access on Advance Excel - Online
    Complimentary material access on GST E-book - Online

  • 24 X 7 Online Support

    24x7 Online Access* to Course Material (Presentations, Recordings, Practice Files, Utility Files, etc.)

Course Structure

  • 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
  • Track the Project Progress : Creating Gantt Chart
  • Equity Valuation: Application & Process
  • 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
  • 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 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
  • 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 Situatio
  • 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
For corporate enquiries contactcorporate@edupristine.com

Schedule WHEN

Need more info?

Just drop in your details and our support team will reach out to you as soon as possible.

Benefits WHY?

  • 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

Average Salary for Course Experts

The average Investment banking salary is 9,02,800.

Reviews WHAT OTHERS SAY

EduPristine is a great place to start your finance career. It has a good faculty and after completing your course they also provide great placement assistance.I sincerely thanks EduPristine for this and looking forward for continuing my relations with them.

Deepesh Jain

Who should do this? TARGET

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.

`````````````````````````````````````````````````` courses.php Post ID = 97248