1 2 H20 7 Columnl S A 5969.16 G H COMPANY, INC. CONSOLIDATED STATEMENTS OF INCOME 2006 2007 2008 2009 2010 2011 2012 9 Revenue $ 5,381 $ 7,802 $ 9,207 $ 10,864 $ 12,820 $ 13,461 $ 14,134 11 Costs and expenses: 12 Cost of revenue $ 1,345 $ 25% 1,951 $ 25% 2,302 S 25% 2,716 S 3,205 $ 3,365 $ 3,533 25% 25% 25% 2596 $ 639.04 $ 926.61 $ 1,093.40 $ 1,290.21 $ 1,522.45 $ 1,598.57 $ 1,678.50 12% 129 12% 12% 12% 888.37 $ 1,048.28 $1,236.97 $ 1,298.81 $1,363.75 10% 10% 10% 10% 10% 775.15 $ 914.67 $ 1,079.31 $1,133.28 $ 1,189.94 1296 12% $ 519.21 $752.86 $ 10% 10% $ 453.04 $ 656.90 $ 8% 8% $ 2,957 $ 4,287 $ 56% 5296 $96 5,059 $ 53% 8% 5.969 $ 54% 539 5396 4,895 $ 5,776 $ 6,065 $ 6,368 45% 45% 45% 45% 13 14 Marketing and sales 15 16 Research and development 17 18 General and administrative 19 20 Total costs and expenses 21 22 Income from operations 23 25 Interest and other income (expense) net 26 Interest expense $ 2,424 $ 3,515 $ 4,148 S 4596 45% 4596 $96 8% 8% 7,044 $ 7,396 $ 7,766 5396 27 Other income (expense), net 28 29 (72) -3% (104) (122) (144) (170) (179) (188) -3% -396 -396 -396 -396 -3% 32 Provision for income taxes 31 Income before provision for income taxes $ 2,353 $ 3,412 $ 4,026 $ 4,750 $ 5,605 $ 5,886 $ 6,180 $ 1,058.80 $1,535.25 $ 1,811.60 $ 2,137.69 $ 2,522.47 $ 2,648.70 $2,781.02 33 4596 45% 45% 45% 45% 45% 45% 34 35 Net income $ 1,294 $ 1,876 $ 2,214 S 36 37 24% 9% 249 2496 2,613 $ 2496 3,083 S 3,237 S 3,399 24% 24% 24% 9% 996 996 996 996 9% 38 Add: Depreciation and amortization $ 462 $ 671 $ 7915 934 $ 1,102 $ 1,1575 1,215 39 Net cash flow from operations $ 1,757 $ 2,547 S 3,005 S 3,546 S 4,185 $ 4,394 S 4,614 40 Calculating the sum of the revenues from year 2006 to 2010. Check all that apply. Cursor at an empty cell Enter=SUM(E9:19) In Excel 2010, select cells E9:19, Sum shown at the bottom right of the worksheet Cursor at an empty cell-Click on AutoSum Change the cell selection to E9:19 Cursor at an empty cell Enter -E9+F9+G9+H9+19 idently reached If you were do the same validation and modification tasks for the balance sheet of the same company which supposedly has been provided in Sheet 2 of the Workbook, you would use the syntax Page Down to navigate to the next worksheet. You realize tha cell AC2034 and you need to navigate back to the location where top of the page where the data resides, you would enter While you were conducting some calculations, you realize that the values were being incorrectly calculated because the rar change when you dragged the cell or copied it to another location. Your goal is to make cell E9 an absolute reference, whic drag the function to another cell, it will still point to the same cell. You would thus add sign and refer to the cell as -8-9 $E$9 +E+9 cells would that if you copy or Calculating the sum of the revenues from year 2006 to 2010. Check all that apply. Cursor at an empty cell Enter =SUM(E9:19) In Excel 2010, select cells E9:19, Sum shown at the bottom right of the worksheet Cursor at an empty cell Click on AutoSum Change the cell selection to E9:19 Cursor at an empty cell Enter E9+F9+G9+H9+19 If you were do the same validation and modification tasks for the balance sheet of the same company which supposedly has been provided in Sheet 2 of the Workbook, you would use the syntax Page Down to navigate to the next worksheet. You realize that you accidently reached cell AC2034 and you need to navigate back to the location where top of the page where the data resides, you would enter While you were conducting some calculations, you realize that the values were being incorrectly calculated because the range of the cells would change when you dragged the cell or copied it to another location. Your goal is to make cell E9 an absolute reference, which means that if you copy or drag the function to another cell, it will still point to the same cell. You would thus add sign and refer to the cell as Calculating the sum of the revenues from year 2006 to 2010. Check all that apply. Cursor at an empty cell Enter =SUM(E9:19) In Excel 2010, select cells E9:19, Sum shown at the bottom right of the worksheet Cursor at an empty cell Click on AutoSum-Change the cell selection to E9:19 Cursor at an empty cell Enter -E9+F9+G9+H9+19 If you were do the same validation and modification tasks for the balance sheet of the same company which supposedly has been provided in Sheet 2 of the Workbook, you would use the syntax Page Down to navigate to the next worksheet. You realize that you accidently reached cell AC2034 and you need to navigate back to the location where top of the page where the data resides, you would enter End ould While you were conducting some calculations, you realize that the values were being incorrectly calculated because the ran change when you dragged the cell or copied it to another location. Your goal is to make cell E9 an absolute reference, which Home ou copy or drag the function to another cell, it will still point to the same cell. You would thus add sign and refer to the cell as Grade It Now Save & Continue