BUSINESS FORECASTING

Buy ready-to-submit essays. No Plagiarism Guarantee

Note: Our papers are 100% human-written.

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. © BrainMass Inc. brainmass.com March 21, 2019, 10:30 am ad1c9bdddf
https://brainmass.com/business/business-management/business-forecasting-16031

Attachments

• forecasting-apex mutual fund.xls

Solution Preview

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