PLEASE SHOW ALL CALCULATION FOR EACH PROBLEMS IN EXCEL 1 In mid 2012, Apple had cash and short term investments of $ 27 19$27 19 billion, accounts receivable of $ 13 84$13 84 billion, current assets of $ 51 47$51 47 billion, and current liabilities of $ 33 45$33 45 billion a What was Apple's current ratio b What was Apple's quick ratio c What was Apple's cash ratio d In mid 2012, Dell had a cash ratio of 0 740 74, a quick ratio of 1 131 13 and a current ratio of 1 361 36 What can you say about the asset liquidity of Apple relative to Dell a What was Apple's current ratio The current ratio is nothing (Round to two decimal places ) 2 See Table LOADING showing financial statement data and stock price data for Mydeco Corp a How did Mydeco's accounts receivable days change over this period b How did Mydeco's inventory days change over this period c Based on your analysis, has Mydeco improved its management of its working capital during this time period (Note Use a 365 day year ) a How did Mydeco's accounts receivable days change over this period The accounts receivable days for 2009 is nothing days (Round to one decimal place ) HERE IS THE TABLE BELOW 2009 2013 Financial Statement Data and Stock Price Data for Mydeco Corp Mydeco Corp 2009 2013 (All data as of fiscal year end, in $ million) Income Statement 2009 2010 2011 2012 2013 Revenue 405 1405 1 362 1362 1 421 4421 4 515 6515 6 602 3602 3 Cost of Goods Sold ( 188 1 )(188 1) ( 176 4 )(176 4) ( 203 2 )(203 2) ( 246 5 )(246 5) ( 295 6 )(295 6) Gross Profit 217 0217 0 185 7185 7 218 2218 2 269 1269 1 306 7306 7 Sales and Marketing ( 67 3 )(67 3) ( 66 0 )(66 0) ( 83 0 )(83 0) ( 99 0 )(99 0) ( 123 9 )(123 9) Administration ( 61 3 )(61 3) ( 58 9 )(58 9) ( 57 8 )(57 8) ( 68 2 )(68 2) ( 77 4 )(77 4) Depreciation Amortization ( 26 3 )(26 3) ( 26 4 )(26 4) ( 33 6 )(33 6) ( 37 1 )(37 1) ( 39 7 )(39 7) EBIT 62 162 1 34 434 4 43 843 8 64 864 8 65 765 7 Interest Income (Expense) ( 34 4 )(34 4) ( 31 9 )(31 9) ( 33 7 )(33 7) ( 36 5 )(36 5) ( 41 4 )(41 4) Pretax Income 27 727 7 2 52 5 10 110 1 28 328 3 24 324 3 Income Tax ( 9 7 )(9 7) ( 0 9 )(0 9) ( 3 5 )(3 5) ( 9 9 )(9 9) ( 8 5 )(8 5) Net Income 18 018 0 1 61 6 6 66 6 18 418 4 15 815 8 Shares outstanding (millions) 55 255 2 55 255 2 55 255 2 55 255 2 55 255 2 Earnings per share $ 0 33$0 33 $ 0 03$0 03 $ 0 12$0 12 $ 0 33$0 33 $ 0 29$0 29 Balance Sheet 2009 2010 2011 2012 2013 Assets Cash 47 147 1 63 063 0 76 876 8 73 673 6 74 574 5 Accounts Receivable 89 789 7 68 168 1 71 471 4 76 476 4 86 786 7 Inventory 32 932 9 32 332 3 27 427 4 31 331 3 34 334 3 Total Current Assets 169 7169 7 163 4163 4 175 6175 6 181 3181 3 195 5195 5 Net Property, Plant Equip 248 1248 1 242 2242 2 312 9312 9 349 6349 6 346 1346 1 Goodwill Intangibles 358 7358 7 358 7358 7 358 7358 7 358 7358 7 358 7358 7 Total Assets 776 5776 5 764 3764 3 847 2847 2 889 6889 6 900 3900 3 Liabilities Stockholders' Equity Accounts Payable 20 520 5 17 617 6 20 820 8 28 428 4 32 532 5 Accrued Compensation 6 36 3 6 26 2 7 57 5 7 67 6 9 69 6 Total Current Liabilities 26 826 8 23 823 8 28 328 3 36 036 0 42 142 1 Long term Debt 504 1504 1 504 1504 1 580 2580 2 605 1605 1 605 1605 1 Total Liabilities 530 9530 9 527 9527 9 608 5608 5 641 1641 1 647 2647 2 Stockholders' Equity 245 6245 6 236 4236 4 238 7238 7 248 5248 5 253 1253 1 Total Liabilities Stockholders' Equity 776 5776 5 764 3764 3 847 2847 2 889 6889 6 900 3900 3 Statement of Cash Flows 2009 2010 2011 2012 2013 Net Income 18 018 0 1 61 6 6 66 6 18 418 4 15 815 8 Depreciation Amortization 26 326 3 26 426 4 33 633 6 37 137 1 39 739 7 Chg in Accounts Receivable 3 93 9 21 621 6 negative 3 33 3 ( 5 0 )(5 0) ( 10 3 )(10 3) Chg in Inventory ( 2 9 )(2 9) 0 60 6 4 94 9 ( 3 9 )(3 9) ( 3 0 )(3 0) Chg in Pay Accrued Comp 1 61 6 ( 3 0 )(3 0) 4 54 5 7 77 7 6 16 1 Cash from Operations 46 946 9 47 247 2 46 346 3 54 354 3 48 348 3 Capital Expenditures ( 24 5 )(24 5) ( 25 4 )(25 4) ( 102 7 )(102 7) ( 76 5 )(76 5) ( 41 0 )(41 0) Cash from Investing Activ ( 24 5 )(24 5) ( 25 4 )(25 4) ( 102 7 )(102 7) ( 76 5 )(76 5) ( 41 0 )(41 0) Dividends Paid ( 5 9 )(5 9) ( 5 9 )(5 9) ( 5 9 )(5 9) ( 5 9 )(5 9) ( 6 4 )(6 4) Sale (or purchase) of stock Debt Issuance (Pay Down) 76 176 1 24 924 9 Cash from Financing Activ ( 5 9 )(5 9) ( 5 9 )(5 9) 70 270 2 19 019 0 ( 6 4 )(6 4) Change in Cash 16 516 5 15 915 9 13 813 8 ( 3 2 )(3 2) 0 90 9 Mydeco Stock Price $ 8 45$8 45 $ 2 63$2 63 $ 4 94$4 94 $ 9 49$9 49 $ 10 97$10 97 3 See Table LOADING showing financial statement data and stock price data for Mydeco Corp a Compare accounts payable days in 2009 and 2013 b Did this change in accounts payable days improve or worsen Mydeco's cash position in 2013 (Note Use a 365 day year ) a Compare accounts payable days in 2009 and 2013 The accounts payable days for 2009 is nothing days (Round to one decimal place ) HERE IS THE TABLE BELOW 2009 2013 Financial Statement Data and Stock Price Data for Mydeco Corp Mydeco Corp 2009 2013 (All data as of fiscal year end, in $ million, except for EPS and share price) Income Statement 2009 2010 2011 2012 2013 Revenue 407 9407 9 359 5359 5 427 5427 5 513 2513 2 600 4600 4 Cost of Goods Sold ( 189 8 )(189 8) ( 171 9 )(171 9) ( 209 6 )(209 6) ( 244 3 )(244 3) ( 297 2 )(297 2) Gross Profit 218 1218 1 187 6187 6 217 9217 9 268 9268 9 303 2303 2 Sales and Marketing ( 68 4 )(68 4) ( 65 0 )(65 0) ( 83 5 )(83 5) ( 97 8 )(97 8) ( 125 6 )(125 6) Administration ( 59 3 )(59 3) ( 60 9 )(60 9) ( 58 3 )(58 3) ( 66 1 )(66 1) ( 79 2 )(79 2) Depreciation Amortization ( 27 6 )(27 6) ( 28 7 )(28 7) ( 35 4 )(35 4) ( 37 9 )(37 9) ( 38 4 )(38 4) EBIT 62 862 8 33 033 0 40 740 7 67 167 1 60 060 0 Interest Income (Expense) ( 34 0 )(34 0) ( 31 2 )(31 2) ( 32 7 )(32 7) ( 35 9 )(35 9) ( 41 0 )(41 0) Pretax Income 28 828 8 1 81 8 8 08 0 31 231 2 19 019 0 Income Tax ( 10 1 )(10 1) ( 0 6 )(0 6) ( 2 8 )(2 8) ( 10 9 )(10 9) ( 6 7 )(6 7) Net Income 18 718 7 1 21 2 5 25 2 20 320 3 12 312 3 Shares outstanding (millions) 56 156 1 56 156 1 56 156 1 56 156 1 56 156 1 Earnings per share $ 0 33$0 33 $ 0 02$0 02 $ 0 09$0 09 $ 0 36$0 36 $ 0 22$0 22 Balance Sheet 2009 2010 2011 2012 2013 Assets Cash 49 949 9 71 371 3 82 682 6 80 580 5 78 078 0 Accounts Receivable 87 787 7 69 769 7 71 871 8 78 378 3 86 886 8 Inventory 33 833 8 31 531 5 29 529 5 32 432 4 36 436 4 Total Current Assets 171 4171 4 172 5172 5 183 9183 9 191 2191 2 201 2201 2 Net Property, Plant Equip 242 9242 9 244 9244 9 307 4307 4 343 6343 6 343 9343 9 Goodwill Intangibles 359 7359 7 359 7359 7 359 7359 7 359 7359 7 359 7359 7 Total Assets 774 0774 0 777 1777 1 851 0851 0 894 5894 5 904 8904 8 Liabilities Stockholders' Equity Accounts Payable 16 716 7 19 319 3 22 622 6 26 326 3 32 532 5 Accrued Compensation 7 37 3 7 37 3 7 17 1 8 68 6 10 310 3 Total Current Liabilities 24 024 0 26 626 6 29 729 7 34 934 9 42 842 8 Long term Debt 503 5503 5 503 5503 5 578 4578 4 602 6602 6 602 6602 6 Total Liabilities 527 5527 5 530 1530 1 608 1608 1 637 5637 5 645 4645 4 Stockholders' Equity 246 5246 5 247 0247 0 242 9242 9 257 0257 0 259 4259 4 Total Liabilities Stockholders' Equity 774 0774 0 777 1777 1 851 0851 0 894 5894 5 904 8904 8 Statement of Cash Flows 2009 2010 2011 2012 2013 Net Income 18 718 7 1 21 2 5 25 2 20 320 3 12 312 3 Depreciation Amortization 27 627 6 28 728 7 35 435 4 37 937 9 38 438 4 Chg in Accounts Receivable 3 93 9 18 018 0 negative 2 12 1 ( 6 5 )(6 5) ( 8 5 )(8 5) Chg in Inventory ( 2 9 )(2 9) 2 32 3 2 02 0 ( 2 9 )(2 9) ( 4 0 )(4 0) Chg in Pay Accrued Comp 1 61 6 2 62 6 3 13 1 5 25 2 7 97 9 Cash from Operations 48 948 9 52 852 8 43 643 6 54 054 0 46 146 1 Capital Expenditures ( 24 5 )(24 5) ( 25 2 )(25 2) ( 101 0 )(101 0) ( 74 1 )(74 1) ( 41 4 )(41 4) Cash from Investing Activ ( 24 5 )(24 5) ( 25 2 )(25 2) ( 101 0 )(101 0) ( 74 1 )(74 1) ( 41 4 )(41 4) Dividends Paid ( 6 2 )(6 2) ( 6 2 )(6 2) ( 6 2 )(6 2) ( 6 2 )(6 2) ( 7 2 )(7 2) Sale (or purchase) of stock Debt Issuance (Pay Down) 74 974 9 24 224 2 Cash from Financing Activ ( 6 2 )(6 2) ( 6 2 )(6 2) 68 768 7 18 018 0 ( 7 2 )(7 2) Change in Cash 18 218 2 21 421 4 11 311 3 ( 2 1 )(2 1) ( 2 5 )(2 5) Mydeco Stock Price $ 8 72$8 72 $ 2 99$2 99 $ 5 02$5 02 $ 9 21$9 21 $ 12 35$12 35 4 See Table LOADING showing financial statement data and stock price data for Mydeco Corp a By how much did Mydeco increase its debt from 2009 to 2013 b What was Mydeco's EBITDA Interest coverage ratio in 2009 and 2013 Did its coverage ratio ever fall below 2 00 from 2009 to 2013 c Overall, did Mydeco's ability to meet its interest payments improve or decline over this period b What was Mydeco's EBITDA Interest coverage ratio in 2009 and 2013 Did its coverage ratio ever fall below 2 00 from 2009 to 2013 The interest coverage ratio for 2009 is nothing (Round to two decimal places ) HERE IS THE TABLE BELOW ,,,,,, ,,,,,, Income Statement,2009,2010,2011,2012,2013, Revenue,381 3,360 2,424 3,508 7,608 4, Cost of Goods Sold,(183 7),(174 2),(209 4),(246 5),(296 7), Gross Profit,197 6,186 0,214 9,262 2,311 7, Sales and Marketing,(66 0),(66 3),(83 1),(105 5),(121 8), Administration,(61 6),(57 9),(60 3),(64 9),(77 1), Depreciation Amortization,(25 8),(27 0),(33 6),(38 0),(38 9), EBIT,44 2,34 8,37 9,53 8,73 9, Interest Income (Expense),(34 0),(32 1),(31 3),(38 8),(38 5), Pretax Income,10 2,2 7,6 6,15 0,35 4, Income Tax,(3 6),(0 9),(2 3),(5 3),(12 4), Net Income,6 6,1 8,4 3,9 7,23 0, Shares outstanding (millions),53 1,53 1,53 1,53 1,53 1, Earnings per share,$0 12,$0 03,$0 08,$0 18,$0 43, Balance Sheet,2009,2010,2011,2012,2013, Assets,,,,,, Cash,48 1,68 2,81 8,67 4,80 2, Accounts Receivable,89 5,68 1,68 6,77 2,86 8, Inventory,33 6,32 9,26 9,32 5,33 3, Total Current Assets,171 2,169 2,177 3,177 1,200 3, Net Property, Plant Equip ,240 3,242 4,311 7,347 3,349 8, Goodwill Intangibles,360 1,360 1,360 1,360 1,360 1, Total Assets,771 6,771 7,849 1,884 5,910 2, Liabilities Stockholders' Equity,,,,,, Accounts Payable,18 7,17 1,20 3,27 7,31 3, Accrued Compensation,6 1,6 3,6 7,7 1,9 9, Total Current Liabilities,24 8,23 4,27 0,34 8,41 2, Long term Debt,497 8,497 8,574 3,598 2,598 2, Total Liabilities,522 6,521 2,601 3,633 0,639 4, Stockholders' Equity,249 0,250 5,247 8,251 5,270 8, Total Liabilities Stockholders' Equity,771 6,771 7,849 1,884 5,910 2, Statement of Cash Flows,2009,2010,2011,2012,2013, Net Income,6 6,1 8,4 3,9 7,23 0, Depreciation Amortization,25 8,27 0,33 6,38 0,38 9, Chg in Accounts Receivable,3 9,21 4, 0 5,(8 6),(9 6), Chg in Inventory,(2 9),0 7,6 0,(5 6),(0 8), Chg in Pay Accrued Comp ,3 1,(1 4),3 6,7 8,6 4, Cash from Operations,36 5,49 5,47 0,41 3,57 9, Capital Expenditures,(27 0),(23 9),(104 4),(74 1),(38 4), Cash from Investing Activ ,(27 0),(23 9),(104 4),(74 1),(38 4), Dividends Paid,(5 5),(5 5),(5 5),(5 5),(6 7), Sale (or purchase) of stock, , , , , , Debt Issuance (Pay Down), , ,76 5,23 9, , Cash from Financing Activ ,(5 5),(5 5),71 0,18 4,(6 7), Change in Cash,4 0,20 1,13 6,(14 4),12 8, Mydeco Stock Price,$8 26,$3 52,$4 85,$9 16,$9 77, 5 See Table LOADING showing financial statement data and stock price data for Mydeco Corp a How did Mydeco's book debt equity ratio change from 2009 to 2013 b How did Mydeco's market debt equity ratio change from 2009 to 2013 c Compute Mydeco's debt to enterprise value ratio to assess how the fraction of its business that is debt financed has changed over the period a How did Mydeco's book debt equity ratio change from 2009 to 2013 The book debt equity ratio for 2009 is nothing (Round to two decimal places ) HERE IS THE TABLE BELOW 2009 2013 Financial Statement Data and Stock Price Data for Mydeco Corp Mydeco Corp 2009 2013 (All data as of fiscal year end, in $ million) Income Statement 2009 2010 2011 2012 2013 Revenue 385 3385 3 360 2360 2 424 3424 3 510 8510 8 602 1602 1 Cost of Goods Sold ( 185 8 )(185 8) ( 170 0 )(170 0) ( 206 5 )(206 5) ( 244 9 )(244 9) ( 288 8 )(288 8) Gross Profit 199 5199 5 190 2190 2 217 8217 8 265 9265 9 313 3313 3 Sales and Marketing ( 66 3 )(66 3) ( 65 9 )(65 9) ( 81 9 )(81 9) ( 96 3 )(96 3) ( 125 2 )(125 2) Administration ( 59 3 )(59 3) ( 60 9 )(60 9) ( 59 0 )(59 0) ( 65 9 )(65 9) ( 76 5 )(76 5) Depreciation Amortization ( 25 6 )(25 6) ( 28 2 )(28 2) ( 33 0 )(33 0) ( 37 7 )(37 7) ( 37 4 )(37 4) EBIT 48 348 3 35 235 2 43 943 9 66 066 0 74 274 2 Interest Income (Expense) ( 33 9 )(33 9) ( 32 5 )(32 5) ( 33 0 )(33 0) ( 36 9 )(36 9) ( 40 4 )(40 4) Pretax Income 14 414 4 2 72 7 10 910 9 29 129 1 33 833 8 Income Tax ( 5 0 )(5 0) ( 0 9 )(0 9) ( 3 8 )(3 8) ( 10 2 )(10 2) ( 11 8 )(11 8) Net Income 9 49 4 1 81 8 7 17 1 18 918 9 22 022 0 Shares outstanding (millions) 56 556 5 56 556 5 56 556 5 56 556 5 56 556 5 Earnings per share $ 0 17$0 17 $ 0 03$0 03 $ 0 13$0 13 $ 0 33$0 33 $ 0 39$0 39 Balance Sheet 2009 2010 2011 2012 2013 Assets Cash 48 448 4 62 962 9 83 983 9 76 176 1 85 285 2 Accounts Receivable 88 488 4 68 168 1 69 169 1 77 777 7 86 886 8 Inventory 32 932 9 32 132 1 26 426 4 32 832 8 35 235 2 Total Current Assets 169 7169 7 163 1163 1 179 4179 4 186 6186 6 207 2207 2 Net Property, Plant Equip 243 3243 3 239 4239 4 313 2313 2 347 9347 9 345 3345 3 Goodwill Intangibles 360 4360 4 360 4360 4 360 4360 4 360 4360 4 360 4360 4 Total Assets 773 4773 4 762 9762 9 853 0853 0 894 9894 9 912 9912 9 Liabilities Stockholders' Equity Accounts Payable 19 619 6 16 716 7 23 923 9 27 927 9 33 133 1 Accrued Compensation 7 57 5 5 55 5 6 36 3 8 48 4 9 49 4 Total Current Liabilities 27 127 1 22 222 2 30 230 2 36 336 3 42 542 5 Long term Debt 497 6497 6 497 6497 6 573 4573 4 599 2599 2 599 2599 2 Total Liabilities 524 7524 7 519 8519 8 603 6603 6 635 5635 5 641 7641 7 Stockholders' Equity 248 7248 7 243 1243 1 249 4249 4 259 4259 4 271 2271 2 Total Liabilities Stockholders' Equity 773 4773 4 762 9762 9 853 0853 0 894 9894 9 912 9912 9 Statement of Cash Flows 2009 2010 2011 2012 2013 Net Income 9 49 4 1 81 8 7 17 1 18 918 9 22 022 0 Depreciation Amortization 25 625 6 28 228 2 33 033 0 37 737 7 37 437 4 Chg in Accounts Receivable 3 93 9 20 320 3 negative 1 01 0 ( 8 6 )(8 6) ( 9 1 )(9 1) Chg in Inventory ( 2 9 )(2 9) 0 80 8 5 75 7 ( 6 4 )(6 4) ( 2 4 )(2 4) Chg in Pay Accrued Comp 2 82 8 ( 4 9 )(4 9) 8 08 0 6 16 1 6 26 2 Cash from Operations 38 838 8 46 246 2 52 852 8 47 747 7 54 154 1 Capital Expenditures ( 26 5 )(26 5) ( 26 4 )(26 4) ( 102 3 )(102 3) ( 76 0 )(76 0) ( 38 3 )(38 3) Cash from Investing Activ ( 26 5 )(26 5) ( 26 4 )(26 4) ( 102 3 )(102 3) ( 76 0 )(76 0) ( 38 3 )(38 3) Dividends Paid ( 5 3 )(5 3) ( 5 3 )(5 3) ( 5 3 )(5 3) ( 5 3 )(5 3) ( 6 7 )(6 7) Sale (or purchase) of stock Debt Issuance (Pay Down) 75 875 8 25 825 8 Cash from Financing Activ ( 5 3 )(5 3) ( 5 3 )(5 3) 70 570 5 20 520 5 ( 6 7 )(6 7) Change in Cash 7 07 0 14 514 5 21 021 0 ( 7 8 )(7 8) 9 19 1 Mydeco Stock Price $ 7 44$7 44 $ 4 05$4 05 $ 4 37$4 37 $ 9 26$9 26 $ 9 97$9 97 6 For fiscal year 2012, Starbucks Corporation (SBUX) had total revenues of $ 13 30$13 30 billion, net income of $ 1 38$1 38 billion, total assets of $ 8 22$8 22 billion, and total shareholders' equity of $ 5 11$5 11 billion Calculate Starbucks' ROE directly, and using the DuPont Identity The ROE calculated directly is nothing (Round to two decimal places )

