Use the bond pricing formula to price a 20-year and a 5-year semi-annual coupon bond. Specify if the bond is a Discount/Par/Premium bond. A discount bond trades below the par value and a premium bond above. Can you please help me with the formulas I am supposed to use in excel.

Short Answer: Which bond appears to be more sensitive to changes in interest rates? Short Answer: Which bond appears to be more sensitive to changes in interest rates