Performance report
Earnings in (Millions)
$60,000
$40,000
$20,000
Revenue
Expenses
Net income
Earnings before interest and taxes (EBIT)
Adjusted EBIT
Free cash flow to firm
Free cash flow to equity
($20,000)
($40,000)
($60,000)
1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007
Analysis prepared on Tuesday, January 06, 2009.
Earnings adjustments
We avoid GAAP earnings in our valuations because accrual accounting allows an entity to record revenues before cash is collected and record expenses that do not involve payments of cash. Accrual income almost never matches the actual cash generated from operations. As investors we're primarily interested in the actual cash that a company generates from operations free of any form of manipulation.
    To get there we estimate free cash flows to firm first by making a number major adjustments to earnings;
  • We capitalize research and development, accrual accounting requires that R&D be expensed as it occurs, but we recognize and appreciate that results from R&D creates growth. We treat it the same as all other investments by capitalizing it.
    values in Millions
    R&D asset lifetime10 years
    R&D expense$8,372
    R&D amortized$5,991
    R&D asset value$43,317
    The R&D asset value is used to adjust the book value of equity, this in turn is used in the return on equity calculations.
  • True one time charges muddle the growth picture of a stock because they tend to have a significant effect on profit but not earnings from operations. Valuations depend on our ability to predict future earnings growth, to get there we remove one time expenses from earnings.
  • The marginal tax rate is used to determine the taxes that aught to have been paid. Corporations have a number of ways to defer the taxes they pay, these deferments can have a significant impact on stated earnings. Eventually though they have to be paid causing another significant impact on earnings. In order to avoid these oscillations to earnings we use the marginal tax rate to determine the amount paid for taxes.
  • The other major adjustment to earnings that is made is by accounting for off-balance sheet item such as operating leases. Operating leases are treated as Operating expenses where they should be treated as financial expenses that have the same obligations as debt. Our second major adjustment therefore is in converting operating leases to their debt equivalent.
    Operating lease expenses and debt adjustment in (Millions)
    Current year$212
    Year one$192
    Year two$151
    Year three$99
    Year four$75
    Post year four$788
    Total$1,517
    Debt value$944
    Depreciation$94
    Debt Adjustment
    + Debt$7,314
    + Value of operating lease debt$944
    = Debt (Adjusted)$8,258
This leads to the following adjustments to earnings
Earnings Adjustement (values in Millions)
+ Earning before interest and taxes (EBIT):$9,167
+ R&D expense: $8,372
- R&D amortized: $5,991
+ Operating lease expense: $212
- Operating lease depreciation: $94
+ One time charges: $0
= Adjusted earnings before interest and taxes$11,666
- Taxes ( marginal rate = 35 % ): $4,083
= Adjusted earnings after taxes: $7,583
Now we have a better value for earnings that can be compared year to year to get a better picture of growth.
Cashflow analysis
Free cash flow is the actual cash generated from operations, it 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. Growth investments include investments in R&D, acquisitions, investments in operations (working capital investment) and investment in fixed capital.
Investment expenses (Millions)
+ R&D investment$8,372
+ Working capital investment$5,083
+ Fixed capital investment$1,880
+ Acquisitions$283
Investment depreciation and amortization (Millions)
- R&D amortized$5,991
- Fixed capital depreciation$5,200
- Operating lease depreciation$94
= Reinvested for future growth$4,333
The amount a company reinvests will determine future growth.
Free cash flow to firm derivation: (values in Millions)
+ Adjusted Earnings Before Interest and Taxes (EBIT):$11,666
- Marginal Tax Rate:35.00 %
= Adjusted Earning after taxes:$7,583
- Reinvested$4,333
= Free cash flow to firm (FCFF)$3,250
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 effect the adjustments to earnings have on the returns on capital and equity.
Returns on investment:
Return on capital (ROC)7.75 %
Return on equity (ROE)11.41 %
Adjusted ROC7.29 %
Adjusted ROE7.72 %
A good estimate for future growth is derived by multiplying the estimated future reinvestment rate with the estimated future return on capital.
Operating efficiency
The balance sheet provides insight into the company's operations. It contains all it's assets and liabilities. Of particular interest are it's current assets and liabilities, these are the short term assets and liabilities generated from it's operating activities. For a company that produces a product, for example, the current assets and liabilities are the items that the company uses to build the product such as inventory and raw materials, the money owed the company after selling the product to it's customers and the money it owes to creditors such as the raw material wholesalers as well as service providers. The following metrics are estimates that define how efficient a company is at executing the sales cycle.
  • Days inventory outstanding This metric measures how many days worth of inventory the company has in it's warehouse. It is measured as following DIO = (Inventory/Cost of sales) * 365.
  • Days payable outstandingPayables are the moneys owed to creditors such as the providers of the raw materials or service providers. Days payable outstanding is a measure of how long the company takes to pay its creditors. it is calculated as follows: DPO = (Accounts Payable/ Cost of sales )*365.
  • Days sales outstanding Sales are revenues, receivables are uncollected sales made on credit. A company has to collect sales as quickly as possible so it can use that money to create more products. This value is estimated as following: (Receivables / Revenues) * 365 or ( receivables/ Average sales per day).
  • Cash conversion cycle. This metric measures how quickly in days a company can produce a product from raw materials, sell it to a customer and collect those sales, it is estimated in the following way: CCC = DIO + DSO - DPO. a good way to measure how effective management is at making money is by looking at the cash conversion cycle over time. Warning flags are an increase of Inventory (can't sell product) and Receivables (can't collect on the goods sold on credit)
