User Report

FINANCIAL ABBOT.xlsx

Balance Sheets

Abbott Laboratories ANNUAL BALANCE SHEET
TICKER: ABT
SIC: 2834
GICS: 35101010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
ASSETS
Cash & Equivalents $ 6,125.00 $ 4,460.00 $ 8,098.00 $ 15,173.98 $ 8,097.36 $ 7,323.94 $ 9,932.05 $ 5,079.63 $ 2,820.83 $ 1,373.44 $ 2,956.09
Net Receivables $ 3,418.00 $ 3,586.00 $ 3,986.00 $ 7,612.86 $ 7,683.92 $ 7,184.03 $ 6,541.94 $ 5,465.66 $ 4,946.88 $ 4,231.14 $ 3,576.79
Inventories $ 2,599.00 $ 2,643.00 $ 2,693.00 $ 3,792.31 $ 3,284.25 $ 3,188.73 $ 3,264.88 $ 2,775.85 $ 2,951.44 $ 2,806.42 $ 2,541.98
Prepaid Expenses @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF
Other Current Assets $ 2,013.00 $ 4,572.00 $ 4,470.00 $ 4,743.43 $ 4,703.25 $ 4,620.82 $ 3,575.03 $ 3,721.43 $ 3,323.59 $ 2,870.89 $ 2,311.16
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Assets $ 14,155.00 $ 15,261.00 $ 19,247.00 $ 31,322.58 $ 23,768.77 $ 22,317.53 $ 23,313.89 $ 17,042.56 $ 14,042.73 $ 11,281.88 $ 11,386.03
Gross Plant, Property & Equipment $ 12,383.00 $ 12,632.00 $ 12,870.00 $ 18,928.89 $ 18,016.56 $ 17,374.30 $ 16,486.91 $ 15,188.67 $ 15,597.80 $ 14,401.94 $ 12,760.42
Accumulated Depreciation $ 6,653.00 $ 6,697.00 $ 6,965.00 $ 10,865.84 $ 10,142.61 $ 9,403.35 $ 8,867.42 $ 7,969.51 $ 8,079.65 $ 7,455.50 $ 6,757.28
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Net Plant, Property & Equipment $ 5,730.00 $ 5,935.00 $ 5,905.00 $ 8,063.05 $ 7,873.96 $ 7,970.96 $ 7,619.49 $ 7,219.17 $ 7,518.15 $ 6,946.44 $ 6,003.14
Investments at Equity $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 159.00 $ 162.00 $ 167.00
Other Investments $ 4,041.00 $ 229.00 $ 119.00 $ 273.60 $ 378.23 $ 302.05 $ 1,132.87 $ 1,073.74 $ 1,125.26 $ 1,229.87 $ 134.01
Intangibles $ 15,200.00 $ 16,265.00 $ 15,507.00 $ 24,362.41 $ 25,695.02 $ 28,081.71 $ 19,492.16 $ 15,138.47 $ 15,849.32 $ 15,852.90 $ 9,960.89
Deferred Charges $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Assets $ 2,121.00 $ 3,585.00 $ 2,175.00 $ 3,213.31 $ 2,560.92 $ 790.03 $ 858.21 $ 1,945.28 $ 1,019.46 $ 705.08 $ 1,490.13
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL ASSETS $ 41,247.00 $ 41,275.00 $ 42,953.00 $ 67,234.95 $ 60,276.90 $ 59,462.27 $ 52,416.62 $ 42,419.20 $ 39,713.93 $ 36,178.17 $ 29,141.20
LIABILITIES
Long Term Debt Due In One Year $ 3.00 $ 55.00 $ 9.00 $ 308.82 $ 1,026.90 $ 2,044.97 $ 247.29 $ 1,956.89 $ 898.55 $ 95.28 $ 1,849.56
Notes Payable $ 3,127.00 $ 4,382.00 $ 3,164.00 $ 2,081.84 $ 2,347.86 $ 4,349.80 $ 4,978.44 $ 1,691.07 $ 1,827.36 $ 5,305.99 $ 212.45
Accounts Payable $ 1,081.00 $ 1,064.00 $ 1,026.00 $ 1,796.99 $ 1,721.13 $ 1,535.76 $ 1,280.54 $ 1,351.44 $ 1,219.53 $ 1,175.59 $ 1,032.52
Taxes Payable $ 430.00 $ 270.00 $ 175.00 $ 655.42 $ 514.95 $ 1,307.72 $ 442.14 $ 805.40 $ 80.41 $ 262.34 $ 488.93
Accrued Expenses $ 3,789.00 $ 3,719.00 $ 4,406.00 $ 8,215.76 $ 9,115.12 $ 7,343.44 $ 5,480.44 $ 5,228.05 $ 4,572.89 $ 4,658.01 $ 3,347.94
Other Current Liabilities $ 756.00 $ 1,042.00 $ 727.00 $ 221.34 $ 754.28 $ 680.75 $ 620.64 $ 559.06 $ 504.54 $ 453.99 $ 484.12
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Liabilities $ 9,186.00 $ 10,532.00 $ 9,507.00 $ 13,280.18 $ 15,480.23 $ 17,262.43 $ 13,049.49 $ 11,591.91 $ 9,103.28 $ 11,951.20 $ 7,415.51
Long Term Debt $ 5,871.00 $ 3,408.00 $ 3,388.00 $ 18,085.30 $ 12,039.82 $ 12,523.52 $ 11,266.29 $ 8,713.33 $ 9,487.79 $ 7,009.66 $ 4,571.50
Deferred Taxes $ 808.00 $ 860.00 $ 466.00 $ 710.00 @CF @CF @CF $ - 0 $ - 0 $ - 0 $ 583.08
Investment Tax Credit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Liabilities $ 4,056.00 $ 4,836.00 $ 4,325.00 $ 8,346.23 $ 8,230.70 $ 7,199.85 $ 5,202.11 $ 4,634.42 $ 3,344.32 $ 3,163.13 $ 2,155.84
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES $ 19,921.00 $ 19,636.00 $ 17,686.00 $ 40,421.71 $ 35,750.75 $ 36,985.80 $ 29,517.90 $ 24,939.65 $ 21,935.39 $ 22,123.99 $ 14,725.93
Redeemable Noncontrolling Int. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 @CF @CF @CF @CF
EQUITY
Preferred Stock - Redeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Preferred Stock - Nonredeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Preferred Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Common Stock $ 12,734.00 $ 12,383.00 $ 12,048.00 $ 11,754.55 $ 9,817.13 $ 8,744.70 $ 8,257.87 $ 7,444.41 $ 6,104.10 $ 4,290.93 $ 3,523.77
Capital Surplus $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ (46.31)
Retained Earnings $ 19,099.00 $ 17,821.00 $ 19,967.00 $ 20,557.32 $ 18,310.18 $ 17,560.26 $ 17,908.10 $ 12,661.54 $ 12,887.57 $ 9,958.49 $ 11,150.07
Less: Treasury Stock $ 10,622.00 $ 8,678.00 $ 6,844.00 $ 5,590.91 $ 3,687.48 $ 3,916.82 $ 3,310.35 $ 2,626.40 $ 1,213.13 $ 195.24 $ 212.26
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Common Equity $ 21,211.00 $ 21,526.00 $ 25,171.00 $ 26,720.96 $ 24,439.83 $ 22,388.14 $ 22,855.63 $ 17,479.55 $ 17,778.54 $ 14,054.19 $ 14,415.27
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Stockholder's Equity - Parent $ 21,211.00 $ 21,526.00 $ 25,171.00 $ 26,720.96 $ 24,439.83 $ 22,388.14 $ 22,855.63 $ 17,479.55 $ 17,778.54 $ 14,054.19 $ 14,415.27
Nonredeemable Noncontrolling Int. $ 115.00 $ 113.00 $ 96.00 $ 92.27 $ 86.31 $ 88.33 $ 43.10 @NA @NA @NA @NA
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL EQUITY $ 21,326.00 $ 21,639.00 $ 25,267.00 $ 26,813.23 $ 24,526.15 $ 22,476.46 $ 22,898.73 $ 17,479.55 $ 17,778.54 $ 14,054.19 $ 14,415.27
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES & EQUITY $ 41,247.00 $ 41,275.00 $ 42,953.00 $ 67,234.95 $ 60,276.90 $ 59,462.27 $ 52,416.62 $ 42,419.20 $ 39,713.93 $ 36,178.17 $ 29,141.20
COMMON SHARES OUTSTANDING 1,472.67 1,508.04 1,548.10 1,576.67 1,570.38 1,546.98 1,551.17 1,552.43 1,549.91 1,537.24 1,539.24

&"Arial,Bold"&12&A

Income Statements

Abbott Laboratories ANNUAL INCOME STATEMENT
TICKER: ABT
SIC: 2834
GICS: 35101010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Sales $ 20,405.00 $ 20,247.00 $ 21,848.00 $ 39,873.91 $ 38,851.26 $ 35,166.72 $ 30,764.71 $ 29,527.55 $ 25,914.24 $ 22,476.32 $ 22,287.81
Cost of Goods Sold $ 7,722.00 $ 8,159.00 $ 9,067.00 $ 12,009.51 $ 12,177.69 $ 11,382.89 $ 10,816.82 $ 10,427.19 $ 9,041.16 $ 7,759.40 $ 9,012.17
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Gross Profit $ 12,683.00 $ 12,088.00 $ 12,781.00 $ 27,864.40 $ 26,673.57 $ 23,783.84 $ 19,947.89 $ 19,100.36 $ 16,873.08 $ 14,716.93 $ 13,275.64
Selling, General, &
Administrative Expense $ 7,839.00 $ 7,613.00 $ 8,388.00 $ 15,297.68 $ 14,633.23 $ 13,120.75 $ 10,954.64 $ 10,784.44 $ 9,494.65 $ 8,297.96 $ 7,081.30
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Income Before Deprec. $ 4,844.00 $ 4,475.00 $ 4,393.00 $ 12,566.72 $ 12,040.34 $ 10,663.09 $ 8,993.25 $ 8,315.92 $ 7,378.43 $ 6,418.97 $ 6,194.34
Depreciation, Depletion, &
Amortization $ 1,472.00 $ 1,548.00 $ 1,719.00 $ 2,783.21 $ 3,043.89 $ 2,624.31 $ 2,089.51 $ 1,838.83 $ 1,854.89 $ 1,558.75 $ 1,358.94
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Profit $ 3,372.00 $ 2,927.00 $ 2,674.00 $ 9,783.52 $ 8,996.45 $ 8,038.78 $ 6,903.74 $ 6,477.10 $ 5,523.55 $ 4,860.22 $ 4,835.40
Interest Expense $ 163.00 $ 150.00 $ 157.00 $ 516.40 $ 530.14 $ 553.14 $ 519.66 $ 528.47 $ 593.14 $ 416.17 $ 241.36
Non-Operating Income/Expense $ 215.00 $ 100.00 $ 62.00 $ 163.48 $ 177.84 $ 291.39 $ 367.56 $ 540.67 $ 493.25 $ 582.32 $ 508.01
Special Items $ (224.00) $ (346.00) $ (45.00) $ (3,155.97) $ (3,435.50) $ (2,055.20) $ 449.13 $ (626.01) $ (945.00) $ (2,742.00) $ (473.13)
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Pretax Income $ 3,200.00 $ 2,531.00 $ 2,534.00 $ 6,274.61 $ 5,208.64 $ 5,721.83 $ 7,200.77 $ 5,863.29 $ 4,478.65 $ 2,284.37 $ 4,628.92
Total Income Taxes $ 577.00 $ 797.00 $ 138.00 $ 299.69 $ 470.19 $ 1,086.66 $ 1,447.94 $ 1,122.07 $ 863.33 $ 559.62 $ 1,247.86
Minority Interest ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
$ 2,623.00 $ 1,734.00 $ 2,396.00 $ 5,974.92 $ 4,738.45 $ 4,635.17 $ 5,752.84 @NA @NA @NA @NA
Noncontrolling Interest - Inc Acc $ 17.00 $ 13.00 $ 13.00 $ 12.00 $ 10.00 $ 9.00 $ 7.00 $ 7.00 $ 9.00 $ 8.00 $ 9.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary
Items & Discontinued Operations $ 2,606.00 $ 1,721.00 $ 2,383.00 $ 5,962.92 $ 4,728.45 $ 4,626.17 $ 5,745.84 $ 4,734.22 $ 3,606.31 $ 1,716.76 $ 3,372.07
Preferred Dividends $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Available for Common $ 2,606.00 $ 1,721.00 $ 2,383.00 $ 5,962.92 $ 4,728.45 $ 4,626.17 $ 5,745.84 $ 4,734.22 $ 3,606.31 $ 1,716.76 $ 3,372.07
Savings Due to Common
Stock Equivalents $ (11.00) $ (8.00) $ (18.00) $ (45.92) $ (14.00) $ (13.00) $ (13.00) $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Available for Common $ 2,595.00 $ 1,713.00 $ 2,365.00 $ 5,917.00 $ 4,714.45 $ 4,613.17 $ 5,732.84 $ 4,734.22 $ 3,606.31 $ 1,716.76 $ 3,372.07
Extraordinary Items $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Discontinued Operations $ 1,817.00 $ 563.00 $ 193.00 $ - 0 $ - 0 $ - 0 $ - 0 $ 146.50 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Net Income $ 4,412.00 $ 2,276.00 $ 2,558.00 $ 5,917.00 $ 4,714.45 $ 4,613.17 $ 5,732.84 $ 4,880.72 $ 3,606.31 $ 1,716.76 $ 3,372.07
Income to Company Incl Extraordinary
Items & Disc Ops $ 4,440.00 $ 2,297.00 $ 2,589.00 $ 5,974.92 $ 4,738.45 $ 4,635.17 $ 5,752.84 @NA @NA @NA @NA
Earnings Per Share Basic -
Excluding Extra Items & Disc Op $ 1.73 $ 1.13 $ 1.52 $ 3.76 $ 3.03 $ 2.98 $ 3.71 $ 3.06 $ 2.34 $ 1.12 $ 2.17
Earnings Per Share Basic -
Including Extra Items & Disc Op $ 2.94 $ 1.50 $ 1.64 $ 3.76 $ 3.03 $ 2.98 $ 3.71 $ 3.16 $ 2.34 $ 1.12 $ 2.17
Earnings Per Share Diluted-
Excluding Extra Items & Disc Op $ 1.72 $ 1.12 $ 1.50 $ 3.72 $ 3.01 $ 2.96 $ 3.69 $ 3.03 $ 2.31 $ 1.12 $ 2.16
Earning Per Share Diluted -
Including Extra Items & Disc Op $ 2.92 $ 1.49 $ 1.62 $ 3.72 $ 3.01 $ 2.96 $ 3.69 $ 3.12 $ 2.31 $ 1.12 $ 2.16
EPS Basic from Operations $ 1.83 $ 1.57 $ 1.39 $ 5.05 $ 4.70 $ 4.20 $ 3.77 $ 3.36 $ 2.84 $ 2.54 $ 2.50
EPS Diluted from Ops $ 1.82 $ 1.56 $ 1.37 $ 4.99 $ 4.66 $ 4.17 $ 3.74 $ 3.32 $ 2.82 $ 2.53 $ 2.48
Dividends Per Share $ 0.96 $ 0.88 $ 0.56 $ 2.01 $ 1.88 $ 1.72 $ 1.56 $ 1.40 $ 1.27 $ 1.16 $ 1.09
Com Shares for Diluted EPS 1,506.00 1,527.00 1,574.00 1,591.84 1,567.39 1,556.02 1,555.13 1,560.75 1,560.06 1,536.72 1,564.10
Com Shares for Basic Eps 1,496.00 1,516.00 1,558.00 1,575.38 1,557.64 1,546.40 1,546.98 1,545.36 1,543.08 1,529.85 1,552.46

&"Arial,Bold"&12&A

Financial Ratios

