Available courses
- Facilitator: Mark Woolhouse

- Facilitator: Mark Woolhouse

- Facilitator: Greg Mayes

- Facilitator: Greg Mayes

- Facilitator: Greg Mayes

This programme will train you how to build robust forecast models for companies. We recommend (and provide as part of this programme) our Excel skills module. You should have basic competency in Excel and accounting to get maximum benefit from this programme.
You will progressively build an integrated balance sheet, profit and loss, and cash flow forecasting model. We will also build a discounted cash flow valuation and sensitivities to make it useful as a credit analysis, debt structuring and capital structure optimisation tool. The model is of Unilever and gives an interesting insight into the drivers behind the Kraft-Heinz bid and how the market valuation has closely tracked the DCF valuation implied from Management’s guidance to equity researchers.
The key to our technique of integrated model building is “Building in Balance”: using the basic principles of double entry book-keeping and carefully choosing the order in which we build and integrate we ensure that our forecasts balance from the beginning and stay in balance as we go. “Building in Balance” also gives us some simple troubleshooting tools to “shake-out” errors as soon as they arise, leading to a robust, error-free model straight out of the box.
The training will develop your Excel skills and show you how to reliably quickly and accurately build rigorous, flexible financial models. You’ll understand the flow and logic of typical forecasting models and you’ll be able to get more out of the peer/third party models you use.
- facilitator: Mark Woolhouse
This programme will teach you step-by-step how to build a leveraged buyout model. This is exactly the kind of model you might use as an investment banking analyst to “trawl” for deal opportunities and prepare a pitchbook. The crucial word here is Leveraged and a key element of the programme is to introduce you to the typical debt instruments used, the different roles they play in leveraged financing schemes and how the market has changed. The bottom line here is that the leveraged financing market in Europe grows more and more like the US market in terms of the depth of liquidity available, the range of investors, and the aggressiveness of financing terms. We’ll give you some background into the development of the market and how the arrival of new investors, such as Hedge Funds and CLOs pre-crunch, and more recently insurance companies and other institutions to the B loan market, have changed the funding landscape.
The model we’ll build is highly flexible, so it will allow you to model “old-school” A,B loan and mezzanine structures, unitranche financings and mixed loan and high yield bond schemes.
The model will produce all of the main return metrics that P/E investors use and the standard credit risk metrics that potential debt investors will use. We will also produce a value bridge – disaggregating returns into their various drivers: sales growth, operating margin expansion, debt paydown, “multiple arbitrage” and fees.
Simple models like this one are excellent tools to give you insight into what drives the economics (or lack of!) in a deal. This is precisely the sort of model you might build as part of your investment banking induction programme (or indeed you might discover it’s the “standard model” in your department – albeit with a few formatting changes). We hope you enjoy the programme.
- Facilitator: Mark Woolhouse
Lifecycle of a Trade – T Rowe Price
- Facilitator: Greg Mayes
First part of the course focuses on the accounting information relevant to finance and financial analysis. Why it is useful and where it falls short too!
Who should attend?
General managers, Non-finance Board Directors, Department Heads, sales, marketing, Trustees, Charity managers, IT managers, Project Managers, any managers responsible for project evaluation and budgetary control, Office managers, Operations managers, and all people with a need or interest in managing financials or presenting professional, meaningful financial information.
- Teacher: Greg Mayes
Social networks