Financial modeling - Fundamentals Part 1

This session teaches participants how to build a three statement integrated financial model, comprising income statement, balance sheet and cash flow statement. Best-practice modelling techniques are demonstrated, to ensure maximum accuracy and efficiency. Participants also learn how to stress-test the assumptions used, to check the model for mistakes and to document it. This session uses simplified teaching models as well as a real company forecast model.

Financial modeling - Fundamentals Part 2

Using a real company forecast model, we start the session by reviewing the structure and key components of an integrated three statement forecast model. We then focus on modeling operating cash (required cash) and separating it from excess cash. We then teach participants how to build a forecast cash flow statement from scratch, using income statement and balance sheet inputs. The last part of this session focuses on interest calculations and circularities, where we teach participants the difference between using beginning, ending or average debt/cash balances and how to work safely and effectively with or without circular formulae in a model This session can be taken as a stand-alone module, or as a follow-up to the Part 1 session.

Excel power modeling

This program covers a range of tools and techniques in Excel designed to improve effectiveness and efficiency.

Valuation fundamentals

The session lays the foundations to build a solid understanding of corporate valuation in the context of investment banking. The most common valuation methodologies are introduced, explaining the difference between a company's fundamental value, and how much an acquirer would pay for the business. The concepts of enterprise value and equity value are explained, using simple but rigorous exercises. Finally, the basics of multiple valuation and discounted cash flow valuation are introduced. Exercises are used throughout the session.

DCF valuation

Participants learn how to build a discounted cash flow valuation model. The session starts with an overview of the valuation methodology, and the steps required in setting up a valuation model. We then focus on the calculation of free cash flow. A detailed ratio analysis is used to establish the reasonableness of the forecasts and to identify when the target company reaches steady state. We analyze the weighted average cost of capital, calculate terminal values, using both the exit multiple method and the perpetuity growth method. We discount the free cash flows to arrive at enterprise values and calculate the implied share price. Once the valuation is complete participants perform several checks on the analysis using key ratios, and sensitivity and scenario analysis.