Abbott Laboratories Financial Analysis
DuPont Analysis Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Net Profitability 12.77% 8.50% 10.91% 14.95% 12.17% 13.15% 18.68% 16.03% 13.92% 7.64% 15.13%
Total Asset Turnover 0.495 0.481 0.397 0.625 0.649 0.629 0.649 0.719 0.683 0.688
Equity Multiplier 1.921 1.796 2.116 2.484 2.548 2.466 2.349 2.329 2.384 2.294
Return on Equity 12.13% 7.34% 9.15% 23.23% 20.12% 20.39% 28.46% 26.85% 22.66% 12.06%
Profitability Analysis
Gross Profitability 62.16% 59.70% 58.50% 69.88% 68.66% 67.63% 64.84% 64.69% 65.11% 65.48% 59.56%
Operating Profitability 16.53% 14.46% 12.24% 24.54% 23.16% 22.86% 22.44% 21.94% 21.31% 21.62% 21.70%
Net Profitability 12.77% 8.50% 10.91% 14.95% 12.17% 13.15% 18.68% 16.03% 13.92% 7.64% 15.13%
Return on Assets 6.32% 4.09% 4.33% 9.35% 7.90% 8.27% 12.12% 11.53% 9.50% 5.26%
Return on Equity 12.13% 7.34% 9.15% 23.23% 20.12% 20.39% 28.46% 26.85% 22.66% 12.06%
Efficiency Analysis
Receivable Turnover 5.827 5.348 3.767 5.213 5.226 5.124 5.124 5.672 5.647 5.757
Receivable DSO 62.643 68.252 96.887 70.012 69.841 71.232 71.231 64.356 64.636 63.398
Inventory Turnover 2.946 3.058 2.796 3.394 3.763 3.528 3.581 3.641 3.140 2.902
Inventory DCO 123.888 119.355 130.536 107.537 97.007 103.470 101.918 100.241 116.225 125.794
Net PP&E Turnover 3.498 3.420 3.128 5.004 4.904 4.511 4.147 4.007 3.583 3.471
Net Fixed Asset Turnover 0.768 0.814 0.733 1.101 1.055 1.062 1.129 1.157 1.025 1.054
Total Asset Turnover 0.495 0.481 0.397 0.625 0.649 0.629 0.649 0.719 0.683 0.688
Liquidity Analysis
Current Ratio 1.541 1.449 2.025 2.359 1.535 1.293 1.787 1.470 1.543 0.944 1.535
Quick Ratio 1.039 0.764 1.271 1.716 1.019 0.840 1.262 0.910 0.853 0.469 0.881
Cash Ratio 0.667 0.423 0.852 1.143 0.523 0.424 0.761 0.438 0.310 0.115 0.399
Times Interest Earned 20.687 19.513 17.032 18.946 16.970 14.533 13.285 12.256 9.312 11.678 20.034
Accounts Payable Turnover 7.159 7.760 5.645 7.116 7.537 8.029 8.591 7.975 7.671 7.268
Accounts Payable DCO (DPO) 50.985 47.037 64.661 51.292 48.429 45.457 42.486 45.769 47.583 50.223
Leverage Ratio
Total Debt to Total Assets 0.483 0.476 0.412 0.601 0.593 0.622 0.563 0.588 0.552 0.612 0.505
Long Term Term Debt to Total Assets 0.260 0.221 0.190 0.404 0.336 0.332 0.314 0.315 0.323 0.281 0.251
Total Debt to Total Equity 0.934 0.907 0.700 1.508 1.458 1.646 1.289 1.427 1.234 1.574 1.022

&"Arial,Bold"&12&A

FINANCIAL ELI LILLY.xlsx

Balance Sheets

Lilly (Eli) & Co. ANNUAL BALANCE SHEET
TICKER: LLY
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
ASSETS
Cash & Equivalents $ 4,451.80 $ 4,827.00 $ 5,397.30 $ 5,684.30 $ 6,897.10 $ 6,727.00 $ 4,497.60 $ 5,926.10 $ 4,831.20 $ 3,891.00 $ 5,037.70
Net Receivables $ 4,071.60 $ 3,801.30 $ 4,022.80 $ 3,888.30 $ 4,237.90 $ 4,158.10 $ 3,831.80 $ 3,277.30 $ 3,704.80 $ 2,694.40 $ 2,761.70
Inventories $ 3,445.80 $ 2,740.00 $ 2,928.80 $ 2,643.80 $ 2,299.80 $ 2,517.70 $ 2,849.90 $ 2,493.20 $ 2,523.70 $ 2,270.30 $ 1,878.00
Prepaid Expenses @CF @CF @CF @CF @CF @CF @CF $ 374.60 $ 613.60 $ 319.50 $ 362.00
Other Current Assets $ 604.40 $ 811.50 $ 755.80 $ 822.30 $ 813.40 $ 1,437.20 $ 1,307.20 $ 382.10 $ 642.80 $ 519.20 $ 756.40
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Assets $ 12,573.60 $ 12,179.80 $ 13,104.70 $ 13,038.70 $ 14,248.20 $ 14,840.00 $ 12,486.50 $ 12,453.30 $ 12,316.10 $ 9,694.40 $ 10,795.80
Gross Plant, Property & Equipment $ 16,660.90 $ 16,029.30 $ 15,646.70 $ 14,918.00 $ 14,594.10 $ 14,486.60 $ 15,100.00 $ 15,315.90 $ 14,841.30 $ 13,716.70 $ 13,136.00
Accumulated Depreciation $ 8,607.40 $ 8,065.40 $ 7,671.20 $ 7,157.80 $ 6,833.80 $ 6,545.90 $ 6,902.60 $ 6,689.60 $ 6,266.20 $ 5,564.40 $ 5,223.50
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Net Plant, Property & Equipment $ 8,053.50 $ 7,963.90 $ 7,975.50 $ 7,760.20 $ 7,760.30 $ 7,940.70 $ 8,197.40 $ 8,626.30 $ 8,575.10 $ 8,152.30 $ 7,912.50
Investments at Equity @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF
Other Investments $ 3,646.60 $ 4,568.90 $ 7,624.90 $ 6,313.30 $ 4,029.80 $ 1,779.50 $ 1,155.80 $ 1,544.60 $ 577.10 $ 1,001.90 $ 1,296.60
Intangibles $ 9,074.70 $ 4,642.30 $ 4,331.10 $ 4,752.70 $ 5,128.10 $ 4,818.80 $ 3,699.80 $ 4,054.10 $ 2,455.40 $ 130.00 $ 139.60
Deferred Charges $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 1,670.50 $ 1,091.50 $ 2,419.60
Other Assets $ 2,220.50 $ 7,823.30 $ 2,212.50 $ 2,534.00 $ 2,493.40 $ 1,622.40 $ 1,921.40 $ 2,534.30 $ 1,280.60 $ 1,885.30 $ 2,016.70
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL ASSETS $ 35,568.90 $ 37,178.20 $ 35,248.70 $ 34,398.90 $ 33,659.80 $ 31,001.40 $ 27,460.90 $ 29,212.60 $ 26,874.80 $ 21,955.40 $ 24,580.80
LIABILITIES
Long Term Debt Due In One Year $ 6.10 $ 8.10 $ 1,012.60 $ 11.90 $ 1,516.80 $ 18.20 $ 20.30 $ 420.40 $ 395.10 $ 210.80 $ 721.30
Notes Payable $ - 0 $ 2,680.60 $ - 0 $ - 0 $ 5.50 $ 137.80 $ 7.10 $ 5,425.90 $ 18.60 $ 8.60 $ 13.40
Accounts Payable $ 1,338.20 $ 1,128.10 $ 1,119.30 $ 1,188.30 $ 1,125.20 $ 1,072.20 $ 968.10 $ 885.80 $ 924.40 $ 789.40 $ 781.30
Taxes Payable $ 358.90 $ 93.50 $ 254.40 $ 143.50 $ 261.60 $ 457.50 $ 346.70 $ 229.20 $ 238.40 $ 640.60 $ 884.90
Accrued Expenses @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF
Other Current Liabilities $ 6,526.40 $ 7,297.20 $ 6,530.30 $ 7,045.80 $ 6,021.80 $ 5,415.70 $ 5,225.90 $ 6,148.40 $ 3,860.30 $ 3,436.10 $ 3,315.40
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Liabilities $ 8,229.60 $ 11,207.50 $ 8,916.60 $ 8,389.50 $ 8,930.90 $ 7,101.40 $ 6,568.10 $ 13,109.70 $ 5,436.80 $ 5,085.50 $ 5,716.30
Long Term Debt $ 7,972.40 $ 5,367.70 $ 4,200.30 $ 5,519.40 $ 5,464.70 $ 6,770.50 $ 6,634.70 $ 4,615.70 $ 4,593.50 $ 3,494.40 $ 5,763.50
Deferred Taxes @CF @CF @CF @CF @CF @CF $ 84.80 $ 74.70 $ 287.50 $ 62.20 $ 695.10
Investment Tax Credit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Liabilities $ 4,776.60 $ 5,214.90 $ 4,491.10 $ 5,716.10 $ 5,728.60 $ 4,716.70 $ 4,648.00 $ 4,674.80 $ 3,053.10 $ 2,332.60 $ 1,614.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES $ 20,978.60 $ 21,790.10 $ 17,608.00 $ 19,625.00 $ 20,124.20 $ 18,588.60 $ 17,935.60 $ 22,474.90 $ 13,370.90 $ 10,974.70 $ 13,788.90
Redeemable Noncontrolling Int. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2.40 @CF @CF @CF
EQUITY
Preferred Stock - Redeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Preferred Stock - Nonredeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Preferred Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Common Stock $ 691.30 $ 694.60 $ 698.50 $ 716.60 $ 724.10 $ 721.30 $ 718.70 $ 711.10 $ 709.50 $ 707.90 $ 706.90
Capital Surplus $ 5,552.10 $ 5,292.30 $ 5,050.00 $ 4,963.10 $ 4,886.80 $ 4,746.10 $ 4,558.20 $ 3,890.30 $ 3,710.00 $ 3,471.20 $ 3,217.50
Retained Earnings $ 11,431.10 $ 12,490.90 $ 14,989.70 $ 12,291.10 $ 11,039.20 $ 10,062.50 $ 7,358.50 $ 4,868.10 $ 11,819.90 $ 9,538.00 $ 9,606.60
Less: Treasury Stock $ 3,103.20 $ 3,104.60 $ 3,106.80 $ 3,205.60 $ 3,108.40 $ 3,109.60 $ 3,111.70 $ 2,734.20 $ 2,735.50 $ 2,736.40 $ 2,739.10
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Common Equity $ 14,571.30 $ 15,373.20 $ 17,631.40 $ 14,765.20 $ 13,541.70 $ 12,420.30 $ 9,523.70 $ 6,735.30 $ 13,503.90 $ 10,980.70 $ 10,791.90
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Stockholder's Equity - Parent $ 14,571.30 $ 15,373.20 $ 17,631.40 $ 14,765.20 $ 13,541.70 $ 12,420.30 $ 9,523.70 $ 6,735.30 $ 13,503.90 $ 10,980.70 $ 10,791.90
Nonredeemable Noncontrolling Int. $ 19.00 $ 14.90 $ 9.30 $ 8.70 $ (6.10) $ (7.50) $ 1.60 @NA @NA @NA @NA
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL EQUITY $ 14,590.30 $ 15,388.10 $ 17,640.70 $ 14,773.90 $ 13,535.60 $ 12,412.80 $ 9,525.30 $ 6,735.30 $ 13,503.90 $ 10,980.70 $ 10,791.90
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES & EQUITY $ 35,568.90 $ 37,178.20 $ 35,248.70 $ 34,398.90 $ 33,659.80 $ 31,001.40 $ 27,460.90 $ 29,212.60 $ 26,874.80 $ 21,955.40 $ 24,580.80
COMMON SHARES OUTSTANDING 1,055.27 1,060.63 1,066.80 1,093.64 1,107.79 1,102.29 1,099.03 1,096.06 1,094.31 1,091.67 1,090.14

&"Arial,Bold"&12&A

Income Statements

Lilly (Eli) & Co. ANNUAL INCOME STATEMENT
TICKER: LLY
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Sales $ 19,958.70 $ 19,615.60 $ 23,113.10 $ 22,603.40 $ 24,286.50 $ 23,076.00 $ 21,836.00 $ 20,378.00 $ 18,633.50 $ 15,691.00 $ 14,645.30
Cost of Goods Sold $ 3,534.80 $ 3,637.50 $ 3,578.30 $ 3,479.50 $ 3,866.50 $ 3,231.40 $ 3,156.50 $ 3,400.60 $ 3,393.70 $ 2,919.10 $ 2,897.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Gross Profit $ 16,423.90 $ 15,978.10 $ 19,534.80 $ 19,123.90 $ 20,420.00 $ 19,844.60 $ 18,679.50 $ 16,977.40 $ 15,239.80 $ 12,771.90 $ 11,748.30
Selling, General, &
Administrative Expense $ 11,329.40 $ 11,235.40 $ 12,656.90 $ 12,791.60 $ 12,900.70 $ 11,937.60 $ 11,219.00 $ 10,452.30 $ 9,581.80 $ 8,019.10 $ 7,522.50
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Income Before Deprec. $ 5,094.50 $ 4,742.70 $ 6,877.90 $ 6,332.30 $ 7,519.30 $ 7,907.00 $ 7,460.50 $ 6,525.10 $ 5,658.00 $ 4,752.80 $ 4,225.80
Depreciation, Depletion, &
Amortization $ 1,349.40 $ 1,295.00 $ 1,329.80 $ 1,317.00 $ 1,201.40 $ 1,134.80 $ 1,090.50 $ 925.10 $ 855.10 $ 627.40 $ 577.20
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Profit $ 3,745.10 $ 3,447.70 $ 5,548.10 $ 5,015.30 $ 6,317.90 $ 6,772.20 $ 6,370.00 $ 5,600.00 $ 4,802.90 $ 4,125.40 $ 3,648.60
Interest Expense $ 216.00 $ 187.10 $ 184.20 $ 198.80 $ 211.70 $ 211.50 $ 291.50 $ 276.50 $ 323.60 $ 344.80 $ 245.70
Non-Operating Income/Expense $ 483.30 $ 435.60 $ 207.70 $ 85.00 $ 32.70 $ 206.50 $ 62.00 $ 250.40 $ 445.60 $ 582.60 $ 559.90
Special Items $ (1,222.40) $ (695.90) $ 317.70 $ 506.70 $ (789.40) $ (242.00) $ (782.70) $ (6,881.50) $ (1,048.10) $ (945.20) $ (1,245.30)
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Pretax Income $ 2,790.00 $ 3,000.30 $ 5,889.30 $ 5,408.20 $ 5,349.50 $ 6,525.20 $ 5,357.80 $ (1,307.60) $ 3,876.80 $ 3,418.00 $ 2,717.50
Total Income Taxes $ 381.60 $ 609.80 $ 1,204.50 $ 1,319.60 $ 1,001.80 $ 1,455.70 $ 1,029.00 $ 764.30 $ 923.80 $ 755.30 $ 715.90
Minority Interest ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
$ 2,408.40 $ 2,390.50 $ 4,684.80 $ 4,088.60 $ 4,347.70 $ 5,069.50 $ 4,328.80 @NA @NA @NA @NA
Noncontrolling Interest - Inc Acc @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary
Items & Discontinued Operations $ 2,408.40 $ 2,390.50 $ 4,684.80 $ 4,088.60 $ 4,347.70 $ 5,069.50 $ 4,328.80 $ (2,071.90) $ 2,953.00 $ 2,662.70 $ 2,001.60
Preferred Dividends $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Available for Common $ 2,408.40 $ 2,390.50 $ 4,684.80 $ 4,088.60 $ 4,347.70 $ 5,069.50 $ 4,328.80 $ (2,071.90) $ 2,953.00 $ 2,662.70 $ 2,001.60
Savings Due to Common
Stock Equivalents $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Available for Common $ 2,408.40 $ 2,390.50 $ 4,684.80 $ 4,088.60 $ 4,347.70 $ 5,069.50 $ 4,328.80 $ (2,071.90) $ 2,953.00 $ 2,662.70 $ 2,001.60
Extraordinary Items $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ (22.00)
Discontinued Operations $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Net Income $ 2,408.40 $ 2,390.50 $ 4,684.80 $ 4,088.60 $ 4,347.70 $ 5,069.50 $ 4,328.80 $ (2,071.90) $ 2,953.00 $ 2,662.70 $ 1,979.60
Income to Company Incl Extraordinary
Items & Disc Ops $ 2,408.40 $ 2,390.50 $ 4,684.80 $ 4,088.60 $ 4,347.70 $ 5,069.50 $ 4,328.80 @NA @NA @NA @NA
Earnings Per Share Basic -
Excluding Extra Items & Disc Op $ 2.27 $ 2.23 $ 4.33 $ 3.67 $ 3.90 $ 4.58 $ 3.94 $ (1.89) $ 2.71 $ 2.45 $ 1.84
Earnings Per Share Basic -
Including Extra Items & Disc Op $ 2.27 $ 2.23 $ 4.33 $ 3.67 $ 3.90 $ 4.58 $ 3.94 $ (1.89) $ 2.71 $ 2.45 $ 1.82
Earnings Per Share Diluted-
Excluding Extra Items & Disc Op $ 2.26 $ 2.23 $ 4.32 $ 3.66 $ 3.90 $ 4.58 $ 3.94 $ (1.89) $ 2.71 $ 2.45 $ 1.83
Earning Per Share Diluted -
Including Extra Items & Disc Op $ 2.26 $ 2.23 $ 4.32 $ 3.66 $ 3.90 $ 4.58 $ 3.94 $ (1.89) $ 2.71 $ 2.45 $ 1.81
EPS Basic from Operations $ 3.05 $ 2.78 $ 4.15 $ 3.40 $ 4.41 $ 4.82 $ 4.36 $ 3.88 $ 3.55 $ 3.19 $ 2.88
EPS Diluted from Ops $ 3.03 $ 2.78 $ 4.14 $ 3.39 $ 4.41 $ 4.82 $ 4.36 $ 3.88 $ 3.55 $ 3.18 $ 2.87
Dividends Per Share $ 2.00 $ 1.96 $ 1.96 $ 1.96 $ 1.96 $ 1.96 $ 1.96 $ 1.88 $ 1.70 $ 1.60 $ 1.52
Com Shares for Diluted EPS 1,065.72 1,074.29 1,084.77 1,117.29 1,113.97 1,105.81 1,098.37 1,094.50 1,090.75 1,087.49 1,092.15
Com Shares for Basic Eps 1,061.91 1,069.93 1,080.87 1,113.18 1,113.92 1,105.79 1,098.34 1,094.50 1,090.43 1,086.24 1,088.75

&"Arial,Bold"&12&A

Financial Ratios

