Question: Please do in excel. show all formulas used to get to each number/answer. Your firm is contemplating the purchase of a new $485,000 computer-based order

 Please do in excel. show all formulas used to get to

Please do in excel. show all formulas used to get to each number/answer.

Your firm is contemplating the purchase of a new $485,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $35,000 at the end of that time. You will save $140,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%, what is the IRR for this project? Should you accept if the RRR is 10%? 1 Your firm is contemplating the purchase of a new $485,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $35,000 at the end of that time. You will save $140,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%, what is the IRR for this project? Should you accept if the RRR is 10%? 1

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!