United Rentals Inc Valuation – April 2019 #URI

Company Profile (excerpt from Reuters): United Rentals, Inc., incorporated on July 20, 1998, is a holding company. The Company is an equipment rental company, which operates throughout the United States and Canada. It operates through two segments: general rentals, and trench, power and pump. The general rentals segment includes the rental of construction, aerial, industrial and homeowner equipment and related services and activities. The trench, power and pump segment includes the rental of specialty construction products and related services. As of October 17, 2018, the Company had an integrated network of 1075 rental locations in North America and 11 in Europe. The Company conducts its operations through its subsidiaries, NES Rentals Holdings II, Inc., United Rentals (North America), Inc. (URNA) and subsidiaries of URNA.

 

Downloadable PDF version of this valuation:

ModernGraham Valuation of URI – April 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $9,549,825,287 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 0.83 Fail
3. Earnings Stability Positive EPS for 10 years prior Fail
4. Dividend Record Dividend Payments for 10 years prior Fail
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end 2565.90% Pass
6. Moderate PEmg Ratio PEmg < 20 8.87 Pass
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 2.90 Pass
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 0.83 Fail
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 -30.55 Fail
3. Earnings Stability Positive EPS for 5 years prior Pass
4. Dividend Record Currently Pays Dividend Fail
5. Earnings Growth EPSmg greater than 5 years ago Pass

 

Stage 2: Determination of Intrinsic Value

EPSmg $13.67
MG Growth Estimate 15.00%
MG Value $526.14
Opinion Undervalued
MG Grade C+
MG Value based on 3% Growth $198.16
MG Value based on 0% Growth $116.16
Market Implied Growth Rate 0.18%
Current Price $121.20
% of Intrinsic Value 23.04%

United Rentals, Inc. does not satisfy the requirements of either the Enterprising Investor or the more conservative Defensive Investor. The Defensive Investor is concerned with the low current ratio, insufficient earnings stability over the last ten years, and the poor dividend history. The Enterprising Investor has concerns regarding the level of debt relative to the current assets, and the lack of dividends. As a result, all value investors following the ModernGraham approach should explore other opportunities at this time or proceed cautiously with a speculative attitude.

As for a valuation, the company appears to be Undervalued after growing its EPSmg (normalized earnings) from $4.32 in 2015 to an estimated $13.67 for 2019. This level of demonstrated earnings growth outpaces the market’s implied estimate of 0.18% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value above the price.

At the time of valuation, further research into United Rentals, Inc. revealed the company was trading below its Graham Number of $128.67. The company does not pay a dividend. Its PEmg (price over earnings per share – ModernGraham) was 8.87, which was below the industry average of 32.68, which by some methods of valuation makes it one of the most undervalued stocks in its industry. Finally, the company was trading above its Net Current Asset Value (NCAV) of $-159.15.

United Rentals, Inc. receives an average overall rating in the ModernGraham grading system, scoring a C+.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) -$159.15
Graham Number $128.67
PEmg 8.87
Current Ratio 0.83
PB Ratio 2.90
Current Dividend $0.00
Dividend Yield 0.00%
Number of Consecutive Years of Dividend Growth 0

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $1,761,000,000
Total Current Liabilities $2,116,000,000
Long-Term Debt $10,844,000,000
Total Assets $18,133,000,000
Intangible Assets $6,142,000,000
Total Liabilities $14,730,000,000
Shares Outstanding (Diluted Average) 81,487,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $17.27
Dec2018 $13.12
Dec2017 $15.73
Dec2016 $6.45
Dec2015 $6.07
Dec2014 $5.15
Dec2013 $3.64
Dec2012 $0.79
Dec2011 $1.38
Dec2010 -$0.44
Dec2009 -$1.02
Dec2008 -$12.62
Dec2007 $3.25
Dec2006 $2.06
Dec2005 $1.80
Dec2004 -$0.88
Dec2003 -$3.29
Dec2002 -$4.88
Dec2001 $1.18
Dec2000 $1.89
Dec1999 $1.53

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $13.67
Dec2018 $11.01
Dec2017 $9.11
Dec2016 $5.34
Dec2015 $4.32
Dec2014 $3.00
Dec2013 $1.57
Dec2012 -$0.43
Dec2011 -$1.33
Dec2010 -$2.37
Dec2009 -$2.66
Dec2008 -$2.75
Dec2007 $1.66
Dec2006 $0.23
Dec2005 -$0.86
Dec2004 -$1.86
Dec2003 -$1.81

Recommended Reading:

Other ModernGraham posts about the company

United Rentals Inc Valuation – June 2018 $URI
United Rentals Inc Valuation – September 2017 $URI
United Rentals Inc Valuation – August 2016 $URI
United Rentals Inc. Analysis – Initial Coverage $URI

Other ModernGraham posts about related companies

Verisk Analytics Inc Valuation – March 2019 #VRSK
Global Payments Inc Valuation – March 2019 #GPN
Robert Half International Inc Valuation – March 2019 #RHI
Alliance Data Systems Corp Valuation – March 2019 #ADS
IHS Markit Ltd Valuation – February 2019 $INFO
Automatic Data Processing Inc Valuation – February 2019 $ADP
Fiserv Inc Valuation – February 2019 $FISV
Rollins Inc Valuation – February 2019 $ROL
Iron Mountain Inc Valuation – February 2019 $IRM
Cintas Corp Valuation – February 2019 $CTAS

Disclaimer:

The author did not hold a position in any company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

Twitter Inc Valuation – April 2019 #TWTR

Company Profile (excerpt from Reuters): Twitter, Inc. (Twitter), incorporated on April 19, 2007, offers products and services for users, advertisers, developers and data partners. The Company’s products and services include Twitter, Periscope, Promoted Tweets, Promoted Accounts and Promoted Trends.

 

Downloadable PDF version of this valuation:

ModernGraham Valuation of TWTR – April 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $26,509,140,015 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 4.69 Pass
3. Earnings Stability Positive EPS for 10 years prior Fail
4. Dividend Record Dividend Payments for 10 years prior Fail
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end -183.13% Fail
6. Moderate PEmg Ratio PEmg < 20 76.76 Fail
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 3.94 Fail
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 4.69 Pass
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 0.31 Pass
3. Earnings Stability Positive EPS for 5 years prior Fail
4. Dividend Record Currently Pays Dividend Fail
5. Earnings Growth EPSmg greater than 5 years ago Pass

 

Stage 2: Determination of Intrinsic Value

EPSmg $0.45
MG Growth Estimate 15.00%
MG Value $17.33
Opinion Overvalued
MG Grade F
MG Value based on 3% Growth $6.53
MG Value based on 0% Growth $3.83
Market Implied Growth Rate 34.13%
Current Price $34.54
% of Intrinsic Value 199.37%

