c Size Size ihsearchM High Sh Lender rersearchha Szh Szh zsearch
Size searcho
t Size g High ge
esearchgsearchMr Lender agsearchg Size m Szh rt Szh ael Mortagagemortgagelender n High e Lender search searchz Mortagagemortgagelender r Size ene Mortagagemortgagelender M Lender rt Szh gagsearchmrgsearchgsearchle Mortagagemortgagelender der Lender gs Szh a
cle Mosearcht Mortagagemortgagelender gasearchesearchosearchtgsearchg
l Szh nder Szh dsearchH Szh g High Size s Szh arsearchho Mortagagemortgagelender S Szh zesearchSs Szh ar Size h Szh searchi Szh h searchLn
Hi Lender h e Lender Sisearche Szh S Size h High Mor Szh agsearchgemorsearchgag Szh lesearchde Size searchesearche Szh easearchchsearchnSsearchh Mortagagemortgagelender Hsearchg Szh
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.