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 14, find the indicated limit or function value, or state that it does not exist. (a) (b) (c) (d) f(-1) (e) (f) f(1) lim f(x) lim fx) lim f(x) lim f(x)
-
When investing for a long-term goal such as retirement, how are the costs associated with your investments likely to affect your results? Explain your answer in terms of this chapters concepts.
-
Do the following activities to complete your marketing plan: 1. Draw a simple organizational chart for your organization. 2. Develop a Gantt chart (see Chapter 2) to schedule the key activities...
-
Students in a management science class have just received their grades on the first test. The instructor has provided information about the first test grades in some previous classes as well as the...
-
3. If the policy proposed in question 2 is adopted, analyze the potential effects of this policy on the demand for workers under the age of 65. That is, if employers who want their employees to be...
-
Given a point P (2, 4, 8) and using the homogeneous representation: a. Calculate the corresponding transformation matrix and the coordinates of the transformed point P* if P is rotated about the x,...
-
A 0.17-kg rubber egg bounces off an actor's roof, remaining in contact with it for 72 ms while changing the egg's velocity from 22.9 m/s directly toward the roof to 14.4 m/s directly away from it....
-
Consider the following information for three stocks, Stocks X, Y, and Z. The returns on the three stocks are positively correlated, but they are not perfectly correlated. (That is, each of the...
-
If the returns on Stock A are as follows: Year 1 return 37 %, Year 2 return-_8 %, Year 3 return 12 %, Year 4 return-12 %, and Year 5 return-7 %, what is the average return for Stock A over this 5...
-
give a detailed analysis. PROBLEM/OPPORTUNITY STATEMENT The recent Banking Crisis has raised the alarm on a number of threats that are particularly salient towards small and medium-size banks....
-
A dolphin emits an ultrasonic wave with a frequency of 1 0 7 kHz . Sound waves travel at 1 5 3 0 m / s in seawater. What is the wavelength of this sound in seawater? Report your answer in units of cm...
-
Labour force data for country Eturia (all in millions) are shown in the table below. Enter your responses below rounded to one decimal place. 2013 2014 2015 Population (millions) 20 20.5 21.02...
-
Assume you are the accountant for Catalina Industries. John Catalina, the owner of the company, is in a hurry to receive the financial statements for the year ended December 31, 20X1, and asks you...
-
Define human communication.
-
Perceiving your communication as effective while those around you perceive it as ineffective is known as ______________.
-
Visit any of the websites for major social media companies (Facebook, Twitter, LinkedIn, etc.). Under the About Us section, read the company mission statement and goals for the organization. Do you...
Study smarter with the SolutionInn App