50.1K

Verified Solution

Link Copied!

help please fast.

Porcelain Computer Company is considering purchasing two different types of servers. Server A will generate net cash inflows of $26,000 per year and have a zero residual value. Server A's estimated useful life is three years, and it costs $46,000. Server B will generate net cash inflows of $30,000 in year 1,$12,000 in year 2, and $4,000 in year 3. Server B has a $5,000 residua value and an estimated useful life of three years. Server B also costs $46,000. Porcelain Computer Company's required rate of retur 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, XX.) Now determine the payback period for Server B. (Round your answer to one decimal place, XX.) The payback period for Server B is 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\%.) 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.) Calculate the internal rate of retum (IRR) for both server investments. Use Microsoft Excel to calculate IRR. (Round the IRR calculations to two decimal places, XX%.) Requirement 2. Assuming capital rationing applies, which server should Porcelain Computer Company invest in? Porcelain Computer Company is considering purchasing two different types of servers. Server A will generate net cash inflows of $26,000 per year and have a zero residual value. Server A's estimated useful life is three years, and it costs $46,000. Server B will generate net cash inflows of $30,000 in year 1,$12,000 in year 2, and $4,000 in year 3. Server B has a $5,000 residua value and an estimated useful life of three years. Server B also costs $46,000. Porcelain Computer Company's required rate of retur 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, XX.) Now determine the payback period for Server B. (Round your answer to one decimal place, XX.) The payback period for Server B is 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\%.) 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.) Calculate the internal rate of retum (IRR) for both server investments. Use Microsoft Excel to calculate IRR. (Round the IRR calculations to two decimal places, XX%.) Requirement 2. Assuming capital rationing applies, which server should Porcelain Computer Company invest in

Answer & Explanation Solved by verified expert

See Answer