Homework Answers
Using excel formula to calculate
| A | B | C | |
| 1 | Year | Fund | Market |
| 2 | 1 | 14% | 13% |
| 3 | 2 | -15% | -14% |
| 4 | 3 | -6% | -5% |
| 5 | 4 | 5% | 28% |
| 6 | 5 | 14% | 8% |
| 7 | 6 | 8% | 5% |
| Part 1 | Arithmetic Average | 0.0333 | 0.0583 |
| Excel Formula | AVERAGE(B2:B7) | AVERAGE(C2:C7) | |
| Part 2 | Covariance | 0.00000 | |
| Excel Formula | Covariance(B2:B7;C2:C7) | ||
| Part 3 | Variance | 0.0135 | 0.0212 |
| Excel Formula | VAR(B2:B7) | VAR(C2:C7) | |
| Part 4 | Beta | 0.56 | |
| Excel formula | SLOPE(B2:B7;C2:C7) |
Add Answer to:
Problem 4 Intro The following table shows rates of return for a mutual fund and the...
Problem 14 Intro Apple stock had a return of 11%two years ago, and 22% last year. Google stock had a return of 12%...
Problem 14 Intro Apple stock had a return of 11%two years ago, and 22% last year. Google stock had a return of 12% two years ago, and 13% last year. Attempt 1/10 for 10 pts. Part 1 lf you invest 30% in Apple and 70% in Google, what is the expected return of your portfolio for next year, if you use the past as a guide for the future (which is generally not a good idea for calculating expected returns)?...
Problem 14 44ゆ Intro Apple stock had a return of 11%two years ago, and 22% last year. Google stock had a return o...
Problem 14 44ゆ Intro Apple stock had a return of 11%two years ago, and 22% last year. Google stock had a return of 12% two years ago, and 13% last year. Attempt 1/10 for 10 pts Part 1 Ifyou invest 30% in Apple and 70% in Google, what is the expected return of your porttolo for next year, if you use the past as a guide for the future (which is generally not a good idea for calculating expected returns)?...
Intro You have $10,000 to invest and are deciding between investing in an equity mutual fund...
Intro You have $10,000 to invest and are deciding between investing in an equity mutual fund and Treasury bills. The fund has an expected return of 9% and a standard deviation of returns of 20%. T-bills have a return of 4%. Part 1 La Attempt 3/5 for 8 pts. If you put 76% into the mutual fund, what is your expected return? 3+ decimals Submit Part 2 | Attempt 1/5 for 10 pts. What is the standard deviation of returns...
Problem 10 Intro Stock 1 has an expected return of 7% and a standard deviation of...
Problem 10 Intro Stock 1 has an expected return of 7% and a standard deviation of 28%. Stock 2 has an expected return of 14% and a standard deviation of 24%. Their correlation is 0.35. You invest 30% in stock 1 and 70% in stock 2. Part 1 Attempt 1/5 for 10 pts. What is the expected return of the portfolio? 0.119 E(r) = wiE(ru) + w2E(+2) = 0.3 0.07 +0.7.0.14 = 0.119 – Attempt 2/5 for 9 pts. Part...
Problem 3 Intro The return statistics for two stocks and T-bills are given below: B C...
Problem 3 Intro The return statistics for two stocks and T-bills are given below: B C D T- 2 Expected return 3 Variance 4 Standard deviation 5 Covariance Stock A Stock B bills 0.094 0.064 0.02 0.1225 0.0729 0.35 0.27 0.02835 Part 1 | Attempt 1/10 for 10 pts. What is the Sharpe ratio of a portfolio with 70% invested in stock A and the rest in stock B? B+ decima Submit
Problem 17 Intro You've assembled the following portfolio: Stock Beta Portfolio weight The expected market return...
Problem 17 Intro You've assembled the following portfolio: Stock Beta Portfolio weight The expected market return is 5% and the risk-free rate is 2%. Assume that the CAPM holds. Part 1 Attempt 1/5 for 10 pts. What is the beta of the portfolio? 2+ decimals Submit VB Attempt 1/5 for 10 pts. Part 2 What is the expected return of your portfolio? 3. decimals Submit
Intro ABC Corp. has just paid a dividend of $0.49. ABC has an annual required return...
Intro ABC Corp. has just paid a dividend of $0.49. ABC has an annual required return of 9.52%. Part 1 18 Attempt 1/10 for 10 pts. If dividends are annual and expected to be constant, what is the intrinsic value of ABC stock? 1+ decima Submit 1 - Attempt 1/10 for 10 pts. Part 2 What is ABC's dividend yield? 3+ decima Submit Part 3 18 | Attempt 1/10 for 10 pts. From now on, assume that the dividend of...
Problem 5 Intro The following table shows historical end-of- year prices for two non-dividend-paying stocks. ТА...
Problem 5 Intro The following table shows historical end-of- year prices for two non-dividend-paying stocks. ТА ТВ с 1 Year Stock A Stock B 2 1 64.94 14.3 32 75.33 16.16 3 58 13.9 4. 54.52 13.06 57.25 14.63 7 6 65.27 15.8 VO+WN Part 1 Attempt 1/10 for 10 pts. What was the arithmetic average return for stock B? 4+ decir Submit Part 2 Attempt 1/10 for 10 pts. What was the standard deviation of returns for stock B?...
Problem 11 Intro Stock 1 has an expected return of 17% and a standard deviation of...
Problem 11 Intro Stock 1 has an expected return of 17% and a standard deviation of 28%. Stock 2 has an expected return of 9% and a standard deviation of 15%. Their correlation is 0.32. Part 1 Attempt 5/5 for 6 pts. What is the minimum standard deviation that is achievable by combining both stocks? 3+ decima Submit
Problem 17 Intro You've assembled the following portfolio: Stock Beta Portfolio weight 1 1.6 0.2 2...
Problem 17 Intro You've assembled the following portfolio: Stock Beta Portfolio weight 1 1.6 0.2 2 1.1 3 0.7 0.5 The expected market return is 9% and the risk-free rate is 2%. Assume that the CAPM holds. i | Attempt 1/5 for 10 pts. Part 1 What is the beta of the portfolio? No decimals Submit Part 2 IB Attempt 175 for 10 pts. What is the expected return of your portfolio? 3+ decimals Submit Intro We know the following...
Problem 14 Intro Apple stock had a return of 11%two years ago, and 22% last year. Google stock had a return of 12% two years ago, and 13% last year. Attempt 1/10 for 10 pts. Part 1 lf you invest 30% in Apple and 70% in Google, what is the expected return of your portfolio for next year, if you use the past as a guide for the future (which is generally not a good idea for calculating expected returns)?...
Problem 14 44ゆ Intro Apple stock had a return of 11%two years ago, and 22% last year. Google stock had a return of 12% two years ago, and 13% last year. Attempt 1/10 for 10 pts Part 1 Ifyou invest 30% in Apple and 70% in Google, what is the expected return of your porttolo for next year, if you use the past as a guide for the future (which is generally not a good idea for calculating expected returns)?...
Intro You have $10,000 to invest and are deciding between investing in an equity mutual fund and Treasury bills. The fund has an expected return of 9% and a standard deviation of returns of 20%. T-bills have a return of 4%. Part 1 La Attempt 3/5 for 8 pts. If you put 76% into the mutual fund, what is your expected return? 3+ decimals Submit Part 2 | Attempt 1/5 for 10 pts. What is the standard deviation of returns...
Problem 10 Intro Stock 1 has an expected return of 7% and a standard deviation of 28%. Stock 2 has an expected return of 14% and a standard deviation of 24%. Their correlation is 0.35. You invest 30% in stock 1 and 70% in stock 2. Part 1 Attempt 1/5 for 10 pts. What is the expected return of the portfolio? 0.119 E(r) = wiE(ru) + w2E(+2) = 0.3 0.07 +0.7.0.14 = 0.119 – Attempt 2/5 for 9 pts. Part...
Problem 3 Intro The return statistics for two stocks and T-bills are given below: B C D T- 2 Expected return 3 Variance 4 Standard deviation 5 Covariance Stock A Stock B bills 0.094 0.064 0.02 0.1225 0.0729 0.35 0.27 0.02835 Part 1 | Attempt 1/10 for 10 pts. What is the Sharpe ratio of a portfolio with 70% invested in stock A and the rest in stock B? B+ decima Submit
Problem 17 Intro You've assembled the following portfolio: Stock Beta Portfolio weight The expected market return is 5% and the risk-free rate is 2%. Assume that the CAPM holds. Part 1 Attempt 1/5 for 10 pts. What is the beta of the portfolio? 2+ decimals Submit VB Attempt 1/5 for 10 pts. Part 2 What is the expected return of your portfolio? 3. decimals Submit
Intro ABC Corp. has just paid a dividend of $0.49. ABC has an annual required return of 9.52%. Part 1 18 Attempt 1/10 for 10 pts. If dividends are annual and expected to be constant, what is the intrinsic value of ABC stock? 1+ decima Submit 1 - Attempt 1/10 for 10 pts. Part 2 What is ABC's dividend yield? 3+ decima Submit Part 3 18 | Attempt 1/10 for 10 pts. From now on, assume that the dividend of...
Problem 5 Intro The following table shows historical end-of- year prices for two non-dividend-paying stocks. ТА ТВ с 1 Year Stock A Stock B 2 1 64.94 14.3 32 75.33 16.16 3 58 13.9 4. 54.52 13.06 57.25 14.63 7 6 65.27 15.8 VO+WN Part 1 Attempt 1/10 for 10 pts. What was the arithmetic average return for stock B? 4+ decir Submit Part 2 Attempt 1/10 for 10 pts. What was the standard deviation of returns for stock B?...
Problem 11 Intro Stock 1 has an expected return of 17% and a standard deviation of 28%. Stock 2 has an expected return of 9% and a standard deviation of 15%. Their correlation is 0.32. Part 1 Attempt 5/5 for 6 pts. What is the minimum standard deviation that is achievable by combining both stocks? 3+ decima Submit
Problem 17 Intro You've assembled the following portfolio: Stock Beta Portfolio weight 1 1.6 0.2 2 1.1 3 0.7 0.5 The expected market return is 9% and the risk-free rate is 2%. Assume that the CAPM holds. i | Attempt 1/5 for 10 pts. Part 1 What is the beta of the portfolio? No decimals Submit Part 2 IB Attempt 175 for 10 pts. What is the expected return of your portfolio? 3+ decimals Submit Intro We know the following...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago