The financial statements for Nike, Inc., are available at the Appendix B link above. The following additional information (in millions) is available: Accounts receivable at
The financial statements for Nike, Inc., are available at the Appendix B link above. The following additional information (in millions) is available:
Accounts receivable at May 31, 2011: $3,138
Inventories at May 31, 2011: 2,715
Total assets at May 31, 2011: 14,998
Stockholders' equity at May 31, 2011: 9,843
Determine the following measures for the fiscal years ended May 31, 2013 (fiscal 2012), and May 31, 2012 (fiscal 2011). Do not round interim calculations. Round the working capital amount in part (a) to the nearest dollar. Round all other final answers to one decimal place. When required, use the rounded final answers in subsequent computations.
\fFinancial Statement Analysis The financial statements for Nike, Inc., are attached The following additional information (in millions) is available: Accounts receivable at May 31, 2011: $3,138 Inventories at May 31, 2011: 2,715 Total assets at May 31, 2011: 14,998 Stockholders' equity at May 31, 2011: 9,843 Determine the following measures for the fiscal years ended May 31, 2013 (fiscal 2012), and May 31, 2012 (fiscal 2011). Round all other final answers to one decimal place. a. Qicck ratio =liquid asset/ current liabilities $2,317+$1,140=$3,457 $3,337+$2,628 =$5,965 Fiscal 2011- $3,457/$3,865 =0.89 ...=0.9 Fiscal 2012- 5965/ 3926 =1.52........=1.5 b. days' sales in accounts receivable Taking 1 year= 365 days Dos= 365days/accounts receivable turnover fiscal 2011= 365/7.4 = 49.3 days fiscal 2012= 365/8.1 =45.1 days b. number of days sales in inventory =365 days/ inventory turnover ratio fiscal 2011= 365/4.4 = 83.0 days fiscal 2012= 365/4.3 =84.9 days c. ratio of liability to stockholder equity= total liability/ equity fiscal 2011= 5,084/10,382 = 0.5 fiscal 2012= 6,428/11,156 =0.6 d. ratio of sales to asset= total sales/ total assets fiscal 2011 = 7,431/ 15,465= 0.5 fiscal 2012 = 7,780/ 17,584 =0.4 a.Rate earned on common stockholders' equity ROE = (Net Income-Pref Div)/Avge Common Equity For 2013 : ROE = 2485 / [(11156+10381)/2] = 23.1% For 2012 : ROE = 2223/[(10381+9843)/2] = 22.0% b.Price-earnings ratio, assuming that the market price was $61.66 per share on May 31, 2013, and $53.10 per share on May 31, 2012 PE Ratio = Share price/EPS For 2013 : PE = 61.66/2.69 = 22.9 For 2012 : PE = 53.10/2.42 = 21.9 Note : Summary is as given below. Page no refers to the page in word doc attached by you. Page 5 Page 7 2013 $2,485 $0 $11,156 23.1% Net Income Pref Div Common Equity ROE EPS Share price PE Ratio $ $ 2.69 61.66 22.9 2012 2011 $2,223 $2,133 $0 $0 $10,381 $9,843 22.0% $ $ 2.42 53.10 21.9