Project For ACG 3301 Summer 2013
Project for ACG 3301 summer 2013
Application & Analysis
Sherwin Williams Paints: Obtain its annual report by going to the company’s website. Download the annual report for the most recent year. (On many company’s websites, you will need to visit the Investor Relations section to obtain the company’s financial statement.) You may also collect the information from the company’s Form 10-K, which can be found at http://sec.gov/idea/searchidea/companysearch_idea.html.
Questions
1. Locate the company’s annual report as outlined previously. Find the company’s segment information; it should be in the “Notes to Consolidated Financial Statements” or other similarly named section. Look for the word “Segment” in a heading—that is usually the section you need.
2. List the segments as reported in the annual report. Make a table listing each operating segment Revenues Profit
Paint Stores Group, $5,410 $862
Consumer Group, $1,322 $217
Global Finishes Group, $1,961 $147
Latin America Coatings Group $836 $81 3. Use the data you collected in Requirement 2 to calculate each segment’s sales margin. Interpret your results.
Sales Margin = Operating Income / Sales
Painting Stores Group:
Sales Margin= 862 / 5410 = 15.9%
Consumer Group:
Sales Margin = 217 / 1322 = 16.4%
Global Finishes Group:
Sales Margin = 147 / 1961 = 7.5%
Latin America Coatings Group:
Sales Margin = 81 / 836 = 9.7%
4. Use the data you collected in Question 2 to calculate each segment’s capital turnover. Interpret your results.
Painting Stores Group:
Capital Turnover= 5410 / 1374 = 3.94
Consumer Group:
Capital Turnover = 1322 / 1701 = 0.78
Global Finishes Group:
Capital Turnover = 1961 / 987 = 1.99
Latin America Coatings Group:
Capital Turnover = 836 / 485 = 1.72
5. Use the data you collected in Requirement 2 to calculate
Application & Analysis
Sherwin Williams Paints: Obtain its annual report by going to the company’s website. Download the annual report for the most recent year. (On many company’s websites, you will need to visit the Investor Relations section to obtain the company’s financial statement.) You may also collect the information from the company’s Form 10-K, which can be found at http://sec.gov/idea/searchidea/companysearch_idea.html.
Questions
1. Locate the company’s annual report as outlined previously. Find the company’s segment information; it should be in the “Notes to Consolidated Financial Statements” or other similarly named section. Look for the word “Segment” in a heading—that is usually the section you need.
2. List the segments as reported in the annual report. Make a table listing each operating segment Revenues Profit
Paint Stores Group, $5,410 $862
Consumer Group, $1,322 $217
Global Finishes Group, $1,961 $147
Latin America Coatings Group $836 $81 3. Use the data you collected in Requirement 2 to calculate each segment’s sales margin. Interpret your results.
Sales Margin = Operating Income / Sales
Painting Stores Group:
Sales Margin= 862 / 5410 = 15.9%
Consumer Group:
Sales Margin = 217 / 1322 = 16.4%
Global Finishes Group:
Sales Margin = 147 / 1961 = 7.5%
Latin America Coatings Group:
Sales Margin = 81 / 836 = 9.7%
4. Use the data you collected in Question 2 to calculate each segment’s capital turnover. Interpret your results.
Painting Stores Group:
Capital Turnover= 5410 / 1374 = 3.94
Consumer Group:
Capital Turnover = 1322 / 1701 = 0.78
Global Finishes Group:
Capital Turnover = 1961 / 987 = 1.99
Latin America Coatings Group:
Capital Turnover = 836 / 485 = 1.72
5. Use the data you collected in Requirement 2 to calculate