As an example, suppose that a bond was issued with a coupon rate of 8 and a face value of 1,000. .
Fortunately, the Rate function in Excel can do the calculation quite easily.
1, yield to maturity is the discount rate at which the sum of all future cash flows from the bond (coupons and principal) is equal to the current price of the bond.

The Yield function is defined as: yield ( settlement, maturity, rate, pr, redemption, frequency,basis) where settlement is the date that you take ownership (typically 3 business days after the trade date maturity is the maturity date, rate is the annual coupon rate, pr is the.
Yield to worst (YTW when a bond is callable, puttable, exchangeable, or has other features, the yield to worst is the lowest yield of yield to maturity, yield to call, yield to put, and others.
However as the yield graph is curved, for long-term bonds, the price yield curve is hump-shaped to accommodate for the lower convexity in the later term.
The rate of interest used to discount the bonds cash flows is known as the yield to maturity (YTM.) a) Pricing Coupon Bonds A coupon-bearing bond may be priced with the following formula: where: C the periodic coupon payment y the yield to maturity (YTM).A) price The Excel function price is implemented as follows: price(settlement, maturity, rate, yld, redemption, frequency, basis) where: settlement date on which the bond owner pays for the bond maturity maturity date of the bond; this is the date on which the owner receives the.Calculations edit Formula for yield to maturity for zero-coupon bonds edit Yield to maturity (YTM) Face value Present value Time period 1 displaystyle textYield to maturity (YTM)sqrttextTime perioddfrac textFace valuetextPresent value-1 Example 1 edit Consider a 30-year zero-coupon bond with a face value of 100.Let's return to our example: Assume that the bond may be called in one year with a call premium of 3 of the face value.That is why we calculate the yield to call (YTC) for callable bonds.Now, ask yourself which is more advantageous to the issuer: 1) Continuing to pay interest at a yield.50 per year; or 2) Call the bond and pay an annual rate.17?Treasuries can be classified by their maturities as follows: Treasury bills the maturity is one year or less; the currently available maturities are 4 weeks, 13 weeks, 26 weeks and 52 weeks Treasury notes the maturity ranges between 1 and 10 years; the currently available.

[L_RANDNUM-10-999]