The Answer is in the image, click to view ...

Question: PLEASE SHOW ALL CALCULATION FOR EACH PROBLEMS IN EXCEL 1. In mid-2012, Apple had cash and short-term investments of $ 27.19$27.19 billion, accounts receivable of

PLEASE SHOW ALL CALCULATION FOR EACH PROBLEMS IN EXCEL

1. In mid-2012, Apple had cash and short-term investments of $ 27.19$27.19 billion, accounts receivable of $ 13.84$13.84 billion, current assets of $ 51.47$51.47 billion, and current liabilities of $ 33.45$33.45 billion.

a. What was Apple's current ratio?

b. What was Apple's quick ratio?

c. What was Apple's cash ratio?

d. In mid-2012, Dell had a cash ratio of 0.740.74, a quick ratio of 1.131.13 and a current ratio of 1.361.36. What can you say about the asset liquidity of Apple relative to Dell?

a. What was Apple's current ratio?

The current ratio is ___ nothing. (Round to two decimal places.)

2. See Table LOADING... showing financial statement data and stock price data for Mydeco Corp.

a. How did Mydeco's accounts receivable days change over this period?

b. How did Mydeco's inventory days change over this period?

c. Based on your analysis, has Mydeco improved its management of its working capital during this time period? (Note: Use a 365-day year.)

