Saturday, September 3, 2022

Linear Regression of Monthly Returns of Lennox International against Vanguard S&P 500 Index ETF

Here is the graph of monthly returns of Lennox International (LII) plotted against Vanguard S&P 500 Index ETF (VOO):

Exhibit 1: Monthly Returns of Lennox International and Vanguard S&P 500 Index ETF [June 2019 -  August 2022 


(Source: RStudio, ggplot, Data Provided by IEX Cloud)

Results of the linear regression of monthly returns of Lennox International against Vanguard S&P 500 Index ETF:

VOOandLII <- read_excel("/LII_VOO_LM_September_2022.xlsx", sheet = "Sheet1")

lmLIIVOO = lm(LII_Monthly_Return~VOO_Monthly_Return, data = VOOandLII)

> summary(lmLIIVOO)

Call:
lm(formula = LII_Monthly_Return ~ VOO_Monthly_Return, data = VOOandLII)

Residuals:
      Min        1Q    Median        3Q       Max 
-0.090246 -0.052733 -0.001907  0.040310  0.108446 

Coefficients:
                    Estimate Std. Error t value Pr(>|t|)    
(Intercept)        -0.010082   0.009416  -1.071    0.291    
VOO_Monthly_Return  0.995050   0.170040   5.852 9.97e-07 ***
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 0.05767 on 37 degrees of freedom
Multiple R-squared:  0.4807, Adjusted R-squared:  0.4666 
F-statistic: 34.24 on 1 and 37 DF,  p-value: 9.966e-07

The slope of the regression corresponds to the beta of the stock. In this case, Lennox International has a beta of 0.995. Lennox's beta is close to the S&P 500 beta, so Lennox will move in line with the market.  

The adjusted R-squared is 0.46. About 46% of Lennox's return is explained by the returns of the S&P 500 index.  











Saturday, February 26, 2022

Welch Two Sample t-test of Daily Price Returns of J.M. Smucker and Mondelez

J.M. Smucker and Mondelez are consumer staples companies with similar financial performance. Both companies compete in similar product categories, especially when it relates to snacks. But, Mondelez has a vast international operation, while J. M. Smucker is more focused on the U.S. with very little So, I wanted to see if the mean daily returns are the same between the two stocks.

First, I downloaded the daily price return data for the past six months for both J.M. Smucker (SJM) and Mondelez (MDLZ) from IEX Cloud

I did a correlation between the daily price returns of the two companies using R:

> cor(SJM_6Month_ClosingPrice_Daily_Return_Data$changePercent, MDLZ_6Month_ClosingPrice_Daily_Return_Data$changePercent) 

[1] 0.5815403

The correlation in the daily returns between the two companies was 0.58 for the past six months. It is a positive correlation, but I would not consider this as a strong correlation in returns between the two companies. I would consider it a strong correlation if it was at or above 0.70. This came as a surprise given that both the companies are in the consumer staples sector and that sector has performed very well since December 2021. 

Next, I wanted to calculate the p-value for the Welch two-sample t-test between means of the daily returns.  The null hypothesis is that the difference in mean daily returns between J.M. Smucker and Mondelez is zero. The alternate hypothesis is that the difference is not zero. The p-value is 0.9035, which means the null hypothesis can be resoundingly rejected. The t-test command in R and the result set is presented below. The J. M. Smucker had a mean daily return of 0.0893% and Mondelez had a daily return of 0.0717%. There is a 1.7 basis points difference in returns with J. M. Smucker having a slightly larger daily return than Mondelez.       

> t.test(SJM_6Month_ClosingPrice_Daily_Return_Data$changePercent,         MDLZ_6Month_ClosingPrice_Daily_Return_Data$changePercent)

Welch Two Sample t-test

data:  SJM_6Month_ClosingPrice_Daily_Return_Data$changePercent and MDLZ_6Month_ClosingPrice_Daily_Return_Data$changePercent

t = 0.1214, df = 239.4, p-value = 0.9035

alternative hypothesis: true difference in means is not equal to 0

95 percent confidence interval:

 -0.002682718  0.003035099

sample estimates:

   mean of x    mean of y 

0.0008936508 0.0007174603 

Finally, here's the scatter plot of daily price change of J.M. Smucker (SJM) and Mondelez (MDLZ).

(Data Source: IEXCloud.io, Plot Created using RStudio)

  

Monday, January 31, 2022

Copper Prices at 5-Week Lows. Is this a Bad Sign for the Global Economy?

Aluminum and copper prices are a study in contrast. Aluminum is trading near all-time highs (See Exhibit 1: Aluminum Trading Near All-time High Price) while copper's rally is beginning to fade. Copper is trading at 5-week lows.  

Exhibit 1: Aluminum Trading Near All-time High Price

According to Trading Economics, low inventory levels, the power crisis in Europe, and Ukraine-Russia tensions are all to blame for this incredible rally in aluminum.

Meanwhile, copper prices are at five-week lows due to the strong dollar and increased production. Trading Economics reports that Chilean authorities are projecting that copper production will increase by 4.1% during 2022, returning to pre-pandemic levels. Even at its current price of $4.32/lb, copper is trading at all-time highs (See Exhibit 2: Copper Prices at 5-Week Lows). I am watching copper see if it falls below $4/lb. Falling below that price level may be a bearing sign not only for copper but for the world economy.

Exhibit 2: Copper Prices are at 5-Week Lows


If copper continues to fall, the stock prices for miners, such as Rio Tinto (RIO), might fall with it. The share price of Rio Tinto has tumbled about 9% from its peak of approximately $78.48 achieved in mid-January (See Exhibit 3: Rio Tinto's Share Price Takes a Hit in January).

Exhibit 3: Rio Tinto's Share Price Takes a Hit in January

(Source: Seeking Alpha)


Friday, January 28, 2022

Invest in an Equal-Weight ETF in these Turbulent Times.

The S&P 500 index is market-capitalization-weighted. The weighting by market cap means the companies with the largest market capitalization (Market capitalization = Number of shares outstanding x Share Price) get the highest weight. Last year, this method for calculating the index made the five largest companies by market cap account for 23% of the index. That is just 5 out of the 500 companies accounting for about a quarter of the market capitalization. These five companies were: Apple, Microsoft, Alphabet (Google), Amazon, and Facebook (Meta). When the share price of these companies starts underperforming, the market takes a huge tumble. We can see that happening now. The S&P 500 index (VOO) is down about 9.72% (pre-market on January 28), while the S&P 500 equal-weighted ETF (RSP) is down 7.48% (See Exhibit 1: Invesco Equal-Weight ETF Beats Vanguard S&P 500 Market-Cap Weighted ETF). That is a difference in the performance of 224 basis points. In essence, the equal-weight ETF outperformed the market-cap ETF. The dividend yield is about the same for both ETFs. The Invesco Equal-Weight ETF charges a higher expense ratio than the Vanguard S&P 500 ETF. Invesco charges 20 basis points (bps) or 0.2%, while the Vanguard S&P 500 ETF (VOO) charges three bps or 0.03%. Invesco charges 7x more than the Vanguard ETF. Even after deducting the extra expense of investing in the Invesco ETF, it comes ahead in performance by over 200 bps.  

The era of big-tech is coming to an end due to more regulation and their size inhibiting growth. At least for now, Apple seems to be bucking the trend after reporting blockbuster results yesterday. Interest rates are also rising, putting pressure on valuation because future earnings will be discounted at a higher interest rate. It may be good to have a position in the Invesco Equal-Weight ETF (RSP) during these times. 

     Exhibit 1: Invesco Equal-Weight ETF Beats Vanguard S&P 500 Market-Cap Weighted ETF
(Source: Seeking Alpha)
Also, there may be other equal-weight ETFs in the market. I am aware of Invesco's ETF, so I have invested in it. I am not endorsing the Invesco ETF. 

Monday, January 3, 2022

Few Things to Know About Our Current Energy Transition from Fossil Fuels to Renewables.

In a discussion hosted by Bridgewater Associates (the world's largest hedge fund), Daniel Yergin discussed the current energy transition, geopolitics, and government. Daniel Yergin emphasizes a few things about our energy transition:

  • Energy transition to oil from coal took nearly a hundred years. 
  • Instead of trying to control oil supplies, now we are trying to control materials used in batteries and solar panels. Increasing lithium and cobalt prices pose a challenge for electric vehicles. 
  • Electric vehicles may need subsidies to make them affordable. 

Governments can offer subsidies, but the loss of revenue due to the subsidies need to be compensated by higher taxes, lower social benefits, or higher deficits. The world is grappling with excessive debt levels and does not have the flexibility to take on more deficit spending. Take the example of Japan, where the outstanding government bonds have crossed one thousand trillion yen for the first time.    

You can watch the Daniel Yergin discussion on YouTube.  

Sunday, January 2, 2022

Energy Transition will be Messy and Expensive. Hold on to Your Barrel of Oil for Now.

Many people anticipate that electric vehicles will win the transportation race and replace the internal combustion engine. Many journalists and energy experts have been warning for a while that the transition from fossil fuels to renewables will be messy. Daniel Yergin says that we are in an energy-mix era

Lithium - one of the critical materials used in batteries - is in short supply, and its prices have increased by 5x. Electric vehicle battery costs are set to increase for the first time in a decade. 

Meanwhile, European Union is beginning to realize that they cannot simply abandon nuclear power and still keep the lights on. They plan to classify nuclear power and natural gas as "green" power sources. In my opinion, there is no such thing as fully green energy. For example, lithium mining and mining for other materials in producing an electric vehicle are damaging to the economy. The world needs good recycling technology to create a circular economy and minimize emissions and environmental damage.       

General Motors Ultium Battery and Global Vehicle Platform for Electric Vehicles.
(Source: General Motors)

The surge in oil prices in the past year, coupled with the reluctance of oil companies to invest in new oil discoveries, could lead to higher energy prices and even an energy shock. This lack of investment in new oil supplies could increase inflation.   

Covered Call on J. M. Smucker, Public Service Employee Pay in China, Indonesia's Foreign Relations Dilemma

I recently wrote about my investment thesis for J. M. Smucker (NYSE: SJM) on Seeking Alpha. I have also written in the comments section about how selling a covered call on $SJM at current prices can boost overall investment returns.  

J. M. Smucker's Has Timeless Brands, but the stock has run up a lot. 
(Source: J. M. Smucker)

Nikkei Asia has published a fascinating article on how China cut public employees' paychecks. Many Chinese citizens are probably amazed and shocked to learn that some public employees make 200,000 yuan a year. Their paychecks are getting cut by about 25%. Cities in China were collecting revenue from land sales, but there are not many land sales with the indebted real estate market anymore. 

Indonesia is grappling with more meddling from China in the South China Sea. China is trying to assert itself in Asia.  

Note: Please pay for good journalism. When you support good journalism, you are keeping your freedom. Also, each day you will go to bed brighter. I read a lot of articles on Seeking Alpha every day. I subscribe to The Economist, The Financial Times, Barron's, Nikkei Asia, Bloomberg BusinessWeek, and The Wall Street Journal. I have a subscription to Seeking Alpha because I am a contributor on that site. 

Fun Fact: Nikkei - a Japanese company - owns The Financial Times.      

Monday, December 27, 2021

Comparing Inflation Using Producer Price Index (PPI)

The Bureau of Labor Statistics does a world-class job of compiling the producer price index (PPI) across multiple industries and product groups. I wanted to better understand inflation from one category - Fruit and Vegetable Canning. 

We know 2020 was a year like no other in world history. Demand slumped initially when the pandemic shut down the economy. But, the stimulus that was unleashed in the U.S. and across the world helped stimulate demand for products. The work-from-home trend added to the need for furniture and laptops. Comparing the producer price index between 2020 and 2021 may not accurately picture inflation. So, I have compared the change in the index between 2019 and 2021 for the fruit and vegetable canning industry. That shows a sharp increase in inflation (See Exhibit: Increase in Producer Price Index Between 2019 and 2021). The graph also shows the trend line and the equation. The slope for the change in PPI between 2019 and 2021 is 0.0037. The data used is for January to November for each year.   

Exhibit: Increase in Producer Price Index Between 2019 and 2021 (%)   

(Source: BLS, Author Calculations)

We compare this producer price index year-over-year change with change in PPI for the fruit and vegetable canning industry between 2007 and 2009 (See Exhibit: Increase in Producer Price Index Between 2007 and 2009 (%)). The year 2009 was when the world was coming out of the deep recession caused by the U.S. subprime mortgage crisis. Inflation for the fruit and vegetable canning category saw a year-over-year increase of 14% between 2007 and 2009. The slope was -0.0021 showing that the inflationary pressure tailed off by the end of the year in 2009. In 2021, the price index is still increasing.   

Exhibit: Increase in Producer Price Index Between 2007 and 2009 (%)  
(Source: BLS, Author Calculations)

In the first half of 2022, the stimulus-driven demand should be fading. That should lead to moderation in the growth of the producer price index.  
      

 

Sunday, December 12, 2021

Oracle: Excelling in Financial Engineering.

Oracle (ORCL) faced its first real challenge to its business model from Amazon AWS (AMZN). For a long time, Oracle's relational database has been the standard for many companies in the Global 2000. Oracle's database is still so entrenched in many corporations across the globe that they pay millions of dollars in Oracle license and support fees each year to keep the right to use their software. But, companies formed in the last 10-15 years have shunned the Oracle database. Instead, they have relied on myriad open-source database options and cheaper databases from other companies. The advent of AWS made it easy for any company to manage databases in the cloud. 


Oracle has lagged behind the prominent three cloud vendors in offering infrastructure-as-a-service (IaaS). The company has a reasonably significant market share position in SaaS software, where it competes against the likes of Salesforce (CRM), Workday (WDAY), and SAP (SAP). But, Oracle is still heavily dependent on revenue from its database software. Since Oracle cannot attract new customers to its database, it has resorted to using its existing database install base as an annuity business. In essence, the Oracle database software generates much rental income from its remaining customers.  


In the face of Oracle management's inability to innovate and compete, they have resorted to financial engineering to prop up their share price. A company innovating and competing well in the marketplace is most likely growing revenues. At the very least, revenue growth needs to keep up with GDP growth. Unfortunately, there is no revenue growth at Oracle. In the fiscal year ending May 31, 2011, Oracle had total sales of $35.622 billion. In the fiscal year ending May 31, 2021, Oracle had total sales of $40.479 billion. That equates to a 13.6% growth in revenue over 11 years. The 13.6% rate amounts to a compound annual growth rate (CAGR) of 1.16%

Exhibit: Oracle Annual Sales Revenue from Fiscal Year Ending on May 31, 2011

(Source: SEC.GOV)

How does a company show earnings per share (EPS) growth when revenue growth is nonexistent? Investors react positively to a growing EPS number. One way to show an ever-increasing EPS number is to repurchase the company shares and retire them. The repurchase transaction reduces the outstanding shares, and thus when stagnant net income is divided by outstanding shares, the resulting EPS number looks as if it is growing. 

The company has spent billions of dollars each year repurchasing its stock. The company has spent $137.65 billion in repurchasing its shares in 11 years. Initially, the share repurchases did not do much to the stock price. So, in recent years, the company has gotten even more brazen in buying back its stocks (See Exhibit: Annual Amount in Billions Spent by Oracle on Share Repurchase).  

Exhibit: Annual Amount in Billions Spent by Oracle on Share Repurchase 

(Source: SEC.GOV)
One way to analyze how much the company has spent on its repurchase is to compare its operating cash flow to the repurchase amount. The company had $155.212 billion in operating cash flow in 11 years and it spend 88.6% of that in buying back its own shares.
 
Exhibit: Oracle's Annual Operating Cash Flow

(Source: SEC.GOV)
In the end, Oracle's management led by Safra and the company's largest shareholder - Larry Ellison - benefit the most from these buybacks. Larry is now on the list of the top-10 wealthiest people in the world solely due to these buybacks. Due to these buybacks, the stock has risen a lot, and ordinary investors should prudently book profits. You do not want to be in this stock when the music stops.  





        

 

   

Paccar: Peak Demand For Trucks

 Paccar ( PCAR ) produced 185,900 trucks in 2022 and is on track for another record year in 2023. The company has experienced good revenue ...