[The following information applies to the questions dlsplayed below.] Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Click here to download the Excel template. which you will use to answer the questions that follow. Click here for a a brief tutorial on Charts in Excel. Required: 1. Refer to the "Requirement 1 Financlals" tab within your template. For this year, create formulas within column D that calculate the average balance for each balance sheet account. a. What is the average balance for the following accounts: b. What is this year's average total liabilitles and stockholders' equity? Complete this question by entering your answers in the tabs below. What is the average balance for the following accounts: Required: 1. Refer to the "Requirement 1 Financlals" tab within your template. For this year, create formulas within column D that calculate the average balance for each balance sheet account. a. What is the average balance for the following accounts: b. What is this year's average total llabilitiles and stockholders' equity? Complete this question by entering your answers in the tabs below. What is this year's average total liabilities and stockholders' equity