How to calculate the following questions in excel

Assignment Help Finance Basics

Reference no: EM13305029

How to calculate the following questions in excel?

Suppose the standard deviation of the market return is 20%.

a. What is the standard deviation of returns on a well-diversified portfolio with a beta of 1.3?

b. What is the standard deviation of returns on a well-diversified portfolio with a beta of 0?

c. A well-diversified portfolio has a standard deviation of 15%. What is its beta?

d. A poorly diversified portfolio has a standard deviation of 20%. What can you say about its beta?

Reference no: EM13305029

Questions Cloud

How much heat does it exhaust in each cycle : A heat engine has an effiency of 35.0 % and recieves 150 K of heat per cycle. How much heat does it exhaust in each cycle

What nominal rate of return do you expect to earn : You expect the inflation rate to be 2.9 percent and the U.S. Treasury bill yield to be 3.7 percent for the next year. The risk premium on small-company stocks is 12.6 percent. What nominal rate of return do you expect to earn on small-company stoc..

What real rate of return did she earn on her investments : Last year, Rita earned 11.6 percent on her investments while U.S. Treasury bills yielded 3.8 percent and the inflation rate was 3.1 percent. What real rate of return did she earn on her investments last year?

Compute how many molecules are there in the gas : An ideal gas has a pressure of 2.5 atm, a volume of 1.0L at at temperature of 30 degrees Celcius. How many molecules are there in the gas

How to calculate the following questions in excel : How to calculate the following questions in excel? Suppose the standard deviation of the market return is 20%.

Find the maximum radius that this circle could have : A point source of light is submerged 2.5 m below the surface of a lake and emits rays in all directions. What is the maximum radius that this circle could have

Determine the number of molecules of pain reliever : Manufacturers of headache remedies routinely claim that their own brands are more potent pain relievers than the competing brands. Find the number of molecules of pain reliever

By how much does the required return on the riskier stock : Electro Inc. has a beta of 1.8, Flowers Galore has a beta of 0.9, the average return in the market is 12%, and the risk-free rate of return is 4.0%. By how much does the required return on the riskier stock exceed the required return on the less r..

What is your inheritance worth to you today : Your grandfather left you an inheritance that will provide an annual income for the next 10 years. You will receive the first payment one year from now in the amount of $4,000.

User Account

All Pages