**Please show formulas used for the first part on paper and the second part in Excel. Thanks**

2. A precision grinder installation project has the cash flows in the table below. An engineer wants to find the ROR for the project. Use the tests that indicate the number of ROR values (cash flow rule of signs and cumulative cash flow test) to show that no unique i* 2 0 exists for the project. Show the cash flows for PW. and FW, in conversion factor standard notation and calculate their values. Calculate the MIRR for the project by hand with the appropriate equation to four significant digits. The reinvestment rate is 8% and the borrowing rate is 10%. Then use the Excel spreadsheet function MIRR to find the exact MIRR to four significant digits to check your calculations. Include a screen shot of your spreadsheet with data. Data Year Cash Flow $ 0 -1,000 1 1,200 2 -3,000 3 3,500 2. A precision grinder installation project has the cash flows in the table below. An engineer wants to find the ROR for the project. Use the tests that indicate the number of ROR values (cash flow rule of signs and cumulative cash flow test) to show that no unique i* 2 0 exists for the project. Show the cash flows for PW. and FW, in conversion factor standard notation and calculate their values. Calculate the MIRR for the project by hand with the appropriate equation to four significant digits. The reinvestment rate is 8% and the borrowing rate is 10%. Then use the Excel spreadsheet function MIRR to find the exact MIRR to four significant digits to check your calculations. Include a screen shot of your spreadsheet with data. Data Year Cash Flow $ 0 -1,000 1 1,200 2 -3,000 3 3,500