copy its contents into a spreadsheet.)
able[[,Project X,Project Y,Project Z],[Initial Investment (CF_(0)),$78,000,$52,000,$66,000
Unequal livesANPV approachPortland Products is considering the purchase of one of three mutually exclusive projects for increasing production efficiency. The firm plans to use a 12.6% cost of capital to evaluate copy its contents into a spreadsheet.) Project X Project Y Project Z Initial investment (CFo $78,000 $52,000 $66,000 Year(t) Cash inflows (CF $17,100 $27,900 $15,100 2 24,700 37,700 15,100 3 32,800 15,100 4 40,900 15,100 5 15,100 6 15,100 7 15,100 8 15,100
a. Calculate the NPV for each project over its life. Rank the projects in descending order on the basis of NPV b. Use the annualized net present value (ANPV) approach to evaluate and rank the projects in descending order on the basis of ANPV. c. Compare and contrast your findings in parts (a) and (b). Which project would you recommend that the firm acquire?