The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...

Free

90.2K

Verified Solution

Question

Accounting

The table below shows the closing monthly stock prices for IBMand Amazon. Calculate the simple three-month moving average foreach month for both companies. (Input all amounts aspositive values. Do not round intermediate calculations. Round youranswers to 2 decimal places.)

IBMAMZN
January$178.64$622.11
February179.29629.60
March199.03565.61
April215.76550.10
May189.49497.82
June211.39488.38
July242.47608.19
August196.78534.21
September223.43511.14
October215.31607.79
November199.04586.34
December177.30662.40
IBMAMZN
March
April
May
June
July
August
September
October
November
December

Answer & Explanation Solved by verified expert
3.7 Ratings (390 Votes)

IBM

AMZN
March      185.65      605.77
April      198.03      581.77
May      201.43      537.84
June      205.55      512.10
July      214.45      531.46
August      216.88      543.59
September      220.89      551.18
October      211.84      551.05
November      212.59      568.42
December      197.22      618.84

For 3 month moving average

--for the month of March, stock of Jan, Feb and March will be added and then divided by 3

--for April, stock of Feb, Mar and Apr will be added and divided by 3

--and so on


Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students