please explain this in excel with formulas given

35 1 Use the following information for Convertible L. 2 Face Value $1,000 3 Coupon Rate 9.50% 4 Market price of a convertible bond $1,100 5 Conversion ratio 6 Estimated value of a straight bond $850.00 7 Price of the common stock $28.00 8 Dividend per share $0.75 9 10 11 12 A) Premium over straight value (SV) of a Convertible Bond L is closed to: 13 14 Group of answer choices 0.00% 11.76% 17.65% 29.41% 15 a 16 b 17 C 18 d 19 20 B) Minimum price of a Convertible Bond L is closed to: 21 22 Group of answer choices 23 a 24 b 25 c 850 980 1000 1100 26 d 27 28 29 30 31