Advanced Financial Analysis and Modelling in Excel
Kuala Lumpur, Malaysia
The “Advanced Valuation and Modelling in Excel” course reviews lessons on valuation, risk assessment and forecasting learned from the financial crisis. Mistakes made in valuing sub-prime loans compared to other famous valuation errors are examined and a review of valuation lessons 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 to clearly define risks and value without being overly complex
The fundamental factors that underlie valuation and how they can 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
The course will be of value to professionals in the following areas:
Corporate Finance
Corporate Treasury
Capital Markets
Audit and Product Control
Risk Management and ALM
Research and Analysis
Sales and Trading
Investment Management
Origination
Securitisation and Syndication
Structured Finance
Money Markets and Repo
Systems Programming
Funding
Government and Agency Funding and Investment
Regulation and Compliance and Documentation
For more information on this training course please email training@euromoneyasia.com or call +852 2520 1481
Attendance cost: €5747.50
Event organizer: Euromoney Plc