I need to put this information into the attached spreadsheet but I dont know;

Financial Ratio Calculations - Columbia Sportswear

Sales 2014 AR 2013 AR

2,100,590 344,390 306,878

Receivables Turnover: 6.45 Average Collection Period: 56.58

Financial Ratio Calculations - VF Corporation

Sales 2014 AR 2013 AR

12,154,784 1,276,224 776,403

Receivables Turnover: 11.84 Average Collection Period: 30.82

Name Section Date (a) Chapter 8 Comparative Analysis Problem Columbia Sportswear Company vs. VF Corporation Columbia Sportswear VF Corporation (1) Accounts receivable turnover: (2) Average collection period: (b) 475 475 ative Analysis Problem any vs. VF Corporation 475 475 Financial Ratio Calculations - Columbia Sportswear Sales 2014 AR 2,100,590 2013 AR 344,390 306,878 Receivables Turnover: 6.45 Average Collection Period: 56.58 Financial Ratio Calculations - VF Corporation Sales 2014 AR 12,154,784 2013 AR 1,276,224 776,403 Receivables Turnover: 11.84 Average Collection Period: 30.82 What conclusions concerning the management of accounts receivable can be drawn from this data? The receivables turnover ratio is nearly two times higher for YF Corporation than Columbia Sportswear. This means that YF sells more merchandise on a cash basis and is more conservative about extending credit to customers. Columbia is more likely to sell items on credit, which may increase revenue, but also carries a higher risk of loss. The average collection period estimates the number of days that will pass for a credit sale to be paid in cash. As expected, YF has a lower turnover ratio, which means their receivables will take less time to be paid on average compared to Columbia