dixter, you are confused. You say: That is false.... not the way it works.
To begin with, bonds don't have a prime value... the $1,000 is par value. So let's say you have this mythical bond with a 30 year remaining term and a coupon of 9% and because interest rates are lower than when the bond was issued the value has increased and you need to pay $1,500 to acquire it.
In the first year, you receive interest of $90 ($1,000 par value * 9% coupon rate)... your yield is 5.54% [=RATE(30,90,-1500,1000)=5.54%]. The simple fact that in the first year you only receive $90 of interest on a $1,500 cash outlay/investment is proof positive that your return is less than 9%!
The only way you can achieve a yield of 9% is to buy the bond for par of $1,000, but because market interest rates are lower you have to pay more than $1,000 for a 9% coupon, and that extra $500 that you pay reduces the effective yield below 9% to 5.54%.
IRR | 5.54% |
0 | -1,500 |
1 | 90 |
2 | 90 |
3 | 90 |
4 | 90 |
5 | 90 |
6 | 90 |
7 | 90 |
8 | 90 |
9 | 90 |
10 | 90 |
11 | 90 |
12 | 90 |
13 | 90 |
14 | 90 |
15 | 90 |
16 | 90 |
17 | 90 |
18 | 90 |
19 | 90 |
20 | 90 |
21 | 90 |
22 | 90 |
23 | 90 |
24 | 90 |
25 | 90 |
26 | 90 |
27 | 90 |
28 | 90 |
29 | 90 |
30 | 1,090 |
| |
| |
Math is hard dixter.
Bond Amortization Calculator | | | | | | | | | | |
| | | | | | | | | | |
Bond Details | | Rate | Years | No. payments | Amount | | | | | |
Bond details | | 9.00% | 30 | 1 | 1,000.00 | | | | | |
| | | | | | | | | | |
Bond Issue Price | | | | | | | | | | |
Bond Issue price | | 5.54% | | | 1,500.00 | | | | | |
Premium | | | | | 500.00 | | | | | |
| | | | | | | | | | |
Effective Interest Method Amortization Schedule | | | | | | | | | | |
Period | Opening | Interest | Payment | Closing | Premium | | | | | |
1 | 1,500.00 | 83.15 | 90.00 | 1,493.15 | 6.85 | | | | | |
2 | 1,493.15 | 82.77 | 90.00 | 1,485.92 | 7.23 | | | | | |
3 | 1,485.92 | 82.37 | 90.00 | 1,478.29 | 7.63 | | | | | |
4 | 1,478.29 | 81.95 | 90.00 | 1,470.23 | 8.05 | | | | | |
5 | 1,470.23 | 81.50 | 90.00 | 1,461.73 | 8.50 | | | | | |
6 | 1,461.73 | 81.03 | 90.00 | 1,452.76 | 8.97 | | | | | |
7 | 1,452.76 | 80.53 | 90.00 | 1,443.29 | 9.47 | | | | | |
8 | 1,443.29 | 80.01 | 90.00 | 1,433.29 | 9.99 | | | | | |
9 | 1,433.29 | 79.45 | 90.00 | 1,422.75 | 10.55 | | | | | |
10 | 1,422.75 | 78.87 | 90.00 | 1,411.61 | 11.13 | | | | | |
11 | 1,411.61 | 78.25 | 90.00 | 1,399.86 | 11.75 | | | | | |
12 | 1,399.86 | 77.60 | 90.00 | 1,387.46 | 12.40 | | | | | |
13 | 1,387.46 | 76.91 | 90.00 | 1,374.37 | 13.09 | | | | | |
14 | 1,374.37 | 76.19 | 90.00 | 1,360.56 | 13.81 | | | | | |
15 | 1,360.56 | 75.42 | 90.00 | 1,345.98 | 14.58 | | | | | |
16 | 1,345.98 | 74.61 | 90.00 | 1,330.59 | 15.39 | | | | | |
17 | 1,330.59 | 73.76 | 90.00 | 1,314.35 | 16.24 | | | | | |
18 | 1,314.35 | 72.86 | 90.00 | 1,297.20 | 17.14 | | | | | |
19 | 1,297.20 | 71.91 | 90.00 | 1,279.11 | 18.09 | | | | | |
20 | 1,279.11 | 70.90 | 90.00 | 1,260.02 | 19.10 | | | | | |
21 | 1,260.02 | 69.85 | 90.00 | 1,239.86 | 20.15 | | | | | |
22 | 1,239.86 | 68.73 | 90.00 | 1,218.59 | 21.27 | | | | | |
23 | 1,218.59 | 67.55 | 90.00 | 1,196.14 | 22.45 | | | | | |
24 | 1,196.14 | 66.31 | 90.00 | 1,172.45 | 23.69 | | | | | |
25 | 1,172.45 | 64.99 | 90.00 | 1,147.44 | 25.01 | | | | | |
26 | 1,147.44 | 63.61 | 90.00 | 1,121.04 | 26.39 | | | | | |
27 | 1,121.04 | 62.14 | 90.00 | 1,093.19 | 27.86 | | | | | |
28 | 1,093.19 | 60.60 | 90.00 | 1,063.78 | 29.40 | | | | | |
29 | 1,063.78 | 58.97 | 90.00 | 1,032.75 | 31.03 | | | | | |
30 | 1,032.75 | 57.25 | 90.00 | 1,000.00 | 32.75 | | | | | |
| | | | | | | | | | |