I really need the actual equations for part 2 in order to receive credit, if you could tell me what those equations are that would be a huge help! Thank you!

ACCTG 231 ends the semester with a step back into working with financial statements presented to external users, along with ratios commonly employed to evaluate companies for either investment potential or creditworthiness. 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. NIKE, INC. CONSOLIDATED STATEMENTS OF INCOME $ 2019 39,117 21.643 17,474 3.753 YEAR ENDED MAY 31, 2021 2020 44,538 $ 37.403 $ 24,576 21,162 19.962 16,241 3,114 3,592 9,911 9.534 13,025 13.126 262 89 14 139 6.661 2.887 934 348 5,727 $ 2,539 $ 8.949 12,702 49 (In millons, except per share data) Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Total selling and administrative expense Interest expense (income), net Other (income) expense, net Income before income taxes Income tax expense NET INCOME Earnings per common share: Basic Dituted Weighted average common shares outstanding Basic Diuted 782 4,801 772 4,029 $ $ $ 3.64 $ 3.56 $ 1.63 $ 1.60 $ 2.55 2.49 1,573,0 1.609.4 1,558.8 1,591.6 1.579.7 1,618,4 The accompanying Notes to the Consolidated Financial Statements are an integral part of this statement. 2021 FORM 10-K 57 NIKE, INC. CONSOLIDATED BALANCE SHEETS MAY 31, 2020 2021 $ 9.889 $ 3,587 4,463 6,854 1,498 26,291 4,904 3,113 269 242 2,921 37,740 $ 8,348 439 2.749 7.367 1,653 20.556 4,866 3,097 274 223 2,326 31,342 $ (in millions) ASSETS Current assets: Cash and equivalents Short-term investments Accounts receivable.net Inventories Prepaid expenses and other current assets Total current assets Property, plant and equipment, net Operating lease right-of-use assets, net Identifiable intangible assets, net Goodwill Deferred income taxes and other assets TOTAL ASSETS LIABILITIES AND SHAREHOLDERS' EQUITY Current abilities: Current portion of long-term debt Notes payable Accounts payable Current portion of operating lease liabilities Accrued liabilities Income taxes payable Total current liabilities Long-term debt Operating lease liabilities Deferred income taxes and other liabilities Commitments and contingencies (Note 18) Redeemable preferred stock Shareholders' equity Common stock at stated value: Class A convertible - 305 and 315 shares outstanding Class B-1.273 and 1,243 shares outstanding Capital in excess of stated value Accumulated other comprehensive income (lass) Retained earnings (deficit) Total shareholders' equity TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 2 2,836 467 6,063 306 3 248 2,248 445 5,184 156 8.284 9.406 2.913 2.684 9,674 9,413 2,931 2,955 - 3 9.965 (380) 3.179 12,767 37.740 $ 3 8.299 (56) (191) 8,055 31,342 $ The accompanying Notes to the Consolidated Financial Statements are an integral part of this statemont. 1 (14 Points - 1 point per account) NIKE's 2021 Dividend $ 1.10 From the Company Financial Statements of NIKE, identify the following items and input amounts into the shaded cells. If NIKE does not have an account requested put 0 (zero). Balance Sheet (2021 amounts only) Balance Sheet (2021 and 2020 amounts) Cash $ 9,889,000,000 2021 2020 Accounts Receivable $ 4,463,000,000 Inventory $ 6,854,000,000 $ 7,367,000,000 Marketable Securities* $ 3,587,000,000 Total Stockholders' Equity $ 12,767,000,000 $8,055,000,000 Total Current Assets $ 26,291,000,000 Total Current Liabilities $ 9,674,000,000 Total Liabilities $ 24,973,000,000 Income Statement (2021 only) Sales** Cost of Goods Sold** Interest Expense Income Tax Expense Net Income Basic Earnings per share $ 44,538,000,000 $ 24,576,000,000 $ 262.000.000 $ 934,000,000 $ 5,727,000,000 $ 3.64 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 2.72 2.01 (1 point) (1 point) Asset Management Average Inventory Sale period 0.28 (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)