can some one please help me with this, it is in access tamplete, so I need the formula and cell ref

Sales for the year 2022 were $220,000, with cost of goods sold being 60 percent of sales. Amortization expense was 10 percent of pant and equipment (net) at the beginning of the year. Interest expense for the bonds payable was 8 percent, while interest on the notes payable was 10 percent. These are based on December 31 , 2021, balances. Seling and administrative expenses were $22,000, and the tax rate averaged 18 percent. During the year 2022, the cash balance and prepaid expenses balance were unchanged. Accounts receivable and inventory each increased by 10 percent, and accounts payable increased by 25 percent, A new machine was purchased on December 31,2022 , at a cost of $35,000. A cash dividend of $12,800 was paid to common shareholders at the end of 2022. Also, notes payable increased by $6,000 and bonds payabla decreased by $10,000. The common stock account did not change. B. Prepare an income statement for the year 2022 b. Prepare a balance sheet as of December 31,2022 c. Prepare a statement of cash flows for the year ended December 31,2022 Instructions Use the templates below to meet the requirements of the problem. a. Prepare an income statement for the year 2022 Nova Scotia Corporation b. Predare a balance sheet as of December 31. 2022. 107 C. Prepare a statement of cash flows for the year ended December 31, 2022. Nova Scotia Corporation Statement of Cash Flows For the Year Ended December 31, 2022 Operating Activities: Net income (earnings after taxes) Add items not requiring an outlay of cash: Amortization Cash flow from operations Changes in non-cash working capitat Increase in accounts receivable Increase in inventory Increase in accounts payable Increase in notes payable Net change in non-cash working cap Cash provided by operating activities investing Activities: Increase in plant and equipment Cash used in investing activities Cash used in investing Financing Activities: Decrease in bonds payable Cash used in financing activities Net increase in cash during the year Cash, beginning of year FORMULA Cash, end of year CELLR REF FORMULA FORMULA FORMULA FORMULA 49,400FORMULA FORMULA