Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions