Certybox offers a comprehensive and yet affordable program in finance modelling. the program has an employment-oriented approach and is based on a detailed research of companies’ requirements. It prepares students for roles like audit, finance analyst, managers and many more is available in online and offline modes.

About the Course

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.

Who can opt this Program?

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.

DELIVERABLES

Financial modelling online course is a flexible course that helps you to prepare for the exam at your own pace. This course is designed for self-directed learning, allowing participants to begin classes at their convenience with structured training and review exercises to reinforce learning, followed by an end-of-course examination.

  • Financial Modelling – Online Training
  • Study Notes
  • Download the study notes to supplement video tutorials.
  • 24×7 Online Access
  • Access to Course Material
  • Case Study
  • Hands-on Case Study (Real Life) based learning

Course Curriculum

Excel Tips
Understanding And Creating A Financial Model Template 00:00:00
Learning referencing (usage of $)Frame work in Excel 00:00:00
Learning Custom formatting in Excel 00:00:00
Excel Skills – Shortcuts, Formulas, Array Function and Pivot Tables 00:00:00
Implementing simple business modeling case in Excel 00:00:00
Simple exercise/models in excel 00:00:00
Case Study FMCG
Case Study FMCG 00:00:00
Data Collection and Data Structuring 00:00:00
Preliminary Scrutiny of the Data and Information 00:00:00
Understanding the Business Profile of the Company 00:00:00
Modeling the Historical Statement 00:00:00
Business Drivers Identification and Modeling 00:00:00
Modeling Assumptions for Future Action 00:00:00
Modeling Revenue Build-up – projecting the future revenues 00:00:00
Modeling Cost Build-up – projecting the future cost 00:00:00
Modeling the Asset Schedule 00:00:00
Modeling the Depreciation Schedule – Book and Income Tax Depreciation 00:00:00
Working Capital & Term Loan Modeling – Debt Infusion Tax Modeling 00:00:00
Modeling MAT and MAT credit 00:00:00
Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payble 00:00:00
Equity Modeling – Equity Infusion 00:00:00
Modeling Paid Up Capital and Share Premium Account 00:00:00
Modeling Retained Earning Schedule 00:00:00
Modeling the projected Cash Flow Statement 00:00:00
Modeling the projected P/L and BS 00:00:00
Modeling the projected Cash Flow Statement 00:00:00
Conducting Covenant Testing 00:00:00
Performing Ratio Analysis 00:00:00
WACC and Cost of Equity Analysis 00:00:00
Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation) 00:00:00
Performing sensitivity/scenario analysis 00:00:00
Project Finance
Introduction to Project Finance 00:00:00
Understanding the Project Finance Model 00:00:00
Characteristics of Project Finance 00:00:00
Risk and contractual arrangement to Mitigate Risk 00:00:00
Understanding the Escrow Arrangement 00:00:00
Incorporating Date, logical functions and flags to make the Model Flexible Incorporating Delays in the Model 00:00:00
Cash Flow Waterfall model – Modeling Payoffs to Investors using Goal Seek 00:00:00
Implementing Interest During Construction and Breaking Circular Loops 00:00:00
M &A I & II
Meaning and categories of M&A 00:00:00
Forms of payment in a Merger Deal 00:00:00
Hostile Vs Friendly offer 00:00:00
Evaluating a Merger Bid 00:00:00
Merger Analysis – Key Drivers and Inputs 00:00:00
Accretion/Dilution Analysis 00:00:00
Merger Plan – Ownership Vs Deal Price 00:00:00
Modeling a financing plan 00:00:00
Performing sensitivity analysis on Acquirer’s EPS 00:00:00
Performing Contribution Analysis 00:00:00
Estimating value of a Merger Transaction 00:00:00
Discounted Cashflow Analysis 00:00:00
Comparable Company Analysis 00:00:00
Comparable Transaction Analysis 00:00:00
Case Study
Data Collection from Public Sources 00:00:00
Understanding the Business Profile of the Company 00:00:00
Modeling Revenue & Expenses Drivers 00:00:00
Modeling Income Statement 00:00:00
Modeling Implied EBITDA 00:00:00
Balance Sheet Projections 00:00:00
Cash Flow Statement Projection 00:00:00
Performing Valuation And Sensitivity Analysis 00:00:00
Calculating Enterprise value and Implied Market capitalization 00:00:00
Macros I
Macros I 00:00:00
Introduction to Macros & Advanced Application Building in Excel 00:00:00
Key Concepts in Macros 00:00:00
Macros as recorded Robots! 00:00:00
Form Controls and Active X controls 00:00:00
Implementing user forms in Excel Macros 00:00:00
Linking forms to excel cells 00:00:00
Building flexible Charts in Excel 00:00:00
Macros II
Macros II 00:00:00
Understanding VBA – Sub & Functions 00:00:00
Understanding the Relevant Language Constructs 00:00:00
IDC Implementation using Macros 00:00:00
Breaking Circular Loops using Macro 00:00:00
Monte Carlo Simulation 00:00:00
Basics of Debugging VBA Code 00:00:00
Charting
Charting 00:00:00
Building Primary & Secondary Axis in a Chart 00:00:00
Radar Charts – Showing the progress of Commercial Property Development 00:00:00
Waterfall Charts – Showing Funding Breakup for Renewable Energy project 00:00:00
Football Field – Showing Valuation Summary using Different Parameters 00:00:00
Gantt Chart – Tracking the status of an Ongoing Project 00:00:00
Advance Function
Advance Function 00:00:00
Named Ranges 00:00:00
Index Match 00:00:00
Array Functions 00:00:00
Building Scenarios using Offset Functions 00:00:00
Creating growing models & Index functions 00:00:00
Usage of Indirect Functions 00:00:00
Usage of Goal Seek and Solver Functions 00:00:00

Course Reviews

5

5
1 ratings
  • 5 stars1
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. 5

    I must appreciate the whole team of Certybox to launch such a good course on Financial Modelling, as this is the need of the day where more and more complex business scenarios needs to be modelled in MS excel for better decision making.

TAKE THIS COURSE
  • FREE
  • 180 Days
124 STUDENTS ENROLLED

Get a Free Consultation

Related Courses

Copyright © 2019 Certybox All Rights Reserved