a. How did Mydeco's accounts receivable days change over this period?

The accounts receivable days for 2009 is ____ nothing days. (Round to one decimal place.)

HERE IS THE TABLE BELOW

2009--2013 Financial Statement Data and Stock Price Data for Mydeco Corp.
Mydeco Corp. 2009--2013 (All data as of fiscal year end, in $ million)
Income Statement	2009	2010	2011	2012	2013
Revenue	405.1405.1	362.1362.1	421.4421.4	515.6515.6	602.3602.3
Cost of Goods Sold	( 188.1 )(188.1)	( 176.4 )(176.4)	( 203.2 )(203.2)	( 246.5 )(246.5)	( 295.6 )(295.6)
Gross Profit	217.0217.0	185.7185.7	218.2218.2	269.1269.1	306.7306.7
Sales and Marketing	( 67.3 )(67.3)	( 66.0 )(66.0)	( 83.0 )(83.0)	( 99.0 )(99.0)	( 123.9 )(123.9)
Administration	( 61.3 )(61.3)	( 58.9 )(58.9)	( 57.8 )(57.8)	( 68.2 )(68.2)	( 77.4 )(77.4)
Depreciation & Amortization	( 26.3 )(26.3)	( 26.4 )(26.4)	( 33.6 )(33.6)	( 37.1 )(37.1)	( 39.7 )(39.7)
EBIT	62.162.1	34.434.4	43.843.8	64.864.8	65.765.7
Interest Income (Expense)	( 34.4 )(34.4)	( 31.9 )(31.9)	( 33.7 )(33.7)	( 36.5 )(36.5)	( 41.4 )(41.4)
Pretax Income	27.727.7	2.52.5	10.110.1	28.328.3	24.324.3
Income Tax	( 9.7 )(9.7)	( 0.9 )(0.9)	( 3.5 )(3.5)	( 9.9 )(9.9)	( 8.5 )(8.5)
Net Income	18.018.0	1.61.6	6.66.6	18.418.4	15.815.8
Shares outstanding (millions)	55.255.2	55.255.2	55.255.2	55.255.2	55.255.2
Earnings per share	$ 0.33$0.33	$ 0.03$0.03	$ 0.12$0.12	$ 0.33$0.33	$ 0.29$0.29
Balance Sheet	2009	2010	2011	2012	2013
Assets
Cash	47.147.1	63.063.0	76.876.8	73.673.6	74.574.5
Accounts Receivable	89.789.7	68.168.1	71.471.4	76.476.4	86.786.7
Inventory	32.932.9	32.332.3	27.427.4	31.331.3	34.334.3
Total Current Assets	169.7169.7	163.4163.4	175.6175.6	181.3181.3	195.5195.5
Net Property, Plant & Equip.	248.1248.1	242.2242.2	312.9312.9	349.6349.6	346.1346.1
Goodwill & Intangibles	358.7358.7	358.7358.7	358.7358.7	358.7358.7	358.7358.7
Total Assets	776.5776.5	764.3764.3	847.2847.2	889.6889.6	900.3900.3
Liabilities & Stockholders' Equity
Accounts Payable	20.520.5	17.617.6	20.820.8	28.428.4	32.532.5
Accrued Compensation	6.36.3	6.26.2	7.57.5	7.67.6	9.69.6
Total Current Liabilities	26.826.8	23.823.8	28.328.3	36.036.0	42.142.1
Long-term Debt	504.1504.1	504.1504.1	580.2580.2	605.1605.1	605.1605.1
Total Liabilities	530.9530.9	527.9527.9	608.5608.5	641.1641.1	647.2647.2
Stockholders' Equity	245.6245.6	236.4236.4	238.7238.7	248.5248.5	253.1253.1
Total Liabilities & Stockholders' Equity	776.5776.5	764.3764.3	847.2847.2	889.6889.6	900.3900.3
Statement of Cash Flows	2009	2010	2011	2012	2013
Net Income	18.018.0	1.61.6	6.66.6	18.418.4	15.815.8
Depreciation & Amortization	26.326.3	26.426.4	33.633.6	37.137.1	39.739.7
Chg. in Accounts Receivable	3.93.9	21.621.6	negative 3.33.3	( 5.0 )(5.0)	( 10.3 )(10.3)
Chg. in Inventory	( 2.9 )(2.9)	0.60.6	4.94.9	( 3.9 )(3.9)	( 3.0 )(3.0)
Chg. in Pay. & Accrued Comp.	1.61.6	( 3.0 )(3.0)	4.54.5	7.77.7	6.16.1
Cash from Operations	46.946.9	47.247.2	46.346.3	54.354.3	48.348.3
Capital Expenditures	( 24.5 )(24.5)	( 25.4 )(25.4)	( 102.7 )(102.7)	( 76.5 )(76.5)	( 41.0 )(41.0)
Cash from Investing Activ.	( 24.5 )(24.5)	( 25.4 )(25.4)	( 102.7 )(102.7)	( 76.5 )(76.5)	( 41.0 )(41.0)
Dividends Paid	( 5.9 )(5.9)	( 5.9 )(5.9)	( 5.9 )(5.9)	( 5.9 )(5.9)	( 6.4 )(6.4)
Sale (or purchase) of stock	-	-	-	-	-
Debt Issuance (Pay Down)	-	-	76.176.1	24.924.9	-
Cash from Financing Activ.	( 5.9 )(5.9)	( 5.9 )(5.9)	70.270.2	19.019.0	( 6.4 )(6.4)
Change in Cash	16.516.5	15.915.9	13.813.8	( 3.2 )(3.2)	0.90.9
Mydeco Stock Price	$ 8.45$8.45	$ 2.63$2.63	$ 4.94$4.94	$ 9.49$9.49	$ 10.97$10.97

