Question: Can someone please help me do this excel format? Thanks! Your firm is contemplating the purchase of a new $ 5 3 5 , 0

Can someone please help me do this excel format? Thanks!
Your firm is contemplating the purchase of a new $535,000 computer-based order entry system. The system will be
2
depreciated straight-line to zero over its five-year life. It will be worth $30,000 at the end of that time. You will save $165,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $60,000(this is a one-time reduction). If the tax rate is 24 percent, what is the IRR for this project?
3
Input area:
\table[[Initial investment,$535,000
 Can someone please help me do this excel format? Thanks! Your

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!