pb4uski
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
You are right... I remember reading somewhere that the minimum coupon is 0%.... and obviously, if the coupon is zero and one pays more than par then the real yield has to be negative.
Inflation | 2.00% | ||
Coupon rate | 0.00% | ||
Effective yield | 2.01% | ||
n | Principal | Cash Flow | Proof – PV |
0.0 | 100,000.00 | -100,000.00 | 100,000.00 |
0.5 | 101,000.00 | 0.00 | 0.00 |
1.0 | 102,010.00 | 0.00 | 0.00 |
1.5 | 103,030.10 | 0.00 | 0.00 |
2.0 | 104,060.40 | 0.00 | 0.00 |
2.5 | 105,101.01 | 0.00 | 0.00 |
3.0 | 106,152.02 | 0.00 | 0.00 |
3.5 | 107,213.54 | 0.00 | 0.00 |
4.0 | 108,285.67 | 0.00 | 0.00 |
4.5 | 109,368.53 | 0.00 | 0.00 |
5.0 | 110,462.21 | 0.00 | 0.00 |
5.5 | 111,566.83 | 0.00 | 0.00 |
6.0 | 112,682.50 | 0.00 | 0.00 |
6.5 | 113,809.33 | 0.00 | 0.00 |
7.0 | 114,947.42 | 0.00 | 0.00 |
7.5 | 116,096.90 | 0.00 | 0.00 |
8.0 | 117,257.86 | 0.00 | 0.00 |
8.5 | 118,430.44 | 0.00 | 0.00 |
9.0 | 119,614.75 | 0.00 | 0.00 |
9.5 | 120,810.90 | 0.00 | 0.00 |
10.0 | 122,019.00 | 0.00 | 0.00 |
10.5 | 123,239.19 | 0.00 | 0.00 |
11.0 | 124,471.59 | 0.00 | 0.00 |
11.5 | 125,716.30 | 0.00 | 0.00 |
12.0 | 126,973.46 | 0.00 | 0.00 |
12.5 | 128,243.20 | 0.00 | 0.00 |
13.0 | 129,525.63 | 0.00 | 0.00 |
13.5 | 130,820.89 | 0.00 | 0.00 |
14.0 | 132,129.10 | 0.00 | 0.00 |
14.5 | 133,450.39 | 0.00 | 0.00 |
15.0 | 134,784.89 | 0.00 | 0.00 |
15.5 | 136,132.74 | 0.00 | 0.00 |
16.0 | 137,494.07 | 0.00 | 0.00 |
16.5 | 138,869.01 | 0.00 | 0.00 |
17.0 | 140,257.70 | 0.00 | 0.00 |
17.5 | 141,660.28 | 0.00 | 0.00 |
18.0 | 143,076.88 | 0.00 | 0.00 |
18.5 | 144,507.65 | 0.00 | 0.00 |
19.0 | 145,952.72 | 0.00 | 0.00 |
19.5 | 147,412.25 | 0.00 | 0.00 |
20.0 | 148,886.37 | 148,886.37 | 100,000.00 |
Last edited: