Can you please answer them and make sure they are right? Instructions for Questions 13-19 Create a
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Instructions for Questions 13-19 Create a dataset that has monthly returns for the following stocks: TSLA, JNJ, GOOGL, and GE from January 1, 2018 to December 31, 2022 using their "adjusted" price. Create an equally weighted portfolio consisting of these stocks and calculate the monthly returns of your portfolio. Import the Market Returns and Risk-Free Rate dataset and join with your portfolio to obtain the market return (market return) and risk-free rate ("risk-free"). = Hint: The code to retrieve the necessary data from the tidyquant package on R is as follows: 'stocks % tq_get(get "stock.prices", from = "2018-01-01", to = "2022-12-31") Hint: An equally weighted portfolio means that you invest the same proportion of your total investment into each stock. If you have 4 stocks, you'd invest 25% of your total funds into each. Dataset Market and Risk Free Return: Market and RiskFree Returns 2018 to 2022.csv 13 14 1 point How many months did this portfolio exceed a 25% return rate? 00 1 month 2 months 3 months 4 months 1 point Utilizing the companies from question above, calculate the following, as a percentage, rounded to four decimal places: O O O O Portfolio standard deviation GE standard deviation Portfolio arithmetic average GE arithmetic average 8.3468%, 12.4647%, 5.2548%, -0.0079% 13.3434%, 12.4647%, 2.2553%, -0.0079% 13.2924%, 12.4647%, 5.2548%, -0.8925% 8.3468%, 15.5614%, 1.7038%, -0.0079% 16 -DO 15 1 point What is the cumulative return of the portfolio rounded to the nearest percent? 64% O O O O 89% 103% 137% 1 point Calculate TSLA's average monthly excess return relative to the market. Give your answer as a percentage, rounded to two decimal places. O O O O 3.69% -.74% -4.24% 4.24% -D-O -DOO -DO Instructions for Questions 13-19 Create a dataset that has monthly returns for the following stocks: TSLA, JNJ, GOOGL, and GE from January 1, 2018 to December 31, 2022 using their "adjusted" price. Create an equally weighted portfolio consisting of these stocks and calculate the monthly returns of your portfolio. Import the Market Returns and Risk-Free Rate dataset and join with your portfolio to obtain the market return (market return) and risk-free rate ("risk-free"). = Hint: The code to retrieve the necessary data from the tidyquant package on R is as follows: 'stocks % tq_get(get "stock.prices", from = "2018-01-01", to = "2022-12-31") Hint: An equally weighted portfolio means that you invest the same proportion of your total investment into each stock. If you have 4 stocks, you'd invest 25% of your total funds into each. Dataset Market and Risk Free Return: Market and RiskFree Returns 2018 to 2022.csv 13 14 1 point How many months did this portfolio exceed a 25% return rate? 00 1 month 2 months 3 months 4 months 1 point Utilizing the companies from question above, calculate the following, as a percentage, rounded to four decimal places: O O O O Portfolio standard deviation GE standard deviation Portfolio arithmetic average GE arithmetic average 8.3468%, 12.4647%, 5.2548%, -0.0079% 13.3434%, 12.4647%, 2.2553%, -0.0079% 13.2924%, 12.4647%, 5.2548%, -0.8925% 8.3468%, 15.5614%, 1.7038%, -0.0079% 16 -DO 15 1 point What is the cumulative return of the portfolio rounded to the nearest percent? 64% O O O O 89% 103% 137% 1 point Calculate TSLA's average monthly excess return relative to the market. Give your answer as a percentage, rounded to two decimal places. O O O O 3.69% -.74% -4.24% 4.24% -D-O -DOO -DO
Expert Answer:
Related Book For
Fundamentals Of Corporate Finance
ISBN: 9780135811603
5th Edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
6. Use the same set of information given in the problem above. (a) Use S&P 500 future prices to calculate the implied dividend yield on S&P 500. For simplicity, assume you can borrow or deposit money...
-
Hello, I am not sure onm this and need help please, thank you! For each of the following situations, list which ACID property is being violated, then describe what an ACID-compliant DBMS would have...
-
For the function f graphed in Figure 13, find the indicated limit or function value, or state that it does not exist. (a) f(-3) (b) f(3) (c) (d) (e) (f) Figure 13 lim fx) lim) lim f(x) lim f(x)...
-
The rotor of a gas turbine is rotating at a speed of 6900 rpm when the turbine is shut down. It is observed that 4 min is required for the rotor to coast to rest. Assuming uniformly accelerated...
-
How to obtain a dismissal of a lawsuit?
-
Rockport Municipal Marina is considering adding a new dock to accommodate large yachts. The dock would cost $700,000 and would generate $144,000 annually in new cash inflows. Its expected life would...
-
Variances, Entries, and Income Statement A summary of Blake Company's manufacturing variance report for June follows. Total Standard Costs (7,600 units) Actual Costs (7,600 units) Variances Direct...
-
Physical sediment light enough to be carried in the flow of water; often the majority of a stream's load.. choose one: 1. bed load 2. suspended load 3. dissolved load
-
Conflict theorists describe how deviance is defined by the people in power. In society, power and wealth impact the perception of deviance and the overall treatment of those who commit crimes....
-
The 6-month zero rate is 8% per annum with semi-annual compounding. Currently, a one-year bond with a 10% per annum coupon is trading at 96, with a par value of 100. The coupon is paid semi-annually....
-
1. Consider a fixed rate or constant payment (FRM or CPM) mortgage loan that carries a mortgage interest rate of 6.5%. What is the effective annual rate (EAR)? What is the equivalent monthly rate...
-
What are the key challenges and opportunities associated with the integration of emerging separation technologies such as membrane bioreactors, ion exchange resins, and magnetic separation systems...
-
Monika is also responsible for the "spin kits" brand. They have been a very popular product among high school kids. Given the popularity, it has been difficult to keep them in stock. For this reason,...
-
(a) Consider the data sequence 10000011000010 Encode the sequence using HDB3. (4 marks) A digital link uses a channel that can convey frequency from de to B Hz. Suppose the line coding NRZ Polar is...
-
Evaluate the integral, if it exists. Jo y(y + 1) dy
-
Bauer Industries is an automobile manufacturer. Management is currently evaluating a proposal to build a plant that will manufacture lightweight trucks. Bauer plans to use a cost of capital of 12% to...
-
Does accelerated depreciation generally increase or decrease NPV relative to straight line depreciation?
-
Quisco Systems has 7.5 billion shares outstanding and a share price of $18. Quisco is considering developing a new networking product in house at a cost of $500 million. Alternatively, Quisco can...
-
A failure report states that a safety transmitter signaled a high pressure in a vessel and initiated a trip. Other pressure measurements did not indicate any high pressure. A diagnostic in the safety...
-
An instrument has a failure rate of 0.015 failures per year. All failures are immediately detectable. The MTTR is 24 hours. What is steady state unavailability?
-
A valve has a failure rate of 0.06 failures per year. A periodic inspection performed once a year can detect 60% of the failures. The valve is operated for 10 years before it is removed from service...
Study smarter with the SolutionInn App