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).

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.)

*Please show excel formulas if possible! Thank you.