Please post excel formula

G11 3 A B DE F G H 1 1 Bruin, Inc., has identified the following two mutually exclusive projects. What is the IRR for each of these projects? If the required return is 11 percent, what is the NPV for 2 each of these projects? 3 4 Input area: S 6 B 7 Year 0 ($41,300) ($41,300) 8 Year 1 19,100 6,300 9 Year 2 7,800 14,200 10 Year 3 15,200 17,900 11 Year 4 8,400 30,300 12 Required return 11% 13 14 (Use cells A6 to C12 from the given information to complete this question. You must use the built-in Excel 15 function to answer this question.) 16 17 Output area: 18 19 IRRA + 20 RRB 21 NPVA 22 NPVB 23 24 36 Graded Worksheet + Calculation Mode: Automatic Workbook Statistics