Principles of Managerial Finance, Student Value Edition (15th Edition) (The Pearson Series in Finance)
15th Edition
ISBN: 9780134478166
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
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
Don't used Ai solution
Don't used Ai solution
Scenario one: Under what circumstances would it be appropriate for a firm to use different cost of capital for its different operating divisions? If the overall firm WACC was used as the hurdle rate for all divisions, would the riskier division or the more conservative divisions tend to get most of the investment projects? Why? If you were to try to estimate the appropriate cost of capital for different divisions, what problems might you encounter? What are two techniques you could use to develop a rough estimate for each division’s cost of capital?
Chapter 8 Solutions
Principles of Managerial Finance, Student Value Edition (15th Edition) (The Pearson Series in Finance)
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
- Scenario three: If a portfolio has a positive investment in every asset, can the expected return on a portfolio be greater than that of every asset in the portfolio? Can it be less than that of every asset in the portfolio? If you answer yes to one of both of these questions, explain and give an example for your answer(s). Please Provide a Referencearrow_forwardHello expert Give the answer please general accountingarrow_forwardScenario 2: The homepage for Coca-Cola Company can be found at coca-cola.com Links to an external site.. Locate the most recent annual report, which contains a balance sheet for the company. What is the book value of equity for Coca-Cola? The market value of a company is (# of shares of stock outstanding multiplied by the price per share). This information can be found at www.finance.yahoo.com Links to an external site., using the ticker symbol for Coca-Cola (KO). What is the market value of equity? Which number is more relevant to shareholders – the book value of equity or the market value of equity?arrow_forward
- FILE HOME INSERT Calibri Paste Clipboard BIU Font A1 1 2 34 сл 5 6 Calculating interest rates - Excel PAGE LAYOUT FORMULAS DATA 11 Α΄ Α΄ % × fx A B C 4 17 REVIEW VIEW Alignment Number Conditional Format as Cell Cells Formatting Table Styles▾ Styles D E F G H Solve for the unknown interest rate in each of the following: Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 7 8 Present value Years Interest rate 9 10 11 SA SASA A $ 181 4 $ 335 18 $ 48,000 19 $ 40,353 25 12 13 14 15 16 $ SA SA SA A $ Future value 297 1,080 $ 185,382 $ 531,618arrow_forwardB B Canning Machine 2 Monster Beverage is considering purchasing a new canning machine. This machine costs $3,500,000 up front. Required return = 12.0% Year Cash Flow 0 $-3,500,000 1 $1,000,000 2 $1,200,000 3 $1,300,000 4 $900,000 What is the value of Year 3 cash flow discounted to the present? 5 $1,000,000 Enter a response then click Submit below $ 0 Submitarrow_forwardFinances Income Statement Balance Sheet Finances Income Statement Balance Sheet Materia Income Statement Balance Sheet FY23 FY24 FY23 FY24 FY23 FY24 Sales Cost of Goods Sold 11,306,000,000 5,088,000,000 13,206,000,000 Current Current Assets 5,943,000,000 Other Expenses 4,523,000,000 5,283,000,000 Cash 211,000,000 328,600,000 Liabilities Accounts Payable 621,000,000 532,000,000 Depreciation 905,000,000 1,058,000,000 Accounts 502,000,000 619,600,000 Notes Payable 376,000,000 440,000,000 Earnings Before Int. & Tax 790,000,000 922,000,000 Receivable Interest Expense 453,000,000 530,000,000 Total Current Inventory 41,000,000 99,800,000 997,000,000 972,000,000 Taxable Income 337,000,000 392,000,000 Liabilities Taxes (25%) 84,250,000 98,000,000 Total Current 754,000,000 1,048,000,000 Long-Term Debt 16,529,000,000 17,383,500,000 Net Income Dividends 252,750,000 294,000,000 Assets 0 0 Fixed Assets Add. to Retained Earnings 252,750,000 294,000,000 Net Plant & 20,038,000,000 21,722,000,000…arrow_forward
- Do you know what are Keith Gill's previous projects?arrow_forwardExplain why long-term bonds are subject to greater interest rate risk than short-term bonds with references or practical examples.arrow_forwardWhat does it mean when a bond is referred to as a convertible bond? Would a convertible bond be more or less attractive to a bond holder than a non-convertible bond? Explain in detail with examples or academic references.arrow_forward
- Alfa international paid $2.00 annual dividend on common stock and promises that the dividend will grow by 4% per year, if the stock’s market price for today is $20, what is required rate of return?arrow_forwardgive answer general accounting.arrow_forwardGive me answers in general financearrow_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