The table below shows the closing monthly stock prices for Amazon.com and Google
ID: 2737658 • Letter: T
Question
The table below shows the closing monthly stock prices for Amazon.com and Google during 2011. Calculate the exponential three-month moving average for both stocks where two-thirds of the average weight is placed on the most recent price.
AMZN GOOG January $ 169.64 $ 600.36 February 173.29 613.40 March 180.13 586.76 April 195.81 544.10 May 196.69 529.02 June 204.49 506.38 July 222.52 603.69 August 215.23 540.96 September 216.23 515.04 October 213.51 592.64 November 192.29 599.39 December 173.10 645.90Explanation / Answer
March AMAZON = 169.64(1/6) + 173.29(1/6) + 180.13(2/3) = 28.273 + 28.882 + 120.087 =$177.242
OR
March AMAZON = (169.64 + 173.29) / 2 = 342.93/2 = $171.465
$171.465 x 0.333 = 57.098
$57.098 + (180.13 x .667) = $57.098 + 120.147 =$177.245
April AMAZON =173.29(1/6) + 180.13(1/6) + 195.81(2/3) = $189.443
April AMAZON =(173.29 + 180.13) / 2 = $176.71
$176.71 * 0.333 = $58.844
$58.844 + (195.81 * 0.667) = 58.844+130.605 =$189.449
May AMAZON = 180.13(1/6) + 195.81(1/6) + 196.69(2/3) = $193.783
May AMAZON =(180.13+195.81) / 2 = $187.97
$187.97 * 0.333 = $62.594
$62.594 + (196.69 * 0.667) = 62.594+131.192 =$193.786
June AMAZON =195.81(1/6) + 196.69(1/6) + 204.49(2/3) = $201.743
June AMAZON =(195.81+196.69) / 2 = $196.25
$196.25 * 0.333 = $65.351
$65.351 + (204.49 * 0.667) = 65.351+136.395 =$201.746
July AMAZON =196.69(1/6) + 204.49(1/6) + 222.52(2/3) = $215.21
July AMAZON =(196.69+204.49) / 2 = $200.59
$200.59 * 0.333 = $66.796
$66.796 + (222.52 * 0.667) = 66.796+148.421 =$215.217
August AMAZON =204.49(1/6) + 222.52(1/6) +215.23(2/3) = $214.655
August AMAZON =(204.49+222.52) / 2 = $213.505
$213.505 * 0.333 = $71.097
$71.097 + (215.23 * 0.667) = 71.097+143.558 =$214.655
September AMAZON =222.52(1/6) +215.23(1/6) + 216.23(2/3) = $217.112
September AMAZON =(222.52+215.23) / 2 = $218.875
$218.875 * 0.333 = $72.885
$72.885 + (216.23 * 0.667) = 72.885+144.225=$217.110
October AMAZON =215.23(1/6) + 216.23(1/6) + 213.51(2/3) = $214.25
October AMAZON =(215.23+216.23) / 2 = $215.73
$215.73 * 0.333 = $71.838
$71.838 + (213.51 * 0.667) = 71.838+142.411=$214.249
November AMAZON =216.23(1/6) + 213.51(1/6) + 192.29(2/3) = $199.817
November AMAZON =(216.23+213.51) / 2 = $214.87
$214.87 * 0.333 = $71.552
$71.552 + (192.29 * 0.667) =71.552+128.257=$199.809
December AMAZON =213.51(1/6) + 192.29(1/6) + 173.10(2/3) = $183.033
December AMAZON =(213.51+192.29) / 2 = $202.9
$202.9 * 0.333 = $67.565
$67.565 + (173.10 * 0.667) =67.565+115.458=$183.023
March GOOG = 600.36(1/6) + 613.40(1/6) + 586.76(2/3) =$593.467
OR
March GOOG = (600.36 + 613.40) / 2 = $606.88
$606.88 x 0.333 = 202.091
$202.091 + (586.76 x .667) = $202.091 + 391.369 =$593.460
April GOOG =613.40(1/6) + 586.76(1/6) + 544.10(2/3) = $562.76
April GOOG =(613.40+586.76) / 2 = $600.08
$600.08 * 0.333 = $199.827
$199.827 + (544.10 * 0.667) = 199.827+362.915 =$562.742
May GOOG =586.76(1/6) + 544.10(1/6) + 529.02(2/3) = $541.157
May GOOG =(586.76+544.10) / 2 = $565.43
$565.43 * 0.333 = $188.288
$188.288 + (529.02 * 0.667) = 188.288+352.856 =$541.144
june GOOG =544.10(1/6) + 529.02(1/6) + 506.38(2/3) = $516.44
june GOOG =(544.10+529.02) / 2 = $536.56
$536.56 * 0.333 = $178.674
$178.674 + (506.38 * 0.667) = 178.674+337.755 =$516.429
july GOOG = 529.02(1/6) + 506.38(1/6)+ 603.69(2/3) = $575.027
july GOOG =(529.02+506.38) / 2 = $517.7
$517.7 * 0.333 = $172.394
$172.394 + (603.69 * 0.667) = 172.394+402.661 =$575.055
august GOOG = 506.38(1/6)+ 603.69(1/6) + 540.96(2/3) = $545.652
august GOOG =(506.38+603.69) / 2 = $555.035
$555.035 * 0.333 = $184.827
$184.827 + (540.96 * 0.667) = 184.827+360.820 =$ 545.647
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.