All the answers must entered as a formula

HS ? El x Calculating days' sales in receivables - Excel PAGE LAYOUT FORMULAS DATA REVIEW FILE HOME INSERT VIEW Sign In i Calibri - 11 AP 101 Paste BIU % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A B C D E T1 G H 1 J 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 a un Accounts receivable Credit sales Days per year $ $ 7 438,720 5,173,820 365 8 9 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 13 Receivables turnover 14 15 Days' sales in receivables 16 17 18 19 Sheet 1 READY T + 100% A