Forecast the fund price for month 21

Assignment Help Financial Management

Reference no: EM131341732

Mary Hernandez has invested in a stock mutual fund and she is considering liquidating and investing in a bond fund. She would like to forecast the price of the stock fund for the next month before making a decision. She has collected the following data on the average price of the fund during the past 20 months.

Month	Fund Price	Month	Fund Price
1	63 1/4	11	68 1/8
2	60 1/8	12	63 1/4
3	61 3/4	13	64 3/8
4	64 1/4	14	68 5/8
5	59 3/8	15	70 1/8
6	57 7/8	16	72 3/4
7	62 1/4	17	74 1/8
8	65 1/8	18	71 3/4
9	68 1/4	19	75 1/2
10	65 1/2	20	76 3/4

a. Using a three-month moving average, forecast the fund price for month 21.

b. Using a three-month weighted average with the most recent month weighted 0.60, the next most recent month weighted 0.30, and the third month weighted 0.10, forecast the fund price for month 21.

c. Compute an exponentially smoothed forecast using α = 0.40 and forecast the fund price for month 21.

d. Compare the forecasts in (a), (b), and (c) using MAD and indicate the most accurate.

Reference no: EM131341732

Questions Cloud

What was the firm free cash flow : Everest Inc. recently reported $202,500 of sales, $145,200 of operating costs other than depreciation, and $9,775.00 of depreciation. The company had $35,250 of outstanding bonds that carry a 6.75% interest rate, and its federal-plus-state income tax..

Who are the people you usually associate with at work : What are the problems or challenges you deal with (money, health, family, etc). Who are the people you usually associate with (at work, at play, friends, neighbors). Where are you going ( to what kind of future, what plans for your life).

Six marketing and advertising strategies : Write a two-page reflection paper by recommending at least six marketing and advertising strategies (concepts) and explaining how each strategy would strengthen the brand for an e-commerce site.

About the cost of common equity : The future earnings, dividends, and common stock price of Callahan Technologies Inc. are expected to grow 4% per year. Callahan's common stock currently sells for $25.50 per share; its last dividend was $2.50; and it will pay a $2.60 dividend at the ..

Forecast the fund price for month 21 : Using a three-month weighted average with the most recent month weighted 0.60, the next most recent month weighted 0.30, and the third month weighted 0.10, forecast the fund price for month 21.

Why we should have cause for concern regarding bioethical : HE 485W:Please explain why we should have cause for concern regarding the Bioethical issues facing us in today's modern contemporary Society.When does an individuals' right to choose begin to threaten the autonomy of others? Likewise, when does the q..

Create a static property of the class to access them : Add a static method in class StudentTest, which creates several objects of type Student and store them in static fields. Create a static property of the class to access them. Write a test program, which displays the information about them in the c..

Complete the two annual after-tax rates of return columns : George inherited $100,000 with the stipulation that he invest it to financially benefit his family. George and Alice decided they would in invest the inheritance to help them accomplish two financial goals: Complete the two annual after-tax rates of ..

Write essay paper which is about effects of eating junk food : Write an essay paper 3 to 5 pges which is about Effects of eating junk food with outline and i will upload picture and there are few things you need it for the outline.

User Account

All Pages