Twitter Inc does not satisfy the requirements of either the Enterprising Investor or the more conservative Defensive Investor. The Defensive Investor is concerned with the insufficient earnings stability or growth over the last ten years, and the poor dividend history, and the high PEmg and PB ratios. The Enterprising Investor has concerns regarding the lack of earnings stability over the last five years, and the lack of dividends. As a result, all value investors following the ModernGraham approach should explore other opportunities at this time or proceed cautiously with a speculative attitude.

As for a valuation, the company appears to be Overvalued after growing its EPSmg (normalized earnings) from $-1.4 in 2015 to an estimated $0.45 for 2019. This level of demonstrated earnings growth does not support the market’s implied estimate of 34.13% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value below the price.

At the time of valuation, further research into Twitter Inc revealed the company was trading above its Graham Number of $11.08. The company does not pay a dividend. Its PEmg (price over earnings per share – ModernGraham) was 76.76, which was above the industry average of 33.53. Finally, the company was trading above its Net Current Asset Value (NCAV) of $4.84.

Twitter Inc scores quite poorly in the ModernGraham grading system, with an overall grade of F.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) $4.84
Graham Number $11.08
PEmg 76.76
Current Ratio 4.69
PB Ratio 3.94
Current Dividend $0.00
Dividend Yield 0.00%
Number of Consecutive Years of Dividend Growth 0

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $7,111,036,000
Total Current Liabilities $1,516,311,000
Long-Term Debt $1,730,922,000
Total Assets $10,162,572,000
Intangible Assets $1,272,294,000
Total Liabilities $3,356,978,000
Shares Outstanding (Diluted Average) 776,211,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $0.61
Dec2018 $1.56
Dec2017 -$0.15
Dec2016 -$0.65
Dec2015 -$0.79
Dec2014 -$0.96
Dec2013 -$3.41
Dec2012 -$0.68
Dec2011 -$1.60
Dec2010 -$0.15

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $0.45
Dec2018 $0.18
Dec2017 -$0.74
Dec2016 -$1.12
Dec2015 -$1.40
Dec2014 -$1.59
Dec2013 -$1.66
Dec2012 -$0.68
Dec2011 -$0.57
Dec2010 -$0.05

Recommended Reading:

Other ModernGraham posts about the company

Twitter Inc Valuation – June 2018 $TWTR

Other ModernGraham posts about related companies

eBay Inc Valuation – February 2019 $EBAY
Facebook Inc Valuation – January 2019 $FB
Shutterstock Inc Valuation – August 2018 $SSTK
Twitter Inc Valuation – June 2018 $TWTR
Salesforce.com Inc Valuation – June 2018 $CRM
eBay Inc Valuation – May 2018 $EBAY
Facebook Inc Valuation – March 2018 $FB
Salesforce.com Inc Valuation – April 2017 $CRM
Paypal Holdings Inc Valuation – Initial Coverage $PYPL
Netflix Inc Valuation – February 2017 $NFLX

Disclaimer:

The author did not hold a position in any company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

Illinois Tool Works Inc Valuation – April 2019 #ITW

Company Profile (excerpt from Reuters): Illinois Tool Works Inc., incorporated on June 19, 1961, is a manufacturer of a range of industrial products and equipment. The Company operates through seven segments: Automotive OEM; Food Equipment; Test & Measurement and Electronics; Welding; Polymers & Fluids; Construction Products, and Specialty Products. As of December 31, 2016, the Company had 85 divisions in 57 countries.

 

Downloadable PDF version of this valuation:

ModernGraham Valuation of ITW – April 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $48,387,279,394 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 1.63 Fail
3. Earnings Stability Positive EPS for 10 years prior Pass
4. Dividend Record Dividend Payments for 10 years prior Pass
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end 52.27% Pass
6. Moderate PEmg Ratio PEmg < 20 22.20 Fail
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 15.06 Fail
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 1.63 Pass
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 2.70 Fail
3. Earnings Stability Positive EPS for 5 years prior Pass
4. Dividend Record Currently Pays Dividend Pass
5. Earnings Growth EPSmg greater than 5 years ago Pass

 

Stage 2: Determination of Intrinsic Value

EPSmg $6.67
MG Growth Estimate 3.23%
MG Value $99.71
Opinion Overvalued
MG Grade B
MG Value based on 3% Growth $96.68
MG Value based on 0% Growth $56.67
Market Implied Growth Rate 6.85%
Current Price $148.01
% of Intrinsic Value 148.43%

Illinois Tool Works Inc. is suitable for the Enterprising Investor but not the more conservative Defensive Investor. The Defensive Investor is concerned with the low current ratio, high PEmg and PB ratios. The Enterprising Investor is only concerned with the level of debt relative to the net current assets. As a result, all Enterprising Investors following the ModernGraham approach should feel comfortable proceeding with the analysis.

As for a valuation, the company appears to be Overvalued after growing its EPSmg (normalized earnings) from $5.49 in 2015 to an estimated $6.67 for 2019. This level of demonstrated earnings growth does not support the market’s implied estimate of 6.85% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value below the price.

At the time of valuation, further research into Illinois Tool Works Inc. revealed the company was trading above its Graham Number of $41.22. The company pays a dividend of $3.56 per share, for a yield of 2.4%, putting it among the best dividend paying stocks today. Its PEmg (price over earnings per share – ModernGraham) was 22.2, which was below the industry average of 24.48, which by some methods of valuation makes it one of the most undervalued stocks in its industry. Finally, the company was trading above its Net Current Asset Value (NCAV) of $-17.6.

Illinois Tool Works Inc. performs fairly well in the ModernGraham grading system, scoring a B.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) -$17.60
Graham Number $41.22
PEmg 22.20
Current Ratio 1.63
PB Ratio 15.06
Current Dividend $3.56
Dividend Yield 2.41%
Number of Consecutive Years of Dividend Growth 20

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $5,778,000,000
Total Current Liabilities $3,542,000,000
Long-Term Debt $6,029,000,000
Total Assets $14,870,000,000
Intangible Assets $5,717,000,000
Total Liabilities $11,612,000,000
Shares Outstanding (Diluted Average) 331,400,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $7.70
Dec2018 $7.60
Dec2017 $4.86
Dec2016 $5.70
Dec2015 $5.13
Dec2014 $7.28
Dec2013 $3.74
Dec2012 $6.06
Dec2011 $4.19
Dec2010 $2.99
Dec2009 $1.89
Dec2008 $2.91
Dec2007 $3.36
Dec2006 $3.01
Dec2005 $1.30
Dec2004 $1.10
Dec2003 $1.66
Dec2002 $1.16
Dec2001 $1.32
Dec2000 $1.58
Dec1999 $1.38

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $6.67
Dec2018 $6.14
Dec2017 $5.39
Dec2016 $5.63
Dec2015 $5.49
Dec2014 $5.39
Dec2013 $4.23
Dec2012 $4.18
Dec2011 $3.18
Dec2010 $2.73
Dec2009 $2.57
Dec2008 $2.71
Dec2007 $2.44
Dec2006 $1.87
Dec2005 $1.30
Dec2004 $1.32
Dec2003 $1.43

