In: Finance
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 | 191.86 | 532.41 | |||||
September | 225.35 | 510.10 | |||||
October | 215.79 | 611.83 | |||||
November | 200.84 | 582.86 | |||||
December | 178.42 | 666.80 | |||||
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 | 191.86 | 532.41 | |||||
September | 225.35 | 510.10 | |||||
October | 215.79 | 611.83 | |||||
November | 200.84 | 582.86 | |||||
December | 178.42 | 666.80 | |||||
IBM AMZN
March
April
May
June
July
August
September
October
November
December
IBM | AMAZON | ||||
January | 181.04 | 627.91 | |||
February | 180.89 | 181.02 | 633.92 | 628.91 | |
March | 204.07 | 184.75 | 559.97 | 621.60 | |
April | 221.08 | 206.91 | 551.70 | 558.59 | |
May | 187.57 | 215.50 | 489.50 | 541.33 | |
June | 213.23 | 191.85 | 483.58 | 488.51 | |
July | 247.79 | 218.99 | 609.39 | 504.55 | |
August | 191.86 | 238.47 | 532.41 | 596.56 | |
September | 225.35 | 197.44 | 510.10 | 528.69 | |
October | 215.79 | 223.76 | 611.83 | 527.06 | |
November | 200.84 | 213.30 | 582.86 | 607.00 | |
December | 178.42 | 197.10 | 666.80 | 596.85 |