3. See Table LOADING... showing financial statement data and stock price data for Mydeco Corp.

a. Compare accounts payable days in 2009 and 2013.

b. Did this change in accounts payable days improve or worsen Mydeco's cash position in 2013? (Note: Use a 365-day year.)

a. Compare accounts payable days in 2009 and 2013.

The accounts payable days for 2009 is nothing days.(Round to one decimal place.)

HERE IS THE TABLE BELOW.

2009--2013 Financial Statement Data and Stock Price Data for Mydeco Corp.
Mydeco Corp. 2009--2013 (All data as of fiscal year end, in $ million, except for EPS and share price)
Income Statement	2009	2010	2011	2012	2013
Revenue	407.9407.9	359.5359.5	427.5427.5	513.2513.2	600.4600.4
Cost of Goods Sold	( 189.8 )(189.8)	( 171.9 )(171.9)	( 209.6 )(209.6)	( 244.3 )(244.3)	( 297.2 )(297.2)
Gross Profit	218.1218.1	187.6187.6	217.9217.9	268.9268.9	303.2303.2
Sales and Marketing	( 68.4 )(68.4)	( 65.0 )(65.0)	( 83.5 )(83.5)	( 97.8 )(97.8)	( 125.6 )(125.6)
Administration	( 59.3 )(59.3)	( 60.9 )(60.9)	( 58.3 )(58.3)	( 66.1 )(66.1)	( 79.2 )(79.2)
Depreciation & Amortization	( 27.6 )(27.6)	( 28.7 )(28.7)	( 35.4 )(35.4)	( 37.9 )(37.9)	( 38.4 )(38.4)
EBIT	62.862.8	33.033.0	40.740.7	67.167.1	60.060.0
Interest Income (Expense)	( 34.0 )(34.0)	( 31.2 )(31.2)	( 32.7 )(32.7)	( 35.9 )(35.9)	( 41.0 )(41.0)
Pretax Income	28.828.8	1.81.8	8.08.0	31.231.2	19.019.0
Income Tax	( 10.1 )(10.1)	( 0.6 )(0.6)	( 2.8 )(2.8)	( 10.9 )(10.9)	( 6.7 )(6.7)
Net Income	18.718.7	1.21.2	5.25.2	20.320.3	12.312.3
Shares outstanding (millions)	56.156.1	56.156.1	56.156.1	56.156.1	56.156.1
Earnings per share	$ 0.33$0.33	$ 0.02$0.02	$ 0.09$0.09	$ 0.36$0.36	$ 0.22$0.22
Balance Sheet	2009	2010	2011	2012	2013
Assets
Cash	49.949.9	71.371.3	82.682.6	80.580.5	78.078.0
Accounts Receivable	87.787.7	69.769.7	71.871.8	78.378.3	86.886.8
Inventory	33.833.8	31.531.5	29.529.5	32.432.4	36.436.4
Total Current Assets	171.4171.4	172.5172.5	183.9183.9	191.2191.2	201.2201.2
Net Property, Plant & Equip.	242.9242.9	244.9244.9	307.4307.4	343.6343.6	343.9343.9
Goodwill & Intangibles	359.7359.7	359.7359.7	359.7359.7	359.7359.7	359.7359.7
Total Assets	774.0774.0	777.1777.1	851.0851.0	894.5894.5	904.8904.8
Liabilities & Stockholders' Equity
Accounts Payable	16.716.7	19.319.3	22.622.6	26.326.3	32.532.5
Accrued Compensation	7.37.3	7.37.3	7.17.1	8.68.6	10.310.3
Total Current Liabilities	24.024.0	26.626.6	29.729.7	34.934.9	42.842.8
Long-term Debt	503.5503.5	503.5503.5	578.4578.4	602.6602.6	602.6602.6
Total Liabilities	527.5527.5	530.1530.1	608.1608.1	637.5637.5	645.4645.4
Stockholders' Equity	246.5246.5	247.0247.0	242.9242.9	257.0257.0	259.4259.4
Total Liabilities & Stockholders' Equity	774.0774.0	777.1777.1	851.0851.0	894.5894.5	904.8904.8
Statement of Cash Flows	2009	2010	2011	2012	2013
Net Income	18.718.7	1.21.2	5.25.2	20.320.3	12.312.3
Depreciation & Amortization	27.627.6	28.728.7	35.435.4	37.937.9	38.438.4
Chg. in Accounts Receivable	3.93.9	18.018.0	negative 2.12.1	( 6.5 )(6.5)	( 8.5 )(8.5)
Chg. in Inventory	( 2.9 )(2.9)	2.32.3	2.02.0	( 2.9 )(2.9)	( 4.0 )(4.0)
Chg. in Pay. & Accrued Comp.	1.61.6	2.62.6	3.13.1	5.25.2	7.97.9
Cash from Operations	48.948.9	52.852.8	43.643.6	54.054.0	46.146.1
Capital Expenditures	( 24.5 )(24.5)	( 25.2 )(25.2)	( 101.0 )(101.0)	( 74.1 )(74.1)	( 41.4 )(41.4)
Cash from Investing Activ.	( 24.5 )(24.5)	( 25.2 )(25.2)	( 101.0 )(101.0)	( 74.1 )(74.1)	( 41.4 )(41.4)
Dividends Paid	( 6.2 )(6.2)	( 6.2 )(6.2)	( 6.2 )(6.2)	( 6.2 )(6.2)	( 7.2 )(7.2)
Sale (or purchase) of stock	-	-	-	-	-
Debt Issuance (Pay Down)	-	-	74.974.9	24.224.2	-
Cash from Financing Activ.	( 6.2 )(6.2)	( 6.2 )(6.2)	68.768.7	18.018.0	( 7.2 )(7.2)
Change in Cash	18.218.2	21.421.4	11.311.3	( 2.1 )(2.1)	( 2.5 )(2.5)
Mydeco Stock Price	$ 8.72$8.72	$ 2.99$2.99	$ 5.02$5.02	$ 9.21$9.21	$ 12.35$12.35

