Here are comings per share for two companies by quarter from the first quarter of three years ago through the second quarter of this year. Forecast samninga per share for the rest of Nis year and next year. Um exponential smoothing to forecast the third period of this year, and the time series de composition method to forecast the last two quiers of this year and il four quarters of ext year. (it la much else to solve the problem on a computer spreadsheet so you can see what is happening) 3 years ago QUARTER 1 021 2 years ago 1 FARNINOS PER SHARE COMPANY A COMPANY $162 $0.19 2.39 0.24 1.14 1218 0.35 1.58 0.22 202 0.31 1.17 032 0.27 0.43 0.27 035 -0.21 ) 0.44 -0.05 ) 0.45 0.30 0.46 (ss) 020 032 0.46 at your 1 For the exponential smoothing method, choose the first quarter of 3 years ago as the beginning forecast. Make two force one with a = 0.10 and one with a 0:30. (Negative values should be indicated by minus sign. Round your answers to 3 decimal places) Quar Company Forecast Forecast -0.10 CH 0.30 1.62 12 Forecast 0.10 0.19 Company Force 30 0.10 0,19 3 years ago 162 100 0.19 0.20 189 1.60 021 IV 1.54 119 021 0.20 021 2 years ago 1 140 1.58 0.25 024 0.21 1. 1.58 10 0.26 183 0 22 1.67 1.52 0.28 1.50 145 1.14 Last year 0.23 0.25 0.26 028 0.88 0.33 033 0.38 1.18 0 55 97 010 030 0.31 0.30 041 0.16 90 yar Copery OR Quarter 3 years ago Furcast 0.10 0.19 0.10 020 020 030 0.19 0.19 III 0.21 021 N 1 Company For GR0.30 1.62 1.02 1.62 162 1.89 180 164 100 156 1.49 150 1.12 1.69 1.67 1.50 1.82 1.46 1.14 1.14 on 2 years ago 0.21 1 0.21 iu 0.26 0.24 0.26 0.20 0.33 0.22 0.23 0.25 0.20 IV al you 1 033 030 1.10 OT M 0.30 0.56 0.10 0.16 -0.30 Ne year 00 0.26 0.30 0.31 0.30 0.39 041 006 35 62 0.10 03 b-1. Calculate the MAD for each forecast using a starting with second care of years ago through second quarter of this year. Round your answers to decimal places) MAD Company 0.0.10 11 -2. Using the MAD method of testing the forecasting model's performance, plus actual data from 3 years ago through the second quarter of this year, how well did the model perform? Based on MAD, an of 43 performs better than ang of a c. Using the decomposition of a time series method of forecasting, forecast earings per share for the last two quarters of this year and all our quarters of next year. Negative valors should be indicated to minus sign. Round your answers to 3 decimal places) Com Seasonal Factor Compare Seasonal Foto Foreca Quarter Forecast BE 0.16 032 6.38 b-1. Calculate the MAD for each forecast using data starting with second quarter of 3 years ago through second quarter of this year. (Round your answers to 3 decimal places) WO Company Company 0.10 =0.30 De b-2. Using the MAD method of testing the forecasting modelu performance, plus actu data from 3 years ago through the woond quarter of this year, how wel did the model perform? Based on MAD, an a of 03 performs better than an aof 01 c. Using the decompostion of a time series method of forecasting, forecast earnings per share for the last two quarters of this year and all four quarters of next year. (Negative value should be indicated by a minus sign. Round your answers to 3 decimal places) Company Sa Factor Forecast Company Bon Factor QUR Forecast this year ned your 1 It MV d. Using your forecasts, comment on each company Company A's EPS is a lot Company B EPS is an inte References Book & Resources Worksheet Dan Problem 3.29 MacBook Air Here are comings per share for two companies by quarter from the first quarter of three years ago through the second quarter of this year. Forecast samninga per share for the rest of Nis year and next year. Um exponential smoothing to forecast the third period of this year, and the time series de composition method to forecast the last two quiers of this year and il four quarters of ext year. (it la much else to solve the problem on a computer spreadsheet so you can see what is happening) 3 years ago QUARTER 1 021 2 years ago 1 FARNINOS PER SHARE COMPANY A COMPANY $162 $0.19 2.39 0.24 1.14 1218 0.35 1.58 0.22 202 0.31 1.17 032 0.27 0.43 0.27 035 -0.21 ) 0.44 -0.05 ) 0.45 0.30 0.46 (ss) 020 032 0.46 at your 1 For the exponential smoothing method, choose the first quarter of 3 years ago as the beginning forecast. Make two force one with a = 0.10 and one with a 0:30. (Negative values should be indicated by minus sign. Round your answers to 3 decimal places) Quar Company Forecast Forecast -0.10 CH 0.30 1.62 12 Forecast 0.10 0.19 Company Force 30 0.10 0,19 3 years ago 162 100 0.19 0.20 189 1.60 021 IV 1.54 119 021 0.20 021 2 years ago 1 140 1.58 0.25 024 0.21 1. 1.58 10 0.26 183 0 22 1.67 1.52 0.28 1.50 145 1.14 Last year 0.23 0.25 0.26 028 0.88 0.33 033 0.38 1.18 0 55 97 010 030 0.31 0.30 041 0.16 90 yar Copery OR Quarter 3 years ago Furcast 0.10 0.19 0.10 020 020 030 0.19 0.19 III 0.21 021 N 1 Company For GR0.30 1.62 1.02 1.62 162 1.89 180 164 100 156 1.49 150 1.12 1.69 1.67 1.50 1.82 1.46 1.14 1.14 on 2 years ago 0.21 1 0.21 iu 0.26 0.24 0.26 0.20 0.33 0.22 0.23 0.25 0.20 IV al you 1 033 030 1.10 OT M 0.30 0.56 0.10 0.16 -0.30 Ne year 00 0.26 0.30 0.31 0.30 0.39 041 006 35 62 0.10 03 b-1. Calculate the MAD for each forecast using a starting with second care of years ago through second quarter of this year. Round your answers to decimal places) MAD Company 0.0.10 11 -2. Using the MAD method of testing the forecasting model's performance, plus actual data from 3 years ago through the second quarter of this year, how well did the model perform? Based on MAD, an of 43 performs better than ang of a c. Using the decomposition of a time series method of forecasting, forecast earings per share for the last two quarters of this year and all our quarters of next year. Negative valors should be indicated to minus sign. Round your answers to 3 decimal places) Com Seasonal Factor Compare Seasonal Foto Foreca Quarter Forecast BE 0.16 032 6.38 b-1. Calculate the MAD for each forecast using data starting with second quarter of 3 years ago through second quarter of this year. (Round your answers to 3 decimal places) WO Company Company 0.10 =0.30 De b-2. Using the MAD method of testing the forecasting modelu performance, plus actu data from 3 years ago through the woond quarter of this year, how wel did the model perform? Based on MAD, an a of 03 performs better than an aof 01 c. Using the decompostion of a time series method of forecasting, forecast earnings per share for the last two quarters of this year and all four quarters of next year. (Negative value should be indicated by a minus sign. Round your answers to 3 decimal places) Company Sa Factor Forecast Company Bon Factor QUR Forecast this year ned your 1 It MV d. Using your forecasts, comment on each company Company A's EPS is a lot Company B EPS is an inte References Book & Resources Worksheet Dan Problem 3.29 MacBook Air