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.

Answers: 2

Show answers

Other questions on the subject: Business

Business, 22.06.2019 00:40, alaynagrace1111

Select the statement that indicates tina's company is a partnership. tina jones is a dancer specializing in latin dance styles. she always wanted to have her own dance studio where she could teach dancing to young and old alike. in 2006, she opened her first dance studio, electric diva, in madison triangle. it was a great choice as a business location because it's well-connected by highways to most places in the city. she leased the space for three years. her initial investment included a good sound system, cheerful interior design, and strong flooring. to raise capital for the business, tina turned to her brother-in-law, philip. philip made half the financial investment. he manages the accounts and social media needs of the business. he has a 30% share in trisha's business. together, they expanded the business to three dance studios in the city and plan to open franchises in other cities.

Answers: 1

continue

Business, 22.06.2019 06:30, nrudd9799

If a team of three workers, each making the u. s. federal minimum wage, produced these 12 rugs, what would the total labor cost be? don't forget that these workers would be working overtime.

Answers: 3

continue

Business, 22.06.2019 13:30, OnWheels

After successfully completing your corporate finance class, you feel the next challenge ahead is to serve on the board of directors of schenkel enterprises. unfortunately, you will be the only person voting for you. the company has 375,000 shares outstanding, and the stock currently sells for $40, if there are four seats in the current election, how much will it cost you to buy a seat?

Answers: 2

continue

Business, 22.06.2019 13:30, karenjunior

Over the past year, three of the star salesmen at family resorts international's corporate office have been lured away to competitors. on top of that, karina, the general manager of the sales department, has noticed that most employees come in, do their jobs, and leave. family resorts offers a good salary, benefits, and tuition reimbursement, as well as a number of development and training programs. most employees seem contented enough, but karina would like to do something to increase the level of engagement among her staff. what do you think karina should do?

Answers: 1

continue

You know the right answer?

The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft C...