Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access with AI-Powered 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