Securities and Portfolio Return Computations
Beginning Stock Price $73
Ending Stock Price $82
Dividend $1.20
Percentage Total Return = #NAME?
CHAPTER 10: PROBLEM 12
Stock Return the past 5 years -18.35% 14.72% 28.47% 6.48% 16.81%
Holding Period Return for the Stock = #NAME? (Note: Subtract your answer by 1 to obtain the correct percentage answer)
CHAPTER 10: PROBLEM 14
Price of Preferred Stock Last Year $94.83
Current Price of Preferred Stock $96.20
Preferred Stock Dividend 4.20%
Face Value of Preferred Stock $100
Total Return = #NAME?
CHAPTER 10: PROBLEM 15
Stock Price 3 Months Ago $41.75
Current Stock Price $44.07
First calculate the total return for the 3 months #NAME?
Then calculate the APR by multiplying the answer in cell B35 by 4 #NAME?
EAR (Effective Annual Rate) = #NAME?
CHAPTER 11: PROBLEM 2
Stock A $3,900
Stock B $5,700
Total Value of the Portfolio $9,600
Expected Return on Stock A 9.50%
Expected Return on Stock B 15.20%
Expected Return on the Portfolio = #NAME?
CHAPTER 11: PROBLEM 12
Beta 0.85
Expected Return on the Market 11.50%
Risk-Free Rate 3.40%
Expected Return on the Stock = #NAME?
CHAPTER 12: PROBLEM 1
Beta 1.21
Risk-Free Rate 3.50%
Expected Return on the Market 11%
Cost of Equity = #NAME?
CHAPTER 12: PROBLEM 5
Common Stock weight 70%
Debt weight 30%
Cost of Equity 13%
Cost of Debt 6%
Tax Rate 35%
WACC = #NAME?
