Kabegamieda

The Bond Yield Calculator for Excel or Open Office Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity The bond yield to maturity calculator is designed to handle odd first time periods and is ideal to analyze bond payment schedules and yield to maturity calculationsYield to maturity (YTM, yield) is the bond's internal rate of return (IRR) It is the rate that discounts future cash flows to the current market price ForDownload links for Bond Yield To Maturity Calculator 10 Bond Yield To Maturity Calculator 10 (804KB) Bond Yield to Maturity calculator for Excel and OpenOffice Calc Bond Yield Calculator Excel Model Eloquens Yield to maturity calculator excel download

The components of the discount yield formula are as follows (Face Value – Purchase Price) is the total discount amount applied to the face value of the bond (Face Value – Purchase Price) / Face Value is the percentage value of the total discount on the bond to its face value 360 / No of Days (or Months) to Maturity is the number of days (or months) remaining until maturity, because the bond is held until maturityYield to Maturity (YTM) 28 The Yield to maturity (or Promised yield or Internal rate of return (IRR)) can be computed from bond pricing formulas 1 when a bond's price is known (Solve for i ) YTM will be realised when bond is held to maturity Coupon payments are reinvested at the same rate as the YTMYield to Maturity (YTM) for a bond is the total return, interest plus capital gain, obtained from a bond held to maturity It is expressed as a percentage and tells investors what their return on investment will be if they purchase the bond and hold on to it until the bond issuer