The following table shows the operating efficiency of PFIZER INC
Values in days20072006200520042003200220012000199919981997
Cash conversion cycle101143136156146828891144182236
Days inventory outstanding135205185223217242199201239319285
Days payable outstanding113136122137145230174180188219123
Days sales outstanding7975737074706369938374
Risk
Risk is an important measure that determines whether a stock is worth investing in and the associated fair value of that stock. The investor loses their entire investment when that company goes bankrupt. The measures below give an indication of bankruptcy risk and needs to be carefully assessed.
  • Current ratio The current ratio is a financial ratio that measures a companies ability to pay it's short term liabilities. When short term liabilities exceed short term assets the current ratio will be less than one and this indicates that a company may have problems meeting it's short-term obligations. It is calculated as follows: Current Ratio = Current Assets / Current Liabilities
  • Acid test or quick ratioT he acid test measures a companies ability to pay it's short term obligations quickly using cash and near cash. It is calculated as follows: Acid Test = (Cash + Investments) / Current Liabilities
  • Acid test (liberal) The more liberal version of the acid test allows a company to collect receivables and other assets except for inventory. Acid test (liberal) = (Current Assets - Inventory) / Current Liabilities
  • Debt to equity ratio The debt to equity ratio shows the proportion of debt and equity used to finance a company's assets. Debt and equity are both adjusted to account for Operating leases and R&D as described above. The debt to equity ratio is calculated by dividing Debt by Equity.
  • Interest coverage ratio The interest coverage ratio measures a firms ability to meet it's interest payments, it is calculated as follows: Interest coverage ratio = EBIT (adjusted) / Interest payment
  • Fixed charges coverage ratio Fixed charges include interest payments and operating lease expenses for this year it is calculated as follows. EBIT (adjusted) / (interest payment + operating lease expense)
