subject
Business, 20.02.2020 22:03 b2cutie456

The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017.Ticker6/30/20175/31/20174/30/2 0173/31/20172/28/20171/31/2017ORCL5 0.1445.3944.9644.6142.5940.11MSFT68 .9369.8468.4665.8663.9864.65NVDA144 .56144.35104.3108.93101.48109.18a) Enter the data, as shown, into a worksheet and format the table as shown. b) Create a formula to calculate the monthly rate of return during the first semester of 2017 and for each company. Format the results as percentages with two decimal places. c) Calculate the total return for the entire holding period, the compound average monthly rate of return, the average monthly rate of return using the AVERAGE function, and the average monthly rate of return using the GEOMEAN function. d) Create a line chart showing the stock prices from January to June 2017 for these companies. Make sure to title the chart and label the axes. Also present the data from January to June and use Times New Roman for the title, labels, and numbers. Select a different dash type for each line representing each company.

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 02:00
On january 1, 2017, fisher corporation purchased 40 percent (90,000 shares) of the common stock of bowden, inc. for $980,000 in cash and began to use the equity method for the investment. the price paid represented a $48,000 payment in excess of the book value of fisher's share of bowden's underlying net assets. fisher was willing to make this extra payment because of a recently developed patent held by bowden with a 15-year remaining life. all other assets were considered appropriately valued on bowden's books. bowden declares and pays a $90,000 cash dividend to its stockholders each year on september 15. bowden reported net income of $400,000 in 2017 and $348,000 in 2018. each income figure was earned evenly throughout its respective year. on july 1, 2018, fisher sold 10 percent (22,500 shares) of bowden's outstanding shares for $338,000 in cash. although it sold this interest, fisher maintained the ability to significantly influence bowden's decision-making process. prepare the journal entries for fisher for the years of 2017 and 2018. (if no entry is required for a transaction/event, select "no journal entry required" in the first account field. do not round intermediate calculations. round your final answers to the nearest whole dollar.)
Answers: 3
question
Business, 22.06.2019 12:30
In the 1970s, kmart used blue light specials to encourage customers to flock to a particular department having a temporary sale. a spinning blue light activated for approximately 30 seconds, and then an in-store announcement informed shoppers of the special savings in the specific department. over time, loyal kmart shoppers learned to flock to the department with the spinning blue light before any announcement of special savings occurred. if kmart was employing classical conditioning techniques, what role did the spinning blue light play?
Answers: 3
question
Business, 22.06.2019 21:20
What business practice contributed most to andrew carnegie’s ability to form a monopoly?
Answers: 1
question
Business, 22.06.2019 23:30
Sports leave thousands of college athletes with little time for their studies. this is an example of
Answers: 1
You know the right answer?
The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft C...
Questions
question
World Languages, 12.02.2021 21:00
question
Arts, 12.02.2021 21:00
question
Mathematics, 12.02.2021 21:00
question
History, 12.02.2021 21:00
question
Mathematics, 12.02.2021 21:00
Questions on the website: 13722363