Gatomeguti

YIELD() Using a spreadsheet to calculate Fixed Rate Bond yield Suppose we have a $1000 face value bond with 6 years to maturity, a coupon rate of 8%, and a price of $911 If the bond makes semiannual payments, what is its YieldToMaturity ?The formula used to calculate the Yield is =YIELD (C4,C5,C6,C7,C8,C9,C10) The YIELD function calculates the yield of the 10year bond YIELD = % As recommended the values of the settlement and maturity date arguments are entered as a reference to the cells containing datesYIELD is an Excel function that returns the yield to maturity of a bond given its coupon rate, current price, principal amount and coupon payment frequency per year In the context of debt securities, yield is the return that a debtholder earns by investing in a security at its current price There are two common measures of yield current yield and yield to maturity Professional Bond Valuation And Yield To Maturity Spreadsheet Yield to maturity of a bond excel