Sherwin-Williams Co (SHW) S Year- Consolidated Financial Statements G. (oll velues in millions) 12/31/2015 12/31/2016 12/11/2017...

 

  

Transcribed Image Text:

Sherwin-Williams Co (SHW) S Year- Consolidated Financial Statements G. (oll velues in millions) 12/31/2015 12/31/2016 12/11/2017 12/31/2018 12/31/2019 Balance Sheet Assets Cash Short-Term investments Accounts Receivable Inventory Other Current Assets Current Assets Net Property Plant & Equipment Intangibles Other Long Term Assets Tetal Long-Term Assets Total Assets %24 205.7 $ 889.8 S 204.2 S 155.5 5 1618 1,1143 1,2310 2,104.6 2,075.4 2,139.4 1,89.6 1,018.5 1,068.3 1,801.4 1,815.3 2983 4344.5 1,7768 320.3 438.2 355.7 440.9 4,631.7 2,658.9 3,627.3 4,465.8 1,041.9 1,095.9 3,520 11,739.3 1,398.7 1,381.9 12,816.7 12,1583 854.7 692.4 647.4 7988 604.4 3,133.0 3,125.2 15,492.6 14,789.8 15,864.5 5,791.9 $ 6,752.5 $ 19,958.4 $ 19,1334.3 $ 20,496.2 Liabilities Accounts Payable Accrued Expenses Notes Payable Current Portion of Long Term Debt Other Current Liabilities Current Liebilities Long Term Debt Other Long Term Liabilities Total Liabilities 1,157.6 S 1,034.6 S 1,791.6 S 1,799.4 S 1,876.3 860.5 976.6 1,4808 1,509.1 1,311.0 39.5 40.7 633.7 328.4 204,7 3.2 700.5 1.2 307.2 801.4 81.1 768 79.9 353.6 328.5 4,521.9 2.141.9 2,829.2 3,987.2 4,297.7 1,920.2 1,2113 9,885.7 9,4214 861.9 833.6 2,3913 2,397.7 15,4035 2,429.6 4,923.9 4,874.1 16,266.2 16,372.9 Equity Minority Interest Preferred Stock Common Stock Retained Earnings Total Common Equity Total Stockholders' Equity (1,773.9) (1,6307) (1,425. 7) 5,117.9 (1,885.9) 5,616.6 3,730.7 3,730.7 (2,564.1) 2,6418 867.9 3.509.1 6,687.4 1878.A 3,692.2 4,1233 867.9 1878.4 3,692.2 4,123 Total Liab.&Equity 5,791.9 S 6,752.5 $ 19.958.4 S 19.134.35 20,496 2 Common Shares Outstanding Stock Price (per share) 92.2 93.0 939 93.1 259 60 S 268 74S 410 04 S 39146 $ sa3.54 Income Statement Sales Costs of Goods Sold Depreciation arnd Amortiation Selling Gener al &Administrative Expense Earnings Before Interest and Taxes (EBIT) Interest EBT (Before Unusual itema) 5 31,139 S 11,855.6 5 14,983 5 175345 S 17.00 5,5815 198.6 5735.6 197.7 4918 S74.9 4.1010 1,8212 154.1 1,667.2 FinStms SHW Ouestion 1 4,6586 45494 2,5511 3.513.5 1,645.7 2.030.6 2,448.4 263.5 16.7 349.3 2.184.3 2,00 Question 4 1.583.9 1.767.2 Instructions Question 2 Question 3 EE E Merge & Center ipboard Font Alignment Sherwin-Williams Co (SHW) 5 Year Consolidated Financial Statements (all values in miltions) Intangibles Other Long-Term Assets Total Long-Term Assets Total Assets 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 12,816.7 798.8 15,492.6 1,398.7 1,181.9 17,158 11,739.3 692.4 647.4 854.7 604.4 3,133.0 3,125.2 6,752.5 S 19,958.4 $ 19,13343 $ 20,496.2 14,789.8 15,864.5 5,791.9 $ Liabilities Accounts Payable 1,157.6 S 860.5 39.5 1,034.6 S 1,791.6 S 1,799.4 S 1,509.1 1,8763 Accrued Expenses Notes Payable Current Portion of Long Term Debt Other Current Liabilities Current Liabilities Long Term Debt Other Long-Term Liabilities Total Liabilities 976.6 1,480.8 1,311.0 40.7 633.7 328.4 204.7 801.4 3.2 700.5 1.2 307.2 81.1 76.8 79.9 3536 4,297.7 3285 2,141.9 2,829.2 3,987.2 4,521.9 1,920.2 1,211.3 9,885.7 8,708.1 9,4214 2,429.6 16,372.9 861.9 833.6 2,393.3 2,397.7 4,923.9 4,874.1 16.266.2 15,403.5 Equity Minority Interest Preferred Stock Common Stock Retained Earnings Total Common Equity Total Stockholders' Equity (1,773.9) 2,641.8 (1,630.7) 3,509.1 (1,425.7) (1,885.9) 5,616.6 (2,564.1) 5,117.9 6,687.4 867.9 1,878.4 3,692.2 3,730.7 4,1233 867.9 1,878.4 3.692.2 3,730.7 4.123.3 Total Liab. & Equity 5,791.9 $ 6,752.5 $ 19,958.4 S 19,134.3 $ 20,496.2 Common Shares Outstanding Stock Price (per share) 92.2 93.0 93.9 93.1 393.46 5 92.1 259.60 S 268.74 $ 410.04 S 58a 54 Income Statement Sales Costs of Goods Sold Depreciation and Amortization Seling, General & Administrative Expense Earnings Before interest and Taxes (EBIT) Interest EBT (Before Unusual items) Unusual Items Earnings Before Taxes (EBT) $ 1,339.3 S 11,855.6 S 14,983.8 $ 17534.5 S 17900.8 7,802.8 5,581.5 9,602.6 5,735.6 197.7 9,837.8 198.6 4918 5963 5749 4,101.0 1,821.2 32749 2,4484 349.3 4,658.6 4,549.4 3,913.5 1,645.7 2,030.6 2.551.1 61.8 154.1 2635 366.7 1,583.9 1,667.2 1,767.2 2,184.3 2,099.1 35.0 71.9 238.9 824.7 1173 1,359.7 250.9 1,549.0 1.595.2 1528.2 (28S.6) 1,8138 S 4405 495.1 1,053.8 S Taxes 462.5 1108.7 S 322.9 1,541. Net Income Common Dividends Other Dividends & Distributions Addition to Retained Earnings 249.6 312.1 3190 (1139) 1.608.7S 287.1 498. S 115 1 49.7 (46.71 867.4 $ 1,070. 689.1 S Instructions FinStms SH W Question 1 Question 2 Question 3 Question 4 12 Clipboard Font Alignment Number A1 fx Question 1- Ratio Analysis Use the financial stotements provided with the worksheet below to complete this questien a. Caludate the total debt for the firm and the five debt managementration as tisted for the firm for the tast five years b. Trom a book value standpoint, indicate whether the fim's use of debt to finance its asets has increased/decreased/remained steady over the most recent fout yrars Which ratio did you une to arrive at this answer?Explain how this change in debt financing impacted the firm's abity to cover its interest expense using your calcutated values C. Calulate the firm's net profit margin, total asset turnover, and equity multiplier for the last five yas Uhing the Dont tormula, calulate the firm's return on common equity d. Based upon your results, did the firm's operatine.performance hate a significant impact on its return on common equity? Explain, using your calculated values parta ASSET MANAGEMENT RATIOS 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/11/2019 Total Cebit Debt Ratio Debt to Equity Ratio Market Debt Ratio tiabilities to Assets Ratio Times Interest Earned Ratio part b RATIOS- CONCEPTUAL QUESTION mcreased/Decreased/Remained Steady Ratio Used Interest Espense Coverage Explanation: part e DUPONT ANALYSIS Instructions FinStms SHW Question 1 Question 2 Question 3 Question 4 P Type here to search DII 立 ite U General BIU-H aA- EEEEEE Merge & Center $ - % > pboard Font Alignment Number Question 1- Ratio Analysis part b RATIOS -CONCEPTUAL QUESTION Increased/Decreased/Remained Steady Ratio Used Interest Expense Coverage Explanation: part e DUPONT ANALYSIS 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 Net Profit Margin Total Asset Turmover Equity Muitiplier Return on Common Equity (DuPont) part d RATIOS - CONCEPTUAL QUESTION Did operating performance impact the firm's ROE? (Answer Yes or No): Explanation: Instructions FinStms SHW Question 1 Question 2 Question 3 Question 4 O Type here to search 立 Sherwin-Williams Co (SHW) S Year- Consolidated Financial Statements G. (oll velues in millions) 12/31/2015 12/31/2016 12/11/2017 12/31/2018 12/31/2019 Balance Sheet Assets Cash Short-Term investments Accounts Receivable Inventory Other Current Assets Current Assets Net Property Plant & Equipment Intangibles Other Long Term Assets Tetal Long-Term Assets Total Assets %24 205.7 $ 889.8 S 204.2 S 155.5 5 1618 1,1143 1,2310 2,104.6 2,075.4 2,139.4 1,89.6 1,018.5 1,068.3 1,801.4 1,815.3 2983 4344.5 1,7768 320.3 438.2 355.7 440.9 4,631.7 2,658.9 3,627.3 4,465.8 1,041.9 1,095.9 3,520 11,739.3 1,398.7 1,381.9 12,816.7 12,1583 854.7 692.4 647.4 7988 604.4 3,133.0 3,125.2 15,492.6 14,789.8 15,864.5 5,791.9 $ 6,752.5 $ 19,958.4 $ 19,1334.3 $ 20,496.2 Liabilities Accounts Payable Accrued Expenses Notes Payable Current Portion of Long Term Debt Other Current Liabilities Current Liebilities Long Term Debt Other Long Term Liabilities Total Liabilities 1,157.6 S 1,034.6 S 1,791.6 S 1,799.4 S 1,876.3 860.5 976.6 1,4808 1,509.1 1,311.0 39.5 40.7 633.7 328.4 204,7 3.2 700.5 1.2 307.2 801.4 81.1 768 79.9 353.6 328.5 4,521.9 2.141.9 2,829.2 3,987.2 4,297.7 1,920.2 1,2113 9,885.7 9,4214 861.9 833.6 2,3913 2,397.7 15,4035 2,429.6 4,923.9 4,874.1 16,266.2 16,372.9 Equity Minority Interest Preferred Stock Common Stock Retained Earnings Total Common Equity Total Stockholders' Equity (1,773.9) (1,6307) (1,425. 7) 5,117.9 (1,885.9) 5,616.6 3,730.7 3,730.7 (2,564.1) 2,6418 867.9 3.509.1 6,687.4 1878.A 3,692.2 4,1233 867.9 1878.4 3,692.2 4,123 Total Liab.&Equity 5,791.9 S 6,752.5 $ 19.958.4 S 19.134.35 20,496 2 Common Shares Outstanding Stock Price (per share) 92.2 93.0 939 93.1 259 60 S 268 74S 410 04 S 39146 $ sa3.54 Income Statement Sales Costs of Goods Sold Depreciation arnd Amortiation Selling Gener al &Administrative Expense Earnings Before Interest and Taxes (EBIT) Interest EBT (Before Unusual itema) 5 31,139 S 11,855.6 5 14,983 5 175345 S 17.00 5,5815 198.6 5735.6 197.7 4918 S74.9 4.1010 1,8212 154.1 1,667.2 FinStms SHW Ouestion 1 4,6586 45494 2,5511 3.513.5 1,645.7 2.030.6 2,448.4 263.5 16.7 349.3 2.184.3 2,00 Question 4 1.583.9 1.767.2 Instructions Question 2 Question 3 EE E Merge & Center ipboard Font Alignment Sherwin-Williams Co (SHW) 5 Year Consolidated Financial Statements (all values in miltions) Intangibles Other Long-Term Assets Total Long-Term Assets Total Assets 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 12,816.7 798.8 15,492.6 1,398.7 1,181.9 17,158 11,739.3 692.4 647.4 854.7 604.4 3,133.0 3,125.2 6,752.5 S 19,958.4 $ 19,13343 $ 20,496.2 14,789.8 15,864.5 5,791.9 $ Liabilities Accounts Payable 1,157.6 S 860.5 39.5 1,034.6 S 1,791.6 S 1,799.4 S 1,509.1 1,8763 Accrued Expenses Notes Payable Current Portion of Long Term Debt Other Current Liabilities Current Liabilities Long Term Debt Other Long-Term Liabilities Total Liabilities 976.6 1,480.8 1,311.0 40.7 633.7 328.4 204.7 801.4 3.2 700.5 1.2 307.2 81.1 76.8 79.9 3536 4,297.7 3285 2,141.9 2,829.2 3,987.2 4,521.9 1,920.2 1,211.3 9,885.7 8,708.1 9,4214 2,429.6 16,372.9 861.9 833.6 2,393.3 2,397.7 4,923.9 4,874.1 16.266.2 15,403.5 Equity Minority Interest Preferred Stock Common Stock Retained Earnings Total Common Equity Total Stockholders' Equity (1,773.9) 2,641.8 (1,630.7) 3,509.1 (1,425.7) (1,885.9) 5,616.6 (2,564.1) 5,117.9 6,687.4 867.9 1,878.4 3,692.2 3,730.7 4,1233 867.9 1,878.4 3.692.2 3,730.7 4.123.3 Total Liab. & Equity 5,791.9 $ 6,752.5 $ 19,958.4 S 19,134.3 $ 20,496.2 Common Shares Outstanding Stock Price (per share) 92.2 93.0 93.9 93.1 393.46 5 92.1 259.60 S 268.74 $ 410.04 S 58a 54 Income Statement Sales Costs of Goods Sold Depreciation and Amortization Seling, General & Administrative Expense Earnings Before interest and Taxes (EBIT) Interest EBT (Before Unusual items) Unusual Items Earnings Before Taxes (EBT) $ 1,339.3 S 11,855.6 S 14,983.8 $ 17534.5 S 17900.8 7,802.8 5,581.5 9,602.6 5,735.6 197.7 9,837.8 198.6 4918 5963 5749 4,101.0 1,821.2 32749 2,4484 349.3 4,658.6 4,549.4 3,913.5 1,645.7 2,030.6 2.551.1 61.8 154.1 2635 366.7 1,583.9 1,667.2 1,767.2 2,184.3 2,099.1 35.0 71.9 238.9 824.7 1173 1,359.7 250.9 1,549.0 1.595.2 1528.2 (28S.6) 1,8138 S 4405 495.1 1,053.8 S Taxes 462.5 1108.7 S 322.9 1,541. Net Income Common Dividends Other Dividends & Distributions Addition to Retained Earnings 249.6 312.1 3190 (1139) 1.608.7S 287.1 498. S 115 1 49.7 (46.71 867.4 $ 1,070. 689.1 S Instructions FinStms SH W Question 1 Question 2 Question 3 Question 4 12 Clipboard Font Alignment Number A1 fx Question 1- Ratio Analysis Use the financial stotements provided with the worksheet below to complete this questien a. Caludate the total debt for the firm and the five debt managementration as tisted for the firm for the tast five years b. Trom a book value standpoint, indicate whether the fim's use of debt to finance its asets has increased/decreased/remained steady over the most recent fout yrars Which ratio did you une to arrive at this answer?Explain how this change in debt financing impacted the firm's abity to cover its interest expense using your calcutated values C. Calulate the firm's net profit margin, total asset turnover, and equity multiplier for the last five yas Uhing the Dont tormula, calulate the firm's return on common equity d. Based upon your results, did the firm's operatine.performance hate a significant impact on its return on common equity? Explain, using your calculated values parta ASSET MANAGEMENT RATIOS 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/11/2019 Total Cebit Debt Ratio Debt to Equity Ratio Market Debt Ratio tiabilities to Assets Ratio Times Interest Earned Ratio part b RATIOS- CONCEPTUAL QUESTION mcreased/Decreased/Remained Steady Ratio Used Interest Espense Coverage Explanation: part e DUPONT ANALYSIS Instructions FinStms SHW Question 1 Question 2 Question 3 Question 4 P Type here to search DII 立 ite U General BIU-H aA- EEEEEE Merge & Center $ - % > pboard Font Alignment Number Question 1- Ratio Analysis part b RATIOS -CONCEPTUAL QUESTION Increased/Decreased/Remained Steady Ratio Used Interest Expense Coverage Explanation: part e DUPONT ANALYSIS 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 Net Profit Margin Total Asset Turmover Equity Muitiplier Return on Common Equity (DuPont) part d RATIOS - CONCEPTUAL QUESTION Did operating performance impact the firm's ROE? (Answer Yes or No): Explanation: Instructions FinStms SHW Question 1 Question 2 Question 3 Question 4 O Type here to search 立

Answer rating: 100% (QA)

part a ASSET MANAGEMENT RATIOS 12312015 12312016 12312017 12312018 12312019 TOTAL DEBT 49239 48741 162662 154035 163729 DEBT RATIO 085 072 8150 8050 7... View the full answer