Advanced Financial Modeling

Day 1

• Advanced excel tools and functions useful in financial modeling (Offset, Index & Match, Developer tools, scenario manager, solver, etc.)
• Creating different types of flexible models which can incorporate detailed scenario analysis using switches – Choosing the right one that suits your subject company
• Consolidating monthly forecasts to quarterly and quarterly to annual
• Introducing Timing Flags:
• Using timing flags for creating flexible debt repayment schedules
• Using timing flags for creating flexible project feasibility analysis schedules

Day 2

• Flexible debt modelling incorporating revolver, cash sweep and different tranches of debt
• Financial model auditing tools – Decode and understand any existing financial model
• Finding and removing circular referencing problem
• F5- special auditing tools
• Understand which of the multiple sell side models is best for the subject company

• Analyzing large volume stock price or fund performance data and calculating flexible performing metrics (Standard deviation, downside deviation, Sharpe ratio, Sortino ratio, Maximum Drawdown, etc.)
• Recording and Editing macro using basic VBA tools
• Exchanging information with VB code
• Displaying a Message box
• Creating a module and sub
• Using names in a VBA code
• Formatting cells or ranges using VBA codes
• Performing basic mathematical operations using VBA codes

• Dynamic dashboards and charting to present financial models
• Using excel’ Camera tool
• LCreating flexible charts using dynamic tiles and data labels
• Advanced chart types: Cash flow waterfall, football field chart, etc.