Reference no: EM13789171
Forecasting Methods
Calculate and answer parts a through d. Include all calculations and spreadsheets in your post. Explain why the moving average method was used instead of another forecasting method. What might be another forecasting method that could prove to be just as useful?
The figures below indicate the number of mergers that took place in the savings and loan industry over a 12-year period.
Year Mergers Year Mergers
2000 46 2006 83
2001 46 2007 123
2002 62 2008 97
2003 45 2009 186
2004 64 2010 225
2005 61 2011 240
a. Calculate a 5-year moving average to forecast the number of mergers for 2012.
b. Use the moving average technique to determine the forecast for 2005 to 2011. Calculate measurement error using MSE and MAD.
c. Calculate a 5-year weighted moving average to forecast the number of mergers for 2012. Use weights of 0.10, 0.15, 0.20, 0.25, and 0.30, with the most recent year weighted being the largest.
d. Use regression analysis to forecast the number of mergers in 2012.
|
The patterns of volcanoes and earthquakes
: What is the difference between the older continental drift theory by Wegener and the more recent plate tectonic theory?
|
|
Holding period yield
: The YTM on a bond is the interest rate you earn on your investment if interest rates don't change. If you actually sell the bond before it matures, your realized return is known as the holding period yield (HPY).
|
|
Cash equal to the present value of the payments
: Pay $420 per month for 9 months and an additional $11,500 at the end of 9 months. The dealer is charging 24 percent per annum. When you buy the car, pay cash equal to the present value of the payments in option (a). Determine how much cash the dealer..
|
|
Application of attributes sampling in bakers procedures
: Describe each incorrect assumption, statement, and inappropriate application of attributes sampling in Baker's procedures.
|
|
Calculate measurement error using mse and mad
: Use the moving average technique to determine the forecast for 2005 to 2011. Calculate measurement error using MSE and MAD.
|
|
About the semi annual coupon bond
: Suppose your company needs to raise $45 million and you want to issue 30-year bonds for this purpose. Assume the required return on your bond issue will be 6 percent, and you're evaluating two issue alternatives: A semi annual coupon bond with a 6 pe..
|
|
When employees at abc corp need to order supplies they enter
: When employees at ABC Corp need to order supplies, they enter item data on a purchase requisition form (which is sent to supply requisition). A requisition clerk assigns a requisition number and stores the form in the requisition file. Before the req..
|
|
Identify person in medias spotlight who use logical fallacy
: Identify and research a person in the media's spotlight who has used a specific logical fallacy. Please be sure the thesis statement includes the logical fallacy you discuss in your paper, the person who used it
|
|
Recent annual financial statements
: Calculate the 14 ratios (show your calculations) for the company using the two most recent annual financial statements found on the financial information website you used earlier. Be careful not to use quarterly information, and include ratios for..
|