Use excel, explain fully with formulas (formulatext function in excel)

You have been hired to value a new 20-year callable, convertible bond. The bond has a coupon rate of 5.4 percent, payable annually. The conversion price is $96 and the stock currently sells for $38.10. The stock price is expected to grow at 12 percent per year. The bond is callable at $1,200; but based on prior experience, it won't be called unless the conversion value is $1,300. The required return on this bond is 9 percent.

What value would you assign to this bond?