Accounts receivable analysis The following data are taken from the financial statements of Sigmon Inc. Terms of al sales are 2/10,45 2013 2012 2011 Accounts receivable, end of year $735,000 $655,000 $580,000 Sales on account 5,692,000 4,623,500 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and thout your own as the rest Open spreadsheet a. For 2012 and 2043, determine (1) the accounts receivable tumover and (2) the number of days sincebes And intermediate calculations. Round your answers to one decimal place. 20Y3 2012 days days 1. Accounts receivable turnover 2. Number of days. sales in receivables This can be seen in both the b. The collection of accounts receivable has in the collection period. at) (Arias Se Santa File Home Insert Search Option Draw Page Layout Formulas Data Review Arial View Help 10 B ng YAY D13 1 A B C D E F Accounts receivable analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10 n/45. G 2 3 4 5 6 Accounts receivable, end of year Sales on account 2013 $735,000 5,692,000 20Y2 $655,000 4,623,500 2011 $580,000 Number of days in a year 365 Using formulas and cell references, perform the required analysis, and input your answers into the 2073 and 2072 columns respectively. Transfer the numeric results for the green entry cells (D13:E14) into the appropriate fields in CNOW 2 for grading Formulas 20Y3 2012 a 1. Accounts receivable turnover 2. Number of days' sales in receivables 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26