Need help

Prepare a Vertical Analysis using Excel J & J SNACK FOODS CORP. AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (in thousands, except share amounts Sept. 25, 2021 2021% Assets Sept. 26, 2020 2020% Favorable or Current assets Unfavorable Cash and cash equivalents $ 283,192 195,809 Marketable securities held to maturity 7,980 51,091 Accounts receivable, net 162,939 140,938 Inventories 123,160 116,165 Prepaid expenses and other 7,498 5,768 Total current assets 584,769 506,357 Property, plant and equipment, at cost $ 757,242 676,724 Less accumulated depreciation and amortization 490,055 423,276 Property, plant and equipment, net 267,187 253, 448 Other assets Goodwill $ 121,833 102,511 Other intangible assets, net 77,776 54,922 Marketable securities held to maturity 4,047 79,360 Marketable securities available for sale 10,084 19,903 Operating lease right-of-use assets 54,555 Other 1,968 2,838 Total other assets 270,263 259,534 Total Assets $ 1, 122,219 $ 1,019,339 Liabilities and Stockholders' Equity Current Liabilities Current finance lease liabilities $ 182 339 Accounts payable 96,789 72,029 Accrued insurance liability 16,260 10,457 Accrued liabilities 10,955 7,808 Current operating lease liabilities 13,395 Accrued compensation expense 17,968 21,154 Dividends payable 12,080 9,447 Total current liabilities 167,629 121,234 392 718 Noncurrent finance lease liabilities Noncurrent operating lease liabilities 46,557 61,578 61,920 Deferred income taxes Other long-term liabilities 409 1,716 Stockholders' Equity Preferred stock, $1 par value; authorized 10,000,000 shares; none issued Common stock, no par value; 45,744 tA 73,597 authorized, 50,000,000 shares; issued and outstanding 19,084,000 and 18,915,000 respectively (13,383 (12,988) Accumulated other comprehensive loss 785,440 800,995 Retained Earnings 845,654 33,751 Total stockholders' equity $ 1,122,219 $ 1,019,339 Total Liabilities and Stockholders' Equity