Question: show work in excel please 1. The current risk-free rate of interest is 3% and the expected return on the market is 10%. a. Using
1. The current risk-free rate of interest is 3% and the expected return on the market is 10%. a. Using EXCEL's Data Table feature create a two-way data table to determine the cost of equity by varying both Beta and the risk-free rate of interest. Use Beta values of 0.70 , 0.85,1.00,1.15,1.30, and 1.45 , and risk-free interest rate values of 4%,5%,6%,7%, and 8%. b. Explain how the cost of equity is impacted by: i. A change in Beta ii. A change in the risk-free interest rate
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
