Nike financial analysis statement Appendix C Nike Inc Form 1
Solution
a.
Working Capital = Total current assets - Total current liabilities
Working capital on May 31, 2013 = $13,626 million - $3,926 million = $9,700 million
Working capital on May 31, 2012 = $11,845 million - $3,882 million = $7,963 million
b.
Current Ratio = Total current assets - Total current liabilities
Current ratio on May 31, 2013 = $13,626 million / $3,926 million = 3.47 times
Current ratio on May 31, 2012 = $11,845 million / $3,882 million = 3.05 times
c.
Quick ratio = (Total current assets - Inventories - Prepaid expenses) / Total current liabilities
Quick ratio on May 31, 2013 = ($13,626 - $3,434 - 802) million / $3,926 million = 2.40 times
Quick ratio on May 31, 2012 = ($11,845 - $3,222 - $857) million / $3,882 million = 2 times
d.
Accounts receivable turnover = Sales / Average accounts receivable
Where,
Average accounts receivable = (Beginning accounts receivable + Ending accounts receivable) / 2
Accounts receivable turnover on May 31, 2013 = $25,313 / [ ($3,117 + 3,132) / 2 ] = 8.1 times
Accounts receivable turnover on May 31, 2012 = $23,331 / [ ($3,132 + $3,138) / 2 ] = 7.44 times
e.
Number of days\' sales in receivables = 365 days / Accounts receivable turnover
Number of days\' sales in receivables on May 31, 2013 = 365 days / 8.1 = 45 days
Number of days\' sales in receivables on May 31, 2012 = 365 days / 7.44 = 49 days
