Part A ratios that are missing for year 5 are the ratios that need to be calculated. Please help, thank you!
January 31, Year 5 Year 4 Year 3 Year 2 $ 350 26 248 28 $ 652 1,560 8 $2,220 $ 56 465 7 201 24 $ 753 1,342 $ 43 387 10 169 20 $ 629 1,172 $ 188 51 21 130 15 $ 405 947 $2,096 $1,802 $1,352 $ 79 $ 32 ASSETS Cash Marketable securities Accounts receivable Inventories Prepayments Total Current Assets Property, plant, and equipment, net Other assets Total Assets LIABILITIES AND SHAREHOLDERS' EQUITY Accounts payable Short-term borrowing Other current liabilities Total Current Liabilities Long-term debt Other noncurrent liabilities Total Liabilities Common stock Additional paid-in capital Retained earnings Treasury stock Total Shareholders' Equity Total Liabilities and Shareholders' Equity $ 84 54 276 $ 414 872 265 $1,551 $ 1 $ 58 33 220 $ 311 713 214 $1,238 $ 1 139 906 (188) $ 858 $2,096 193 $ 272 629 165 $1,066 $ 1 143 701 (109) $ 736 $1,802 132 $ 164 581 12 $ 757 $ 1 141 520 (67) $ 595 $1,352 140 1,076 (548) $ 669 $2,220 For the Year Ended January 31, Year 5 Year 4 Year 3 Sales Cost of goods sold Selling and administrative expenses Interest expense Interest income Income tax expense Net Income $ 2,021 (1,048) (562) (63) 5 (137) $ 216 $1,708 (936) (386) (54) 4 (131) $ 205 $1,596 (893) (343) (48) 4 (121) $ 195 Year 5 Year 4 Year 3 Square feet of retail space in thousands) Number of employees Growth rate in sales Comparable store sales increase 5,590 48,500 18.3% 2.0% 5,016 30,200 7.0% (9.0%) 4,358 22,000 16.9% 5.0% For the Year Ended January 31, Year 5 Year 4 Year 3 $ 216 106 13 (34) 125 $ 426 $ 205 90 56 (27) 19 $ 343 $ 195 76 49 (34) 60 $ 346 $ (185) 4,779 (4,314) $ (160) 3,771 (3,849) OPERATIONS Net income Depreciation and amortization Addbacks and subtractions, net (Increase) Decrease in inventories Increase (Decrease) in current liabilities Cash Flow from Operations INVESTING Property, plant, and equipment acquired Marketable securities sold Marketable securities purchased Other investing transactions Cash Flow from Investing FINANCING Increase in short-term borrowing Increase in common stock Acquisition of common stock Dividends Cash Flow from Financing Change in Cash Cash-Beginning of year Cash-End of Year $ (146) 2,419 (2,729) 5 $ (451) $ (280) $ (238) $ $ 4 $ 20 (116) (43) 20 49 (435) (46) $ (412) $ 294 56 $ 350 $ (92) 13 43 56 $ (39) $ (144) 188 $ 43 $ Year 5 Year 4 Year 3 Profit margin for ROA Assets turnover ROA Profit margin for ROCE Capital structure leverage ROCE Cost of goods sold/Sales Selling and administrative expense/Sales Interest revenue/Sales Income tax expense (excluding tax effects of interest expense)/Sales Accounts receivable turnover Inventory turnover Fixed assets tumover Sales per store Sales per square foot Sales per employee 14.1% 0.9 12.3% 12.09 2.4 25.7% 54.8% 22.6% 0.2% 14.29 1.0 14.396 12.296 2.4 29.3% 56.0% 21.5% 0.396 8.8% 200.9 5.1 1.4 $2,440,000 $ 340.51 56,556 8.6% 103.0 6.0 1.5 $2,673,367 $ 366.22 $ 72,545 $ Required a. Calculate the ratios for Year 5. The income tax rate is 35%. b. Analyze the changes in ROA for Abercrombie & Fitch during the three-year period, suggesting possible reasons for the changes observed. c. Analyze the changes in ROCE for Abercrombie & Fitch during the three-year period, suggesting possible reasons for the changes observed
