Question

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 $ 173.24 $ 609.06 February 175.69 619.88 March 187.69 578.30 April 203.79 546.50 May 193.81 516.54 June 207.25 499.18 July 230.50 605.49 August 207.85 538.26 September 219.11 513.48 October 214.23 598.70 November 194.99 594.17 December 174.78 652.50

Homework Answers

Answer #1

Solution :

Here,

We can find the simple three - month moving average for each month for both companies as follows

For IBM :

Simple three-month moving average at the end of march = ( 173.24 + 175.69 + 187.69 ) / 3 =  178.87

Similarly we can find for others as follows :

Months IBM Amazon Average ( IBM ) Average ( Amazon )
January 173.24 609.06
February 175.69 619.88
March 187.69 578.30 178.87 602.41
April 203.79 546.50 189.06 581.56
May 193.81 516.54 195.10 547.11
June 207.25 499.18 201.62 520.74
July 230.50 605.49 210.52 540.40
August 207.85 538.26 215.20 547.64
September 219.11 513.48 219.15 552.41
October 214.23 598.70 213.73 550.15
November 194.99 594.17 209.44 568.78
December 174.78 652.50 194.67 615.12
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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 $ 175.04 $ 613.41 February 176.89 623.12 March 191.47 574.07 April 207.78 547.70 May 192.37 510.30 June 208.63 495.58 July 234.49 606.39 August 204.16 536.91 September 220.55 512.70 October 214.59 601.73 November 196.34 591.56...
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 $ 173.84 $ 610.51 February 176.09 620.96 March 188.95 576.89 April 205.12 546.90 May 193.33 514.46 June 207.71 497.98 July 231.83 605.79 August 206.62 537.81 September 219.59 513.22 October 214.35 599.71 November 195.44 593.30...
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 $ 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...
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 $ 174.44 $ 611.96 February 176.49 622.04 March 190.21 575.48 April 206.45 547.30 May 192.85 512.38 June 208.17 496.78 July 233.16 606.09 August 205.39 537.36 September 220.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 $ 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...
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 $ 170.84 $ 603.26 February 174.09 615.56 March 182.65 583.94 April 198.47 544.90 May 195.73 524.86 June 205.41 503.98 July 225.18 604.29 August 212.77 540.06 September 217.19 514.52 October 213.75...
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 $ 175.04 $ 613.41 February 176.89 623.12 March 191.47 574.07 April 207.78 547.70 May 192.37 510.30 June 208.63 495.58 July 234.49 606.39 August 204.16 536.91 September 220.55 512.70 October 214.59...
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 $ 178.04 $ 620.66 February 178.89 628.52 March 197.77 567.02 April 214.43 549.70 May 189.97 499.90 June 210.93 489.58 July 241.14 607.89 August 198.01 534.66 September 222.95 511.40 October 215.19...
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 $ 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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT