Required information Consider the cash flows shown. 0 1 2 Year Revenues, $ Costs, $ 3 4.000 0 -6.000 25,000 | 19,000 -30,000 -7,000 4 28,000 -8,500 -5,000 NOTE: This is a multi-part question. Once an answer is submitted, you will be unable to return to this part. Determine the external rate of return using the MIRR method if Ip=18% per year and Ib = 10% per year. Verify your answer with the spreadsheet function. The spreadsheet function is MIRR(B1:B5,10%,18%) The external rate of return is % per year