FINANCIAL MODELLING

INTRODUCTION

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.

ABOUT FINANCIAL MODELING

Financial Modeling is one 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.

WHAT WILL I LEARN ?

At the end of the course you will learn how to construct an integrated financial model from scratch. You will soon be building models that are robust, and provide you with dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.

TARGET AUDIENCE

This program is suitable for people in Investment banking, Project management, Equity research, Business planning & strategy, Private equity funds or commercial banking. It is also ideal for CA, CFA Program, FRM, MBA Finance, B .TECH and Commerce Graduates who want a career in any of the above profiles.

BENEFITS

Financial Models constructed in Financial Modeling help in decision making and business modeling for firms and check the viability of projects. You learn techniques 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.

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 edge over others.

PRE-REQUISITES

Student should have hands on experience on Excel and brief idea about Finance, Balance Sheets and Cash Flow Models.

OUTLINES

1. Financial Modeling Principles : Excel as a tool for financial modeling 
   Building financial models best practices
   Modeling growth drivers, depreciation, cost drivers, asset & debt schedules
2. Valuation Principles :  Projecting cash flow statement
   Circular references and handling them
   Financial ratio analysis
   Valuation using DCF & Comps
3. Financial Modeling Principles : Excel as a tool for financial modeling 
   Building financial models best practices
   Modeling growth drivers, depreciation, cost drivers, asset & debt schedules
4. Valuation Principles : Projecting cash flow statement
   Circular references and handling them
   Financial ratio analysis
   Valuation using DCF & Comps
   Scenario analysis and Building valuation dashboards 
   Q & A
5. Advanced Functions, Tools & Charting : Techniques 
   Advanced Tools in Excel for Auditing Financial Models 
   Mastering Financial Functions 
   Advanced Charting Techniques in Excel 
6. Using Macros & VBA for Financial Modeling : Understanding Macros & VBA for Financial Modeling 
   Implementing Monte Carlo Simulation
   Advanced Charting Techniques in Excel
   Q & A
   Commodities
   Foreign Exchange & Corporate Bonds

INSTRUCTOR

Dr. Hanifah SE.,Ak.,Msi, CA & Team / Drs. Arif Budiarto , M.Si, Akuntan & Team