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

Red Bull Accounting Case Study

Accounting in the Investment Banking Case Study.

Unlock Your Certificate   
 
0% Complete

6 Lessons (45m)

Show lesson playlist
  • Description & Objectives

  • 1. Accounting Case Study - Introduction

    02:35
  • 2. Accounting Case Study - Income Statements

    17:15
  • 3. Accounting Case Study - Balance Sheet

    07:25
  • 4. Accounting Case Study - Debt Section

    07:22
  • 5. Accounting Case Study - Ratio Analysis

    05:49
  • 6. Accounting Case Study - Lease Adjustments

    04:59

Next: Red Bull Modeling Case Study

Accounting Case Study - Ratio Analysis

  • Notes
  • Questions
  • Transcript
  • 05:49

Analyze the financial ratios of Keurig Dr. Pepper and compare them to other beverage companies. The meaning and calculation of various ratios such as profitability, growth, asset efficiency, and leverage.

Downloads

Ratio Analysis EmptyRatio Analysis Full

Glossary

Efficiency Ratios Growth Rate Leverage Ratio Profitability ratios Return on Invested Capital (ROIC)
Back to top
Financial Edge Training

© Financial Edge Training 2026

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

Once we have the key numbers for Dr. Pepper, we can now look at the financial ratios And there are three main groups of ratios that we look at. The first are profitability ratios, which looks at how much profit the firm is making each dollar of revenue. And we also have growth rates. And growth rates are very, very important when we come to valuation because that's one of the key differentiators in what multiple a firm trades at. And we will use the growth in the recurring revenues to make sure any non-recurring items are stripped out. Gross margin, we can just copy to the right EBIT margin and EBITDA margin. EBITDA margin's probably the most important because it strips out the effect of acquisitions which create lots of additional depreciation and amortization. So that's probably a key metric in terms of our margin and revenue growth as well. When we come to valuation, we've also got a net operational profit after tax, which are just EBIT times 1 minus the tax rate. And that's one of the reasons why we had the tax rate included above at the top. And then we have invested capital. Invested capital is one of the key metrics which will compare to NOPAT. And in this case, investor capital is the net debt plus shareholders equity line items. Because it's the capital that external investors, third party investors, both on the debt side and the equity side given to the business, we subtract cash. Cash generates interest income, which is not included in operating profit. So therefore we obviously don't want to include it in the denominator and that will give us a return. And that return investor capital is what we'll compare to the cost of capital because the return is what investors get. The cost of capital is what they expect. If we come down to asset efficiency, asset efficiency ratios focus on how well the company is managing its assets and in the case of working capital line items, how quickly they turn over. So the receivable days is a good metric of how long it takes to get paid by customers. So the lower the number, the better. Inventory days, again, this is measuring the amount of time it takes to convert raw material into the end product and deliver it to the customer. So the more efficient your manufacturing process, the shorter your inventory days. So we would like to have a smaller number relatively for inventory days. And then payable days is how long it takes you to pay your suppliers. because if you are a good negotiator and you have a dominant position in an industry, you would normally expect to see your payable debt ratio be higher. And you can see here In this sector the person or the firm were the biggest payable days is Coca-Cola. It's by far the largest player and that's probably why it's got the largest payable days. Operating working capital. This gives you a sense of how much cash is tied up in working capital reached dollar of sales in this industry, most of the players, with the exception of Monster, have a negative working capital. And what that means is they're paying their suppliers after they have received cash from their customers. And then there are a few other metrics of just how efficient they are with the amount of PP&E per dollar of sales, CapEx as a percent of revenue, and then how much they're reinvesting in their assets, their CapEx compared to how much they are depreciating their assets. And then we've got revenue over investor capital, which is another metric. So that's the asset efficiency ratios. Leverage ratios are a way of establishing the indebtedness of the company comparatively. A straightforward one is debt divided by equity. So if your debt is equal to equity, this would be one times or a hundred percent. Probably more intuitive is to have debt developed by debt plus equity. So this gives you a kind of percentage of debt in your financing structure. So in this case for Keurig Dr. Pepper in 2023 it's around 40% or 0.4 times. So 40% of the capital is provided by debt holders. 60% is provided by equity holders and that's called it a nice metric. We can also use net debt and you'll find the rating agencies use both gross and net items. In some industries that have a lot of cash on a regular basis, you probably better it off for using net debt, but in others it's actually better to use gross debt. So it kind of depends on the industry, those metric. And you can either do it by net debt over equity or net debt divided by net debt plus equity. A key metric is your debt is multiple of EBITDA. This is very important. This is mostly how we think about leveraging finance is EBITDA multiples. A very high multiple is about six times. For a publicly traded company, normally you would expect it in the range of up to two to three times. Sometimes very stable. Industries can push ahead of that and still maintain an investment grade credit rating. But if you are hitting things like four times, five times over the long term, you probably won't have an investment grade credit rating. And another metric is EBITDA of interest expense, less important because interest rates historically and the recent history have been very low, but it is becoming more important and it as interest rates rise.

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.