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* 0 exists for the project. Show the cash flows for PW₀ and FW_n 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.

PLEASE EXPLAIN ANY FORMULAS USED IN EXCEL, DONT JUST SHOW SCREENSHOT!

Data

Year	Cash Flow $
0	-1,000
1	1,200
2	-3,000
3	3,500