In: Finance
Beta of portfolio is calculated in excel and screen shot provided below:
Beta of portfolio is 0.87.
Risk free rate = 6%
Market return = 11%
Required rate of return of company stock is calculated below using CAPM formula:
Required rate of return = Risk free rate + (Market Return - Risk free rate) × Beta
= 6% + (11% - 6%) × 0.87
= 6% + (5% × 0.87)
= 6% + 4.35%
= 10.35%
Hence, required rate of return of company stock is 10.35%.