Create excel budget tool including net present value (NPV), internal rate of return (IRR), payback period, and profitability index (PI).

• A new major equipment purchase, which will cost $10 million; however, it is projected to reduce cost of sales by 5% per yearfor 8 years.
• The equipment is projected to be sold for salvage value estimated to be $500,000 at the end of year 8.
• Being a relatively safe investment, the required rate of return of the project is 8%.
• The equipment will be depreciated at a MACRS 7-year schedule.
• Annual sales for year 1 are projected at $20 million and should stay the same per year for 8 years.
• Before this project, cost of sales has been 60%.
• The marginal corporate tax rate is presumed to be 25%.