Question: please show how to input with excel formula Project Evaluation Your firm is contemplating the purchase of a new $440,000 computer-based order entry system. The
Project Evaluation Your firm is contemplating the purchase of a new $440,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 6-year life. It will be worth $57,000 at the end of that time. You will save $161,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $44,000 at the beginning of the project. Working capital will revert back to normal at the end of the project. The tax rate is 24 percent. What is the aftertax salvage value of the equipment? What is the annual operating cash fow? What is the IRR for this project? Input area: 5 440,000 Initial investment Depreciation straight-line over life Pretax salvage value Cost savings per year Working capital reduction Tax rate $ $ $ 6 57,000 161.000 (44,000) 24% Output area: + 5 73333 Annual depreciation charge Aftertax salvage value OCF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
