Financial Modeling

Program Objective

Excel Modeling techniques are used in many different areas, such as credit analysis, investment appraisal, risk management, valuation, financial analysis and forecasting. This 6 days computer based practical training course intends to address the most pressing requirement of the industry: financial modeling through MS-Excel The programs shall aim to provide the participants with

• Understanding and creating a financial model template
• Excel Skills – Shortcuts, Formulas and cross referencing
• Historical financial statement modeling (P&L and B/S)
• Calculating growth drivers in a financial model
• Building the asset and depreciation schedule
• Building debt & interest schedule
• Building cash flow statement while financial modeling
• Building interest on excess cash and cash revolver
• Creating the final Financial model and Building ratios for analysis
• Updating integrated model for valuation using DCF and Comps
• Sensitivity/ Scenario Analysis
• Creating foot-ball field for valuation analysis
• Modeling other Accounting concepts - Revenue Recognition, Deferred tax etc
• Project Finance Modeling covering Infrastructure sector
• Merger & Acquisitions Analysis
• Knowledge of advance excel tools for improved excel efficiency