Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Garfield Financial invests primarily in energy stocks. The price of the fund at the end of each month for the 12 months of 2019 and

image text in transcribed
Garfield Financial invests primarily in energy stocks. The price of the fund at the end of each month for the 12 months of 2019 and the first two months of 2020 is shown in Table below. Use Excel and answer the following questions: a) Find the forecast value of the mutual fund for each month by using a naive model. The value for December 2018 was 20. b) Use a two-month moving average to forecast the mutual fund price for March 2020. c) Use a four-month moving average to forecast the mutual fund price for March 2020. d) Use a five-month weighted moving average to forecast the mutual fund price for March 2020. e) Use a six-month weighted moving average to forecast the mutual fund price for March 2020. f) Use exponential smoothing with a smoothing constant of 0.2 and an initial forecast value of 20 for January 2019 to forecast the price for March 2020. g) Use exponential smoothing with a smoothing constant of 0.1 and an initial forecast value of 20 for January 2019 to forecast the price for March 2020. h) Based on a-g what is your forecast for the mutual fund price for March 2020? Explain. Month Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mutual Fund Price 21 22 20 19 24 21 18 22 20 20 17 23 21 18

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Public Health And Not-for-Profit Organizations

Authors: Steven A. Finkler, Daniel L. Smith, Thad D. Calabrese, Robert M. Purtell

7th Edition

1071835335, 978-1071835333

More Books

Students also viewed these Finance questions

Question

Name the sources of revenues and costs for teams.

Answered: 1 week ago

Question

What is quality of work life ?

Answered: 1 week ago

Question

What is meant by Career Planning and development ?

Answered: 1 week ago

Question

What are Fringe Benefits ? List out some.

Answered: 1 week ago

Question

Define pay ranges. What is the purpose of establishing pay ranges?

Answered: 1 week ago