Question: Please solve for the cash cycle using excel. Thank you. In fiscal 2017 and 2016, Estee Lauder's financial statements included the following items. $ millions

Please solve for the cash cycle using excel. Thank you.

In fiscal 2017 and 2016, Estee Lauder's financial statements included the following items. $ millions 2017 2016 Inventory $ 1, 405 $ 1, 264 Receivables 1, 660 1, 258 Payables 2, 713 2,349 Sales 11 , 115 11, 262 Cost of goods sold 2, 413 2, 181 What was its cash cycle? Assume 365 days in a year. (Negative amounts should be Indicated by a minus sign. Do not round intermediate calculations. Round your answer to the nearest whole number.) Cash cycle days
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
