Kimberly-Clark is a household products com- Colgate and Kimberly-Clark pany that produces and sells various paper products under popular brand names such as Kleenex and Scott. In many respects, Kimberly- Clark is similar to Colgate: both are mature and profitable consumer products companies that are of similar size. Therefore, Kimberly-Clark is a good company with which to compare Colgates financial performance. The tables below provide summary financial information for both Colgate and Kimberly-Clark over the 20012011 period.

Required:

Conduct a detailed comparative analysis of Colgate and Kimberly-Clarks financial performance over the 20012011 period. Specifically:

a. Conduct an index-number trend analysis separately for every item reported in the table (e.g., net sales, gross profit, etc.). Use 2001 as the base year (i.e., set 2001 numbers equal to 100).

b. Calculatethefollowingratiosforeveryyearforeachcompany:returnoninvestment(returnonassets,returnon common equity), operating performance (gross profit margin, operating profit margin), asset utilization (total asset turnover), capital structure (total debt to equity, long-term debt to equity), dividend payout rate, and mar- ket measures (price-to-earnings, price-to-book).

c. Conduct an index-number trend analysis separately for every one of the ratios that you computed in (b). Once again use 2001 as the base year. d. For analysis in (a), (b), and (c) that involves net income or operating income, it is important to also examine these numbers after removing the costs relating to restructuring activities. The tables calculate net income and operating income after adding the pretax cost of restructuring (e.g., net income before restructuring). Compute all trends and ratios using these adjusted income numbers in addition to those using the reported numbers.

d. For analysis in (a), (b), and (c) that involves net income or operating income, it is important to also examine these numbers after removing the costs relating to restructuring activities. The tables calculate net income and operating income after adding the pretax cost of restructuring (e.g., net income before restructuring). Compute all trends and ratios using these adjusted income numbers in addition to those using the reported numbers.

e. Finally,weneedtodeterminethestockpriceperformanceofthetwocompaniesoverthisperiod.Todothat,we need to determine cum-dividend return. Cum-dividend return is the return on a stock including cash dividends. Colgates compounded annualized cum-dividend return over the 20022011 period is 6.9% compared to 5.3% for Kimberly-Clark (note the period is 20022011 and not 20012011). Verify these numbers are true. (Hint: This is advanced analysis that covers material from finance outside the scope of this chapter and should be at- tempted only by those who are conversant with finance techniques. Cum-dividend return is determined by the following formula: Cum-dividend return for a year [(Closing stock price Cash dividend paid during the year)/Opening stock price] 1. Using this formula, determine the cum-dividend return for each company for every year. Then determine the compounded annualized return over the entire period).

f. ExamineallofthepreviousanalysesandprovideacommentarythatcomparestheperformanceofColgateand Kimberly-Clark over the 20022011 period.

Note: This case involves extensive data analysis and should be done using Excel (or similar software). To facilitate the analysis in Excel, the data in the tables above are available in Excel format and can be downloaded from the books website.

FYI: Can you please include your spreadsheet with calculations in addition to the Word summary - I need to be able to see the formulas.

Thank you in advance!