Lilly (Eli) & Co. Financial Analysis
DuPont Analysis Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Net Profitability 12.07% 12.19% 20.27% 18.09% 17.90% 21.97% 19.82% -10.17% 15.85% 16.97% 13.67%
Total Asset Turnover 0.549 0.542 0.664 0.664 0.751 0.789 0.771 0.727 0.763 0.674
Equity Multiplier 2.427 2.193 2.149 2.404 2.492 2.665 3.485 2.771 1.994 2.137
Return on Equity 16.07% 14.48% 28.91% 28.89% 33.51% 46.22% 53.24% -20.47% 24.12% 24.46%
Profitability Analysis
Gross Profitability 82.29% 81.46% 84.52% 84.61% 84.08% 86.00% 85.54% 83.31% 81.79% 81.40% 80.22%
Operating Profitability 18.76% 17.58% 24.00% 22.19% 26.01% 29.35% 29.17% 27.48% 25.78% 26.29% 24.91%
Net Profitability 12.07% 12.19% 20.27% 18.09% 17.90% 21.97% 19.82% -10.17% 15.85% 16.97% 13.67%
Return on Assets 6.62% 6.60% 13.45% 12.01% 13.45% 17.34% 15.28% -7.39% 12.09% 11.44%
Return on Equity 16.07% 14.48% 28.91% 28.89% 33.51% 46.22% 53.24% -20.47% 24.12% 24.46%
Efficiency Analysis
Receivable Turnover 5.070 5.014 5.843 5.563 5.785 5.776 6.143 5.837 5.824 5.752
Receivable DSO 71.989 72.794 62.466 65.611 63.091 63.189 59.416 62.530 62.675 63.459
Inventory Turnover 1.143 1.283 1.284 1.408 1.605 1.204 1.182 1.356 1.416 1.407
Inventory DCO 319.370 284.414 284.213 259.292 227.387 303.146 308.923 269.242 257.803 259.349
Net PP&E Turnover 2.492 2.461 2.938 2.913 3.094 2.860 2.596 2.369 2.228 1.953
Net Fixed Asset Turnover 0.832 0.832 1.063 1.109 1.365 1.482 1.376 1.301 1.390 1.205
Total Asset Turnover 0.549 0.542 0.664 0.664 0.751 0.789 0.771 0.727 0.763 0.674
Liquidity Analysis
Current Ratio 1.528 1.087 1.470 1.554 1.595 2.090 1.901 0.950 2.265 1.906 1.889
Quick Ratio 1.036 0.770 1.056 1.141 1.247 1.533 1.268 0.702 1.570 1.295 1.364
Cash Ratio 0.541 0.431 0.605 0.678 0.772 0.947 0.685 0.452 0.889 0.765 0.881
Times Interest Earned 17.338 18.427 30.120 25.228 29.844 32.020 21.852 20.253 14.842 11.965 14.850
Accounts Payable Turnover 3.439 3.069 3.348 3.305 3.321 2.842 3.790 3.723 4.256 4.216
Accounts Payable DCO (DPO) 106.141 118.929 109.010 110.426 109.912 128.434 96.304 98.027 85.758 86.565
Leverage Ratio
Total Debt to Total Assets 0.590 0.586 0.500 0.571 0.598 0.600 0.653 0.769 0.498 0.500 0.561
Long Term Term Debt to Total Assets 0.358 0.285 0.247 0.327 0.333 0.371 0.414 0.321 0.295 0.268 0.328
Total Debt to Total Equity 1.438 1.416 0.998 1.328 1.487 1.498 1.883 3.337 0.990 0.999 1.278

&"Arial,Bold"&12&A

FINANCIAL GSK.xlsx

Balance Sheets

Glaxosmithklien PLC ANNUAL BALANCE SHEET
TICKER: GSK
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
ASSETS
Cash & Equivalents $ 8,707.51 $ 6,865.22 $ 9,281.44 $ 6,935.74 $ 9,163.72 $ 9,606.15 $ 11,014.58 $ 8,791.87 $ 8,992.85 $ 5,954.14 $ 8,996.20
Net Receivables $ 7,958.42 $ 6,887.03 $ 8,691.41 $ 8,163.52 $ 8,201.98 $ 8,528.71 $ 10,023.54 $ 8,746.55 $ 10,435.43 $ 10,082.87 $ 9,004.79
Inventories $ 6,954.21 $ 6,591.05 $ 6,463.86 $ 6,454.39 $ 6,017.48 $ 5,905.91 $ 6,570.27 $ 5,929.47 $ 6,075.93 $ 4,773.11 $ 3,741.83
Prepaid Expenses $ 533.81 $ 450.20 $ 480.65 $ 463.47 $ 529.81 $ 397.11 $ 488.24 $ 431.26 $ 474.25 $ 438.73 $ 491.58
Other Current Assets $ 305.24 $ 2,071.87 $ 319.88 $ 248.81 $ 1,205.67 $ 244.73 $ 308.79 $ 1,346.41 $ 1,059.62 $ 280.08 $ 414.23
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Assets $ 24,459.19 $ 22,865.39 $ 25,237.23 $ 22,265.93 $ 25,118.67 $ 24,682.61 $ 28,405.42 $ 25,245.55 $ 27,038.07 $ 21,528.93 $ 22,648.63
Gross Plant, Property & Equipment $ 30,597.95 $ 30,151.22 $ 30,396.72 $ 29,697.66 $ 29,259.28 $ 29,083.19 $ 30,324.44 $ 27,757.10 $ 29,937.14 $ 26,329.46 $ 22,670.97
Accumulated Depreciation $ 16,341.52 $ 16,050.01 $ 15,692.26 $ 15,426.13 $ 15,667.51 $ 15,161.12 $ 15,169.50 $ 13,608.83 $ 14,417.92 $ 12,756.36 $ 11,237.51
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Net Plant, Property & Equipment $ 14,256.43 $ 14,101.21 $ 14,704.45 $ 14,271.53 $ 13,591.77 $ 13,922.07 $ 15,154.95 $ 14,148.27 $ 15,519.21 $ 13,573.10 $ 11,433.46
Investments at Equity $ 305.24 $ 529.65 $ 535.34 $ 941.57 $ 870.07 $ 1,663.88 $ 1,446.95 $ 806.97 $ 652.84 $ 577.79 $ 474.39
Other Investments $ 2,930.03 $ 2,735.50 $ 2,918.68 $ 2,187.24 $ 1,701.30 $ 1,914.77 $ 1,155.94 $ 1,059.88 $ 1,345.36 $ 863.74 $ 622.21
Intangibles $ 32,196.42 $ 18,762.14 $ 22,355.01 $ 23,612.42 $ 17,954.56 $ 18,682.81 $ 18,663.18 $ 11,651.34 $ 11,560.53 $ 7,934.29 $ 7,010.98
Deferred Charges $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Assets $ 4,664.16 $ 4,332.24 $ 4,002.62 $ 4,167.95 $ 4,589.63 $ 4,134.29 $ 4,468.56 $ 4,676.62 $ 5,403.25 $ 5,570.26 $ 4,558.26
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL ASSETS $ 78,811.47 $ 63,326.13 $ 69,753.34 $ 67,446.65 $ 63,826.00 $ 65,000.41 $ 69,294.99 $ 57,588.63 $ 61,519.25 $ 50,048.11 $ 46,747.92
LIABILITIES
Long Term Debt Due In One Year $ 1,287.33 $ 2,972.28 $ 1,567.90 $ 2,536.87 $ 3,935.52 $ 49.25 $ 1,088.04 $ 1,176.83 $ 2,543.87 $ 930.34 $ 665.18
Notes Payable $ 641.45 $ 1,612.32 $ 3,054.59 $ 3,367.86 $ 256.36 $ 398.65 $ 1,290.13 $ 220.75 $ 4,409.12 $ 475.94 $ 1,397.38
Accounts Payable $ 4,600.75 $ 4,346.26 $ 4,539.62 $ 4,335.45 $ 3,989.90 $ 3,295.43 $ 2,998.98 $ 1,685.57 $ 1,847.38 $ 1,694.19 $ 1,407.70
Taxes Payable $ 2,095.41 $ 1,472.12 $ 2,406.55 $ 2,234.40 $ 2,552.73 $ 1,611.54 $ 2,345.83 $ 1,140.28 $ 1,639.03 $ 1,216.29 $ 3,899.96
Accrued Expenses $ 7,850.77 $ 7,321.66 $ 7,466.59 $ 7,065.84 $ 6,912.41 $ 6,743.24 $ 7,244.43 $ 6,704.27 $ 7,278.41 $ 7,156.72 $ 6,663.79
Other Current Liabilities $ 3,309.00 $ 2,986.30 $ 3,633.02 $ 2,925.53 $ 5,674.11 $ 7,594.41 $ 4,623.76 $ 3,716.15 $ 2,809.77 $ 2,755.75 $ 2,313.51
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Liabilities $ 19,784.71 $ 20,710.95 $ 22,668.26 $ 22,465.95 $ 23,321.04 $ 19,692.53 $ 19,591.17 $ 14,643.85 $ 20,527.58 $ 14,229.23 $ 16,347.51
Long Term Debt $ 22,596.77 $ 24,677.11 $ 25,616.77 $ 23,857.98 $ 18,959.80 $ 22,794.01 $ 23,904.53 $ 22,266.20 $ 14,023.05 $ 9,346.44 $ 9,059.79
Deferred Taxes $ 2,244.34 $ 693.22 $ 1,148.58 $ 1,632.71 $ 1,277.14 $ 1,088.21 $ 1,042.77 $ 1,043.80 $ 1,760.07 $ 1,165.37 $ 978.00
Investment Tax Credit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Liabilities $ 21,094.15 $ 9,555.55 $ 7,372.12 $ 8,518.04 $ 6,553.51 $ 6,426.16 $ 7,389.94 $ 7,474.70 $ 5,544.13 $ 6,410.50 $ 7,351.31
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES $ 65,719.98 $ 55,636.83 $ 56,805.73 $ 56,474.68 $ 50,111.48 $ 50,000.91 $ 51,928.40 $ 45,428.54 $ 41,854.84 $ 31,151.53 $ 33,736.61
Redeemable Noncontrolling Int. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 565.76 $ 609.18 @CF @CF
EQUITY
Preferred Stock - Redeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Preferred Stock - Nonredeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Preferred Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Common Stock $ 1,975.96 $ 2,085.89 $ 2,214.29 $ 2,193.74 $ 2,154.98 $ 2,182.59 $ 2,289.25 $ 2,068.59 $ 2,982.40 $ 2,933.98 $ 2,562.73
Capital Surplus $ 4,174.59 $ 4,297.97 $ 4,300.95 $ 3,288.18 $ 2,599.34 $ 2,197.98 $ 2,211.65 $ 1,938.48 $ 2,512.12 $ 1,680.48 $ 943.62
Retained Earnings $ 11,700.95 $ 11,267.57 $ 16,988.35 $ 15,335.07 $ 18,838.61 $ 20,274.34 $ 23,676.57 $ 18,889.21 $ 30,030.40 $ 24,361.07 $ 16,572.67
Less: Treasury Stock $ 10,310.40 $ 11,010.53 $ 11,906.76 $ 11,368.76 $ 11,113.62 $ 10,976.04 $ 12,002.38 $ 11,301.95 $ 16,469.69 $ 10,078.96 $ 7,067.71
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Common Equity $ 7,541.10 $ 6,640.90 $ 11,596.83 $ 9,448.22 $ 12,479.32 $ 13,678.87 $ 16,175.08 $ 11,594.33 $ 19,055.23 $ 18,896.57 $ 13,011.32
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Stockholder's Equity - Parent $ 7,541.10 $ 6,640.90 $ 11,596.83 $ 9,448.22 $ 12,479.32 $ 13,678.87 $ 16,175.08 $ 11,594.33 $ 19,055.23 $ 18,896.57 $ 13,011.32
Nonredeemable Noncontrolling Int. $ 5,550.40 $ 1,048.40 $ 1,350.78 $ 1,523.75 $ 1,235.19 $ 1,320.63 $ 1,191.51 @NA @NA @NA @NA
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL EQUITY $ 13,091.50 $ 7,689.30 $ 12,947.61 $ 10,971.97 $ 13,714.51 $ 14,999.50 $ 17,366.59 $ 11,594.33 $ 19,055.23 $ 18,896.57 $ 13,011.32
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES & EQUITY $ 78,811.47 $ 63,326.13 $ 69,753.34 $ 67,446.65 $ 63,826.00 $ 65,000.41 $ 69,294.99 $ 57,588.63 $ 61,519.25 $ 50,048.11 $ 46,747.92
COMMON SHARES OUTSTANDING 2,420.00 2,405.52 2,395.58 2,413.72 2,479.06 2,598.13 2,536.60 2,529.08 2,686.93 2,801.33 2,826.32

&"Arial,Bold"&12&A

Income Statements

Glaxosmithklien PLC ANNUAL INCOME STATEMENT
TICKER: GSK
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Sales $ 50,036.13 $ 36,430.71 $ 46,433.72 $ 44,575.77 $ 43,498.94 $ 44,459.79 $ 47,092.86 $ 36,391.08 $ 46,017.90 $ 46,089.77 $ 37,854.85
Cost of Goods Sold $ 9,820.84 $ 8,778.20 $ 11,590.20 $ 10,279.21 $ 9,067.39 $ 8,813.46 $ 8,945.20 $ 6,644.34 $ 8,302.31 $ 8,063.56 $ 6,634.57
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Gross Profit $ 40,215.29 $ 27,652.51 $ 34,843.52 $ 34,296.56 $ 34,431.54 $ 35,646.33 $ 38,147.65 $ 29,746.74 $ 37,715.59 $ 38,026.22 $ 31,220.28
Selling, General, &
Administrative Expense $ 16,904.81 $ 16,680.92 $ 19,994.87 $ 19,966.48 $ 19,174.21 $ 25,169.00 $ 21,261.22 $ 15,873.31 $ 19,950.15 $ 20,984.44 $ 17,851.46
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Income Before Deprec. $ 23,310.48 $ 10,971.58 $ 14,848.65 $ 14,330.08 $ 15,257.33 $ 10,477.33 $ 16,886.43 $ 13,873.43 $ 17,765.44 $ 17,041.78 $ 13,368.83
Depreciation, Depletion, &
Amortization $ 2,403.60 $ 2,311.78 $ 2,343.56 $ 2,349.86 $ 2,210.92 $ 2,584.32 $ 2,525.29 $ 1,799.60 $ 2,027.96 $ 1,876.34 $ 1,553.80
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Profit $ 20,906.88 $ 8,659.81 $ 12,505.08 $ 11,980.22 $ 13,046.42 $ 7,893.02 $ 14,361.15 $ 12,073.83 $ 15,737.48 $ 15,165.44 $ 11,815.03
Interest Expense $ 986.51 $ 1,057.75 $ 1,209.90 $ 1,227.78 $ 1,146.63 $ 1,214.43 $ 1,272.34 $ 1,204.61 $ 861.19 $ 615.00 $ 733.93
Non-Operating Income/Expense $ 1,294.70 $ 85.68 $ 120.99 $ 91.07 $ 980.39 $ 255.51 $ 413.88 $ 507.28 $ 581.40 $ 597.37 $ 489.86
Special Items $ (5,693.43) $ (3,064.19) $ (399.43) $ 39.03 $ (919.79) $ (2,074.84) $ (745.30) $ (1,641.71) $ (670.69) $ 127.31 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Pretax Income $ 15,521.64 $ 4,623.55 $ 11,016.74 $ 10,882.53 $ 11,960.38 $ 4,859.25 $ 12,757.38 $ 9,734.79 $ 14,787.00 $ 15,275.12 $ 11,570.96
Total Income Taxes $ 3,176.29 $ 213.42 $ 1,688.89 $ 3,167.84 $ 3,480.29 $ 2,007.12 $ 3,592.31 $ 2,846.32 $ 4,250.37 $ 4,506.74 $ 3,293.22
Minority Interest ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
$ 12,345.35 $ 4,410.13 $ 9,327.85 $ 7,714.69 $ 8,480.10 $ 2,852.14 $ 9,165.07 @NA @NA @NA @NA
Noncontrolling Interest - Inc Acc $ (73.73) $ 116.84 $ 318.22 $ 291.09 $ 306.08 $ 337.09 $ 223.11 $ 160.81 $ 190.49 $ 213.49 $ 218.29
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary
Items & Discontinued Operations $ 12,419.08 $ 4,293.30 $ 9,009.63 $ 7,423.60 $ 8,174.02 $ 2,515.05 $ 8,941.97 $ 6,727.66 $ 10,346.14 $ 10,554.90 $ 8,059.45
Preferred Dividends $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Available for Common $ 12,419.08 $ 4,293.30 $ 9,009.63 $ 7,423.60 $ 8,174.02 $ 2,515.05 $ 8,941.97 $ 6,727.66 $ 10,346.14 $ 10,554.90 $ 8,059.45
Savings Due to Common
Stock Equivalents $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Available for Common $ 12,419.08 $ 4,293.30 $ 9,009.63 $ 7,423.60 $ 8,174.02 $ 2,515.05 $ 8,941.97 $ 6,727.66 $ 10,346.14 $ 10,554.90 $ 8,059.45
Extraordinary Items $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Discontinued Operations $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Net Income $ 12,419.08 $ 4,293.30 $ 9,009.63 $ 7,423.60 $ 8,174.02 $ 2,515.05 $ 8,941.97 $ 6,727.66 $ 10,346.14 $ 10,554.90 $ 8,059.45
Income to Company Incl Extraordinary
Items & Disc Ops $ 12,345.35 $ 4,410.13 $ 9,327.85 $ 7,714.69 $ 8,480.10 $ 2,852.14 $ 9,165.07 @NA @NA @NA @NA
Earnings Per Share Basic -
Excluding Extra Items & Disc Op $ 5.15 $ 1.79 $ 3.73 $ 3.02 $ 3.25 $ 0.99 $ 3.52 $ 2.59 $ 3.75 $ 3.74 $ 2.84
Earnings Per Share Basic -
Including Extra Items & Disc Op $ 5.15 $ 1.79 $ 3.73 $ 3.02 $ 3.25 $ 0.99 $ 3.53 $ 2.59 $ 3.75 $ 3.74 $ 2.84
Earnings Per Share Diluted-
Excluding Extra Items & Disc Op $ 5.09 $ 1.76 $ 3.66 $ 2.98 $ 3.20 $ 0.99 $ 3.50 $ 2.57 $ 3.71 $ 3.70 $ 2.82
Earning Per Share Diluted -
Including Extra Items & Disc Op $ 5.09 $ 1.76 $ 3.66 $ 2.98 $ 3.20 $ 0.99 $ 3.50 $ 2.57 $ 3.71 $ 3.70 $ 2.82
EPS Basic from Operations $ 6.89 $ 2.71 $ 3.86 $ 3.32 $ 3.54 $ 1.67 $ 3.76 $ 3.06 $ 3.93 $ 3.70 $ 2.84
EPS Diluted from Ops $ 6.81 $ 2.66 $ 3.78 $ 3.25 $ 3.50 $ 1.65 $ 3.73 $ 3.04 $ 3.89 $ 3.68 $ 2.82
Dividends Per Share $ 2.41 $ 2.65 $ 2.41 $ 2.48 $ 2.21 $ 2.00 $ 1.85 $ 2.14 $ 2.06 $ 1.74 $ 1.53
Com Shares for Diluted EPS 2,444.00 2,432.50 2,459.50 2,494.50 2,549.50 2,564.00 2,554.00 2,613.00 2,783.50 2,850.00 2,860.00
Com Shares for Basic Eps 2,415.50 2,404.00 2,415.50 2,456.00 2,514.00 2,542.50 2,534.50 2,597.50 2,762.00 2,821.50 2,837.00

