### Create an Account

Home / Questions / Using a Spreadsheet to Calculate Bond Values What is the value of a \$1000 bond with a 12-y...

# Using a Spreadsheet to Calculate Bond Values What is the value of a \$1000 bond with a 12-year maturity and an 8 percent coupon rate (paid semiannually if the required return is 5 percent 6 percent

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 return is 5 percent, 6 percent, 8 percent, and 10 percent? ( LG 3-2 ) ( LG 3-2 )

Bond Valuation Formula Used to Calculate Fair Present Values

Most bonds pay a stated coupon rate of interest to the holders of the bonds. These bonds are called coupon bonds. The interest, or coupon, payments per year, INT, are generally constant (are fixed) over the life of the bond. 5 Thus, the fixed interest payment is essentially an annuity paid to the bond holder periodically (normally semiannually) over the life of the bond. Bonds that do not pay coupon interest are called zero-coupon bonds. For these bonds, INT is zero. The face or par value of the bond, on the other hand, is a lump sum payment received by the bond holder when the bond matures. Face value is generally set at \$1,000 in the U.S. bond market.

May 18 2020 View more View Less Subscribe To Get Solution