/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q24E Using NPV to make capital invest... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Using NPV to make capital investment decisions Holmes Industries is deciding whether to automate one phase of its production process. The manufacturing equipment has a six-year life and will cost \(910,000.

Year 1 \) 262,000

Year 2 254,000

Year 3 222,000

Year 4 215,000

Year 5 200,000

Year 6 175,000

Requirements

  1. Compute this project’s NPV using Holmes’s 14% hurdle rate. Should Holmes invest in the equipment?

Holmes could refurbish the equipment at the end of six years for \(104,000. The refurbished equipment could be used one more year, providing \)77,000 of net cash inflows in year 7. Additionally, the refurbished equipment would have a $55,000 residual value at the end of year 7. Should Holmes invest in the equipment and refurbish it after six years? (Hint: In addition to your answer to Requirement 1, discount the additional cash outflow and inflows back to the present value.)

Short Answer

Expert verified
  1. NPV = $(24,170)
  2. NPV = $(18,794)

Step by step solution

01

Meaning of Net Present Value (NPV)

The approach to deciding project reasonability is called net present value (NPV). This approach decides the display value of cash inflows and outflows sometime recently, calculating the investment's net present value. On the off chance that a project's NPV is positive, it ought to be affirmed.

02

Computing NPV for the project

Years

Cash Flows

PVF (14%)

PV

CF

PVF

CF PVF

Year 0

$(910,000)

1.000

$(910,000)

Year 1

$262,000

0.877

$229,774

Year 2

$254,000

0.769

$195,326

Year 3

$222,000

0.675

$149,850

Year 4

$215,000

0.592

$127,280

Year 5

$200,000

0.519

$103,800

Year 6

$175,000

0.456

$79,800

NPV

$(24,170)

Note: The project's net present value (NPV) is negative, hence no investment should be made in it.

03

Calculation of NPV

Years

Cash Flow

Refurbishment Cash Flow

Total Cash

Flows

PVF (14%)

PV

CF

RCF

TCF=CF+RCF

PVF

TCF PVF

Year 0

$(910,000)

$(910,000)

1.000

$(910,000)

Year 1

$262,000

$262,000

0.877

$229,774

Year 2

$254,000

$254,000

0.769

$195,326

Year 3

$222,000

$222,000

0.675

$149,850

Year 4

$215,000

$215,000

0.592

$127,280

Year 5

$200,000

$200,000

0.519

$103,800

Year 6

$175,000

$(104,000)

$71,000

0.456

$32,376

Year 7

$77,000

$55,000

$132,000

0.400

$52,800

NPV

$(18,794)

Even with the renovation option, the project's NPV is negative; hence, no investment should be made in the project.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Refer to Short Exercise S26-4. Assume the expansion has no residual value. What is the project’s NPV (round to nearest dollar)? Is the investment attractive? Why or why not?

Using payback, ARR, and NPV with unequal cash flows

Hughes Manufacturing, Inc. has a manufacturing machine that needs attention. The company is considering two options. Option 1 is to refurbish the current machine at a cost of \(2,600,000. If refurbished, Hughes expects the machine to last another eight years and then have no residual value. Option 2 is to replace the machine at a cost of \)3,800,000. A new machine would last 10 years and have no residual value. Hughes expects the following net cash inflows from the two options:

Year

Refurbish current machine

Purchase new machine

1

\(1,760,000

\)2,970,000

2

440,000

490,000

3

360,000

410,000

4

280,000

330,000

5

200,000

250,000

6

200,000

250,000

7

200,000

250,000

8

200,000

250,000

9

250,000

10

250,000

Total

\(3,640,000

\)5,700,000

Hughes uses straight-line depreciation and requires an annual return of 10%.

Requirements

1. Compute the payback, the ARR, the NPV, and the profitability index of these two options.

2. Which option should Hughes choose? Why?

Cornell Company is considering a project with an initial investment of \(596,500 that is expected to produce cash inflows of \)125,000 for nine years. Cornell’s required rate of return is 12%.

14. What is the NPV of the project?

15. What is the IRR of the project?

16. Is this an acceptable project for Cornell?

P26-40 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?

Why are net present value and internal rate of return considered discounted cash flow methods?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.