Financial Modeling

The aim of this session is to build a model which forecasts the impact of undergoing a financial restructuring. The model covers both the restructuring and the emergence phase. Both the financial and operational restructuring will drive the emergence date adjustments. This model will integrate a two stage accounting adjustment model into a three statement financial forecast model.

The aim of this session is to produce a 13 week cash flow model which fully integrates to a 3 statement financial statement forecast. Both a direct and an indirect cash flow statement will be produced. The financials are produced for a variety of time periods, weekly, quarterly and annually. The actual financials are integrated so that the financial forecast is up to date and there is a variance analysis output section. The issues are the efficiency and integrity of the model.

How much can a financial buyer pay? Participants will build financial models that analyze leveraged buyout (LBO) transactions as they are developed in today’s market. You’ll learn to handle tricky circularities inherent in structures like revolvers and cash sweeps along with modeling the return to different players in an LBO deal.

How much can a financial buyer pay? Participants will build financial models that analyze leveraged buyout (LBO) transactions as they are developed in today’s market. You’ll learn to handle tricky circularities inherent in structures like revolvers and cash sweeps along with modeling the return to different players in an LBO deal.

How much can a financial buyer pay? Participants will build financial models that analyze leveraged buyout (LBO) transactions as they are developed in today’s market. You’ll learn to handle tricky circularities inherent in structures like revolvers and cash sweeps along with modeling the return to different players in an LBO deal.

How much can a financial buyer pay? Participants will build financial models that analyze leveraged buyout (LBO) transactions as they are developed in today’s market. You’ll learn to handle tricky circularities inherent in structures like revolvers and cash sweeps along with modeling the return to different players in an LBO deal.

Participants start with a blank spreadsheet and build a model template. The financial statements of a case company are then analyzed, and the historical data is cleaned and prepared for the forecasting process. Ratios are calculated and assumptions for each line item in the financial statements are created. The full forecast model is then built. The forecasting techniques for several different items are examined separately, using dedicated Excel files, before being adapted for the case company. Complex issues such as minority interest and affiliates are also covered in this session. The full exercise takes 2 days.

Participants practice using an Excel modeling toolkit for advanced financial models.

This session deals with advanced modeling topics in valuation and deal structuring. Participants complete and add to existing models using a variety of small case studies that highlight key financial modeling issues.

This program covers a range of tools and techniques in Excel designed to improve effectiveness and efficiency. We cover formatting, advanced functions, text and date functions, range names and printing techniques.