I need the common based year calcualted. 
abc H .0 Check cell Themes Aa- + >H 2.2 Y FX Pos L 100% Q- Search in Sheet At Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Alignment Number Format Cells Themes Fill Calibri (Body) - 11 - A- A Wrap Text General Normal Bad Good X Aa HH BREDE Clear Paste B I U A- 5 LE Merge - % .00 % ) 4.0 AM Conditional Neutral Calculation .00 Check Cell Formatting Insert Delete Format E30 % fx A B D E F G H 1 K L M N o P Q R S T U V w Y Z 1 Schedule One 2 Brady Corporation 3 Income Statements (000's/$) Common-size Common-base year 4 Trend Trend 5 2014 2015 2016 2014 2015 2016 2014 2015 2016 6 $ $ $ 7 Revenue 18,675 28,675 48,845 100.00% 100.00% 8 Cost of Goods Sold 15,932 24,393 42,007 85.31% 85.07% 86.00% 9 Gross Profit 2,743 4,282 6,838 14.69% 14.93% 14.00% 10 Operating Expenses 11 Selling 1,251 1,851 2,734 6.70% 6.46% 5.60% 12 General & Administrative 1,090 1,590 2,192 5.84% 5.54% 4.49% 13 Total Operating Expenses 2,341 3,441 4,926 12.54% 5.54% 4.49% 14 Operating Profit 402 841 1,912 2.15% 2.93% 3.91% 15 Interest Expense 210 510 1,059 1.12% 1.78% 2.17% 16 Earnings Before Taxes 192 331 853 1.03% 1.15% 1.75% 17 Taxes 67 116 299 0.36% 0.40% 0.61% 18 Earnings After Taxes 125 215 554 0.67% 0.75% 1.13%% 19 20 3 Step DuPont ROE Analysis 21 ROE 2016-25% 22 ROE 2017= 25% 23 24 2016 liabilites 1900 25 2017 liablites- 3200 26 When doing the balance sheet I notice that the buisness had higer libalites in 2017. Also the liablites did increase by 68% while the total sales only went up by 22% and the profit margin when down by one year. I saw a lot of change in the numbers and how it changed from year to year. 28 Brief analysis of main trends I noticed: I noticed that per year to year the common size would change in a small amount. Since the company has higer lelveraged and needed to be more particualr on the financial descisons that had to be made. The company did not have a great asset turnover and the year to y 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 IS BS + 0 Normal View Ready Sum-0 27 200 RRRR abc H .0 Check cell Themes Aa- + >H 2.2 Y FX Pos L 100% Q- Search in Sheet At Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Alignment Number Format Cells Themes Fill Calibri (Body) - 11 - A- A Wrap Text General Normal Bad Good X Aa HH BREDE Clear Paste B I U A- 5 LE Merge - % .00 % ) 4.0 AM Conditional Neutral Calculation .00 Check Cell Formatting Insert Delete Format E30 % fx A B D E F G H 1 K L M N o P Q R S T U V w Y Z 1 Schedule One 2 Brady Corporation 3 Income Statements (000's/$) Common-size Common-base year 4 Trend Trend 5 2014 2015 2016 2014 2015 2016 2014 2015 2016 6 $ $ $ 7 Revenue 18,675 28,675 48,845 100.00% 100.00% 8 Cost of Goods Sold 15,932 24,393 42,007 85.31% 85.07% 86.00% 9 Gross Profit 2,743 4,282 6,838 14.69% 14.93% 14.00% 10 Operating Expenses 11 Selling 1,251 1,851 2,734 6.70% 6.46% 5.60% 12 General & Administrative 1,090 1,590 2,192 5.84% 5.54% 4.49% 13 Total Operating Expenses 2,341 3,441 4,926 12.54% 5.54% 4.49% 14 Operating Profit 402 841 1,912 2.15% 2.93% 3.91% 15 Interest Expense 210 510 1,059 1.12% 1.78% 2.17% 16 Earnings Before Taxes 192 331 853 1.03% 1.15% 1.75% 17 Taxes 67 116 299 0.36% 0.40% 0.61% 18 Earnings After Taxes 125 215 554 0.67% 0.75% 1.13%% 19 20 3 Step DuPont ROE Analysis 21 ROE 2016-25% 22 ROE 2017= 25% 23 24 2016 liabilites 1900 25 2017 liablites- 3200 26 When doing the balance sheet I notice that the buisness had higer libalites in 2017. Also the liablites did increase by 68% while the total sales only went up by 22% and the profit margin when down by one year. I saw a lot of change in the numbers and how it changed from year to year. 28 Brief analysis of main trends I noticed: I noticed that per year to year the common size would change in a small amount. Since the company has higer lelveraged and needed to be more particualr on the financial descisons that had to be made. The company did not have a great asset turnover and the year to y 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 IS BS + 0 Normal View Ready Sum-0 27 200 RRRR
