this question needs to be answered in a excel file please, with step by step ins
ID: 3221492 • Letter: T
Question
this question needs to be answered in a excel file please, with step by step instructions.
For the following questions, use this information from General Electric Corporation’s annual reports available in the file GE Data Spring 2017:
1) Compute a simple index for the revenue of GE. Use 2004 as the base period. What can you conclude about the change in revenue over the period?
2) Compute a simple index for the revenue of GE using the period 2004–06 as the base. What can you conclude about the change in revenue over the period?
3) Compute a simple index for the number of employees for GE. Use 2004 as the base period. What can you conclude about the change in the number of employees over the period?
4) Compute a simple index for the number of employees for GE using the period 2004–06 as the base. What can you conclude about the change in the number of employees over the period?
Do your calculations in Excel
Column1 Revenue Employees Year ($million) (000) 2004 134.3 305 2005 148.0 307 2006 163.4 316 2007 172.5 319 2008 182.5 323 2009 153.7 304 2010 148.9 287 2011 146.5 305 2012 146.7 307 2013 146.0 305 2014 153.5 315 2015 147.6 316Explanation / Answer
Index for a year = 100x(value for the year/base year value) Average of 2004, 2005 and 2006 values is taken as the base value for 2004-06 Column1 Revenue Employees Revenue Index Employees Index Year ($million) 0 2004 Base 04-06 Base 2004 Base 04-06 Base 2004 134.3 305 100 90.39713 100 98.59914 2005 148 307 110.201 99.61858 100.6557 99.24569 2006 163.4 316 121.6679 109.9843 103.6066 102.1552 2007 172.5 319 128.4438 116.1095 104.5902 103.125 2008 182.5 323 135.8898 122.8405 105.9016 104.4181 2009 153.7 304 114.4453 103.4552 99.67213 98.27586 2010 148.9 287 110.8712 100.2244 94.09836 92.78017 2011 146.5 305 109.0841 98.60893 100 98.59914 2012 146.7 307 109.2331 98.74355 100.6557 99.24569 2013 146 305 108.7118 98.27238 100 98.59914 2014 153.5 315 114.2964 103.3206 103.2787 101.8319 2015 147.6 316 109.9032 99.34934 103.6066 102.1552
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.