Course Details

Financial Modeling Training Programme has the below stated areas and more in our curriculum:

Basic Excel Skills –Formulas, Shortcuts, Date functions, logical functions

Learning referencing (usage of $) frame work in Excel

Incorporating Date, logical functions ,

Pivot Table & Reports

Understanding VBA - Sub & Functions

Understanding the Relevant Language Constructs

Macros

Breaking Circular Loops using Macro

Basics of Debugging VBA Code

Automation Reporting

Module -  3 - WORKSHOP

Simple exercise/model in excel 

Flags to make the Model Flexible

Understanding Business Model And Creating a Financial Model Template

Identification of Business Drivers and Modeling

Implementing simple business modeling case in Excel\

Project cost and its typical components

Modeling Assumptions for Future projections

Capital Expenditure phasing and modeling

Infusion of debt and equity

Modeling financial projections

Implementing Interest During Construction 

Creating macros and Breaking Circular Loops

Term Loan Modeling - Debt schedule – Monthly, Quarterly and annual schedules

Modeling the Depreciation Schedule – Book and Income Tax Depreciation

Modeling Working Capital

Tax Modeling 

Adjusting accumulated losses

Modeling MAT and MAT credit

Modeling Dividend / Retained Earning Schedule

Custom formatting for checks and balances

Module - 5 WORKSHOP

Creating and Modeling financial statements from the various schedules 

P&L

Cash flow statement

Balance Sheet

Performing sensitivity/scenario analysis

Performing Ratio Analysis