Lion Corp. has a $5,000 par value bond with a coupon rate of 4.2% paid semiannually and 16 years to maturity. The
YTM on the bond is 4.4%. What is the dollar price of the bond? I need to work out the problem with excel. Please include any notes so I can handle problems such as this one.