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

Classroom Training in Bangalore

Financial Modeling Prep

CFA Melbourne
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.
Topics Covered
  • Day 1
    • Understanding And Creatting A Financial Model Template
    • Learnig referencing (usage of $)Frame work in Excel
    • Learning Custom formatting in Excel
    • Excel Skils - Shortcuts, Formulas, Array Function and Pivot Tables
    • Implementing simple business modeling case in Excel
    • Simple exercise/models in excel
  • Day 2, 3, 4 & 5
    • Data Collection and Data Structuring
    • Preliminary Scrutiny of the Data and Information
    • Understand the Business Model and Operating Model
    • Modeling the Historical Statement
    • Business Drivers Identification and Modeling
    • Modeling Assumptions for Future Action
    • Modeling Revenue Build-up - projecting the future revenues
    • Modeling Cost Build-up - projecting the future cost
    • Modeling the Asset Schedule
    • Modeling the Depreciation Schedule - Book and Income Tax Depreciation
    • Working Capital & Term Loan Modeling - Debt Infusion
    • Tax Modeling
    • Modeling MAT and MAT credit
    • Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payble
    • Equity Modeling - Equity Infusion
    • Modeling Paid Up Capital and Share Premium Account
    • Modeling Retained Earning Schedule
    • Modeling the projected P/L and BS
    • Modeling the projected Cash Flow Statement
    • Conducting Covenant Testing
    • Performing Ratio Analysis
    • WACC and Cost of Equity Analysis
    • Performoing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation)
    • Performoing sensitivity/scenario analysis
  • Day 6
    • Understanding the Project Finance Model
    • Characteristics of Project Finance
    • Risk and contractual arrangement to Mitigate Risk
    • Understanding the Escrow Arrangement
    • Incorporating Date, logical functions and flags to make the Model Flexible
    • Incorporating Delays in the Model
    • Cash Flow Waterfall model - Modeling Payoffs to Investors using Goal Seek
    • Implementing Interest During Construction and Breaking Circular Loops
  • Day 7 & 8
    • Meaning and categories of M&A
    • Merger motivations
    • Forms of payment in a Merger Deal
    • Hostile Vs Friendly offer
    • Evaluating a Merger Bid
    • Merger Analysis - Key Drivers and Inputs
    • Synery and Accretion/Dilution Analysis
    • Merger Plan - Ownership Vs Deal Price
    • Modeling a financing plan
    • Performing sensitivity analysis on Acquirer's EPS
    • Performing Contribution Analysis
    • Estimating value of a Merger Transaction
    • Discounted Cashflow Analysis
    • Comparable Company Analysis
    • Comparable Transaction Analysis
  • Day 9 & 10
    • Data Collection from Public Sources
    • Understanding the Business Profile of the Company
    • Modeling Revenue & Expenses Drivers
    • Modeling Income Statement
    • Modeling Implied EBITDA
    • Balance Sheet Projections
    • Cash Flow Statement Projection
    • Performing Valuation And Sensitivity Analysis
    • Calculating Enterprise value and Implied Market capitalization
  • Day 11
    • Introduction to Macros & Advanced Application Building in Excel
    • Key Concepts in Macros
    • Macros as recorded Robots!
    • Form Contrls and Active X controls
    • Implementing user forms in Excel Macros
    • Linking forms to excel cells
    • Building flexible Charts in Excel
  • Day 12
    • Understanding VBA - Sub & Functions
    • Understanding the Relevant Language Constructs
    • IDC Implementation using Macros
    • Breaking Circular Loops using Macro
    • Monte Carlo Simulation
    • Basics of Debugging VBA Code
  • Day 13
    • Building Primary & Secondary Axis in a Chart
    • Radar Charts - Showing the progress of Commercial Property Development
    • Waterfall Charts - Showing Funding Breakup for Renewable Energy project
    • Football Field - Showing Valuation Summary using Different Parameters
    • Gantt Chart - Tracking the status of an Ongoing Project
  • Day 14
    • Named Ranges
    • Index Match
    • Array Functions
    • Building Scenarios using Offset Functions
    • Creating growing models & Index functions
    • Usage of Indirect Functions
    • Usage of Goal Seek and Solver Functions
Sample Preview of our material
LinkedIn , Groupon Models et al.
Course Highlights
Extensive Classroom Training
14 days (70 hrs) Comprehensive Training
Live Webinar
14 days Online Lectures with Recordings for all the topics.
Comprehensive study notes
You can browse through these notes while viewing the videos as per your convenience.
EduPristine & BSE brings Financial Modeling Certification Program
24x7 Online Access
Online Access to Course Material (Unlocked Excel Models, Presentations, etc.)
Case Study
Hands-on Case Study (Real Life) based learning
(Toll Free)
Bangalore Varada Hubscopes A R COMPLEX, #18/9, 100 Feet road, BTM Layout 1st stage, Gurappanapalya, Opp. Reliance Fresh, Above Pineapple Saloon and Spa, Next to HDFC Bank, Banglaore -560068 18002005835
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.
Who is the target audience?

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 = 12736