&"Arial,Bold"&12&A

Financial Ratios

Glaxosmithklien PLC Financial Analysis
DuPont Analysis Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Net Profitability 24.82% 11.78% 19.40% 16.65% 18.79% 5.66% 18.99% 18.49% 22.48% 22.90% 21.29%
Total Asset Turnover 0.704 0.548 0.677 0.679 0.675 0.662 0.742 0.611 0.825 0.952
Equity Multiplier 6.840 6.449 5.736 5.318 4.487 4.149 4.381 3.886 2.940 3.034
Return on Equity 119.52% 41.61% 75.33% 60.14% 56.93% 15.54% 61.75% 43.90% 54.52% 66.16%
Profitability Analysis
Gross Profitability 80.37% 75.90% 75.04% 76.94% 79.15% 80.18% 81.01% 81.74% 81.96% 82.50% 82.47%
Operating Profitability 41.78% 23.77% 26.93% 26.88% 29.99% 17.75% 30.50% 33.18% 34.20% 32.90% 31.21%
Net Profitability 24.82% 11.78% 19.40% 16.65% 18.79% 5.66% 18.99% 18.49% 22.48% 22.90% 21.29%
Return on Assets 17.47% 6.45% 13.13% 11.31% 12.69% 3.75% 14.09% 11.30% 18.55% 21.81%
Return on Equity 119.52% 41.61% 75.33% 60.14% 56.93% 15.54% 61.75% 43.90% 54.52% 66.16%
Efficiency Analysis
Receivable Turnover 6.741 4.677 5.510 5.448 5.200 4.793 5.018 3.794 4.486 4.829
Receivable DSO 54.147 78.040 66.245 67.003 70.194 76.154 72.740 96.197 81.372 75.581
Inventory Turnover 1.450 1.345 1.794 1.648 1.521 1.413 1.431 1.107 1.531 1.894
Inventory DCO 251.711 271.413 203.412 221.429 239.983 258.344 255.020 329.752 238.482 192.716
Net PP&E Turnover 3.529 2.529 3.205 3.200 3.162 3.058 3.214 2.453 3.164 3.686
Net Fixed Asset Turnover 1.055 0.857 1.035 1.063 1.101 1.095 1.286 1.089 1.461 1.752
Total Asset Turnover 0.704 0.548 0.677 0.679 0.675 0.662 0.742 0.611 0.825 0.952
Liquidity Analysis
Current Ratio 1.236 1.104 1.113 0.991 1.077 1.253 1.450 1.724 1.317 1.513 1.385
Quick Ratio 0.842 0.664 0.793 0.672 0.745 0.921 1.074 1.198 0.946 1.127 1.101
Cash Ratio 0.440 0.331 0.409 0.309 0.393 0.488 0.562 0.600 0.438 0.418 0.550
Times Interest Earned 21.193 8.187 10.336 9.758 11.378 6.499 11.287 10.023 18.274 24.659 16.098
Accounts Payable Turnover 2.277 2.004 2.614 2.574 2.520 2.589 4.093 3.678 5.424 5.864
Accounts Payable DCO (DPO) 160.333 182.100 139.633 141.784 144.850 140.964 89.185 99.227 67.291 62.243
Leverage Ratio
Total Debt to Total Assets 0.834 0.879 0.814 0.837 0.785 0.769 0.749 0.799 0.690 0.622 0.722
Long Term Term Debt to Total Assets 0.583 0.552 0.489 0.504 0.420 0.466 0.467 0.535 0.347 0.338 0.372
Total Debt to Total Equity 5.020 7.236 4.387 5.147 3.654 3.334 2.990 3.967 2.228 1.649 2.593

&"Arial,Bold"&12&A

FINANCIAL MERCK.xlsx

Balance Sheets

Merck & Co. ANNUAL BALANCE SHEET
TICKER: MRK
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
ASSETS
Cash & Equivalents $ 13,427.00 $ 15,719.00 $ 17,486.00 $ 16,141.00 $ 14,972.00 $ 12,201.00 $ 9,604.50 $ 5,486.40 $ 8,230.80 $ 8,713.00 $ 15,637.60
Net Receivables $ 6,484.00 $ 6,626.00 $ 7,184.00 $ 7,672.00 $ 8,261.00 $ 7,344.00 $ 6,602.90 $ 3,778.90 $ 3,636.20 $ 3,314.80 $ 2,927.30
Inventories $ 4,700.00 $ 5,571.00 $ 6,226.00 $ 6,535.00 $ 6,254.00 $ 5,868.00 $ 8,055.30 $ 2,283.30 $ 1,881.00 $ 1,769.40 $ 1,658.10
Prepaid Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 467.90 $ 255.30 $ 826.30
Other Current Assets $ 5,153.00 $ 5,257.00 $ 4,789.00 $ 4,509.00 $ 3,694.00 $ 3,651.00 $ 4,165.90 $ 7,756.30 $ 829.50 $ 1,177.70 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Assets $ 29,764.00 $ 33,173.00 $ 35,685.00 $ 34,857.00 $ 33,181.00 $ 29,064.00 $ 28,428.60 $ 19,304.90 $ 15,045.40 $ 15,230.20 $ 21,049.30
Gross Plant, Property & Equipment $ 28,430.00 $ 31,140.00 $ 33,094.00 $ 33,415.00 $ 32,473.00 $ 30,563.00 $ 30,868.10 $ 24,128.20 $ 24,803.10 $ 24,209.50 $ 23,713.30
Accumulated Depreciation $ 15,923.00 $ 18,004.00 $ 18,121.00 $ 17,385.00 $ 16,176.00 $ 13,481.00 $ 12,594.60 $ 12,128.60 $ 12,457.10 $ 11,015.40 $ 9,315.10
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Net Plant, Property & Equipment $ 12,507.00 $ 13,136.00 $ 14,973.00 $ 16,030.00 $ 16,297.00 $ 17,082.00 $ 18,273.50 $ 11,999.60 $ 12,346.00 $ 13,194.10 $ 14,398.20
Investments at Equity $ 702.00 $ 337.00 $ 1,600.00 $ 1,300.00 $ 886.00 $ 494.00 $ 900.00 $ 1,400.00 $ 3,900.00 $ 3,500.00 $ 3,000.00
Other Investments $ 13,049.00 $ 13,595.00 $ 9,770.00 $ 7,305.00 $ 3,458.00 $ 2,175.00 $ 432.30 $ 6,491.30 $ 7,159.20 $ 7,788.20 $ 1,107.90
Intangibles $ 40,325.00 $ 33,378.00 $ 36,102.00 $ 41,217.00 $ 46,457.00 $ 51,834.00 $ 59,578.90 $ 1,964.10 $ 2,168.00 $ 2,375.50 $ 1,604.40
Deferred Charges $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Assets $ 5,432.00 $ 4,716.00 $ 7,515.00 $ 5,423.00 $ 4,849.00 $ 5,132.00 $ 4,476.40 $ 6,035.80 $ 7,732.10 $ 2,481.80 $ 3,686.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL ASSETS $ 101,779.00 $ 98,335.00 $ 105,645.00 $ 106,132.00 $ 105,128.00 $ 105,781.00 $ 112,089.70 $ 47,195.70 $ 48,350.70 $ 44,569.80 $ 44,845.80
LIABILITIES
Long Term Debt Due In One Year $ 2,300.00 $ 1,000.00 $ 2,100.00 $ 1,800.00 $ 24.00 $ 1,500.00 $ 748.60 $ 7.40 $ 1,400.00 $ 449.00 $ 522.00
Notes Payable $ 285.00 $ 1,704.00 $ 2,421.00 $ 2,515.00 $ 1,966.00 $ 900.00 $ 837.20 $ 2,289.70 $ 423.60 $ 836.10 $ 2,450.00
Accounts Payable $ 2,533.00 $ 2,625.00 $ 2,274.00 $ 1,753.00 $ 2,462.00 $ 2,308.00 $ 2,236.90 $ 617.60 $ 624.50 $ 496.60 $ 471.10
Taxes Payable $ 1,560.00 $ 1,606.00 $ 251.00 $ 1,200.00 $ 781.00 $ 1,243.00 $ 1,117.40 $ 1,422.60 $ 444.10 $ 3,398.00 $ 3,489.50
Accrued Expenses @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF @CF
Other Current Liabilities $ 12,525.00 $ 11,831.00 $ 10,822.00 $ 11,080.00 $ 11,012.00 $ 9,690.00 $ 10,810.60 $ 9,981.40 $ 9,366.00 $ 7,543.00 $ 6,370.90
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Liabilities $ 19,203.00 $ 18,766.00 $ 17,868.00 $ 18,348.00 $ 16,245.00 $ 15,641.00 $ 15,750.70 $ 14,318.70 $ 12,258.20 $ 12,722.70 $ 13,303.50
Long Term Debt $ 23,929.00 $ 18,699.00 $ 20,539.00 $ 16,254.00 $ 15,525.00 $ 15,482.00 $ 16,074.90 $ 3,943.30 $ 3,915.80 $ 5,551.00 $ 5,125.60
Deferred Taxes $ 6,535.00 $ 4,266.00 $ 6,776.00 $ 5,740.00 $ 5,626.00 $ 7,411.00 $ 8,797.20 $ 312.20 $ 395.60 $ 852.60 $ 1,269.80
Investment Tax Credit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Liabilities $ 7,345.00 $ 7,813.00 $ 8,136.00 $ 10,327.00 $ 10,789.00 $ 10,442.00 $ 9,974.30 $ 7,454.40 $ 11,189.70 $ 5,477.70 $ 4,823.10
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES $ 57,012.00 $ 49,544.00 $ 53,319.00 $ 50,669.00 $ 48,185.00 $ 48,976.00 $ 50,597.10 $ 26,028.60 $ 27,759.30 $ 24,604.00 $ 24,522.00
Redeemable Noncontrolling Int. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,408.80 $ 2,406.70 $ 2,406.10 $ 2,407.20
EQUITY
Preferred Stock - Redeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Preferred Stock - Nonredeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Preferred Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Common Stock $ 1,788.00 $ 1,788.00 $ 1,788.00 $ 1,788.00 $ 1,788.00 $ 1,788.00 $ 1,781.30 $ 29.80 $ 29.80 $ 29.80 $ 29.80
Capital Surplus $ 40,222.00 $ 40,423.00 $ 40,508.00 $ 40,646.00 $ 40,663.00 $ 40,701.00 $ 39,682.60 $ 8,319.10 $ 8,014.90 $ 7,166.50 $ 6,900.00
Retained Earnings $ 41,200.00 $ 41,698.00 $ 37,060.00 $ 35,303.00 $ 35,858.00 $ 34,320.00 $ 38,638.40 $ 41,144.90 $ 38,314.70 $ 37,930.80 $ 37,971.20
Less: Treasury Stock $ 38,534.00 $ 35,262.00 $ 29,591.00 $ 24,717.00 $ 23,792.00 $ 22,433.00 $ 21,044.30 $ 30,735.50 $ 28,174.70 $ 27,567.40 $ 26,984.40
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Common Equity $ 44,676.00 $ 48,647.00 $ 49,765.00 $ 53,020.00 $ 54,517.00 $ 54,376.00 $ 59,058.00 $ 18,758.30 $ 18,184.70 $ 17,559.70 $ 17,916.60
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Stockholder's Equity - Parent $ 44,676.00 $ 48,647.00 $ 49,765.00 $ 53,020.00 $ 54,517.00 $ 54,376.00 $ 59,058.00 $ 18,758.30 $ 18,184.70 $ 17,559.70 $ 17,916.60
Nonredeemable Noncontrolling Int. $ 91.00 $ 144.00 $ 2,561.00 $ 2,443.00 $ 2,426.00 $ 2,429.00 $ 2,434.60 @NA @NA @NA @NA
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL EQUITY $ 44,767.00 $ 48,791.00 $ 52,326.00 $ 55,463.00 $ 56,943.00 $ 56,805.00 $ 61,492.60 $ 18,758.30 $ 18,184.70 $ 17,559.70 $ 17,916.60
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES & EQUITY $ 101,779.00 $ 98,335.00 $ 105,645.00 $ 106,132.00 $ 105,128.00 $ 105,781.00 $ 112,089.70 $ 47,195.70 $ 48,350.70 $ 44,569.80 $ 44,845.80
COMMON SHARES OUTSTANDING 2,781.13 2,838.14 2,927.53 3,026.64 3,040.84 3,082.11 3,108.22 2,107.69 2,172.50 2,167.79 2,181.92

&"Arial,Bold"&12&A

Income Statements

