Purchase Solution

Not what you're looking for?

Apex Mutual fund invests primarily in technology stocks. The price of the fund at the end of each month for the 12 months are as follows:

January - 19.39
February - 18.96
March 18.20
April 17.89
May 18.43
June 19.98
July 19.51
August 20.63
sEPTEMBER 19.78
October 21.25
November 21.18
December 22.14

QUESTION: FIND THE FORECAST VALUE OF THE MUTUAL FUND FOR EACH MONTH BY USING THE NAIVE MODEL. THE VALUE FOR DECEMBER 1999 WAS. 19.00.

QUESTION: EVALUATE THE FORECAST USING MAD, MSE, MAPE AND MPE.

QUESTION: FORECAST THE MUTUAL PRICE FOR JANUARY 2001.

QUESTION: WRITE A MEMO SUMMARIZING YOUR FINDINGS.

I NEED ASSISTANCE IN LEARNING HOW TO FORECAST THE FUND FOR EACH MONTH USING THE NAIVE MODEL IN EXCEL. I ALSO NEED ASSISTANCE IN EVALUATING THE FORECASTING METHOD USING MAD, MSE, MAPE, MPE AND LASTLY, I NEED TO KNOW HOW TO FORECAST THE MUTUAL FUND FOR JANUARY 2001. IF YOU COULD ASSIST ME WITH A SIMILAR PROBLEM THAT I CAN FOLLOW IT IS GREATLY APPRECIATED. EXCEL FILE IS ATTACHED.

##### Solution Preview

1. There are many ways to forecast for the next period. I am using a method where , the actual price ...

Solution provided by:
###### Education
• BE, Bangalore University, India
###### Recent Feedback
• "What does 1 and 0 means in the repair column?"
• "Went through all of the formulas, excellent work! This really helped me!"
• "try others as well please"
• "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."

##### Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

##### SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.