Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 -Spending Money to Save Money? For help on this one, refer back to the computerized inventory management system in Example 10.3 below . Here,

1 -Spending Money to Save Money? For help on this one, refer back to the computerized inventory management system in Example 10.3 below. Here, were contemplating a new automatic surveillance system to replace our current contract security system. It will cost $450,000 to get the new system. The cost will be depreciated straight-line to zero over the systems four-year expected life. The system is expected to be worth $250,000 at the end of four years after removal costs. We think the new system will save us $125,000 per year, before taxes, in contract security costs. The tax rate is 21 percent. What are the NPV and IRR for buying the new system? The required return is 17 percent.

image text in transcribed

EXAMPLE 10.3 TO BUY OR NOT TO BUY We are considering the purchase of a $200,000 computer-based inventory management system. It will be depreciated straight-line to zero over its four-year life. It will be worth $30,000 at the end of that time. The system will save us $60,000 before taxes in inventory-related costs. The relevant tax rate is 21 percent. Because the new setup is more efficient than our existing one, we will be able to carry less total inventory and thus free up $45,000 in net working capital. What is the NPV at 16 percent? What is the DCF return (the IRR) on this investment? We can first calculate the operating cash flow. The aftertax cost savings are $60,000 * (1 - 21) = $47,400. The depreciation is $200,000/4 = $50,000 per year, so the depreciation tax shield is $50,000 x 21 = $10,500. Operating cash flow is $47,400 + 10,500 = $57,900 per year. The capital spending involves $200,000 up front to buy the system. The aftertax salvage is $30,000 X (1 - 21) = $23,700. Finally, and this is the somewhat tricky part, the initial investment in net working capital is a $45,000 inflow because the system frees up working capital. Furthermore, we will have to put this back in at the end of the project's life. What this really means is simple: While the system is in operation, we have $45,000 to use elsewhere. To finish our analysis, we can compute the total cash flows: Year 1 2 3 4 $57.900 $57.900 $57.900 $57.900 $ 45,000 - 45.000 Operating cash flow Change in NWC Capital spending Total cash flow 200.000 23,700 SI55.000 $57.900 $57.60 $57.900 $36,600 At 16 percent, the NPV is -$4,749, so the investment is not attractive. After some trial and error, we find that the NPV is zero when the discount rate is 14.36 percent, so the IRR on this investment is about 14.4 percent

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Venture Capital And The Finance Of Innovation

Authors: Andrew Metrick, Ayako Yasuda

3rd Edition

1119490111, 978-1119490111

More Books

Students also viewed these Finance questions

Question

Discuss the objectives of discipline and appeals systems

Answered: 1 week ago