Advanced LBO Modeling Part 1
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Introducing the ToolCo Case Study
Introducing the ToolCo Case Study
ToolCo operates a chain of hardware stores in the US and has been identified by Dealer-Partners as a potential takeover target. In this lesson, we learn more about this case study and how this course differs from the previous modelling courses you may have completed
LBO Deal Assumptions
LBO Deal Assumptions
In this lesson, we enter the basic deal assumptions for our model to calculate the Equity Value and Enterprise Value of ToolCo
Fees, Funds Required and Debt
Fees, Funds Required and Debt
In this lesson, we calculate the transaction fees Dealer Partners would incur and find the total funds required and amount debt needed to do the deal.
LBO Revenue Projections
LBO Revenue Projections
In this lesson, we create 5-year revenue projections for ToolCo, including both the revenue per store and # of stores in our projections.
LBO Expense Projections
LBO Expense Projections
In this lesson, we create expense projections for ToolCo, based primarily on assumed expenses per store. This is a common way of creating expense projections for retail chains.
Capital Expenditure and Depreciation Part 1
Capital Expenditure and Depreciation Part 1
In this lesson we project the depreciation for next 5 years from our existing property, plant and equipment.
Capital Expenditure and Depreciation Part 2
Capital Expenditure and Depreciation Part 2
In this lesson we project the depreciation for next 5 years from new capital expenditure we aim to buy in the next 5 years. This means we need to project capital expenditure before we can project depreciation.
Balance Sheet and Cashflow Assumptions
Balance Sheet and Cashflow Assumptions
In this lesson, we enter the assumptions required to project both the balance sheet and the statement cashflows for the next 5 years.
Projecting the Income Statement
Projecting the Income Statement
In this lesson, create our 5-year projection for the income statement, utilising revenue and expense projections calculated in earlier lessons.
Projecting the Balance Sheet
Projecting the Balance Sheet
In this lesson, create our 5-year projection for the balance sheet, linking the assumptions created in an earlier lesson.
Projecting the Statement of Cashflows
Projecting the Statement of Cashflows
In this lesson, we use values from the income statement and statement of cashflows to project our statement of cashflows.
Completing our 3 Statement Projection
Completing our 3 Statement Projection
In this lesson, we wrap up our 3-statement projection by connecting values in the statement of cashflows back to our balance sheet, which should hopefully balance!
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
