Quick Price Calculation

• 1). Look up the current yield for comparable bonds. The coupon rate or annual interest and time to maturity of the bond should be known. The Wall Street Journal, both in print and online at wsj.com, provides a listing of current bond data.
  
  
• 2). An estimated bond value is the annual coupon rate divided by the current yield. If a bond pays $80 per year in interest per $1,000 of face amount (8 percent coupon) and the current market yield is 7 percent, calculate 80 divided by 0.07. In this case, a $1,000 bond has a premium value of $1,142.85.
  
  
• 3). Use this premium calculation to get an idea what a premium bond is worth. The longer the maturity, the more accurate the estimate.
  
  

Spreadsheet Price Calculation

• 1). Using spreadsheet software such as Microsoft Excel or Open Office Calc, set up two columns, one for labels and the second for data.
  
  
• 2). Type these labels into the label column: Today's Date, Maturity Date, Coupon Rate, Current Yield, Par Value, Frequency and Price.
  
  
• 3). In the second column enter the data corresponding to the label. The maturity date is the date when the bond principal will be returned to the bond holder. Coupon rate and current yield should be expressed as a percentage. A $1,000 bond paying $40 twice a year would has a coupon rate of 8 percent. Par value is the maturity value expressed as a percentage, usually 100. However, enter this value as a whole number, not a percentage. The frequency is the number of interest payments per year, usually two.
  
  
• 4). In the column next to the price label, type in the PRICE function using the entered data. If the data is in column B, the formula will look like this:
  =PRICE(B1,B2,B3,B4,B5,B6). The PRICE function will return a current value of the bond based on the provided data.
  
  
• 5). Check the results of your spreadsheet. Using a 8 percent coupon, 7 percent current yield and a 30-year maturity from the current date should produce a price of $112.47. This means a $1,000 face amount bond would have a premium price of $1,124.70. If the results are accurate, you can now figure the premium value of any bond with an above market coupon rate.