Seeking Alpha

Eric Cota's  Instablog

Eric Cota
Send Message
I'm a value investor for the long term primarily focused on firms in the S&P 500 that produce solid free cash flow and pay dividends. I look for undervalued firms using a discounted cash flow model. I reinvest dividends and track performance on a total return, risk-adjusted basis. Five years... More
My blog:
Manzanita Drive
  • Johnson & Johnson: Cash Flow Update 0 comments
    Feb 28, 2012 1:21 PM | about stocks: JNJ
    Current Price: ~ $65/share
    Projected Yield: ~ 3.54%

    Johnson & Johnson ranks as the world's largest and most diverse health-care company. The company comprises three divisions: pharmaceutical, medical devices and diagnostics, and consumer. While the pharmaceutical division currently represents close to 36% of total sales, we expect patent losses and the Synthes acquisition to reduce this proportion to approximately 27% during the next 10 years, with the device segment picking up the majority of the share.

    Estimated WACC for the firm today is 7.16% using the Capital Asset Pricing Model and the company's recent SEC filings.

    Recent free cash flows and noted growth rates:

    YearFCF $Millions
    20026077
    20038333
    20048956
    20059245
    200611510
    200711939
    200811906
    200914206
    201014001
    201111405

    Average Annual Growth FCF: ~ 8%

    CAGR FCF: ~ 7%
    Consensus Forecast Industry 5-Year Growth: ~ 7% per year

    Consensus Forecast Company 5-Year Growth: ~ 6% per year

    Internal Growth Rate: ~ 3%

    Sustainable Growth Rate: ~ 6%

    Scenario 1
    Average FCF (2011, 2010) is $12703 million

    • Start at $12703 million FCF
    • Assume a 5-year growth rate in FCF of 6% per year, then no growth or 0% growth in FCF per year forever:

    Discounted Cash Flow Valuation

    YearFCF $Millions
    012703
    113465
    214273
    315129
    416037
    516999
    Terminal Value251581

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

    Scenario 2
    All else being equal,

    • Assume a 5-year growth rate in FCF of 2% per year, then 0% growth in FCF per year forever:

    Discounted Cash Flow Valuation

    YearFCF $Millions
    012703
    112957
    213216
    313481
    413750
    514025
    Terminal Value199730
    • Present Value of the entire firm (Debt + Equity): $196233 million
    • Value of Equity: $180648 million or $66/share
    • 20% margin of safety is $53/share

    Sources

    Morningstar.com

    Yahoo! Finance

    Johnson & Johnson

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

    Stocks: JNJ
Back To Eric Cota's Instablog HomePage »

Instablogs are blogs which are instantly set up and networked within the Seeking Alpha community. Instablog posts are not selected, edited or screened by Seeking Alpha editors, in contrast to contributors' articles.

Full index of posts »
Latest Followers

StockTalks

More »

Latest Comments


Instablogs are Seeking Alpha's free blogging platform customized for finance, with instant set up and exposure to millions of readers interested in the financial markets. Publish your own instablog in minutes.