🎯24Q1 Roundup

Time to review the quarter

Companies are starting to release their 24Q2 reports. In this edition, I thought we would take the chance to compare some metrics of the 24Q1 period. As such, this edition will look a bit different from usual.

Company (link to 24Q1)

24Q2 Announcement

TotalEnergies

25-Jul

Bp

30-Jul

ConocoPhillips

01-Aug

Shell

01-Aug

ExxonMobil

02-Aug

Marathon Petroleum

06-Aug

Saudi Aramco

09-Aug (estimated)

PetroChina

30-Aug (estimated)

Getting Started

For simplicity, I am going to use the ticker symbol in the charts. The exception is for Aramco and PetroChina. They both have numeric tickers, which aren’t super recognisable, so I have made my own up for the sake of convenience.

Company

Symbol/Reference

ExxonMobil

XOM

BP

BP

ConocoPhillips

COP

TotalEnergies

TTE

Shell

SHEL

Saudi Aramco

ARAM

PetroChina

PCHN

Marathon Petroleum

MPC

Get value stock insights free.

PayPal, Disney, and Nike recently dropped 50-80%.

  • Are they undervalued?

  • Can they recover?

  • Read Value Investor Daily to find out.

We read hundreds of value stock ideas daily and send you the best.

Income Conversion 2024 Q1

Company

Revenue

Gross Profit

Gross Margin

Net Profit

Net Margin

ARAM

U$118.6B

U$82.8B

69.8%

U$27.3B

23.0%

PCHN

U$115.0B

U$24.4B

21.3%

U$7.2B

6.2%

XOM

U$83.1B

U$26.4B

31.8%

U$8.2B

9.9%

SHEL

U$74.7B

U$22.0B

29.5%

U$7.4B

9.8%

TTE

U$58.8B

U$17.4B

29.6%

U$5.5B

9.9%

BP

U$50.0B

U$15.5B

31.0%

U$2.4B

4.8%

MCP

U$33.2B

U$3.6B

10.9%

U$1.3B

4.0%

COP

U$14.5B

U$7.1B

49.3%

U$2.6B

17.6%

Comparing the companies, we see some interesting insights:

  • Saudi Aramco is a beast with the highest Revenue, Net Profit and Net Margin.

  • PetroChina has revenue similar to Aramco's, but it is unable to convert that to net profit successfully.

  • ExxonMobil, Shell and TotalEnergies have similar conversation percentages.

  • ConocoPhillips has an order of magnitude lower than Aramco but demonstrates that it is nearly as efficient in its conversion to net profit.

Net Cashflow 2024 Q1

Company

Operations

Investing

Finance

Net Cashflow

ARAM

 U$33.6B 

 U$12.8B 

 -U$34.4B 

 U$12.0B 

PCHN

 U$15.6B 

 -U$8.8B 

 -U$9.2B 

 -U$2.4B 

XOM

 U$14.7B 

 -U$4.6B 

 -U$8.0B 

 U$2.1B 

SHEL

 U$13.3B 

 -U$3.5B 

 -U$8.6B 

 U$1.2B 

TTE

 U$2.2B 

 -U$3.5B 

 -U$0.3B 

 -U$1.6B 

BP

 U$6.5B 

 -U$3.8B 

 -U$2.7B 

 U$0.0B 

MPC

 U$1.5B 

 -U$0.8B 

 -U$3.0B 

 -U$2.3B 

COP

 U$5.0B 

 -U$2.1B 

 -U$2.9B 

 -U$0.1B 

The net cashflow gives us insights into the total net of that activity.

  • Aramco made money in its investing activities.

  • BP was balanced in its cash flow with no change in its reserves; similarity COP was close to net 0 change.

  • Most spent more on financing activities, whereas BP and TotalEnergies did not. This is because BP and TotalEnergies received large borrowings (see below, for example).

Equity Portfolio 2024 Q1

Company

Current Assets

Noncurrent Assets

Assets

ARAM

U$186.1B 

 U$475.5B  

 U$661.6B 

PCHN

 U$93.9B 

 U$291.6B 

 U$385.6B 

XOM

 U$99.4B 

 U$278.5B 

 U$377.9B 

SHEL

 U$133.1B 

 U$269.0B 

 U$402.0B 

TTE

 U$97.5B 

 U$185.6B 

 U$283.1B 

BP

 U$101.4B 

 U$174.0B 

 U$275.4B 

MPC

 U$31.3B 

 U$54.3B 

 U$85.5B 

COP

 U$13.7B 

 U$81.6B 

 U$95.3B

Company

Current Liabilities

Noncurrent Liabilities

Liabilities

Equity

ARAM

 U$83.8B 

 U$118.6B 

 U$202.3B 

 U$459.3B 

PCHN

 U$87.9B 

 U$62.4B 

 U$150.3B 

 U$235.3B 

XOM

 U$71.9B 

 U$92.9B 

 U$164.9B 

 U$213.1B 

SHEL

 U$93.9B 

 U$119.8B 

 U$213.7B 

 U$188.3B 

TTE

 U$89.2B 

 U$72.8B 

 U$162.0B 

 U$121.1B 

BP

 U$82.3B 

 U$108.2B 

 U$190.5B 

 U$84.9B 

MPC

 U$21.8B 

 U$34.0B 

 U$55.8B 

 U$29.8B 

COP

 U$10.2B 

 U$35.9B 

 U$46.0B 

 U$49.3B 

Current Ratio 2024 Q1

The current ratio is the current assets / current liabilities. As such, one or greater indicates a business has enough current assets to pay off its current liabilities in full. The average for the industry is clearly seen as 1.1 to 1.4. Aramco goes above and beyond.

Debt to Equity Ratio 2024 Q1

In previous editions, I have made reference to the Liability to Asset (L/A) ratio. I think the Debt to Equity ratio is a better term as it is not constrained from 0 to 1. A lower Debt to Equity ratio is usually better as more of the assets are owned, and less is reliant on debt. However, debt is used as leverage, so it is not necessarily a bad thing. We can see quite a spread; notably, BP and Marathon had the highest ratio; they also had the lowest profit margin for the quarter.

Company 

Current Ratio

Debt to Equity Ratio

ARAM

5.7

0.44

PCHN

1.1

0.64

XOM

1.4

0.77

SHEL

1.4

1.14

TTE

1.1

1.34

BP

1.2

2.24

MPC

1.4

1.87

COP

1.4

0.93

Enjoyed this newsletter? Forward it to a friend and have them sign up here.

Cheers,

Connor

All data can be found on the respective investors websites. Refer to the newsletters linked up top. Then at the bottom of those newsletters will be the direct link to the source.