Question
Loper Fields is evaluating a new order processing system. The cost of the system is $385,000 which will be depreciated on a straight line basis
Loper Fields is evaluating a new order processing system. The cost of the system is $385,000 which will be depreciated on a straight line basis to zero. This project will run for 5 years. At the end of the project the new order processing system may be sold for $60,000. This order processing system will allow Loper Fields to save two salaried positions/benefits in the amount of $135,000 (pre-tax) each year. This system will require an investment in NWC of $35,000 at the beginning of the project. The firms tax rate is 21% and the cost of capital is 10%.
How would I put this into excel to get the answer? Could you actually do it in excel and post a picture of the spreadsheet. Thanks!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started