Wednesday, July 27, 2011

Union Pacific (UNP) - Valuation Analysis

Description

Union Pacific Corporation, incorporated in 1969, is engaged in the transportation business. The Company’s principal operating company, Union Pacific Railroad Company, links 23 states in the western two-thirds of the United States of America. Union Pacific Railroad Company serves many United States population centers and provides them with mode of freight transportation. Union Pacific Railroad Company’s business mix includes Agricultural Products, Automotive, Chemicals, Energy, Industrial Products and Intermodal. The Company has 31,953 route miles, linking Pacific Coast and Gulf Coast ports with the Midwest and the eastern United States gateways and providing several corridors to key Mexican gateways. It serves the western two-thirds of the United States and maintains coordinated schedules with other rail carriers to move freight to and from the Atlantic Coast, the Pacific Coast, the Southeast, the Southwest, Canada and Mexico.
Source: Reuters

Valuation

I estimated the intrinsic value of UNP to be $99.37.  Key assumptions included:

                Core growth rate: 17.0%
                Terminal growth rate: 5.0%
                Risk-adjusted discount rate: 11.1%

                Operating ratio: 70%
                CAPEX as % of sales: 15.0%
                Depreciation as % of sales: 9.0%
                Effective tax rate: 36.0%

                Working capital as % of sales: -7.5%

Given the current market price of $102.20, UNP is overvalued by 2.9% to its intrinsic value.  The risk-adjusted margin of safety was calculated to be 8.3%.  Since the stock is trading above the estimated intrinsic value, it would be prudent to wait until shares of UNP fell.  Based on the $99.37 intrinsic value and 8.3% risk-adjusted margin of safety, it might be prudent to consider shares at $91.14 or below.

Dividends

The dividend appears to be growing faster than earnings growth and has increased in recent years.  From 2000 to the 2010, the dividend has grown from $0.40 per share to $1.31 per share.  The compound annual growth rates for the past ten-, five-, and three-years are:

                Ten years: 14.1%
                Five years: 21.6%
                Three years: 20.7%

Although growing faster than earnings, the dividend appears to be sustainable.  Based on either net income, dividend payout ratio has not exceeded 50%.  A dividend payout ratio of less than 50% is a positive allowing for sustainable growth and a cushion for short-term earnings volatility.  Below is the dividend payout ratio for the past five years:

                2006: 20.0%
                2007: 19.6%
                2008: 20.6%
                2009: 28.8%
                2010: 21.7%

In the book, The Ultimate Dividend Playbook, Josh Peters discusses a model to calculate a stock’s prospective return.  The model is called the Dividend Drill Return Model (DDRM).  It is based on the premise that the dividend total return is equal to the yield plus dividend growth.  Dividend growth is then broken into core growth (the rate of growth for total profits) plus share change (reduction of shares due to share repurchase). 

Given a core growth rate of 17.0% and current dividend yield of 1.9%, UNP’s cost of growth is $6.06 per share.  After reducing this amount and dividends of $1.90 per share, the funding gap is $2.38.  UNP may need to borrow the $2.38 per share to reduce outstanding shares or increase expansion; this amount is forecasted to have a -2.3% impact on share price.  As a result, the DDRM forecasts the projected total return for UTX to be 16.5%.  Below is a breakdown of the total return:

                Core growth rate: 17.0%
                Dividend yield: 1.9%
                Funding surplus: -2.3%
                Total return: 16.5%

Summary

Based on a valuation $99.37, shares are trading at a 2.9% premium to the intrinsic value.  UNP has aggressively increased dividends and the dividend appears sustainable as the payout ratio is less than 50%.  Based on the DDRM, the projected total return for UNP is 16.5%.  Shares of UNP look attractive at lower prices than where UNP is currently trading at.

Sysco (SYY) - Valuation Analysis

Description

Sysco Corporation (Sysco), along with its subsidiaries and divisions, is a North American distributor of food and related products primarily to the foodservice or food-away-from-home industry. The Company provides products and related services to approximately 400,000 customers, including restaurants, healthcare and educational facilities, lodging establishments and other foodservice customers. Sysco provides food and related products to the foodservice or food-away-from-home industry. The Company has aggregated its operating companies into a number of segments, of which only Broadline and SYGMA are the main segments. Broadline operating companies distribute a line of food products and a variety of non-food products to their customers. SYGMA operating companies distribute a line of food products and a variety of non-food products to chain restaurant customer locations.

The products the Company distributes include a line of frozen foods, such as meats, fully prepared entrees, fruits, vegetables and desserts; full line of canned and dry foods; fresh meats; dairy products; beverage products; imported specialties, and fresh produce. Sysco also supplies a variety of non-food items, including paper products, such as disposable napkins, plates and cups; tableware, such as china and silverware; cookware, such as pots, pans and utensils; restaurant and kitchen equipment and supplies, and cleaning supplies. No single customer accounted for 10% or more of Sysco’s total sales during fiscal 2010.
Source: Reuters

Valuation

I estimated the intrinsic value of SYY to be $33.62.  Key assumptions included:

                Core growth rate: 7.5%
                Terminal growth rate: 3.0%
                Risk-adjusted discount rate: 11.5%

                Cost of sales: 81.0%
                Selling, general, & administrative costs as % of sales: 14.0%
                Research & development as % of sales: 0.0%
                CAPEX as % of sales: 1.5%
                Depreciation as % of sales: 1.0%
                Effective tax rate: 38.0%

                Day sales in receivables: 26
                Day sales of inventory: 22
                Days payable outstanding: 24

Given the current market price of $31.29, SYY is undervalued by 6.9% to its intrinsic value, which is a positive.  The risk-adjusted margin of safety was calculated to be 15.5%.  Since the actual margin of safety (6.9%) is less than the risk-adjusted margin of safety (6.9%), SYY may not be appropriate to buy at this time.