Merck & Co. ANNUAL INCOME STATEMENT
TICKER: MRK
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Sales $ 39,498.00 $ 42,237.00 $ 44,033.00 $ 47,267.00 $ 48,047.00 $ 45,987.00 $ 27,428.30 $ 23,850.30 $ 24,197.70 $ 22,636.00 $ 22,011.90
Cost of Goods Sold $ 8,214.00 $ 9,441.00 $ 9,570.00 $ 9,379.00 $ 9,304.00 $ 8,916.00 $ 4,948.40 $ 3,916.80 $ 4,130.00 $ 3,760.10 $ 3,330.30
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Gross Profit $ 31,284.00 $ 32,796.00 $ 34,463.00 $ 37,888.00 $ 38,743.00 $ 37,071.00 $ 22,479.90 $ 19,933.50 $ 20,067.70 $ 18,875.90 $ 18,681.60
Selling, General, &
Administrative Expense $ 16,412.00 $ 17,339.00 $ 18,795.00 $ 20,461.00 $ 21,341.00 $ 21,363.00 $ 13,898.70 $ 12,079.90 $ 12,289.00 $ 11,408.00 $ 10,708.50
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Income Before Deprec. $ 14,872.00 $ 15,457.00 $ 15,668.00 $ 17,427.00 $ 17,402.00 $ 15,708.00 $ 8,581.20 $ 7,853.60 $ 7,778.70 $ 7,467.90 $ 7,973.10
Depreciation, Depletion, &
Amortization $ 6,201.00 $ 5,791.00 $ 6,411.00 $ 6,743.00 $ 6,838.00 $ 6,532.00 $ 2,227.50 $ 1,414.50 $ 1,527.60 $ 1,504.60 $ 1,520.40
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Profit $ 8,671.00 $ 9,666.00 $ 9,257.00 $ 10,684.00 $ 10,564.00 $ 9,176.00 $ 6,353.70 $ 6,439.10 $ 6,251.10 $ 5,963.30 $ 6,452.70
Interest Expense $ 672.00 $ 732.00 $ 801.00 $ 714.00 $ 749.00 $ 698.00 $ 284.50 $ 251.30 $ 384.30 $ 375.10 $ 385.50
Non-Operating Income/Expense $ 358.00 $ 561.00 $ 517.00 $ 733.00 $ 650.00 $ 603.00 $ 2,750.40 $ 3,016.30 $ 4,007.10 $ 3,172.70 $ 2,334.60
Special Items $ (2,956.00) $ 7,788.00 $ (3,428.00) $ (1,964.00) $ (3,131.00) $ (7,428.00) $ 6,472.20 $ 727.60 $ (6,381.80) $ (2,419.00) $ (916.10)
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Pretax Income $ 5,401.00 $ 17,283.00 $ 5,545.00 $ 8,739.00 $ 7,334.00 $ 1,653.00 $ 15,291.80 $ 9,931.70 $ 3,492.10 $ 6,341.90 $ 7,485.70
Total Income Taxes $ 942.00 $ 5,349.00 $ 1,028.00 $ 2,440.00 $ 942.00 $ 671.00 $ 2,267.60 $ 1,999.40 $ 95.30 $ 1,787.60 $ 2,732.60
Minority Interest ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
$ 4,459.00 $ 11,934.00 $ 4,517.00 $ 6,299.00 $ 6,392.00 $ 982.00 $ 13,024.20 @NA @NA @NA @NA
Noncontrolling Interest - Inc Acc $ 17.00 $ 14.00 $ 113.00 $ 131.00 $ 120.00 $ 121.00 $ 122.90 $ 123.90 $ 121.40 $ 120.50 $ 121.80
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary
Items & Discontinued Operations $ 4,442.00 $ 11,920.00 $ 4,404.00 $ 6,168.00 $ 6,272.00 $ 861.00 $ 12,901.30 $ 7,808.40 $ 3,275.40 $ 4,433.80 $ 4,631.30
Preferred Dividends $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2.10 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Available for Common $ 4,442.00 $ 11,920.00 $ 4,404.00 $ 6,168.00 $ 6,272.00 $ 861.00 $ 12,899.20 $ 7,808.40 $ 3,275.40 $ 4,433.80 $ 4,631.30
Savings Due to Common
Stock Equivalents $ - 0 $ - 0 $ - 0 $ (3.00) $ (15.00) $ (2.00) $ (46.30) $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Available for Common $ 4,442.00 $ 11,920.00 $ 4,404.00 $ 6,165.00 $ 6,257.00 $ 859.00 $ 12,852.90 $ 7,808.40 $ 3,275.40 $ 4,433.80 $ 4,631.30
Extraordinary Items $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Discontinued Operations $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Net Income $ 4,442.00 $ 11,920.00 $ 4,404.00 $ 6,165.00 $ 6,257.00 $ 859.00 $ 12,852.90 $ 7,808.40 $ 3,275.40 $ 4,433.80 $ 4,631.30
Income to Company Incl Extraordinary
Items & Disc Ops $ 4,459.00 $ 11,934.00 $ 4,517.00 $ 6,299.00 $ 6,392.00 $ 982.00 $ 13,024.20 @NA @NA @NA @NA
Earnings Per Share Basic -
Excluding Extra Items & Disc Op $ 1.58 $ 4.12 $ 1.49 $ 2.03 $ 2.04 $ 0.28 $ 5.67 $ 3.66 $ 1.51 $ 2.04 $ 2.11
Earnings Per Share Basic -
Including Extra Items & Disc Op $ 1.58 $ 4.12 $ 1.49 $ 2.03 $ 2.04 $ 0.28 $ 5.67 $ 3.66 $ 1.51 $ 2.04 $ 2.11
Earnings Per Share Diluted-
Excluding Extra Items & Disc Op $ 1.56 $ 4.07 $ 1.47 $ 2.00 $ 2.02 $ 0.28 $ 5.65 $ 3.64 $ 1.49 $ 2.03 $ 2.10
Earning Per Share Diluted -
Including Extra Items & Disc Op $ 1.56 $ 4.07 $ 1.47 $ 2.00 $ 2.02 $ 0.28 $ 5.65 $ 3.64 $ 1.49 $ 2.03 $ 2.10
EPS Basic from Operations $ 2.22 $ 2.09 $ 2.13 $ 2.50 $ 2.38 $ 1.76 $ 3.81 $ 3.50 $ 3.44 $ 2.76 $ 2.68
EPS Diluted from Ops $ 2.20 $ 2.06 $ 2.11 $ 2.48 $ 2.37 $ 1.74 $ 3.80 $ 3.48 $ 3.41 $ 2.82 $ 2.65
Dividends Per Share $ 1.81 $ 1.77 $ 1.73 $ 1.69 $ 1.56 $ 1.52 $ 1.52 $ 1.52 $ 1.52 $ 1.52 $ 1.52
Com Shares for Diluted EPS 2,841.00 2,928.00 2,996.00 3,076.00 3,094.00 3,120.00 2,273.20 2,145.30 2,192.90 2,187.70 2,200.40
Com Shares for Basic Eps 2,816.00 2,894.00 2,963.00 3,041.00 3,071.00 3,095.00 2,268.20 2,135.80 2,170.50 2,177.60 2,197.00

&"Arial,Bold"&12&A

Financial Ratios

Merck & Co. Financial Analysis
DuPont Analysis Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Net Profitability 11.25% 28.22% 10.00% 13.05% 13.05% 1.87% 47.04% 32.74% 13.54% 19.59% 21.04%
Total Asset Turnover 0.395 0.414 0.416 0.447 0.456 0.422 0.344 0.499 0.521 0.506
Equity Multiplier 2.139 2.017 1.965 1.879 1.854 1.842 1.985 2.586 2.600 2.520
Return on Equity 9.50% 23.58% 8.17% 10.97% 11.03% 1.46% 32.15% 42.27% 18.33% 25.00%
Profitability Analysis
Gross Profitability 79.20% 77.65% 78.27% 80.16% 80.64% 80.61% 81.96% 83.58% 82.93% 83.39% 84.87%
Operating Profitability 21.95% 22.89% 21.02% 22.60% 21.99% 19.95% 23.16% 27.00% 25.83% 26.34% 29.31%
Net Profitability 11.25% 28.22% 10.00% 13.05% 13.05% 1.87% 47.04% 32.74% 13.54% 19.59% 21.04%
Return on Assets 4.44% 11.69% 4.16% 5.84% 5.95% 0.79% 16.20% 16.34% 7.05% 9.92%
Return on Equity 9.50% 23.58% 8.17% 10.97% 11.03% 1.46% 32.15% 42.27% 18.33% 25.00%
Efficiency Analysis
Receivable Turnover 6.026 6.117 5.928 5.933 6.158 6.595 5.284 6.433 6.962 7.253
Receivable DSO 60.575 59.671 61.572 61.518 59.273 55.348 69.078 56.740 52.425 50.326
Inventory Turnover 1.599 1.601 1.500 1.467 1.535 1.281 0.957 1.881 2.263 2.194
Inventory DCO 228.203 228.043 243.352 248.853 237.776 284.994 381.294 194.032 161.307 166.357
Net PP&E Turnover 3.081 3.005 2.841 2.924 2.879 2.601 1.812 1.959 1.895 1.641
Net Fixed Asset Turnover 0.576 0.625 0.624 0.660 0.646 0.573 0.492 0.779 0.773 0.852
Total Asset Turnover 0.395 0.414 0.416 0.447 0.456 0.422 0.344 0.499 0.521 0.506
Liquidity Analysis
Current Ratio 1.550 1.768 1.997 1.900 2.043 1.858 1.805 1.348 1.227 1.197 1.582
Quick Ratio 1.037 1.191 1.381 1.298 1.430 1.250 1.029 0.647 0.968 0.945 1.395
Cash Ratio 0.699 0.838 0.979 0.880 0.922 0.780 0.610 0.383 0.671 0.685 1.175
Times Interest Earned 12.903 13.205 11.557 14.964 14.104 13.146 22.333 25.623 16.266 15.898 16.739
Accounts Payable Turnover 2.847 3.587 4.599 4.584 4.063 2.961 7.511 6.955 7.567 8.001
Accounts Payable DCO (DPO) 128.195 101.760 79.357 79.631 89.837 123.270 48.594 52.484 48.237 45.618
Leverage Ratio
Total Debt to Total Assets 0.560 0.504 0.505 0.477 0.458 0.463 0.451 0.603 0.624 0.606 0.600
Long Term Term Debt to Total Assets 0.371 0.313 0.336 0.305 0.304 0.315 0.311 0.248 0.321 0.267 0.250
Total Debt to Total Equity 1.274 1.015 1.019 0.914 0.846 0.862 0.823 1.516 1.659 1.538 1.503

&"Arial,Bold"&12&A

FINANCIAL NOVARTIS.xlsx

Balance Sheets

Novartis AG (ADR) ANNUAL BALANCE SHEET
TICKER: NVS
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
ASSETS
Cash & Equivalents $ 5,304.00 $ 13,506.00 $ 9,101.00 $ 8,119.00 $ 5,075.00 $ 8,134.00 $ 17,449.00 $ 6,117.00 $ 13,201.00 $ 7,955.00 $ 10,933.00
Net Receivables $ 10,551.00 $ 10,255.00 $ 12,625.00 $ 12,533.00 $ 12,373.00 $ 11,716.00 $ 10,010.00 $ 8,573.00 $ 8,504.00 $ 7,971.00 $ 6,563.00
Inventories $ 6,226.00 $ 6,093.00 $ 7,354.00 $ 6,744.00 $ 5,930.00 $ 6,093.00 $ 5,830.00 $ 5,792.00 $ 5,455.00 $ 4,498.00 $ 3,725.00
Prepaid Expenses $ 621.00 $ 550.00 $ 674.00 $ 608.00 $ 706.00 $ 742.00 $ 402.00 $ 399.00 $ 270.00 $ 244.00 $ 222.00
Other Current Assets $ 143.00 $ 7,157.00 $ 788.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 736.00 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Assets $ 22,845.00 $ 37,561.00 $ 30,542.00 $ 28,004.00 $ 24,084.00 $ 26,685.00 $ 33,691.00 $ 20,881.00 $ 27,430.00 $ 21,404.00 $ 21,443.00
Gross Plant, Property & Equipment $ 31,448.00 $ 31,428.00 $ 35,601.00 $ 32,772.00 $ 29,935.00 $ 28,957.00 $ 25,900.00 $ 23,973.00 $ 22,800.00 $ 19,703.00 $ 16,514.00
Accumulated Depreciation $ 15,466.00 $ 15,445.00 $ 17,259.00 $ 15,833.00 $ 14,308.00 $ 13,117.00 $ 11,825.00 $ 10,873.00 $ 10,167.00 $ 8,758.00 $ 7,835.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Net Plant, Property & Equipment $ 15,982.00 $ 15,983.00 $ 18,342.00 $ 16,939.00 $ 15,627.00 $ 15,840.00 $ 14,075.00 $ 13,100.00 $ 12,633.00 $ 10,945.00 $ 8,679.00
Investments at Equity $ 15,314.00 $ 8,432.00 $ 9,225.00 $ 8,840.00 $ 8,622.00 $ 8,386.00 $ 17,794.00 $ 17,712.00 $ 6,945.00 $ 6,111.00 $ 7,086.00
Other Investments $ 1,796.00 @NA @NA @CF $ 1,356.00 $ 1,262.00 $ 1,375.00 $ 1,182.00 $ 1,319.00 $ 2,313.00 $ 1,910.00
Intangibles $ 65,391.00 $ 53,143.00 $ 58,867.00 $ 61,421.00 $ 61,912.00 $ 64,923.00 $ 22,370.00 $ 20,819.00 $ 21,249.00 $ 21,230.00 $ 13,294.00
Deferred Charges $ 36.00 $ 37.00 $ 42.00 $ 55.00 $ 38.00 $ 982.00 $ 1,585.00 $ 182.00 $ 2,309.00 $ 2,102.00 $ 1,919.00
Other Assets $ 10,192.00 $ 10,231.00 $ 9,236.00 $ 8,957.00 $ 5,857.00 $ 5,240.00 $ 4,615.00 $ 4,423.00 $ 3,567.00 $ 3,903.00 $ 3,401.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL ASSETS $ 131,556.00 $ 125,387.00 $ 126,254.00 $ 124,216.00 $ 117,496.00 $ 123,318.00 $ 95,505.00 $ 78,299.00 $ 75,452.00 $ 68,008.00 $ 57,732.00
LIABILITIES
Long Term Debt Due In One Year $ 1,659.00 $ 2,989.00 $ 2,590.00 $ 2,009.00 $ 778.00 $ 98.00 $ 29.00 $ 17.00 $ 24.00 $ 1,340.00 $ 1,122.00
Notes Payable $ 3,915.00 $ 3,571.00 $ 4,083.00 $ 3,936.00 $ 5,596.00 $ 8,529.00 $ 5,284.00 $ 5,169.00 $ 5,093.00 $ 5,303.00 $ 5,768.00
Accounts Payable $ 5,668.00 $ 5,419.00 $ 6,148.00 $ 5,593.00 $ 4,989.00 $ 4,788.00 $ 4,012.00 $ 3,395.00 $ 3,018.00 $ 2,487.00 $ 1,961.00
Taxes Payable $ 1,717.00 $ 2,076.00 $ 2,459.00 $ 2,070.00 $ 1,706.00 $ 1,710.00 $ 1,816.00 $ 1,376.00 $ 1,719.00 $ 1,161.00 $ 1,253.00
Accrued Expenses $ 4,366.00 $ 4,402.00 $ 3,818.00 $ 3,359.00 $ 3,372.00 $ 3,345.00 $ 2,830.00 $ 2,546.00 $ 2,280.00 $ 1,950.00 $ 1,999.00
Other Current Liabilities $ 6,383.00 $ 8,516.00 $ 7,270.00 $ 7,084.00 $ 6,707.00 $ 6,188.00 $ 5,499.00 $ 4,001.00 $ 4,507.00 $ 3,993.00 $ 3,225.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Liabilities $ 23,708.00 $ 26,973.00 $ 26,368.00 $ 24,051.00 $ 23,148.00 $ 24,658.00 $ 19,470.00 $ 16,504.00 $ 16,641.00 $ 16,234.00 $ 15,328.00
Long Term Debt $ 16,327.00 $ 13,799.00 $ 11,242.00 $ 13,781.00 $ 13,855.00 $ 14,360.00 $ 8,675.00 $ 2,178.00 $ 677.00 $ 656.00 $ 1,319.00
Deferred Taxes $ 6,355.00 $ 6,099.00 $ 6,904.00 $ 7,286.00 $ 6,761.00 $ 7,689.00 $ 4,407.00 $ 4,144.00 $ 4,466.00 $ 5,290.00 $ 3,472.00
Investment Tax Credit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Liabilities $ 8,044.00 $ 7,672.00 $ 7,268.00 $ 9,879.00 $ 7,792.00 $ 6,842.00 $ 5,491.00 $ 5,036.00 $ 4,272.00 $ 4,534.00 $ 4,449.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES $ 54,434.00 $ 54,543.00 $ 51,782.00 $ 54,997.00 $ 51,556.00 $ 53,549.00 $ 38,043.00 $ 27,862.00 $ 26,056.00 $ 26,714.00 $ 24,568.00
Redeemable Noncontrolling Int. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 149.00 $ 173.00 @CF $ 174.00
EQUITY
Preferred Stock - Redeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Preferred Stock - Nonredeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Preferred Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Common Stock $ 991.00 $ 1,001.00 $ 1,001.00 $ 1,001.00 $ 1,016.00 $ 957.00 $ 957.00 $ 959.00 $ 990.00 $ 990.00 $ 994.00
Capital Surplus $ - 0 $ - 0 $ - 0 $ 198.00 $ 198.00 $ 198.00 $ 198.00 $ 198.00 $ 198.00 $ 198.00 $ 199.00
Retained Earnings $ 76,156.00 $ 69,868.00 $ 73,431.00 $ 67,986.00 $ 64,751.00 $ 62,166.00 $ 56,364.00 $ 49,270.00 $ 48,210.00 $ 40,246.00 $ 31,943.00
Less: Treasury Stock $ 101.00 $ 103.00 $ 89.00 $ 92.00 $ 121.00 $ 125.00 $ 132.00 $ 139.00 $ 175.00 $ 140.00 $ 146.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Common Equity $ 77,046.00 $ 70,766.00 $ 74,343.00 $ 69,093.00 $ 65,844.00 $ 63,196.00 $ 57,387.00 $ 50,288.00 $ 49,223.00 $ 41,294.00 $ 32,990.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Stockholder's Equity - Parent $ 77,046.00 $ 70,766.00 $ 74,343.00 $ 69,093.00 $ 65,844.00 $ 63,196.00 $ 57,387.00 $ 50,288.00 $ 49,223.00 $ 41,294.00 $ 32,990.00
Nonredeemable Noncontrolling Int. $ 76.00 $ 78.00 $ 129.00 $ 126.00 $ 96.00 $ 6,573.00 $ 75.00 @NA @NA @NA @NA
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL EQUITY $ 77,122.00 $ 70,844.00 $ 74,472.00 $ 69,219.00 $ 65,940.00 $ 69,769.00 $ 57,462.00 $ 50,288.00 $ 49,223.00 $ 41,294.00 $ 32,990.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES & EQUITY $ 131,556.00 $ 125,387.00 $ 126,254.00 $ 124,216.00 $ 117,496.00 $ 123,318.00 $ 95,505.00 $ 78,299.00 $ 75,452.00 $ 68,008.00 $ 57,732.00
COMMON SHARES OUTSTANDING 2,373.90 2,398.63 2,426.08 2,420.62 2,406.69 2,289.45 2,274.35 2,264.85 2,264.45 2,348.23 2,335.92

&"Arial,Bold"&12&A

Income Statements

