PrimeTech Manufacturing automation equipment with sunk costs: IRR and NPV

Business FinanceCapital Budgeting

The question

MegaStuff Manufacturing, Inc. is thinking about buying some computer equipment to partially automate several of the firm's production lines. The equipment is recommended by a manufacturing consultant, who was hired by MegaStuff to study their production processes earlier this year. MegaStuff paid the consultant $25,000 for the analysis. An additional $50,000 has already been spent on employee training sessions, to ease the transition if the equipment is purchased. The computer equipment will cost $550,000. Delivery and setup costs will cost an additional $25,000. In addition, $15,000 in net working capital will be required at installation. The equipment will have a 5 year class life and will be depreciated using simplified straight line. MegaStuff has a tax rate of 21% and a cost of capital of 14%.

Currently, the firm's annual operating expenses total $640,000. The new equipment will decrease the firm's operating expenses to $400,000 per year.

S'pose MegaStuff decides to keep the equipment for 8 years and sell it for $40,000 at the end of year 8. What are the project's IRR and NPV?

Below is the Accuity problem: the same method with different numbers. We solve ours, so work through it and you'll know how to solve yours.

The Accuity problem

PrimeTech Manufacturing Inc. is considering $600,000 of equipment to automate its production lines. A consultant, paid $30,000, recommended the equipment, and PrimeTech has already spent $50,000 on training sessions before deciding whether to buy. If the company buys the equipment, it will spend $28,000 on shipping and need $18,000 of working capital. The equipment has a 5-year life and is depreciated straight-line. PrimeTech's tax rate is 21% and its cost of capital is 15%.

Annual operating expensesAmount
Current$680,000
Projected with the new equipment$420,000
  1. If PrimeTech keeps the equipment for 9 years and sells it for $45,000 at the end, what are the project's IRR and NPV?

An Accuity original. We write our own version of each problem and solve it from scratch, so you learn the method rather than copying an answer.

Video solution

Covers the full step-by-step solution below, start to finish.

Jake Glidden, CPA, MSA

Solved by

Jake Glidden, CPA, MSA

Founder of Accuity

Jake started Accuity while studying accounting at UCF and has worked with hundreds of students in introductory and upper-level accounting classes. Accuity solutions are checked against the textbook before they're published.

Certified Public Accountant (CPA) · B.S.B.A. in Accounting, UCF · M.S. in Accounting, UCF

More about Accuity →

Step-by-step solution

The same steps the video works through, written out.

This problem tests which costs belong in a capital budgeting analysis and what happens when an asset is kept longer than its depreciation life.

Sunk costs are ignored

The $30,000 consultant fee and the $50,000 of training have already been spent and cannot be recovered whether or not PrimeTech buys the equipment. They are sunk costs and are left out.

Initial outlay (year 0)

ItemAmount
Equipment$600,000
Shipping28,000
Depreciable base628,000
Working capital18,000
Initial outlay$646,000

Annual cash flows

Savings = 680,000 − 420,000 = $260,000 per year. Depreciation = 628,000 / 5 = $125,600 for years 1-5, then $0.

Years 1-5Years 6-9
Operating savings$260,000$260,000
Depreciation(125,600)0
Earnings before tax134,400260,000
Taxes (21%)(28,224)(54,600)
Net income106,176205,400
Add back depreciation125,6000
Operating cash flow$231,776$205,400

Cash flow falls by $26,376 after year 5 because the depreciation tax shield (21% × 125,600) ends.

Terminal cash flow (year 9)

The equipment is fully depreciated, so the entire $45,000 is a taxable gain.

ItemAmount
Sale price$45,000
Tax (21% × 45,000)(9,450)
Working capital recovered18,000
Terminal cash flow$53,550

Year 9 total = 205,400 + 53,550 = $258,950.

IRR and NPV (HP 10BII+)

  1. [shift] [C ALL], 1 [shift] [P/YR]
  2. 646000 [+/-] [CFj]
  3. 231776 [CFj], 5 [shift] [Nj]
  4. 205400 [CFj], 3 [shift] [Nj] (years 6-8)
  5. 258950 [CFj] (year 9)
  6. 15 [I/YR], [shift] [NPV] → 437,722.03
  7. [shift] [IRR/YR] → 32.58

Answer: IRR is about 32.58% and NPV at 15% is about $437,722, so the equipment is a good investment.

Mistakes to avoid

  • Adding the $30,000 consultant fee or the $50,000 training to the outlay.
  • Keeping the $125,600 depreciation in years 6-9, which overstates cash flow.
  • Entering 9 years of $231,776; only the first 5 years carry the tax shield.

More Capital Budgeting problems

Got a different wording of this problem?

Assignments vary by school and semester. Share the version you were given and we'll add it so other students can find this solution.

Studying Capital Budgeting for a class?

Accuity courses map to your actual syllabus — video lessons, exam-style practice, and walkthroughs for the problems you're assigned.

Ace your accounting classes.

Textbook questions are for reference. We show a textbook's question only so you can find the problem you were assigned. We don't solve textbook questions: every solution and video on this site works through our own Accuity problem, written to teach the same method with different numbers.

Educational use. Accuity problems are original teaching material — we write our own version of each problem and solve it on video so you learn the method. Don't submit our work as your own; that violates your school's academic integrity policy. If you believe content here infringes your rights, file a DMCA notice.