Recommended Reading:

Other ModernGraham posts about the company

Illinois Tool Works Inc Valuation – June 2018 $ITW
Best Dividend Paying Stocks for Dividend Growth Investors – August 2017
Illinois Tool Works Inc Valuation – August 2017 $ITW
9 Best Stocks For Value Investors This Week – 7/8/16
Illinois Tool Works Inc Valuation – July 2016 $ITW

Other ModernGraham posts about related companies

Ingersoll-Rand PLC Valuation – January 2019 $IR
General Electric Co Valuation – November 2018 $GE
3M Co Valuation – November 2018 $MMM
ITT Inc Valuation – July 2018 $ITT
Illinois Tool Works Inc Valuation – June 2018 $ITW
Honeywell International Inc Valuation – June 2018 $HON
General Electric Co Valuation – February 2018 $GE
3M Company Valuation – February 2018 $MMM
Raven Industries Inc Valuation – September 2017 $RAVN
Illinois Tool Works Inc Valuation – August 2017 $ITW

Disclaimer:

The author did not hold a position in any company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

Pinnacle West Capital Corp Valuation – March 2019 #PNW

Company Profile (excerpt from Reuters): Pinnacle West Capital Corporation, incorporated on February 20, 1985, is a holding company that operates through its subsidiaries. The Company operates through regulated electricity segment, which consists of traditional regulated retail and wholesale electricity businesses and related activities, and includes electricity generation, transmission and distribution. The Company’s subsidiaries include Arizona Public Service Company (APS), which is a vertically-integrated electric utility that provides retail or wholesale electric service to the State of Arizona, with the exceptions of one-half of the Phoenix metropolitan area, the Tucson metropolitan area and Mohave County in northwestern Arizona.

PNW Chart

PNW data by YCharts

 

Downloadable PDF version of this valuation:

ModernGraham Valuation of PNW – March 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $10,824,428,063 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 0.56 Fail
3. Earnings Stability Positive EPS for 10 years prior Pass
4. Dividend Record Dividend Payments for 10 years prior Pass
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end 39.65% Pass
6. Moderate PEmg Ratio PEmg < 20 21.58 Fail
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 2.03 Pass
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 0.56 Fail
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 -6.41 Fail
3. Earnings Stability Positive EPS for 5 years prior Pass
4. Dividend Record Currently Pays Dividend Pass
5. Earnings Growth EPSmg greater than 5 years ago Pass

 

Stage 2: Determination of Intrinsic Value

EPSmg $4.47
MG Growth Estimate 3.33%
MG Value $67.81
Opinion Overvalued
MG Grade D+
MG Value based on 3% Growth $64.84
MG Value based on 0% Growth $38.01
Market Implied Growth Rate 6.54%
Current Price $96.52
% of Intrinsic Value 142.35%

Pinnacle West Capital Corporation does not satisfy the requirements of either the Enterprising Investor or the more conservative Defensive Investor. The Defensive Investor is concerned with the low current ratio, high PEmg ratio. The Enterprising Investor has concerns regarding the level of debt relative to the current assets. As a result, all value investors following the ModernGraham approach should explore other opportunities at this time or proceed cautiously with a speculative attitude.

As for a valuation, the company appears to be Overvalued after growing its EPSmg (normalized earnings) from $3.66 in 2015 to an estimated $4.47 for 2019. This level of demonstrated earnings growth does not support the market’s implied estimate of 6.54% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value below the price.

At the time of valuation, further research into Pinnacle West Capital Corporation revealed the company was trading above its Graham Number of $71.02. The company pays a dividend of $2.82 per share, for a yield of 2.9%, putting it among the best dividend paying stocks today. Its PEmg (price over earnings per share – ModernGraham) was 21.58, which was below the industry average of 23.71, which by some methods of valuation makes it one of the most undervalued stocks in its industry. Finally, the company was trading above its Net Current Asset Value (NCAV) of $-101.07.

Pinnacle West Capital Corporation scores quite poorly in the ModernGraham grading system, with an overall grade of D+.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) -$101.07
Graham Number $71.02
PEmg 21.58
Current Ratio 0.56
PB Ratio 2.03
Current Dividend $2.82
Dividend Yield 2.92%
Number of Consecutive Years of Dividend Growth 7

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $924,991,000
Total Current Liabilities $1,648,964,000
Long-Term Debt $4,638,232,000
Total Assets $17,664,202,000
Intangible Assets $262,902,000
Total Liabilities $12,315,497,000
Shares Outstanding (Diluted Average) 112,703,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $4.81
Dec2018 $4.54
Dec2017 $4.35
Dec2016 $3.95
Dec2015 $3.92
Dec2014 $3.58
Dec2013 $3.66
Dec2012 $3.45
Dec2011 $3.09
Dec2010 $3.27
Dec2009 $0.67
Dec2008 $2.40
Dec2007 $3.05
Dec2006 $3.27
Dec2005 $1.82
Dec2004 $2.66
Dec2003 $2.63
Dec2002 $1.76
Dec2001 $3.68
Dec2000 $3.56
Dec1999 $1.97

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $4.47
Dec2018 $4.22
Dec2017 $4.01
Dec2016 $3.80
Dec2015 $3.66
Dec2014 $3.49
Dec2013 $3.24
Dec2012 $2.88
Dec2011 $2.56
Dec2010 $2.37
Dec2009 $2.03
Dec2008 $2.69
Dec2007 $2.78
Dec2006 $2.58
Dec2005 $2.32
Dec2004 $2.67
Dec2003 $2.69

Recommended Reading:

Other ModernGraham posts about the company

Pinnacle West Capital Corp Valuation – June 2018 $PNW
Pinnacle West Corp Valuation – March 2017 $PNW
Pinnacle West Capital Corp Valuation – December 2015 Update $PNW
22 Companies in the Spotlight This Week – 11/29/14
Pinnacle West Capital Corporation Annual Valuation – 2014 $PNW

Other ModernGraham posts about related companies

NiSource Inc Valuation – March 2019 #NI
American Electric Power Company Inc Valuation – March 2019 #AEP
American Water Works Co Inc Valuation – March 2019 #AWK
Alliant Energy Corp Valuation – March 2019 #LNT
Consolidated Edison Inc Valuation – March 2019 #ED
Duke Energy Corp Valuation – March 2019 #DUK
Sempra Energy Valuation – March 2019 #SRE
Ameren Corp Valuation – March 2019 #AEE
NextEra Energy Inc Valuation – February 2019 $NEE
Dominion Energy Inc Valuation – February 2019 $D

