*All answers must be entered as a FORMULA PLEASE*

Example: If they asked what the net income is, it would be =D6

A B D E F G H I J K 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 22 23