Calculate the 5-year monthly returns for Oracle Corporation (ORCL) ending on or around June 1, 2020....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculate the 5-year monthly returns for Oracle Corporation (ORCL) ending on or around June 1, 2020. Calculate the corresponding 5-year monthly returns for the S&P 500 (^GSPC). a) Calculate the covariance between the return series b) Calculate the Beta implied by that covariance c) Graph the returns with the S&P returns on the x-axis and the Oracle returns on the y-axis. Add a trendline. d) Use the regression tool (under Tools/Data Analysis) to calculate a regression with Oracle returns as the y-variable, S&P returns as the x- variable. e) What is the 95% confidence interval for your Beta? What does that mean? f) What proportion of the variance in Oracle's returns is explained by the CAPM? g) Given your calculated Beta, if you expect a 7% return for the S&P 500 over the next year, and if short term rates are currently at 0.5%, what returns do you expect for Oracle? Calculate the 5-year monthly returns for Oracle Corporation (ORCL) ending on or around June 1, 2020. Calculate the corresponding 5-year monthly returns for the S&P 500 (^GSPC). a) Calculate the covariance between the return series b) Calculate the Beta implied by that covariance c) Graph the returns with the S&P returns on the x-axis and the Oracle returns on the y-axis. Add a trendline. d) Use the regression tool (under Tools/Data Analysis) to calculate a regression with Oracle returns as the y-variable, S&P returns as the x- variable. e) What is the 95% confidence interval for your Beta? What does that mean? f) What proportion of the variance in Oracle's returns is explained by the CAPM? g) Given your calculated Beta, if you expect a 7% return for the S&P 500 over the next year, and if short term rates are currently at 0.5%, what returns do you expect for Oracle?
Expert Answer:
Answer rating: 100% (QA)
a The covariance between the return series is 00001 CovXY EXY EXEY or We can find out the monthly cl... View the full answer
Related Book For
Differential Equations and Linear Algebra
ISBN: 978-0131860612
2nd edition
Authors: Jerry Farlow, James E. Hall, Jean Marie McDill, Beverly H. West
Posted Date:
Students also viewed these biology questions
-
Use the information below to answer the following question U.S. Expands China Paper Anti-Dumping Tariff Responding to a case brought by the NewPage Corporation of Dayton, Ohio, the U.S. Commerce...
-
Use information from Table 16.2 to answer the following questions about sound in air. At 20oC the bulk modulus for air is 1.42 X 105 Pa and its density is 1.20 kg/m3. At this temperature, what are...
-
Use the following payoff matrix to answer the following questions. Suppose this is a one-shot game:a. Determine the dominant strategy for each player. If such strategies do not exist, explain why...
-
Write a java program that will find the minimum value and print it to the console for the given array: {72, 101, 108, 108, 111, 32, 101, 118, 101, 114, 121, 111, 110, 101, 33, 32, 76, 111, 111, 107,...
-
A TCP segment consisting of 1500 bits of data and 160 bits of header is sent to the IP layer, which appends another 160 bits of header. This is then transmitted through two networks, each of which...
-
Economy Appliance Co. manufactures lowprice, no-frills appliances that are in great demand for rental units. Pricing and cost information on Economys main products are as shown on page 943. Customers...
-
An airplane is flying at a flight (or local) Mach number of 0.70 at \(10,000 \mathrm{~m}\) in the Standard Atmosphere. Find the ground speed (a) if the air is not moving relative to the ground (b) if...
-
Secondary data have been called the first line of attack for business researchers. Discuss this description.
-
Question 1: Assume the following: Units / year = 10 = Tenure new builder Business and technical skills = New builder / Average skill Financial = High risk o Ignore the equity calculations. Carry out...
-
1. Staples, following extensive injuries in an automobile accident, was declared mentally incompetent. He imagined himself to be in command of a large army engaged in protecting the country against...
-
Which leadership style on Blake and Moutons Leadership Grid has a high concern for people and low concern for production?
-
Describe the International Monetary Fund. How do the Foreign Exchange Market and the International Monetary System relate and interact? Provide examples.
-
Suppose the target range for the federal funds rate is 1.5 to 2.0 percent but that the equilibrium federal funds rate is currently 1.70 percent. Assume that the equilibrium federal funds rate falls...
-
1. Do you believe that Porshe's management is appropriately concerned with shareholder wealth? Does Porsche's ownership structure work to the benefit or detriment of public shareholders?
-
Analyse effective leadership strategies for enhancing performance in public enterprises. Use practical examples from the Namibian corporate sector to illustrate your answers.
-
Cash includes currency and coins, balances in checking accounts, and items acceptable for deposit in these accounts, such as checks and money orders received from customers. These forms of cash...
-
You need to do a strategic analysis using the five forces model and the value chain. Which tool should you use first?
-
A company has the following incomplete production budget data for the first quarter: In the previous December, ending inventory was 200 units, which was the minimum required, at 10% of projected...
-
Function Space Dependence: Determine whether each subset S of C(R) in Problems 1-3 is or is not linearly independent? 1. S = {et, e-t} 2. S = {et, tet, t2et} 3. S = {sin t, sin 2t, sin 3t}
-
Negative Roots: Verify that in the overdamped mass-spring system, for which ( = b2 - 4mk > 0, both characteristic roots are negative?
-
Phase Portraits: For Problems 1-3, find (t) and then sketch the trajectory for the NP in the x phase plane, with arrows showing the direction of motion. (These are the equations of Problems 1-2 and...
-
A manager has been using a certain technique to forecast demand for project man- agement software at her store. Actual demand and her corresponding predictions are shown below: a. What was the...
-
DRIVE WIND Driver's Donuts is a bakery and coffee shop that depends on morning com- muters for 80% of its daily business. During the morning rush from 5:30 a.m. to 8:30 a.m., an average of 35 cars...
-
Why aren't the effective capacity and the optimal operating level of any operation necessarily the same amount of activity?
Study smarter with the SolutionInn App