Advanced Credit Analysis & Financial Modelling

Course overview During the financial crisis, many banks and other financial institutions lost billions of dollars due to their failure to analyse credit risks correctly. Even when financial institutions do not suffer direct financial losses due to default or market movements, they may be receiving an inadequate return for the risks involved. With leveraged instruments set to remain a standard part of corporate capital structures, in both the private and public equity markets, knowing how to analyse credit risk remains key to avoiding losses and to maximising returns. Summary of course content Advanced financial analysis, including calculating key credit ratios for complex credit Advanced financial modelling in Excel® Assessing refinancing risk Credit enhancement methods; securitisation, security, netting, SPVs etc Creating cashflow ring-fencing structures Credit linked notes Parent and subsidiary rating linkage Sovereign risk techniques Sovereign debt techniques Corporate valuation for acquisition finance and distressed situations Deteriorating credits, potential and actual NPLs: warning signs and strategies for minimising losses Methodology This programme combines theory with frequent use of exercises and case studies. These are based on real situations and are designed to help you implement new practices and to learn from empirical experience. This course is practical and interactive, encouraging you to ask questions. The techniques taught are intended to be of immediate practical use in the workplace. Computer-based exercises All delegates should bring their laptops to facilitate in-class studies and exercises and should have a basic level understanding of Excel. Who should attend this training course? Bank Credit Officers Investment Bankers Bond Credit Analysts Fixed Income/Credit Traders Fixed Income/Credit Sales Personnel Fund Managers Treasurers Compliance Officers Management Consultants Financial decision makers in corporations FTS-Eligible 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 all eligibility criteria being met. FTS claims may only be made for programmes listed on the FTS Programme Directory with the specified validity period. Please refer to www.ibf.org.sg for more information. Please note that this course is only eligible for FTS Funding when registering for all modules.
Day 1 Advanced financial analysis, including calculating key credit ratios Adjusting for exceptionals, non-core items, derivatives, etc. Key accounting factors – revenue recognition, expense allocation, derivatives Calculating net debt – adjusting for quasi debt, cash collateral Adjusting for off-balance sheet items and entities Focus on operating cashflow not earnings Case studies: High yield and complex high grade accounts Advanced financial modelling in Excel Modelling amend and extend facilities Modelling for a new capital structure, e.g. following new shareholder value policies, acquisitions, leveraged buyouts, deleveraging Day 2 Advanced financial modelling in Excel (continued) Modelling new loan features, e.g. PIK toggles, amortisations, cash sweep, equity kickers Assessing refinancing risk Impact of Basel III and bank funding constraints The CLO markets Other factors increasing refinancing risk The importance of forecasting the credit profile at loan maturity Day 3 Credit enhancement methods Securitisation Typical structure and participants Creating cashflow ring-fencing measures Rating considerations Security and netting Type of security Offsetting of multiple credit exposures Credit linked notes Case study: Analysis of BAA's major ring-fencing mechanism to give lenders additional protection Parent and subsidiary rating linkage Credit assessment of: Non-recourse projects e.g. associates and joint-ventures Non-guaranteed subsidiaries Captive finance subsidiaries Fitch criteria for associates, j/vs, subsidiaries S&P criteria for associates, j/vs, subsidiaries, captive finance subs Sovereign risk – importance to corporates; key market and rating criteria Case studies: Covering the current most risky sovereign situations and the impact of recent ECB initiatives Sovereign debt Sovereign composite issuance Sovereign guaranteed debt Sovereign partially-guaranteed debt Day 4 Corporate valuation for acquisition finance and distressed situations Including PE ratios, EBITDA multiples and DCF Case studies: To practice equity valuation and to cover the importance of equity valuations to lenders Deteriorating credits, potential and actual NPLs: Warning signs and strategies for minimising loss Case studies: Analysis of distressed credits that recovered and of those that went bankrupt