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.
-
Describe how the file manager allocates a file to a single user.
List the steps that...
asked 12 minutes ago -
For the following reaction:
IBr(g) + 4F2(g) → IF5(g) +
BrF3(g)
Compound
ΔH°f (kJ mol-1)...
asked 14 minutes ago -
Assuming the simple probability of even A is given as P(A) and
the simple probability of...
asked 17 minutes ago -
2.- It is known that 20% of the students on campus are smokers.
If 8 students...
asked 17 minutes ago -
Provide a summary/reflection of what you gleaned of how law
enforcement is effect by Unconventional Weapons...
asked 38 minutes ago -
From the following heats of combustion,
CH3OH(l) + 3/2O2(g) → CO2(g) +
2H2O(l)
ΔHorxn = –726.4...
asked 31 minutes ago -
Floating Point Representation
Consider a computer that stores information using 10 bits words.
The first bit...
asked 1 hour ago -
. The theoretical weight percent of carbon in (CH3)3N is:
A. 20.32% B. 81.95% C. 9.97%...
asked 53 minutes ago -
The rate of a certain reaction is given by the following rate
law:
rate = k[H2][I2]...
asked 48 minutes ago -
A 10,000 uF capacitor is in series with a 1 uH inductor. What is
Zeq of...
asked 52 minutes ago -
Draw the molecular orbital diagram for O2-
(oxygen molecule with a negative charge).
asked 1 hour ago -
Of all the different weapons discussed in this chapter that make
up CBRNE,
Which group do...
asked 1 hour ago