Using a Spreadsheet to Calculate Bond Values. What is the value of a $1,000 bond with a 12-year maturity and an 8 percent coupon rate (paid semiannually) if the required rate of return is 5 percent, 6 percent, 8 percent, and 10 percent? (LG 3-2) Periodic The Bond Face Number of Coupon Required Value Value Payments Payment, $ Return Will Be $1,000 12 x 2 = 24 1,000(0.082=40 5% $1,268.27 1,000 24 40 1.169.36 1,000 24 8 1,000.00 1,000 24 40 10 862.01 6 40