how do I answer question 2 using this information

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 pice of GAP stock have been entered into cells Q9 and Q10, respectively). THE GAP, INC. CONSOLIDATED BALANCE SHEETS (5 and shares in millions except par value) ASSEIS Current assets. LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable \begin{tabular}{rrr} $1,951 & $ & 1,743 \\ 1,367 & 1,276 \\ 734 & 831 \\ \hline 25 & 34 \\ \hline 4,077 & 3,884 \\ \hline \end{tabular} Accrued expenses and other current liabilities Current portion of operating lease liabilities Income taxes payable Total current liabilities Long-term liabilities: Long-term debt Long-term operating lease liabilities Other long-term liabilities Total long-term liabilities \begin{tabular}{rr} 1,484,033 & 4,617 \\ \hline 445 & 438 \\ \hline 5,962 \\ \hline \end{tabular} Commitments and contingencies (see Note 15) Stockholders' equity: Common stock $0.05 par value Authorized 2,300 shares for all periods presented; Issued and Outstanding 371 and 374 shares Additional paid-in capital Retained eamings Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity THE GAP, INC. CONSOLIDATED STATEMENTS OF OPERATIONS THE GAP, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (LOSS) THE GAP, INC. CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY THE GAP, INC. Compute the Followine ratios (please indut into shaded celi) Display answer to two decimal places. (9 Points - 1 point per ratie) 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 pice of GAP stock have been entered into cells Q9 and Q10, respectively). THE GAP, INC. CONSOLIDATED BALANCE SHEETS (5 and shares in millions except par value) ASSEIS Current assets. LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable \begin{tabular}{rrr} $1,951 & $ & 1,743 \\ 1,367 & 1,276 \\ 734 & 831 \\ \hline 25 & 34 \\ \hline 4,077 & 3,884 \\ \hline \end{tabular} Accrued expenses and other current liabilities Current portion of operating lease liabilities Income taxes payable Total current liabilities Long-term liabilities: Long-term debt Long-term operating lease liabilities Other long-term liabilities Total long-term liabilities \begin{tabular}{rr} 1,484,033 & 4,617 \\ \hline 445 & 438 \\ \hline 5,962 \\ \hline \end{tabular} Commitments and contingencies (see Note 15) Stockholders' equity: Common stock $0.05 par value Authorized 2,300 shares for all periods presented; Issued and Outstanding 371 and 374 shares Additional paid-in capital Retained eamings Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity THE GAP, INC. CONSOLIDATED STATEMENTS OF OPERATIONS THE GAP, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (LOSS) THE GAP, INC. CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY THE GAP, INC. Compute the Followine ratios (please indut into shaded celi) Display answer to two decimal places. (9 Points - 1 point per ratie)