Using payback, ARR, NPV, and IRR to make capital investment decisions This problem continues the Piedmont Computer Company situation from Chapter 25. 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%. Requirements 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. Assuming capital rationing applies, which server should Piedmont Computer Company invest in?

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter19: Capital Investment
Section: Chapter Questions
Problem 4CE: Manzer Enterprises is considering two independent investments: A new automated materials handling...
icon
Related questions
Question

Using payback, ARR, NPV, and IRR to make capital investment decisions

This problem continues the Piedmont Computer Company situation from Chapter 25. 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%.

Requirements

  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 Piedmont Computer Company invest in?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 8 steps with 7 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College