Question

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.) January February March April MAY June July August September October November December IBM AMZN $ 175.04 $ 613.41 176.89 623.12 191.47 574.07 207.78 547.70 192.37 510.30 208.63 495.58 234.49 606.39 204.16 536.91 220.55 512.70 214.59 501.73 196.34 591.56 175.62655.80 IBM AMZN March April May June July August September October November December

Answer 1

- D A B C D 1 Date IBM AMZN IBM AMZN 2 January | $175.04 $613.41 3 February $176.89 $623.12 March $191.47 $574.07 $ 186.30 $ 588.80 5 April $207.78 $547.70 $ 199.91 $ 564.67 6 May $192.37 $510.30 $ 194.79$ 527.16 7 June $208.63 $495.58 $ 205.78 $ 506.72 8 July $234.49 $606.39 $ 223.16 $ 571.91 9 August | $204.16 $536.91 $ 209.96 $ 541.60 10 September $220.55 $512.70 $ 220.14 $ 532.35 11 October $214.59 $601.73 $ 213.85 $ 576.09 12 November $196.34 $591.56 $ 203.42 $ 580.11 13 December $175.62 $655.80 $ 185.57 $ 636.08

D AMZN w A B C 1 Date IBM AMZN IBM 2 January 175.04 613.41 February 176.89 623.12 4 March 191.47 574.07 =+B2/6+B3/6+B4*2/3 5 April 207.78 547.7 =+B3/6+B4/6+B5*2/3 192.37 510.3 =+B4/6+B5/6+B6*2/3 208.63 495.58 =+B5/6+B6/6+B7*2/3 8 July 234.49 606.39 =+B6/6+B7/6+B8*2/3 August 204.16 536.91 =+B7/6+B8/6+B9*2/3 10 September 220.55 512.7 =+B8/6+B9/6+B10*2/3 11 October 214.59 | 601.73 |=+B9/6+B10/6+B11*2/3 | 12 November 196.34 591.56 =+B10/6+B11/6+B12*2/3 13 December 175.62 655.8 =+B11/6+B12/6+B13*2/3 June cou =+C2/6+C3/6+C4*2/3 =+C3/6+C4/6+C5*2/3 =+C4/6+C5/6+C6*2/3 =+C5/6+C6/6+C7*2/3 =+C6/6+C7/6+C8*2/3 =+C7/6+C8/6+C9*2/3 =+C8/6+C9/6+C10*2/3 =+C9/6+C10/6+C11*2/3 =+C10/6+C11/6+C12*2/3 =+C11/6+C12/6+C13*2/3

*Please rate thumbs up