The following formulas concern the price and return of U.S. government bonds.
CPN=
The yield to maturity (YTM) must satisfy:
YTM=
BEY=
If the bond's yield to maturity is known, you can calculate the market price as the present value of the coupon payments and the face value.
MP=