looking for a vertical and horizontal analysis
can anyone help
Continuing Cookie Chronicle 13 a, r (Essay) The comparative balance sheet of Cookie & Coffee Creations Inc. at October 31, 2023 For the years 2023 and 2022, and the income statements for the years ended October 31, 2022 and 2023, are presented below. COOKIE I COFFEE CREATIONS I Balance Sheet October 31 Ansel! Cash Accounts receivable Inventory Prepaid expenses Equipment Accumulated depreciation Total assets Llabllltles and Stodtholders' Equity Acoounts payable Income taxes payable Dividends payable Salaries and wages payable Interest payable Note payablecurrent portion Note payablelong-terrn portion Preferred stock, no par, $6 cumulative 3,000 and 2,300 shares issued, respectively Common stock, 51 par25,930 shares issued Additional paid in capitaltreasury- stock Retained earnings Less treasury stock Total liabilities and stockholders'eqwty 2023 $29,074 3,250 7,097 5,300 102,000 {25,200} $122,021 $1,150 9,251 27,000 7,250 130 4,000 6,000 15,000 25,930 250 26,002 0 $122 821 2022 $11,550 2,710 7,450 5,050 75,500 (9,100) $94,150 $2,450 7,200 27,000 1,200 0 0 0 14,000 25,930 0 15,000 (500) $94 150 Total liabilitles and stockholders'equlty $122 321 $94 160 COOKIE In COFFEE CREATIONS INC. Income Statement Year Ended Octoberzl 2023 2022 Sales $485,625 $462,500 Cost of goods sold 222,694 208,125 Gross prot 262,931 254,375 Operating expenses Salaries and wages expense 147,979 146,350 Depreciatlon expense 17,600 9,100 Other operating expenses 43.136 42,925 Total operating expenses 213.755 198.375 Income from operations 49,166 56,000 Other expenses Interest expense 413 0 Loss on disposal of plant assets 2.500 D Total other expenses 2,913 0 Income before lncome tax 46,253 56,000 Income tax expense 9,251 14,000 Net income $37,002 $42,000 Additional information: Natalie and Curtis are thinking about borrowing an additional $20,000 to buy more kitchen equipment. The loan would be repaid over a 4-year period. The terms of the loan provide for equal semi-annual payments of $2,500 on May 1 and November 1 of each year, plus interest of 5% on the outstanding balance. 2023 2022 1- Current ratio 0.94 :1 0,73 :l 2. Debt to assets 45 \"in 40 \"1'0 3. Gross prot rate 54 \"A: 55 WI: 4- Prot margin 7.6 \"pl: 9.}. \"1'0 5. Return on assets (Total assets at November 1, 2021, were $35,180.) 34.1 \"in 64.9 \"1'0 5. Return on common stockholders' equity (Total common stockholders' equity at November 1, 2021, was $25,180. DiVIdends on preferred stock were $16,800 in 2022 and $18,000 In 2023). 39-7 \"vb 34-8 \"In COOKIE & COFFEE CREATIONS INC. Income Statement Year Ended October 31 Horizontal Analysis Sales 5 % Cost of goods sold 7% Gross profit 3 % Operating expenses Salaries and wages expense 1 % Depreciation expense 93 % Other operating expenses 12 % Total operating expenses 8 % Income from operations -12 % Other expenses Interest expense Loss on disposal of plant assets Total other expenses Income before income tax -17 % Income tax expense -34 % Net income -12 %COOKIE & COFFEE CREATIONS INC. Income Statement Year Ended October 31 2023 2022 Vertical Analysis Vertical Analysis Sales 100.00 % 100.00 % Cost of goods sold 45.86 % 45.00 % Gross profit 54.14 % 55.00 % Operating expenses Salaries and wages expense 30.47 % 31.64 % Depreciation expense 3.62 % 1.97 % Other operating expenses 9.92 % 9.28 % Total operating expenses 44.02 % 42.89 % Income from operations 10.12 % 12.11 % Other expenses Interest expense 0.09 % 0.00 % Loss on disposal of plant assets 0.51 % 0.00 % Total other expenses 0.60 % 0.00 % Income before income tax 9.52 % 12.11 % Income tax expense 1.90 % 3.03 % Net income 7.62 % 9.08 %
