The Pennington Corporation issued a new series of bonds on January 1, 1978. The bonds were sold at par ($1,000), have a 12 percent coupon, and mature in 30 years, on December 31, 2007. Coupon payments are made semiannually (on June 30 and December 31). Show me on Excel formula please.

1.)What was the YTM of Penningtons bonds on January 1, 1978?

2. What was the price of the bond on January 1, 1983, 5 years later, assuming that the level of interest rates had fallen to 10 percent?

3. Find the current yield and capital gains yield on the bond on January 1, 1983, given the price as determined in part b.

4. On July 1, 2001, Penningtons bonds sold for $916.42. What was the YTM at that date?

5. What were the current yield and capital gains yield on July 1, 2001?