Pic 1: Balance Sheet Pic 2: Income Statement Pic 3: Cash Flow Statement Pic 4: Ratios

Project instructions and grading scheme. 1. Perform the vertical and horizontal analysis and calculate the ratios as instructed (37.1 points). Fill the grey cells by using formulas NOT hardcoding. You will not earn credit for hardcoding (entering the figures manually). 2. You are a financial analyst. Based on your analysis of Sherwin Williams's (SW) financial statements, provide a report to guide investors whether SW is a buy (keep) or sell stock. Your report should include the following a. An interpretation of trends illustrated by supportive ratios, horizontal and vertical analysis and focus on the main ratios that "tell the story". (a minimum of 2 pages-not to exceed three pages, single space, 12 font size-in the form of report/write up NOT bullet points). i. Horizontal (Rate of Change-See for example Exhibit 4.5 in your textbook) and Vertical analysis (Common Size- See for example Exhibit 4.4 in your textbook) (12 points) ii. Liquidity analysis ( 10 points) iii. Efficiency analysis ( 10 points) iv. Profitability analysis ( 10 points) v. Solvency analysis ( 10 points) b. Your informed recommendation (buy or sell) about SW with justifications. What is your general impression about Macy's ? Support your conclusion (1- paragraph) (10.9 points) 3. To calculate ratios, use the formulas that are provided in your textbook (page 4-51, 5-37, 540). Project instructions and grading scheme. 1. Perform the vertical and horizontal analysis and calculate the ratios as instructed (37.1 points). Fill the grey cells by using formulas NOT hardcoding. You will not earn credit for hardcoding (entering the figures manually). 2. You are a financial analyst. Based on your analysis of Sherwin Williams's (SW) financial statements, provide a report to guide investors whether SW is a buy (keep) or sell stock. Your report should include the following a. An interpretation of trends illustrated by supportive ratios, horizontal and vertical analysis and focus on the main ratios that "tell the story". (a minimum of 2 pages-not to exceed three pages, single space, 12 font size-in the form of report/write up NOT bullet points). i. Horizontal (Rate of Change-See for example Exhibit 4.5 in your textbook) and Vertical analysis (Common Size- See for example Exhibit 4.4 in your textbook) (12 points) ii. Liquidity analysis ( 10 points) iii. Efficiency analysis ( 10 points) iv. Profitability analysis ( 10 points) v. Solvency analysis ( 10 points) b. Your informed recommendation (buy or sell) about SW with justifications. What is your general impression about Macy's ? Support your conclusion (1- paragraph) (10.9 points) 3. To calculate ratios, use the formulas that are provided in your textbook (page 4-51, 5-37, 540)