4. See Table LOADING.. showing financial statement data and stock price data for Mydeco Corp.

a. By how much did Mydeco increase its debt from 2009 to 2013?

b. What was Mydeco's EBITDA/Interest coverage ratio in 2009 and 2013? Did its coverage ratio ever fall below 2.00 from 2009 to 2013?

c. Overall, did Mydeco's ability to meet its interest payments improve or decline over this period?

b. What was Mydeco's EBITDA/Interest coverage ratio in 2009 and 2013? Did its coverage ratio ever fall below 2.00 from 2009 to 2013?

The interest coverage ratio for 2009 is nothing. (Round to two decimal places.)

HERE IS THE TABLE BELOW

,,,,,,

Income Statement,2009,2010,2011,2012,2013,

Revenue,381.3,360.2,424.3,508.7,608.4,

Cost of Goods Sold,(183.7),(174.2),(209.4),(246.5),(296.7),

Gross Profit,197.6,186.0,214.9,262.2,311.7,

Sales and Marketing,(66.0),(66.3),(83.1),(105.5),(121.8),

Administration,(61.6),(57.9),(60.3),(64.9),(77.1),

Depreciation & Amortization,(25.8),(27.0),(33.6),(38.0),(38.9),

EBIT,44.2,34.8,37.9,53.8,73.9,

Interest Income (Expense),(34.0),(32.1),(31.3),(38.8),(38.5),

Pretax Income,10.2,2.7,6.6,15.0,35.4,

Income Tax,(3.6),(0.9),(2.3),(5.3),(12.4),

Net Income,6.6,1.8,4.3,9.7,23.0,

Shares outstanding (millions),53.1,53.1,53.1,53.1,53.1,

Earnings per share,$0.12,$0.03,$0.08,$0.18,$0.43,

Balance Sheet,2009,2010,2011,2012,2013,

Assets,,,,,,

Cash,48.1,68.2,81.8,67.4,80.2,

Accounts Receivable,89.5,68.1,68.6,77.2,86.8,

Inventory,33.6,32.9,26.9,32.5,33.3,

Total Current Assets,171.2,169.2,177.3,177.1,200.3,

"Net Property, Plant & Equip.",240.3,242.4,311.7,347.3,349.8,

Goodwill & Intangibles,360.1,360.1,360.1,360.1,360.1,

Total Assets,771.6,771.7,849.1,884.5,910.2,

Liabilities & Stockholders' Equity,,,,,,

Accounts Payable,18.7,17.1,20.3,27.7,31.3,

Accrued Compensation,6.1,6.3,6.7,7.1,9.9,

Total Current Liabilities,24.8,23.4,27.0,34.8,41.2,