Novartis AG (ADR) ANNUAL INCOME STATEMENT
TICKER: NVS
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Sales $ 49,440.00 $ 52,419.00 $ 57,920.00 $ 56,617.00 $ 58,683.00 $ 50,624.00 $ 44,267.00 $ 41,459.00 $ 38,072.00 $ 36,031.00 $ 32,212.00
Cost of Goods Sold $ 12,026.00 $ 12,802.00 $ 15,036.00 $ 14,020.00 $ 14,093.00 $ 11,609.00 $ 9,913.00 $ 9,139.00 $ 8,491.00 $ 8,449.00 $ 7,566.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Gross Profit $ 37,414.00 $ 39,617.00 $ 42,884.00 $ 42,597.00 $ 44,590.00 $ 39,015.00 $ 34,354.00 $ 32,320.00 $ 29,581.00 $ 27,582.00 $ 24,646.00
Selling, General, &
Administrative Expense $ 22,939.00 $ 23,976.00 $ 27,422.00 $ 26,587.00 $ 27,720.00 $ 23,946.00 $ 21,800.00 $ 21,314.00 $ 19,210.00 $ 17,118.00 $ 16,753.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Income Before Deprec. $ 14,475.00 $ 15,641.00 $ 15,462.00 $ 16,010.00 $ 16,870.00 $ 15,069.00 $ 12,554.00 $ 11,006.00 $ 10,371.00 $ 10,464.00 $ 7,893.00
Depreciation, Depletion, &
Amortization $ 5,225.00 $ 4,361.00 $ 4,731.00 $ 4,598.00 $ 4,756.00 $ 2,498.00 $ 2,266.00 $ 2,300.00 $ 2,221.00 $ 1,850.00 $ 1,302.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Profit $ 9,250.00 $ 11,280.00 $ 10,731.00 $ 11,412.00 $ 12,114.00 $ 12,571.00 $ 10,288.00 $ 8,706.00 $ 8,150.00 $ 8,614.00 $ 6,591.00
Interest Expense $ 676.00 $ 724.00 $ 692.00 $ 724.00 $ 751.00 $ 692.00 $ 551.00 $ 290.00 $ 237.00 $ 266.00 $ 343.00
Non-Operating Income/Expense $ 295.00 $ 1,924.00 $ 1,057.00 $ 972.00 $ 69.00 $ 1,188.00 $ 522.00 $ 1,083.00 $ 717.00 $ 595.00 $ 1,017.00
Special Items $ (735.00) $ (208.00) $ (361.00) $ (417.00) $ (659.00) $ (1,365.00) $ (337.00) @CF $ (1,143.00) $ (642.00) @CF
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Pretax Income $ 8,134.00 $ 12,272.00 $ 10,735.00 $ 11,243.00 $ 10,773.00 $ 11,702.00 $ 9,922.00 $ 9,499.00 $ 7,487.00 $ 8,301.00 $ 7,265.00
Total Income Taxes $ 1,106.00 $ 1,545.00 $ 1,443.00 $ 1,625.00 $ 1,528.00 $ 1,733.00 $ 1,468.00 $ 1,336.00 $ 947.00 $ 1,282.00 $ 1,124.00
Minority Interest ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
$ 7,028.00 $ 10,727.00 $ 9,292.00 $ 9,618.00 $ 9,245.00 $ 9,969.00 $ 8,454.00 @NA @NA @NA @NA
Noncontrolling Interest - Inc Acc $ 3.00 $ 73.00 $ 117.00 $ 113.00 $ 132.00 $ 175.00 $ 54.00 $ 38.00 $ 22.00 $ 27.00 $ 11.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary
Items & Discontinued Operations $ 7,025.00 $ 10,654.00 $ 9,175.00 $ 9,505.00 $ 9,113.00 $ 9,794.00 $ 8,400.00 $ 8,125.00 $ 6,518.00 $ 6,992.00 $ 6,130.00
Preferred Dividends $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Available for Common $ 7,025.00 $ 10,654.00 $ 9,175.00 $ 9,505.00 $ 9,113.00 $ 9,794.00 $ 8,400.00 $ 8,125.00 $ 6,518.00 $ 6,992.00 $ 6,130.00
Savings Due to Common
Stock Equivalents $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Available for Common $ 7,025.00 $ 10,654.00 $ 9,175.00 $ 9,505.00 $ 9,113.00 $ 9,794.00 $ 8,400.00 $ 8,125.00 $ 6,518.00 $ 6,992.00 $ 6,130.00
Extraordinary Items $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Discontinued Operations $ 10,758.00 $ (444.00) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 70.00 $ 5,428.00 $ 183.00 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Net Income $ 17,783.00 $ 10,210.00 $ 9,175.00 $ 9,505.00 $ 9,113.00 $ 9,794.00 $ 8,400.00 $ 8,195.00 $ 11,946.00 $ 7,175.00 $ 6,130.00
Income to Company Incl Extraordinary
Items & Disc Ops $ 17,786.00 $ 10,283.00 $ 9,292.00 $ 9,618.00 $ 9,245.00 $ 9,969.00 $ 8,454.00 @NA @NA @NA @NA
Earnings Per Share Basic -
Excluding Extra Items & Disc Op $ 2.92 $ 4.39 $ 3.76 $ 3.93 $ 3.83 $ 4.28 $ 3.70 $ 3.59 $ 2.81 $ 2.98 $ 2.63
Earnings Per Share Basic -
Including Extra Items & Disc Op $ 7.40 $ 4.21 $ 3.76 $ 3.93 $ 3.83 $ 4.28 $ 3.70 $ 3.62 $ 5.15 $ 3.06 $ 2.63
Earnings Per Share Diluted-
Excluding Extra Items & Disc Op $ 2.88 $ 4.31 $ 3.70 $ 3.89 $ 3.78 $ 4.26 $ 3.69 $ 3.56 $ 2.80 $ 2.96 $ 2.62
Earning Per Share Diluted -
Including Extra Items & Disc Op $ 7.29 $ 4.13 $ 3.70 $ 3.89 $ 3.78 $ 4.26 $ 3.69 $ 3.59 $ 5.13 $ 3.04 $ 2.62
EPS Basic from Operations $ 3.16 $ 4.46 $ 3.87 $ 4.07 $ 4.06 $ 4.79 $ 3.83 $ 3.56 $ 3.23 $ 3.21 $ 2.79
EPS Diluted from Ops $ 3.12 $ 4.38 $ 3.81 $ 4.02 $ 4.01 $ 4.76 $ 3.81 $ 3.53 $ 3.21 $ 3.19 $ 2.78
Dividends Per Share $ 2.67 $ 2.76 $ 2.43 $ 2.48 $ 2.36 $ 1.95 $ 1.71 $ 1.54 $ 1.10 $ 0.88 $ 0.88
Com Shares for Diluted EPS 2,438.00 2,470.00 2,479.00 2,445.00 2,413.00 2,301.00 2,276.55 2,284.24 2,328.89 2,360.46 2,342.45
Com Shares for Basic Eps 2,402.81 2,425.78 2,440.85 2,418.00 2,382.00 2,286.00 2,267.86 2,265.54 2,317.47 2,345.23 2,332.85

&"Arial,Bold"&12&A

Financial Ratios

Novartis AG (ADR) Financial Analysis
DuPont Analysis Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Net Profitability 14.21% 20.32% 15.84% 16.79% 15.53% 19.35% 18.98% 19.60% 17.12% 19.41% 19.03%
Total Asset Turnover 0.385 0.417 0.462 0.468 0.487 0.463 0.509 0.539 0.531 0.573
Equity Multiplier 1.737 1.732 1.743 1.788 1.774 1.720 1.613 1.545 1.585 1.693
Return on Equity 9.50% 14.66% 12.77% 14.06% 13.43% 15.40% 15.59% 16.33% 14.40% 18.83%
Profitability Analysis
Gross Profitability 75.68% 75.58% 74.04% 75.24% 75.98% 77.07% 77.61% 77.96% 77.70% 76.55% 76.51%
Operating Profitability 18.71% 21.52% 18.53% 20.16% 20.64% 24.83% 23.24% 21.00% 21.41% 23.91% 20.46%
Net Profitability 14.21% 20.32% 15.84% 16.79% 15.53% 19.35% 18.98% 19.60% 17.12% 19.41% 19.03%
Return on Assets 5.47% 8.47% 7.33% 7.86% 7.57% 8.95% 9.67% 10.57% 9.09% 11.12%
Return on Equity 9.50% 14.66% 12.77% 14.06% 13.43% 15.40% 15.59% 16.33% 14.40% 18.83%
Efficiency Analysis
Receivable Turnover 4.752 4.582 4.604 4.546 4.872 4.660 4.764 4.856 4.622 4.958
Receivable DSO 76.802 79.658 79.270 80.282 74.915 78.322 76.612 75.172 78.974 73.616
Inventory Turnover 1.952 1.904 2.133 2.212 2.344 1.947 1.706 1.625 1.706 2.055
Inventory DCO 186.946 191.695 171.115 164.979 155.694 187.436 213.963 224.595 213.923 177.618
Net PP&E Turnover 3.093 3.054 3.283 3.477 3.730 3.385 3.258 3.222 3.229 3.672
Net Fixed Asset Turnover 0.503 0.571 0.604 0.597 0.618 0.639 0.743 0.786 0.805 0.869
Total Asset Turnover 0.385 0.417 0.462 0.468 0.487 0.463 0.509 0.539 0.531 0.573
Liquidity Analysis
Current Ratio 0.964 1.393 1.158 1.164 1.040 1.082 1.730 1.265 1.648 1.318 1.399
Quick Ratio 0.669 0.881 0.824 0.859 0.754 0.805 1.410 0.890 1.304 0.981 1.141
Cash Ratio 0.224 0.501 0.345 0.338 0.219 0.330 0.896 0.371 0.793 0.490 0.713
Times Interest Earned 13.683 15.580 15.507 15.762 16.130 18.166 18.672 30.021 34.388 32.383 19.216
Accounts Payable Turnover 2.193 1.996 2.665 2.804 2.850 2.698 2.687 2.955 3.433 4.147
Accounts Payable DCO (DPO) 166.410 182.911 136.951 130.188 128.091 135.276 135.843 123.509 106.336 88.024
Leverage Ratio
Total Debt to Total Assets 0.414 0.435 0.410 0.443 0.439 0.434 0.398 0.358 0.348 0.393 0.429
Long Term Term Debt to Total Assets 0.234 0.220 0.201 0.249 0.242 0.234 0.194 0.145 0.125 0.154 0.160
Total Debt to Total Equity 0.706 0.770 0.695 0.795 0.782 0.768 0.662 0.557 0.533 0.647 0.750

&"Arial,Bold"&12&A

FINANCIAL PFIZER.xlsx

Balance Sheets

Pfizer, Inc. ANNUAL BALANCE SHEET
TICKER: PFE
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
ASSETS
Cash & Equivalents $ 23,290.00 $ 36,122.00 $ 32,408.00 $ 32,708.00 $ 26,758.00 $ 28,012.00 $ 25,969.00 $ 23,731.00 $ 25,475.00 $ 27,713.00 $ 22,226.00
Net Receivables $ 8,176.00 $ 8,669.00 $ 9,357.00 $ 12,378.00 $ 13,659.00 $ 15,079.00 $ 15,840.00 $ 9,782.00 $ 10,460.00 $ 9,906.00 $ 10,275.00
Inventories $ 7,513.00 $ 5,663.00 $ 6,166.00 $ 7,063.00 $ 7,769.00 $ 8,405.00 $ 12,403.00 $ 4,381.00 $ 5,302.00 $ 6,111.00 $ 6,039.00
Prepaid Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 @CF @CF @CF
Other Current Assets $ 4,825.00 $ 7,248.00 $ 8,313.00 $ 9,266.00 $ 9,542.00 $ 8,972.00 $ 7,458.00 $ 5,182.00 $ 5,612.00 $ 3,219.00 $ 3,356.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Assets $ 43,804.00 $ 57,702.00 $ 56,244.00 $ 61,415.00 $ 57,728.00 $ 60,468.00 $ 61,670.00 $ 43,076.00 $ 46,849.00 $ 46,949.00 $ 41,896.00
Gross Plant, Property & Equipment $ 27,268.00 $ 24,988.00 $ 25,678.00 $ 27,882.00 $ 30,522.00 $ 32,298.00 $ 33,924.00 $ 25,128.00 $ 28,103.00 $ 27,063.00 $ 26,617.00
Accumulated Depreciation $ 13,502.00 $ 13,226.00 $ 13,281.00 $ 13,421.00 $ 13,584.00 $ 13,175.00 $ 11,144.00 $ 11,841.00 $ 12,369.00 $ 10,431.00 $ 9,527.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Net Plant, Property & Equipment $ 13,766.00 $ 11,762.00 $ 12,397.00 $ 14,461.00 $ 16,938.00 $ 19,123.00 $ 22,780.00 $ 13,287.00 $ 15,734.00 $ 16,632.00 $ 17,090.00
Investments at Equity @CF @CF @CF @CF @CF @CF @CF $ - 0 $ - 0 $ - 0 $ - 0
Other Investments $ 15,999.00 $ 17,518.00 $ 16,406.00 $ 14,149.00 $ 9,457.00 $ 9,748.00 $ 13,122.00 $ 11,478.00 $ 4,856.00 $ 3,892.00 $ 2,497.00
Intangibles $ 88,598.00 $ 77,236.00 $ 81,904.00 $ 90,685.00 $ 98,900.00 $ 101,505.00 $ 110,391.00 $ 39,185.00 $ 41,880.00 $ 45,226.00 $ 51,560.00
Deferred Charges $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 @CF @CF @CF @CF
Other Assets $ 5,293.00 $ 5,056.00 $ 5,150.00 $ 5,088.00 $ 4,979.00 $ 4,170.00 $ 4,986.00 $ 4,122.00 $ 5,949.00 $ 2,138.00 $ 4,522.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL ASSETS $ 167,460.00 $ 169,274.00 $ 172,101.00 $ 185,798.00 $ 188,002.00 $ 195,014.00 $ 212,949.00 $ 111,148.00 $ 115,268.00 $ 114,837.00 $ 117,565.00
LIABILITIES
Long Term Debt Due In One Year $ 3,720.00 $ 3,011.00 $ 2,060.00 $ 2,449.00 $ 6.00 $ 3,502.00 $ 27.00 $ 937.00 $ 1,024.00 $ 712.00 $ 778.00
Notes Payable $ 6,440.00 $ 2,130.00 $ 3,967.00 $ 3,975.00 $ 4,012.00 $ 2,121.00 $ 5,442.00 $ 8,383.00 $ 4,801.00 $ 1,722.00 $ 10,811.00
Accounts Payable $ 3,620.00 $ 3,440.00 $ 3,234.00 $ 4,264.00 $ 3,836.00 $ 4,026.00 $ 4,370.00 $ 1,751.00 $ 2,270.00 $ 2,019.00 $ 2,226.00
Taxes Payable $ 418.00 $ 531.00 $ 678.00 $ 1,010.00 $ 1,013.00 $ 946.00 $ 10,107.00 $ 656.00 $ 1,380.00 $ 6,466.00 $ 3,617.00
Accrued Expenses $ 2,359.00 $ 1,784.00 $ 1,792.00 $ 2,046.00 $ 2,169.00 $ 2,108.00 $ 2,242.00 $ 1,667.00 $ 1,974.00 $ 1,903.00 $ 1,720.00
Other Current Liabilities $ 12,842.00 $ 10,735.00 $ 11,635.00 $ 14,875.00 $ 17,033.00 $ 15,906.00 $ 15,037.00 $ 13,615.00 $ 10,386.00 $ 8,567.00 $ 9,296.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Liabilities $ 29,399.00 $ 21,631.00 $ 23,366.00 $ 28,619.00 $ 28,069.00 $ 28,609.00 $ 37,225.00 $ 27,009.00 $ 21,835.00 $ 21,389.00 $ 28,448.00
Long Term Debt $ 28,818.00 $ 31,541.00 $ 30,462.00 $ 31,036.00 $ 34,931.00 $ 38,410.00 $ 43,193.00 $ 7,963.00 $ 7,314.00 $ 5,546.00 $ 6,347.00
Deferred Taxes $ 26,877.00 $ 24,981.00 $ 25,590.00 $ 21,593.00 $ 19,597.00 $ 18,648.00 $ 17,839.00 $ 2,959.00 $ 7,696.00 $ 8,015.00 $ 10,240.00
Investment Tax Credit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Liabilities $ 17,368.00 $ 19,499.00 $ 16,063.00 $ 22,872.00 $ 22,784.00 $ 21,082.00 $ 24,246.00 $ 15,477.00 $ 13,299.00 $ 8,529.00 $ 6,903.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES $ 102,462.00 $ 97,652.00 $ 95,481.00 $ 104,120.00 $ 105,381.00 $ 106,749.00 $ 122,503.00 $ 53,408.00 $ 50,144.00 $ 43,479.00 $ 51,938.00
Redeemable Noncontrolling Int. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 184.00 $ 114.00 @CF @CF
EQUITY
Preferred Stock - Redeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Preferred Stock - Nonredeemable $ 26.00 $ 29.00 $ 33.00 $ 39.00 $ 45.00 $ 52.00 $ 61.00 $ 73.00 $ 93.00 $ 141.00 $ 169.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Preferred Stock $ 26.00 $ 29.00 $ 33.00 $ 39.00 $ 45.00 $ 52.00 $ 61.00 $ 73.00 $ 93.00 $ 141.00 $ 169.00
Common Stock $ 459.00 $ 455.00 $ 453.00 $ 448.00 $ 445.00 $ 444.00 $ 443.00 $ 443.00 $ 442.00 $ 441.00 $ 439.00
Capital Surplus $ 81,016.00 $ 78,977.00 $ 77,283.00 $ 72,607.00 $ 71,420.00 $ 70,753.00 $ 70,164.00 $ 69,858.00 $ 69,363.00 $ 68,316.00 $ 66,699.00
Retained Earnings $ 62,471.00 $ 64,861.00 $ 66,461.00 $ 48,287.00 $ 42,081.00 $ 39,276.00 $ 40,978.00 $ 44,573.00 $ 51,959.00 $ 49,200.00 $ 38,087.00
Less: Treasury Stock $ 79,252.00 $ 73,021.00 $ 67,923.00 $ 40,121.00 $ 31,801.00 $ 22,712.00 $ 21,632.00 $ 57,391.00 $ 56,847.00 $ 46,740.00 $ 39,767.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Common Equity $ 64,694.00 $ 71,272.00 $ 76,274.00 $ 81,221.00 $ 82,145.00 $ 87,761.00 $ 89,953.00 $ 57,483.00 $ 64,917.00 $ 71,217.00 $ 65,458.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Stockholder's Equity - Parent $ 64,720.00 $ 71,301.00 $ 76,307.00 $ 81,260.00 $ 82,190.00 $ 87,813.00 $ 90,014.00 $ 57,556.00 $ 65,010.00 $ 71,358.00 $ 65,627.00
Nonredeemable Noncontrolling Int. $ 278.00 $ 321.00 $ 313.00 $ 418.00 $ 431.00 $ 452.00 $ 432.00 @NA @NA @NA @NA
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL EQUITY $ 64,998.00 $ 71,622.00 $ 76,620.00 $ 81,678.00 $ 82,621.00 $ 88,265.00 $ 90,446.00 $ 57,483.00 $ 64,917.00 $ 71,217.00 $ 65,458.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES & EQUITY $ 167,460.00 $ 169,274.00 $ 172,101.00 $ 185,798.00 $ 188,002.00 $ 195,014.00 $ 212,949.00 $ 111,148.00 $ 115,268.00 $ 114,837.00 $ 117,565.00
COMMON SHARES OUTSTANDING 6,175.00 6,291.00 6,399.00 7,276.00 7,575.00 8,012.00 8,070.00 6,746.00 6,761.00 7,124.00 7,361.00

&"Arial,Bold"&12&A

Income Statements

Pfizer, Inc. ANNUAL INCOME STATEMENT
TICKER: PFE
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Sales $ 48,851.00 $ 49,605.00 $ 51,584.00 $ 58,986.00 $ 67,425.00 $ 67,791.00 $ 49,934.00 $ 48,341.00 $ 48,209.00 $ 48,201.00 $ 51,298.00
Cost of Goods Sold $ 7,856.00 $ 7,773.00 $ 7,544.00 $ 8,600.00 $ 10,829.00 $ 12,441.00 $ 6,769.00 $ 4,783.00 $ 5,670.00 $ 5,216.00 $ 6,161.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Gross Profit $ 40,995.00 $ 41,832.00 $ 44,040.00 $ 50,386.00 $ 56,596.00 $ 55,350.00 $ 43,165.00 $ 43,558.00 $ 42,539.00 $ 42,985.00 $ 45,137.00
Selling, General, &
Administrative Expense $ 21,979.00 $ 22,051.00 $ 20,742.00 $ 23,809.00 $ 27,801.00 $ 28,796.00 $ 22,413.00 $ 21,633.00 $ 22,765.00 $ 22,769.00 $ 24,225.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Income Before Deprec. $ 19,016.00 $ 19,781.00 $ 23,298.00 $ 26,577.00 $ 28,795.00 $ 26,554.00 $ 20,752.00 $ 21,925.00 $ 19,774.00 $ 20,216.00 $ 20,912.00
Depreciation, Depletion, &
Amortization $ 5,157.00 $ 5,537.00 $ 6,410.00 $ 7,611.00 $ 9,026.00 $ 8,487.00 $ 4,757.00 $ 5,090.00 $ 5,200.00 $ 5,293.00 $ 5,576.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Profit $ 13,859.00 $ 14,244.00 $ 16,888.00 $ 18,966.00 $ 19,769.00 $ 18,067.00 $ 15,995.00 $ 16,835.00 $ 14,574.00 $ 14,923.00 $ 15,336.00
Interest Expense $ 1,231.00 $ 1,401.00 $ 1,446.00 $ 1,565.00 $ 1,731.00 $ 1,835.00 $ 1,267.00 $ 562.00 $ 440.00 $ 517.00 $ 488.00
Non-Operating Income/Expense $ 1,553.00 $ 1,728.00 $ 549.00 $ 261.00 $ 1,061.00 $ 1,280.00 $ 1,710.00 $ 1,793.00 $ 1,948.00 $ 1,718.00 $ 1,167.00
Special Items $ (5,216.00) $ (2,331.00) $ (275.00) $ (5,582.00) $ (6,337.00) $ (8,090.00) $ (5,611.00) $ (8,372.00) $ (6,804.00) $ (3,096.00) $ (4,481.00)
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Pretax Income $ 8,965.00 $ 12,240.00 $ 15,716.00 $ 12,080.00 $ 12,762.00 $ 9,422.00 $ 10,827.00 $ 9,694.00 $ 9,278.00 $ 13,028.00 $ 11,534.00
Total Income Taxes $ 1,990.00 $ 3,120.00 $ 4,306.00 $ 2,562.00 $ 4,023.00 $ 1,124.00 $ 2,197.00 $ 1,645.00 $ 1,023.00 $ 1,992.00 $ 3,424.00
Minority Interest ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
$ 6,975.00 $ 9,120.00 $ 11,410.00 $ 9,518.00 $ 8,739.00 $ 8,298.00 $ 8,630.00 @NA @NA @NA @NA
Noncontrolling Interest - Inc Acc $ 26.00 $ 32.00 $ 30.00 $ 28.00 $ 42.00 $ 32.00 $ 9.00 $ 23.00 $ 42.00 $ 12.00 $ 16.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary
Items & Discontinued Operations $ 6,949.00 $ 9,088.00 $ 11,380.00 $ 9,490.00 $ 8,697.00 $ 8,266.00 $ 8,621.00 $ 8,026.00 $ 8,213.00 $ 11,024.00 $ 8,094.00
Preferred Dividends $ 1.00 $ 1.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 3.00 $ 4.00 $ 5.00 $ 6.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Available for Common $ 6,948.00 $ 9,087.00 $ 11,378.00 $ 9,488.00 $ 8,695.00 $ 8,264.00 $ 8,619.00 $ 8,023.00 $ 8,209.00 $ 11,019.00 $ 8,088.00
Savings Due to Common
Stock Equivalents $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Available for Common $ 6,948.00 $ 9,087.00 $ 11,378.00 $ 9,488.00 $ 8,695.00 $ 8,264.00 $ 8,619.00 $ 8,023.00 $ 8,209.00 $ 11,019.00 $ 8,088.00
Extraordinary Items $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ (25.00)
Discontinued Operations $ 11.00 $ 48.00 $ 10,623.00 $ 5,080.00 $ 1,312.00 $ (9.00) $ 14.00 $ 78.00 $ (69.00) $ 8,313.00 $ 16.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Net Income $ 6,959.00 $ 9,135.00 $ 22,001.00 $ 14,568.00 $ 10,007.00 $ 8,255.00 $ 8,633.00 $ 8,101.00 $ 8,140.00 $ 19,332.00 $ 8,079.00
Income to Company Incl Extraordinary
Items & Disc Ops $ 6,986.00 $ 9,168.00 $ 22,033.00 $ 14,598.00 $ 10,051.00 $ 8,289.00 $ 8,644.00 @NA @NA @NA @NA
Earnings Per Share Basic -
Excluding Extra Items & Disc Op $ 1.13 $ 1.43 $ 1.67 $ 1.27 $ 1.11 $ 1.03 $ 1.23 $ 1.19 $ 1.19 $ 1.52 $ 1.10
Earnings Per Share Basic -
Including Extra Items & Disc Op $ 1.13 $ 1.44 $ 3.23 $ 1.96 $ 1.28 $ 1.03 $ 1.23 $ 1.20 $ 1.18 $ 2.67 $ 1.10
Earnings Per Share Diluted-
Excluding Extra Items & Disc Op $ 1.11 $ 1.41 $ 1.65 $ 1.26 $ 1.11 $ 1.02 $ 1.23 $ 1.19 $ 1.18 $ 1.52 $ 1.09
Earning Per Share Diluted -
Including Extra Items & Disc Op $ 1.11 $ 1.42 $ 3.19 $ 1.94 $ 1.27 $ 1.02 $ 1.23 $ 1.20 $ 1.17 $ 2.66 $ 1.09
EPS Basic from Operations $ 1.77 $ 1.67 $ 1.72 $ 1.63 $ 1.69 $ 1.46 $ 1.66 $ 2.13 $ 1.85 $ 1.69 $ 1.72
EPS Diluted from Ops $ 1.74 $ 1.65 $ 1.70 $ 1.62 $ 1.69 $ 1.20 $ 1.64 $ 2.12 $ 1.84 $ 1.68 $ 1.70
Dividends Per Share $ 1.12 $ 1.04 $ 0.96 $ 0.88 $ 0.80 $ 0.72 $ 0.80 $ 1.28 $ 1.16 $ 0.96 $ 0.76
Com Shares for Diluted EPS 6,257.00 6,424.00 6,895.00 7,508.00 7,870.00 8,074.00 7,045.00 6,750.00 6,939.00 7,274.00 7,411.00
Com Shares for Basic Eps 6,176.00 6,346.00 6,813.00 7,442.00 7,817.00 8,036.00 7,007.00 6,727.00 6,917.00 7,242.00 7,361.00

&"Arial,Bold"&12&A

Financial Ratios

Pfizer, Inc. Financial Analysis
DuPont Analysis Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Net Profitability 14.22% 18.32% 22.06% 16.09% 12.90% 12.19% 17.26% 16.60% 17.04% 22.87% 15.78%
Total Asset Turnover 0.290 0.291 0.288 0.316 0.352 0.332 0.308 0.427 0.419 0.415
Equity Multiplier 2.465 2.303 2.261 2.275 2.241 2.283 2.191 1.850 1.690 1.700
Return on Equity 10.17% 12.26% 14.38% 11.55% 10.18% 9.25% 11.66% 13.11% 12.07% 16.13%
Profitability Analysis
Gross Profitability 83.92% 84.33% 85.38% 85.42% 83.94% 81.65% 86.44% 90.11% 88.24% 89.18% 87.99%
Operating Profitability 28.37% 28.71% 32.74% 32.15% 29.32% 26.65% 32.03% 34.83% 30.23% 30.96% 29.90%
Net Profitability 14.22% 18.32% 22.06% 16.09% 12.90% 12.19% 17.26% 16.60% 17.04% 22.87% 15.78%
Return on Assets 4.13% 5.32% 6.36% 5.08% 4.54% 4.05% 5.32% 7.09% 7.14% 9.49%
Return on Equity 10.17% 12.26% 14.38% 11.55% 10.18% 9.25% 11.66% 13.11% 12.07% 16.13%
Efficiency Analysis
Receivable Turnover 5.800 5.504 4.747 4.531 4.692 4.385 3.898 4.776 4.734 4.777
Receivable DSO 62.930 66.319 76.897 80.557 77.785 83.237 93.644 76.419 77.098 76.410
Inventory Turnover 1.192 1.314 1.141 1.160 1.339 1.196 0.807 0.988 0.994 0.859
Inventory DCO 306.087 277.730 320.028 314.749 272.579 305.238 452.516 369.464 367.350 425.110
Net PP&E Turnover 3.827 4.107 3.841 3.757 3.739 3.236 2.769 3.331 2.979 2.859
Net Fixed Asset Turnover 0.415 0.436 0.429 0.463 0.509 0.474 0.455 0.708 0.707 0.672
Total Asset Turnover 0.290 0.291 0.288 0.316 0.352 0.332 0.308 0.427 0.419 0.415
Liquidity Analysis
Current Ratio 1.490 2.668 2.407 2.146 2.057 2.114 1.657 1.595 2.146 2.195 1.473
Quick Ratio 1.070 2.071 1.787 1.575 1.440 1.506 1.123 1.241 1.646 1.759 1.142
Cash Ratio 0.792 1.670 1.387 1.143 0.953 0.979 0.698 0.879 1.167 1.296 0.781
Times Interest Earned 11.258 10.167 11.679 12.119 11.421 9.846 12.624 29.956 33.123 28.865 31.426
Accounts Payable Turnover 2.750 2.179 1.773 1.949 2.593 2.011 4.833 1.921 2.267 2.491
Accounts Payable DCO (DPO) 132.748 167.539 205.865 187.262 140.765 181.484 75.524 190.014 161.025 146.504
Leverage Ratio
Total Debt to Total Assets 0.612 0.577 0.555 0.560 0.561 0.547 0.575 0.483 0.437 0.380 0.443
Long Term Term Debt to Total Assets 0.436 0.449 0.419 0.406 0.411 0.401 0.400 0.238 0.246 0.192 0.200
Total Debt to Total Equity 1.576 1.363 1.246 1.275 1.275 1.209 1.354 0.934 0.776 0.612 0.796

&"Arial,Bold"&12&A

FINANCIALS BRISTOL & MYERS SQUIB.xlsx

Balance Sheets

Bristol Myers Squibb ANNUAL BALANCE SHEET
TICKER: BMY
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
ASSETS
Cash & Equivalents $ 4,270.00 $ 7,435.00 $ 4,525.00 $ 2,829.00 $ 8,733.00 $ 7,301.00 $ 8,514.00 $ 8,265.00 $ 2,225.00 $ 4,013.00 $ 5,799.00
Net Receivables $ 4,117.00 $ 3,212.00 $ 3,098.00 $ 2,764.00 $ 3,487.00 $ 3,257.00 $ 3,164.00 $ 3,710.00 $ 4,240.00 $ 3,247.00 $ 3,378.00
Inventories $ 1,221.00 $ 1,560.00 $ 1,498.00 $ 1,657.00 $ 1,384.00 $ 1,204.00 $ 1,413.00 $ 1,765.00 $ 2,162.00 $ 2,079.00 $ 2,060.00
Prepaid Expenses @CF @CF @CF @CF @CF $ 252.00 $ 256.00 $ 320.00 $ 310.00 $ 314.00 $ 270.00
Other Current Assets $ 807.00 $ 2,401.00 $ 9,795.00 $ 2,271.00 $ 1,714.00 $ 1,259.00 $ 611.00 $ 703.00 $ 1,411.00 $ 649.00 $ 776.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Assets $ 10,415.00 $ 14,608.00 $ 18,916.00 $ 9,521.00 $ 15,318.00 $ 13,273.00 $ 13,958.00 $ 14,763.00 $ 10,348.00 $ 10,302.00 $ 12,283.00
Gross Plant, Property & Equipment $ 8,631.00 $ 9,066.00 $ 8,843.00 $ 9,383.00 $ 8,381.00 $ 8,260.00 $ 8,895.00 $ 9,449.00 $ 10,214.00 $ 10,144.00 $ 9,984.00
Accumulated Depreciation $ 4,219.00 $ 4,649.00 $ 4,264.00 $ 4,050.00 $ 3,860.00 $ 3,596.00 $ 3,840.00 $ 4,044.00 $ 4,564.00 $ 4,471.00 $ 4,291.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Net Plant, Property & Equipment $ 4,412.00 $ 4,417.00 $ 4,579.00 $ 5,333.00 $ 4,521.00 $ 4,664.00 $ 5,055.00 $ 5,405.00 $ 5,650.00 $ 5,673.00 $ 5,693.00
Investments at Equity @NA @NA @CF @CF @CF @CF @CF @CF @CF @CF $ 66.00
Other Investments $ 4,720.00 $ 4,444.00 $ 3,747.00 $ 3,523.00 $ 2,909.00 $ 2,681.00 $ 1,369.00 $ - 0 $ - 0 $ - 0 $ - 0
Intangibles $ 8,300.00 $ 8,780.00 $ 9,414.00 $ 16,413.00 $ 8,710.00 $ 8,603.00 $ 8,083.00 $ 5,978.00 $ 6,328.00 $ 6,681.00 $ 6,744.00
Deferred Charges $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 1,324.00
Other Assets $ 3,901.00 $ 1,500.00 $ 1,936.00 $ 1,107.00 $ 1,512.00 $ 1,855.00 $ 2,543.00 $ 3,406.00 $ 3,846.00 $ 2,919.00 $ 2,028.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL ASSETS $ 31,748.00 $ 33,749.00 $ 38,592.00 $ 35,897.00 $ 32,970.00 $ 31,076.00 $ 31,008.00 $ 29,552.00 $ 26,172.00 $ 25,575.00 $ 28,138.00
LIABILITIES
Long Term Debt Due In One Year $ - 0 $ - 0 $ 27.00 $ 664.00 $ - 0 $ 17.00 $ 148.00 $ 27.00 $ - 0 $ - 0 $ - 0
Notes Payable $ 139.00 $ 590.00 $ 359.00 $ 162.00 $ 115.00 $ 100.00 $ 83.00 $ 127.00 $ 1,891.00 $ 187.00 $ 231.00
Accounts Payable $ 1,565.00 $ 2,487.00 $ 2,559.00 $ 2,202.00 $ 2,603.00 $ 1,983.00 $ 1,711.00 $ 1,535.00 $ 1,442.00 $ 1,239.00 $ 1,579.00
Taxes Payable $ 572.00 $ 251.00 $ 160.00 $ 193.00 $ 167.00 $ 65.00 $ 175.00 $ 347.00 $ 296.00 $ 444.00 $ 538.00
Accrued Expenses $ 4,083.00 $ 3,310.00 $ 3,041.00 $ 3,627.00 $ 3,961.00 $ 3,597.00 $ 3,407.00 $ 3,780.00 $ 3,919.00 $ 3,663.00 $ 3,995.00
Other Current Liabilities $ 1,658.00 $ 1,823.00 $ 6,294.00 $ 1,431.00 $ 934.00 $ 977.00 $ 789.00 $ 894.00 $ 1,096.00 $ 963.00 $ 547.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Current Liabilities $ 8,017.00 $ 8,461.00 $ 12,440.00 $ 8,279.00 $ 7,780.00 $ 6,739.00 $ 6,313.00 $ 6,710.00 $ 8,644.00 $ 6,496.00 $ 6,890.00
Long Term Debt $ 6,550.00 $ 7,242.00 $ 7,981.00 $ 6,568.00 $ 5,376.00 $ 5,328.00 $ 6,130.00 $ 6,585.00 $ 4,381.00 $ 7,248.00 $ 8,364.00
Deferred Taxes $ 31.00 $ 60.00 $ 73.00 $ 383.00 $ 107.00 $ 54.00 $ 31.00 $ 59.00 $ 80.00 $ 68.00 $ 178.00
Investment Tax Credit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Liabilities $ 2,726.00 $ 3,003.00 $ 2,862.00 $ 7,029.00 $ 3,840.00 $ 3,317.00 $ 3,749.00 $ 3,957.00 $ 2,505.00 $ 1,772.00 $ 1,498.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES $ 17,324.00 $ 18,766.00 $ 23,356.00 $ 22,259.00 $ 17,103.00 $ 15,438.00 $ 16,223.00 $ 17,311.00 $ 15,610.00 $ 15,584.00 $ 16,930.00
Redeemable Noncontrolling Int. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 @CF @CF @CF @CF
EQUITY
Preferred Stock - Redeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Preferred Stock - Nonredeemable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Total Preferred Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Common Stock $ 221.00 $ 221.00 $ 221.00 $ 221.00 $ 220.00 $ 220.00 $ 220.00 $ 220.00 $ 220.00 $ 220.00 $ 220.00
Capital Surplus $ 1,459.00 $ 1,507.00 $ 1,922.00 $ 2,694.00 $ 3,114.00 $ 3,682.00 $ 3,768.00 $ 2,757.00 $ 2,625.00 $ 2,498.00 $ 2,457.00
Retained Earnings $ 29,145.00 $ 30,116.00 $ 30,811.00 $ 29,531.00 $ 30,024.00 $ 29,265.00 $ 28,219.00 $ 19,830.00 $ 18,301.00 $ 18,200.00 $ 19,699.00
Less: Treasury Stock $ 16,559.00 $ 16,992.00 $ 17,800.00 $ 18,823.00 $ 17,402.00 $ 17,454.00 $ 17,364.00 $ 10,566.00 $ 10,584.00 $ 10,927.00 $ 11,168.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Common Equity $ 14,266.00 $ 14,852.00 $ 15,154.00 $ 13,623.00 $ 15,956.00 $ 15,713.00 $ 14,843.00 $ 12,241.00 $ 10,562.00 $ 9,991.00 $ 11,208.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Stockholder's Equity - Parent $ 14,266.00 $ 14,852.00 $ 15,154.00 $ 13,623.00 $ 15,956.00 $ 15,713.00 $ 14,843.00 $ 12,241.00 $ 10,562.00 $ 9,991.00 $ 11,208.00
Nonredeemable Noncontrolling Int. $ 158.00 $ 131.00 $ 82.00 $ 15.00 $ (89.00) $ (75.00) $ (58.00) @NA @NA @NA @NA
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL EQUITY $ 14,424.00 $ 14,983.00 $ 15,236.00 $ 13,638.00 $ 15,867.00 $ 15,638.00 $ 14,785.00 $ 12,241.00 $ 10,562.00 $ 9,991.00 $ 11,208.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES & EQUITY $ 31,748.00 $ 33,749.00 $ 38,592.00 $ 35,897.00 $ 32,970.00 $ 31,076.00 $ 31,008.00 $ 29,552.00 $ 26,172.00 $ 25,575.00 $ 28,138.00
COMMON SHARES OUTSTANDING 1,669.00 1,661.00 1,649.00 1,638.00 1,690.00 1,704.00 1,714.00 1,979.00 1,979.00 1,967.00 1,957.00

