In: Finance
Bond Valuation
A corporate bond has a face value of $1,000. The bond has an 8% coupon rate and it has 13 years to maturity. The interest rate on similar bonds is 6%. Assume interest is paid annually. What is the current price of this bond?
Assume everything in #1 above, except the interest rate on similar bonds is 4%. What is the current price of this bond?
Assume everything in #1 above, except the interest rate on similar bonds is 4% and the bond pays interest semiannually. What is the price of this bond?
please show me using excel
A)
Bond price at 6% is $1,177.05
B)
Bond price at 4% is $1,399.43
C)
Bond price at 4% semi annual compounding is $1,402.42