1. Straight-line: A new project will require an equipment worth $100,000. The installation expenses are $10,000. The project will run for five years. The depreciation is straight-line basis. The equipment will be depreciated to a zero book value at the end of the project. The project will require an initial investment in net working capital is $5,000 which will be recouped at the end of the project. The annual operating cash flow is $50,000. The equipment is expected to have a salvage value of $4,000 at the end of the project. Assume a tax rate of 25% and a cost of capital is 10%. What are the NPV and IRR of the project? Should the equipment be purchased? 2. MACRS: The equipment cost is $50,000 and it would cost another $10,000 to modify it. Assume that the equipment falls into the MACRS 3-year class. The equipment will be sold after 3 years for $20,000. It would require an increase in net working capital of $2,000 at the start of the project. This working capital would be recovered at the end of the project. The new project will not have an effect on revenues but it is expected to save the firm $20,000 per year in before-tax operating costs, mainly labor. Assume a tax rate of 40% and a cost of capital is 10%. What are the NPV and IRR of the project? Should the equipment be purchased? The MACRS allowance percentages for the 3-year asset class are as follows, commencing with year one: 33.33%, 44.45%, 14.81%, 7.41%. Also upload your excel files showing your work