|FTS Eligible - Financial Training Scheme for Singaporean citizens and PRs only (more information)
This course will review lessons on valuation, risk assessment and forecasting that can be derived from the financial crisis. Participants will discuss mistakes made in valuing sub-prime loans and other famous valuation errors. This provides context for other subjects in the course.
Summary of course content
- Valuation lessons from the current financial crisis
- How structured financial models can be created that clearly define risks and value without being overly complex
- The fundamental factors that underlie valuation and how can they be used in practice
- What lies behind multiples such as the P/E and the EV/EBITDA ratios and how these multiples can be used in valuation
- How to effectively present risk analysis in valuation analysis models
- Whether Monte Carlo simulation and mathematical techniques can realistically be used to assess risk and compute value
- The valuation of debt and measurement of debt capacity to provide alternative ways to value investments
- The creation of models specifically used to evaluate LBOs, project finance and M&A
Case studies, hands-on analysis and template models will be used as the primary teaching tools in the programme. If you are interested in practical mechanics of excel (macros, combo boxes, offset and indirect functions etc.) these can also be discussed after the course.
Other than the instruction in how to build, use and analyse financial models, you will receive a comprehensive suite of financial modeling software on CD that includes a number of template models and Excel add-ins.
The software consists of corporate models that accept historic financial data and generate alternative valuation measures; M&A models that consolidate two companies using alternative financing assumptions and produce accretion and dilution estimates; project finance models that measure the effect of alternative elements in a cash flow waterfall including debt service reserves, junior debt, covenants, defaults and pre-payments; LBO models that measure the debt capacity of a transaction; option pricing models that account for alternative structures; and debt valuation spreadsheets, Monte Carlo simulation models, tornado diagram and sensitivity analysis.
This course will make extensive use of modelling exercises in Excel®
All delegates should bring their own laptops loaded with Microsoft Excel® 2010 or later to facilitate inclass
studies and exercises.
Free CD to take-away
Delegates will receive a comprehensive suite of financial modelling software on a CD that includes a number of template models and excel add-ins.
Book early and fill in our pre-course survey to ensure your specific needs are met in the course by the trainer.
This programme is approved for listing on the Financial Training Scheme (FTS) Programme Directory and is eligible for FTS claims subject to all eligibility criteria being met.
Please note that in no way does this represent an endorsement of the quality of the training provider and programme. Participants are advised to assess the suitability of the programme and its relevance to participants’ business activities or job roles.
The FTS is available to eligible entities, at a 50% funding level of programme fees, subject to a cap of $2,000/participant/programme and all eligibility criteria being met. FTS claims may only be made for programmes listed on the FTS Programme Directory with specified validity period. Please refer to www.ibf.org.sg for more information.