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 20 21 8 E- P A 4 READY Attempt(s) Calculating liquidity ratios - Excel FORMULAS DATA REVIEW % C A A Alignment Number Conditional Cells Editing - Formatting Cell Format as Table Styles Styles A fx SDJ, Inc., has net working capital of $2,710, current liabilities of $3,950, and Y B C D E F G H I J K SDJ, Inc., has net working capital of $2,710, current liabilities of $3,950, and inventory of $3,420. What is the current ratio? What is the quick ratio? Net working capital $ 2,710 Current liabilities $ 3,950 Inventory $ 3,420 Complete the following analysis. Do not hard code values in your calculations. Current assets Current ratio Quick ratio Sheet1 4 M G HOME Arial BIU. I INSERT - 12 Font X PAGE LAYOUT - A A Pry + VIEW ? + Sign In + X 100% Hint 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