Skip to content
Felix
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • 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
      • 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
      • 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
      • 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 my profile
    • 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

Chemicals - Analysis and Modeling

What makes chemical companies distinct from other sectors, and applies a range of sector-specific techniques.

Unlock Your Certificate   
 
0% Complete

30 Lessons (120m)

Show lesson playlist
  • Description & Objectives

  • 1. Chemical Sector Players

    02:35
  • 2. What Makes Chemical Companies Special

    01:30
  • 3. Scale of Chemicals Companies - Examples

    01:53
  • 4. Oversupply Problems in the Chemical Sector

    01:46
  • 5. Commodity Prices

    02:02
  • 6. Segmental Analysis

    03:53
  • 7. Segmental Analysis Workout

    12:23
  • 8. Sum of the Parts Valuation

    02:27
  • 9. Sum of the Parts Workout

    01:49
  • 10. Pensions in the Chemical Sector

    02:04
  • 11. Analyzing Chemical Companies

    01:50
  • 12. Case Study Company AkzoNobel

    02:23
  • 13. Chemicals Model - Model Intro

    03:05
  • 14. Chemicals Model - Company and Segment Intro

    02:04
  • 15. Chemicals Model - Segmental Forecasting and Bridges Discussion

    05:25
  • 16. Chemicals Model - Paint Segment Revenue

    03:32
  • 17. Chemicals Model - Paint Segment EBIT Margin

    08:15
  • 18. Chemicals Model - Performance Segment Bridges and Corporate

    07:14
  • 19. Chemicals Model - Operating Model Intro

    03:50
  • 20. Chemicals Model - Operating Model Subtotals

    04:39
  • 21. Chemicals Model - Profit and Loss

    03:14
  • 22. Chemicals Model - BASE Calculations

    05:03
  • 23. Chemicals Model - Balance Sheet

    04:56
  • 24. Chemicals Model - Cashflow Statement

    06:10
  • 25. Chemicals Model - Interest and Circularity

    05:43
  • 26. Chemicals Model - Completing the Model

    03:46
  • 27. Chemicals Model - Model Metrics

    05:59
  • 28. Chemicals Model - Sum of the Parts EV

    03:42
  • 29. Chemicals Model - Sum of the Parts Complete

    05:37
  • 30. Chemicals Tryout

Chemicals Model - Model Metrics

  • Notes
  • Questions
  • Transcript
  • 05:59

Analyzing a chemical company like Akzo to see how it has done, and how it is predicted to do.

Downloads

Chemicals Model - Model Metrics EmptyChemicals Model - Model Metrics Full

Glossary

Chemicals Ratios
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

We'll now look at the metrics one block at a time.

You can see I've already populated them and the formulas are here on the right.

First, revenue and margins.

This is the overall revenue growth and what it does is it combines the revenue of all the segments and you can see that there's a bit of shrinkage in revenue in 2023, but the desire would remain to look at much more detail for which we have the segments tab.

The margins are interesting because the margins are lower than you would expect from our two operating segments.

Paint and performance both have relatively high margins compared to here, and so this could seem like an error, but what we're seeing is corporate dragging down the overall EBIT margin.

This is also similar for EBITDA and net income.

This would be helpful for benchmarking.

So it's interesting to note that major competitors, American competitors of Axo such as PPG, which has repeatedly tried to buy Axo, has significantly higher EBITDA margin, something like 19%, and this helps us to understand whether Axo is able to create return from its revenues and then we can dig down into the segments to find out why they can or cannot.

The next block is about asset efficiency, and you can see we've just copied in the OWC, so the operating working capital, and then we've made that relative to revenues.

This allows you to see how much OWC there is relative to the revenues that it's helping to create.

And so one way to think about it with Axo is how many tins of paint do they need on their shelves to create the sales that they are creating? And you can see that after some volatility.

Broadly, things are improving because they're able to reduce their proportional OWC and that will be releasing cash.

So what we might be seeing here is the product of their restructuring plan.

For a very capital intensive industry like chemicals, you might see lots more metrics than just PPE over revenue, but here we just have the one.

You can see that Axo is creating around five times as much revenue as it has PPP and E, and you can see that it's improving, so they're able to create more revenue outta less PP and E.

This would warrant further investigation, however, because it could represent things wearing out and not being replaced in time for high quality production down on borrowings, you can see a sudden lurch, which again might seem like an error, but what we're seeing here is a transition from the historical where you can have short-term borrowings and cash to our forecast with the sweep where you cannot have short-term borrowings if you have cash, so the short-term borrowings disappear.

This is then accompanied by a convergence of total debt and net debt.

Historically, they can be quite far apart because you Could have quite high debt.

That's also netted out by quite high cash in the forecast. That can't be the case.

The cash Is already netted out, and so the Debt That you are seeing already has an element of net in it, which is interesting.

What's perhaps more interesting, however, is what we Actually do with Debt and net debt.

There are some classic credit metrics down here.

If we accept that EBITDA is close to cash, it's not perfect, but pretty close.

Then debt over EBITDA is something like a Payback period Where initially in the model it would take about two and a half years of EBITDA to payback the total debt Or 1.6 on a net debt basis, but then in the next year that Rockets up And that's because in the next year, Axo is doing some share buybacks and is entering the lutan market by doing some acquisitions.

Axo has been under quite a little Pressure to do buybacks, Divestments and changes of direction because the competitor that we mentioned earlier, PPG, which is outcompeting it in terms of some of its margins, has also been a Prospective purchaser For a long time.

And so one of the responses to that was to make a major divestment in 2018, which we can't see, and then start to reach into new markets, which we can perhaps see a bit here.

And that's caused what might be a quite concerning level of debt and credit analysts would be watching these lines with interest and with information which is available to us.

Now at time of recording, we know that Axo actually suffered A downgrade in November, 2024. And so What's Happening here is That debt over EBITDA is not just concerning to investors, But also To credit agencies and that would have a big impact on their ability to borrow and their cost of debt.

So Very important to credit analysts. These lines.

Also important is interest cover Because it Represents a margin of safety for your ability To service your debt.

You can see the interest cover is Really good.

However, just like The more Leverage based metrics, it really takes A beating in 2022. And that's because, Uh, what Axo does is it borrows And it borrows quite expensively because It's already quite highly Levered and it's doing that to expand and do the buybacks.

It may seem odd to do any kind of metrics on book basis, Which Is what the final line is doing, but what credit analysts might do with this line is say, well, What's the proportion of debt to the total assets Of the company, which is net debt plus Equity, Broadly speaking.

And what they might do there is they might be undervaluing the equity quite A lot, but if Axo was on a breakup basis, As in it was in trouble and was going to liquidate, then you could assume that the equity Was worth its book value.

And so this then allows you to see the proportion of debt in the overall capital Structure at book or breakup value.

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.