will use its cost of capital as discount rate for decisions on allocation of capital through various projects. This assignment is to make capital budgeting decisions based on a number of investment decisions tools. Due date: November 15, 2023 Instructions: 1. Use the scenario below to answer the questions. 2. You can use MS Excel for all calculations or the BA II Plus. 3. Submit your report in MS Excel format. Attach any supporting Excel documents to the D2L assignment tool. Submit your report in MS Word format if you are using the BA II Plus calculator and show your calculations, and table for your cash flows for Question #3. Marks Allocated Marks Obtained Question 1 7.5 2 12.5 Total 20 Question #1 (7.5 marks) ABC Corporation wants to buy a new warehouse inventory system. They expect the savings (cash flows) generated in the next five years to be generated as per Table 1. The value of the inventory system is $70,000 and ABC Corp. cost of capital is 11%. Calculate the Payback, Net Present Value (NPV) and Internal Rate of Return (IRR) of this investment. Based on the three capital budgeting tools, should ABC corporate invest in the warehouse inventory system? Year Cash flows 0 1 10,000 2 35,000 3 30,000 4 20,000 5 5,000 Total 100,000