! Required information Consider the cash flows shown. 4 Year Revenues, $ Costs, $ 0 0 -6,000 1 2 25,000 19,000 -30,000 -7,000 3 4,000 -4,500 28,000 -12.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 ir= 18% per year and ip = 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