Purchase Solution

Finance: Evalulate Jane's Three Possible Investments in Stock

Not what you're looking for?

Ask Custom Question

Jane is considering investing in three different stocks or creating three distinct two-stock portfolios. Jane considers herself to be a rather conservative investor. She is able to obtain forecasted returns for the three securities for the years 2010 through 2016. The data are as follows:

Earning before depreciation, interest and tax.

Year A B C
2010 10% 10% 10%
2011 13 10 14
202 15 8 10
2013 14 12 11
2014 16 12 9
20145 14 15 9
2016 12 15 10

In any of the possible two- stock portfolios, the weight of each stock in the portfolio will be 50%. The three possible portfolio combinations are AB, AC, and BC.

To Do
Create a spreadsheet similar to Tables 5.7 and 5.8 ( which can be viewed at www.prenhall.com/gitman) to answer the following:

a. Calculate the expected return for each individual stock.
b. Calculate the standard deviation for each individual stock.
c. Calculate the expected returns for portfolio 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.

Purchase this Solution

Solution Summary

This solution provides a complete computation of the given finance problem formatted in Excel.

Solution Preview

See the attached Excel file for format and formulas.

1.       Spreadsheet Exercise
Jane is considering investing in three different stocks or creating three distinct two-stock portfolios. Jane considers herself to be a rather conservative investor. She is able to obtain forecasted returns for the three securities for the years 2010 through 2016. The data are as follows:
Earning before depreciation, interest and ...

Purchase this Solution


Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.