Data table The McConnel Department Stores, inc chal exacutve olficer (CEO) has asked you to compate the conteany's proft performance and frianciat postion with the averages for the industry The CEO has given you the companys income statement and balance steot as well as the ingustiy avorage data for retaiers (Click the icoa fo viow the income statomont) (Click the icon to view the balance sheot) Requirement 1. Prepore a common swe income statement and balance sheet lot McConned. The first colurin of each ststoment should present McConneirs common-size stakement, and the second cotimn. the industry avorages Begin by propacing the cominon size nicome statement for McConiel (Round ycur answers bo oot decmal plack 8 ) Prepare a common-size balance sheet for McConnell. (Round vour answers tn nna docimal place, XX%.) botter er whree thin the indastry anesage? (a) Computo veconneirs gross prote pedcantage. (Round the gios prost percentnge to ane decrmal place, X% ) Gross orott percentage Prote margin talo Itan the induty averajes bor (i) Compite Meconnors cuiront tatio, (Teound the ratio to two docme paces ) Curtent indio = Deth to equity roho inderiry averagas? Mccontieis curnent rato s the andinty avorsga the iset lo equey iato is