Thank you! :)

. For this assignment you will use the financial statements and Excel template provided in Canvas (each section of ACCTG 231 is assigned a different company) to: Find the financial statement amounts requested and enter them into the Excel spreadsheet template (NOTE: an amount for dividends has already been entered in the data section of the spreadsheet). (14 points) Compute the ratios requested in the Excel template. (11 points) . A couple of notes: The financial statements uploaded to Canvas for this assignment are not necessarily the most recent for each company, as years were explicitly chosen to insure a positive net income and existence of a few key items. . Also, ratios presented online may differ from those you compute as websites may adjust formulas and/or omit items from some calculations (i.e. some ratios have a few variations with regard to alternative calculations). Points for this assignment will be based on: Using amounts from the specific financial statements provided Computing ratios using the specific formulas in Chapter 14 (a summary of the Chapter 14 formulas is in Exhibit 14-6 in the text) present all computations to two decimal places. ABERCROMBIE & FITCH Abercrombie & Fitch Co. ("A&F"), a company incorporated in Delaware in 1996, through its subsidiaries (collectively, A&F and its subsidiaries are referred to as the "Company" and "we"), is a global multi-brand omnichannel specialty retailer, whose products are sold primarily through its Company-owned store and digital channels, as well as through various third-party wholesale, franchise and licensing arrangements. The Company offers a broad assortment of apparel, personal care products and accessories for men, women and kids under the Hollister, Abercrombie & Fitch and abercrombie kids brands. The brands share a commitment to offering unique products of enduring quality and exceptional comfort that allow customers around the world to express their own individuality and style. The Company primarily has operations in North America, Europe and Asia, among other regions. Abercrombie & Fitch Co. Consolidated Balance Sheets (Thousands, except par value amounts) February 1, 2020 February 2, 2019 Assets Current assets: Cash and equivalents Receivables Inventories Other current assets Total current assets Property and equipment, net Operating lease right-of-use assets Other assets Total assets Liabilities and stockholders' equity Current liabilities: Accounts payable Accrued expenses Short-term portion of operating lease liabilities 671,267 $ 723,135 80,251 73.112 434,326 437,879 78,905 101,824 1,264,7491,335,950 665,290 694,855 1,230,954 388,672 354,788 3,549,665 $2,385,593 219,919 $ 302,214 282,829 10,392 226,878 293,579 * Income taxes payable 18,902 19,558 558,917 815,354 1,252,634 231,963 250,439 76,134 46,337 235,145 608,055 178,536 1,663,133 Short-term portion of deferred lease credits Total current liabilities Long-term liabilities: Long-term portion of operating lease liabilities Long-term portion of borrowings, net Long-term portion of deferred lease credits Leasehold financing obligations Other liabilities Total long-term liabilities Stockholders' equity Class A Common Stock - $0.01 par value: 150,000 shares authorized and 103,300 shares issued at each of February 1, 2020 and February 2, 2019 Paid-in capital Retained earnings Accumulated other comprehensive loss, net of tax ("AOCL") Treasury stock, at average cost: 40,514 and 37,073 shares at February 1, 2020 and February 2, 2019, respectively Total Abercrombie & Fitch Co. stockholders' equity Noncontrolling interests Total stockholders' equity Total liabilities and stockholders' equity 1,033 404,983 2,313,745 (108,886) 1,033 405,379 2,418,544 (102,452) (1,552,065) 1,058,810 12,368 1,071,178 3,549,665 $ (1,513,604) 1,208,900 9,721 1,218,621 2,385,593 Item 8. Financial Statements and Supplementary Data Abercrombie & Fitch Co. Consolidated Statements of Operations and Comprehensive Income (Thousands, except per share amounts) Net sales Cost of sales, exclusive of depreciation and amortization Gross profit Stores and distribution expense Marketing, general and administrative expense Flagship store exit charges Asset impairment, exclusive of flagship store exit charges Other operating income, net Operating income Interest expense, net Income before income taxes Income tax expense Net income Less: Net income attributable to noncontrolling interests Net income attributable to A&F. Fiscal 2019 Fiscal 2018 Fiscal 2017 3,623,073 $ 3,590,109 $ 3,492,690 1,472,155 1,430,193 1,408,848 2,150,918 2,159,9162,083,842 1,551,243 1,536,216 1,540,032 464,615 484,863 471,914 47,257 5,806 2,393 19,135 11,580 14,391 (1,400) (5,915) (16,938) 70,068 127,366 72,050 7,737 10,999 16,889 62,331 116,367 55,161 17,371 37,559 44,636 44,960 78,808 10,525 5,602 4,267 3,431 39,358 $ 74,541 $ 7,094 $ SWARA Net income per share attributable to A&F Basic Diluted 0.10 0.61 $ 0.60 $ 1.11 $ 1.08 $ 0.10 Weighted average shares outstanding Basic Diluted 64,428 65,778 67,350 69,137 68,391 69,403 Other comprehensive (loss) income Foreign currency translation, net of tax Derivative financial instruments, net of tax Other comprehensive (loss) income Comprehensive income Less: Comprehensive income attributable to noncontrolling interests Comprehensive income attributable to A&F (5,080) $ (1,354) (6,434) 38,526 5,602 32,924 $ (19,940) $ 12,542 (7,398) 71,410 4,267 67,143 $ 41,180 (14,932) 26,248 36,773 3,431 33,342 1 (14 Points - 1 point per account) Dividends for Abercrombie & Fitch $ 0.80 From the Financial Statements for Abercrombie & Fitch, identify the following items and input amounts into the shaded cells. If A & F does not have an account requested put 0 (zero). Balance Sheet (February 1, 2020 amounts only) February 1, 2020 and February 2, 2019 Income Statement (Fiscal 2019 only) Cash 2020: 2019: Sales Accounts Receivable Inventory Cost of Goods Sold Marketable Securities Total Stockholders' Equity Interest Expense Total Current Assets Income Tax Expense Total Current Liabilities Net Income Total Liabilities Basic Earnings per share 2 Compute the following ratios (please input into shaded cell) Display answer to two decimal places. (11 points, as indicated) Liquidity Current Ratio Acid Test (1 point) (1 point) Asset Management Average Inventory Sale period (2 points) Debt Management Debt to equity Times Interest Earned (1 point (2 points) Profitability Return on Equity Net Profit Margin (2 points) :(1 point) Market Performance Dividend Payout (1 point)