Required information Consider the cash flows shown. Year Revenues, $ Costs, $ 0 1 2 3 4 0 -6,000 25,000 |-30,000||-7,000 19,000 4,000 28,000 -5,500 -13,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 i,= 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 33.80 % per year