Please upload with excel functions as well 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. Table of Contents Abercrombie & Fitch Co. Consolidated Balance Sheets (Thousands, except par value amounts) February 1, 2020 February 2, 2019 571,267 80 251 434,326 78,905 1,264.749 665.290 1,230,964 388,672 3,519,665 $ 723,135 73,112 437,879 101,824 1,335,950 694,855 354,788 2,385,593 226,878 293,579 219,919 $ 302.214 282,829 10 392 Assets Current assets: Cash and equivalents Receivables Inventories Other current assets Total current assels Property and equipment, net Operating lease right-of-use assets Other assets Total assets Liabilties and stockholders equity Current liabilities: Accounts payable Accrued expenses Short-term portion of operating lease liabilties Income taxes payable Short-term parlion of deferred lease credits Total current liabilities Long-term liabilities: Long-term portion of operating tease liabilities Long-term portion of borrowings, not Long-term porlich af 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 Ratained earnings Accumulated other comprehensive loss, net of lax ("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' equlty Noncontrolling interests Total stockholders eqully Total liabilities and stockholders' equity 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 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 S The accompanying Notes are an integral part of these Consolidated Financial Statements. Table of Contents Item 8. Financial Statements and Supplementary Data Abercrombie & Fitch Co. Consolidated Statements of Operations and Comprehensive Income (Thousands, except per share amounts) Not sales Cost of sales, exclusive of depreciation and amortization Gross profil Storos and distribution expanse Marketing general and administrative expense Flagship store exil charges Asset Impalment, exclusive of flagship store exit aharon Other operating income, net Operating income Interest expense, nel Income before income taxes Income tax expenso Not income Less: Net Income attributable to noncontrolling interests Not income attrbutable to A&F Fiscal 2019 3,623,073 $ 1,472,155 2,150,918 1,561,243 464,615 47.257 19,135 (1.400) 70,068 7.737 62,331 17,371 44,960 5,002 39,350 $ Fiscal 2018 3,690,100 $ 1,430,193 2,159,918 1,535,216 484,863 5,800 11,580 (5,915) 127.300 10,999 110,367 37.559 78.808 4.267 74,541 S Fiscal 2017 3.192,690 1,406,840 2,083,842 1.540,032 471,914 2,393 4,391 (16.938) 72,050 16,888 55,161 44,636 10.526 3.431 7,094 Net income per share attributable to A&F Basic Diluded 0.61 $ 10.60 3 1.11 $ 0.10 1.08 SIR0.10 Weighted average shares outstanding Basic Diluted 64,428 67,350 69,137 68391 64.403 65,778 Other comprehensive (es) Income Foreign currency translation, not of tax Derivalve financial Instruments, net of tax Other comprehensive foss) income Comprehensive Income Less: Comprehensive Income attributable to noncontroling Interests Comprehensive Income attributable ta A&F (5.080) 5 (19,940) $ (1.354) 12,542 (6,434) (7,398) 38,526 71,410 5,602 4,267 32.924 $67,143 $ 41,180 (14,932) 24 248 36,773 3,431 33,342 The accompanying Notes are an integral part of these Consolidated Financial Statements. 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) 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. Table of Contents Abercrombie & Fitch Co. Consolidated Balance Sheets (Thousands, except par value amounts) February 1, 2020 February 2, 2019 571,267 80 251 434,326 78,905 1,264.749 665.290 1,230,964 388,672 3,519,665 $ 723,135 73,112 437,879 101,824 1,335,950 694,855 354,788 2,385,593 226,878 293,579 219,919 $ 302.214 282,829 10 392 Assets Current assets: Cash and equivalents Receivables Inventories Other current assets Total current assels Property and equipment, net Operating lease right-of-use assets Other assets Total assets Liabilties and stockholders equity Current liabilities: Accounts payable Accrued expenses Short-term portion of operating lease liabilties Income taxes payable Short-term parlion of deferred lease credits Total current liabilities Long-term liabilities: Long-term portion of operating tease liabilities Long-term portion of borrowings, not Long-term porlich af 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 Ratained earnings Accumulated other comprehensive loss, net of lax ("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' equlty Noncontrolling interests Total stockholders eqully Total liabilities and stockholders' equity 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 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 S The accompanying Notes are an integral part of these Consolidated Financial Statements. Table of Contents Item 8. Financial Statements and Supplementary Data Abercrombie & Fitch Co. Consolidated Statements of Operations and Comprehensive Income (Thousands, except per share amounts) Not sales Cost of sales, exclusive of depreciation and amortization Gross profil Storos and distribution expanse Marketing general and administrative expense Flagship store exil charges Asset Impalment, exclusive of flagship store exit aharon Other operating income, net Operating income Interest expense, nel Income before income taxes Income tax expenso Not income Less: Net Income attributable to noncontrolling interests Not income attrbutable to A&F Fiscal 2019 3,623,073 $ 1,472,155 2,150,918 1,561,243 464,615 47.257 19,135 (1.400) 70,068 7.737 62,331 17,371 44,960 5,002 39,350 $ Fiscal 2018 3,690,100 $ 1,430,193 2,159,918 1,535,216 484,863 5,800 11,580 (5,915) 127.300 10,999 110,367 37.559 78.808 4.267 74,541 S Fiscal 2017 3.192,690 1,406,840 2,083,842 1.540,032 471,914 2,393 4,391 (16.938) 72,050 16,888 55,161 44,636 10.526 3.431 7,094 Net income per share attributable to A&F Basic Diluded 0.61 $ 10.60 3 1.11 $ 0.10 1.08 SIR0.10 Weighted average shares outstanding Basic Diluted 64,428 67,350 69,137 68391 64.403 65,778 Other comprehensive (es) Income Foreign currency translation, not of tax Derivalve financial Instruments, net of tax Other comprehensive foss) income Comprehensive Income Less: Comprehensive Income attributable to noncontroling Interests Comprehensive Income attributable ta A&F (5.080) 5 (19,940) $ (1.354) 12,542 (6,434) (7,398) 38,526 71,410 5,602 4,267 32.924 $67,143 $ 41,180 (14,932) 24 248 36,773 3,431 33,342 The accompanying Notes are an integral part of these Consolidated Financial Statements. 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)