Disclaimer:

The author did not hold a position in any company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

Mid-America Apartment Communities Inc Valuation – March 2019 #MAA

Company Profile (excerpt from Reuters): Mid-America Apartment Communities, Inc. (MAA), incorporated on September 22, 1993, is a multifamily focused, self-administered and self-managed real estate investment trust (REIT). The Company owns, operates, acquires and develops apartment communities primarily located in the Southeast and Southwest regions of the United States. It operates through three segments: Large market same store, Secondary market same store and Non-Same Store and Other. Its Large market same store communities are communities in markets with a population of at least one million and at least 1% of the total public multifamily REIT units that it has owned and that have been stabilized for at least a full 12 months. Its Secondary market same store communities are communities in markets with populations of more than one million but less than 1% of the total public multifamily REIT units or markets with populations of less than one million that it has owned and that have been stabilized for at least a full 12 months. Its Non-same store communities and other includes recent acquisitions and communities in development or lease-up communities.

 

Downloadable PDF version of this valuation:

ModernGraham Valuation of MAA – March 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $12,056,183,749 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 0.08 Fail
3. Earnings Stability Positive EPS for 10 years prior Pass
4. Dividend Record Dividend Payments for 10 years prior Pass
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end 52.37% Pass
6. Moderate PEmg Ratio PEmg < 20 44.26 Fail
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 1.89 Pass
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 0.08 Fail
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 -11.93 Fail
3. Earnings Stability Positive EPS for 5 years prior Pass
4. Dividend Record Currently Pays Dividend Pass
5. Earnings Growth EPSmg greater than 5 years ago Fail

 

Stage 2: Determination of Intrinsic Value

EPSmg $2.39
MG Growth Estimate -2.51%
MG Value $8.32
Opinion Overvalued
MG Grade D+
MG Value based on 3% Growth $34.69
MG Value based on 0% Growth $20.34
Market Implied Growth Rate 17.88%
Current Price $105.90
% of Intrinsic Value 1273.44%

Mid-America Apartment Communities Inc does not satisfy the requirements of either the Enterprising Investor or the more conservative Defensive Investor. The Defensive Investor is concerned with the low current ratio, high PEmg ratio. The Enterprising Investor has concerns regarding the level of debt relative to the current assets, and the lack of earnings growth over the last five years. As a result, all value investors following the ModernGraham approach should explore other opportunities at this time or proceed cautiously with a speculative attitude.

As for a valuation, the company appears to be Overvalued after seeing its EPSmg (normalized earnings) decline from $2.87 in 2015 to an estimated $2.39 for 2019. This level of demonstrated earnings growth does not support the market’s implied estimate of 17.88% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value below the price.

At the time of valuation, further research into Mid-America Apartment Communities Inc revealed the company was trading above its Graham Number of $48.81. The company pays a dividend of $3.69 per share, for a yield of 3.5%, putting it among the best dividend paying stocks today. Its PEmg (price over earnings per share – ModernGraham) was 44.27, which was below the industry average of 61.92, which by some methods of valuation makes it one of the most undervalued stocks in its industry. Finally, the company was trading above its Net Current Asset Value (NCAV) of $-43.18.

Mid-America Apartment Communities Inc scores quite poorly in the ModernGraham grading system, with an overall grade of D+.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) -$43.18
Graham Number $48.81
PEmg 44.27
Current Ratio 0.08
PB Ratio 1.89
Current Dividend $3.69
Dividend Yield 3.48%
Number of Consecutive Years of Dividend Growth 8

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $34,259,000
Total Current Liabilities $413,850,000
Long-Term Debt $4,528,328,000
Total Assets $11,323,781,000
Intangible Assets $3,900,000
Total Liabilities $4,951,592,000
Shares Outstanding (Diluted Average) 113,881,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $1.96
Dec2018 $1.93
Dec2017 $2.86
Dec2016 $2.69
Dec2015 $4.41
Dec2014 $1.97
Dec2013 $2.25
Dec2012 $2.56
Dec2011 $1.31
Dec2010 $0.56
Dec2009 $0.85
Dec2008 $0.64
Dec2007 $1.01
Dec2006 $0.29
Dec2005 $0.25
Dec2004 $0.50
Dec2003 -$0.07
Dec2002 -$0.11
Dec2001 $0.72
Dec2000 $0.78
Dec1999 $0.93

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $2.39
Dec2018 $2.66
Dec2017 $2.97
Dec2016 $2.94
Dec2015 $2.87
Dec2014 $1.98
Dec2013 $1.83
Dec2012 $1.47
Dec2011 $0.91
Dec2010 $0.70
Dec2009 $0.71
Dec2008 $0.61
Dec2007 $0.53
Dec2006 $0.25
Dec2005 $0.24
Dec2004 $0.27
Dec2003 $0.26

Recommended Reading:

Other ModernGraham posts about the company

Mid-America Apartment Communities Inc Valuation – June 2018 $MAA
Mid-America Apartment Communities Inc Valuation – Initial Coverage $MAA

Other ModernGraham posts about related companies

Extra Space Storage Inc Valuation – March 2019 #EXR
Digital Realty Trust Inc Valuation – March 2019 #DLR
Equity Residential Valuation – March 2019 #EQR
Prologis Inc Valuation – March 2019 #PLD
Duke Realty Corp Valuation – March 2019 $DRE
Realty Income Corp Valuation – February 2019 $O
Ventas Inc Valuation – February 2019 $VTR
SL Green Realty Corp Valuation – February 2019 $SLG
Regency Centers Corp Valuation – February 2019 $REG
Host Hotels & Resorts Inc Valuation – February 2019 $HST

Disclaimer:

The author did not hold a position in any company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

Fortune Brands Home & Security Inc Valuation – March 2019 #FBHS

Company Profile (excerpt from Reuters): Fortune Brands Home & Security, Inc., incorporated on June 9, 1988, is a holding company. The Company is a home and security products company. The Company operates through four segments: Cabinets, Plumbing, Doors and Security. The Company sells its products through a range of sales channels, including kitchen and bath dealers, wholesalers oriented toward builders or professional remodelers, industrial and locksmith distributors, do-it-yourself remodeling-oriented home centers and other retail outlets. The Company’s subsidiaries include MasterBrand Cabinets, Inc., Moen Incorporated, Fortune Brands Global Plumbing Group LLC, Fortune Brands Doors, Inc. and Fortune Brands Storage & Security LLC.

 

Downloadable PDF version of this valuation:

ModernGraham Valuation of FBHS – March 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $6,456,820,866 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 1.13 Fail
3. Earnings Stability Positive EPS for 10 years prior Fail
4. Dividend Record Dividend Payments for 10 years prior Fail
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end 915.73% Pass
6. Moderate PEmg Ratio PEmg < 20 15.79 Pass
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 3.00 Pass
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 1.13 Fail
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 9.32 Fail
3. Earnings Stability Positive EPS for 5 years prior Pass
4. Dividend Record Currently Pays Dividend Pass
5. Earnings Growth EPSmg greater than 5 years ago Pass

 

