A B C D E F G H I J K L M N z 3 4 5 Calculate Price Of A Semi-Annual Coupon Bond In Excel 6 7 8 $ 1,000.00 5.0% 9 Assume bondholders can get coupons twice in a year from a bond. In this condition, you must calculate the price of the semi-annual coupon bond: 10 Face value Market (discount) interest rate (annual) Time to maturity in years Number of periods Coupon rate (annual) Price of the bond 10 20 2.50% ? 11 12 13 14 15 16 17 18 19 20 $ 1,000.00 21 1.0% 22 10 Face value Market (discount) interest rate (annual) Time to maturity in years Number of periods Coupon rate (annual) Price of the bond 23 20 24 2.50% 25 ? 26