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
-
Probability and Statistics II Assignment 5: Simple Linear Regression The compressive strength of a rivet fastener used in an aircraft panel assembly is being studied by the manufacturing operations...
-
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 11, find the indicated limit or function value, or state that it does not exist. (a) (b) f(-3) (c) f(-1) (d) (e) f(1) (f) (g) (h) (i) Figure 11 lim f(x) limf(x)...
-
From literature sources, find the critical pressures and temperatures of methane, methylamine (CH 3 NH 2 ), ammonia, and tetrafluoromethane. Discuss the suitability of using each of these solvents...
-
If a triangle is a right triangle, then it does not have one 90 -degree angle or \(a^{2}+b^{2}=c^{2}\). Given the true statements p: "A right triangle has one 90 -degree angle," \(q\) : "The triangle...
-
This information relates to Crofoot Real Estate Agency. Oct 1 Stockholders invest $30,000 in exchange for common stock of the corporation. 2. Hires an administrative assistant at an annual salary of...
-
At the beginning of 20x6, Split Co.'s shareholders' equity had a balance of $52562 and liabilities were equal to $18873. During the year 20x6, assets increased by $20393 and liabilities decreased by...
-
Hill Bikes Unlimited uses a flexible budget and standard costs to aid planning and control of its bicycle production. You recently accepted a position with Hill Bikes and as part of your duties, you...
-
For those discussions: Freedom of Speech 1. First, read the assigned text, discussions questions are based on the text. 2. Second, read the discussion question on the key concepts in the topic and...
-
Dats Systems has stock currently priced at $50.00 per share. If investors are earning a 7% return on Dats Systems, what is the company's annual dividend payment per share?
-
Becker Tabletops has two support departments (Janitorial and Cafeteria) and two production departments (Cutting and Assembly). Relevant details for these departments are as follows: Support...
-
Your client, Ms. Kimberly Hall, stands convicted under your state law for charges involving theft, trafficking in stolen property, fraud, and alteration of vehicle identification numbers. Hall runs a...
-
Answer the following #1 Laura is suing Jeffrey for repayment of a $500 loan. Laura lent $500 to Jeffrey 3 months ago, as he was short on money for rent, and he agreed to pay her back within 60 days....
-
What is the difference in total payments for a loan of $35,000 which is paid over 5 years with equal total payments, compared to a loan of $35,000 which is paid back in equal total payments starting...
-
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...
-
You are to enter up the sales journal from the following details. Post the items to the relevant accounts in the sales ledger and then show the transfer to the sales account in the general ledger....
-
Enter up the sales journal from the following, then post the items to the relevant accounts in the sales ledger. Then show the transfer to the sales account in the general ledger. 19X8 Mar 1 Credit...
-
J Fisher, White House, Bolton, is selling the following items, the retail prices as shown: plastic tubing at 1 per metre, polythene sheeting at 2 per length, vinyl padding at 5 per box, foam rubber...
Study smarter with the SolutionInn App