Hi, I can't figure out this question in excel, can someone please show me the excel...

Hi, I can't figure out this question in excel, can someone please show me the excel formulas to input in order to solve for part A and B please!!!!

The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017.

Ticker	6/30/2017	5/31/2017	4/30/2017	3/31/2017	2/28/2017	1/31/2017
ORCL	50.14	45.39	44.96	44.61	42.59	40.11
MSFT	68.93	69.84	68.46	65.86	63.98	64.65
NVDA	144.56	144.35	104.3	108.93	101.48	109.18

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

Expert Solution

jeff jeffy answered 1 year ago

Can't figure out what I am doing wrong. Please let me know. Sample output: Please enter...

Can't figure out what I am doing wrong. Please let me know. Sample output: Please enter the name of the weather data file: temperatures.txt Tell me about your crew’s preferred temperature for sailing: What is the coldest temperature they can sail in? 60 What is the hottest temperature they can sail in? 80 Month 1: 93.3 percent of days in range. Month 2: 20.0 percent of days in range. Month 3: 58.1 percent of days in range. Month 4: 100.0...

without using excel can someone show me the steps to approach the following question Question 2...

without using excel can someone show me the steps to approach the following question Question 2 Rump Industries Ltd expects its new product will give it a significant first mover advantage in the market and that is expected to provide growth in earnings per share of 400% within the coming year, and 75% growth in each of the subsequent 3 years. After that time, it is expected competitors will have developed and brought to market similar products with the result...

Can someone please show me how to do the work on this please. Question The transactions...

Can someone please show me how to do the work on this please. Question The transactions of the Fury Delivery Service are recorded in the general journal below. Instructions: 1. Post the journal entries to the attached general ledger “T” accounts. 2. Prepare a trial balance on the form provided after the “T” accounts. General Journal Date Account Titles and Explanation Debit Credit 2017 Sept. 1 Cash Common Stock (Stockholders invested cash in business) 25,000 25,000 4 Equipment Cash Notes...

I can't seem to figure out what the hybridization of PF6(-) is. could someone explain how...

I can't seem to figure out what the hybridization of PF6(-) is. could someone explain how to find it correctly for me?

Can someone do this in Excel and show me the formulas as well. The management of...

Can someone do this in Excel and show me the formulas as well. The management of Tri-County Air Taxi, Inc., is considering the replacement of an old machine used in its helicopter repair facility. It is fully depreciated but it can be used by the corporation through 20x5. If management decides to replace the old machine, James Transportation Company has offered to purchase it for $69,000 on the replacement date. The old machine would have no salvage value in 20x5....

I can't figure this problem out! The problem is: Show the relationship between income and crime...

I can't figure this problem out! The problem is: Show the relationship between income and crime using indifference curves.

This is a question from Intro to Bayesian Statistics but I can't figure out what is...

This is a question from Intro to Bayesian Statistics but I can't figure out what is expected here. Derive the posterior distribution of obtaining heads in coin flips. The prior has p(θ = .25) = .25, p(θ = .50) = .50, and p(θ = .75) = .25. The data consist of a specific sequence of flips with 3 heads and 9 tails, so p(Data|θ) = θ^3 (1 − θ) ^9.

Can someone show me how to do this on excel? Question involves cell phone users. Mean...

Can someone show me how to do this on excel? Question involves cell phone users. Mean monthly data usage = 5.8 GB/month StDev monthly data usage = 2.5 GB/month "Heavy users" are those that use >= 9 GB/month a.) What is the probability a "heavy user" uses more than 10 GB/month? b.) Two users are selected at random. What is the probability at least one of them is a heavy user? c.) Five users are selected at random. What is...

I am struggling with figureing this out as a practicing question! Please show me the work...

I am struggling with figureing this out as a practicing question! Please show me the work for how to get the correct answers! ABC Company produces two separate products, product A and product B. Information on product A and B is reported below: Product A Product B Sales Price: $1,000 $1,800 Direct Materials $100 $500 Direct Labor $250 $600 Variable Overhead $50 $400 Commissions: $25 $40 Company information: Fixed Manufacturing overhead: $400,000 per year Fixed Administrative Expenses: $375,000 per year Tax rate: 25% ABC Company has to decide which of the following sales mixes will...

Please use EXCEL to answer and show all formulas. I can't understand the answer if I...

Please use EXCEL to answer and show all formulas. I can't understand the answer if I can't see the formulas for each field. Thank you very much. Newman manufacturing is considering a cash purchase of the stock of Grips Tool. During the year just completed, Grips earned $4.25 per share and paid cash dividends of $2.55 per share (D0=$2.55). Grips' earnings and dividends are expected to grow at 25% per year for the next 3 years, after which they are...

Question