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 2 years 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
- ***Convert the C++ to Python*** #include <iostream> using std::cout; using std::cin; using std::endl; int charClass; char...
- Make-or-Buy Decision Fremont Computer Company has been purchasing carrying cases for its portable computers at a...
- The following costs were incurred for the single product produced during the first year of operations...
- Non-constant growth model: Do=$2.00 required return on equity= 5% g= 9% n=1,2 g=7% n=3,4 g=3% n=5...
- . Find all x ∈ Z143 such that x2Ξ 7 (mod 143). Please explain all steps...
- #Python: A palindrome is a sequence of characters that reads the same backwards as forwards. For...
- Explain an example in which a variable has two different addresses at different places in a...
ADVERTISEMENT