USE MICROSOFT EXCEL PLEASE

LG 2 P12-20 RISK-ADJUSTED DISCOUNT RATES: BASIC Country Wallpapers is considering investing in one of three mutually exclusive projects, E, F, and G. The firm's cost of capital, r, is 10%, and the risk-free rate, RF, is 2%. The firm has estimated each project's cash flow and each project's beta, as shown in the following table. a. Find the NPV of each project, using the firm's cost of capital. Which project is preferred in this situation? b. The firm uses the following equation to determine the risk-adjusted discount rate, RADRj, for each project j : RADRj=RF+j(rmRF) Where RF= risk-free rate =2% Bj= beta of project j RADRj= risk-adjusted discount rate for project j rm= expected return on market portfolio =10% Substitute each project's beta into this equation to determine its RADR. c. Use the RADR for each project to determine its risk-adjusted NPV. Which project is preferable in this situation? d. Compare and discuss your findings in parts a and c. Which project do you recommend that the firm accept