A manufacturing company is considering the following projects to improve their production process. The projects have a 3 year life. Refer to the Table of Projects, Costs and Benefits Evaluate the projects by first determining the rate of return for each project. Table of Project Costs and Benefits i. On Excel create a spreadsheet to calculate the rate of return. Label the columns Projects, i, n PMT,PV,FV, then IRR. As shown in the sample table below, Table 1. Follow the format in Table 1 to create your Excel spreadsheet to calculate the rate of return for each project. Use Excel command: =RATE (C1,D1,E1,F1) (5 marks) ii Create a second table in Excel on the same spreadsheet. Rearrange the Projects in order of highest rate of return to lowest. The headings of this second table: Project, Cost, Annual benefit, Rate of Return, Cumulative first cost. (3 marks) 1. Which projects should be done if the budget is $70,000 ? (2 marks) 2. What is the opportunity cost of capital? (2 marks) Please submit your Excel spreadsheet showing the two tables generated to obtain full marks for this