Advanced LBO Modeling Part 2
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Debt Instruments for our Deal
Debt Instruments for our Deal
Dealer Partners plans on a number of different debt types in the proposed deal. In this lesson, we explore the terms and characteristics associated with each type
Sources and Uses Table
Sources and Uses Table
The Sources and Uses Table outlines all the sources of cash to fund the deal and separately, where this cash is going.
Allocating Purchase Price Premium Part 1
Allocating Purchase Price Premium Part 1
Allocating the purchase price premium is one of the harder adjustments to make post-transaction. In this lesson, we begin this process, introducing the concept of goodwill.
Allocating Purchase Price Premium Part 2
Allocating Purchase Price Premium Part 2
In this lesson we calculate Total Goodwill created in the transaction and make the necessary adjustments to the balance sheet.
Additional Adjustments to the Balance Sheet.
Additional Adjustments to the Balance Sheet.
In this lesson we apply our adjustments to the balance sheet, altering many of the line-items for current year-end.
Debt Schedule Part 1
Debt Schedule Part 1
In this lesson, we calculate the annual interest payments that ToolCo will need to make on each debt tranche, and calculate the commitment fee on the revolver loan.
Debt Schedule Part 2
Debt Schedule Part 2
In this lesson, we calculate the mandatory annual debt repayment for each instrument and link these payments back to our financial statements
Reviewing our Transaction Assumptions
Reviewing our Transaction Assumptions
Our client has called an retail consulting firm to help validate some of our model assumptions. Hopefully this will improve the viability of the transaction.
Completing our Financial Statement Projections
Completing our Financial Statement Projections
In this lesson, we complete our financial statement projections, hoping that both sides of the balance sheet are the same!
Optional Debt Repayments
Optional Debt Repayments
Optional debt repayments enable a company to pay down debt early on some of their debt tranches. Find out how to build this complex logic - in this lesson.
Investment Analysis Part 1
Investment Analysis Part 1
In this lesson, we calculate the metrics (e.g. Net Debt, EBITDA) that will be used for our profitability and liquidity analysis.
Investment Analysis Part 2
Investment Analysis Part 2
Performing our profitability and leverage analysis will help both Dealer Partners and the lenders determine ToolCo's ability to repay its loans
