Project 4 - Fin 345 Visit the Edgewell Personal Care Investor Relations website and dick on Financial Reports. In the SEC Filings folder, download the excel version of their 2019 Annual Report. Copy the following tabs from their Annual Report into your Project 4 spreadsheet-Income Statement, Balance sheet2, Cash Flow Statement, and Table 53. (Please note: you can use Yahoo Finance, Morningstar, etc. to check your results but you MUST Download the data from the Annual Report) Question 1: Create a spreadsheet that provides a historical view of Edgewell's key metrics: 1. Net Sales (2017-2109) 2. Gross Margin % (2017 - 2109) 3. EBIT % (2017-2109) 4. Current and Quick ratios. 2019 and 2018 only 5. "Net (decrease) or increase in cash and cash equivalents for 2019 and 2018. Found on the cash flow statement (one-line item) 6. Product breakdown: a. Net Sales b. Profit margin %'s for each product segment. C. Which product's revenue is growing which product has the highest profit margin% 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 (OR.PA). 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 Edgewell 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. Project 4 - Fin 345 Visit the Edgewell Personal Care Investor Relations website and dick on Financial Reports. In the SEC Filings folder, download the excel version of their 2019 Annual Report. Copy the following tabs from their Annual Report into your Project 4 spreadsheet-Income Statement, Balance sheet2, Cash Flow Statement, and Table 53. (Please note: you can use Yahoo Finance, Morningstar, etc. to check your results but you MUST Download the data from the Annual Report) Question 1: Create a spreadsheet that provides a historical view of Edgewell's key metrics: 1. Net Sales (2017-2109) 2. Gross Margin % (2017 - 2109) 3. EBIT % (2017-2109) 4. Current and Quick ratios. 2019 and 2018 only 5. "Net (decrease) or increase in cash and cash equivalents for 2019 and 2018. Found on the cash flow statement (one-line item) 6. Product breakdown: a. Net Sales b. Profit margin %'s for each product segment. C. Which product's revenue is growing which product has the highest profit margin% 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 (OR.PA). 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 Edgewell 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