Dividends

The dividend appears to be growing faster than earnings growth, but has slowed in recent years.  From 2000 to the 2010, the dividend has grown from $0.24 per share to $1.00 per share.  The compound annual growth rates for the past ten-, five-, and three-years are:

                Ten years: 17.2%
                Five years: 13.6%
                Three years: 9.6%

Although growing faster than earnings, the dividend appears to be sustainable.  Based on net income, the dividend payout ratio exceed 50% once.  Based on free cash flow, the dividend payout ratio has fluctuated more ranging from 47.2% to 199.4%.  A dividend payout ratio of less than 50% is a positive allowing for sustainable growth and a cushion for short-term earnings volatility.  Below is the dividend payout ratio for the past five years:

                2006: 46.5%
                2007: 44.5%
                2008: 45.0%
                2009: 51.9%
                2010: 49.1%
In the book, The Ultimate Dividend Playbook, Josh Peters discusses a model to calculate a stock’s prospective return.  The model is called the Dividend Drill Return Model (DDRM).  It is based on the premise that the dividend total return is equal to the yield plus dividend growth.  Dividend growth is then broken into core growth (the rate of growth for total profits) plus share change (reduction of shares due to share repurchase). 

Given a core growth rate of 7.5% and current dividend yield of 3.3%, SYY’s cost of growth is $0.48 per share.  After reducing this amount and dividends of $1.04 per share, the funding surplus is $0.47.  SYY can use this $0.47 per share to reduce outstanding shares; this amount is forecasted to have a 1.5% impact on share price.  As a result, the DDRM forecasts the projected total return for UTX to be 12.3%.  Below is a breakdown of the total return:

                Core growth rate: 7.5%
                Dividend yield: 3.3%
                Funding surplus: 1.5%
                Total return: 12.3%

Summary

Based on a valuation $33.62, shares are trading at a 6.9% discount to the intrinsic value.  Given a risk-adjusted margin of safety of 15.5%, SYY could be considered a buy at $28.40.  SYY has a history of dividend increases and the dividend appears sustainable as the payout ratio is around 50%.  Based on the DDRM, the projected total return for SYY is 12.3%.

Tuesday, July 26, 2011

United Technologies (UTX) - Valuation Analysis

Description

UTX is a provider of technology products and services to the building systems and aerospace industries worldwide. The Company’s operating units include businesses with operations throughout the world. Otis, Carrier and UTC Fire and Security serve customers in the commercial and residential property industries worldwide. Carrier also serves commercial, industrial, transport refrigeration and food service equipment customers. Pratt and Whitney, Hamilton Sundstrand and Sikorsky serve commercial and government customers in both the original equipment and aftermarket parts and services markets of the aerospace industry.
Source: Reuters

Valuation

I estimated the intrinsic value of UTX to be $104.25.  Key assumptions included:

                Core growth rate: 10.0%
                Terminal growth rate: 3.0%
                Risk-adjusted discount rate: 12.0%

                Cost of sales: 73.0%
                Selling, general, & administrative costs as % of sales: 11.2%
                Research & development as % of sales: 3.0%
                CAPEX as % of sales: 2.5%
                Depreciation as % of sales: 2.0%
                Effective tax rate: 28.0%

                Day sales in receivables: 60
                Day sales of inventory: 75
                Days payable outstanding: 45

Given the current market price of $86.18 UTX is undervalued by 17.3% to its intrinsic value.  The risk-adjusted margin of safety was calculated to be 14.2%.  Since the actual margin of safety (17.7%) is greater than the risk-adjusted margin of safety (14.2%), this stock should be considered a buy.

Dividends

The dividend appears to be growing faster than earnings growth, but has slowed in recent years.  From 2000 to the 2010, the dividend has grown from $0.41 per share to $1.70 per share.  The compound annual growth rates for the past ten-, five-, and three-years are:

                Ten years: 17.0%
                Five years: 17.9%
                Three years: 13.3%

Although growing faster than earnings, the dividend appears to be sustainable.  Based on either net income or free cash flow, the dividend payout ratio has not exceeded 50%.  A dividend payout ratio of less than 50% is a positive allowing for sustainable growth and a cushion for short-term earnings volatility.  From 2006 to 2010, the dividend payout ratio based on net income has grown from 25.5% to 33.9%.  Below is the dividend payout ratio for the past five years:

                2006: 25.5%
                2007: 25.6%
                2008: 25.8%
                2009: 35.4%
                2010: 33.9%

In the book, The Ultimate Dividend Playbook, Josh Peters discusses a model to calculate a stock’s prospective return.  The model is called the Dividend Drill Return Model (DDRM).  It is based on the premise that the dividend total return is equal to the yield plus dividend growth.  Dividend growth is then broken into core growth (the rate of growth for total profits) plus share change (reduction of shares due to share repurchase). 

Given a core growth rate of 10.0% and current dividend yield of 2.2%, UTX’s cost of growth is $2.49 per share.  After reducing this amount and dividends of $1.92 per share, the funding surplus is $0.40.  UTX can use this $0.40 per share to reduce outstanding shares; this amount is forecasted to have a 0.5% impact on share price.  As a result, the DDRM forecasts the projected total return for UTX to be 12.6%.  Below is a breakdown of the total return:

                Core growth rate: 10.0%
                Dividend yield: 2.2%
                Funding surplus: 0.5%
                Total return: 12.6%

Summary

Based on a valuation $104.25, shares are trading at a 17.3% discount to the intrinsic value.  UTX has a history of stable dividend increases and the dividend appears sustainable as the payout ratio is less than 50%.  Based on the DDRM, the projected total return for UTX is 12.6%.