Stage 2: Determination of Intrinsic Value

EPSmg $2.91
MG Growth Estimate 15.00%
MG Value $112.04
Opinion Undervalued
MG Grade C-
MG Value based on 3% Growth $42.20
MG Value based on 0% Growth $24.74
Market Implied Growth Rate 3.64%
Current Price $45.94
% of Intrinsic Value 41.01%

Fortune Brands Home & Security Inc does not satisfy the requirements of either the Enterprising Investor or the more conservative Defensive Investor. The Defensive Investor is concerned with the low current ratio, insufficient earnings stability over the last ten years, and the poor dividend history. The Enterprising Investor has concerns regarding the level of debt relative to the current assets. As a result, all value investors following the ModernGraham approach should explore other opportunities at this time or proceed cautiously with a speculative attitude.

As for a valuation, the company appears to be Undervalued after growing its EPSmg (normalized earnings) from $1.24 in 2015 to an estimated $2.91 for 2019. This level of demonstrated earnings growth outpaces the market’s implied estimate of 3.64% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value above the price.

At the time of valuation, further research into Fortune Brands Home & Security Inc revealed the company was trading above its Graham Number of $34.08. The company pays a dividend of $0.8 per share, for a yield of 1.7% Its PEmg (price over earnings per share – ModernGraham) was 15.79, which was below the industry average of 24.02, which by some methods of valuation makes it one of the most undervalued stocks in its industry. Finally, the company was trading above its Net Current Asset Value (NCAV) of $-14.73.

Fortune Brands Home & Security Inc receives an average overall rating in the ModernGraham grading system, scoring a C-.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) -$14.73
Graham Number $34.08
PEmg 15.79
Current Ratio 1.13
PB Ratio 3.00
Current Dividend $0.80
Dividend Yield 1.74%
Number of Consecutive Years of Dividend Growth 6

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $1,686,100,000
Total Current Liabilities $1,492,100,000
Long-Term Debt $1,809,000,000
Total Assets $5,964,600,000
Intangible Assets $3,327,100,000
Total Liabilities $3,784,600,000
Shares Outstanding (Diluted Average) 142,500,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $3.35
Dec2018 $2.66
Dec2017 $3.03
Dec2016 $2.62
Dec2015 $1.93
Dec2014 $0.95
Dec2013 $1.34
Dec2012 $0.71
Dec2011 -$0.23
Dec2010 $0.41

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $2.91
Dec2018 $2.54
Dec2017 $2.31
Dec2016 $1.80
Dec2015 $1.24
Dec2014 $0.81
Dec2013 $0.64
Dec2012 $0.26
Dec2011 $0.03
Dec2010 $0.14

Recommended Reading:

Other ModernGraham posts about the company

Fortune Brands Home & Security Inc Valuation – June 2018 $FBHS
6 Best Stocks for Value Investors This Week – 3/11/17
Fortune Brands Home & Security Inc Valuation – Initial Coverage $FBHS

Other ModernGraham posts about related companies

Fortune Brands Home & Security Inc Valuation – June 2018 $FBHS
Tyco International PLC Valuation – November 2015 Update $TYC
ADT Stock Analysis – 2015 Annual Update $ADT
Tyco International Limited Annual Valuation – 2014 $TYC
ADT Corporation 2014 Annual Valuation $ADT

Disclaimer:

The author did not hold a position in any company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

Digital Realty Trust Inc Valuation – March 2019 #DLR

Company Profile (excerpt from Reuters): Digital Realty Trust, Inc., incorporated on March 9, 2004, is a real estate investment trust (REIT). The Company is engaged in the business of owning, acquiring, developing and operating data centers. It is focused on providing data center and colocation solutions for domestic and international tenants across a range of industry verticals ranging from financial services, cloud and information technology services, to manufacturing, energy, healthcare and consumer products. As of December 31, 2016, its portfolio consisted of 145 operating properties, including 14 properties held as investments in unconsolidated joint ventures, of which 104 are located throughout the United States, 32 are located in Europe, four are located in Asia, three are located in Australia and two are located in Canada.

 

Downloadable PDF version of this valuation:

ModernGraham Valuation of DLR – March 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $23,947,537,171 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 0.31 Fail
3. Earnings Stability Positive EPS for 10 years prior Pass
4. Dividend Record Dividend Payments for 10 years prior Pass
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end -13.22% Fail
6. Moderate PEmg Ratio PEmg < 20 96.72 Fail
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 2.20 Pass
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 0.31 Fail
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 -11.62 Fail
3. Earnings Stability Positive EPS for 5 years prior Pass
4. Dividend Record Currently Pays Dividend Pass
5. Earnings Growth EPSmg greater than 5 years ago Fail

 

Stage 2: Determination of Intrinsic Value

EPSmg $1.19
MG Growth Estimate -3.03%
MG Value $2.90
Opinion Overvalued
MG Grade D
MG Value based on 3% Growth $17.27
MG Value based on 0% Growth $10.13
Market Implied Growth Rate 44.11%
Current Price $115.23
% of Intrinsic Value 3975.43%

DIGITAL RLTY TR/SH does not satisfy the requirements of either the Enterprising Investor or the more conservative Defensive Investor. The Defensive Investor is concerned with the low current ratio, insufficient earnings growth over the last ten years, and the high PEmg ratio. The Enterprising Investor has concerns regarding the level of debt relative to the current assets, and the lack of earnings growth over the last five years. As a result, all value investors following the ModernGraham approach should explore other opportunities at this time or proceed cautiously with a speculative attitude.

As for a valuation, the company appears to be Overvalued after seeing its EPSmg (normalized earnings) decline from $1.49 in 2015 to an estimated $1.19 for 2019. This level of demonstrated earnings growth does not support the market’s implied estimate of 44.11% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value below the price.

At the time of valuation, further research into DIGITAL RLTY TR/SH revealed the company was trading above its Graham Number of $27.74. The company pays a dividend of $4.04 per share, for a yield of 3.5%, putting it among the best dividend paying stocks today. Its PEmg (price over earnings per share – ModernGraham) was 96.72, which was above the industry average of 61.92. Finally, the company was trading above its Net Current Asset Value (NCAV) of $-60.29.

