roject 4- Fin 345 Due: March 15 Visit the Edgewell Personal Care Investor Relations website and click on Financial Reports. In the SEC Filings folder, download the excel version of their 2018 Annual Report. Copy the following tabs from their Annual Report into your Project 4 spreadsheet-Income Statement, Balance Sheet2, Cash Flow Statement, and Table 50 Question 1: Create a spreadsheet that provides a historical view of Edgewell's key metrics: 1. Net Sales (2016-2108); Also, calculate YoY sales trend 2018 vs. 2017 and 2017 vs. 2016 2. Gross Margin % (2016-2108); Also, calculate YoY trends for 2018 vs. 2017 and 2017 vs. 2016 3. EBIT % (2016-2108); Also, calculate YoY trends for 2018 vs. 2017 and 2017 vs. 2016 4. Current and Quick ratios. 2018 and 2017 only 5. Net decrease or increase in cash for 2018 and 2017 from the cash flow statement (one-line item) Product breakdown: " a. Net revenue YoY sales trend 2018 vs. 2017 and 2017 vs. 2016; Profit margin %'s for each product segment. which product's revenue is growing; which product has the highest profit margin % c. Question 2: Create a spreadsheet that will perform a Dupont Analysis for this stock vs. an industry average For this exercise, calculate the Dupont ratio for Edgewell Personal Care (EPC). In addition, compile the industry average using Edgewell's primary competitors (Proctor & Gamble, Spectrum Brands, and L'Oreal). Note: you do not need to download the financial statements of each competitor. Instead utilize Yahoo Finance (or other websites) to easily source data for each of the competitors. Illustrate each Dupont component and highlight where Edgewe is doing better (highlighted in green) and/or worse (highlighted in red) than the industry. Please have your Edgewell Personal Care column next to the industry column to allow for easier illustration of the differences. Finally, please remember to include Edgewell into your industry average calculation Based on the results of Questions 1 and 2, would you recommend buying shares of Edgewell Personal Care? Defend your answer roject 4- Fin 345 Due: March 15 Visit the Edgewell Personal Care Investor Relations website and click on Financial Reports. In the SEC Filings folder, download the excel version of their 2018 Annual Report. Copy the following tabs from their Annual Report into your Project 4 spreadsheet-Income Statement, Balance Sheet2, Cash Flow Statement, and Table 50 Question 1: Create a spreadsheet that provides a historical view of Edgewell's key metrics: 1. Net Sales (2016-2108); Also, calculate YoY sales trend 2018 vs. 2017 and 2017 vs. 2016 2. Gross Margin % (2016-2108); Also, calculate YoY trends for 2018 vs. 2017 and 2017 vs. 2016 3. EBIT % (2016-2108); Also, calculate YoY trends for 2018 vs. 2017 and 2017 vs. 2016 4. Current and Quick ratios. 2018 and 2017 only 5. Net decrease or increase in cash for 2018 and 2017 from the cash flow statement (one-line item) Product breakdown: " a. Net revenue YoY sales trend 2018 vs. 2017 and 2017 vs. 2016; Profit margin %'s for each product segment. which product's revenue is growing; which product has the highest profit margin % c. Question 2: Create a spreadsheet that will perform a Dupont Analysis for this stock vs. an industry average For this exercise, calculate the Dupont ratio for Edgewell Personal Care (EPC). In addition, compile the industry average using Edgewell's primary competitors (Proctor & Gamble, Spectrum Brands, and L'Oreal). Note: you do not need to download the financial statements of each competitor. Instead utilize Yahoo Finance (or other websites) to easily source data for each of the competitors. Illustrate each Dupont component and highlight where Edgewe is doing better (highlighted in green) and/or worse (highlighted in red) than the industry. Please have your Edgewell Personal Care column next to the industry column to allow for easier illustration of the differences. Finally, please remember to include Edgewell into your industry average calculation Based on the results of Questions 1 and 2, would you recommend buying shares of Edgewell Personal Care? Defend your
