PLEASE SHOW HOW TO ANSWER ON EXCEL :-)

The Pennington Corporation issued a new series of bonds on January 1, 1994. The bonds were sold at par ($1,000), had a 12% coupon, and mature in 30 years, on December 31, 2023. Coupon payments are made semiannually (on June 30 and December 31).

a. What was the YTM on January 1, 1994?

b. What was the price of the bonds on January 1, 1999, 5 years later, assuming that interest rates had fallen to

10%?

c. Find the current yield, capital gains yield, and total return on January 1, 1999, given the price as

determined in part b.

d. On July 1, 2017, 612 years before maturity, Pennington's bonds sold for $916.42. What were the YTM, the

current yield, the capital gains yield, and the total return at that time?

e. Now assume that you plan to purchase an outstanding Pennington bond on March 1, 2017, when the going

rate of interest given its risk was 15.5%. How large a check must you write to complete the transaction? (This is a difficult question.)