Question: The Data Tank, Inc. has asked you to evaluate the proposed acquisition of a new computer. The computer's price is $ 4 0 , 0

The Data Tank, Inc. has asked you to evaluate the proposed acquisition of a new computer. The computer's price is $40,000, and it falls into the MACRS 3-year class. Purchase of the computer would require an increase in net operating working capital of $2,000. The computer would increase the firm's before-tax revenues by $20,000 per year but would also increase operating costs by $5,000 per year. The computer is expected to be used for 3 years and then be sold for $25,000. The firm's marginal tax rate is 40 percent, and the project's cost of capital is 14 percent.
The MACRS table -33.33%,44.45%,14.81%, and 7.41% for Years 1 through 4.
What is the project's IRR?
Group of answer choices
17.61%
14.03%
15.72%
19.22%
12.35%
Please show how to solve this and excel and make sure one of those multiple choice options is the answer.

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!