what is the answer

Required information Excel Analytics 16-2 (Static) Return on Equity (ROE) [LO16-3, 16-4, 16-5] [The following information applikes to the questions displayed below] Edman Comparty is a merchandiser that has provided the following balance sheet and income statement for this year. 5. Io evaluate ahernative 2. refer lo the "Hequement 5 rinancisk' tab within your template. Asiume the company puechases neve equipment in an eflort to grow saies whe the following estimated impocts - Next year's sales and varlable expenses increase by 5% - Next year's facd expemes are the same as this year - Neat year's encing bolances in accounts receivable, inventory. and accounts payable each merease by ss compared so their respective beginning balances - Next year's ending balance in propety plant and equpment (ned increases ty 5110000 compered to its beguncing balance. This reflects the purchase of a $150000 piece of equiment minus nest year's depreclabon experise of $40,000 - Next year's ending balance in bonds peryable decreases by $50.000 compered to ms begirning balance. thes reilects a bond issuance of 5150000 to purchase the eguipenent and a bond rebretrent of 3200000 - Next year's ending balances in other astets and coernon stock are the aame as theie begining batances. A. Baved on the above ertimated mpacts, use Exeel formilas 10 calculare the revined sales and varable cepmes as necden in column it: olint Your focmulas should refes to indarmason cemaned in the fecepirement i fanancuab tab) What are the ievtred arnosints of sules and the varable expenses? b. Flased on the above estamated impocts, une Excel formalas to calculate enoling bolances as needed in coluenc What is the ending balance in the following accounts? automatically be compued for youd What is the everage balance in the followeng accounts? d. What is the compary's estanated average toinal lathillies and stockholders' equaty for real year? Conghtete this auestiee bry eitreing your antwers in the tabs below. Required information Excel Analytics 16-2 (Static) Return on Equity (ROE) [LO16-3, 16-4, 16-5] [The following information applikes to the questions displayed below] Edman Comparty is a merchandiser that has provided the following balance sheet and income statement for this year. 5. Io evaluate ahernative 2. refer lo the "Hequement 5 rinancisk' tab within your template. Asiume the company puechases neve equipment in an eflort to grow saies whe the following estimated impocts - Next year's sales and varlable expenses increase by 5% - Next year's facd expemes are the same as this year - Neat year's encing bolances in accounts receivable, inventory. and accounts payable each merease by ss compared so their respective beginning balances - Next year's ending balance in propety plant and equpment (ned increases ty 5110000 compered to its beguncing balance. This reflects the purchase of a $150000 piece of equiment minus nest year's depreclabon experise of $40,000 - Next year's ending balance in bonds peryable decreases by $50.000 compered to ms begirning balance. thes reilects a bond issuance of 5150000 to purchase the eguipenent and a bond rebretrent of 3200000 - Next year's ending balances in other astets and coernon stock are the aame as theie begining batances. A. Baved on the above ertimated mpacts, use Exeel formilas 10 calculare the revined sales and varable cepmes as necden in column it: olint Your focmulas should refes to indarmason cemaned in the fecepirement i fanancuab tab) What are the ievtred arnosints of sules and the varable expenses? b. Flased on the above estamated impocts, une Excel formalas to calculate enoling bolances as needed in coluenc What is the ending balance in the following accounts? automatically be compued for youd What is the everage balance in the followeng accounts? d. What is the compary's estanated average toinal lathillies and stockholders' equaty for real year? Conghtete this auestiee bry eitreing your antwers in the tabs below