7 Calculating days sales in receivables - Excel PAGE LAYOUT FORMULAS DATA REVIEW HOME INSERT VIEW Calibri B I U. . .A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles 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 Profit margin Accounts receivable Percent credit sales Days per year 186,000 7.90% 123,840 7096 365 Complete the following analysis. Do not hard code values in your calculations Total sales Credit sales Receivables turnover Days' sales in receivables