We are considering the purchase of a $150,000 computer-based inventory management system. It will be...
60.1K
Verified Solution
Question
Accounting
- We are considering the purchase of a $150,000 computer-based inventory management system. It will be depreciated straight-line to zero over its four-year life. It will be worth $40,000 at the end of that time. The system will save us $50,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 $42,000 in net working capital. What is the NPV at 15 percent? What is the DCF return (the IRR) on this investment?
Sales |
|
Depreciation |
|
Cost (Fixed, Variable) |
|
EBIT |
|
Taxes (21%) |
|
Net Income |
|
EBIT |
|
+Depreciation |
|
-Taxes (21%) |
|
Operating Cash Flow |
|
Year | |||||
| 0 | 1 | 2 | 3 | 4 |
Operating Cash Flow |
|
|
|
|
|
Change in NWC |
|
|
|
|
|
Capital Spending |
|
|
|
|
|
Total Cash Flow |
|
|
|
|
|
- We are considering the purchase of a $150,000 computer-based inventory management system. It will be depreciated straight-line to zero over its four-year life. It will be worth $40,000 at the end of that time. The system will save us $50,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 $42,000 in net working capital. What is the NPV at 15 percent? What is the DCF return (the IRR) on this investment?
Sales |
|
Depreciation |
|
Cost (Fixed, Variable) |
|
EBIT |
|
Taxes (21%) |
|
Net Income |
|
EBIT |
|
+Depreciation |
|
-Taxes (21%) |
|
Operating Cash Flow |
|
Year | |||||
| 0 | 1 | 2 | 3 | 4 |
Operating Cash Flow |
|
|
|
|
|
Change in NWC |
|
|
|
|
|
Capital Spending |
|
|
|
|
|
Total Cash Flow |
|
|
|
|
|
- We are considering the purchase of a $150,000 computer-based inventory management system. It will be depreciated straight-line to zero over its four-year life. It will be worth $40,000 at the end of that time. The system will save us $50,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 $42,000 in net working capital. What is the NPV at 15 percent? What is the DCF return (the IRR) on this investment?
Sales |
|
Depreciation |
|
Cost (Fixed, Variable) |
|
EBIT |
|
Taxes (21%) |
|
Net Income |
|
EBIT |
|
+Depreciation |
|
-Taxes (21%) |
|
Operating Cash Flow |
|
Year | |||||
| 0 | 1 | 2 | 3 | 4 |
Operating Cash Flow |
|
|
|
|
|
Change in NWC |
|
|
|
|
|
Capital Spending |
|
|
|
|
|
Total Cash Flow |
|
|
|
|
|
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.