Explore BrainMass
Share

Calculating the expected returns

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Suppose that the Treasury bill rate were 6% rather than 4%. Assume that the expected return on the market stays at 10%. Use the betas in Table 8.2 (p. 193) - provided below.

Stock Beta (B) Expected return Stock Beta (B) Expected return
Amazon 2.16 15.40% Disney 0.96 7.00%
Ford 1.75 12.60% Newmont 0.63 4.70%
Dell 1.41 10.20% Exxon Mobil 0.55 4.20%
Starbucks 1.16 8.40% Johnson&Johnson 0.5 3.80%
Boeing 1.14 8.30% Campbell Soup 0.3 2.40%

a. Calculate the expected return from Dell.
b. Find the highest expected return that is offered by one of these stocks.
c. Find the lowest expected return that is offered by one of these stocks.
d. Would Ford offer a higher or lower expected return if the interest rate were 6% rather than 4%? Assume that the expected market return stays at 10%.
e. Would Exxon Mobil offer a higher or lower expected return if the interest rate were 8%?

© BrainMass Inc. brainmass.com March 21, 2019, 11:02 pm ad1c9bdddf
https://brainmass.com/economics/finance/calculating-the-expected-returns-442527

Attachments

Solution Preview

Please refer attached file for better clarity of formulas in MS Excel.

Formula Calculation
A. Dell's expected return Risk free rate+beta*(market return-risk free rate) 11.64%

Stock Beta (B) T Bill Risk-Free Rate Market Return Expected return
Amazon ...

Solution Summary

Solution describes the steps to calculate the expected returns in the given cases.

$2.19