Long-term Debt,497.8,497.8,574.3,598.2,598.2,

Total Liabilities,522.6,521.2,601.3,633.0,639.4,

Stockholders' Equity,249.0,250.5,247.8,251.5,270.8,

Total Liabilities & Stockholders' Equity,771.6,771.7,849.1,884.5,910.2,

Statement of Cash Flows,2009,2010,2011,2012,2013,

Net Income,6.6,1.8,4.3,9.7,23.0,

Depreciation & Amortization,25.8,27.0,33.6,38.0,38.9,

Chg. in Accounts Receivable,3.9,21.4,-0.5,(8.6),(9.6),

Chg. in Inventory,(2.9),0.7,6.0,(5.6),(0.8),

Chg. in Pay. & Accrued Comp.,3.1,(1.4),3.6,7.8,6.4,

Cash from Operations,36.5,49.5,47.0,41.3,57.9,

Capital Expenditures,(27.0),(23.9),(104.4),(74.1),(38.4),

Cash from Investing Activ.,(27.0),(23.9),(104.4),(74.1),(38.4),

Dividends Paid,(5.5),(5.5),(5.5),(5.5),(6.7),

Sale (or purchase) of stock,-,-,-,-,-,

Debt Issuance (Pay Down),-,-,76.5,23.9,-,

Cash from Financing Activ.,(5.5),(5.5),71.0,18.4,(6.7),

Change in Cash,4.0,20.1,13.6,(14.4),12.8,

Mydeco Stock Price,$8.26,$3.52,$4.85,$9.16,$9.77,

5. See Table LOADING...showing financial statement data and stock price data for Mydeco Corp.

a. How did Mydeco's book debt-equity ratio change from 2009 to 2013?

b. How did Mydeco's market debt-equity ratio change from 2009 to 2013?

c. Compute Mydeco's debt-to-enterprise value ratio to assess how the fraction of its business that is debt financed has changed over the period.

a. How did Mydeco's book debt-equity ratio change from 2009 to 2013?

The book debt-equity ratio for 2009 is nothing. (Round to two decimal places.)

HERE IS THE TABLE BELOW.

