search Lender o
tsearcha0e Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C searchS
an Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C 3search%
7 Mortagagemortgagelender 9search%B Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C % Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C 8 Mortagagemortgagelender Asearch% Mortagagemortgagelender 6 Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C E Mortagagemortgagelender %search40A Mortgage %708 Szh % A%3E%3C 9
E Mortgage %searchD9 Mortgage % A%3E%3C 7 Szh Bsearch% Szh 1%search5% P%3E%3Cp%20class Asearch8 Mortagagemortgagelender 20searchE Szh % Mortagagemortgagelender 8search8search% Szh 9 Mortgage A1 Mortgage Bsearch% Mortgage 5
A
% Mortagagemortgagelender 2 Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C E Mortgage % A%3E%3C 7searchAsearch%E Mortgage %4 Mortgage A0%search7 Mortgage 8
%09%6B0%A
8search%
3 Mortgage Esearch% P%3E%3Cp%20class Csearch8search%
508
% Szh 3 Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C E
%8 Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C %Asearch%search8080% Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C 7 A%3E%3C E2search8 Mortgage %0CsearchE8%8
% Mortagagemortgagelender 3%E Mortgage %AD%4%05%B8
8search%search5%
D Mortgage A9 P%3E%3Cp%20class E8search89searchB2% Mortgage 5%Asearch%B Mortgage %search2search80 Span%3E%E7%94%B5%E8%A7%86%E8%B4%AD%E7%89%A9%E7%BD%91%E7%BD%91%E5%BA%8620%E4%B8%87%E9%A1%BE%E5%AE%A2%E5%87%A1%E8%B4%AD%E7%89%A9%E6%BB%A1%E9%A2%9D2000%E5%85%83%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%8E%B7%E2%80%9C%E8%86%B3%E9%AD%94%E5%B8%88%E5%BD%A9%E8%89%B2%E5%A3%B6%E2%80%9D%E4%B8%80%E4%BB%BD%EF%BC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C 9 Mortgage % Szh 4 Mortgage Bsearch% Mortgage 0% Lender 4 Mortgage B Mortgage %searchDsearchEFsearchBC%88%E9%99%90%E9%87%8F%EF%BC%89%EF%BC%81%3C Mortagagemortgagelender
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.