The following table shows the risk ratios described above.
Risk ratios20072006200520042003200220012000199919981997
Current ratio2.152.201.471.501.261.341.351.431.221.381.29
Acid test1.171.300.780.750.510.680.630.570.480.550.30
Acid test (liberal)1.901.911.261.251.011.191.151.211.041.130.95
Debt to equity ratio (Adjusted)0.080.060.070.090.090.120.120.080.060.070.13
Interest coverage ratio (Adjusted)0.000.000.000.000.000.000.000.000.000.000.00
Fixed charges coverage ratio (Adjusted)55.03107.9671.2577.6554.0289.6997.3697.92126.11100.07111.78
Performance data
Revenue/Earnings data
Historic values
Earnings in (Millions)2007200620052004
Revenue$48,418$48,371$51,298$52,516
Expenses$42,033$38,251$43,260$41,206
Net income$8,144$19,337$8,085$11,361
Earnings before interest and taxes (EBIT)$9,167$21,329$11,509$14,026
Adjusted EBIT$11,666$24,724$16,458$19,490
Free cash flow to firm$3,250$16,398$9,008$6,009
Free cash flow to equity$6,098$22,830$11,113$9,914
Operating lease expenses
Historic values
Operating lease expense and debt conversion in (Millions)2007200620052004
Current year$212$229$231$251
Year one$192$200$217$240
Year two$151$174$181$218
Year three$99$113$141$165
Year four$75$72$103$150
Post year four$788$524$376$575
Total$1,517$1,312$1,249$1,599
Debt value$944$847$826$1,078
Depreciation$94$121$138$180
stock price calculator
Past growth rates
20 %
10 %
EBIT (adjusted)
Profit
Revenue
-10 %
-20 %
-30 %
-40 %
-50 %
-60 %
-70 %
-80 %
-90 %
all 10 years 6 years 4 years 2 years
Cashflow in (Millions)
$30,000
$20,000
$10,000
Profit
EBIT
FCFE
FCFF
($10,000)
($20,000)
($30,000)
($40,000)
($50,000)
($60,000)
2002 2003 2004 2005 2006 2007
Reinvestment in years past.
( values in Millions )2007200620052004
+ R&D investment$8,372$8,434$9,094$8,755
+ Working capital investment$5,083($2,530)($1,798)$1,659
+ Fixed Capital investment$1,880$2,050$2,106$2,601
+ Acquisitions$283$2,280$2,240$2,280
- R&D amortized$5,991$5,147$4,238$3,362
- Fixed capital depreciation$5,200$5,293$5,576$5,093
- Operating lease depreciation$94$121$138$180
= Reinvested$4,333($327)$1,690$6,660
Cashflow adjustments in years past.
( values in Millions )2007200620052004
Adjusted EBIT$11,666$24,724$16,458$19,490
Marginal tax rate35.00 %35.00 %35.00 %35.00 %
Adjusted EBIT(1 - t)$7,583$16,070$10,698$12,668
Reinvestment expense (gain)$4,333($327)$1,690$6,660
Free cash flow to firm (FCFF)$3,250$16,398$9,008$6,009
The rate of reinvestment in years past.
past reinvestment rates2 years4 years6 years10 yearsall
Reinvestment27.55 %30.87 %133.75 %108.05 %104.75 %
Working capital investment25.64 %11.89 %8.73 %5.34 %4.86 %
R&D investment81.44 %79.25 %81.43 %73.19 %71.89 %
Acquisitions8.96 %14.21 %101.14 %60.68 %55.17 %
Net capital investments18.77 %19.44 %20.22 %24.61 %24.99 %
Historic growth rates for important measures of earnings.
Past growth rates2 years4 years6 years10 yearsall
EBIT (adjusted)-71.77 %-8.41 %0.96 %9.52 %10.70 %
Profit-81.46 %1.36 %10.89 %15.52 %15.90 %
Revenue0.10 %-3.04 %5.46 %11.82 %12.64 %
Working capital.
( values in Millions )2007200620052004
Cash and equivalent$3,406$1,827$2,247$1,808
Short term investments$22,069$25,886$19,979$18,085
Accounts receivable$10,460$9,906$10,275$10,020
Inventory$5,302$6,111$6,039$6,660
Deferred taxes
Prepaid expenses$5,498$3,157$3,196$2,939
Other assets$114$62$160$182
Total assets$46,849$46,949$41,896$39,694
Accounts payable$4,433$4,074$3,998$4,090
Debt payments$5,825$2,434$11,589$11,266
Accrued Expenses$1,974$1,903$1,720$2,203
Tax payable$1,380$6,466$3,617$1,963
Other liabilities$8,223$6,512$7,524$6,936
Total liabilities$21,835$21,389$28,448$26,458
Working capital$25,014$25,560$13,448$13,236
Non cash working capital$5,364$281$2,811$4,609
Investment in working capital$5,083($2,530)($1,798)$1,659
Business Summary
Corporate Information
Executive Officers
Senior Vice PresidentBAGGER RICHARD H
Sr. Vice President, ControllerCANGIALOSI LORETTA V
Senior Vice PresidentFECZKO JOSEPH M
Vice ChairmanKATEN KAREN L
Chairman & CEOKINDLER JEFFREY B
Senior Vice PresidentLAMATTINA JOHN L
Senior Vice PresidentLEVIN ALAN G
Senior Vice PresidentMONTERO SYLVIA M
Senior Vice PresidentREAD IAN C
Senior Vice PresidentWAXMAN ALLEN P
Vice ChairmanSHEDLARZ DAVID L
Senior Vice PresidentCORR PETER B
Senior Vice PresidentHARDWICK CHARLES L
Senior VP - Human ResourcesJACKSON YVONNE R
Senior Vice PresidentMITCHELL JOHN W
Senior Vice PresidentRICCIARDI NATALE S
Senior Vice PresidentDAMELIO FRANK A
Senior Vice PresidentGOODMAN COREY S
Senior Vice PresidentMACKAY MARTIN
Senior Vice PresidentMCLEOD MARY S
Senior Vice PresidentSUSMAN SALLY
Senior Vice PresidentRINGO WILLIAM R
Senior Vice PresidentSCHULMAN AMY W
Board of Directors
CORNWELL W DON
KINDLER JEFFREY B
MCKINNELL HENRY A
MEAD DANA G
STEERE WILLIAM C JR
Ausiello Dennis A
GRAY III WILLIAM H
HOWELL WILLIAM R
LORCH GEORGE A
RAINES FRANKLIN D
SIMMONS RUTH J
VALLES JEAN PAUL
BROWN MICHAEL S
BURNS M ANTHONY
BURT ROBERT N
HORNER CONSTANCE J
IKENBERRY STANLEY
KILTS JAMES M
NORA JOHNSON SUZANNE M
Investors
Other investors
Earnings in (Millions)20072006200520042003200220012000199919981997
Revenue$48,418$48,371$51,298$52,516$45,188$32,373$32,259$29,574$16,204$13,544$12,504
Expenses$42,033$38,251$43,260$41,206$43,579$23,722$24,596$26,104$13,025$11,594$10,291
Net income$8,144$19,337$8,085$11,361$3,910$9,126$7,788$3,726$3,179$1,950$2,213
Earnings before interest and taxes (EBIT)$9,167$21,329$11,509$14,026$5,531$11,735$10,349$5,775$4,423$2,592$3,078
Adjusted EBIT$11,666$24,724$16,458$19,490$15,665$15,337$14,117$12,828$6,810$4,703$5,030
Free cash flow to firm$3,250$16,398$9,008$6,009($54,831)$5,932$4,590$3,383$46$929$921
Free cash flow to equity$6,098$22,830$11,113$9,914($51,259)$8,520$6,825$2,436$1,131$1,886$1,772
Adjusted debt$8,258$6,393$7,173$8,357$7,121$4,087$3,433$1,699$795$792$1,000
Adjusted equity$105,945$109,007$98,419$95,678$82,738$33,761$28,399$22,446$12,901$10,738$7,933
Adjusted depreciation$11,285$10,561$9,952$8,635$6,417$2,781$2,292$1,738$985$704$523
Total reinvestment$4,333($327)$1,690$6,660$65,013$4,037$4,586$4,955$4,381$2,128$2,348
Adjusted EBIT$11,666$24,724$16,458$19,490$15,665$15,337$14,117$12,828$6,810$4,703$5,030
Adjusted EBIT(1 - t)$7,583$16,070$10,698$12,668$10,182$9,969$9,176$8,338$4,426$3,057$3,270
FCFF$3,250$16,398$9,008$6,009($54,831)$5,932$4,590$3,383$46$929$921
FCFE$6,098$22,830$11,113$9,914($51,259)$8,520$6,825$2,436$1,131$1,886$1,772
Cash conversion cycle101143136156146828891144182236
Days inventory outstanding135205185223217242199201239319285
Days payable outstanding113136122137145230174180188219123
Days sales outstanding7975737074706369938374
Acid test1.171.300.780.750.510.680.630.570.480.550.30
liberal acid test1.901.911.261.251.011.191.151.211.041.130.95
Current ratio2.152.201.471.501.261.341.351.431.221.381.29
Fixed charges coverage ratio43.2493.1449.8255.8819.0768.6371.3744.0881.9155.1568.40
Interest coverage ratio0.000.000.000.000.000.000.000.000.000.000.00
 
