Question

Complete tabs 4.7 , 4.12, 4.27, 4.30 and 4.32 in the attached Chapter 4 Excel spredsheet. Complete tabs 5.2, 5.12, 5.22, 5.24, and 5.28 in the attached Chapter 5 Excel spreadsheet. An EXAMLE tab is provided in each spreadsheet for your quidance. You must use formulas in the spreadsheets to show your work.

125% Help FIN3310-Copy of Student CHO T Insert Table Chart Text ew Zoom Add Category EXAMPLE #4.2 #4.4 #4.5 #4.6 #4.7 4.3. Efficiency ratio: If Newton Manufacturers have an accounts receivable turnover of 4.8 times and net sales of $7,812,379, what is its level of receivables? Accounts receivable turnover Net sales 4.8 times $ 7,812,379 A/R Turnover = Net sales A/R A/R = Net sales A/R Turnover A/R = 1,627,578.96 30

Answer 1

(4.3)

accounts receivable turnover=net sales/average accounts receivables

Hence accounts receivables=(78,12,379/4.8)

=$16,27,578.96(approx)

=$16,27,579

(4.4)