File B19 Home Insert Share Formulas Data Review View Help Dra Calibri (Body) 11 BE V *** Xfx =RATE (30, B8 A B C D E F 1 Jiminy's Cricket Farm issued a 30-year, 4.5 percent semiannual bond 2 three years ago. The bond currently sells for 104 percent of its face value. The company's tax rate is 22 percent. 3 4 Input Area: 5 6 Settlement 1/1/2020 7 Maturity 1/1/2047 8 Coupon rate 4.50% 9 Price (% of par) 104 10 Redemption (% of par) 100 11 Payments per year 2 22% 12 Tax rate 13 14 (Use cells A6 to B12 from the given information to complete this questi 15 built-in Excel function to answer this question. Leave the "Basis" input 16 17 Output Area: 18 1-RATE (30.B.