Skip to content
Felix
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • AI
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Industrials
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
  • Ask An Instructor
  • Support
  • Log in
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • AI
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Industrials
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
Felix
  • Data
    • Company Analytics
    • My Filing Annotations
    • Market & Industry Data
    • United States
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
    • Europe
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
  • Models
  • Account
    • Edit Profile
    • Manage Account
    • My List
    • Restart Homepage Tour
    • Restart Company Analytics Tour
    • Restart Filings Tour
  • Log in
  • Ask An Instructor
    • Email Our Experts
    • Felix User Guide
    • Contact Support

LBO Valuation Case Study

LBO Valuation in the Investment Banking Case Study.

Unlock Your Certificate   
 
0% Complete

12 Lessons (40m)

Show lesson playlist
  • Description & Objectives

  • 1. LBO Case Study - LBO Structure Guidelines

    04:01
  • 2. LBO Case Study - Sources and Uses

    05:37
  • 3. LBO Case Study - Key Numbers

    02:53
  • 4. LBO Case Study - Income Statement

    02:04
  • 5. LBO Case Study - Cash Flows

    02:24
  • 6. LBO Case Study - Debt Servicing

    04:20
  • 7. LBO Case Study - Unsecured Notes

    02:38
  • 8. LBO Case Study - Cash Balance

    02:42
  • 9. LBO Case Study - Interest on Income Statement

    02:07
  • 10. LBO Case Study - Structure Test

    03:43
  • 11. LBO Case Study - Return to Equity Holders

    03:20
  • 12. LBO Case Study - Review of Model

    04:05

Prev: Synergy Valuation Case Study Next: Football Field Case Study

LBO Case Study - Debt Servicing

  • Notes
  • Questions
  • Transcript
  • 04:20

Calculate the debt servicing for the senior debt tranche in a leveraged buyout model. Use the min function, the average function, and the absolute reference to make the model flexible and accurate.

Downloads

Debt Servicing EmptyDebt Servicing Full

Glossary

=MIN() Absolute Reference Average LBO Senior Debt Tranche
Back to top
Financial Edge Training

© Financial Edge Training 2025

Topics
Introduction to Finance Accounting Financial Modeling Valuation M&A and Divestitures Private Equity
Venture Capital Project Finance Credit Analysis Transaction Banking Restructuring Capital Markets
Asset Management Risk Management Economics Data Science and System
Request New Content
System Account User Guide Privacy Policy Terms & Conditions Log in
Transcript

Now for the debt servicing, we're going to do a little base calculation here in rows 47 through 49. But it's a very simple base calculation. And the first thing I need to do is I need to anchor the number in the his last historical year, which is column F. And I'm gonna anchor that senior a debt balance by taking the balance from the sources and uses of funds from the senior debt. And my beginning balance is going to equal the ending balance of the prior year. And then I've got to calculate the issuance or repayment. Now for this line in row 48, what we want to do is try and make this as flexible as possible. We want to use every single dime of cashflow in cell G44, this 1,910 to repay the debt. But clearly, because the beginning balance is 12,536, you can't repay all that all at once. You're gonna pay as much as you possibly can do, but actually you want to pick the smaller number between the 12,536, and the 1,910. And we can do that by using a min function, the minimum of the beginning balance or the cash available. And I'm gonna make that negative by multiplying by minus 1. So in a situation where we have more debt than we can pay off, what will happen? The min function will take just the cash available where the cash available is bigger than the beginning balance. We won't overpay the debt. We'll just take the beginning balance. And if I just copy this right, you will see this because in the year that the debt can be paid off in 2029, the cash available is actually 3,332.6, but it's being compared with 57.9. And the 57.9 is smaller. So that is what gets repaid. So we actually have some surplus cash in that year to be waterfall down to repaying the next tranche of debt. Now, if we ran out of cash, let me make a kind of silly CapEx assumption of making that 10,000. So we're run out of cash. Can you see how the min function is so beautiful? Because what it does, it compares this negative 7,305 with the beginning balance that's smaller. It's a min function, but then it flips its sign. So that means it will actually be an issuance of debt. So the min function is just such a powerful feature. I'm going to control Z that change to go back to normal. And I'll calculate the interest expense. And the interest expense. I'm gonna go and calculate or pick up my assumption, which is the cost of senior debt. I'll absolute reference that and I'll multiply it by the average of the ending balances of last year. And this year I want to make it negative, so I multiply it by minus 1. So we've done our debt servicing for the senior debt tranche, or typically known as the term B tranche. So then we can calculate the cash flow of all for debt repayment after senior debt. And I'm gonna take the cash flow that we had originally, and I'm gonna add to what has been used for the issuance or repayment of the senior tranche. Now you may be thinking, why aren't we also including interest expense? Because surely we've gotta pay that. And the answer is yes, we do have to pay for that. But notice in row 40 when we calculated the cash flows to service debt, we did not start with EBITDA. We started with net income. And that 2290 in cell G40 is after, or at least will be when we wire the model up after deducting the 462 of interest expense. So I'm gonna hit enter and obviously we don't have any available cash because we are using the cash suite mechanism and every single dime is being used to service that senior debt. So then when I copy this across to the final year, you'll see that eventually once we've cleared the senior debt, then we get some surplus cash and that can be applied to the next tranche of debt.

