- 1 33 33 Points Skipped Ebook Print References X File Paste Clipboard C3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 1 (126.41 KiB) Viewed 13 times
2 33.33 points eBook Print ច References XS FILE Paste Clipboard A1 1 2 3 4 5 6 ✓ A 7 8 9 10 11 12 13 14 15 16 17 18 19 > READY Attempt(s) Calculating days' sales in receivables - Excel FORMULAS DATA REVIEW VIEW Calibri % BIU Cell Alignment Number Conditional Format as Formatting Table Styles Styles ⠀ fx B с D E F G H I J 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? Accounts receivable $ Credit sales $ 438,720 5,173,820 365 Days per year Complete the following analysis. Do not hard code values in your calculations. Receivables turnover Days' sales in receivables Sheet 1 + B m + HOME INSERT PAGE LAYOUT - 11 A A M Font X Cells ? M Editing Sign In X 100% Hint
3 33.34 points eBook Print References XS- FILE Paste Clipboard A1 A 1 2 3 4 5 6 7 8 • 9 10 11 12 13 14 15 16 17 18 19 20 21 READY Attempt(s) Calculating days' sales in receivables - Excel FORMULAS DATA REVIEW VIEW Calibri % BIU- A. Alignment Number Conditional Format as Cell Formatting Table Styles Styles fx B C с D E F G H I J A company has net income of $186,000, a profit margin of 7.9 percent, and an accounts receivable balance of $123,840. Assuming 70 percent of sales are on credit, what is the company's days' sales in receivables? Net income $ 186,000 7.90% Profit margin Accounts receivable $ 123,840 Percent credit sales 70% Days per year 365 Complete the following analysis. Do not hard code values in your calculations. Total sales Credit sales Receivables turnover Days' sales in receivables Sheet1 + www 4 " + HOME INSERT Font X PAGE LAYOUT 11 - A A & ? Cells A Editing X Sign In 100% Hint