Question: please show excel formulas used as well. thank you Problem 4 (15 points) Main Street Hardware is contemplating the purchase of a new $75,000 computer-based

please show excel formulas used as well. thank you
please show excel formulas used as well. thank you Problem 4 (15
points) Main Street Hardware is contemplating the purchase of a new $75,000

Problem 4 (15 points) Main Street Hardware is contemplating the purchase of a new $75,000 computer-based order-entry system. The system will be depreciated straight-line to zero over its four-year life. After that it is expected to be obsolete and therefore worthless. The company expects to save $27,000 per year in order processing costs. Assume no change in net working capital (NWC) as a result of the project. If the tax is 21%, what is the IRR for this project? If the company's hurdle rate is 14%, should the project be accepted? Initial investment: Annual cost savings Depreciation method: Depreciation life Salvage value: Tax rate: Discount (hurdle) rate: 0 1 2 3 4 Added profit from cost savings Depreciation EBIT Taxes Net income EBIT Plus: depreciation Minus: taxes Operating cash flow 1 Operating cash flow 2 Capital spending 3 Net cash flow 5 IRR Accept? (Yes/No) 3

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!