Question: please show work on excel thank you. Manipulating CAPM Use the basic equation for the capital asset pricing model (CAPM) to work each of the

please show work on excel thank you.
Manipulating CAPM Use the basic equation for the capital asset pricing model (CAPM) to work each of the following problems. a. Find the required return for an asset with a beta of 1.51 when the risk-free rate and market return are 7% and 14%, respectively. b. Find the risk-free rate for a firm with a required return of 11.539% and a beta of 1.12 when the market return is 11%. c. Find the market return for an asset with a required return of 13.043% and a beta of 1.51 when the risk-free rate is 8%. d. Find the beta for an asset with a required return of 12.906% when the risk-free rate and market return are 5% and 10.9%, respectively a. The required return for an asset with a beta of 1.51 when the risk-free rate and market return are 7% and 14%, respectively, is \%. (Round to two decimal places.) Capital asset pricing model (CAPM) For the asset shown in the following table, use the capital asset pricing model to find the required return. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Risk-free rate, RF 9% Market return, I'm 15% Beta, e Beta, b 1.2 The required return for the asset is %. (Round to two decimal places.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
