Please help me solve this?

Required information Excel Analytics 16-2 (Static) Return on Equity (ROE) [LO16-3, 16-4, 16-5] [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. Click here to download the Excel femplate. which you will use to answer the questions that follow Click here for a a brief tutorial on Charts in Excel. 4. Refer to the "Requirement 4 ROE Diagram" tab within your template. For altemative 1, complete the diagram by using appropriate formulas and reference cells. (In some instances your formulas and reference cells will refer to the Requirement 3 Financials tab). 0. Which choice shows the formulas used to compute the net operating income and average total assets? b. What is this alternative's estimated net profit margin percentage, total asset turnover, equity muitipliet, and retum on equity (ROE)? c. If the company pursues this altemative, would it cause next year's ROE to be greater than, less than, or equal to this year's ROE (as computed in requirement 2b ) Complete this question by entering your answers in the tabs below. Which choice shows the formulas used to computo the net operating income and avorage total assets? 4. Refer to the "Requirement 4 ROE Diagrom" tab within your template. For aliernative 1, complete the diagram by using appropriate formulas and reference cells. In some instances your formulas and reference cells will refer to the Requirement 3 Financals tabj a. Which choice shows the formulas used to compute the net operating income and average total assets? b. What is this alternative's estimated net profit margin percentage, total asset turnover, equity multiplies, and retum on equity (inoef? c. If the company pursues this altemative, would it cause next year's ROE to be greater than, less than, or equal to this year's ROE (as computed in requirement 26 )? Complete this question by entering your answers in the tabs below. What is this altemative's estimated net profit margn percentage, total anset bunevec, equity multplec, and return on equity (ROE)? (Round your answern to 2 decimal plices.) 4. Refer to the "Requirement 4 ROE Diagram" tab within your template. For alternative 1 , complete the diagram by using appropriate formulas and reference cells. (fin some instances your formulas and reference cells will refer to the Requirement 3 Financhals tob) a. Which choice shows the formulas used to compute the net operating income and average total assets? b. What is this alternative's estimated net profit margin percentage, total asset turnovec, equity mulipliet, arid retum on equity (HOE)? c. If the company pursues this aliemative, would it cause next year's ROE to be greater than, less than, or equal to this year's ROE (as computed in requirement 2b) ? Complete this question by entering your answers in the tabs below. If the company purnuen then altemative, would it cause next year'= Roe to be greatof than, fess than, of eegal to thin year's ROE (an computed in requirement 2b) ? Required information Excel Analytics 16-2 (Static) Return on Equity (ROE) [LO16-3, 16-4, 16-5] [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. Click here to download the Excel femplate. which you will use to answer the questions that follow Click here for a a brief tutorial on Charts in Excel. 4. Refer to the "Requirement 4 ROE Diagram" tab within your template. For altemative 1, complete the diagram by using appropriate formulas and reference cells. (In some instances your formulas and reference cells will refer to the Requirement 3 Financials tab). 0. Which choice shows the formulas used to compute the net operating income and average total assets? b. What is this alternative's estimated net profit margin percentage, total asset turnover, equity muitipliet, and retum on equity (ROE)? c. If the company pursues this altemative, would it cause next year's ROE to be greater than, less than, or equal to this year's ROE (as computed in requirement 2b ) Complete this question by entering your answers in the tabs below. Which choice shows the formulas used to computo the net operating income and avorage total assets? 4. Refer to the "Requirement 4 ROE Diagrom" tab within your template. For aliernative 1, complete the diagram by using appropriate formulas and reference cells. In some instances your formulas and reference cells will refer to the Requirement 3 Financals tabj a. Which choice shows the formulas used to compute the net operating income and average total assets? b. What is this alternative's estimated net profit margin percentage, total asset turnover, equity multiplies, and retum on equity (inoef? c. If the company pursues this altemative, would it cause next year's ROE to be greater than, less than, or equal to this year's ROE (as computed in requirement 26 )? Complete this question by entering your answers in the tabs below. What is this altemative's estimated net profit margn percentage, total anset bunevec, equity multplec, and return on equity (ROE)? (Round your answern to 2 decimal plices.) 4. Refer to the "Requirement 4 ROE Diagram" tab within your template. For alternative 1 , complete the diagram by using appropriate formulas and reference cells. (fin some instances your formulas and reference cells will refer to the Requirement 3 Financhals tob) a. Which choice shows the formulas used to compute the net operating income and average total assets? b. What is this alternative's estimated net profit margin percentage, total asset turnovec, equity mulipliet, arid retum on equity (HOE)? c. If the company pursues this aliemative, would it cause next year's ROE to be greater than, less than, or equal to this year's ROE (as computed in requirement 2b) ? Complete this question by entering your answers in the tabs below. If the company purnuen then altemative, would it cause next year'= Roe to be greatof than, fess than, of eegal to thin year's ROE (an computed in requirement 2b)