ompute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, hdicate whether each project is acceptable. (Round your answers to 2 decimal places.) Acceptable? IRR Project X1 Project X2

A company is evaluating three possible investments. The following information is provided by the​ company:     Project A Project B Project C Investment $238,000 $54,000 $238,000 Residual value 0 30,000 40,000 Net cash​ inflows:       Year 1 70,000 30,000 100,000 Year 2 70,000 21,000 70,000 Year 3 70,000 17,000 80,000 Year 4 70,000 14,000 40,000 Year 5 70,000 0 0   What is the payback period for Project​ A? (Assume that the company uses the straight−line depreciation​ method.) (Round your answer to two decimal​ places.)         A. 1.8 years   B. 2.4 years   C. 5.00 years   D. 3.4 years

First United Bank Inc. is evaluating three capital investment projects using the net present value method. Relevant data related to the projects are summarized as follows:   BranchOfficeExpansion ComputerSystemUpgrade ATMKioskExpansion Amount to be invested $686,053   $516,654   $295,458   Annual net cash flows:               Year 1 411,000   288,000   177,000     Year 2 382,000   259,000   122,000     Year 3 349,000   230,000   89,000     Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 7 0.665 0.513 0.452 0.376 0.279 8 0.627 0.467 0.404 0.327 0.233 9 0.592 0.424 0.361 0.284 0.194 10 0.558 0.386 0.322 0.247 0.162 Required: 1.  Assuming that the desired rate of return is 20%, prepare a net present value analysis for each project. Use the…

Pls give me a correct answer