Performance report

Analysis prepared by Ruben Rotteveel on Tuesday, May 22, 2012.
for more information about the companies listed in this report, click here.

Opportunity

We first look at the growth oportunities these companies provide. To estimate future growth we look at historic growth, the investment in future growth through research and development, acquisitions and capital investments, how well management invests the corporations capital and equity as well as the ability for operations to sustain itself.

  • Historic Growth Rates: Revenue (chart it) In the past 5-10 years, Johnson & Johnson has had the most consisten growth in revenues and Profit (chart it) of all the companies being compared. Merck has had a resurgence of late, and Pfizer is extremely inconsistent. For comparison purposes we included a Celgene, a much smaller high growth company Revenue Growth (chart it)
  • Investment We can see that Johnson & Johnson consistently invests the most for the future.
  • Management Effectiveness

    Merck and BMS are surging of late probably because some past investments are finally bearing fruit and decrease in recent investments. J&J belongs amongst the best for the past five years and probably into the future.

  • Conclusion
    • Johnson & Johnson provides the best opportunity for the conservative long term investor. The risks of default etc. are minimal The biggest risk to your investment in J&J is paying too much for it. Comparing current market prices agains this valuation suggests that J&J is fairly valued at this moment. My policy is to wait until the price is discounted by at least 10% - 20% so I will wait for that to happen.
    • Celgene however is much more exciting as a potential high growth investment, with no real risk of default. It's the next on my list to value. Stay tuned.

Investment rationale/Risk

The biggest risk to any investment is the complete loss of that investment through bankrupcy. That's why we look at leverage risk first. In addition we want to make sure that a corporation can fund it's near term liabilities without having to go to the credit markets.

  • Leverage risk Let's look at Debt or Leverage (chart it), Debt to Equity (chart it) and Debt to Capital (chart it) ratios.

    Johnson & Johnson's debt has increased dramatically of late, but compared against equity it's average to what the others have. Considering how cheap loans are these days it's a smart way to get cheap capital. With it's reputation JNJ is probably amongst the few that can get loans easily in the current financial climate.

    Notice that Celgene has no debt.

  • Short term Risk
      First, the risk ratio's.
    • The acid test determines a company's ability to pay near term liabilities with it's current assets. The first only looks at cash and cash equivalentsAcid test (chart it) and the more liberal version that assumes inventory and accounts payable can be used to cover liabilities as well Acid test 2(chart it). Higher values are better, above 2 is preferred.
    • We also want to know if a company is consistently able to meet it's financial obligations, in particular it's interest payments.Interest coverage ratio(chart it) J&J's negative values are anomalies caused by interest revenues generated in those periods.
  • Operations We always want to look at operations, are products moving and are vendors paying for product? The metric that captures this best is the cash conversion cycle Cash conversion cycle (chart it). It consists of the following.

Earnings adjustments

The valuation is based on a free cash flow to firm valuation. Free cash flow is similar in concept to Warren Buffets concept of owner earnings. It is determined by subtracting from adjusted earnings the amount a company invests in growth (see table above). Growth investment includes investments in R&D, acquisitions, investments in operations (working capital investment) and investment in fixed capital.
Investment expenses (Millions)
+ R&D investment$6,986
+ Working capital investment$7,230
+ Fixed capital investment$2,365
+ Acquisitions$8,985
Investment depreciation and amortization (Millions)
- R&D amortized$5,400
- Fixed capital depreciation$2,774
- Operating lease depreciation$0
= Reinvested for future growth$17,392
Earnings Adjustement (values in Millions)
+ Earning before interest and taxes (EBIT):$16,116
+ R&D expense: $6,986
- R&D amortized: $5,400
+ Operating lease expense: $0
- Operating lease depreciation: $0
+ One time charges: $0
= Adjusted earnings before interest and taxes$17,702
- Taxes ( marginal rate = 35 % ): $6,196
= Adjusted earnings after taxes: $11,506
Free cash flow to firm derivation: (values in Millions)
+ Adjusted Earnings Before Interest and Taxes (EBIT):$17,702
- Marginal Tax Rate:35.00 %
= Adjusted Earning after taxes:$11,506
- Reinvested$17,392
= Free cash flow to firm (FCFF)($5,886)
After equity is adjusted to include the R&D asset value and debt to include the Operating lease liabilities debt equivalent, managements effectiveness can be measured more accurately. The below shows the enormous effect the two adjustements to earnings have on the returns on capital and equity.
Returns on investment:
Return on capital (ROC)10.86 %
Return on equity (ROE)13.61 %
Adjusted ROC9.38 %
Adjusted ROE9.67 %

