Complete the common-size and common-base year financial statements [Income Statement (IS) and Balance Sheet (BS)] or Brady Corp. in ExcelPerform the 3 step DuPont Return on Equity (ROE) analysis for Brady Corp. using cell references

6 6 %6 } {`` P| + 100 = X V BS A \\D G| N O 1 Schedule One* 2| Brady Corporation 3 Income Statements ( 000's / 5 ) Common - size Common - base year Trend Trend* 2014\\ 2015\\ 2016 2014 2015 2016 2014 2015 2016 6\\ 7\\ Revenue* 18, 675 28, 675 48 , 845 8| Cost of Goods Sold 15 , 932 24 , 393\\ 42 , 007 9\\ Gross Profit 2 , 743 4 , 282\\ 6 . 838 10 Operating Expenses 17\\ Selling 1 , 251 1 , 851 2 , 734 12\\ General & Administrative 1 , 090\\ 1 , 590 2 , 192 13 Total Operating Expenses 2 , 341 3 , 441 4 , 926 14 Operating Profit 402 841 1 , 912 15 Interest Expense* 210 510 1 , 059 16 Earnings Before Taxes 192 331 853 17 Taxes 67 116 299 18 Earnings After Taxes 125 215 554 19\\ 20 3 Step Dupont ROE Analysis\\ 27\\ 22 60 & & G B WR = 6` ` ~ ~ ~` & w ~ ~` 6 00 ~ ` ` D W| J a cl D WN _ !`` -