Given the spreadsheet below, calculate the portfolio beta and the expected return on this two stock portfolio

Question:

Given the spreadsheet below, calculate the portfolio beta and the expected return on this two stock portfolio using the CAPM.
a. If the weights were 50/50, would this increase or decrease the portfolio return?
b. If the market's expected return had been 8% with the 60/40 weights, would this increase or decreased the portfolio return?
The Market's Expected Return
The
Risk Free Rate
Beta for Bateman Industires…………………………………...9%
Beta for Advanced Solar Arrays 1.34……………………….2.50%
Weight for Bateman…………………………………………..0.98
Weigh for Solar Arrays
Portfolio Beta………………………………………………….60%
Expected Return on the Portfolio……………………………...40%
Expected Return
The expected return is the profit or loss an investor anticipates on an investment that has known or anticipated rates of return (RoR). It is calculated by multiplying potential outcomes by the chances of them occurring and then totaling these...
Portfolio
A portfolio is a grouping of financial assets such as stocks, bonds, commodities, currencies and cash equivalents, as well as their fund counterparts, including mutual, exchange-traded and closed funds. A portfolio can also consist of non-publicly...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: