Question

In: Finance

Please show all work and formula: Please use the information on the table below to answer...

Please show all work and formula:

Please use the information on the table below to answer this question.

Security                       Actual Return             Beta

A                                 12%                             1.2

B                                  10%                             1.0

C                                  14%                             1.4

  1. Assume the risk-free interest rate is 1% and the market risk premium is 5.5%. An investor would like to invest $40,000 in Security A, $25,000 in security B and $50,000 in Security C. Find the portfolio’s expected return.
  2. Find the portfolio’s actual return.
  3. Based on your answers to a and b, is the portfolio’s return higher or lower than required? How should prices react?

Solutions

Expert Solution

Expected returns

Stock A

As per CAPM
expected return = risk-free rate + beta * (Market risk premium)
Expected return% = 1 + 1.2 * (5.5)
Expected return% = 7.6

Stock B

As per CAPM
expected return = risk-free rate + beta * (Market risk premium)
Expected return% = 1 + 1 * (5.5)
Expected return% = 6.5

Stock C

As per CAPM
expected return = risk-free rate + beta * (Market risk premium)
Expected return% = 1 + 1.4 * (5.5)
Expected return% = 8.7
Total Portfolio value = Value of Stock A + Value of Stock B + Value of Stock C
=40000+25000+50000
=115000
Weight of Stock A = Value of Stock A/Total Portfolio Value
= 40000/115000
=0.3478
Weight of Stock B = Value of Stock B/Total Portfolio Value
= 25000/115000
=0.2174
Weight of Stock C = Value of Stock C/Total Portfolio Value
= 50000/115000
=0.4348
Expected return of Portfolio = Weight of Stock A*Expected return of Stock A+Weight of Stock B*Expected return of Stock B+Weight of Stock C*Expected return of Stock C
Expected return of Portfolio = 7.6*0.3478+6.5*0.2174+8.7*0.4348
Expected return of Portfolio = 7.8391
Total Portfolio value = Value of Stock A + Value of Stock B + Value of Stock C
=40000+25000+50000
=115000
Weight of Stock A = Value of Stock A/Total Portfolio Value
= 40000/115000
=0.3478
Weight of Stock B = Value of Stock B/Total Portfolio Value
= 25000/115000
=0.2174
Weight of Stock C = Value of Stock C/Total Portfolio Value
= 50000/115000
=0.4348
Actual return of Portfolio = Weight of Stock A*Actual return of Stock A+Weight of Stock B*Actual return of Stock B+Weight of Stock C*Actual return of Stock C
Actual return of Portfolio = 12*0.3478+10*0.2174+14*0.4348
Actual return of Portfolio = 12.4348

Actual return is more than expected return prices will fall


Related Solutions

Please show all work and formulas Please use the following information to answer this question. State    ...
Please show all work and formulas Please use the following information to answer this question. State     Probability       A                     B                      C Boom   .3                     -10%                5%                   0% Normal            .4                     5                      3                      2                      Bust     .3                     10                    -5                     2 Find the expected return and variance of the portfolio if an investor spent $5000 on A, $8000 on B and $7000 on C.
Please show all work and formulas Please use the following information to answer this question. State    ...
Please show all work and formulas Please use the following information to answer this question. State     Probability       A                     B                      C Boom   .3                     -10%                5%                   0% Normal            .4                     5                      3                      2                      Bust     .3                     10                    -5                     2 Find the expected return and variance of the portfolio if an investor spent $5000 on A, $8000 on B and $7000 on C.
Please answer the problem below for all parts. Please show all work and write clearly. Thanks....
Please answer the problem below for all parts. Please show all work and write clearly. Thanks. (Apply total probability and Bayes’ rules) A large industrial firm uses three local motels to provide overnight accommodations for its clients. From past experience it is known that 22% of the clients are assigned rooms at the Ramada Inn, 50% at the Sheraton, and 28% at the Lakeview Motor Lodge. If the plumbing is faulty in 5% of the rooms at the Ramada Inn,...
Please answer all questions, fill in table and show calculations. The table below shows the hypothetical...
Please answer all questions, fill in table and show calculations. The table below shows the hypothetical prices and quantities demanded of a software product. Assume that the fixed cost of setting up the production of software is $200 and the marginal cost is $5. Fill out the table by calculating the revenue, the marginal revenue, total cost, the marginal cost, and the profit. Give a general definition of price elasticity of demand. Explain the factors that make the demand of...
Please show all your work step by step and all the formula that is used. This...
Please show all your work step by step and all the formula that is used. This is my 3rd time posting as people do not explain what they are doing. Therefore, do not answer if you can't explain. D. What is the present value (PV) of a 12-years lease arrangement with an interest rate of 7.5% that requires annual payments of $4250. Per year with first payment being due now? E. A recent college graduate hopes to have $200000. Saved...
Use the following information to answer the questions in this quiz. Please show your work by...
Use the following information to answer the questions in this quiz. Please show your work by submitting a Word, Excel, or JPEG file in the "Project 2 Drop Box". INFORMATION OLD MACHINE: Original Purchase Price $     550,000.00 Original Life 10 YEARS Remaining Life 5 YEARS Straight line depreciation in use Salvage Value $      50,000.00 Current Fair Market Value $     260,000.00 INFORMATION NEW MACHINE A: Purchase Price      $895,000.00 Estimated Life 5 YEARS Use Straight Line Depreciation Method Estimated Salvage Value...
Please answer all parts of the question. Please show all work and all steps. 1a.) Show...
Please answer all parts of the question. Please show all work and all steps. 1a.) Show that the solutions of x' = arc tan (x) + t cannot have maxima 1b.) Find the value of a such that the existence and uniqueness theorem applies to the ivp x' = (3/2)((|x|)^(1/3)), x(0) = a. 1c.) Find the limits, as t approaches both positive infinity and negative infinity, of the solution Φ(t) of the ivp x' = (x+2)(1-x^4), x(0) = 0
PLEASE SHOW ALL THE FORMULA IN AN EXCEL FORMAT AND ANSWER ALL QUESTIONS All problems must...
PLEASE SHOW ALL THE FORMULA IN AN EXCEL FORMAT AND ANSWER ALL QUESTIONS All problems must be solved using Excel formulas to receive credit. Question Set 1. You are in charge of quality control for computer monitors at Dell. You have data on twenty-five batches of monitors, tracking five types of defects: brightness, color, contrast, dead pixels, and stuck pixels. These data are given in the table below. 1. For each defect type, find the average number of defects per...
Please answer the questions in the space provided below each question. Show all of your work...
Please answer the questions in the space provided below each question. Show all of your work and circle your final answer. You forecast there are three potential scenarios for the economy: a bull, flat, and bear market. You also estimate the returns for a stock and bond mutual fund as follows: Economic Scenario Stock Fund Bond Fund Probability of Scenario Recession -18% 6% 0.3 Flat 8% 4% 0.45 Boom 20% -8% 0.25 Using this information, you find for the stock...
Use the data in Table 2.0, answer questions 1, 2, & 3. Please show all of...
Use the data in Table 2.0, answer questions 1, 2, & 3. Please show all of your working. Table 2.0 Data for a sample of 50 individual in a Cardiovascular Disease Study Participant ID Weight (kg) Height (cm) Smoking status Blood glucose 1 70 165 1 107 2 60 162 0 145 3 62 150 1 237 4 66 165 1 91 5 70 162 0 185 6 59 165 0 106 7 47 160 0 177 8 66 170...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT