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 $ Risk Ratios for Abercrombie & Fitch Year 5 Year 4 Year 3 2.3 1.6 Current ratio Quick ratio Operating cash flow to current liabilities ratio Days accounts receivable outstanding Days inventory held Days accounts payable outstanding Net days of working capital financing needed Liabilities to assets ratio Liabilities to shareholders' equity ratio Long-term debt to long-term capital ratio Long-term debt to shareholders' equity ratio Operating cash flow to total liabilities ratio Interest coverage ratio 2.4 1.7 1.177 2. 72 26 48 0.591 1.443 0.454 0.831 0.298 7.2 1.587 4 61 22 43 0.592 1.448 0.461 0.855 0.380 7.6 Required a. Compute these ratios for fiscal Year 5. b. Assess the changes in the short-term liquidity risk of Abercrombie & Fitch between fiscal Year 3 and fiscal Year 5 and the level of that risk at the end of fiscal Year 5. c. Assess the changes in the long-term solvency risk of Abercrombie & Fitch between fiscal Year 3 and fiscal Year 5 and the level of that risk at the end of fiscal Year 5
