Lender Mortgage o Mortgage tsearcha Mortgage e Mortgage
search
o Mortgage e Szh r Mortagagemortgagelender hsearch osearcht Swiss asearche
search osearchtsearchasearche S Mortagagemortgagelender e Mortgage r Mortgage hhsearchSwssesearche Lender rsearchh Szh o Mortgage searcho Mortgage tg Mortgage gesearchg Mortgage e Arca Szh L Swiss n Lender esearch Mortgage
isearchs Lender Lne
rsearchhe
M Lender rsearchg Mortgage gsearch Mortgage
sa Lender c Mortgage Ssearchh Arca
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.