Percentages need to be entered in decimal format, for instance 3% would be entered as .03. That is the return for stock C by the way Adjust the portfolio to consist of 33.33% Stock A, 33.33% Stock B, and 33.33% Stock C (row 31). How does this change affect the portfolio average rate of return, standard deviation, and coefficient of variation versus when 50% was invested in Stock A and 50% in Stock B? Make some other changes in the percentage of stocks in the portfolio (Row 31), making sure that the percentages add up to 100%. For example, you could enter 25% for Stock A, 25% for Stock B, and 50% for Stock C. Notice that the average rate of return for the portfolio remains constant for each scenario, but the standard deviation changes. Would you prefer to hold a portfolio consisting only of Stocks A and B or a portfolio that also includes Stock C? Why or why not?
Risk and return
Before understanding the concept of Risk and Return in Financial Management, understanding the two-concept Risk and return individually is necessary.
Capital Asset Pricing Model
Capital asset pricing model, also known as CAPM, shows the relationship between the expected return of the investment and the market at risk. This concept is basically used particularly in the case of stocks or shares. It is also used across finance for pricing assets that have higher risk identity and for evaluating the expected returns for the assets given the risk of those assets and also the cost of capital.
Percentages need to be entered in decimal format, for instance 3% would be entered as .03.
That is the return for stock C by the way
- Adjust the portfolio to consist of 33.33% Stock A, 33.33% Stock B, and 33.33% Stock C (row 31). How does this change affect the portfolio average
rate of return , standard deviation, and coefficient of variation versus when 50% was invested in Stock A and 50% in Stock B? - Make some other changes in the percentage of stocks in the portfolio (Row 31), making sure that the percentages add up to 100%. For example, you could enter 25% for Stock A, 25% for Stock B, and 50% for Stock C. Notice that the average rate of return for the portfolio remains constant for each scenario, but the standard deviation changes. Would you prefer to hold a portfolio consisting only of Stocks A and B or a portfolio that also includes Stock C? Why or why not?
![C08
GRAPH
INSTRUCTIONS
Chapter 8 Spreadsheet-Related Problem (C08)
Realized Rates of Return
1. There are a number of instructions with which you should be familiar
to use these computerized models. These instructions appear in a
separate worksheet labeled INSTRUCTIONS. If you have not already
done so, you should read these instructions now. To read these
instructions, click on theworksheet labeled INSTRUCTIONS.
2. A graph which shows the return and standard deviation of each
stock and the portfolio will be displayed if you click the worsheet labeled
GRAPH at the bottom of this spreadsheet. To return to this worksheet,
click on the worksheet labeled C08 at the bottom of the GRAPH worksheet.
INPUT DATA:
ΚΕY OUTPUT:
Year
Stock A
Stock B
Stock C
Portfolio
-1
-18.00%
-14.50%
-16.25%
-2
33.00%
21.80%
27.40%
-3
15.00%
30.50%
22.75%
-4
-0.50%
-7.60%
-4.05%
-5
27.00%
26.30%
26.65%
f =
11.30%
11.30%
11.30%
20.79%
20.78%
20.13%
CV =
1.84
1.84
1.78
Percent in:
Stock A
Stock B
Stock C
Portfolio
50.00%
50.00%
0.00%
100.00%
Correlation coefficients, p
Stocks A & B
0.88
Stocks A & C
Stocks B & C](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffd6bd34b-f9e0-4cc4-915e-6f7e1e266a60%2F67817e50-13d6-429e-a2a3-4c93672b2249%2F2gay2tw_processed.jpeg&w=3840&q=75)
![C08
GRAPH
INSTRUCTIONS
4
3
Sd Deviation
Return
2 -
1 -
Stock A
Stock B
Stock C
Portfolio](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffd6bd34b-f9e0-4cc4-915e-6f7e1e266a60%2F67817e50-13d6-429e-a2a3-4c93672b2249%2F1shw7gk_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)