COLGATE'S SUMMARY FINANCIAL DATA 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 (In billions, except per share data) Net sales Gross profit Operating income Net income Restructuring charge (after tax) Net income before restructuring Op income before restructuring 9.90 5.75 2.14 16.73 9.59 3.84 2.43 0.00 2.43 3.84 15.56 9.20 3.49 2.20 0.06 2.26 3.55 15.33 9.01 3.62 2.29 0.00 2.29 3.62 15.33 9.01 3.33 1.96 0.11 2.07 3.44 13.79 8.22 2.96 1.74 0.18 1.92 3.14 12.24 7.21 2.57 1.35 0.29 1.64 2.86 11.40 6.62 2.37 1.35 0.15 1.50 2.52 10.58 6.15 2.20 1.33 0.06 1.39 2.26 1.42 9.29 5.35 2.02 1.29 0.00 1.29 2.02 9.43 5.46 1.86 1.15 0.00 1.15 1.86 0.04 1.46 2.18 Total assets Total liabilities Long-term debt Shareholders' equity Treasury stock at cost 12.72 10.18 4.43 2.07 12.81 11.17 8.36 2.82 2.68 11.31 11.13 7.88 2.82 3.12 10.48 9.98 7.94 3.59 1.92 9.70 10.11 7.72 3.22 9.14 7.62 2.72 1.41 8.07 8.51 7.05 2.92 1.35 7.58 8.67 7.21 3.09 1.25 6.97 7.48 6.38 2.68 0.89 6.50 7.09 6.53 3.21 0.35 6.15 6.98 5.93 2.81 0.85 5.20 2.29 8.90 Basic earnings per share Cash dividends per share Closing stock price Shares outstanding (billions) 4.98 2.27 92.39 0.48 4.45 2.03 80.37 0.49 4.53 1.72 82.15 0.49 3.81 1.56 68.54 0.50 3.35 1.40 77.96 0.51 2.57 1.25 65.24 0.51 2.54 1.11 54.85 0.52 2.45 0.96 51.16 0.53 2.60 0.90 50.05 0.53 2.33 0.72 52.43 0.54 2.02 0.68 57.75 0.55 2009 2002 2001 2011 2010 20.85 19.75 6.15 7.38 2.44 2.90 1.59 1.84 0.29 0.00 1.88 1.84 2.73 2.90 19.12 7.27 3.07 1.88 0.09 1.98 3.16 KIMBERLEY-CLARK'S SUMMARY FINANCIAL DATA 2008 2007 2006 2005 2004 2003 19.42 18.27 16.75 15.90 15.08 14.35 6.68 6.60 6.36 6.12 5.91 5.66 2.64 2.75 2.61 2.57 2.59 2.52 1.69 1.82 1.50 1.57 1.80 1.69 0.05 0.10 0.31 0.17 0.01 0.00 1.74 1.92 1.81 1.74 1.81 1.69 2.69 2.84 2.92 2.73 2.60 2.52 13.57 5.55 2.58 1.67 0.00 1.67 2.58 14.52 6.71 2.60 1.61 0.04 1.65 2.64 (In billions, except per share data) Net sales Gross profit Operating income Net income Restructuring charge (after tax) Net income before restructuring Op income before restructuring Total assets Total liabilities Long-term debt Shareholders' equity Treasury stock at cost Basic earnings per share Cash dividends per share Closing stock price Shares outstanding (billions) 19.37 13.84 5.43 5.53 2.11 19.86 13.12 5.12 5.92 4.73 19.21 12.47 4.79 5.41 4.09 18.09 12.80 4.88 3.88 4.29 18.44 11.73 4.39 5.22 3.81 17.07 9.75 2.28 6.10 1.39 16.30 9.59 2.59 5.56 6.38 17.02 9.30 2.30 6.63 5.05 16.78 9.15 2.73 6.77 3.82 15.59 9.13 2.84 5.65 3.35 15.01 8.51 2.42 5.65 2.75 3.04 4.02 2.76 73.56 0.40 4.47 2.58 63.04 0.41 4.53 2.38 63.71 0.42 4.08 2.27 52.74 0.41 4.13 2.08 69.34 0.42 3.27 1.92 67.95 0.46 3.33 1.75 59.65 0.46 3.58 1.54 65.81 0.48 3.34 1.32 59.09 0.50 3.26 1.18 47.47 0.51 1.11 59.80 0.52 COLGATE'S SUMMARY FINANCIAL DATA 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 (In billions, except per share data) Net sales Gross profit Operating income Net income Restructuring charge (after tax) Net income before restructuring Op income before restructuring 9.90 5.75 2.14 16.73 9.59 3.84 2.43 0.00 2.43 3.84 15.56 9.20 3.49 2.20 0.06 2.26 3.55 15.33 9.01 3.62 2.29 0.00 2.29 3.62 15.33 9.01 3.33 1.96 0.11 2.07 3.44 13.79 8.22 2.96 1.74 0.18 1.92 3.14 12.24 7.21 2.57 1.35 0.29 1.64 2.86 11.40 6.62 2.37 1.35 0.15 1.50 2.52 10.58 6.15 2.20 1.33 0.06 1.39 2.26 1.42 9.29 5.35 2.02 1.29 0.00 1.29 2.02 9.43 5.46 1.86 1.15 0.00 1.15 1.86 0.04 1.46 2.18 Total assets Total liabilities Long-term debt Shareholders' equity Treasury stock at cost 12.72 10.18 4.43 2.07 12.81 11.17 8.36 2.82 2.68 11.31 11.13 7.88 2.82 3.12 10.48 9.98 7.94 3.59 1.92 9.70 10.11 7.72 3.22 9.14 7.62 2.72 1.41 8.07 8.51 7.05 2.92 1.35 7.58 8.67 7.21 3.09 1.25 6.97 7.48 6.38 2.68 0.89 6.50 7.09 6.53 3.21 0.35 6.15 6.98 5.93 2.81 0.85 5.20 2.29 8.90 Basic earnings per share Cash dividends per share Closing stock price Shares outstanding (billions) 4.98 2.27 92.39 0.48 4.45 2.03 80.37 0.49 4.53 1.72 82.15 0.49 3.81 1.56 68.54 0.50 3.35 1.40 77.96 0.51 2.57 1.25 65.24 0.51 2.54 1.11 54.85 0.52 2.45 0.96 51.16 0.53 2.60 0.90 50.05 0.53 2.33 0.72 52.43 0.54 2.02 0.68 57.75 0.55 2009 2002 2001 2011 2010 20.85 19.75 6.15 7.38 2.44 2.90 1.59 1.84 0.29 0.00 1.88 1.84 2.73 2.90 19.12 7.27 3.07 1.88 0.09 1.98 3.16 KIMBERLEY-CLARK'S SUMMARY FINANCIAL DATA 2008 2007 2006 2005 2004 2003 19.42 18.27 16.75 15.90 15.08 14.35 6.68 6.60 6.36 6.12 5.91 5.66 2.64 2.75 2.61 2.57 2.59 2.52 1.69 1.82 1.50 1.57 1.80 1.69 0.05 0.10 0.31 0.17 0.01 0.00 1.74 1.92 1.81 1.74 1.81 1.69 2.69 2.84 2.92 2.73 2.60 2.52 13.57 5.55 2.58 1.67 0.00 1.67 2.58 14.52 6.71 2.60 1.61 0.04 1.65 2.64 (In billions, except per share data) Net sales Gross profit Operating income Net income Restructuring charge (after tax) Net income before restructuring Op income before restructuring Total assets Total liabilities Long-term debt Shareholders' equity Treasury stock at cost Basic earnings per share Cash dividends per share Closing stock price Shares outstanding (billions) 19.37 13.84 5.43 5.53 2.11 19.86 13.12 5.12 5.92 4.73 19.21 12.47 4.79 5.41 4.09 18.09 12.80 4.88 3.88 4.29 18.44 11.73 4.39 5.22 3.81 17.07 9.75 2.28 6.10 1.39 16.30 9.59 2.59 5.56 6.38 17.02 9.30 2.30 6.63 5.05 16.78 9.15 2.73 6.77 3.82 15.59 9.13 2.84 5.65 3.35 15.01 8.51 2.42 5.65 2.75 3.04 4.02 2.76 73.56 0.40 4.47 2.58 63.04 0.41 4.53 2.38 63.71 0.42 4.08 2.27 52.74 0.41 4.13 2.08 69.34 0.42 3.27 1.92 67.95 0.46 3.33 1.75 59.65 0.46 3.58 1.54 65.81 0.48 3.34 1.32 59.09 0.50 3.26 1.18 47.47 0.51 1.11 59.80 0.52