A two-day hands-on workshop for developing constructing an advanced risk-based financial model.
Analysts and other using Excel today are required to use Excel to review, construct, specify or design complex financial models. Modern financial analysis demands models that are flexible and can deal efficiently with downside risk and sensitivity.
Delegates receive a full pack of Excel software and templates for future reference as part of the course materials
Each participant will be required to bring a laptop running Microsoft Office with CD-Rom to the seminar.
Exercise: reworking existing skeleton model
Example: testing a financial analysis model
Exercise: debugging and checking an existing financial model
Exercise: developing forecast free cash flow and ratios
Exercise: producing a forecast with time series analysis
Exercise: adding sensitivity to the case model
Example: quantifying risk in the case model
Example: using simulation in the case model
Example: targeting and optimisation
Exercise: producing a management report
|Training Course||Training Course Summary|
|Advanced Equity Derivatives||This programme has been designed to provide a thorough overview of equity derivatives products, pricing, risk management and applications. We will use real life case study examples to illustrate the techniques and strategies that are used by both “buy side” and “sell side”.|
|Advanced Credit Derivatives||Advanced Credit Derivatives have attracted strong interest from the investment and banking community over the past 20 years and has been used extensively by banks, mutual and hedge funds, as well as by individual investors.|