Piedmont Computer Company is considering purchasing two different types of servers. Server A will generate net cash inflows of $25,000 per year and have a zero residual value. Server A's estimated useful life is three years, and it costs $45,000. Server B will generate net cash inflows of $25,000 in year 1, $15,000 in year 2, and $5,000 in year 3. Server B has a $5,000 residual value and an estimated useful life of three years. Server B also costs $45,000. Piedmont Computer Company's required rate of return is 14%. Read the requirements. Requirement 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. Begin with the payback period for Server A. (Round your answer to one decimal place, X.X.) ID = Payback years Server A Now determine the payback period for Server B. (Round your answer to one decimal place, X.X.) The payback period for Server Bis years. Calculate the accounting rate of return (ARR) for both server investments. (Round all intermediary calculations to the nearest whole dollar. Round your answers to the nearest hundredth percent, X.XX%.) = ARR % Server A Server B Calculate the net present value (NPV) for both server investments. Use Microsoft Excel 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 Piedmont Computer Company is considering purchasing two different types of servers. Server A will generate net cash inflows of $25,000 per year and have a zero residual value. Server A's estimated useful life is three years, and it costs $45,000. Server B will generate net cash inflows of $25,000 in year 1, $15,000 in year 2, and $5,000 in year 3. Server B has a $5,000 residual value and an estimated useful life of three years. Server B also costs $45,000. Piedmont Computer Company's required rate of return is 14%. Read the requirements. Calculate the internal rate of return (IRR) for both server investments. Use Microsoft Excel to calculate IRR. (Round the IRR calculations to two decimal places, X.XX%.) IRR L Server A Server B % % Requirement 2. Assuming capital rationing applies, which server should Piedmont Computer Company invest in? Based on the calculated results in Requirement 1, Server A The payback period is than the server's operating life, NPV is , and the ARR and IRR are both than the required rate of return. Based on the foregoing quantitative factors, Server A is The payback period is the server's operating life, NPV is , and the ARR and IRR are both than the required Based on the calculated results in Requirement 1, Server B rate of return. Based on the foregoing quantitative factors, Server B is Assuming capital rationing applies, which server should Piedmont Computer Company invest in? O A. Based on the foregoing quantitative factors, Server B should be rejected. If qualitative factors do not change the decision, then Piedmont should invest in Server A. O B. Based on the foregoing quantitative factors alone, both Server A and Server B should be rejected. Qualitative factors do not need to be considered. O C. Based on the foregoing quantitative factors, Server A should be rejected. If qualitative factors do not change the decision, then Piedmont should invest in Server B. OD. Based on the foregoing quantitative factors alone, both Server A and Server B should be accepted. Qualitative factors do not need to be considered. Piedmont Computer Company is considering purchasing two different types of servers. Server A will generate net cash inflows of $25,000 per year and have a zero residual value. Server A's estimated useful life is three years, and it costs $45,000. Server B will generate net cash inflows of $25,000 in year 1, $15,000 in year 2, and $5,000 in year 3. Server B has a $5,000 residual value and an estimated useful life of three years. Server B also costs $45,000. Piedmont Computer Company's required rate of return is 14%. Read the requirements. Calculate the internal rate of return (IRR) for both server investments. Use Microsoft Excel to calculate IRR. (Round the IRR calculations to two decimal places, X.XX%.) IRR Server A % Server B Requirement 2. Assuming capital rationing applies, which server should Piedmont Computer Company invest in? Based on the calculated results in Requirement 1, Server A The payback period is than the server's operating life, NPV is and the ARR and IRR are both than the required rate of return. Based on the foregoing quantitative factors, S does not meet the company's investment criteria. Based on the calculated results in Requirement 1, Server B yback period is the server's operating life, NPV is , and the ARR and IRR are both than the required meets or exceeds the company's investment criteria. rate of return. Based on the foregoing quantitative factors, S Assuming capital rationing applies, which server should Piedmont Computer Company invest in? O A. Based on the foregoing quantitative factors, Server B should be rejected. If qualitative factors do not change the decision, then Piedmont should invest in Server A. O B. Based on the foregoing quantitative factors alone, both Server A and Server B should be rejected. Qualitative factors do not need to be considered. O C. Based on the foregoing quantitative factors, Server A should be rejected. If qualitative factors do not change the decision, then Piedmont should invest in Server B. OD. Based on the foregoing quantitative factors alone, both Server A and Server B should be accepted. Qualitative factors do not need to be considered. Piedmont Computer Company is considering purchasing two different types of servers. Server A will generate net cash inflows of $25,000 per year and have a zero residual value. Server A's estimated useful life is three years, and it costs $45,000. Server B will generate net cash inflows of $25,000 in year 1, $15,000 in year 2, and $5,000 in year 3. Server B has a $5,000 residual value and an estimated useful life of three years. Server B also costs $45,000. Piedmont Computer Company's required rate of return is 14%. Read the requirements. Requirement 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. Begin with the payback period for Server A. (Round your answer to one decimal place, X.X.) ID = Payback years Server A Now determine the payback period for Server B. (Round your answer to one decimal place, X.X.) The payback period for Server Bis years. Calculate the accounting rate of return (ARR) for both server investments. (Round all intermediary calculations to the nearest whole dollar. Round your answers to the nearest hundredth percent, X.XX%.) = ARR % Server A Server B Calculate the net present value (NPV) for both server investments. Use Microsoft Excel 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 Piedmont Computer Company is considering purchasing two different types of servers. Server A will generate net cash inflows of $25,000 per year and have a zero residual value. Server A's estimated useful life is three years, and it costs $45,000. Server B will generate net cash inflows of $25,000 in year 1, $15,000 in year 2, and $5,000 in year 3. Server B has a $5,000 residual value and an estimated useful life of three years. Server B also costs $45,000. Piedmont Computer Company's required rate of return is 14%. Read the requirements. Calculate the internal rate of return (IRR) for both server investments. Use Microsoft Excel to calculate IRR. (Round the IRR calculations to two decimal places, X.XX%.) IRR L Server A Server B % % Requirement 2. Assuming capital rationing applies, which server should Piedmont Computer Company invest in? Based on the calculated results in Requirement 1, Server A The payback period is than the server's operating life, NPV is , and the ARR and IRR are both than the required rate of return. Based on the foregoing quantitative factors, Server A is The payback period is the server's operating life, NPV is , and the ARR and IRR are both than the required Based on the calculated results in Requirement 1, Server B rate of return. Based on the foregoing quantitative factors, Server B is Assuming capital rationing applies, which server should Piedmont Computer Company invest in? O A. Based on the foregoing quantitative factors, Server B should be rejected. If qualitative factors do not change the decision, then Piedmont should invest in Server A. O B. Based on the foregoing quantitative factors alone, both Server A and Server B should be rejected. Qualitative factors do not need to be considered. O C. Based on the foregoing quantitative factors, Server A should be rejected. If qualitative factors do not change the decision, then Piedmont should invest in Server B. OD. Based on the foregoing quantitative factors alone, both Server A and Server B should be accepted. Qualitative factors do not need to be considered. Piedmont Computer Company is considering purchasing two different types of servers. Server A will generate net cash inflows of $25,000 per year and have a zero residual value. Server A's estimated useful life is three years, and it costs $45,000. Server B will generate net cash inflows of $25,000 in year 1, $15,000 in year 2, and $5,000 in year 3. Server B has a $5,000 residual value and an estimated useful life of three years. Server B also costs $45,000. Piedmont Computer Company's required rate of return is 14%. Read the requirements. Calculate the internal rate of return (IRR) for both server investments. Use Microsoft Excel to calculate IRR. (Round the IRR calculations to two decimal places, X.XX%.) IRR Server A % Server B Requirement 2. Assuming capital rationing applies, which server should Piedmont Computer Company invest in? Based on the calculated results in Requirement 1, Server A The payback period is than the server's operating life, NPV is and the ARR and IRR are both than the required rate of return. Based on the foregoing quantitative factors, S does not meet the company's investment criteria. Based on the calculated results in Requirement 1, Server B yback period is the server's operating life, NPV is , and the ARR and IRR are both than the required meets or exceeds the company's investment criteria. rate of return. Based on the foregoing quantitative factors, S Assuming capital rationing applies, which server should Piedmont Computer Company invest in? O A. Based on the foregoing quantitative factors, Server B should be rejected. If qualitative factors do not change the decision, then Piedmont should invest in Server A. O B. Based on the foregoing quantitative factors alone, both Server A and Server B should be rejected. Qualitative factors do not need to be considered. O C. Based on the foregoing quantitative factors, Server A should be rejected. If qualitative factors do not change the decision, then Piedmont should invest in Server B. OD. Based on the foregoing quantitative factors alone, both Server A and Server B should be accepted. Qualitative factors do not need to be considered