Please answer the following question using excel

Please answer the question using excel

Case 4 (15pts) LO-5: evaluate Leverage and Capital Structure, Working Capital and Current Asset Management and Current Liabilities Management Compact, Co. has annual report with revenues $ 200.000 with Cost of Goods Sold 70% of Revenues, Purchase 45% of Cost of Goods Sold. The Company had an Average Age of Inventory (AAI) = 45 days, an Average Collection Period (ACP) of 30 days, and an Average Payment Period (APP) = 25 days. a. Calculate the firm's Operating Cycle period! b. Calculate the firm's Cash Conversion Cycle period! C. Calculate the amount of resources needed to support the firm's Cash Conversion Cycle (assuming 365 days in a year)