Please answer question 3 &4 using Excel. 1&2 have already been answered.

(25) Points The Big CompanyTM is considering two pieces of machinery that perform the same repetitive task. The tw alternatives available provide the following set of after-tax net cash flows. Assuming a required rate of return of 10%: Year Project A Project B O Calculate the NPV for each project A=(749.81) B=12,499.96 0 (48,000) (80,000) Calculate the IRR for each project. A= 9.11% B=14.60% 1 * Calculate the uniform annual series (UAS) or the equivalent annual annuity 19000 19000 (EAA) for each project. 2 19000 19000 Compare the two projects using the replacement chain method (i.e. find the 3 19000 19000 replacement chain value). Which project would you select? 19000 Calculate the discounted payback. (ii) Convert this to a rate of return. 5 19000 6 If the projects are mutually exclusive, and can be reproduced which project 19000 do you select? Explain. 7 19000 4 6