Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
15th Edition
ISBN: 9780134476315
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
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.

Chapter 8, Problem 1SE, Spreadsheet Exercise Jane is considering investing in three different stocks or creating three

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:

  1. a. Calculate the average return for each individual stock.
  2. b. Calculate the standard deviation for each individual stock.
  3. c. Calculate the average returns for portfolios AB, AC, and BC.
  4. d. Calculate the standard deviations for portfolios AB, AC, and BC.
  5. 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
  6. 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.

Blurred answer
Students have asked these similar questions
Standard Deviation for portfolio of two risky investments: Mary Guilott recently graduated from college and is evaluating an investment in two companies common stock. She has collected the following information about the common stock of firm A and firm B: Firm A's common stock: 0.15 (expected return), 0.11(standard Deviation) Firm B's common stock: 0.11 (expected return), 0.06 (standard Deviation) Correlation Coefficient: 0.5   If mary decides to invest 10% of her money in Firm A's common stock and 90% in Firm B's common stock, what is the expected rate of return and the standard deviation of the portfolio
QUESTION 1     Aisyah is a new investor; she approached RHB Securities and the firm has provided her with the following information. Probability (%) Expected return (%) Stock X Stock Y 20 13 15 30 14 13 50 15 12   Using these stocks, she has identified two investment portfolio alternatives:   Alternative 1 50% Stock X, 50% Stock Y Alternative 2 60% Stock X, 40% Stock Y   Required: a. Calculatethe expected return and the standard deviation for Stock X and Stock Y.
Teena is considering investing in Stock A and stock B. She plans to invest $ 25,000 in the low risk stock and $ 50,000 in the high-risk stock. You have been given the following information about these two stocks in the table below:StockABE(R)15%10?25%22%Correlation between A and B0.20Based on the given information above, you are required to:i. Calculate the portfolio weightsii. Calculate the portfolio return.iii. Calculate the portfolio risk.iv. Compare portfolio risk with the individual stock risks and identify the benefit of the diversification of the portfolio.

Chapter 8 Solutions

Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)

Knowledge Booster
Background pattern image
Finance
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Personal Finance
Finance
ISBN:9781337669214
Author:GARMAN
Publisher:Cengage
Text book image
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Text book image
PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Text book image
EBK CFIN
Finance
ISBN:9781337671743
Author:BESLEY
Publisher:CENGAGE LEARNING - CONSIGNMENT
Dividend disocunt model (DDM); Author: Edspira;https://www.youtube.com/watch?v=TlH3_iOHX3s;License: Standard YouTube License, CC-BY