Certificate

CEIBS Financial Modeling Program 20-22 Dec 2020

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

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.

LBO analysis fundamentals
Participants are introduced to the basic concepts underlying leveraged buyouts. The session starts by establishing why private equity firms can create value through leveraged buyouts and how the levered valuation fits into the valuation roadmap. Using a simple free cash flow forecast, participants establish how much a financial buyer could pay for the target company. Participants then build a simple LBO model.

M&A analysis fundamentals
This session covers the basic steps of analyzing an acquisition - covering the impact of a deal on the financial statements with a particular focus on EPS, PE and contribution analysis. By the end of the session, the class builds an accretion / dilution model using EPS forecasts and acquisition assumptions, proforma leverage ratios and a proforma balance sheet.