(23 POINTS) ACCTG 231 ends the semester with a step back into working with financial statements prepared for external users, computing ratios commonly employed by investors and creditors to evaluate companies, and doing so using an excel spreadsheet. For this assignment you will use the financial statements for GAP, Inc., provided in Canvas. The financial statements are included in the GAP's annual report: - The Consolidated Balance Sheet is found on page 46 and - The Consolidated Statement of Operations (i.e. Income Statement) is on page 47. 1. After locating the financial statements, enter the amounts requested into the Excel spreadsheet template. (14 points) a. Some items require amounts from the current year only, while inventory and total stockholders' equity require both the current year and the previous year. b. Amounts for annual dividends and market price of GAP stock have been entered into cells Q9 and Q10, respectively). 2. Compute the ratios requested in the Excel template using the formulas in the text (see Exhibit 14-6). (9 points) NOTE: ratios presented in various online sites for GAP may differ from those you compute, as some 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, pages 680-681 - in the text) - be sure spreadsheet presents all computations to two decimal places. \begin{tabular}{l|l} 4 & \\ \hline 5 & 1 \end{tabular} From the Financial Statements of the GAP, identify the following items and input amounts into the shaded cells. (14 Points - 1 point per account) \begin{tabular}{|l|l|l|l|l|} \hline Income Statement (Fiscal 2021 only) & Balance Sheet & January 29,2022 & January 30,2021 \\ \hline Sales & Cash \& equivalents & Annual dividends \\ \hline Cost of Goods Sold & Short term Investments \\ \hline Interest Expense & Merchandise Inventory \\ \hline Income Taxes & Other current assets \\ \hline Net Income (loss) & Total Current Liabilities \\ \hline Earnings per Share - Basic & Total Liabilities \\ \hline & Total Stockholders' Equity \\ \hline \end{tabular} 2 Compute the Following ratios (please input into shaded cell) Display answer to two decimal places. (9 Points - 1 point per ratio) Liquidity Current Ratio Acid Test Asset Management Average sale period Debt Management Debt to equity Times Interest Earned Profitability Return on Equity Net Profit Margin Market Performance Dividend Payout Dividend Yield