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
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
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,