Suppose the hypothetical comparative condensed balance sheets of Nike, Inc. are presented here. 2021 NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 Assets Current Assets $9,550 Property, plant, and equipment (net) 2,050 Other assets 1,480 Total assets $13,080 Liabilities and Stockholders' Equity Current Liabilities $3,230 Long-term liabilities 1,270 Stockholders' equity 8,580 Total liabilities and stockholders' equity $13,080 $8,900 1,850 1,730 $12,480 $3,330 1,300 7,850 $12,480 Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.2%.) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) Increase (Decrease) Percentage Change from 2021 2022 2021 Assets Current Assets $9,550 $8.900 $ % Property, plant, and equipment (net) 2,050 1,850 % Other assets 1,480 1,730 % Total assets $13,080 $12,480 $ % Liabilities and Stockholders' Equity Current Liabilities $3,230 $3,330 $ % Long-term liabilities 1,270 1,300 % Stockholders' equity 8,580 7,850 % Total liabilities and stockholders' equity $13,080 $12,480 $12,480 $ % Operating data for Pina Colada Corp. are presented as follows. Sales revenue Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income 2022 $821,000 521,335 120,687 73,069 32,840 73,069 2021 $621,000 409,239 73,278 49,059 22,356 67,068 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.) PINA COLADA CORP. Condensed Income Statement 2022 2021 Amount Percent Amount Percent Sales $821,000 % $621,000 Cost of goods sold 521,335 % 409,239 % Gross profit 299,665 % 211,761 % Selling expenses 120,687 % 73.278 % Administrative expenses 73,069 % 49,059 % Total operating expenses 193,756 % 122,337 % Income before income taxes 105,909 % 89,424 % Income tax expense 32,840 % 22,356 % Net income $ 73,069 % $ 67,068 % View Policies Current Attempt in Progress Here is the income statement for Skysong, Inc. SKYSONG, INC. Income Statement For the Year Ended December 31, 2022 Sales revenue $405,300 204,000 Cost of goods sold Gross profit Expenses (including $11,200 interest and $27,300 income taxes) Net income 201,300 94,255 $ 107,045 Additional information: 1. Common stock outstanding January 1, 2022, was 20,700 shares, and 39,800 shares were outstanding at December 31, 2022. The market price of Skysong stock was $11.83 in 2022. Cash dividends of $26,209 were paid, $4,800 of which were to preferred stockholders. 2. 3. Compute the following measures for 2022. (Round earnings per share to 2 decimal places, e.g 1.83 and all other answers to 1 decimal place, e.g. 1.8 or 2.5%) (a) Earnings per share $ (b) Price-earnings ratio times (c) Payout ratio % (d) Times interest earned times