Martin Luther King Jr. was born at noon Tuesday, January 15, 1929, at the family home, 501 Auburn Avenue, N.E., Atlanta, Georgia. Dr. Charles Johnson was the attending physician. Martin Luther King Jr., was the first son and second child born to the Reverend Martin Luther King, Sr., and Alberta Williams King.
Example â Calculating the Purchase Price for a Bond with Accrued Interest. You purchase a corporate bond with a settlement date on September 15 with a face value of $1,000 and a nominal yield of 8%, that has a listed price of 100-08, and that pays interest semi-annually on February 15 and August 15.
With that additional information, using the Price() function is simple. To get the price as a percentage of the par value enter the function into B11: =PRICE(B6,B7,B4,B5,B3,B8,B9). You should see that the value of the bond is 96.16% of the face value. It is important to notice that Excel returns 96.16, not 0.9616.