I only need help figuring out the NPV and IRR.

Pithe Computer Company is considering purchasing two different types of servers. Server A will generate nel cash inflows of $27.000 per year and have a zero residual value. Server A's estimated useful life is three years, and it costs $43,000 Server B will generate net cash inflows of $29,000 in year 1, $10,000 in year 2, and $4,000 in year 3. Server B has a $5,000 residual value and an estimated useful life of three years. Server B also costs S43,000. Pithe Computer Company's required rale of return is 15%. Read the requirements turn for both servor Investments. Use Microsoft Excol calculate NPV and IRR. Requirements back years 1. Calculate payback, accounting rate of return, net present value, and internal rate of return for both server investments. Use Microsoft Excel to calculate NPV and IRR. 2. Assuming capital rationing applies, which server should Pithe Computer Company invest in? ulations to the nearest whole dollar. Round your answers to the nearest hundredth percent, X.XX%) R Print Print Done % % Calculate the net present Value INPVJTOT Poth server investments. USC MICROSOTT EXCO to calculate NPV. (Round the NPV calculations to the nearest whole dollar. Use parentheses or a minus sign for a negative net present value.) NPV Server A Server B