| Start Date | End Date | Country | City |
|---|
+966 920007771
 |
 |
Objectives
The principal aim of the course is enable participants to use Microsoft Excel to prepare logical and easy-to-use financial models to support transactions, forecasts and planning for ongoing business streams. These skills can also be used to support credit approvals and reviews by lenders and to support the organization to run or sponsor projects. The course will review best practice in model structures and logic, and using tools to highlight areas of risk, particularly in sensitivity analysis.
Outlines
- Best practice in structuring models
- Building models using best practice Excel techniques
- Building inflation into the model
- Modeling taxes
- Creating cash flow waterfalls
- Using the model for analysis, including banking ratios and valuations
- Sensitivity analysis tools
- Advanced Excel functions
Who Should Attend
- Financial analysts
- Finance managers
- Bank economists
- Relationship managers
- Corporate accountants
- Credit analysts
- Financial controllers
- Budget and forecasting controllers
- Deal structuring analysts
- M&A specialists
- Financial planning and analysis managers
Duration
5 Days
