Questions 3 (4 points) A five-year summary of key financial data for a construction firm is shown in the below table. Evaluate and analyze the performance of this company during the period. What actions, if any, should be taken to improve the company's position? (000's) 2011 2012 2013 2014 2015 2,460 800 925 500 235 9.5 133 5.4 102 2,560 4 820 900 550 290 11.3 172 6.7 118 4.6 2,850 1 900 1,040 680 230 8 220 Sales % Sales growth Labor Material Cubcontr. Gross margin Gross margin % G&A G & A % sales Income before tax Income before tax % Admin. salary Assets Sales to assets Equity Sales to equity Current Assets Investments Investments Property and equipment 7.7 2,830 10.5 780 1,010 720 320 11.3 202 7.1 118 4.2 32 830 3.4 285 9.93 475.8 120 120 354.2 2,835 1 810 1,010 765 250 8.8 218 7.7 32 1.1 38 850 3.33 280 10.12 510 110 110 360 4.1 27 24 800 3.07 350 7.03 520 100 100 280 812 3.15 287 8.92 532 110 110 280 10 0.4 39 830 3.43 205 13.9 511.5 120 120 338.5 900 550 290 11.3 172 6.7 118 1,090 680 230 8 220 7.7 10 4.6 925 500 235 9.5 133 5.4 102 4.1 24 800 3.07 350 7.03 520 100 100 280 27 812 3.15 Material Cubcontr. Gross margin Gross margin % G&A G & A % sales Income before tax Income before tax % Admin. salary Assets Sales to assets Equity Sales to equity Current Assets Investments Investments Property and equipment Accu, depreciation Current liabilities Long term liabilities Current ratio Debt to equity Income to equity % Income to assets % Sales to current assets 1,010 720 320 11.3 202 7.1 118 4.2 32 830 3.4 285 9.93 475.8 120 120 354.2 1,010 765 250 8.8 218 7.7 32 1.1 38 850 3.33 280 10.12 510 110 110 360 287 0.4 39 830 3.43 205 13.9 511.5 120 120 338.5 8.92 532 110 110 280 100 325 125 110 380 145 120 390 155 130 425 145 140 465 160 1.6 1.28 29.1 12.7 4.73 1.4 1.83 41.1 14.5 4.81 1.22 1.91 41.4 14.2 5.94 1.2 2.04 11.4 3.8 5.56 1.1 3.04 4.8 1.2 5.57