6. Using excel, complete the common sized income statement for MKC using D as a guide. Take all calculations to one tenth of one percentage point. Inbox (4) - herbhar 19@gmail.com - Gmail 2/24/21, 2:33 PM mccormick 2017-2019 template.xls Open with A B D E F G H McCormick & Company Income Statements as a Percent of Sales and Changes from Prior Year con AN- 20 1 9 Amount %sales 2 0 1 8 Amount %sales 2 0 Amount %change %change %sales 8 Net Sales Less: cost of sales Gross Profit $5,347.40 $3,202.10 $2,145.3 $5,302.80 $3,209.50 $2,093.3 $4.730.30 $2,936.30 $1.794.0 9 $1,166.80 Less: SGA Transaction and integration expenses Less: Special charges $1,163.40 $22.50 $16.30 $1,031.20 $40.80 $22.20 $20.80 Operating Profit $957.7 $891.1 $699.8 $165.2 $174.6 less: interest expense Less: Other debt costs $95.7 $15.4 $6.1 Plus: other income, net $26.7 $24.8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Income from consolidated operations before income taxes $819.2 $741.3 $594.8 Less: income taxes Net Income from consolidated operations $157.4 $661.8 -$157.3 $898.6 $151.3 $443.5 Income from unconsolidated operations $40.9 $34.8 $33.9 Net Income $702.7 $933.4 $477.4 EPS-Basic $5.30 $3.77 $7.10 7nn 24 CDC Hild 05 24 0277 Sheet1 Snee:2 Snee:3 https://mail.google.com/mail/u/0/?shva=1#inbox?projector 1 Page 1 of 1