Company X is rated A and has 3 bonds issued 2 years ago. All the bonds were issued at par. Bond A is a 6% 10-year bond with yield to maturity of 5% and par value of $100. Bond B is a callable bond and Bond C is a puttable bond, both with 10 years to maturity and par value of $100. All bonds pay coupons annually.

Compute the current price of Bond A and explain why we will use 6% instead of 5%.

*Solve the question using EXCEL.