ytm

Sheet1

Bond Assumptions:
Yield
6.00%
Face
$100.00
Coupon (paid semi-annually)
4.00%
5.00%
6.00%
7.00%
8.00%
Years
30
$72.32 
$86.16 
$100.00 
$113.84 
$127.68 
to
29
$72.67 
$86.33 
$100.00 
$113.67 
$127.33 
Maturity
28
$73.03 
$86.52 
$100.00 
$113.48 
$126.97 
27
$73.42 
$86.71 
$100.00 
$113.29 
$126.58 
26
$73.83 
$86.92 
$100.00 
$113.08 
$126.17 
25
$74.27 
$87.14 
$100.00 
$112.86 
$125.73 
24
$74.73 
$87.37 
$100.00 
$112.63 
$125.27 
23
$75.22 
$87.61 
$100.00 
$112.39 
$124.78 
22
$75.75 
$87.87 
$100.00 
$112.13 
$124.25 
21
$76.30 
$88.15 
$100.00 
$111.85 
$123.70 
20
$76.89 
$88.44 
$100.00 
$111.56 
$123.11 
19
$77.51 
$88.75 
$100.00 
$111.25 
$122.49 
18
$78.17 
$89.08 
$100.00 
$110.92 
$121.83 
17
$78.87 
$89.43 
$100.00 
$110.57 
$121.13 
16
$79.61 
$89.81 
$100.00 
$110.19 
$120.39 
15
$80.40 
$90.20 
$100.00 
$109.80 
$119.60 
14
$81.24 
$90.62 
$100.00 
$109.38 
$118.76 
13
$82.12 
$91.06 
$100.00 
$108.94 
$117.88 
12
$83.06 
$91.53 
$100.00 
$108.47 
$116.94 
11
$84.06 
$92.03 
$100.00 
$107.97 
$115.94 
10
$85.12 
$92.56 
$100.00 
$107.44 
$114.88 
9
$86.25 
$93.12 
$100.00 
$106.88 
$113.75 
8
$87.44 
$93.72 
$100.00 
$106.28 
$112.56 
7
$88.70 
$94.35 
$100.00 
$105.65 
$111.30 
6
$90.05 
$95.02 
$100.00 
$104.98 
$109.95 
5
$91.47 
$95.73 
$100.00 
$104.27 
$108.53 
4
$92.98 
$96.49 
$100.00 
$103.51 
$107.02 
3
$94.58 
$97.29 
$100.00 
$102.71 
$105.42 
2
$96.28 
$98.14 
$100.00 
$101.86 
$103.72 
1
$98.09 
$99.04 
$100.00 
$100.96 
$101.91 

Sheet2

Sheet3