I need help with attached questions. Please use excel to show work. Need ASAP

1. ABC\tCorporation\tcurrently\thas\tan\tinventory\tturnover\tof\t15.7,\ta\tpayables\tturnover\tof\t9.6,\tand\ta receivables\tturnover\tof\t8.4. a. How\tmany\tdays\tare\tin\tthe\tcash\tcycle? b. How\tmany\tdays\tare\tin\tthe\toperating\tcycle? 2. Compute\tthe\tAccounts\tPayable\tPeriod\tbased\ton\tthe\tfollowing\tinformation: ABC Products provides the following information. Average Accounts Payable Balance is as follows: Annual Cost of Goods sold is as follows: Assume 365 days. Compute the Accounts Payable period. $800,000 $9,000,000 3. Compute\tthe\tOperating\tCycle\tbased\ton\tthe\tfollowing\tinformation: ABC Products provides the following information. Average Collection Period 45 days Accounts Payable Period 45 days Average age of inventory 60 days Compute operating cycle 4. Consider\tthe\tfollowing\tfinancial\tstatement\tinformation\tfor\tABC\tCorporation. Assume\tall\tsales\tare\ton\tcredit. a. How\tlong\tis\tthe\tcash\tcycle? b. How\tlong\tis\tthe\toperating\tcycle? 5. The\tABC\tCorporation\thas\tthe\tfollowing\testimated\tquarterly\tsales\tfor\tnext\tyear. The\taverage\tcollection\tperiod\tis\t30\tdays.\tPurchases\tare\tequal\tto\t64\tpercent\tof\tthe\tfollowing quarter's\tsales.\tSuppliers\tare\tnormally\tpaid\tin\t60\tdays.\tDetermine\tthe a. Cash\treceived\tfrom\tcustomers\tin\tQuarter\t2 b. Ending\tAccounts\tReceivables\tBalance\tin\tQuarter\t2 c. Cash\tpaid\tto\tsuppliers\tin\tQuarter\t2 d. Ending\tAccounts\tPayable\tBalance\tin\tQuarter\t2 e. Cash\treceived\tfrom\tcustomers\tin\tQuarter\t3 f. Ending\tAccounts\tReceivables\tBalance\tin\tQuarter\t3 g. Cash\tpaid\tto\tsuppliers\tin\tQuarter\t3 h. Ending\tAccounts\tPayable\tBalance\tin\tQuarter\t3 Page\t1\tof\t3 Solve\tnext\tfour\tquestions\tbased\ton\tthe\tfollowing\tinformation: Month Jan Feb Mar Apr May June Sales $15,306 $15222 $20,121 $22,400 $19,220 $20,212 Month July Aug Sept Oc t Nov Dec Sales $21,083 $25,000 $25,400 $18,950 $19,220 $19,088 The c ompany has estimated expenses as follows: General and Administrative Expenses per month: $5,500 Material Purc hases (are paid in the month following the purc hase): 11% of sales Interest Expense per month: $250 Rent expenses per quarter starting Marc h: $950 Sales are c ollec ted as follows: In the month of sales: 20% In the next month: 5% After 2 months: 30% After 3 months: Remaining Balanc e 6. Find\tthe\tcash\toutflows\tfor\tFebruary 7. Calculate\tthe\tcash\toutflows\tfor\tJune 8. Calculate\tthe\tcollection\tfrom\tsales\tfor\tDecember 9. Calculate\tthe\tcollection\tfrom\tsales\tfor\tJune Page\t2\tof\t3