In: Finance
4. Vitron Corp. has a current accounts receivable balance of $483,810. Credit sales for the year ended were $5,700,000. What is the receivables turnover? The days’ sales in receivables? (10 Points)
(Use Excel and Excel Formulas)
| Account Receivables | $ 483810 | ||||||
| Credit Sales | $5700000 | ||||||
| Receivables Turnover | =Net Credit Sales | ||||||
| Average Accounts receivable | |||||||
| =5700000/483810 | |||||||
| 11.78148 | |||||||
| Days Sales | =Accounts Receivable * Number of Days | ||||||
| Total Credit Sales | |||||||
| =483810/5700000*365 | |||||||
| 30.98082 | |||||||