(Steps Shown) Here are the earnings per share for two companies by quarter from he first quarter of 2004 through the second of 2007. forecast earnings per
Question: Here are the earnings per share for two companies by quarter from he first quarter of 2004 through the second of 2007. forecast earnings per share for the rest of 2007 and 2008. use exponential smoothing to forecast the third period of 2007, and the time series decomposition method to forecast the last two quarters of 2007 and all four quarters of 2008.
| Earnings Per Share | |||
| quarter | company A | company B | |
| 2004 | 1 | $1.67 | $0.17 |
| 2 | 2.35 | 0.24 | |
| 3 | 1.11 | 0.26 | |
| 4 | 1.15 | 0.34 | |
| 2005 | 1 | 1.56 | 0.25 |
| 2 | 2.04 | 0.37 | |
| 3 | 1.14 | 0.36 | |
| 4 | 0.38 | 0.44 | |
| 2006 | 1 | 0.29 | 0.33 |
| 2 | -0.18 | 0.40 | |
| 3 | -0.97 | 0.41 | |
| 4 | 0.20 | 0.47 | |
| 2007 | 1 | -1.54 | 0.30 |
| 2 | 0.38 | 0.47 | |
- for the exponential smoothing method, choose the first quarter of 2004 as the beginning forecast. Make two forecasts: one with \[\alpha \] =0.10 and one with \[\alpha \] =0.30.
- using the MAD method of testing the forecasting model’s performance, plus actual data from 2004 through the second quarter of 2007, how well did the model perform.
- using the decomposition of a time series method of forecasting, forecast earnings per share for the last two quarters of 2007 and all four quarters of 2008. is there a seasonal facto in the earnings?
- using the forecasts, comment on each company.
Price: $2.99
Solution: The downloadable solution consists of 7 pages
Deliverable: Word Document 