please help me figure out the formulas

Chapter 3 Case Problem 2: WINE DEPOT You are to create Wine Depot's financial analyses as of December 31, 2020, and as of December 31, 2021. Following the Chapter 3 examples, use the stu- dent file ch3-05.xls to create a vertical and horizontal analysis of the balance sheet and income statement in the columns provided. (Note: The horizontal analysis will compare December 31, 2020 with December 31, 2021.) Also cre- ate a pie chart of expenses for the year ended December 31, 2021; a column chart of expenses for the years ended December 31, 2020, and December 31, Financial Statement Analysis 2021; and a ratio analysis as of December 31, 2021. Save the file as ch3-05_student_name.xls (replacing student name with your name). Note: You will have to use Ex olumns are not adjacent to one another as in the chapter example. Use what- ever chart layout you prefer. name.xls (replacing cel's help feature to create the column chart, because the Print each completed worksheet in Value view, with landscape orientation, scaling to fit to 1 page wide by 1 page tall, and with your name and date printed in the lower left footer and the file name in the lower right footer. Use Excel's help feature to move charts on your worksheet so that they print on a separate page. Chapter 3 Case Problem 3: SNICK'S BOARD SHOP eate a financial analysis for Snick's Board Shop as of December s the Chanter 3 examples, use the G H Wine Depot, Inc Income Statenmst for the period ended December-2020 % Sales December-2021 SalesChange |$375,000| 150,000 225,000 100% 40% 60% s 425,000 191,250 233,750 100%) 45% 55% Less: Cost of Goods Sold Gross Margin 10 Advertising Marketing Depreciation Interest 8,000 6,000 9,000 3,000 52,000 18,000 1,200 S 18,250 12 13 14 15 16 Utilities 8,000 1,500 85,000 15,000 7,000 Wages Supplies 2,800 100,000 27% 8,500 146,250 34% 87,500 21% 6% $ 61,250 14% 125,000 33% 37,500 10% S 87,500 23% Net income before taxes 26,250 19 20 21 Income taxes Net income 23 24 25 Income Statement Balance SheetRatio Analysis + 100 Ready 25 A1 Wine Depot, Inc. Wine Depot, Inc Balance Sheet as of December-2020 % Assets December-2021 % Assets % Change Current Assets: S 5,000 $ 7,000 Short-Term Investments Accounts Receivable Inventory Prepaid Expenses Supplies 10,500 1,800 22,000 2.300 32300 Equipment 85,000 103,700 Less: Accumulated Depreciation 8,000 77000 Total 16,000 87, $99,000 $120,000 Liabilities and Stockholders Equity Liabilities Current Liabilities: s 3,000 1,000 s 16,000 21 Accounts Payable 22 Income Tax Payable 23 Notes Payable - Equipment 6,000 9,000 18,000 2.000 51000 Notes Payable Other Payroll Liabilities Stockholders Equity 3.750 10.750 1,000 27 Common Stock 1,000 47,00048,000 108250 109250 $120,000 Retained Earnings Total $99,000