Content Requests and Questions

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account
Help

You need an account to contact support.

Create a free account or log in to an existing one

Sorry, you don't have access to that yet!

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account

You have reached the limit of annotations (10) under our premium subscription. Upgrade to unlock unlimited annotations.

Find out more about our premium plan

You are trying to access content that requires a free account. Sign up or login in seconds!

Create a free account or log in to an existing one

You are trying to access content that requires a premium plan.

Find out more about our premium plan or log in to your account

Only US listed companies are available under our Free and Boost plans. Upgrade to Pro to access over 7,000 global companies across the US, UK, Canada, France, Italy, Germany, Hong Kong and more.

Find out more about our premium plan or log in to your account

A pro account is required for the Excel Add In

Find out more about our premium plan

Congratulations on completing

This field is hidden when viewing the form
Name(Required)
This field is hidden when viewing the form
Rate this course out of 5, where 5 is excellent and 1 is terrible.
Were the stated learning objectives met?(Required)
Were the stated prerequisite requirements appropriate and sufficient?(Required)
Were the program materials, including the qualified assessment, relevant and did they contribute to the achievement of the learning objectives?(Required)
Was the time allotted to the learning activity appropriate?(Required)
Are you happy for us to use your feedback and details in future marketing?(Required)

Thank you for already submitting feedback for this course.

CPE

What is CPE?

CPE stands for Continuing Professional Education, by completing learning activities you earn CPE credits to retain your professional credentials. CPE is required for Certified Public Accountants (CPAs). Financial Edge Training is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.

What are CPE credits?

For self study programs, 1 CPE credit is awarded for every 50 minutes of elearning content, this includes videos, workouts, tryouts, and exams.

CPE Exams

You must complete the CPE exam within 1 year of accessing a related playlist or course to earn CPE credits. To see how long you have left to complete a CPE exam, hover over the locked CPE credits button.

What if I'm not collecting CPE credits?

CPE exams do not count towards your FE certification. You do not need to complete the CPE exam if you are not collecting CPE credits, but you might find it useful for your own revision.


Further Help
  • Felix How to Guide walks you through the key functions and tools of the learning platform.
  • Playlists & Tryouts: Playlists are a collection of videos that teach you a specific skill and are tested with a tryout at the end. A tryout is a quiz that tests your knowledge and understanding of what you have just learned.
  • Exam: If you are collecting CPE points you must pass the relevant CPE exam within 1 year to receive credits.
  • Glossary: A glossary can be found below each video and provides definitions and explanations for terms and concepts. They are organized alphabetically to make it easy for you to find the term you need.
  • Search function: Use the Felix search function on the homepage to find content related to what you want to learn. Find related video content, lessons, and questions people have asked on the topic.
  • Closed Captions & Transcript: Closed captions and transcripts are available on videos. The video transcript can be found next to the closed captions in the video player. The transcript feature allows you to read the transcript of the video and search for key terms within the transcript.
  • Questions: If you have questions about the course content, you will find a section called Ask a Question underneath each video where you can submit questions to our expert instructor team.