Course provider

A financial training course from Financial Training Associates Ltd. Financial Training Associates supplies experienced finance trainers to companies who wish to provide financial markets training for small groups of their employees. See www.financialtrainingassociates.com for more info.

Introduction

• This course provides the opportunity for delegates to practise and improve their ability to model leveraged businesses using Excel. The course is conducted in a work shop format, with the emphasis on “learning by doing”.

• On this course delegates imagine working with a business that is contemplating taking on extra debt as part of an acquisition. Participants start with a blank spreadsheet and create a detailed cash flow model from scratch, just like they might have to when modelling in their own workplace. Delegates are guided through a complete model build up and are shown all the steps they need to take. All through the course plenty of guidance and assistance is given by the course instructor.

• As part of their work on the course delegates create a full set of forecast financial statements for the business. Delegates can then consider the impact of a leveraged acquisition undertaken by the business. They can then analyse how the business performs under stress and how key financial ratios and bank covenant tests respond with a change in circumstances.

Detailed modelling work: as part of their work on this course delegates “build up” an integrated financial statement model for a business that has taken on debt as part of a recent transaction

• At the end of the course participants will have a record of their own work and a permanent record of the steps they have taken to create their own leveraged finance model. By the end of the course participants will understand:

o Key concepts in acquisition finance

o How acquisitions are structured

o The detailed functioning of levered deals

o The impact of using different debt and equity instruments

o How to analyse leveraged acquisitions and buy outs

o The essential principles involved in modelling levered structures.

• The time on the course is designed to provide participants with the tools they need to continue with their own efforts to model leveraged buyouts or acquisitions as they return to their workplace.

Delegates are requested to bring a laptop with active USB port to this seminar

Day one

Session 1: planning assumptions

• Obtaining source data

• Coding inputs

• Structuring assumptions and anticipating scenario analysis

• Modelling and formatting best practice

• Good model structure

• Good model design

Modelling: delegates are introduced to a case study and a set of financial statements. Participants use that to start creating their own model.

Session 2: starting to forecast the income statement

• Starting to forecast the P&L from key assumptions

• How far can we progress?

• What’s stopping us from continuing?

• Key drivers for modelling

• Key ratios driving the forecast

o Drivers on revenues

o Drivers on costs

o Sources of data

Modelling: delegates add to their model and forecast out the income statement as far as pre-tax earnings

Session 3: modelling fixed assets

• Forecasting assets

• Key drivers on asset intensity

o Capital expenditure

o Depreciation

• Forecasting depreciation

Modelling: delegates analyse and forecast fixed assets, depreciation and capital expenditure

Session 4: completing the balance sheet

• Key drivers for balance sheet items

o Which creditors can we stretch, and by how much?

o How quickly can we collect debtors?

• Forecasting the balance sheet

• Impacts on cash flow

o Is growth good?

• Linking to other statements

• Balancing the balance sheet

Modelling: delegates use their model to forecast a balance sheet for the case study

Day two

Session 5: modelling debt

• Forecasting a simple debt schedule

• Linking to other statements

• Tools for resolving circularity

o Setting debt paydown

o Iterating

• Forecasting a more complex debt structure

• Modelling a debt waterfall

o Using “max”, “min” and “if” functions to model a debt waterfall

Modelling: delegates forecast a debt pay-down schedule for their case study

Session 6: cash flow

• Modelling the cash flow statement

• Key linkages to other statements

• Presenting the cash flow statement

• Forecasting cash flow to equity

• Forecasting unlevered cash flow

• The link to valuation

Modelling: using their model, delegates forecast levered and unlevered free cash flow

Session 7: defining key outputs

• What are the most important outputs?

• How can they be presented clearly?

• How can we put for example, anticipated sales, capital expenditure and working capital plans into context?

Modelling: delegates complete a new sheet within their model - something that contains key outputs and credit statistics and is quickly and easily readable

Session 8: scenario analysis

• What scenarios make the most sense?

• What inputs should we be flexing?

• How can we structure the model to run those scenarios easily?

• What happens to our outputs as the business is stressed?

• How can we best present the information?

Modelling: delegates develop a suite of scenarios for their model, setting the model up so that it contains a full record of scenarios and the user can switch very quickly between them

Day three

Session 9 – structuring a deal – sources & uses of funds

• Introduction to the fundamental principles of deal structuring

• Exploring “sources & uses” - a key learning concept for the course

o Developing a “first cut” debt structure

o Calculating refinancing needs

o The role of working capital and extra cap ex requirements

o Typical financing and transaction fees

o Determining the equity gap

o The impact of equity rollover

• Concentrating on the key levers without getting bogged down in complex models

Case study: delegates develop their own deal structure for a transaction conducted by the case business

• The impact on the model: calculating goodwill and the pro-forma balance sheet

Session 10: the link to valuation

• Absolute vs. relative valuation techniques

• Defining and refining firm value: enterprise vs. equity value

• What is debt free cash free? What’s the link to deal structure?

• Relative valuation – typical valuation metrics

o Which multiples should we use?

o What are the pros and cons of different multiples?

Exercise: Relative valuation of a bid target

Session 11: determining debt capacity and structuring debt

• Clear, simple and concise explanation of different debt instruments:

o Senior debt

o High-yield debt

o Mezzanine

o Payment-in-Kind

• Understanding the nature of different financial instruments and risk profiles

• Modelling waterfall structures

• Estimating and optimising debt capacity

Modelling – debt structure: delegates develop a debt structure for the case study and start to flex the structure within given constraints. How much debt could the business support? How big a target could it contemplate acquiring? What impact does changing the debt structure have on debt capacity?

• Key considerations for debt holders - keeping finance providers happy

o Typical covenant tests

o Conditions of default

o Covenant trends

o Trends across different businesses

o Typical tests employed by rating agencies

Exercise: - delegates consider how S&P would rate debt in a real business

Session 12 – structuring equity

• The nature of equity instruments used in buy out structures

o The different risks and rewards accruing to different parties

o Incentivising management

o Key drivers for equity investors

• The impact of loan stock & preference shares

• The impact of mezzanine

• Iterating to optimise rewards to key participants

Case study: delegates iterate with a “back of the envelope” deal structure to optimise returns