Question: Q#1:[EXCEL BASED QUESTION]Using the excel example that is discussed in Chapter 7, answer the following questions by first choosing any six assets of your choice.

Q#1:[EXCEL BASED QUESTION]Using the excel example that is discussed in Chapter 7, answer the following questions by first choosing any six assets of your choice. And for your computation in this question, assume the risk-free rate is 0.2%

Blackrock, Goldman Sachs, Morgan Stanley, Tesla, Google, Microsoft

a. Get their monthly price data from yahoo finance for the sample period of 10/1/2011 10/1/2021and compute the realized returns and excess returns.

b. Calculate their average monthly returns, monthly variance and standard deviation.

c. Calculate their average annual returns, annual variance and standard deviation.

d. Compute the variance-covariance matrix of these six assets.

e. Find the minimum variance efficient portfolio.

f. Find the optimal risky (tangent) portfolio.

g. Give an interpretation of your findings in (e)and (f).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q#1:[EXCEL BASED QUESTION]Using the excel example that is discussed in Chapter 7, answer the following questions by first choosing any six assets of your choice. And for your computation in this...

Please use any six large cap assets of your choice. I know how to do A through D. I am just mostly confused about E, F, and G. The numerical data is from searching a large cap on Yahoo Finance, like...

please read chapter and answer the following questions. All answers must be typed. thank you, will give thumbs up. 1. What kind of structure, controls, and culture would you be likely to find in (a)...

Please see the snap photo below for further instructions. thank you 1. Read the Electrolux and GE Applianceh 2. \"the Excel spreadsheet template prov1 e posted N 3 Answer the following questions....

Financial Acct-20, HOMEWORK #A =50 points INSTRUCTIONS 1) Prepare the Items listed in the REQUIRED REPORTS Section below using the BUSINESS TRANSACTIONS at the End. 2) All Reports must be completed...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

Browse financial news in printed and internet-based financial media since January 2021. Identify three separate news items or opinion pieces where the content is about the following topics: (1) how...

In each case, find the approximate sample size required to construct a 95% confidence interval for p that has sampling error SE = .06. a. Assume that p is near .3. b. Assume that you have no prior...

You can elect to receive Social Security retirement benefits Question 1 5 options: and limit your ability to keep on working and earning income. at the full retirement age, which is being raised from...

E9-7 Tanger Company purchased a delivery truck for R$ 38,000 on January 1, 2017. The truck has an expected residual value of R$6,000, and is expected to be driven 100,000 miles over its estimated...