please solve

Instructions: Online 1. Complete the common-size and common-base year financial statements (Income Statement (15) and Balance Sheet (BS)] or Brady Corp. in Excel in the M2 Project Excel file I provided. Be sure to include spark lines to easily show the trends. (25 pts) Write a brief analysis in the Excel worksheet of the main trends that you notice. (25 pts) o See Assigned Readings / Videos "Related to common-size and common-base year financial statements for Project" for videos on using Excel for complete these statements. o See Assigned Readings / Videos "Related to Excel Basics for Projact" for videos on creating sparklines in Excel and how to reference other excel sheets when computing ratios. 2. Perform the 3 step DuPont Return on Equity (ROE) analysis for Brady Corp. using cell references. (25 pts) Write a brief analysis (50-100 words) of what you learn from the DuPont analysis on your Excel worksheet. (25 pts) . For a good example see assigned Readings/Videos "Related to DuPont Return on Equity (ROE) for Project 2" 3. Submit your modified Excel file when you have completed the project by 23:59 Sunday. Grading Rubric Your assignment will be graded according to the grading rubric. D E F H K L M N O P Q R S Brady Corporation Balance Sheets (000's/5 Commonsi Commonbase year Trend Trend 2014 $ 2014 2015 2015 $ 2016 $ 2016 2014 2015 2016 25 1,712 1.582 3,319 20 10 3,412 6,454 2,958 6,490 6,390 12,954 590 Current Auets 7 Cash Receivables 9 Inventory Total current assets 11 12 Feed Assets 13 Land 14 Net plant, property & equipment 15 Totalfixed assets 16 17 Total Assets 11 19 Current liabilities 20 Account payables 21 Short termotes payables Total current liabilities 590 4,832 5,472 590 5,695 6,285 5,330 8.649 11.362 19,239 1,019 300 1,319 2,019 1,300 3,319 4,656 2.500 7.156 24 long-term liabilities 2,100 1310 6,155 3,619 6,649 13511 26 Totallilities 27 26 Shareholders' equity 29 Common stock 30 Retained earning 31 Total equity 12 33 Total liabilities & equity 34 35 4,500 218 4218 4.500 433 4.983 982 5.482 8.649 11,863 19,239 Calibrl (Body) 11 VAA Wrap Text General Inse Hilili BIU Merge & Center IH $ %) 22 Dele Forn Conditional Format Cell Formatting as Table Styles 26 fx D E G H M Q R S Schedule One Brady Corporation Income Statements 1000/5) Common die Common-base year Trend Trend 2014 2015 2016 2014 2015 2016 2014 2015 $ $ 18,675 28,675 15.932 24,393 2,743 4.282 2016 $ 48,845 42,007 6,838 Revenue Cost of Goods Sold Gross Profit Operating Expenses Selling 2 General Administrative 3 Total Operating Experves 4 Operating Profit s Interest Expense 16 Earnings Before Taxes 17 Taxes 38 Earnings Alter Taxes 1 251 1,090 2,341 402 210 192 67 125 1,851 1,590 1441 841 510 331 2,734 2,192 4,926 1,912 1.059 853 299 554 215 20 3 Step DuPont ROE Analysis 21 23 24 26 27 28 29 30 31 33 34 35 36 40 4 44 IS BS