Hello. If you guys can please explain how you got your answers with the equations on Excel! Need to learn how to do this, please.

2. Here are earnings per share for two companies by quarter from the first quarter of 2009 through the second quarter of 2012. Use the time series decomposition method to forecast the last two quarters of 2012 and all four quarters of 2013. Using your forecasts, comment on each company (it is much easier to solve this problem on a computer spreadsheet so you can see what is happening.) Quarter 2009 ! | III IV 2010 1 III IV 1 Company A $1.67 2.35 1.11 1.15 1.56 2.04 1.14 0.38 0.29 -0.18 (loss) -0.97 (loss) 0.2 -154 (loss) 0.38 Company B $0.17 0.24 0.26 0.34 0.25 0.37 0.36 0.44 0.33 0.40 0.41 0.47 0.30 0.47 2011 III IV 1 2012 Period (1) Quarter Actual Demand (y) Average of Same Quarters of Each Year Seasonal Factor Deseasonalized demand (ya Deseosonalized Forecast (Y) Forecast(Y) 1 1 2 3 4 5 6 7 8 11 HII IV 1 2 3 4 5 1.67 2.35 1.11 1.15 1.56 2.04 1.14 0.38 0.20 -0.18 -0.97 0.20 -1.54 0.30 6 7 O IV 1 1 HII IV 1 10 11 12 13 14 15 16 17 18 19 20 11 12 13 14 15 16 17 18 19 20 IV - = IV Period (t) Quarter Actual Demand (y) Average of Same Quarters of Each Year Seasonal Deseasonalized Factor demand (y) Deseasonalized Forecast (Y) Forecast(Y) 1 2 3 4 5 7 8 9 1 II III IV 1 II III IV 1 II III IV 1 II III IV 1 II III TV 0.17 0.24 0.26 0.34 0.25 0.37 0.36 0.44 0.33 0.40 0.41 0.47 0.30 0.47 10 11 12 13 1 2 3 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 14 15 16 17 18 19 20 Comment on the company B