Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. the table below shows the closing monthly stock pr

The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential...

Free

80.2K

Verified Solution

Question

Finance

The table below shows the closing monthly stock prices for IBMand Amazon. Calculate the exponential three-month moving averagefor both stocks where two-thirds of the average weight is placed onthe most recent price. (Do not round intermediatecalculations. Round your answers to 2 decimal places.)

IBMAMZN
January$172.64$607.61
February175.29618.80
March186.43579.71
April202.46546.10
May194.29518.62
June206.79500.38
July229.17605.19
August209.08538.71
September218.63513.74
October214.11597.69
November194.54595.04
December174.50651.40
IBMAMZN
March
April
May
June
July
August
September
October
November
December

Answer & Explanation Solved by verified expert
4.4 Ratings (795 Votes)

3 months moving average is calculated by taking the average of every 3 months combination as shown in the below table:

  1. Average period = January, February, March
  2. Average period = February, March, April
  3. Average period = March, April, May
  4. Average period = April, May, June
  5. Average period = May, June, July
  6. Average period = June, July, August
  7. Average period =July, August, September
  8. Average period =August, September, October
  9. Average period =September, October, November
  10. Average period =October, November, December
IBM 3MA Amazon 3MA
January $172.64 January $607.61
February $175.29 February $618.80
March $186.43 (0.5*172.64+0.5*175.29+2*186.43)/3= $182.28 March $579.71 (0.5*607.61+0.5*618.8+2*579.71)/3= $590.88
April $202.46 (0.5*175.29+0.5*186.43+2*202.46)/3= $195.26 April $546.10 (0.5*618.8+0.5*579.71+2*546.1)/3= $563.82
May $194.29 (0.5*186.43+0.5*202.46+2*194.29)/3= $194.34 May $518.62 (0.5*579.71+0.5*546.1+2*518.62)/3= $533.38
June $206.79 (0.5*202.46+0.5*194.29+2*206.79)/3= $203.99 June $500.38 (0.5*546.1+0.5*518.62+2*500.38)/3= $511.04
July $229.17 (0.5*194.29+0.5*206.79+2*229.17)/3= $219.63 July $605.19 (0.5*518.62+0.5*500.38+2*605.19)/3= $573.29
August $209.08 (0.5*206.79+0.5*229.17+2*209.08)/3= $212.05 August $538.71 (0.5*500.38+0.5*605.19+2*538.71)/3= $543.40
September $218.63 (0.5*229.17+0.5*209.08+2*218.63)/3= $218.80 September $513.74 (0.5*605.19+0.5*538.71+2*513.74)/3= $533.14
October $214.11 (0.5*209.08+0.5*218.63+2*214.11)/3= $214.03 October $597.69 (0.5*538.71+0.5*513.74+2*597.69)/3= $573.87
November $194.54 (0.5*218.63+0.5*214.11+2*194.54)/3= $201.82 November $595.04 (0.5*513.74+0.5*597.69+2*595.04)/3= $581.93
December $174.50 (0.5*214.11+0.5*194.54+2*174.5)/3= $184.44 December $651.40 (0.5*597.69+0.5*595.04+2*651.4)/3= $633.06

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

The table below shows the closing monthly stock prices for IBMand Amazon. Calculate the exponential three-month moving averagefor both stocks where two-thirds of the average weight is placed onthe most recent price. (Do not round intermediatecalculations. Round your answers to 2 decimal places.)IBMAMZNJanuary$172.64$607.61February175.29618.80March186.43579.71April202.46546.10May194.29518.62June206.79500.38July229.17605.19August209.08538.71September218.63513.74October214.11597.69November194.54595.04December174.50651.40IBMAMZNMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember

Other questions asked by students

Mechanical Engineering
1.2K views

For the stress data given below with the nearest error of 1: 32 17 38 82 48 5 37 13 19 31 19 a) Construct a frequency...

Physics
1.2K views

Find the change in the internal energy of 453 6 gr of O2 assume ideal...

Physics
1.2K views

3 4 x 100 joule A fully charged capacitor has a capacitance C It is...

Geometry
1.2K views

In the triangle below with right angle LE suppose that mLF 2x 37 and mL...

Calculus
1.2K views

1. Evaluate the following integrals using integration by parts. Clearly denote what is playingthe role...

Algebra
1.2K views

1 point If the linear system has infinitely many solutions then k and h 7x...

Accounting
1.2K views

Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable...

Accounting
1.2K views

Indicate whether the following costs are fixed, variable or mixed. Mixed Variable Fixed None of...

Accounting
1.2K views

ohnson Electrical produces industrial ventilation fans. The company plans to manufacture 69,000 fans evenly over...

Accounting
1.2K views

A gender difference that appear early in development and across culture is, that compared to...

Accounting
1.2K views

29. Comparative financial statements for...

Accounting
1.2K views

Required: 1. Restate the income statement to reflect LCM valuation of the ending inventory Apply...