Question

In: Finance

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 510.62 October 215.55 609.81 November 199.94 584.60 December 177.86 664.60

Solutions

Expert Solution

Answer:

The above excel with 'show formula':


Related Solutions

Problem 8-4 Exponential Moving Averages (LO4, CFA1) The table below shows the closing monthly stock prices...
Problem 8-4 Exponential Moving Averages (LO4, CFA1) 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 $ 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...
Problem 8-4 Exponential Moving Averages (LO4, CFA1) The table below shows the closing monthly stock prices...
Problem 8-4 Exponential Moving Averages (LO4, CFA1) 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 $ 175.64 $ 614.86 February 177.29 624.20 March 192.73 572.66 April 209.11 548.10 May 191.89 508.22 June 209.09 494.38 July 235.82 606.69 August...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT