Create a 4 period moving average forecast

Assignment Help Financial Management
Reference no: EM131312922

a. Create a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data.

b. Calculate the MSE and MAD for each.

c. Plot the original series, and each of the forecasts.

d. Create forecasts for 2014 using each of these three techniques. If you had to choose one of these, which would you choose and why?

e. Given your data, and this time period, would you prefer to try some other type of forecast, or modify the data in some way? (You must explain your answer for full credit.)

Attachment:- State-QPI-2004.rar

Reference no: EM131312922

Questions Cloud

Proposals according to a standard format : Why would a customer give contractors instructions in the RFP to submit their proposals according to a standard format?
What would be the complexity if the list were sorted : Given an unsorted list of n values, what is the time-complexity to find the kth smallest value in the worst case? What would be the complexity if the list were sorted?
What effects or details did the designer ignore : 55 - 7947 Equipment Engineering and Design Structural Failure Problem. A 6 ton pressure vessel - see dimensioned drawing - was being lowered onto a "stillage"or temporary supporting structure for testing outside a factory in the open yard. Why did ..
Proprietorship or partnership to become a corporation : What do you give up as an owner of a proprietorship or partnership to become a corporation? What does it mean to you as an owner to have limited or unlimited liability? How does a corporation differ when a stockholder or manager dies compared to when..
Create a 4 period moving average forecast : Create a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data.
Think about a specific healthcare organization : Think about a specific healthcare organization: Are there any differences for creating an effective delivery system? Who are the important stakeholders in a healthcare delivery system?
What will stock price be in three years : The Jackson–Timberlake Wardrobe Co. just paid a dividend of $1.65 per share on its stock. The dividends are expected to grow at a constant rate of 5 percent per year indefinitely. Investors require a return of 12 percent on the company's stock. What ..
Describe the impact of product design on operations : Write a 1,050 to 1,400-word paper in which you describe the impact of product design on operations and supply chain strategy. Include the following:
Explain competency-base and traditional approach to training : Describe why the competencies of the past are not compatible with the competencies of the future for the global organization. Explain the competency-based and the traditional approach to training.

Reviews

Write a Review

Financial Management Questions & Answers

  What is the net present value of this project

You are analyzing a project with a 30-year lifetime, with the following characteristics: The project will require an initial investment of $20 million and additional investment of $5 million in year 10 and $5 million in year 20. What is the net prese..

  Defined as the par value of common stock

What is the maximum amount that Beta Corporation can pay in cash dividends, without impairing its legal capital, if it is headquarter in a U.S. state where capital is defined as the par value of common stock?

  Do the following data suggest that the high frequency

Do the following data suggest that the high-frequency modulation is an effective analgesic? Use both xˆ2 and zstatistics.

  What is your holding-period return

You buy a ten-year bond that has a 7.75% current yield and a 7.75% coupon (paid annually). In one year, promised yields to maturity have risen to 8.75%. What is your holding-period return?

  Make profit from the arbitrage opportunity

The forward price of wheat for delivery in three months is $3.90 per bushel, while the spot price is $3.60. The three-month interest rate in continuously compounded terms is 8% per annum. What is the strategy followed to make a profit from the arbitr..

  Treasuries due to mature in one year were yielding

Suppose that "0" coupon US treasuries due to mature in one year were yielding .39%, while "0" coupon US treasuries maturing in 2 years were yielding .83%. If you were a risk neutral investor who wanted to choose between these bonds the one that offer..

  Semiannual interest payments

A bond has a $1,000 par value, semiannual interest payments of $40, and a current market value of $1,054. The bonds mature in 12.5 years. The coupon rate is _____ percent, the current yield is _____ percent, and the yield to maturity is _____ percent..

  Rate of inflation-treasury bond and treasury bill

Why is $100 today worth more to you than $100 in one year’s time even if the rate of inflation is zero? If interest rates rise, would you rather be holding a 30-year Treasury bond or a 90-day Treasury bill? Please explain. What is the yield to maturi..

  How much implicit interest would be earned on this bond

Assume a 20-year $1,000 par value zero-coupon bond with an annual YTM of 4% and semiannual compounding. How much implicit interest would be earned on this bond in year 1? How much in year 12?

  What is the intrinsic price of the stock

The University Building Company has fallen on hard times. Its management expects to pay no dividends for the next 3 years. However, the dividend for Year 4 will be $3.50 per share, and the dividend is expected to grow at a rate of 2 percent for Year ..

  Started making annual deposits

5 years ago you started making annual deposits of $362 into an account paying 7% annual return. You continue to make these deposits every year without fail. If you keep doing this every year for the next 5 years, how much money will you have in 5 yea..

  What was the company change in net working capital

The December 31, 2013, balance sheet of Maria’s Tennis Shop, Inc., showed current assets of $1,115 and current liabilities of $920. The December 31, 2014, balance sheet showed current assets of $1,330 and current liabilities of $1,005. What was the c..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd