Problem:
Your company is evaluating new equipment that will cost $1,000,000. The equipment is in the MACRS 3-year class and will be sold after 3 years for $100,000. Use of the equipment will increase net working capital by 100,000. The equipment will save $450,000 per year in operating costs. The company's tax rate is 30 percent and its cost of capital is 10%.
1. Calculate the cash flow in Year 0.
2. Calculate the incremental operational cash flows - use the following (MACRS Depreciation Percentages for three-year class life assets)
3. Calculate the terminal year cash flow
4. Calculate the project's payback period.
5. Calculate the project's NPV.
6. Calculate the project's IRR.
7. Calculate the project's MIRR.
8. Investment Decision: Should the project be accepted or rejected? Why or why not?
Please use excel if possible.