The table below shows amounts invested for growth in past years.

Reinvestment ( values in Millions )20092008200720062005
+ R&D investment$6,986$7,758$8,487$7,684$5,221
+ Working capital investment$7,230$255$138($4,320)($525)
+ Fixed Capital investment$2,365$3,066$2,942$2,666$2,175
+ Acquisitions$8,985$1,214$1,388$41,950$3,177
- R&D amortized$5,400$4,838$4,204$3,626$3,267
- Fixed capital depreciation$2,774----$2,177$2,124
= Reinvested$17,392$7,455$8,751$42,177$4,657
Free cash flow to firm calculation( values in Millions )20092008200720062005
Adjusted EBIT$17,702$40,758$33,556$17,879$14,784
Marginal tax rate35 %35 %35 %35 %35 %
Adjusted EBIT after tax$11,506$26,493$21,812$11,622$9,610
- Reinvestment expense (gain)$17,392$7,455$8,751$42,177$4,657
= Free cash flow to firm (FCFF)($5,886)$19,038$13,060($30,556)$4,953
R&D asset lifetime: 10 years20092008200720062005
R&D expense$6,986$7,758$8,487$7,684$5,221
R&D amortized$5,400$4,838$4,204$3,626$3,267
R&D asset value$36,611$35,025$32,106$27,822$23,764

Management Performance

Return on investment20092008200720062005
Return on equity (ROE)13.61 %42.02 %67.57 %34.74 %31.67 %
Return on capital (ROC)10.86 %29.17 %40.56 %24.27 %25.99 %
Adjusted return on equity9.67 %25.38 %36.95 %25.25 %22.44 %
Adjusted return on capital9.38 %24.54 %32.98 %22.17 %20.14 %

See the adjustment section below for details on how the adjustments were made.

Past growth rates2 years4 years6 years10 yearsall
EBIT (adjusted)-27.12 %10.45 %13.45 %13.81 %13.38 %
Net income-31.00 %14.48 %18.66 %17.24 %15.97 %
Revenue0.64 %6.59 %7.65 %8.73 %9.22 %

List of securities mentioned in this stock report

Johnson & Johnson Celgene Pfizer Abbott Laboratories Merck Bristol Myers Squib
Share
Corporate Information
Business Address
ONE JOHNSON & JOHNSON PLZ
NEW BRUNSWICK, NJ 08933
Phone: (732) 524-2455
Executive Officers
VP, Strategy & GrowthMember, Executive CommitteeVALERIANI NICHOLAS J
Chairman/CEOWELDON WILLIAM C
Vice ChairmanPOON CHRISTINE A
Vice ChairmanDARRETTA ROBERT J
VP, General CounselDEYO RUSSELL C
Member, Executive CommitteeMcCoy Sherilyn S
Member, Executive CommitteeGOGGINS COLLEEN A
Chief Financial OfficerCaruso Dominic J
Member, Executive CommitteeGorsky Alex
Executive Committee MemberScodari Joseph C
Member, Executive CommitteeDORMER MICHAEL J
Member, Executive CommitteeCasey Donald M Jr.
VP, Human ResourcesFoster-Cheek Kaye I
Executive Committee MemberPETERSON PER A
Corporate ControllerCOSGROVE STEPHEN J
VP, Worldwide Human ResourcesFasolo Peter
Member, Executive CommitteeHEISEN JOANN HEFFERNAN
VP, General CounselUllmann Michael H
Board of Directors
Other investors
VP, Strategy & GrowthMember, Executive CommitteeVALERIANI NICHOLAS J

Key Earnings Metrics

