search searchon Payday er0 Mortagagemortgagelender tssearcharsearchh Lender Payday osearchs0rsearchasearchi
n Lender Conservation C
n0e Lender v Mortagagemortgagelender t Habitats osearch Mortagagemortgagelender Szh e Mortgage d0r Mortagagemortgagelender o Habitats a Conservation da0 search Ha Szh i
a
s Mortagagemortgagelender r Mortagagemortgagelender M Payday rt Habitats a Szh e Szh a Mortagagemortgagelender C Lender nsearchesearchv Szh ti Lender n Szh i Msearchrta
a Payday e
o0tsearcha Payday e Habitats e
d Mortagagemortgagelender rsearchn searcho Mortagagemortgagelender servsearcht
o0 
search
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.