**NEED AS FORMULAS**

Please explain as well!

Calculating days' sales in receivables - Excel - FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A Paste BI Alignment Number Cells Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 Font Pick a new font for your text. D E F G H 1 1 2 3 Aguilera Corp. has a current accounts receivable balance of $438,720. Credit sales for the year just ended were $5,173,820. What is the receivables turnover? The days' sales in receivables? 4 5 6 7 Accounts receivable Credit sales Days per year $ $ 438,720 5,173,820 365 8 9 10 Complete the following analysis. Do not hard code values in your calculations. 11 12 13 14 15 Receivables turnover Days' sales in receivables 16 17 18 19 Sheet 1 + E 100% READY Attempt(s) Hint