Question

I need to find the risk-adjusted present value for Project E, F, and G. Please show the work in Excel.

Risk adjusted discount rates -Basic Country Wallpapers s considering investing in one of three mutually exclusive projects, E F and G The firm's cost of capita r is 14.9%, and the risk-free rate, RF S 9.9%. The firm a. Find the net present value (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, RADR, for each project j RADR R+RR) where Rf risk-free rate of returm, RI, - risk index for project j, and r cost of capital Substitute each project's risk index 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? a. Find the net present value (NPV) of each project using the firm's cost of capital. The net present value for project E is $3994.96. (Round to the nearest cent) The net present value for project Fis S 2034.03(Round to the nearest cent) The net present value for project G is S 1863.80 Round to the nearest cent.) Which project is preferred in this situation? (Select from the drop-down menu.) Project E with the highest NPV, is preferred b. The firm uses the following equation to determine the risk-adjusted discount rate, RADRfor each project j Data Table (Click on the icon located on the top-right comer of the data table below in order to copy its contents into a spreadsheet.) Project Initial investment (CFo) $14,600 $11,000 $18,200 RADR RR (-RF) where RE - risk-free rate of return, R,- risk index for project, andr cost of capital The RADR for project E is 18.75 % (Round to two decimal places) The RADR for projec The RADR for project G is 12.75 % (Round to two decimal places ) c. Use the RADR for each project to determine its risk-adjusted NPV The risk-adjusted net present value for project E is $1- (Round to the nearest cent) Year (t) Cash inflows (CF) $6,500 6,500 6,500 6,500 1.77 $6,400 4,400 4,700 1,800 0.98 $3,500 6,600 7.700 12,100 0.57 IF is 14.80 %. (Round to two decimal places.) Risk index (R Print Done

Answer 1

initial investment(Cfo)	-14600	-11000	-18200
1	6500	6400	3500
2	6500	4400	6600
3	6500	4700	7700
4	6500	1800	12100
Risk Index(Rfi)	1.77	0.98	0.57
NPV	$3,994.96	$2,034.03	$1,863.80
Radj=Rf+Rfi(R-Rf)	18.75%	14.80%	12.75%
NPV with Radj	$2,633.45	$2,056.40	$2,955.19

Formula to calculate value of NPV

NPV=(Rate=18.75%, year 1 value=6500, year 2 value=6500, year 3value=6500, year 4 value= 6500)-year 0 value i.e. 14600

NPV= 14600+6500/1.1875+ 6500/(1.1875)^2+ 6500/(1.1875)^3+ 6500 /(1.1875)^4

So project G with NPV=$2,955.19 is better