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

Basic Math
1.2K views

Imagine a class where nearly everyone scores between 83-84%, with hardly any dispersion beyond this narrow...

Operations Management
1.2K views

What’s the best strategy you would recommend an organization use to avoid making this mistake in...

Medical Sciences
1.2K views

What advantages might there be for infants to be born with more nerve cells (neurons) than...

Biology
1.2K views

According to UNAIDS how many AIDS related adult and child deaths occurred worldwide in 2020...

Physics
1.2K views

In the classic Meselson and Stahl experiment E coli are first grown in 15N enriched...

Physics
1.2K views

An empty cylindrical beaker of mass m and radius r and negligible thickness has its...

Calculus
1.2K views

function completely 3 f x x 2x 5x 6 Zero x 3 imions of which...

Accounting
1.2K views

Use the following data to calculate the cost of goods sold for the...

Accounting
1.2K views

Peyton approved general journal entries

Accounting
1.2K views

The adjusted trlal balance for Tybalt Construction on December 31 of the current year follows....

Finance
1.2K views

Suncor is a Canadian company that exports to UK. The company will receive GBP 100,000...

Finance
1.2K views

Restrictive covenants include all of the following except: Question 16 options: ...