Please help

Brief Exercise 10-13 Presented here are liability items for Shamrock Inc. at December 31, 2022. Accounts payable $172,700 FICA taxes payable Notes payable (due May 1, 2023) 22,000 Interest payable Bonds payable (due 2026) 990,000 Notes payable (due 2024) Unearned rent revenue 264,000 Income taxes payable Discount on bonds payable 45,100 Sales taxes payable Prepare the liabilities section of Shamrock's balance sheet. $8,580 44,000 88,000 3,850 1,870 SHAMROCK INC. Balance sheet (Partial) CES SHAMROCK INC. Balance sheet (Partial) city :- emd efe ail *Exercise 11-16 a1 The following financial information is available for Blue Spruce Corporation. (in millions) 2022 2021 Average common stockholders' equity $2,500 $2,600 Dividends declared for common stockholders 319 713 Dividends declared for preferred stockholders 35 Net income 550 620 Calculate the payout ratio and return on common stockholders' equity for 2022 and 2021. (Round answers to 1 decimal place, e.g. 12.5%) 35 hol to 2022 2021 Payout ratio % % Return on common stockholders' equity % P% Hypothetical balance sheets of Nike, Inc. are presented here. NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 $9,880 1,840 1,530 $13,250 $8,900 1,800 1,620 $12,320 Assets Current Assets Property, plant, and equipment (net) Other assets Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities Stockholders' equity Total liabilities and stockholders' equity $3,260 1,250 8,740 $13,250 $3,380 1,300 7,640 $12,320 (a) 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.5%.) NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) Increase Percentage 2022 2021 (Decrease) Change from 2021 Assets uur NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) 2022 2021 Increase (Decrease) Percentage Change from 2021 Assets Current Assets $9,880 $8,900 $ % Property, plant, and equipment (net) 1,840 1,800 % Other assets 1,530 1,620 % Total assets $13,250 $12,320 $ % Liabilities and Stockholders' Equity Current Liabilities $3,260 $3,380 %% $ Long-term liabilities 1,250 1,300 % Stockholders' equity 8,740 7,640 % Total liabilities and stockholders' equity $13,250 $12,320 $ 96 (b) Prepare a vertical analysis of the balance sheet data for Nike for 2022. NIKE, INC. (b) Prepare a vertical analysis of the balance sheet data for Nike for 2022. NIKE, INC. Condensed Balance Sheet $ (in millions) Percent Assets Current Assets $9,880 % Property, plant, and equipment (net) 1,840 % Other assets 1,530 % Total assets $13,250 % Liabilities and Stockholders' Equity Current Liabilities $3,260 % Long-term Liabilities 1,250 % Stockholders' equity 8,740 % $13,250 % Total liabilities and stockholders' equity