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

please show how to input with excel formula
please show how to input with excel formula Project Evaluation Your firm

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

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!