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

90.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

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

A B C
IBM 3 Month Average Smoothing Constant Exponential Moving average(IBM) AMZN Smoothing Constant 3 Month Average Exponential Moving average(AMZN)
January 172.64 0.6666667 607.61 0.6666667
February 175.29 0.6666667 618.8 0.6666667
March 186.43 178.12 0.6666667 178.12 579.71 0.6666667 602.04 602.04
April 202.46 0.6666667 194.3466675 546.1 0.6666667 564.75
May 194.29 0.6666667 194.3088892 518.62 0.6666667 534.00
June 206.79 0.6666667 202.6296301 500.38 0.6666667 511.59
July 229.17 0.6666667 220.3232109 605.19 0.6666667 573.99
August 209.08 0.6666667 212.8277366 538.71 0.6666667 550.47
September 218.63 0.6666667 216.6959124 513.74 0.6666667 525.98
October 214.11 0.6666667 214.9719707 597.69 0.6666667 573.79
November 194.54 0.6666667 201.3506562 595.04 0.6666667 587.96
December 174.5 0.6666667 183.4502178 651.4 0.6666667 630.25
Smoothing Constant 2/3= 0.6666667
IBM
March Moving Average 178.12 (172.64+175.29+186.43)/3
April moving Average=0.666667*(202.46-178.12)+178.12= 194.34667
May Moving Average=0.666667*(194.29-194.346667))+194.346667= 194.3089
AMZN
March Moving Average (607.61+618.8+579.71)/3
April moving Average=0.666667*(546.1-602.04)+602.04= 564.75
May Moving Average=0.666667*(518.62-564.75))+564.75= 534.00

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.40

Other questions asked by students

Q

7 20 pts A machine that dispenses 12 3 ounces of be that the amounts...

Basic Math
Q

ALLEN 56 tuning forks are so arranged in series that 22 each fork gives 4...

Physics
Q

a Find the number z such that the proportion of ob servations that are less...

Statistics
Q

a Consider the following Write the percent represented by the shaded portion of the grid...

Algebra
Q

Consider the system of equation and 2x 3y 2 8 x 4y 2z 1 5x...

Algebra
Q

The compound interest formula is in the next textbox, where R is the future value...

Algebra
Q

expression for the area of the shaded region of the figure 5 Is 712 ynomial...

Algebra
Q

A comparative balance sheet for...

Accounting
Q

During the pandemic, many companies have moved to a work from home environment. Discuss how...

Accounting
Q

QUESTION TWO The following information was extracted from ABC Ltds financial statements for the year...

Accounting
Q

Inland Co., has a total of 84,000 shares of common stock outstanding and no preferred...

Accounting
Q

Oriole Corporation is authorized to issue 53,000 shares of $10 par value ordinary shares. During...

Accounting