Question: Question 1 (50 points). Apex Mutual Fund invests primarily in technology stocks. The revenue of the fund at the end of each quarter for the

Question 1 (50 points). Apex Mutual Fund invests primarily in technology

Question 1 (50 points). Apex Mutual Fund invests primarily in technology stocks. The revenue of the fund at the end of each quarter for the past three years is shown in the table below. Year Quarter Revenue 2019 Q1 15.58 Q2 16.88 Q3 16.99 Q4 17.37 2020 Q1 16.18 Q2 17.67 Q3 18.35 Q4 18.54 2021 Q1 17.02 Q2 18.99 Q3 19.78 Q4 19.43 (a) Use the Naive 5 model (t+1 = Y-3 + 91-44-4) to forecast the revenue for the four quarters of 2021. Compute the MSD of the forecast. (b) Use the MA(4) model to forecast the revenue for the four quarters of 2021. Compute the MSD of the forecast. 1 (c) Use (Holt's) double exponential smoothing method to forecast the revenue for the four quarters of 2021. In your calculations set a = 0.4 and B = 0.5. For the initial values set L2020Q3 = Y202003 and T202023 = 1. Compute the MSD of the forecast. (d) Based on your analyses in parts (a)-(c), suggest the best forecasting method to use for Apex Mutual Fund. Explain. Question 1 (50 points). Apex Mutual Fund invests primarily in technology stocks. The revenue of the fund at the end of each quarter for the past three years is shown in the table below. Year Quarter Revenue 2019 Q1 15.58 Q2 16.88 Q3 16.99 Q4 17.37 2020 Q1 16.18 Q2 17.67 Q3 18.35 Q4 18.54 2021 Q1 17.02 Q2 18.99 Q3 19.78 Q4 19.43 (a) Use the Naive 5 model (t+1 = Y-3 + 91-44-4) to forecast the revenue for the four quarters of 2021. Compute the MSD of the forecast. (b) Use the MA(4) model to forecast the revenue for the four quarters of 2021. Compute the MSD of the forecast. 1 (c) Use (Holt's) double exponential smoothing method to forecast the revenue for the four quarters of 2021. In your calculations set a = 0.4 and B = 0.5. For the initial values set L2020Q3 = Y202003 and T202023 = 1. Compute the MSD of the forecast. (d) Based on your analyses in parts (a)-(c), suggest the best forecasting method to use for Apex Mutual Fund. Explain

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Below are some key facts about Hillsburg Hardware and Ben & James, the paint manufacturer, Hillsburg is considering purchasing. Hillsburg Hardware Limited Hillsburg Stores Ltd. began operations in...

Could you please do G-E For G can you please enter the formula inputs so I can follow along. Thank you Problem 1 (15 points) Apex Mutual Fund invests primarily in technology stocks. The price of the...

6. Apex Mutual Fund invests primarily in technology stocks. The price of the fund at the end of each month for the 12 months of 2006 is shown in Table P-6. a. Find the forecast value of the mutual...

Apex Mutual Fund invests primarily in technology stocks. The price of the fund at the end of each month for the 1 2 months of 2 0 0 6 is shown in Table P - 6 . a . Find the forecast value of the...

give correct only678 16. Consider three stocks: Q. R and S. Beta STD (annual) Forecast for Nov 2008 Dividend Stock Price Q 0.45 35% $0.50 $45 R 1.45 10% 0 $75 S -0.20 40% $1.00 $20 33 2008, Andrew W....

(a) Use the Naive 4 model (Yt+1 = Yt3) to forecast the revenue for the four quarters of 2019. Compute the MSD of the forecast. (b) Use the MA(4) model to forecast the revenue for the four quarters of...

I need the following homework exercise completed. All of the information is within the attached files. I require no explanations, just the answers. Part 1: Finding information: Each of the following...

Part 1: Finding information: Each of the following questions should be answered within the table provided in file entitled "PART 1 TABLE." American Eagle's 2009 10-K is in the file entitled...

Business, Management Whole Foods Market's Generic & Intensive Growth Strategies Updated Sep 16, 2015 Andrew Thompson Whole Foods Market generic strategy, intensive growth strategies, Porter model,...

I need an accounting quality analysis of financial statements of At&t. Identify key accounting policies, assess accounting flexibility within key accounting policies, evaluate accounting strategy,...

Hello, I have assessment.. Step 1 : Calculate the following ratios for the latest five years using the O-S Checklist Approach, an Excel template . For an overview of the approach, read our article,...

John Jones owns and manages a cafe in Collegetown whose annual revenue is $5,000. Annual expenses are as follows: Labor$2,000 Food and drink500 Electricity..100 Vehicle lease150 Rent..500 Interest on...

Strategic Management Accounting (SMA) first coined by Simmonds in 1981, has been proposed during 1990s as a solution to the Lost Relevance of Management Accounting. In the new century, Shank (2007)...

What is the name of the new Association of professional accountans

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...