In: Finance
9. Suppose Blue Thumb Tools is considering the introduction of a new, heavier hammer to be used for driving spikes. The new hammer will cost $490,000. The cost will be depreciated straight-line to zero over the project’s five-year life, at the end of which the new hammer can be scrapped for $40,000. The new hammer will save the firm $146,000 per year in pretax operating costs, and it required an initial investment in net working capital of $35,000. The tax rate of the firm is 30%.
What are the cash flows of firm’s new project (using a time line)?
What is the net present value of this project (list your setups)?
What is the IRR of this project (list your setups)?
Please solve without excel so that I can see the steps.
Step 1 | ||||||
Calculation of the cash flows of firm’s new project | ||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Investment in a new hammer | -$490,000.00 | |||||
Investment in net working capital | -$35,000.00 | |||||
Savings in pre tax operating cost | $146,000.00 | $146,000.00 | $146,000.00 | $146,000.00 | $146,000.00 | |
Tax @ 30% on savings in pre tax operating cost | -$43,800.00 | -$43,800.00 | -$43,800.00 | -$43,800.00 | -$43,800.00 | |
Depreciation Tax shield | $29,400.00 | $29,400.00 | $29,400.00 | $29,400.00 | $29,400.00 | |
After tax scarp value of new hammer | $28,000.00 | |||||
Cash flows of firm's new project | -$525,000.00 | $131,600.00 | $131,600.00 | $131,600.00 | $131,600.00 | $159,600.00 |
Step 2 | ||||||
Calculation of the net present value of this project | ||||||
We are unable to calculate the NPV as the project's required rate of return is not given in the question. | ||||||
Step 3 | ||||||
Calculation of the IRR of this project | ||||||
Year | Cash flow | |||||
0 | - 525,000.00 | |||||
1 | 131,600.00 | |||||
2 | 131,600.00 | |||||
3 | 131,600.00 | |||||
4 | 131,600.00 | |||||
5 | 159,600.00 | |||||
At Internal rate of return (IRR) , the net present value of project is equal to zero. | ||||||
We can use the excel formula to calculate the IRR of the project. | ||||||
IRR of the project | =IRR(B15:B20) | |||||
IRR of the project | 9.36% | |||||
Working | ||||||
Calculation of depreciation tax shield | ||||||
Depreciation per year on New machine = $490000 / 5 years = | $98,000.00 | |||||
x Tax rate | 30% | |||||
Depreciation Tax shield per year | $29,400.00 | |||||
Calculation of after tax scarp value of new hammer | ||||||
Scrap value | $40,000.00 | |||||
Less : Tax @ 30% | $12,000.00 | |||||
After tax scarp value of new hammer | $28,000.00 |