&"Arial,Bold"&12&A

Income Statements

Bristol Myers Squibb ANNUAL INCOME STATEMENT
TICKER: BMY
SIC: 2834
GICS: 35202010
Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Sales $ 16,560.00 $ 15,879.00 $ 16,385.00 $ 17,621.00 $ 21,244.00 $ 19,484.00 $ 18,808.00 $ 20,597.00 $ 19,348.00 $ 17,914.00 $ 19,207.00
Cost of Goods Sold $ 3,142.00 $ 2,952.00 $ 3,272.00 $ 3,474.00 $ 4,722.00 $ 4,420.00 $ 4,376.00 $ 5,584.00 $ 5,326.00 $ 4,970.00 $ 4,993.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Gross Profit $ 13,418.00 $ 12,927.00 $ 13,113.00 $ 14,147.00 $ 16,522.00 $ 15,064.00 $ 14,432.00 $ 15,013.00 $ 14,022.00 $ 12,944.00 $ 14,214.00
Selling, General, &
Administrative Expense $ 10,560.00 $ 8,908.00 $ 8,654.00 $ 8,667.00 $ 8,942.00 $ 8,184.00 $ 8,519.00 $ 9,777.00 $ 9,597.00 $ 9,337.00 $ 9,270.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Income Before Deprec. $ 2,858.00 $ 4,019.00 $ 4,459.00 $ 5,480.00 $ 7,580.00 $ 6,880.00 $ 5,913.00 $ 5,236.00 $ 4,425.00 $ 3,607.00 $ 4,944.00
Depreciation, Depletion, &
Amortization $ 683.00 $ 829.00 $ 1,311.00 $ 989.00 $ 801.00 $ 744.00 $ 647.00 $ 812.00 $ 892.00 $ 927.00 $ 929.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Operating Profit $ 2,175.00 $ 3,190.00 $ 3,148.00 $ 4,491.00 $ 6,779.00 $ 6,136.00 $ 5,266.00 $ 4,424.00 $ 3,533.00 $ 2,680.00 $ 4,015.00
Interest Expense $ 184.00 $ 203.00 $ 199.00 $ 182.00 $ 145.00 $ 153.00 $ 197.00 $ 333.00 $ 457.00 $ 516.00 $ 358.00
Non-Operating Income/Expense $ 864.00 $ 1,177.00 $ 348.00 $ 599.00 $ 593.00 $ 627.00 $ 820.00 $ 751.00 $ 659.00 $ 935.00 $ 572.00
Special Items $ (778.00) $ (1,783.00) $ (406.00) $ (2,568.00) $ (246.00) $ (539.00) $ (287.00) $ 629.00 $ (201.00) $ (464.00) $ 287.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Pretax Income $ 2,077.00 $ 2,381.00 $ 2,891.00 $ 2,340.00 $ 6,981.00 $ 6,071.00 $ 5,602.00 $ 5,471.00 $ 3,534.00 $ 2,635.00 $ 4,516.00
Total Income Taxes $ 446.00 $ 352.00 $ 311.00 $ (161.00) $ 1,721.00 $ 1,558.00 $ 1,182.00 $ 1,320.00 $ 803.00 $ 610.00 $ 932.00
Minority Interest ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
$ 1,631.00 $ 2,029.00 $ 2,580.00 $ 2,501.00 $ 5,260.00 $ 4,513.00 $ 4,420.00 @NA @NA @NA @NA
Noncontrolling Interest - Inc Acc $ 66.00 $ 25.00 $ 17.00 $ 541.00 $ 1,551.00 $ 1,411.00 $ 1,181.00 $ 996.00 $ 763.00 $ 440.00 $ 592.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary
Items & Discontinued Operations $ 1,565.00 $ 2,004.00 $ 2,563.00 $ 1,960.00 $ 3,709.00 $ 3,102.00 $ 3,239.00 $ 3,155.00 $ 1,968.00 $ 1,585.00 $ 2,992.00
Preferred Dividends $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Available for Common $ 1,565.00 $ 2,004.00 $ 2,563.00 $ 1,960.00 $ 3,709.00 $ 3,102.00 $ 3,239.00 $ 3,155.00 $ 1,968.00 $ 1,585.00 $ 2,992.00
Savings Due to Common
Stock Equivalents $ - 0 $ - 0 $ - 0 $ (1.00) $ (8.00) $ (12.00) $ (18.00) $ - 0 $ - 0 $ - 0 $ - 0
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Available for Common $ 1,565.00 $ 2,004.00 $ 2,563.00 $ 1,959.00 $ 3,701.00 $ 3,090.00 $ 3,221.00 $ 3,155.00 $ 1,968.00 $ 1,585.00 $ 2,992.00
Extraordinary Items $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Discontinued Operations $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 7,331.00 $ 2,092.00 $ 197.00 $ - 0 $ 8.00
------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------
Adjusted Net Income $ 1,565.00 $ 2,004.00 $ 2,563.00 $ 1,959.00 $ 3,701.00 $ 3,090.00 $ 10,552.00 $ 5,247.00 $ 2,165.00 $ 1,585.00 $ 3,000.00
Income to Company Incl Extraordinary
Items & Disc Ops $ 1,631.00 $ 2,029.00 $ 2,580.00 $ 2,501.00 $ 5,260.00 $ 4,513.00 $ 11,751.00 @NA @NA @NA @NA
Earnings Per Share Basic -
Excluding Extra Items & Disc Op $ 0.94 $ 1.21 $ 1.56 $ 1.17 $ 2.18 $ 1.80 $ 1.63 $ 1.60 $ 1.00 $ 0.81 $ 1.53
Earnings Per Share Basic -
Including Extra Items & Disc Op $ 0.94 $ 1.21 $ 1.56 $ 1.17 $ 2.18 $ 1.80 $ 5.35 $ 2.65 $ 1.10 $ 0.81 $ 1.53
Earnings Per Share Diluted-
Excluding Extra Items & Disc Op $ 0.93 $ 1.20 $ 1.54 $ 1.16 $ 2.16 $ 1.80 $ 1.63 $ 1.59 $ 0.99 $ 0.81 $ 1.52
Earning Per Share Diluted -
Including Extra Items & Disc Op $ 0.93 $ 1.20 $ 1.54 $ 1.16 $ 2.16 $ 1.80 $ 5.34 $ 2.63 $ 1.09 $ 0.81 $ 1.52
EPS Basic from Operations $ 1.24 $ 1.83 $ 1.72 $ 2.17 $ 2.27 $ 2.10 $ 1.73 $ 1.39 $ 1.05 $ 0.95 $ 1.37
EPS Diluted from Ops $ 1.23 $ 1.82 $ 1.70 $ 2.15 $ 2.25 $ 2.09 $ 1.72 $ 1.37 $ 1.05 $ 0.95 $ 1.35
Dividends Per Share $ 1.49 $ 1.45 $ 1.76 $ 1.36 $ 1.32 $ 0.96 $ 1.25 $ 1.55 $ 1.12 $ 1.12 $ 1.12
Com Shares for Diluted EPS 1,679.00 1,670.00 1,662.00 1,688.00 1,717.00 1,727.00 1,978.00 2,001.00 1,980.00 1,963.00 1,983.00
Com Shares for Basic Eps 1,667.00 1,657.00 1,644.00 1,670.00 1,700.00 1,713.00 1,974.00 1,977.00 1,970.00 1,960.00 1,952.00

&"Arial,Bold"&12&A

Financial Ratios

Bristol Myers Squibb Financial Analysis
DuPont Analysis Dec-15 Dec-14 Dec-13 Dec-12 Dec-11 Dec-10 Dec-09 Dec-08 Dec-07 Dec-06 Dec-05
Net Profitability 9.45% 12.62% 15.64% 11.12% 17.46% 15.92% 17.22% 15.32% 10.17% 8.85% 15.58%
Total Asset Turnover 0.506 0.439 0.440 0.512 0.663 0.628 0.621 0.739 0.748 0.667
Equity Multiplier 2.227 2.394 2.580 2.334 2.033 2.041 2.241 2.444 2.518 2.534
Return on Equity 10.64% 13.26% 17.75% 13.29% 23.55% 20.39% 23.97% 27.67% 19.15% 14.95%
Profitability Analysis
Gross Profitability 81.03% 81.41% 80.03% 80.28% 77.77% 77.31% 76.73% 72.89% 72.47% 72.26% 74.00%
Operating Profitability 13.13% 20.09% 19.21% 25.49% 31.91% 31.49% 28.00% 21.48% 18.26% 14.96% 20.90%
Net Profitability 9.45% 12.62% 15.64% 11.12% 17.46% 15.92% 17.22% 15.32% 10.17% 8.85% 15.58%
Return on Assets 4.78% 5.54% 6.88% 5.69% 11.58% 9.99% 10.70% 11.32% 7.61% 5.90%
Return on Equity 10.64% 13.26% 17.75% 13.29% 23.55% 20.39% 23.97% 27.67% 19.15% 14.95%
Efficiency Analysis
Receivable Turnover 4.519 5.033 5.590 5.638 6.300 6.069 5.472 5.182 5.168 5.408
Receivable DSO 80.769 72.522 65.292 64.741 57.935 60.143 66.701 70.441 70.621 67.493
Inventory Turnover 2.260 1.931 2.074 2.285 3.649 3.378 2.754 2.844 2.512 2.402
Inventory DCO 161.532 189.053 175.974 159.753 100.023 108.055 132.538 128.345 145.322 151.985
Net PP&E Turnover 3.751 3.530 3.306 3.576 4.626 4.009 3.596 3.726 3.417 3.152
Net Fixed Asset Turnover 0.818 0.818 0.712 0.800 1.198 1.118 1.181 1.346 1.244 1.151
Total Asset Turnover 0.506 0.439 0.440 0.512 0.663 0.628 0.621 0.739 0.748 0.667
Liquidity Analysis
Current Ratio 1.299 1.727 1.521 1.150 1.969 1.970 2.211 2.200 1.197 1.586 1.783
Quick Ratio 1.046 1.258 0.613 0.676 1.571 1.567 1.850 1.785 0.748 1.118 1.332
Cash Ratio 0.533 0.879 0.364 0.342 1.122 1.083 1.349 1.232 0.257 0.618 0.842
Times Interest Earned 11.821 15.714 15.819 24.676 46.752 40.105 26.731 13.285 7.731 5.194 11.215
Accounts Payable Turnover 1.384 1.195 1.308 1.560 2.138 2.280 2.479 3.485 4.035 3.541
Accounts Payable DCO (DPO) 263.821 305.539 279.114 234.031 170.735 160.094 147.215 104.743 90.457 103.084
Leverage Ratio
Total Debt to Total Assets 0.546 0.556 0.605 0.620 0.519 0.497 0.523 0.586 0.596 0.609 0.602
Long Term Term Debt to Total Assets 0.293 0.305 0.283 0.389 0.283 0.280 0.320 0.359 0.266 0.355 0.357
Total Debt to Total Equity 1.201 1.252 1.533 1.632 1.078 0.987 1.097 1.414 1.478 1.560 1.511

&"Arial,Bold"&12&A

Tasks

1. See attached financial statement and ratio workbooks for the following companies

a. Abbott Laboratories

b. Bristol-Myers Squibb

c. Glaxosmithklien

d. Eli Lilly & Co.

e. Merck & Co.

f. Novartis

g. Pfizer

2. Use Eli Lilly & Co. pharmaceutical company, to complete the following:

A. The product and service of Eli Lilly

B. The target market of Eli Lilly

C. The competition and market structure of Eli Lilly

D. Use the major income statement figures and put the figures in the pie chart.

E. Use the major balance sheet figures to represent them in pie chart

F. Outline and explain the trend

G. What is market distribution channels of Eli Lilly?

3. Complete the following elements of an industry analysis:

a. Table and chart showing an index of sales for all seven companies using FYE Dec 05 as the base year

b. Table and chart showing an index of net income for all seven companies using FYE Dec 05 as the base year.

c. Table and chart showing an index of total assets for all seven companies using FYE Dec 05 as the base year.

d. Table and chart showing an index of net PPE for all seven companies using FYE Dec 05 as the base year.

e. Table and chart showing an index of inventory for all seven companies using FYE Dec 05 as the base year.

f. Table and chart showing the gross profit margins for all seven companies

g. Table and chart showing the inventory turnover for all seven companies

h. Table and chart showing the net PPE turnover for all seven companies

4. Put the tables and charts from step 2 and 3 into a PowerPoint slide presentation.

5. Use Eli Lilly & Co. company, complete the following:

a. Download and review the 10-K document for your company to develop an understanding of its business model

b. Conduct an IODE financial analysis of the company, including but not limited to:

i. Balance sheet analysis of structure and trends

ii. Income statement analysis of structure and trends

iii. Analysis of the DuPont ratio structure and trends

iv. Analysis of key profitability ratio structure and trends

v. Analysis of key efficiency ratios and trends

vi. Analysis of key leverage ratios and trends

c. Prepare a set of exhibit tables and/or charts that support the findings and implication of each step of your analysis. Put these exhibits into a PowerPoint slide presentation.

d. Develop some conclusions regarding the sustainability of the business model for Eli Lilly Pharmaceutical company in the context of what you know about the industry (e.g., from your industry analysis in Step 2 and 3, and comparison to other companies in the sample). Include these conclusions in your presentation slides.

Submit Your Homework

Let us help you with your homework, we will match you with one of our professional tutors.

My Info

Project Info

Due Date

Describe your Homework Problem

Budget (optional)

By providing your budget we will work on finding the best tutors that can work within it.

Get help from top-rated tutors in any subject.

Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com