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 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
Get step-by-step solutions from verified subject matter experts
