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 | |||||||