| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Periods | Principal | Coupon | Market Price | Market Premium | Tax Rate | |
2 | 7 | 700,000,000.00 | 1.625% | 101.00% | 7,000,000.00 | 0.00% | |
3 | |||||||
4 | Coupon Yield | 10.71% | Total Yield | 2.52% | Total Lazy Yield | 0.67% | |
5 | Coupon Amount | 74,988,169.66 | Total Amount | 717,646,563.54 | Total Lazy Amount | 704,698,235.39 | |
6 | |||||||
7 | Period | In Period | Coupon | Inflation Rate | Principal | Lazy Coupon | |
8 | 1 | 1 | 11,204,375.00 | 1.50% | 693,105,000.00 | 10,246,873.68 | |
9 | 2 | 1 | 11,036,309.38 | 1.50% | 682,708,425.00 | 10,244,568.13 | |
10 | 3 | 1 | 10,870,764.73 | 1.50% | 672,467,798.63 | 10,242,263.10 | |
11 | 4 | 1 | 10,707,703.26 | 1.50% | 662,380,781.65 | 10,239,958.59 | |
12 | 5 | 1 | 10,547,087.71 | 1.50% | 652,445,069.92 | 10,237,654.60 | |
13 | 6 | 1 | 10,388,881.40 | 1.50% | 642,658,393.87 | 10,235,351.13 | |
14 | 7 | 1 | 10,233,048.18 | 1.50% | 633,018,517.96 | 10,233,048.18 | |
15 | 8 | 0 | 0.00 | 2.00% | 0.00 | 0.00 | |
16 | 9 | 0 | 0.00 | 2.00% | 0.00 | 0.00 | |
17 | 10 | 0 | 0.00 | 2.00% | 0.00 | 0.00 | |
18 | 11 | 0 | 0.00 | 2.00% | 0.00 | 0.00 | |
19 | 12 | 0 | 0.00 | 2.00% | 0.00 | 0.00 | |
20 | 13 | 0 | 0.00 | 2.00% | 0.00 | 0.00 | |
21 | 14 | 0 | 0.00 | 2.00% | 0.00 | 0.00 | |
22 | 15 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
23 | 16 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
24 | 17 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
25 | 18 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
26 | 19 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
27 | 20 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
28 | 21 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
29 | 22 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
30 | 23 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
31 | 24 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
32 | 25 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
33 | 26 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
34 | 27 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
35 | 28 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
36 | 29 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
37 | 30 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
38 | 31 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
39 | 32 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
40 | 33 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
41 | 34 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
42 | 35 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
43 | 36 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
44 | 37 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
45 | 38 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
46 | 39 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
47 | 40 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
48 | 41 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
49 | 42 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
50 | 43 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
51 | 44 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
52 | 45 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
53 | 46 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
54 | 47 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
55 | 48 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
56 | 49 | 0 | 0.00 | 0.00% | 0.00 | 0.00 | |
57 | 50 | 0 | 0.00 | 0.00% | 0.00 | 0.00 |