EBK PEARSON ETEXT PRINCIPLES OF MANAGER
15th Edition
ISBN: 9780136846901
Author: SMART
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 8, Problem 1SE
Spreadsheet Exercise
Jane is considering investing in three different stocks or creating three distinct two-stock portfolios. Jane views herself as a rather conservative investor. She is able to obtain historical returns for the three securities for the years 2012 through 2018. The data are given in the following table.
In any of the possible two-stock portfolios, the we1ght of each stock m the portfolio will be 50%. The three possible portfolio combinations are AB, AC, and BC.
To Do
Create a spreadsheet similar to Tables 8.6 and 8.7 to answer the following:
- a. Calculate the average return for each individual stock.
- b. Calculate the standard deviation for each individual stock.
- c. Calculate the average returns for portfolios AB, AC, and BC.
- d. Calculate the standard deviations for portfolios AB, AC, and BC.
- e. Would you recommend that Jane invest in the single stock A or the portfolio consisting of stocks A and B? Explain your answer from a risk-return viewpoint
- f. Would you recommend that Jane invest in the single stock B or the portfolio consisting of stocks B and C? Explain your answer from a risk-return viewpoint
My Lab Finance Visit www.pearson.com/mylab/finance for Chapter Case: Analyzing Risk and Return on Chargers Products’ Investments, Group Exercises, and numerous online resources.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
John works for a fixed income hedge fund. Your fund invests in $100 million in mortgage-backed-bonds (MBS) with a duration of 10. He finances these bonds with $2 million in investor capital and $98 million of overnight repurchase agreements (required haircut=2%) with an interest rate of 1%.
After hours, negative news comes out on the evening news that increases yields on MBS by 25 basis points. Moreover, effective tomorrow, because of this bad news, repurchase agreement lenders will now require a haircut of 3% to lend to you via repurchase agreements with your MBS as collateral. Assuming he receives no interest payments from your MBS, how much cash does he need to not default on today’s repurchase agreement and to keep the position open for one more day tomorrow?
Please provide calculations in excel.
220
6-1. (Expected return and risk) Universal Corporation is planning to invest in a secu- LO1 LO2
rity that has several possible rates of return. Given the following probability distribu-
tion of returns, what is the expected rate of return on the investment? Also, compute
the standard deviations of the returns. What do the resulting numbers represent?
PROBABILITY
0.10
0.20
0.30
RETURN
-10%
5%
0.40
10%
25%
6-2. (Average expected return and risk) Given the holding-period returns shown here,
calculate the average returns and the standard deviations for the Kaifu Corporation Myb
and for the market.
MONTH
1
2
3
KAIFU CORP.
4%
6%
0%
2%
MARKET
2%
3%
1%
-1%
6-3. (Expected rate of return and risk) Carter, Inc. is evaluating a security. Calculate the
investment's expected return and its standard deviation.
PROBABILITY
0.15
RETURN
6%
0.30
9%
0.40
10%
0.15
15%
PART 2 The Valuation of Financial Assets
6-4. (Expected rate of return and risk) Summerville, Inc. is considering an investment in
one of…
6-14. (Expected return, standard deviation, and capital asset pricing model) The following LO5
are the end-of-month prices for both the Standard & Poor's 500 Index and Nike's
common stock.
a. Using the data here, calculate the holding-period returns for each of the months.
NIKE
S&P 500 INDEX
2017
January
$52.90
$2,279
February
57.16
2,364
March
55.73
2,363
April
55.41
2,384
May
52.99
2,412
June
59.00
2,423
July
59.05
2,470
August
52.81
2,472
September
51.85
2,519
October
54.99
2,575
November
60.42
2,648
December
62.55
2,674
2018
January
68.22
2,824
b. Calculate the average monthly return and the standard deviation for both the
S&P 500 and Nike.
222
PART 2 • The Valuation of Financial Assets
c. Develop a graph that shows the relationship between the Nike stock returns
and the S&P 500 Index. (Show the Nike returns on the vertical axis and the
S&P 500 Index returns on the horizontal axis as done in Figure 6-5.)
d. From your graph, describe the nature of the relationship between Nike stock…
Chapter 8 Solutions
EBK PEARSON ETEXT PRINCIPLES OF MANAGER
Ch. 8.1 - What is risk in the context of financial decision...Ch. 8.1 - Prob. 8.2RQCh. 8.1 - Compare the following risk preferences: (a) risk...Ch. 8.2 - Explain how the range is used in scenario...Ch. 8.2 - Prob. 8.5RQCh. 8.2 - Prob. 8.6RQCh. 8.2 - What does the coefficient of variation reveal...Ch. 8.3 - What is an efficient portfolio? How can the return...Ch. 8.3 - Prob. 8.9RQCh. 8.3 - How does international diversification enhance...
Ch. 8.4 - Prob. 8.11RQCh. 8.4 - Prob. 8.12RQCh. 8.4 - Prob. 8.13RQCh. 8.4 - What impact would the following changes have on...Ch. 8 - Prob. 1ORCh. 8 - Prob. 8.1STPCh. 8 - Prob. 8.2STPCh. 8 - Prob. 8.1WUECh. 8 - Prob. 8.2WUECh. 8 - Prob. 8.3WUECh. 8 - Prob. 8.4WUECh. 8 - Prob. 8.5WUECh. 8 - Prob. 8.6WUECh. 8 - Prob. 8.1PCh. 8 - Prob. 8.2PCh. 8 - Prob. 8.3PCh. 8 - Prob. 8.4PCh. 8 - Prob. 8.5PCh. 8 - Learning Goal 2 P8-6 Bar charts and risk Swans...Ch. 8 - Prob. 8.7PCh. 8 - Prob. 8.8PCh. 8 - Prob. 8.9PCh. 8 - Prob. 8.10PCh. 8 - Prob. 8.11PCh. 8 - Prob. 8.12PCh. 8 - Prob. 8.13PCh. 8 - Prob. 8.14PCh. 8 - Learning Goal 4 P8- 15 Correlation, risk, and...Ch. 8 - Prob. 8.16PCh. 8 - Learning Goal 5 P8- 17 Total, nondiversifiable,...Ch. 8 - Prob. 8.18PCh. 8 - Prob. 8.19PCh. 8 - Prob. 8.20PCh. 8 - Prob. 8.21PCh. 8 - Prob. 8.22PCh. 8 - Prob. 8.23PCh. 8 - Prob. 8.24PCh. 8 - Prob. 8.25PCh. 8 - Prob. 8.26PCh. 8 - Prob. 8.27PCh. 8 - Learning Goal 6 P8- 28 Security market line (SML)...Ch. 8 - Prob. 8.29PCh. 8 - Prob. 8.30PCh. 8 - Prob. 8.31PCh. 8 - Spreadsheet Exercise Jane is considering investing...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- required rates of return for the three securities? 6-23. (Portfolio beta and security market line) You own a portfolio consisting of the ☑ stocks below: PERCENTAGE OF STOCK OR SECURITY PORTFOLIO BETA EXPECTED RETURN 1 20% 1.00 12% 2 30% 0.85 8% 3 15% 1.20 12% 25% 0.60 7% 5 10% 1.60 16% The risk-free rate is 3 percent. Also, the expected return on the market portfolio is 11 percent. a. Calculate the expected return of your portfolio. (Hint: The expected return of a portfolio equals the weighted average of the individual stocks' expected returns, where the weights are the percentage invested in each stock.) b. Calculate the portfolio beta. c. Given the foregoing information, plot the security market line on paper. Plot the stocks from your portfolio on your graph. d. From your plot in part (c), which stocks appear to be your winners and which ones appear to be your losers? e. Why should you consider your conclusion in part (d) to be less than certain? 6-24. (Portfolio beta) Assume you…arrow_forwardWizzy Wigs is an unleveraged firm with $80 million in total assets, 2 million shares outstanding, and $15 million in EBIT. The shares price is $40, tax adjusted cost of debt 4.61%, and corporate tax rate of 21%. What are the returns on equity (ROEs) for the firm if it shifts to a 0.75 debt-to-equity ratio and for an individual with 700 shares who created homemade leverage at the same DE ratio? ◻ firm 25.61%; inv. 24.99% firm 18.24%; inv. 19.46% firm 38.59%; inv. 35.53% firm 23.19%; inv. 22.46% firm 30.07%; inv. 30.19% Please show work on excel spreadsheetarrow_forwardYou are running a hot Internet company. Analysts predict that its earnings will grow at 20% per year for the next 9 years. After that, as competition increases, earnings growth is expected to slow to 4% per year and continue at that level forever. Your company has just announced earnings of $4 million. What is the present value of all future earnings if the interest rate is 9%? (Assume all cash flows occur at the end of the year.) The present value of all future earnings is million. (Round to two decimal places.)arrow_forward
- 3. Losses for an insurance company next year are estimated to be 100 million with standard deviation 250 million. Using lognormal and two-parameter Pareto distributions to obtain the VaR at the 95%, 97.5%, 99% security levels. Comment on your findings.arrow_forwardA company sold 4 million shares in its IPO, at a priceof $18.50 per share. Management negotiated a fee(the underwriting spread) of 7% on this transaction.What was the dollar cost of this fee?arrow_forwardConsider the following three bonds (see Table 1), which all have a par value of $100 and pay coupons semiannually if the coupon rate is not zero. What is the 6.5-year spot rate on a BEY basis? Bond Coupon Rate Price Maturity(yrs) A 106 3 6 75 B 0 6 115 C 4 6.5arrow_forward
- Problem 6-8 Project Evaluation Dog Up! Franks is looking at a new sausage system with an installed cost of $445,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped for $53,000. The sausage system will save the firm $139,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $25,000. If the tax rate is 23 percent and the discount rate is 11 percent, what is the NPV of this project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPVarrow_forwardAn investment has an expected return of X percent per year, is expected to make annual payments of $3,170 for 7 years, is worth $14,532, and the first payment is expected in 1 year What is X? Input instructions: Input your answer as the number that appears before the percentage sign. For example, enter 9.86 for 9.86% (do not enter .0986 or 9.86%). Round your answer to at least 2 decimal places. percentarrow_forwardYou just took out a loan for $29,449 that requires annual payments of $4,570 for 20 years. The interest rate on the loan is X percent per year and the first regular payment will be made in 1 year. What is X? Input instructions: Input your answer as the number that appears before the percentage sign. For example, enter 9.86 for 9.86% (do not enter .0986 or 9.86%). Round your answer to at least 2 decimal places. percentarrow_forward
- Could you please help explain the follow-up interviews in a data collecting method? How is to use the follow-up interviews in qualitative data collection methods? Could the qualitative data collection methods can be used in the thematic analysis?arrow_forwardWe often hear about the importance of financial statement analysis. Given the various statements prepared and all the information included therein, the question becomes which of the financial statements should get a closer review and why? Explain what the basic financial statements are and what is the purpose of each statement. Within the different statements, in your opinion what is/are the key areas of information to focus on and why? Be specific as to the importance of your selection.arrow_forwardDon't used hand raiting and don't used Ai solutionarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Pfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Dividend disocunt model (DDM); Author: Edspira;https://www.youtube.com/watch?v=TlH3_iOHX3s;License: Standard YouTube License, CC-BY