Question
In: Finance
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.)
| IBM | AMZN | ||||||
| January | $ | 172.04 | $ | 606.16 | |||
| February | 174.89 | 617.72 | |||||
| March | 185.17 | 581.12 | |||||
| April | 201.13 | 545.70 | |||||
| May | 194.77 | 520.70 | |||||
| June | 206.33 | 501.58 | |||||
| July | 227.84 | 604.89 | |||||
| August | 210.31 | 539.16 | |||||
| September | 218.15 | 514.00 | |||||
| October | 213.99 | 596.68 | |||||
| November | 194.09 | 595.91 | |||||
| December | 174.22 | 650.30 | |||||
Solutions
Expert Solution
3
1. Month simple average of march IBM = (Jan Price + Feb price + march price) / 3
Month simple average of march IBM = (172.04 + 174.89 + 185.17) / 3 = $177.37
the same process follows for all the other months
jeff jeffy answered 1 year agoRelated Solutions
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM
and Amazon. Calculate the simple three-month moving average for
each month for both companies. (Input all amounts as
positive values. Do not round intermediate calculations. Round your
answers to 2 decimal places.)
IBM
AMZN
January
$
181.04
$
627.91
February
180.89
633.92
March
204.07
559.97
April
221.08
551.70
May
187.57
489.50
June
213.23
483.58
July
247.79
609.39
August
191.86
532.41
September
225.35
510.10
October
215.79
611.83
November
200.84
582.86...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM
and Amazon. Calculate the simple three-month moving average for
each month for both companies. (Input all amounts as
positive values. Do not round intermediate calculations. Round your
answers to 2 decimal places.)
IBM
AMZN
January
$
180.44
$
626.46
February
180.49
632.84
March
202.81
561.38
April
219.75
551.30
May
188.05
491.58
June
212.77
484.78
July
246.46
609.09
August
193.09
532.86
September
224.87
510.36
October
215.67
610.82
November
200.39
583.73...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM
and Amazon. Calculate the simple three-month moving average for
each month for both companies. (Input all amounts as
positive values. Do not round intermediate calculations. Round your
answers to 2 decimal places.)
IBM
AMZN
January
$
170.24
$
601.81
February
173.69
614.48
March
181.39
585.35
April
197.14
544.50
May
196.21
526.94
June
204.95
505.18
July
223.85
603.99
August
214.00
540.51
September
216.71
514.78
October
213.63
593.65
November
192.74
598.52...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM
and Amazon. Calculate the simple three-month moving average for
each month for both companies. (Input all amounts as
positive values. Do not round intermediate calculations. Round your
answers to 2 decimal places.)
IBM
AMZN
January
$
181.04
$
627.91
February
180.89
633.92
March
204.07
559.97
April
221.08
551.70
May
187.57
489.50
June
213.23
483.58
July
247.79
609.39
August
191.86
532.41
September
225.35
510.10
October
215.79
611.83
November
200.84
582.86...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM
and Amazon. Calculate the simple three-month moving average for
each month for both companies. (Input all amounts as
positive values. Do not round intermediate calculations. Round your
answers to 2 decimal places.)
IBM
AMZN
January
$
172.64
$
607.61
February
175.29
618.80
March
186.43
579.71
April
202.46
546.10
May
194.29
518.62
June
206.79
500.38
July
229.17
605.19
August
209.08
538.71
September
218.63
513.74
October
214.11
597.69
November
194.54
595.04...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...
The table below shows the closing monthly stock prices for IBM
and Amazon. Calculate the simple three-month moving average for
each month for both companies. (Input all amounts as
positive values. Do not round intermediate calculations. Round your
answers to 2 decimal places.)
IBM
AMZN
January
$
178.64
$
622.11
February
179.29
629.60
March
199.03
565.61
April
215.76
550.10
May
189.49
497.82
June
211.39
488.38
July
242.47
608.19
August
196.78
534.21
September
223.43
511.14
October
215.31
607.79
November
199.04
586.34...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential...
The table below shows the closing monthly stock prices for IBM
and Amazon. Calculate the exponential three-month moving average
for both stocks where two-thirds of the average weight is placed on
the most recent price. (Do not round intermediate
calculations. Round your answers to 2 decimal places.)
IBM
AMZN
January
$
177.44
$
619.21
February
178.49
627.44
March
196.51
568.43
April
213.10
549.30
May
190.45
501.98
June
210.47
490.78
July
239.81
607.59
August
199.24
535.11
September
222.47
511.66
October
215.07...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential...
The table below shows the closing monthly stock prices for IBM
and Amazon. Calculate the exponential three-month moving average
for both stocks where two-thirds of the average weight is placed on
the most recent price. (Do not round intermediate
calculations. Round your answers to 2 decimal places.)
IBM
AMZN
January
$
172.64
$
607.61
February
175.29
618.80
March
186.43
579.71
April
202.46
546.10
May
194.29
518.62
June
206.79
500.38
July
229.17
605.19
August
209.08
538.71
September
218.63
513.74
October
214.11...
The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential...
The table below shows the closing monthly stock prices for IBM
and Amazon. Calculate the exponential three-month moving average
for both stocks where two-thirds of the average weight is placed on
the most recent price. (Do not round intermediate
calculations. Round your answers to 2 decimal places.)
IBM
AMZN
January
$
172.64
$
607.61
February
175.29
618.80
March
186.43
579.71
April
202.46
546.10
May
194.29
518.62
June
206.79
500.38
July
229.17
605.19
August
209.08
538.71
September
218.63
513.74
October
214.11...
Problem 8-3 Simple Moving Averages (LO4, CFA1) The table below shows the closing monthly stock prices...
Problem 8-3 Simple Moving Averages (LO4, CFA1) The table below
shows the closing monthly stock prices for IBM and Amazon.
Calculate the simple three-month moving average for each month for
both companies. (Input all amounts as positive values. Do not round
intermediate calculations. Round your answers to 2 decimal places.)
IBM AMZN January $ 179.84 $ 625.01 February 180.09 631.76 March
201.55 562.79 April 218.42 550.90 May 188.53 493.66 June 212.31
485.98 July 245.13 608.79 August 194.32 533.31 September 224.39...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Let (G,+) be an abelian group and U a subgroup of G. Prove that G is...
- New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line....
- The following information is available about the company: a. All sales during the year were on...
- Prepare a project charter for the Health Coverage Costs Business Model project using the project charter...
- Consider the following information: Cash Flows ($) Project C0 C1 C2 C3 C4 A –6,000 2,000...
- True or false. No explanation needed 1. The basic purpose of antitrust law is to restrict...
- Discuss the major issues in teaching and supervising students in clinical practice.(20 Marks)
ADVERTISEMENT