search Education Csearch%search3 Mortgage C Lender %searchB Mortgage Csearch% Building Mortgage osearcht
a Mortgage e Lender CsearchM Approvals r
g Mortagagemortgagelender g Education Lender Mortgage d
rcsearchC%
zsearch %CE%93%CE%BB%CF%89%CF%83%CF%83%CE%AC%CF%81%CE%B9%CE%BF s %CE%93%CE%BB%CF%89%CF%83%CF%83%CE%AC%CF%81%CE%B9%CE%BF a1337844624843_Rcsearch1 Mortgage Len Approvals esearch C Mortgage o Education tg
g Lender Mortgage Mortgage zsearch 9
C Lender % Education FsearchR Education Mortgage search Lender
How to Calculate Bond Yield to Maturity Using Excel
Subtract the face value (F) of the bond from the current market price (P). For example, if F is $100 and P is $90, then P - F = -$10.
Divide this value by the number of years to maturity (n), as in (F-P)/n. If n = 5, then (F-P)/n = -$2.
Add the interest payment (C) to this value, as in C +(F-P)/n. If C is $5, then C +(F-P)/n = $3.
Divide the combined amount from Step 3 by the price plus face value divided by 2, as in (C +(F-P)/n) / ((F+P)/2). That is, 3 divided by 95 ($100 plus $90 divided by 2) equals .0315789.
The final value from Step 4, multiplied by 100 to get a percentage, is the yield to maturity. Yield to maturity = (C +(F-P)/n) / ((F+P)/2). In the example, the yield to maturity equals 3.158 percent.