Question

Microsoft Corporation reported the following information in its financial statements for three successive quarters ($ in millions): Three Months Ended 9/30/2017 6/30/2017 3/31/2017 (21) (24) (23) $14,561 $19,792 $12,882 Balance sheets: Accounts receivable, net Income statements: Sales revenue $24,538 $23,317 $22,090 Required: Compute the receivables turnover ratio and the average collection period for Q1 and Q4. Assume that each quarter consists of 91 days. (Enter your answers in millions. Round average accounts receivable answers to nearest whole dollar and "Turnover ratio" answers to 3 decimal places.) Receivables Turnover Ratio I Choose Denominator: Choose Numerator: = Receivables Turnover Ratio Receivables turnover ratio Q4 times times Average collection period I Choose Denominator: Choose Numerator: = Average collection period Average collection period Q4 days days Q11

Answer 1

Receivable Turnover Ratio = Net sales / Average Accounts Receivables

Q4 = $23317 / $16337 = 1.43
Average Accounts Receivables = ($12882+19792)/2 = $16337

Q1 = $24538 / $17176.50 = 1.43
Average Accounts Receivable = ($19792+14561)/2 = $17176.50

Average Collection Period = 91 / Receivable Turnover ratio

Q4 = 91 / 1.43 = 63.76 days

Q1 = 91 / 1.43 = 63.70 days