DIGITAL RLTY TR/SH scores quite poorly in the ModernGraham grading system, with an overall grade of D.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) -$60.29
Graham Number $27.74
PEmg 96.72
Current Ratio 0.31
PB Ratio 2.20
Current Dividend $4.04
Dividend Yield 3.51%
Number of Consecutive Years of Dividend Growth 15

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $426,321,000
Total Current Liabilities $1,381,750,000
Long-Term Debt $11,101,479,000
Total Assets $23,766,695,000
Intangible Assets $7,612,161,000
Total Liabilities $12,908,485,000
Shares Outstanding (Diluted Average) 207,027,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $0.82
Dec2018 $1.21
Dec2017 $0.99
Dec2016 $2.20
Dec2015 $1.56
Dec2014 $0.99
Dec2013 $2.12
Dec2012 $1.48
Dec2011 $1.32
Dec2010 $0.68
Dec2009 $0.61
Dec2008 $0.38
Dec2007 $0.30
Dec2006 $0.47
Dec2005 $0.25
Dec2004 -$0.30

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $1.19
Dec2018 $1.38
Dec2017 $1.50
Dec2016 $1.73
Dec2015 $1.49
Dec2014 $1.41
Dec2013 $1.50
Dec2012 $1.09
Dec2011 $0.81
Dec2010 $0.54
Dec2009 $0.44
Dec2008 $0.31
Dec2007 $0.24
Dec2006 $0.16
Dec2005 $0.00
Dec2004 -$0.10

Recommended Reading:

Other ModernGraham posts about the company

Digital Realty Trust Inc Valuation – June 2018 $DLR
Digital Realty Trust Inc Valuation – Initial Coverage $DLR

Other ModernGraham posts about related companies

Equity Residential Valuation – March 2019 #EQR
Prologis Inc Valuation – March 2019 #PLD
Duke Realty Corp Valuation – March 2019 $DRE
Realty Income Corp Valuation – February 2019 $O
Ventas Inc Valuation – February 2019 $VTR
SL Green Realty Corp Valuation – February 2019 $SLG
Regency Centers Corp Valuation – February 2019 $REG
Host Hotels & Resorts Inc Valuation – February 2019 $HST
Vornado Realty Trust Valuation – January 2019 $VNO
Public Storage Valuation – January 2019 $PSA

Disclaimer:

The author did not hold a position in any company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

Equity Residential Valuation – March 2019 #EQR

Company Profile (excerpt from Reuters): Equity Residential, incorporated on July 21, 1992, is a real estate investment trust. The Company’s primary business is the acquisition, development and management of multifamily residential properties. Its segments include Boston, New York, Washington D.C., Southern California, San Francisco, Seattle and Other Markets. Southern California includes Los Angeles, San Diego and Orange County. Other Markets includes Phoenix. It is engaged in leasing of apartment units to residents. It focuses on rental apartment properties in urban and high-density suburban coastal gateway markets.

 

Downloadable PDF version of this valuation:

ModernGraham Valuation of EQR – March 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $27,685,836,753 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 0.13 Fail
3. Earnings Stability Positive EPS for 10 years prior Pass
4. Dividend Record Dividend Payments for 10 years prior Pass
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end -30.92% Fail
6. Moderate PEmg Ratio PEmg < 20 25.76 Fail
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 2.77 Fail
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 0.13 Fail
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 -27.19 Fail
3. Earnings Stability Positive EPS for 5 years prior Pass
4. Dividend Record Currently Pays Dividend Pass
5. Earnings Growth EPSmg greater than 5 years ago Pass

 

Stage 2: Determination of Intrinsic Value

EPSmg $2.91
MG Growth Estimate 0.36%
MG Value $26.77
Opinion Overvalued
MG Grade D+
MG Value based on 3% Growth $42.14
MG Value based on 0% Growth $24.70
Market Implied Growth Rate 8.63%
Current Price $74.85
% of Intrinsic Value 279.62%

Equity Residential does not satisfy the requirements of either the Enterprising Investor or the more conservative Defensive Investor. The Defensive Investor is concerned with the low current ratio, insufficient earnings growth over the last ten years, and the high PEmg and PB ratios. The Enterprising Investor has concerns regarding the level of debt relative to the current assets. As a result, all value investors following the ModernGraham approach should explore other opportunities at this time or proceed cautiously with a speculative attitude.

As for a valuation, the company appears to be Overvalued after growing its EPSmg (normalized earnings) from $2.84 in 2015 to an estimated $2.91 for 2019. This level of demonstrated earnings growth does not support the market’s implied estimate of 8.63% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value below the price.

At the time of valuation, further research into Equity Residential revealed the company was trading above its Graham Number of $26.99. The company pays a dividend of $2.16 per share, for a yield of 2.9%, putting it among the best dividend paying stocks today. Its PEmg (price over earnings per share – ModernGraham) was 25.76, which was below the industry average of 61.92, which by some methods of valuation makes it one of the most undervalued stocks in its industry. Finally, the company was trading above its Net Current Asset Value (NCAV) of $-25.87.

Equity Residential scores quite poorly in the ModernGraham grading system, with an overall grade of D+.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) -$25.87
Graham Number $26.99
PEmg 25.76
Current Ratio 0.13
PB Ratio 2.77
Current Dividend $2.16
Dividend Yield 2.89%
Number of Consecutive Years of Dividend Growth 1

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $47,442,000
Total Current Liabilities $371,694,000
Long-Term Debt $8,817,939,000
Total Assets $20,394,209,000
Intangible Assets $0
Total Liabilities $9,994,560,000
Shares Outstanding (Diluted Average) 384,481,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $1.18
Dec2018 $1.77
Dec2017 $1.63
Dec2016 $11.68
Dec2015 $2.36
Dec2014 $1.73
Dec2013 $5.16
Dec2012 $2.70
Dec2011 $2.98
Dec2010 $0.95
Dec2009 $1.27
Dec2008 $1.46
Dec2007 $3.39
Dec2006 $3.50
Dec2005 $2.79
Dec2004 $1.50
Dec2003 $1.57
Dec2002 $1.18
Dec2001 $1.34
Dec2000 $1.67
Dec1999 $1.14

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $2.91
Dec2018 $3.79
Dec2017 $4.70
Dec2016 $5.74
Dec2015 $2.84
Dec2014 $2.95
Dec2013 $3.25
Dec2012 $2.15
Dec2011 $1.92
Dec2010 $1.63
Dec2009 $2.14
Dec2008 $2.56
Dec2007 $2.93
Dec2006 $2.50
Dec2005 $1.89
Dec2004 $1.44
Dec2003 $1.40

Recommended Reading:

Other ModernGraham posts about the company

Equity Residential Valuation – June 2018 $EQR
11 Best Stocks for Value Investors This Week – 3/4/17
10 Low PE Stock Picks for the Defensive Investor – February 2017
Equity Residential Valuation – February 2017 $EQR
Most Undervalued Stocks of the S&P 500 – February 2017

Other ModernGraham posts about related companies