2009--2013 Financial Statement Data and Stock Price Data for Mydeco Corp.
Mydeco Corp. 2009--2013 (All data as of fiscal year end, in $ million)
Income Statement	2009	2010	2011	2012	2013
Revenue	385.3385.3	360.2360.2	424.3424.3	510.8510.8	602.1602.1
Cost of Goods Sold	( 185.8 )(185.8)	( 170.0 )(170.0)	( 206.5 )(206.5)	( 244.9 )(244.9)	( 288.8 )(288.8)
Gross Profit	199.5199.5	190.2190.2	217.8217.8	265.9265.9	313.3313.3
Sales and Marketing	( 66.3 )(66.3)	( 65.9 )(65.9)	( 81.9 )(81.9)	( 96.3 )(96.3)	( 125.2 )(125.2)
Administration	( 59.3 )(59.3)	( 60.9 )(60.9)	( 59.0 )(59.0)	( 65.9 )(65.9)	( 76.5 )(76.5)
Depreciation & Amortization	( 25.6 )(25.6)	( 28.2 )(28.2)	( 33.0 )(33.0)	( 37.7 )(37.7)	( 37.4 )(37.4)
EBIT	48.348.3	35.235.2	43.943.9	66.066.0	74.274.2
Interest Income (Expense)	( 33.9 )(33.9)	( 32.5 )(32.5)	( 33.0 )(33.0)	( 36.9 )(36.9)	( 40.4 )(40.4)
Pretax Income	14.414.4	2.72.7	10.910.9	29.129.1	33.833.8
Income Tax	( 5.0 )(5.0)	( 0.9 )(0.9)	( 3.8 )(3.8)	( 10.2 )(10.2)	( 11.8 )(11.8)
Net Income	9.49.4	1.81.8	7.17.1	18.918.9	22.022.0
Shares outstanding (millions)	56.556.5	56.556.5	56.556.5	56.556.5	56.556.5
Earnings per share	$ 0.17$0.17	$ 0.03$0.03	$ 0.13$0.13	$ 0.33$0.33	$ 0.39$0.39
Balance Sheet	2009	2010	2011	2012	2013
Assets
Cash	48.448.4	62.962.9	83.983.9	76.176.1	85.285.2
Accounts Receivable	88.488.4	68.168.1	69.169.1	77.777.7	86.886.8
Inventory	32.932.9	32.132.1	26.426.4	32.832.8	35.235.2
Total Current Assets	169.7169.7	163.1163.1	179.4179.4	186.6186.6	207.2207.2
Net Property, Plant & Equip.	243.3243.3	239.4239.4	313.2313.2	347.9347.9	345.3345.3
Goodwill & Intangibles	360.4360.4	360.4360.4	360.4360.4	360.4360.4	360.4360.4
Total Assets	773.4773.4	762.9762.9	853.0853.0	894.9894.9	912.9912.9
Liabilities & Stockholders' Equity
Accounts Payable	19.619.6	16.716.7	23.923.9	27.927.9	33.133.1
Accrued Compensation	7.57.5	5.55.5	6.36.3	8.48.4	9.49.4
Total Current Liabilities	27.127.1	22.222.2	30.230.2	36.336.3	42.542.5
Long-term Debt	497.6497.6	497.6497.6	573.4573.4	599.2599.2	599.2599.2
Total Liabilities	524.7524.7	519.8519.8	603.6603.6	635.5635.5	641.7641.7
Stockholders' Equity	248.7248.7	243.1243.1	249.4249.4	259.4259.4	271.2271.2
Total Liabilities & Stockholders' Equity	773.4773.4	762.9762.9	853.0853.0	894.9894.9	912.9912.9
Statement of Cash Flows	2009	2010	2011	2012	2013
Net Income	9.49.4	1.81.8	7.17.1	18.918.9	22.022.0
Depreciation & Amortization	25.625.6	28.228.2	33.033.0	37.737.7	37.437.4
Chg. in Accounts Receivable	3.93.9	20.320.3	negative 1.01.0	( 8.6 )(8.6)	( 9.1 )(9.1)
Chg. in Inventory	( 2.9 )(2.9)	0.80.8	5.75.7	( 6.4 )(6.4)	( 2.4 )(2.4)
Chg. in Pay. & Accrued Comp.	2.82.8	( 4.9 )(4.9)	8.08.0	6.16.1	6.26.2
Cash from Operations	38.838.8	46.246.2	52.852.8	47.747.7	54.154.1
Capital Expenditures	( 26.5 )(26.5)	( 26.4 )(26.4)	( 102.3 )(102.3)	( 76.0 )(76.0)	( 38.3 )(38.3)
Cash from Investing Activ.	( 26.5 )(26.5)	( 26.4 )(26.4)	( 102.3 )(102.3)	( 76.0 )(76.0)	( 38.3 )(38.3)
Dividends Paid	( 5.3 )(5.3)	( 5.3 )(5.3)	( 5.3 )(5.3)	( 5.3 )(5.3)	( 6.7 )(6.7)
Sale (or purchase) of stock	-	-	-	-	-
Debt Issuance (Pay Down)	-	-	75.875.8	25.825.8	-
Cash from Financing Activ.	( 5.3 )(5.3)	( 5.3 )(5.3)	70.570.5	20.520.5	( 6.7 )(6.7)
Change in Cash	7.07.0	14.514.5	21.021.0	( 7.8 )(7.8)	9.19.1
Mydeco Stock Price	$ 7.44$7.44	$ 4.05$4.05	$ 4.37$4.37	$ 9.26$9.26	$ 9.97$9.97

6. For fiscal year 2012, Starbucks Corporation (SBUX) had total revenues of $ 13.30$13.30 billion, net income of $ 1.38$1.38 billion, total assets of $ 8.22$8.22 billion, and total shareholders' equity of $ 5.11$5.11 billion. Calculate Starbucks' ROE directly, and using the DuPont Identity.

The ROE calculated directly is_____ nothing%. (Round to two decimal places.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

An Investment Analysis Case Study This case is a group project that is due on April 1, before class at 10.30. Stating the obvious: Each group will turn in one report (sounds obvious, but might as...

CASE STUDY REPORT FORMAT GUIDELINE Case Study-1 Following is a suggested guideline for preparing your case study reports. Cover Page (Include student names and student Ids) Executive Summary (If...

i have reposted the same Question Instruction Assignment Question Assignment 1 An Investment Analysis Case Study Stating the obvious: Each group will turn in one report (sounds obvious, but might as...

Old MathJax webview This is the full question which part is missing. This is what given. Assignment Question Assignment 1 An Investment Analysis Case Study Stating the obvious: Each group will turn...

Decision on Investment: Invest or Do not invest Cost of capital: % value Return on capital: % value NPV 10-year life: $ value NPV- Longer life: $ value Report format: Please try to keep your report...

answer the following excel problems using the provided example. use formulas to show work please these are the tabs missing thats all the problems Stay in protected View. Enable Edit F H B D E G 3.6....

What will be the exit strategy for Nantucket Nectars. Explain the financial and growth analysis of the company. ( Please use exhibits to do calculations in excel ) 898-171 Nantucket Nectars It was...

United Airlines established a discount airline named Ted. The managers were interested in determining how flyers using Ted rate the airline service. They plan to question a random sample of flyers...

How do prospective and retrospective payment agreements affect the amount reported as net patient service revenue?

Cul es el primer paso en el proceso de crear un perfil de calidad percibida por el mercado? Pregunta 10Respuesta Multiplicar la calificacin de cada competidor por su peso en la decisin. Pedir a los...

Which of the following reporting standards is higher: a. Substantial Authority versus Reasonable Basis? b. Realistic Possibility of Success versus More Likely Than Not? c. Reasonable Basis versus...

8. How can an interpreter influence the message?

The geographical location of the sender, i.e. where the sender resides

Subjective norms, i.e. the norms of the target group