Current Assets
Cash and equivalent$3,406$1,827$2,247$1,808$1,520$1,878$1,036$1,099$739$1,552$877
Short term investments$22,069$25,886$19,979$18,085$10,432$10,673$7,579$5,764$3,703$2,377$712
Accounts receivable$10,460$9,906$10,275$10,020$9,166$6,184$5,606$5,629$4,137$3,064$2,527
Inventory$5,302$6,111$6,039$6,660$5,837$2,678$2,741$2,702$1,654$1,828$1,773
Deferred taxes
Prepaid expenses$5,498$3,157$3,196$2,939$2,786$1,797$1,488$1,993$958$1,110$816
Other assets$114$62$160$182$1,571$115
Total assets$46,849$46,949$41,896$39,694$29,741$24,781$18,450$17,187$11,191$9,931$6,820
 
Current Liabilities
Accounts payable$4,433$4,074$3,998$4,090$3,901$2,546$2,398$2,415$1,300$1,256$765
Debt payments$5,825$2,434$11,589$11,266$8,818$8,669$6,265$4,289$5,001$2,729$2,255
Accrued Expenses$1,974$1,903$1,720$2,203$3,155$1,084$1,083$982$669$614$477
Tax payable$1,380$6,466$3,617$1,963$1,919$2,231$806$850$869$1,162$785
Other liabilities$8,223$6,512$7,524$6,936$5,864$4,025$3,088$3,445$1,346$1,434$1,023
Total liabilities$21,835$21,389$28,448$26,458$23,657$18,555$13,640$11,981$9,185$7,195$5,305
Working capital$25,014$25,560$13,448$13,236$6,084$6,226$4,810$5,206$2,006$2,736$1,515
Non cash working capital$5,364$281$2,811$4,609$2,950$2,344$2,460$2,632$2,565$1,536$2,181
Investment in working capital$5,083($2,530)($1,798)$1,659$606($116)($172)$67$1,029($645)
Second Opinions
Write your opinion
Use of this site constitutes acceptance of our User Agreement (c) 2008 EquityHive. L.L.C. All rights reserved.