Duke Realty Corp Valuation – March 2019 $DRE
Realty Income Corp Valuation – February 2019 $O
Ventas Inc Valuation – February 2019 $VTR
SL Green Realty Corp Valuation – February 2019 $SLG
Regency Centers Corp Valuation – February 2019 $REG
Host Hotels & Resorts Inc Valuation – February 2019 $HST
Vornado Realty Trust Valuation – January 2019 $VNO
Public Storage Valuation – January 2019 $PSA
Macerich Co Valuation – January 2019 $MAC
HCP Inc Valuation – January 2019 $HCP

Disclaimer:

The author did not hold a position in any company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

DaVita Inc Valuation – March 2019 #DVA

Company Profile (excerpt from Reuters): DaVita Inc., formerly DaVita HealthCare Partners Inc., incorporated on April 4, 1994, operates two divisions: DaVita Kidney Care (Kidney Care) and DaVita Medical Group (DMG). The Kidney Care division consists of the Company’s the United States dialysis and related lab services, its ancillary services and strategic initiatives, including its international operations, and its corporate administrative support. Its DMG division is a patient- and physician-focused integrated healthcare delivery and management company that provides medical services to members primarily through capitation contracts with some of the nation’s health plans. The Company’s segments include U.S. dialysis and related lab services, DMG, and Other-Ancillary services and strategic initiatives. Its U.S. dialysis and related lab services line of business provide kidney dialysis services in the United States for patients suffering from chronic kidney failure, also known as end stage renal disease (ESRD). In addition, as of December 31, 2016, the Company operated or provided administrative services to 154 outpatient dialysis centers serving patients located in 11 countries outside of the United States.

Downloadable PDF version of this valuation:

ModernGraham Valuation of DVA – March 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $8,919,039,746 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 1.72 Fail
3. Earnings Stability Positive EPS for 10 years prior Pass
4. Dividend Record Dividend Payments for 10 years prior Fail
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end 17.39% Fail
6. Moderate PEmg Ratio PEmg < 20 18.25 Pass
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 2.29 Pass
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 1.72 Pass
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 2.31 Fail
3. Earnings Stability Positive EPS for 5 years prior Pass
4. Dividend Record Currently Pays Dividend Fail
5. Earnings Growth EPSmg greater than 5 years ago Pass

 

Stage 2: Determination of Intrinsic Value

EPSmg $2.94
MG Growth Estimate 3.21%
MG Value $43.95
Opinion Overvalued
MG Grade D
MG Value based on 3% Growth $42.70
MG Value based on 0% Growth $25.03
Market Implied Growth Rate 4.87%
Current Price $53.74
% of Intrinsic Value 122.29%

Davita Inc does not satisfy the requirements of either the Enterprising Investor or the more conservative Defensive Investor. The Defensive Investor is concerned with the low current ratio, insufficient earnings growth over the last ten years, and the poor dividend history. The Enterprising Investor has concerns regarding the level of debt relative to the net current assets, and the lack of dividends. As a result, all value investors following the ModernGraham approach should explore other opportunities at this time or proceed cautiously with a speculative attitude.

As for a valuation, the company appears to be Overvalued after growing its EPSmg (normalized earnings) from $2.43 in 2015 to an estimated $2.94 for 2019. This level of demonstrated earnings growth does not support the market’s implied estimate of 4.87% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value below the price.

At the time of valuation, further research into Davita Inc revealed the company was trading above its Graham Number of $45.04. The company does not pay a dividend. Its PEmg (price over earnings per share – ModernGraham) was 18.25, which was below the industry average of 53.13, which by some methods of valuation makes it one of the most undervalued stocks in its industry. Finally, the company was trading above its Net Current Asset Value (NCAV) of $-40.73.

Davita Inc scores quite poorly in the ModernGraham grading system, with an overall grade of D.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) -$40.73
Graham Number $45.04
PEmg 18.25
Current Ratio 1.72
PB Ratio 2.29
Current Dividend $0.00
Dividend Yield 0.00%
Number of Consecutive Years of Dividend Growth 0

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $8,424,159,000
Total Current Liabilities $4,891,161,000
Long-Term Debt $8,172,847,000
Total Assets $19,110,252,000
Intangible Assets $6,960,806,000
Total Liabilities $15,201,854,000
Shares Outstanding (Diluted Average) 166,413,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $4.05
Dec2018 $0.92
Dec2017 $3.47
Dec2016 $4.29
Dec2015 $1.25
Dec2014 $3.33
Dec2013 $2.95
Dec2012 $2.74
Dec2011 $2.48
Dec2010 $1.97
Dec2009 $2.03
Dec2008 $1.77
Dec2007 $1.78
Dec2006 $1.37
Dec2005 $1.10
Dec2004 $1.08
Dec2003 $0.78
Dec2002 $0.61
Dec2001 $0.48
Dec2000 $0.05
Dec1999 -$0.60

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $2.94
Dec2018 $2.48
Dec2017 $3.19
Dec2016 $3.01
Dec2015 $2.43
Dec2014 $2.91
Dec2013 $2.61
Dec2012 $2.36
Dec2011 $2.11
Dec2010 $1.88
Dec2009 $1.76
Dec2008 $1.55
Dec2007 $1.37
Dec2006 $1.11
Dec2005 $0.92
Dec2004 $0.76
Dec2003 $0.48

Recommended Reading:

Other ModernGraham posts about the company

DaVita Inc Valuation – June 2018 $DVA
Davita Inc Valuation – February 2017 $DVA
DaVita HealthCare Partners Inc Valuation – November 2015 Update $DVA
30 Companies in the Spotlight This Week – 11/15/14
DaVita Healthcare Partners Inc. Annual Valuation – 2014 $DVA

Other ModernGraham posts about related companies

Danaher Corp Valuation – March 2019 #DHR
Agilent Technologies Inc Valuation – March 2019 #A
ResMed Inc Valuation – March 2019 #RMD
Cooper Companies Inc Valuation – March 2019 #COO
Edwards Lifesciences Corp Valuation – March 2019 $EW
Boston Scientific Corporation Valuation – March 2019 $BSX
Baxter International Inc Valuation – March 2019 $BAX
Centene Corp Valuation – March 2019 $CNC
Abbott Laboratories Valuation – February 2019 $ABT
Becton Dickinson and Co Valuation – February 2019 $BDX

Disclaimer:

The author did not hold a position in any company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

Western Digital Corp Valuation – March 2019 #WDC

Company Profile (excerpt from Reuters): Western Digital Corporation (Western Digital), incorporated on October 26, 2000, is a developer, manufacturer and provider of data storage devices and solutions that address the needs of the information technology (IT) industry and the infrastructure that enables the proliferation of data in virtually every industry. The Company’s portfolio of offerings addresses three categories: Datacenter Devices and Solutions (capacity and performance enterprise hard disk drives (HDDs), enterprise solid state drives (SSDs), datacenter software and system solutions); Client Devices (mobile, desktop, gaming and digital video hard drives, client SSDs, embedded products and wafers), and Client Solutions (removable products, hard drive content solutions and flash content solutions). The Company also generates license and royalty revenue related to its intellectual property which is included in each of the three categories.

 

