Integrated Excel Problem 9-7 Portfolio Return Year-to-date, Oracle had earned a -1.34 percent return. During the same time period, Valero Energy earned 7.96 percent and McDonald's earned 0.88 percent. If you have a portfolio made up of 30 percent Oracle, 25 percent Valero Energy, and 45 percent McDonald's, what is your portfolio return? Navigation:

5. You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: Manager X Return (%) Manager Y Return (%) Year -6.5 -1.5 -1.5 -3.5 -1.5 3 -1.5 4 -1.0 3.5 0.0 4.5 4.5 6.5 6.5 7.5 8.5 8.5 13.5 12.5 10 17.5 13.5 a. For each manager, calculate (1) the average annual return, (2) the standard deviation of returns, and (3) the semi-deviation of returns. b. Assuming that the average annual risk-free rate during the 10-year sample period was 1.5 percent, calculate the Sharpe ratio for each portfolio. Based on these computations, which manager appears to have performed the best? c. Calculate the Sortino ratio for each portfolio, using the average risk-free rate as the minimum acceptable return threshold. Based on these computations, which manager appears to have performed the best? d. When would you expect the Sharpe and Sortino measures to provide (1) the same per- formance ranking or (2) different performance rankings? Explain.

Question content area top Part 1 ​(Related to Checkpoint​ 8.3)  ​(CAPM and expected​ returns)   a.  Given the following​ holding-period returns, LOADING...  Month Sugita Corp. Market 1 2.4 ​% 1.0 ​% 2 −1.0      2.0   3 0.0      3.0   4 0.0   0.0   5 7.0      7.0   6 7.0      1.0   ​, compute the average returns and the standard deviations for the Sugita Corporation and for the market. b.  If​ Sugita's beta is 1.84 and the​ risk-free rate is 6 ​percent, what would be an expected return for an investor owning​ Sugita? ​ (Note: Because the preceding returns are based on monthly​ data, you will need to annualize the returns to make them comparable with the​ risk-free rate. For​ simplicity, you can convert from monthly to yearly returns by multiplying the average monthly returns by​ 12.) c.  How does​ Sugita's historical average return compare with the return you should expect based on the Capital Asset…

Problem 6-6: Required Rate of Return CAPM Calculate the required rate of return by using CAPM based on the data below. DATA Risk-free rate = 0.04 Market Risk Premium 0.10 %3D Beta = 1.2

Consider the following bootstrapped 3-year performance of an actively managed investor's portfolio and a relevant benchmark: Investor's Portfolio Benchmark Portfolio Iteration Portfolio Value Portfolio Portfolio Value Portfolio Return t=3 Return p.a. t=3 р.а. 1 1.3 9.1% 1.2 6.3% 0.9 -3.5% 0.9 -3.5% 3 0.9 -3.5% 0.8 -7.2% 4 1.2 6.3% 1.1 3.2% 5 1.3 9.1% 1.2 6.3% What is the tracking error of investor's portfolio relative to the benchmark (compounded outperformance) over 3 years (rounded to one decimal place)? Select one: O a. 1.4% ОБ. 2.7% O. 4.5% O d. 4.6% O e. None of the above

Chapter 10: Applying Excel: Exercise (Part 2 of 2) Requirement 2: Revise the data in your worksheet as follows: A 1 Chapter 10: Applying Excel 2 3 Data 4 Sales 5 6 7 Net operating income ROI Average operating assets Minumum required rate of return If your formulas are correct, you should get the correct answers to the following questions. a. What is the ROI? Residual income B % c. Why is the residual income positive? $ 64,000,000 $ 7,680,000 $ 16,000,000 25% b. What is the residual income? (Negative amount should be indicated by a minus sign.)

You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: Year Manager X Return (%) Manager Y Return (%) 1 -1.5 -6.5 2 -1.5 -3.5 3 -1.5 -1.5 4 -1.0 3.5 5 0.0 4.5 6 4.5 6.5 7 6.5 7.5 8 8.5 8.5 9 13.5 12.5 10 17.5 13.5   a.    For each manager, calculate the average annual return, the standard deviation of returns, and the semi-deviation of returns.   b.    Assuming that the average annual risk-free rate during the 10-year sample period was 1.5 percent, calculate the Sharpe ratio for each portfolio. Based on these computations, which manager appears to have performed the best?   c.     Calculate the Sortino ratio for each portfolio, using the average risk-free rate as the minimum acceptable return threshold. Based on these computations, which manager appears to have performed the best?   d.    When would you expect the Sharpe and…

10. Portfolio Return Year-to-date, Company X had earned a +8% return. During the same time period, Company Y earned +10% and Company Z earned – 6% (negative 6%). If you have a portfolio madeup of 30 percent Company X, 25 percent Company Y, and 45 percent Company Z, what is your portfolio return?_____________% 11. You hold the positions in the table below.COMPANY PRICE # SHARES BETAGoodmonth $25.00 200 + 3.0Icestone $20.00 750 – 1.0Bridgerock $50.00 600 + 2.0A. What is the beta of your portfolio?

You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade: Year Manager X Return (%) Manager Y Return (%) 1 -1.5 -6.5 -1.5 -3.5 3 -1.5 -1.5 4 -1.0 3.5 5 0.0 4.5 4.5 6.5 7 6.5 7.5 8 8.5 8.5 13.5 12.5 10 18.5 14.5 a. For each manager, calculate (1) the average annual return, (2) the standard deviation of returns, and (3) the semi-deviation of returns. Do not round intermediate calculations. Round your answers to two decimal places. Average annual return Standard deviation of returns Semi-deviation of returns Manager X % % % Manager Y % % % b. Assuming that the average annual risk-free rate during the 10-year sample period was 3.0%, calculate the Sharpe ratio for each portfolio. Based on these computations, which manager appears to have performed the best? Do not round intermediate calculations. Round your answers to three decimal places. Sharpe ratio (Manager X): Sharpe ratio (Manager Y): Based on Sharpe ratio -Select- )…

You are evaluating the performance of two portfolio managers, and you have gathered annual return data for the past decade:   Year Manager X Return (%) Manager Y Return (%) 1   -2.5   -6.5   2   -2.5   -5.5   3   -2.5   -2.0   4   -2.0   4.0   5   0.0   5.5   6   5.5   6.5   7   7.5   7.5   8   9.5   8.5   9   13.5   12.5   10   18.5   14.5     For each manager, calculate (1) the average annual return, (2) the standard deviation of returns, and (3) the semi-deviation of returns. Do not round intermediate calculations. Round your answers to two decimal places.     Average annual return Standard deviation of returns Semi-deviation of returns Manager X   %   %   % Manager Y   %   %   %   Assuming that the average annual risk-free rate during the 10-year sample period was 1.0%, calculate the Sharpe ratio for each portfolio. Based on these computations, which manager appears to have performed the best? Do not round intermediate calculations. Round your…