Question

Analysis of Accounts Receivable and Allowance for Doubtful Accounts Steelcase, Inc. reported the following amounts in its 2014 and 2013 10-K reports (years ended February 28, 2014 and February 22, 2013). $ millions)
From the income statement
Net sales
From the balance sheet
Accounts receivable, net
Customer deposits
From the disclosure on allowance for doubtful accounts:
Balance at beginning of period Additions (reductions) charged to income
Adjustments or deductions
Balance at end of period
2014 2013
$2,989 $2,869
306.8 287.3
16.0 13.5
4.5 19.6
2.8 3.1
(4.3) (8.2)
13.0 14.5
b. Calculate Steelcase's gross receivables for the years given, and then determine the allowance for doubtful accounts as a percentage of the gross receivables. 2014 2013 Gross accounts receivable (in millions) Allowance as a % of gross receivables Round to one decimal place.)
c. Calculate Steelcase's accounts receivable turnover for 2014. (Use Accounts receivable, net for the calculation.) Round answer to one decimal place times
d. How much cash did Steelcase receive from customers in 2014? 3,005 million

Answer 1

Answer:

b. Gross Receivable = Net receivable +Allowance

2014 = $306.8 + $13 = $319.80

2013 = $287.3 + $14.5 = $301.8

Allowance as a % of Gross receivable = Allowance / Gross receivable

2014 = $13/319.80 = 0.041 =  4.1%

2013 = $14.5/301.8 = 0.015 = 1.5%

c. Average Net Accounts receivable = (Accounts receivable, net 2014 + Accounts receivable, net 2013) / 2 = ($306.8 + $287.3] / 2 = $297.05

Receivable Turnover = Net credit sales / Average Net Accounts receivable

Receivable Turnover = $2,989 / $297.05

Receivable Turnover = 10.06 Times

d) Cash received in 2014 = Beginning Gross receivables + Net sales - Ending Gross receivables-Adjustment in allowance (Write-off 2014)

Cash received in 2014 = $301.8 + $2,989 - $319.8 - $4.3

Cash received in 2014 = $2,966.7

Increase in customer deposits = $16 - 13.5 = $2.5

Total Cash received from customers in 2014 = Cash received in 2014 + Increase in customer deposits

Total Cash received from customers in 2014 = $2,966.7 + $2.5

Total Cash received from customers in 2014 = $2969.20