Downloadable PDF version of this valuation:

ModernGraham Valuation of WDC – March 2019

Stage 1: Is this company suitable for the Defensive Investor or the Enterprising Investor?

What kind of Intelligent Investor are you?

Defensive Investor; must pass 6 out of the following 7 tests.
1. Adequate Size of the Enterprise Market Cap > $2Bil $14,501,831,037 Pass
2. Sufficiently Strong Financial Condition Current Ratio > 2 2.24 Pass
3. Earnings Stability Positive EPS for 10 years prior Pass
4. Dividend Record Dividend Payments for 10 years prior Fail
5. Earnings Growth Increase of 33% in EPS in past 10 years using 3 year averages at beginning and end -73.33% Fail
6. Moderate PEmg Ratio PEmg < 20 31.02 Fail
7. Moderate Price to Assets PB Ratio < 2.5 OR PB*PEmg < 50 1.32 Pass
Enterprising Investor; must pass 4 out of the following 5 tests, or be suitable for the Defensive Investor.
1. Sufficiently Strong Financial Condition Current Ratio > 1.5 2.24 Pass
2. Sufficiently Strong Financial Condition Debt to NCA < 1.1 1.92 Fail
3. Earnings Stability Positive EPS for 5 years prior Pass
4. Dividend Record Currently Pays Dividend Pass
5. Earnings Growth EPSmg greater than 5 years ago Fail

 

Stage 2: Determination of Intrinsic Value

EPSmg $1.61
MG Growth Estimate -4.25%
MG Value $0.00
Opinion Overvalued
MG Grade D+
MG Value based on 3% Growth $23.30
MG Value based on 0% Growth $13.66
Market Implied Growth Rate 11.26%
Current Price $49.84
% of Intrinsic Value N/A

Western Digital Corp does not satisfy the requirements of either the Enterprising Investor or the more conservative Defensive Investor. The Defensive Investor is concerned with the insufficient earnings growth over the last ten years, and the poor dividend history, and the high PEmg ratio. The Enterprising Investor has concerns regarding the level of debt relative to the net current assets, and the lack of earnings growth over the last five years. As a result, all value investors following the ModernGraham approach should explore other opportunities at this time or proceed cautiously with a speculative attitude.

As for a valuation, the company appears to be Overvalued after seeing its EPSmg (normalized earnings) decline from $5.72 in 2015 to an estimated $1.61 for 2019. This level of demonstrated earnings growth does not support the market’s implied estimate of 11.26% annual earnings growth over the next 7-10 years. As a result, the ModernGraham valuation model, based on the Benjamin Graham value investing formula, returns an estimate of intrinsic value below the price.

At the time of valuation, further research into Western Digital Corp revealed the company was trading above its Graham Number of $23.31. The company pays a dividend of $2 per share, for a yield of 4%, putting it among the best dividend paying stocks today. Its PEmg (price over earnings per share – ModernGraham) was 31.02, which was below the industry average of 35.5, which by some methods of valuation makes it one of the most undervalued stocks in its industry. Finally, the company was trading above its Net Current Asset Value (NCAV) of $-25.12.

Western Digital Corp scores quite poorly in the ModernGraham grading system, with an overall grade of D+.

Stage 3: Information for Further Research

Net Current Asset Value (NCAV) -$25.12
Graham Number $23.31
PEmg 31.02
Current Ratio 2.24
PB Ratio 1.32
Current Dividend $2.00
Dividend Yield 4.01%
Number of Consecutive Years of Dividend Growth 0

Useful Links:

ModernGraham tagged articles Morningstar
Google Finance MSN Money
Yahoo Finance Seeking Alpha
GuruFocus SEC Filings

Most Recent Balance Sheet Figures

Balance Sheet Information 12/1/2018
Total Current Assets $9,742,000,000
Total Current Liabilities $4,350,000,000
Long-Term Debt $10,370,000,000
Total Assets $27,939,000,000
Intangible Assets $12,222,000,000
Total Liabilities $17,027,000,000
Shares Outstanding (Diluted Average) 290,000,000

Earnings Per Share History

EPS History
Next Fiscal Year Estimate $0.62
Jun2018 $2.20
Jun2017 $1.34
Jun2016 $1.00
Jun2015 $6.18
Jun2014 $6.68
Jun2013 $3.98
Jun2012 $6.58
Jun2011 $3.09
Jun2010 $5.93
Jun2009 $2.08
Jun2008 $3.84
Jun2007 $2.50
Jun2006 $1.76
Jun2005 $0.90
Jun2004 $0.69
Jun2003 $0.87
Jun2002 $0.34
Jun2001 -$0.31
Jun2000 -$2.69
Jun1999 -$5.51

Earnings Per Share – ModernGraham History

EPSmg History
Next Fiscal Year Estimate $1.61
Jun2018 $2.56
Jun2017 $3.11
Jun2016 $4.29
Jun2015 $5.72
Jun2014 $5.41
Jun2013 $4.63
Jun2012 $4.74
Jun2011 $3.71
Jun2010 $3.75
Jun2009 $2.51
Jun2008 $2.46
Jun2007 $1.63
Jun2006 $1.10
Jun2005 $0.68
Jun2004 $0.31
Jun2003 -$0.41

Recommended Reading:

Other ModernGraham posts about the company

Western Digital Corp Valuation – May 2018 $WDC
Western Digital Corporation Valuation – February 2017 $WDC
Best Stocks Below Their Graham Number – August 2016
Western Digital Corporation Valuation – August 2016 $WDC
10 Low PE Stock Picks for the Defensive Investor – August 2016

Other ModernGraham posts about related companies

Qualcomm Inc Valuation – March 2019 #QCOM
Ametek Inc Valuation – March 2019 #AME
Advanced Micro Devices Inc Valuation – February 2019 $AMD
Qorvo Inc Valuation – February 2019 $QRVO
FLIR Systems Inc Valuation – February 2019 $FLIR
NetApp Inc Valuation – February 2019 $NTAP
Applied Materials Inc Valuation – February 2019 $AMAT
Microchip Technology Inc Valuation – February 2019 $MCHP
Broadcom Inc Valuation – February 2019 $AVGO
KLA-Tencor Corp Valuation – January 2019 $KLAC

Disclaimer:

The author held a long position in WDC but did not hold a position in any other company mentioned in this article at the time of publication and had no intention of changing that position within the next 72 hours.  See my current holdings here.  This article is not investment advice; any reader should speak to a registered investment adviser prior to making any investment decisions.  ModernGraham is not affiliated with the company in any manner.  Please be sure to review our detailed disclaimer.

Back To Top