2:41

2:41 < Back Project 4-5.docx Visi t the website. Click drop to SEC Filings. In the SEC Filings down to Annual Filings and the excel Of 2019 Annual Report. Copy the following tabs their Annual Report into your Project 4 spreadsheet income. consol idated balance Sheets. Colgate-Palmolive Colgate-palmolive company 33. Finum-e Similar check 'Ot' DO 'he Annual Question I : Create a spreadsheet that provides a histical view of Colgate's key metrics. To the right of each metric. if the metric is positive. neutral. or negative for the l. Net sales (2017-2109) 2. Gross Profit % (2017 - 2109) 3. operating Profit % (2017 - 2109) 4. Current ratio 2019 and 201S only 5. Quick ratio. 2019 and20180n1y 6. LT Dcbt'Equity. 2019 and 20180n1y product a, Net Sales b. Profit margin % s for each Rgnxnt. C a spreadsheet that will Frform a Analysis this vs. an industry average. Col gate s primary are Unilcvcr, and (Note: you to thc statements of each comFtitor_ Utilize similM websites to data). Dulmt highli#t is doing in (highlighted in th Colgate to to easier of the Based on the results Of Questions I and 2. you recommend buying Shares Of Colgate? by prt"iding at least one reason from I and one reason from Question 2. Dashboard