Friday, July 1, 2011

Ross Stores Inc: $ROST cash flow valuation

Current Price: ~ $81/share
Projected Yield: ~ 1.10%

Ross Stores is the nation's second-largest off-price retailer of brand-name apparel and home accessories. The company operates about 990 Ross Dress for Less stores and roughly 70 dd's Discounts stores in the United States. Ross Dress for Less offers merchandise at prices that are 20%-60% below the regular prices of most department and specialty stores; dd's Discounts is a similar concept with lower-tier brands and prices that are 20% lower than those at Ross Dress for Less.

I estimated the firm's WACC today at 10.58% using the Capital Asset Pricing Model and the company's recent SEC filings.

Recent free cash flows and noted growth rates:
Year
FCF $Millions
2002
157
2003
199
2004
169
2005
149
2006
199
2007
283
2008
117
2009
359
2010
730
2011
474
TTM
292

Average Annual Growth FCF: ~ 32%
CAGR FCF: ~ 13%
Consensus Forecast Industry 5-Year Growth: ~ 15% per year
Consensus Forecast Company 5-Year Growth: ~ 12% per year

Scenario 1
Starting at $474 million FCF, assuming the company achieves a 5-year growth rate in FCF of 12% per year, and assuming that after the next five years, the company achieves no growth in FCF or 0% growth per year forever:

Discounted Cash Flow Valuation
Year
FCF $Millions
0
474
1
531
2
595
3
666
4
746
5
835
Terminal Value
8839

The firm's future cash flows, discounted at a WACC of 10.58%, give a present value for the entire firm (Debt + Equity) of $7807 million. If the firm's fair value of debt is estimated at $173 million, then the fair value of the firm's equity could be $7634 million.  $7634 million / 117 million outstanding shares is approximately $65 per share and a 20% margin of safety is $52/share.


Scenario 2
Starting at $474 million FCF, assuming the company achieves a 5-year growth rate in FCF of 12% per year, and then a growth rate in FCF of 2.75% per year forever:

Discounted Cash Flow Valuation
Year
FCF $Millions
0
474
1
531
2
595
3
666
4
746
5
835
Terminal Value
11941

The firm's future cash flows, discounted at a WACC of 10.58%, give a present value for the entire firm (Debt + Equity) of $9683 million. If the firm's fair value of debt is estimated at $173 million, then the fair value of the firm's equity could be $9510 million.  $9510 million / 117 million outstanding shares is approximately $81 per share and a 20% margin of safety is $65/share.


Sources
Disclosure: I have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours.

Texas Instruments Inc: $TXN cash flow valuation

Current Price: ~ $34/share
Projected Yield: ~ 1.58%


Dallas-based Texas Instruments generates 96% of its revenue from semiconductors and 4% from its well-known calculators. TI is the world's largest maker of analog chips, which are used to process real-world signals, such as sound and power. TI also has leading market share positions in digital signal processors, used in cell phones, as well as applications processors, where its chips are used to run software and applications in mobile devices.

I estimated the firm's WACC today at 12.09% using the Capital Asset Pricing Model and the company's recent SEC filings.

Recent free cash flows and noted growth rates:
Year
FCF $Millions
2001
29
2002
1190
2003
1351
2004
1848
2005
2442
2006
1188
2007
3720
2008
2567
2009
1890
2010
2621
TTM
2452

Average Annual Growth FCF ex-2001: ~ 28%
CAGR FCF ex-2001: ~ 10%
Consensus Forecast Industry 5-Year Growth: ~ 16% per year
Consensus Forecast Company 5-Year Growth: ~ 11% per year

Scenario 1
Starting at $2621 million FCF, assuming the company achieves a 5-year growth rate in FCF of 11% per year, and assuming that after the next five years, the company achieves no growth in FCF or 0% growth per year forever:

Discounted Cash Flow Valuation
Year
FCF $Millions
0
2621
1
2909
2
3229
3
3585
4
3979
5
4417
Terminal Value
40561

The firm's future cash flows, discounted at a WACC of 12.09%, give a present value for the entire firm (Debt + Equity) of $35,656 million. If the firm's fair value of debt is estimated at $3500 million, then the fair value of the firm's equity could be $32,156 million.  $32,156 million / 1160 million outstanding shares is approximately $28 per share and a 20% margin of safety is $22/share.


Scenario 2
Starting at $2621 million FCF, assuming the company achieves a 5-year growth rate in FCF of 11% per year, and then a growth rate in FCF of 3% per year forever:

Discounted Cash Flow Valuation
Year
FCF $Millions
0
2621
1
2909
2
3229
3
3585
4
3979
5
4417
Terminal Value
53953

The firm's future cash flows, discounted at a WACC of 12.09%, give a present value for the entire firm (Debt + Equity) of $43,226 million. If the firm's fair value of debt is estimated at $3500 million, then the fair value of the firm's equity could be $39,726 million.  $39,726 million / 1160 million outstanding shares is approximately $34 per share and a 20% margin of safety is $27/share.


Sources
Disclosure: I have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours.

W.W. Grainger Inc: $GWW cash flow valuation

Current Price: ~ $158/share
Projected Yield: ~ 1.72%

W.W. Grainger provides customers with facility maintenance products. The firm employs a multichannel strategy using physical stores, a website, and direct marketing to sell its products. Grainger generated revenue of $7.2 billion in 2010 and is based in Chicago.


I estimated the firm's WACC today at 11.21% using the Capital Asset Pricing Model and the company's recent SEC filings.

Recent free cash flows and noted growth rates:
Year
FCF $Millions
2001
410
2002
169
2003
320
2004
278
2005
320
2006
300
2007
271
2008
347
2009
590
2010
476
TTM
466

Average Annual Growth FCF: ~ 11%
CAGR FCF: ~ 2%
Consensus Forecast Industry 5-Year Growth: ~ 12% per year
Consensus Forecast Company 5-Year Growth: ~ 14% per year

Scenario 1
Starting at $476 million FCF, assuming the company achieves a 5-year growth rate in FCF of 14% per year, and assuming that after the next five years, the company achieves no growth in FCF or 0% growth per year forever:

Discounted Cash Flow Valuation
Year
FCF $Millions
0
476
1
543
2
619
3
705
4
804
5
916
Terminal Value
9317

The firm's future cash flows, discounted at a WACC of 11.21%, give a present value for the entire firm (Debt + Equity) of $8041 million. If the firm's fair value of debt is estimated at $500 million, then the fair value of the firm's equity could be $7541 million.  $7541 million / 69 million outstanding shares is approximately $109 per share and a 20% margin of safety is $87/share.


Scenario 2
Starting at $476 million FCF, assuming the company achieves a 5-year growth rate in FCF of 14% per year, and then a growth rate in FCF of 4.25% per year forever:

Discounted Cash Flow Valuation
Year
FCF $Millions
0
476
1
543
2
619
3
705
4
804
5
916
Terminal Value
15003

The firm's future cash flows, discounted at a WACC of 11.21%, give a present value for the entire firm (Debt + Equity) of $11,383 million. If the firm's fair value of debt is estimated at $500 million, then the fair value of the firm's equity could be $10,883 million.  $10,883 million / 69 million outstanding shares is approximately $158 per share and a 20% margin of safety is $126/share.


Sources
Disclosure: I have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours.