Operating Cycle and Cash Cycle Calculations

1. A company has an average collection period (ACP) of 20 days and AR balance of $100,000. Assume 365 days. Note: ACP is same as AR Period.
2. What is the Accounts Receivables Turnover (ART)?
3. What is the sales amount?
4. A company has an Accounts Payable period of 25 days and annual COGS of $300,000.Assume 365 days.
5. What is the Accounts Payable Turnover (APT)?
6. What is the AP balance?
7. ABC Company has an average collection period of 18 days and annual sales of $694,000.
8. What is the Accounts Receivable Turnover?
9. What is the amount of Accounts Receivable as shown on the balance sheet?
10. Inventory Turnover Ratio is 5 times, Accounts Receivable Turnover is 8 times, Account Payable Turnover is 3 times. What is the Operating Cycle? What is the cash cycle?
11. Inventory Period is 30 days, AR period is 25 days, AP Period is 10 days. What is the Operating Cycle? What is the Cash Cycle? What is the Inventory Turnover Ratio? Accounts Receivable Turnover? What is the Account Payable Turnover?

Show work step-by-step using Excel