Question: I'm having trouble figuring out the formulas for these two. I need to do them in Excel, but i keep getting the wrong result. please

I'm having trouble figuring out the formulas for these two. I need to do them in Excel, but i keep getting the wrong result. please help!

2. Vidhya Balan is planning to liquidate her investments in mutual funds and invest in real estate. Before making the change in her investment strategy, Vidhya wants to forecast the price of mutual funds for the next 2 months. She has collected the following data on the average fund prices for the past 10 months: M 2 3 $ 1 9 10 55:10 538 53.40 52.95 $2.15 $2.755265 51.50 52.5 51.70 Average Fund Price nus dollars) 1. Using a five-period moving average, forecast the average fund price for Period 11. 2. Using exponential smoothing with a = 0.3, forecast the average fund price for Period 11. Assume an initial forecast for Month 6 (F6 ) as $52.15

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 General Management Questions!

This is all one question with several parts for my accounting homework. I've tried but I keep getting the wrong answer please help. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 if your formulas are...

PartII. Institutions The great conflict between capitalism and communism is over. Communism has collapsed; capitalism has won. Or so we think. But if you take a closer look at the structure of these...

Please help with equations and cell references needed Check Figure: NPV $1,112 in favor of overhauling the old truck REOUIREMENTS: - Complete the requirements for P12-28 on page 603 of your textbook....

This is use the Blue Spider case study. 1. Due to the case, what went wrong? 2. What and Why are the problems created? The Blue Spider Project "Tus is possible! Yet totally possible! Temos ago I was...

please read and answers the questions 1. What was the most interesting thing in the chapter to you? Why? 2. What in the chapter were you able to directly relate to your own communication...

Hi. I'm asked to take this class for graduation but I don't know how to do any of this. Please help me! I'm already devastated with the whole concept and Finance is new to me. Idk what I'm doing in...

\f 134 THE BIG SQUEEZE munications Workers of America that has sought to unionize high"tech workers. "They hire whomever Microsoft tells them to put on their payroll. Then they p~ocess their...

My chosen company is Adobe ! I have to create a training strategy to address the company needs. I am having trouble figuring out how to actually create the Training or Intervention Strategy. I have...

You need to make a presentation about SWOT Analysis of MEDNAX Inc. & ALIMERA Inc.

Prepare the adjusting entry to record bad debts under each separate assumption. No Required information [The following information applies to the questions displayed below.] At December 31, Hawke...

What is financial leverage, and the process of using debt to fund asset expansion for organizations?

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...