Question: Please show with EXCEL formula to show how to solve the problem Suppose the risk-free rate is 3.4 percent and the market portfolio has an

Please show with EXCEL formula to show how to solve the problem

Suppose the risk-free rate is 3.4 percent and the market portfolio has an expected return of 10.1 percent. The market portfolio has a variance of .0302. Portfolio Z has a correlation coefficient with the market of .20 and a variance of .3205. According to the capital asset pricing model, what is the expected return on Portfolio Z? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Expected return _________________%

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:

One of the many types of sugar The Blue Company produces is granulated sugar, with its most popular package being the 4-pound bag. In August, the company reported the following equivalent units and...

Q:

Show using EXCEL formula to understand how to solve this problem Suppose you observe the following situation: State of Economy Probability of State Return if State Occurs Stock A Stock B Bust .20 .15...

Q:

5. Continue with above problem. Suppose now that your portfolio must yield an expected return of 12% and be efficient, that is, on the best feasible CAL. a. What is the standard deviation of your...

Q:

Assignment 2 Instructions Assignment 2 should be submitted after you have completed Unit 3. This assignment is worth 15 percent of your final grade. Assignment 2 contains four problems. The maximum...

Q:

Part I consists of three questions. Do the computations for the example below. Show the computations step by step, so Mr. Hillbrandt can easily follow your examples. 1. The company?s common stock...

Q:

how do I solve this in Excel? Please show what you enter in excel formula bar. Relationship between the market risk premium, the T-bill rate, and the expected return on the market portfolio If...

Q:

Please Show graph The risk-free rate of interest is 4 percent. The expected rate of return on the market portfolio is 12 percent. Plot this information on a diagram that has beta on the x-axis and...

Q:

1. Alexander have $35,000 to invest. He put $20,000 in Google's Stock and the remaining in Exxon's stock. The expected return of Google is 30 percent and that of Exxon is 22.5 percent. What is the...

Q:

how do I solve this in Excel? Please show what you enter in excel formula bar. Relationship between the market risk premium, the T-bill rate, and the expected return on the market portfolio If...

Q:

Please show complete EXCEL formula and answer all problems You have recently inherited the following portfolio: Stock Investment Stocks Beta A $250,000,000 1.20 B $150,000,000 1.00 C $100,000,000...

Q:

Please USE EXCEL formula to show how to solve this problem Assume Stocks A and B have the following characteristics: Stock Expected Return Standard Deviation A 9.7% 33.7% B 15.7% 62.7% The covariance...

Q:

Operations for Simple Strategies Company for 2007 and 2008 are summarized here. Instructions: 1. Prepare common-size income statements for 2008 and 2007. 2. Comment on Simple Strategies profitability...

Q:

What are some other types of health insurance that might be offered by an employer?

Q:

Alan's FICO score is NOT directly affected by the number of credit cards he applies for recently. the combined credit limits on all his credit cards. the length of his credit history. the amount of...

Q:

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...