Course
|
Financial Modeling

Advanced LBO Modeling Part 2

In this course, we learn how to adjust our financial statement projections, due to the acquisition of the company. In addition, we perform a series of analyses to generate a recommendation for Dealer-Partners on the proposed deal.
3 HOURS
Advanced
14 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Calculate repayments for multiple debt instruments
Allocate the Purchase Price Premium
Compile a debt projection with multiple debt instruments
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Financial Modeling

Advanced LBO Modeling Part 2

In this course, we learn how to adjust our financial statement projections, due to the acquisition of the company. In addition, we perform a series of analyses to generate a recommendation for Dealer-Partners on the proposed deal.
3 HOURS
Advanced
14 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Calculate repayments for multiple debt instruments
Allocate the Purchase Price Premium
Compile a debt projection with multiple debt instruments
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

14 Lessons
Debt Instruments for our Deal
5 MINS
LESSON
Debt Instruments for our Deal
Exercise

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
5 MINS
LESSON
Sources and Uses Table
Exercise

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
6 MINS
LESSON
Allocating Purchase Price Premium Part 1
Exercise

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
6 MINS
LESSON
Allocating Purchase Price Premium Part 2
Exercise

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.
4 MINS
LESSON
Additional Adjustments to the Balance Sheet.
Exercise

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
6 MINS
LESSON
Debt Schedule Part 1
Exercise

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
5 MINS
LESSON
Debt Schedule Part 2
Exercise

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
6 MINS
LESSON
Reviewing our Transaction Assumptions
Exercise

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
7 MINS
LESSON
Completing our Financial Statement Projections
Exercise

In this lesson, we complete our financial statement projections, hoping that both sides of the balance sheet are the same!

Optional Debt Repayments
6 MINS
LESSON
Optional Debt Repayments
Exercise

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
6 MINS
LESSON
Investment Analysis Part 1
Exercise

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
7 MINS
LESSON
Investment Analysis Part 2
Exercise

Performing our profitability and leverage analysis will help both Dealer Partners and the lenders determine ToolCo's ability to repay its loans

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo