Excel Analytics 16-2 (Static) Return on Equity (ROE) [LO16-3, 16-4, 16-5] Skip to question [The following information applies to the questions displayed below.] Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Required: 1. Refer to the "Requirement 1 Financials" 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 liabilitics and stockholders' equity? Complete this question by entering your answers in the tabs below. Congiete this question by enterisg your and wim ls tof tobs beles. Compinte this euestien by antering yeer aswers ln the tabs below. What a tha yeirls andage tatal lasilbies and stockivallers' equity