Case: Campbell Soup Co. Preliminary Financial Analysis Exhibit CC. 5 CAMPBELL SOUP COMPANY Five-Year Growth rates Per share Years 6 to 11 Average for Average for rEars 6 to 8 to yEars 9 to 11] s es 8.09% 5.95% Net income 12.93 10.53 Dividends 11.50 6.69 quity 3.55 0.53 Ten- Year Growth rates* Per share Years 1 to 11 Average for Average for rEars 1 to 3] to rEars 9 to 11] Sales 851% 7.22% Net income 12.19 044 Dividends 8.18 6.62 Equity 6.22 5.13
Case: Campbell Soup Co. Preliminary Financial Analysis Exhibit CC.5 CAMPBELL SOUP COMPANY Five-Year Growth Rates* Per share Years 6 to 11 Average for Average for [Years 6 to 8] to [Years 9 to 11 ] Sales 8.09% 5.95% Net income 12.93 -10.53 Dividends 11.50 6.69 Equity 3.55 0.53 Ten-Year Growth Rates* Per share Years 1 to 11 Average for Average for [Years 1 to 3] to [Years 9 to 11 ] Sales 8.51% 7.22% Net income 12.19 -0.44 Dividends 8.18 6.62 Equity 6.22 5.13
Case: Campbell Soup Co. Short-Term Analysis Exhibit CC. 6 CAMPBELL SOUP COMPANY Common-Size Income statements Year 11 Year 10 Year 9 Year 8 Year 7 Year 6 Net sales 10000%100.00%100.00%10000%100.00%100.00% Costs and expens Cost of products sold 6601%6862%70.55%6968%70.83%7191% Marketing and selling expenses 1541 1580 1444 15.061395 12.70 Administrative expenses 4.94 4.68 4.44 4.78 4.76 4.57 Research and development expenses 0.91 0.87 0.84 0.96 1.00 0.98 Interest expense 1.11 1.15 Interest income (042) (0.28) 0.68) (0.68)(066) (0.64) Foreign exchange losses, net 0.34 Other expense(income 042 0.24 (0.07)(0.21) 0.13 Divestitures, restructuring unusual charges 605 83 Total costs and expenses 8917%9723%98.21%9202%90.93%90.98% Earnings before equity in earnings of affiliates and minority interest 10.83% 79% 7.98%907% 9.02% Equity in earnings of affiliates 0.04 0.22 0.18 0.13 0.34 0.10 Minority interests 12) (0 (0 Earnings before taxes 10.76% 2.89% 1.88% 798%931% 9.03% Taxes on earnings 4.29 1.65 3.02 3.83 Earnings before cumulative effect of accounting change 647% 0.07% 0.23% 4.96%551% 521% Cumulative effect of change accounting for income taxes Net earnings 647 0.07% 0.23% 3%551% 521%
Case: Campbell Soup Co. Short-Term Analysis Exhibit CC.6 CAMPBELL SOUP COMPANY Common-Size Income Statements Year 11 Year 10 Year 9 Year 8 Year 7 Year 6 Net sales 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Costs and expenses: Cost of products sold 66.01% 68.62% 70.55% 69.68% 70.83% 71.91% Marketing and selling expenses 15.41 15.80 14.44 15.06 13.95 12.70 Administrative expenses 4.94 4.68 4.44 4.78 4.76 4.57 Research and development expenses 0.91 0.87 0.84 0.96 1.00 0.98 Interest expense 1.87 1.80 1.66 1.11 1.15 1.31 Interest income (0.42) (0.28) (0.68) (0.68) (0.66) (0.64) Foreign exchange losses, net 0.01 0.05 0.34 0.34 0.11 0.02 Other expense (income) 0.42 0.24 0.57 (0.07) (0.21) 0.13 Divestitures, restructuring & unusual charges — 5.46 6.05 0.83 — — Total costs and expenses 89.17% 97.23% 98.21% 92.02% 90.93% 90.98% Earnings before equity in earnings of affiliates and minority interests 10.83% 2.77% 1.79% 7.98% 9.07% 9.02% Equity in earnings of affiliates 0.04 0.22 0.18 0.13 0.34 0.10 Minority interests (0.12) (0.09) (0.09) (0.13) (0.10) (0.09) Earnings before taxes 10.76% 2.89% 1.88% 7.98% 9.31% 9.03% Taxes on earnings 4.29 2.82 1.65 3.02 3.80 3.83 Earnings before cumulative effect of accounting change 6.47% 0.07% 0.23% 4.96% 5.51% 5.21% Cumulative effect of change in accounting for income taxes — — — 0.67 — — Net earnings 6.47% 0.07% 0.23% 5.63% 5.51% 5.21%
Case: Campbell Soup Co Short-Term Analysis Exhibit CC.7 CAMPBELL SOUP COMPANY Common-Size Balance sheets Year 11 Year 10 Year 9 Year 8 Year 7 Year 6 Industry Composite Year 11 Current assets Cash and cash equivalents 4.31%1.96%307%238%469%561%34% Other temporary investments 0.31 0.67 0.97 8.64 Accounts receivable 127115.1713.6813491094108216.5 Inventories 17.03199220.75184120.1322.1038.6 Prepaid expenses Total current assets 3660%4047%40.73%37.76%4643%48.31%60.70% Plant assets, net of depreciation 43.15%41.74%39.18%41.80%43.55%42.28%21.0% Intangible assets, net of amortization 10.50 32 1187 13.76 Other assets 9.75 848 8.22 6.6810 18.3 Total assets 10000%100.00%100.00%100.00%100 10000%10000% Current liabilities Notes payable 680%492%690%382%3.02%3.22%6.7% Payable to suppliers and others 129212.3812.10116410.2 Accrued liabilities 9.8511959986.565.8860015.8 Dividend payable 0.89 0.78 0.76 ccrued income taxes Total current liabilities 3080%31.54%3133%23.92%2240%22.66%32.70% Long-term debt 1862%19.58%1600%1457%1227%13.11%19.7% Other liabilities, mainly deferred taxes 7.35 9.0 02 9.28 1.5 Shareowner's equity Preferred stock; auth 40,000, 000 sh. none issued Capital stock, $0. 15 par value; authorized 140,000,000 sh ssued 135. 622.676 sh 0.49 0490.52 0.56 0.660.73 Capital surplus 2.59 1.50 1.17 133 Earnings retained in the business 40.1745.16520655.1956.25 Capital stock in treasury, at cost 652 Cumulative translation adjustments 1.54 0.05 0.79 0.38 Total shareowners equity 43.22%41.11%4523%5250%5605%55.70%46.10% Total liabilities and equity 10000%10000%100.00%100.00%100.00%100.00%100.00%
Case: Campbell Soup Co. Short-Term Analysis Exhibit CC.7 CAMPBELL SOUP COMPANY Common-Size Balance Sheets Year 11 Year 10 Year 9 Year 8 Year 7 Year 6 Industry Composite Year 11 Current assets: Cash and cash equivalents 4.31% 1.96% 3.07% 2.38% 4.69% 5.61% 3.4% Other temporary investments 0.31 0.55 0.67 0.97 9.05 8.64 Accounts receivable 12.71 15.17 13.68 13.49 10.94 10.82 16.5 Inventories 17.03 19.92 20.75 18.41 20.13 22.10 38.6 Prepaid expenses 2.23 2.87 2.55 2.51 1.62 1.14 2.2 Total current assets 36.60% 40.47% 40.73% 37.76% 46.43% 48.31% 60.70% Plant assets, net of depreciation 43.15% 41.74% 39.18% 41.80% 43.55% 42.28% 21.0% Intangible assets, net of amortization 10.50 9.32 11.87 13.76 — — Other assets 9.75 8.48 8.22 6.68 10.02 9.41 18.3 Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Current liabilities: Notes payable 6.80% 4.92% 6.90% 3.82% 3.02% 3.22% 6.7% Payable to suppliers and others 11.63 12.76 12.92 12.38 12.10 11.64 10.2 Accrued liabilities 9.85 11.95 9.98 6.56 5.88 6.00 15.8 Dividend payable 0.89 0.78 0.76 — — — Accrued income taxes 1.63 1.13 0.77 1.16 1.40 1.80 Total current liabilities 30.80% 31.54% 31.33% 23.92% 22.40% 22.66% 32.70% Long-term debt 18.62% 19.58% 16.00% 14.57% 12.27% 13.11% 19.7% Other liabilities, mainly deferred taxes 7.35 7.77 7.44 9.02 9.28 8.52 1.5 Shareowner’s equity: Preferred stock; auth 40,000,000 sh.; none issued — — — — — — Capital stock, $0.15 par value; authorized 140,000,000 sh.; issued 135,622,676 sh. 0.49 0.49 0.52 0.56 0.66 0.73 Capital surplus 2.59 1.50 1.29 1.17 1.33 1.38 Earnings retained in the business 46.10 40.17 45.16 52.06 55.19 56.25 Capital stock in treasury, at cost 6.52 2.60 1.80 2.08 1.51 1.75 Cumulative translation adjustments 0.57 1.54 0.05 0.79 0.38 0.91 Total shareowner’s equity 43.22% 41.11% 45.23% 52.50% 56.05% 55.70% 46.10% Total liabilities and equity 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%