Certificate

Bolttech Technical Training Program 2021

Issued to:	Christian Overton
Issued date:	August 30, 2021
Issued by:	AMT Training

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.

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 fundamentals

Participants will assess and calculate the unlevered free cash flows of the target company and perform a discounted cash flow analysis on the target company. The resulting value will be sensitized using data tables.

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.

Non-life insurance: forecasting and valuation

Participants familiarize with the insurance business, starting with the property and casualty sector. Participants complete a fully integrated forecasting and valuation model for a non-life insurance company.

Tech focused M&A modeling case study

During this session, participants build a fully integrated merger model which combines financial statement forecasts for the acquirer and the target. Practical consolidation issues are addressed. The deal analysis focuses on the financing structure, pricing, earnings and credit impact and value creation.