Bonds & Stock Valuation, answer using excel spreadsheet show formulas!!

1. Brittish Beer Inc. has a bond outstanding that sells for 104.23 percent of its 100,000 par value. The bond has a coupon rate of 5.4 percent paid annually and matures in 10 years. What is the yield to maturity of this bond?

2. Phish Phood Co. issued 20-year bonds two years ago at a coupon rate of 6.1 percent. The bonds make semiannual payments. If these bonds currently sell for 103 percent of par value, what is the YTM?

3. Syllio Inc. just paid a dividend of $1.25 per share on its stock. The dividends are expected to grow at a constant rate of 5% per year indefinitely. If investors require a return of 10% on Syllios stock, what is the current value of the stock?