X 5 ? el - Calculating days' sales in receivables - Excel PAGE LAYOUT FORMULAS DATA REVIEW FILE HOME INSERT VIEW Sign In Calibri - 11 LLLL Paste BIU- % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 fox A B D E F G H J 1 2 3 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? 4 5 6 $ 7 8 Net income Profit margin Accounts receivable Percent credit sales Days per year $ 186,000 7.90% 123,840 70% 365 9 10 11 12 13 Complete the following analysis. Do not hard code values in your calculations. 14 15 Total sales 16 17 Credit sales 18 19 Receivables turnover 20 21 Days' sales in receivables