Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. the table below shows the closing monthly stock pr

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

Free

80.2K

Verified Solution

Question

Finance

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$172.64$607.61
February175.29618.80
March186.43579.71
April202.46546.10
May194.29518.62
June206.79500.38
July229.17605.19
August209.08538.71
September218.63513.74
October214.11597.69
November194.54595.04
December174.50651.40
IBMAMZN
March
April
May
June
July
August
September
October
November
December

Answer & Explanation Solved by verified expert
3.5 Ratings (578 Votes)

3 months moving average is calculated by taking the average of every 3 months combination as shown in the below table:

  1. Average period = January, February, March
  2. Average period = February, March, April
  3. Average period = March, April, May
  4. Average period = April, May, June
  5. Average period = May, June, July
  6. Average period = June, July, August
  7. Average period =July, August, September
  8. Average period =August, September, October
  9. Average period =September, October, November
  10. Average period =October, November, December
IBM 3MA Amazon 3MA
January $172.64 January $607.61
February $175.29 February $618.80
March $186.43 (172.64+175.29+186.43)/3= $178.12 March $579.71 (607.61+618.8+579.71)/3= $602.04
April $202.46 (175.29+186.43+202.46)/3= $188.06 April $546.10 (618.8+579.71+546.1)/3= $581.54
May $194.29 (186.43+202.46+194.29)/3= $194.39 May $518.62 (579.71+546.1+518.62)/3= $548.14
June $206.79 (202.46+194.29+206.79)/3= $201.18 June $500.38 (546.1+518.62+500.38)/3= $521.70
July $229.17 (194.29+206.79+229.17)/3= $210.08 July $605.19 (518.62+500.38+605.19)/3= $541.40
August $209.08 (206.79+229.17+209.08)/3= $215.01 August $538.71 (500.38+605.19+538.71)/3= $548.09
September $218.63 (229.17+209.08+218.63)/3= $218.96 September $513.74 (605.19+538.71+513.74)/3= $552.55
October $214.11 (209.08+218.63+214.11)/3= $213.94 October $597.69 (538.71+513.74+597.69)/3= $550.05
November $194.54 (218.63+214.11+194.54)/3= $209.09 November $595.04 (513.74+597.69+595.04)/3= $568.82
December $174.50 (214.11+194.54+174.5)/3= $194.38 December $651.40 (597.69+595.04+651.4)/3= $614.71

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

Transcribed Image Text

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.)IBMAMZNJanuary$172.64$607.61February175.29618.80March186.43579.71April202.46546.10May194.29518.62June206.79500.38July229.17605.19August209.08538.71September218.63513.74October214.11597.69November194.54595.04December174.50651.40IBMAMZNMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember

Other questions asked by students

Q

uestion 14 V of 14 Step 1 of 1 s part of a green initiative...

Basic Math
Q

Evaluate the line integral C F · dr, where C is given by the vector function r(t). F(x, y, z)...

Basic Math
Q

(All answers were generated using 1,000 trials and native Excel functionality.) Grear Tire Company has produced a...

Basic Math
Q

A major property of all fermented foods is that they O Become drier O Are...

Biology
Q

from a long thread charged uniformly with linear charge density A r a The electric...

Physics
Q

Blinky s Beach Toy Emporium is selling novelty beach umbrellas with hilarious memes printed on...

Basic Math
Q

Meowmeow is operating her own clinic business, TH Chamber. The trial balance for TH Chamber...

Accounting
Q

As a recently hired accountant for a small business,SMC,Inc.,you are provided with last years balance...

Accounting
Q

Case 16-8 Frozen Ballooning Out of Control LLC (BLOC or the Company) is a manufacturer...

Accounting
Q

Souza Technology issued $4,000,000 of 6% bonds on August 1, 2019 in order to raise...

Accounting
Q

#2 needs fixing. Bill Padley expects to invest $10,000 for 25 years, after...

Accounting
Q

The Alford Group had 220,000 shares of common stock outstanding at January 1, 2018. The...

Accounting