Financial Analyst Modeling Training using MS Excel
Course Structure:-
Module – 1
- Basic Excel Skills –Formulas, Shortcuts, Date functions, logical functions
- Learning referencing (usage of $) frame work in Excel
- Incorporating Date, logical functions ,
- Pivot Table & Reports
Module – 2
- 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
Module – 4
- 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
Module – 6
- Performing sensitivity/scenario analysis
- Performing Ratio Analysis
- Conducting Covenant Testing
- Assessment of debt serviceability – DSCR
- Calculating Returns
- Project IRR
- Equity IRR
- Performing Valuation using DCF (FCFF and Enterprise Value)
Module – 7
- Understanding the Project Finance Mode
- Characteristics of Project Finance
- Risk and contractual arrangement to Mitigate Risk
- Understanding the Escrow Arrangement
- Cash Flow Waterfall model
- Basics of Public Private Partnership (PPP) framework
Module – 8 WORKSHOP
- Creating a financial model from scratch
- Making modeling assumptions
- Modeling all schedules
- Creating all financial statements
- Calculating viability & returns