Earnings ( values in Millions )20092008200720062005200420032002200120001999199819971996199519941993
Revenue$61,897$63,747$61,095$53,324$47,348$41,862$41,862$36,298$32,317$29,846$23,995$22,629$22,629$21,620$18,842$14,138$13,753
Cost of sales$18,447$18,511$17,751$15,057$13,422$12,176$12,176$10,447$9,581$8,908----$7,152$7,018$6,235$4,791$4,678
Gross profit$43,450$45,236$43,344$38,267$33,926$29,686$29,686$25,851$22,736$20,938$23,995$22,629$15,477$14,602$12,607$9,347$9,075
Sales, general and administrative$19,801$21,490$20,451$17,433$15,860$14,131$14,131$12,216$11,260$11,218$9,027$8,715$8,715$8,394$7,462$5,771$5,671
Research and development$6,986$7,758$8,487$7,684$5,221$5,602$5,602$4,146$3,696$3,171$2,634$2,140$2,140$1,905$1,634$1,182$1,127
Restructuring$1,073--$745--------------$8,157$7,152----------
Other expenses--------$15----$294$185--$143$129$129$284$166$16$39
Operating income$15,590$15,988$13,661$13,150$12,830$9,953$9,953$9,195$7,595$6,549$4,034$4,493$4,493$4,019$3,345$2,378$2,238
Other income$526$21,850$15,612$671--$385$385----$94--------------
Net interest expense (income)$361----($766)($8)$30$30($96)($303)($225)($148)($83)($83)($14)$28$46$31
Income before taxes$15,755$37,838$29,273$14,587$12,838$10,308$10,308$9,291$7,898$6,868$4,182$4,576$4,576$4,033$3,317$2,332$2,207
Taxes$3,489$3,980$2,707$3,534$4,329$3,111$3,111$2,694$2,230$1,915$1,179$1,273$1,273$1,146$914$545$582
Income before extraordinary items$12,266$33,858$26,566$11,053$8,509$7,197$7,197$6,597$5,668$4,953$3,003$3,303$3,303$2,887$2,403$1,787$1,625
Cumulative effect of accounting change--------------------------------$595
Net income$12,266$33,858$26,566$11,053$8,509$7,197$7,197$6,597$5,668$4,953$3,003$3,303$3,303$2,887$2,403$1,787$1,030
 
Current Assets
Cash and equivalent$15,810$19,425$12,809$4,083$9,203$5,377$5,377$2,894$3,758$4,278$1,994$2,753$2,753$2,011$1,201$372$745
Short term investments----------------------------------
Accounts receivable$9,646$9,646$9,719$8,712$6,831$6,574$6,574$5,399$4,630$4,601$3,752$3,329$3,329$3,251$2,903$2,107$1,855
Inventory$5,180$5,180$5,052$4,889$3,744$3,588$3,588$3,303$2,992$2,905$2,898$2,516$2,516$2,498$2,276$1,717$1,742
Deferred taxes$2,793$2,793$3,430$2,094$1,737$1,526$1,526$1,419$1,192$1,174$1,183$831$831$711$717$399$327
Prepaid expenses$2,497----$3,196$2,124$1,784$1,784$1,670$1,687$1,254$870$988$988$774$678$518$621
Other assets$7,230$2,497$3,367$1$7,841$8,471$4,146$4,581$4,214$2,479$2,503$500$146$125$163$1,567$133
Total current assets$43,156$39,541$34,377$22,975$31,480$27,320$22,995$19,266$18,473$16,691$13,200$10,917$10,563$9,370$7,938$6,680$5,423
 
Current Liabilities
Accounts payable$5,541$13,385$14,883$5,691$5,227$4,966$4,966$3,621$2,838$2,122$1,877$1,753$1,753$1,743$1,602$901$910
Debt payments$6,318$6,318$3,732$4,579$280$1,139$1,139$2,117$565$1,489$2,753$714$714$872$321$915$1,032
Accrued Expenses$9,872----$8,891$8,420$7,343$7,343$5,711$4,104$3,322$3,457$2,590$2,590$2,332$2,241$1,283$1,302
Tax payable--$2,793$3,430----------$537$322$206$226$226$237$224$113$183
Other liabilities--($765)($1,193)----$479----------$131------$1,054--
Total current liabilities$21,731$21,731$20,852$19,161$13,927$13,927$13,448$11,449$8,044$7,255$8,293$5,414$5,283$5,184$4,388$4,266$3,427
Working capital$21,425$17,810$13,525$3,814$17,553$13,393$9,547$7,817$10,429$9,436$4,907$5,503$5,280$4,186$3,550$2,414$1,996
Non cash working capital$11,933$4,703$4,448$4,310$8,630$9,155$5,309$7,040$7,236$6,647$5,666$3,464$3,241$3,047$2,670$2,957$2,283
Investment in working capital$7,230$255$138($4,320)($525)$3,846($1,731)($196)$589$981$2,202$223$194$377($287)$674--
Second Opinions
Write your opinion
Use of this site constitutes acceptance of our User Agreement © 2008 - 2012 EquityHive. L.L.C. All rights reserved.