Spreadsheet: 45809d1244598647-calculating-rise-in-cpi-quick-lease-evaluation
Sheet: Sheet3

Today is |  | CPI | Discount PV | 1998
2009-06-10 00:00:00 | CPI [NAME] (Triennial) | 0.01 | 0.1 | 3 |  |  |  | Base Period:  1982-84=100
 | Lease Date | 1998-03-15 00:00:00 | At Lease Date | [NAME]
 | Initial [NAME] | 125 | 5006.876000570856 | 5345.874901313985 |  |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Annual | HALF1
Rental Period | Rent Date | Rent | Present Val | Cumulative PV | Remaining Pmts | Present Val |  | 1966 | 31.8 | 32 | 32.1 | 32.3 | 32.3 | 32.4 | 32.5 | 32.7 | 32.7 | 32.9 | 32.9 | 32.9 | 32.4 | 0.03459119496855334
1 | 1998-03-15 00:00:00 | 23.28767123287671 | 23.28767123287671 | 23.28767123287671 | 0 | 0 |  | 1967 | 32.9 | 32.9 | 33 | 33.1 | 33.2 | 33.3 | 33.4 | 33.5 | 33.6 | 33.7 | 33.8 | 33.9 | 33.4 | 0.03039513677811545
2 | 1998-04-01 00:00:00 | 125 | 118.9767995240928 | 142.2644707569695 | 0 | 0 |  | 1968 | 34.1 | 34.2 | 34.3 | 34.4 | 34.5 | 34.7 | 34.9 | 35 | 35.1 | 35.3 | 35.4 | 35.5 | 34.8 | 0.0471976401179941
3 | 1998-07-01 00:00:00 | 125 | 116.0749263649686 | 258.3393971219381 | 0 | 0 |  | 1969 | 35.6 | 35.8 | 36.1 | 36.3 | 36.4 | 36.6 | 36.8 | 37 | 37.1 | 37.3 | 37.5 | 37.7 | 36.7 | 0.06197183098591563
4 | 1998-10-01 00:00:00 | 125 | 113.2438305999694 | 371.5832277219075 | 0 | 0 |  | 1970 | 37.8 | 38 | 38.2 | 38.5 | 38.6 | 38.8 | 39 | 39 | 39.2 | 39.4 | 39.6 | 39.8 | 38.8 | 0.05570291777188308
5 | 1999-01-01 00:00:00 | 125 | 110.4817859511896 | 482.0650136730972 | 0 | 0 |  | 1971 | 39.8 | 39.9 | 40 | 40.1 | 40.3 | 40.6 | 40.7 | 40.8 | 40.8 | 40.9 | 40.9 | 41.1 | 40.5 | 0.03266331658291466
6 | 1999-04-01 00:00:00 | 125 | 107.7871082450631 | 589.8521219181603 | 0 | 0 |  | 1972 | 41.1 | 41.3 | 41.4 | 41.5 | 41.6 | 41.7 | 41.9 | 42 | 42.1 | 42.3 | 42.4 | 42.5 | 41.8 | 0.03406326034063256
7 | 1999-07-01 00:00:00 | 125 | 105.1581543854274 | 695.0102763035877 | 0 | 0 |  | 1973 | 42.6 | 42.9 | 43.3 | 43.6 | 43.9 | 44.2 | 44.3 | 45.1 | 45.2 | 45.6 | 45.9 | 46.2 | 44.4 | 0.08705882352941186
8 | 1999-10-01 00:00:00 | 125 | 102.5933213516365 | 797.6035976552242 | 0 | 0 |  | 1974 | 46.6 | 47.2 | 47.8 | 48 | 48.6 | 49 | 49.4 | 50 | 50.6 | 51.1 | 51.5 | 51.9 | 49.3 | 0.1233766233766234
9 | 2000-01-01 00:00:00 | 125 | 100.0910452211088 | 897.694642876333 | 0 | 0 |  | 1975 | 52.1 | 52.5 | 52.7 | 52.9 | 53.2 | 53.6 | 54.2 | 54.3 | 54.6 | 54.9 | 55.3 | 55.5 | 53.8 | 0.06936416184971095
10 | 2000-04-01 00:00:00 | 125 | 97.64980021571589 | 995.3444430920489 | 0 | 0 |  | 1976 | 55.6 | 55.8 | 55.9 | 56.1 | 56.5 | 56.8 | 57.1 | 57.4 | 57.6 | 57.9 | 58 | 58.2 | 56.9 | 0.0486486486486486
11 | 2000-07-01 00:00:00 | 125 | 95.26809777143013 | 1090.612540863479 | 0 | 0 |  | 1977 | 58.5 | 59.1 | 59.5 | 60 | 60.3 | 60.7 | 61 | 61.2 | 61.4 | 61.6 | 61.9 | 62.1 | 60.6 | 0.0670103092783505
12 | 2000-10-01 00:00:00 | 125 | 92.94448563066355 | 1183.557026494143 | 0 | 0 |  | 1978 | 62.5 | 62.9 | 63.4 | 63.9 | 64.5 | 65.2 | 65.7 | 66 | 66.5 | 67.1 | 67.4 | 67.7 | 65.2 | 0.09017713365539448
13 | 2001-01-01 00:00:00 | 125 | 90.67754695674493 | 1274.234573450888 | 0 | 0 |  | 1979 | 68.3 | 69.1 | 69.8 | 70.6 | 71.5 | 72.3 | 73.1 | 73.8 | 74.6 | 75.2 | 75.9 | 76.7 | 72.6 | 0.1329394387001477
14 | 2001-04-01 00:00:00 | 126.25 | 89.35055846469503 | 1363.585131915583 | 0 | 0 |  | 1980 | 77.8 | 78.9 | 80.1 | 81 | 81.8 | 82.7 | 82.7 | 83.3 | 84 | 84.8 | 85.5 | 86.3 | 82.4 | 0.1251629726205996
15 | 2001-07-01 00:00:00 | 126.25 | 87.17127655092196 | 1450.756408466505 | 0 | 0 |  | 1981 | 87 | 87.9 | 88.5 | 89.1 | 89.8 | 90.6 | 91.6 | 92.3 | 93.2 | 93.4 | 93.7 | 94 | 90.9 | 0.0892236384704519
16 | 2001-10-01 00:00:00 | 126.25 | 85.04514785455801 | 1535.801556321063 | 0 | 0 |  | 1982 | 94.3 | 94.6 | 94.5 | 94.9 | 95.8 | 97 | 97.5 | 97.7 | 97.9 | 98.2 | 98 | 97.6 | 96.5 | 0.03829787234042548
17 | 2002-01-01 00:00:00 | 126.25 | 82.97087595566636 | 1618.772432276729 | 0 | 0 |  | 1983 | 97.8 | 97.9 | 97.9 | 98.6 | 99.2 | 99.5 | 99.9 | 100.2 | 100.7 | 101 | 101.2 | 101.3 | 99.6 | 0.03790983606557385
18 | 2002-04-01 00:00:00 | 126.25 | 80.94719605430865 | 1699.719628331038 | 0 | 0 |  | 1984 | 101.9 | 102.4 | 102.6 | 103.1 | 103.4 | 103.7 | 104.1 | 104.5 | 105 | 105.3 | 105.3 | 105.3 | 103.9 | 0.03948667324777877
19 | 2002-07-01 00:00:00 | 126.25 | 78.9728741993255 | 1778.692502530363 | 0 | 0 |  | 1985 | 105.5 | 106 | 106.4 | 106.9 | 107.3 | 107.6 | 107.8 | 108 | 108.3 | 108.7 | 109 | 109.3 | 107.6 | 0.03798670465337128
20 | 2002-10-01 00:00:00 | 126.25 | 77.04670653592733 | 1855.739209066291 | 0 | 0 |  | 1986 | 109.6 | 109.3 | 108.8 | 108.6 | 108.9 | 109.5 | 109.5 | 109.7 | 110.2 | 110.3 | 110.4 | 110.5 | 109.6 | 0.01097895699908502
21 | 2003-01-01 00:00:00 | 126.25 | 75.16751857163644 | 1930.906727637927 | 0 | 0 |  | 1987 | 111.2 | 111.6 | 112.1 | 112.7 | 113.1 | 113.5 | 113.8 | 114.4 | 115 | 115.3 | 115.4 | 115.4 | 113.6 | 0.044343891402715
22 | 2003-04-01 00:00:00 | 126.25 | 73.33416446013311 | 2004.24089209806 | 0 | 0 |  | 1988 | 115.7 | 116 | 116.5 | 117.1 | 117.5 | 118 | 118.5 | 119 | 119.8 | 120.2 | 120.3 | 120.5 | 118.3 | 0.04419410745233954
23 | 2003-07-01 00:00:00 | 126.25 | 71.54552630256889 | 2075.786418400629 | 0 | 0 |  | 1989 | 121.1 | 121.6 | 122.3 | 123.1 | 123.8 | 124.1 | 124.4 | 124.6 | 125 | 125.6 | 125.9 | 126.1 | 124 | 0.04647302904564321
24 | 2003-10-01 00:00:00 | 126.25 | 69.80051346592087 | 2145.58693186655 | 0 | 0 |  | 1990 | 127.4 | 128 | 128.7 | 128.9 | 129.2 | 129.9 | 130.4 | 131.6 | 132.7 | 133.5 | 133.8 | 133.8 | 130.7 | 0.0610626486915149
25 | 2004-01-01 00:00:00 | 126.25 | 68.09806191797158 | 2213.684993784522 | 0 | 0 |  | 1991 | 134.6 | 134.8 | 135 | 135.2 | 135.6 | 136 | 136.2 | 136.6 | 137.2 | 137.4 | 137.8 | 137.9 | 136.2 | 0.03064275037369213
26 | 2004-04-01 00:00:00 | 127.5125 | 67.10150491429397 | 2280.786498698816 | 0 | 0 |  | 1992 | 138.1 | 138.6 | 139.3 | 139.5 | 139.7 | 140.2 | 140.5 | 140.9 | 141.3 | 141.8 | 142 | 141.9 | 140.3 | 0.02900652646845536
27 | 2004-07-01 00:00:00 | 127.5125 | 65.46488284321363 | 2346.251381542029 | 0 | 0 |  | 1993 | 142.6 | 143.1 | 143.6 | 144 | 144.2 | 144.4 | 144.4 | 144.8 | 145.1 | 145.7 | 145.8 | 145.8 | 144.5 | 0.02748414376321362
28 | 2004-10-01 00:00:00 | 127.5125 | 63.86817838362305 | 2410.119559925653 | 0 | 0 |  | 1994 | 146.2 | 146.7 | 147.2 | 147.4 | 147.5 | 148 | 148.4 | 149 | 149.4 | 149.5 | 149.7 | 149.7 | 148.2 | 0.02674897119341546
29 | 2005-01-01 00:00:00 | 127.5125 | 62.31041793524199 | 2472.429977860895 | 0 | 0 |  | 1995 | 150.3 | 150.9 | 151.4 | 151.9 | 152.2 | 152.5 | 152.5 | 152.9 | 153.2 | 153.7 | 153.6 | 153.5 | 152.4 | 0.02538410153640625
30 | 2005-04-01 00:00:00 | 127.5125 | 60.79065164413855 | 2533.220629505033 | 0 | 0 |  | 1996 | 154.4 | 154.9 | 155.7 | 156.3 | 156.6 | 156.7 | 157 | 157.3 | 157.8 | 158.3 | 158.6 | 158.6 | 156.9 | 0.03322475570032579
31 | 2005-07-01 00:00:00 | 127.5125 | 59.30795282354978 | 2592.528582328583 | 0 | 0 |  | 1997 | 159.1 | 159.6 | 160 | 160.2 | 160.1 | 160.3 | 160.5 | 160.8 | 161.2 | 161.6 | 161.5 | 161.3 | 160.5 | 0.01702395964691061
32 | 2005-10-01 00:00:00 | 127.5125 | 57.86141738882907 | 2650.389999717412 | 0 | 0 |  | 1998 | 161.6 | 161.9 | 162.2 | 162.5 | 162.8 | 163 | 163.2 | 163.4 | 163.6 | 164 | 164 | 163.9 | 163 | 0.01611903285802851
33 | 2006-01-01 00:00:00 | 127.5125 | 56.4501633061747 | 2706.840163023587 | 0 | 0 |  | 1999 | 164.3 | 164.5 | 165 | 166.2 | 166.2 | 166.2 | 166.7 | 167.1 | 167.9 | 168.2 | 168.3 | 168.3 | 166.6 | 0.02684563758389258
34 | 2006-04-01 00:00:00 | 127.5125 | 55.07333005480459 | 2761.913493078391 | 0 | 0 |  | 2000 | 168.8 | 169.8 | 171.2 | 171.3 | 171.5 | 172.4 | 172.8 | 172.8 | 173.7 | 174 | 174.1 | 174 | 172.2 | 0.03386809269162194
35 | 2006-07-01 00:00:00 | 127.5125 | 53.73007810224838 | 2815.643571180639 | 0 | 0 |  | 2001 | 175.1 | 175.8 | 176.2 | 176.9 | 177.7 | 178 | 177.5 | 177.5 | 178.3 | 177.7 | 177.4 | 176.7 | 177.1 | 0.01551724137931032
36 | 2006-10-01 00:00:00 | 127.5125 | 52.41958839243745 | 2868.063159573077 | 0 | 0 |  | 2002 | 177.1 | 177.8 | 178.8 | 179.8 | 179.8 | 179.9 | 180.1 | 180.7 | 181 | 181.3 | 181.3 | 180.9 | 179.9 | 0.02376910016977929
37 | 2007-01-01 00:00:00 | 128.787625 | 51.65247246474324 | 2919.71563203782 | 0 | 0 |  | 2003 | 181.7 | 183.1 | 184.2 | 183.8 | 183.5 | 183.7 | 183.9 | 184.6 | 185.2 | 185 | 184.5 | 184.3 | 184 | 0.01879491431730251
38 | 2007-04-01 00:00:00 | 128.787625 | 50.39265606316415 | 2970.108288100984 | 0 | 0 |  | 2004 | 185.2 | 186.2 | 187.4 | 188 | 189.1 | 189.7 | 189.4 | 189.5 | 189.9 | 190.9 | 191 | 190.3 | 188.9 | 0.03255561584373301
39 | 2007-07-01 00:00:00 | 128.787625 | 49.16356689089185 | 3019.271854991876 | 0 | 0 |  | 2005 | 190.7 | 191.8 | 193.3 | 194.6 | 194.4 | 194.5 | 195.4 | 196.4 | 198.8 | 199.2 | 197.6 | 196.8 | 195.3 | 0.03415659485023648
40 | 2007-10-01 00:00:00 | 128.787625 | 47.96445550330913 | 3067.236310495186 | 0 | 0 |  | 2006 | 198.3 | 198.7 | 199.8 | 201.5 | 202.5 | 202.9 | 203.5 | 203.9 | 202.9 | 201.8 | 201.5 | 201.8 | 201.6 | 0.02540650406504064
41 | 2008-01-01 00:00:00 | 128.787625 | 46.79459073493573 | 3114.030901230121 | 0 | 0 |  | 2007 | 202.416 | 203.499 | 205.352 | 206.686 | 207.949 | 208.352 | 208.299 | 207.917 | 208.49 | 208.936 | 210.177 | 210.036 | 207.342 | 0.04081268582755193
42 | 2008-04-01 00:00:00 | 128.787625 | 45.65325925359583 | 3159.684160483717 | 0 | 0 |  | 2008 | 211.08 | 211.693 | 213.528 | 214.823 | 216.632 | 218.815 | 219.964 | 219.086 | 218.783 | 216.573 | 212.425 | 210.228 | 215.303 | 0.0009141290064560437
43 | 2008-07-01 00:00:00 | 128.787625 | 44.53976512545935 | 3204.223925609177 | 0 | 0 |  | 2009 | 211.143 | 212.193 | 212.709 | 213.24 |  |  |  |  |  |  |  |  |  | 0.04531524476393412
44 | 2008-10-01 00:00:00 | 128.787625 | 43.45342939069207 | 3247.677354999869 | 0 | 0
45 | 2009-01-01 00:00:00 | 128.787625 | 42.39358964945567 | 3290.070944649325 | 0 | 0
46 | 2009-04-01 00:00:00 | 128.787625 | 41.35959965800554 | 3331.43054430733 | 0 | 128.787625
47 | 2009-07-01 00:00:00 | 128.787625 | 40.35082893463954 | 3371.78137324197 | 1 | 125.6464634146342
48 | 2009-10-01 00:00:00 | 128.787625 | 39.36666237525809 | 3411.148035617228 | 2 | 122.5819155264723
49 | 2010-01-01 00:00:00 | 130.07550125 | 38.7905648770836 | 3449.938600494311 | 3 | 120.7880338358411
50 | 2010-04-01 00:00:00 | 130.07550125 | 37.84445353861814 | 3487.783054032929 | 4 | 117.8419842300889
51 | 2010-07-01 00:00:00 | 130.07550125 | 36.92141808645672 | 3524.704472119386 | 5 | 114.9677894927696
52 | 2010-10-01 00:00:00 | 130.07550125 | 36.02089569410412 | 3560.72536781349 | 6 | 112.1636970661167
53 | 2011-01-01 00:00:00 | 130.07550125 | 35.14233726254061 | 3595.867705076031 | 7 | 109.4279971376748
54 | 2011-04-01 00:00:00 | 130.07550125 | 34.28520708540547 | 3630.152912161436 | 8 | 106.7590215977315
55 | 2011-07-01 00:00:00 | 130.07550125 | 33.4489825223468 | 3663.601894683783 | 9 | 104.1551430221771
56 | 2011-10-01 00:00:00 | 130.07550125 | 32.63315368033835 | 3696.235048364121 | 10 | 101.6147736801728
57 | 2012-01-01 00:00:00 | 130.07550125 | 31.83722310276912 | 3728.07227146689 | 11 | 99.13636456602227
58 | 2012-04-01 00:00:00 | 130.07550125 | 31.06070546611621 | 3759.132976933007 | 12 | 96.71840445465588
59 | 2012-07-01 00:00:00 | 130.07550125 | 30.30312728401582 | 3789.436104217023 | 13 | 94.35941898015207
60 | 2012-10-01 00:00:00 | 130.07550125 | 29.56402661855203 | 3819.000130835575 | 14 | 92.05796973673375
61 | 2013-01-01 00:00:00 | 131.3762562625 | 29.13138232657321 | 3848.131513162148 | 15 | 90.71077993570836
62 | 2013-04-01 00:00:00 | 131.3762562625 | 28.4208608064129 | 3876.55237396856 | 16 | 88.49832188849595
63 | 2013-07-01 00:00:00 | 131.3762562625 | 27.7276690794272 | 3904.280043047988 | 17 | 86.33982623267899
64 | 2013-10-01 00:00:00 | 131.3762562625 | 27.05138446773387 | 3931.331427515722 | 18 | 84.23397681236975
65 | 2014-01-01 00:00:00 | 131.3762562625 | 26.39159460266719 | 3957.723022118389 | 19 | 82.17948957304365
66 | 2014-04-01 00:00:00 | 131.3762562625 | 25.74789717333384 | 3983.470919291723 | 20 | 80.17511177857918
67 | 2014-07-01 00:00:00 | 131.3762562625 | 25.11989968130131 | 4008.590818973024 | 21 | 78.21962124739433
68 | 2014-10-01 00:00:00 | 131.3762562625 | 24.50721920126957 | 4033.098038174294 | 22 | 76.31182560721399
69 | 2015-01-01 00:00:00 | 131.3762562625 | 23.90948214758007 | 4057.007520321874 | 23 | 74.45056156801365
70 | 2015-04-01 00:00:00 | 131.3762562625 | 23.32632404641959 | 4080.333844368293 | 24 | 72.63469421269625
71 | 2015-07-01 00:00:00 | 131.3762562625 | 22.75738931358008 | 4103.091233681874 | 25 | 70.86311630506951
72 | 2015-10-01 00:00:00 | 132.690018825125 | 22.4243543480155 | 4125.515588029889 | 26 | 69.826095090849
73 | 2016-01-01 00:00:00 | 132.690018825125 | 21.87741887611269 | 4147.393006906002 | 27 | 68.12301960082829
74 | 2016-04-01 00:00:00 | 132.690018825125 | 21.34382329376847 | 4168.73683019977 | 28 | 66.46148253739345
75 | 2016-07-01 00:00:00 | 132.690018825125 | 20.8232422378229 | 4189.560072437594 | 29 | 64.84047076818872
76 | 2016-10-01 00:00:00 | 132.690018825125 | 20.31535828080283 | 4209.875430718396 | 30 | 63.25899587140366
77 | 2017-01-01 00:00:00 | 132.690018825125 | 19.81986173736862 | 4229.695292455765 | 31 | 61.71609353307672
78 | 2017-04-01 00:00:00 | 132.690018825125 | 19.33645047548158 | 4249.031742931246 | 32 | 60.21082295909925
79 | 2017-07-01 00:00:00 | 132.690018825125 | 18.86482973217715 | 4267.896572663423 | 33 | 58.74226630156024
80 | 2017-10-01 00:00:00 | 132.690018825125 | 18.40471193383137 | 4286.301284597254 | 34 | 57.30952809908317
81 | 2018-01-01 00:00:00 | 132.690018825125 | 17.95581652081109 | 4304.257101118065 | 35 | 55.91173473081285
82 | 2018-04-01 00:00:00 | 132.690018825125 | 17.51786977640106 | 4321.774970894467 | 36 | 54.54803388371985
83 | 2018-07-01 00:00:00 | 132.690018825125 | 17.09060465990348 | 4338.86557555437 | 37 | 53.21759403289742
84 | 2018-10-01 00:00:00 | 134.0169190133762 | 16.84049825024636 | 4355.706073804617 | 38 | 52.43879997387943
85 | 2019-01-01 00:00:00 | 134.0169190133762 | 16.42975439048425 | 4372.135828195101 | 39 | 51.15980485256529
86 | 2019-04-01 00:00:00 | 134.0169190133762 | 16.02902867364317 | 4388.164856868744 | 40 | 49.91200473421004
87 | 2019-07-01 00:00:00 | 134.0169190133762 | 15.63807675477383 | 4403.802933623518 | 41 | 48.69463876508296
88 | 2019-10-01 00:00:00 | 134.0169190133762 | 15.25666024855983 | 4419.059593872077 | 42 | 47.50696464886143
89 | 2020-01-01 00:00:00 | 134.0169190133762 | 14.88454658396081 | 4433.944140456038 | 43 | 46.34825819401115
90 | 2020-04-01 00:00:00 | 134.0169190133762 | 14.52150886240079 | 4448.465649318438 | 44 | 45.21781287220602
91 | 2020-07-01 00:00:00 | 134.0169190133762 | 14.16732571941541 | 4462.632975037854 | 45 | 44.11493938751806
92 | 2020-10-01 00:00:00 | 134.0169190133762 | 13.82178118967357 | 4476.454756227527 | 46 | 43.03896525611518
93 | 2021-01-01 00:00:00 | 134.0169190133762 | 13.48466457529129 | 4489.939420802819 | 47 | 41.98923439620993
94 | 2021-04-01 00:00:00 | 134.0169190133762 | 13.15577031735736 | 4503.095191120176 | 48 | 40.96510672800969
95 | 2021-07-01 00:00:00 | 134.0169190133762 | 12.83489787059254 | 4515.930088990769 | 49 | 39.96595778342409
96 | 2021-10-01 00:00:00 | 135.35708820351 | 12.64707009687655 | 4528.577159087646 | 50 | 39.38109010854472
97 | 2022-01-01 00:00:00 | 135.35708820351 | 12.33860497256249 | 4540.915764060208 | 51 | 38.42057571565338
98 | 2022-04-01 00:00:00 | 135.35708820351 | 12.03766338786585 | 4552.953427448074 | 52 | 37.48348850307647
99 | 2022-07-01 00:00:00 | 135.35708820351 | 11.74406184182034 | 4564.697489289894 | 53 | 36.56925707617217
100 | 2022-10-01 00:00:00 | 135.35708820351 | 11.45762130909301 | 4576.155110598987 | 54 | 35.67732397675334
101 | 2023-01-01 00:00:00 | 135.35708820351 | 11.17816713082245 | 4587.33327772981 | 55 | 34.80714534317399
102 | 2023-04-01 00:00:00 | 135.35708820351 | 10.90552890811947 | 4598.23880663793 | 56 | 33.95819057870634
103 | 2023-07-01 00:00:00 | 135.35708820351 | 10.63954039816534 | 4608.878347036095 | 57 | 33.12994202800618
104 | 2023-10-01 00:00:00 | 135.35708820351 | 10.38003941284423 | 4619.258386448939 | 58 | 32.32189466146945
105 | 2024-01-01 00:00:00 | 135.35708820351 | 10.12686771984803 | 4629.385254168787 | 59 | 31.53355576728727
106 | 2024-04-01 00:00:00 | 135.35708820351 | 9.879870946193199 | 4639.26512511498 | 60 | 30.76444465101197
107 | 2024-07-01 00:00:00 | 136.7106590855451 | 9.735287468931833 | 4649.000412583912 | 61 | 30.31423326587521
108 | 2024-10-01 00:00:00 | 136.7106590855451 | 9.497841433104231 | 4658.498254017017 | 62 | 29.57486172280509
109 | 2025-01-01 00:00:00 | 136.7106590855451 | 9.266186764004125 | 4667.764440781021 | 63 | 28.85352363200495
110 | 2025-04-01 00:00:00 | 136.7106590855451 | 9.040182208784517 | 4676.804622989805 | 64 | 28.14977915317557
111 | 2025-07-01 00:00:00 | 136.7106590855451 | 8.81968995978977 | 4685.624312949595 | 65 | 27.46319917382983
112 | 2025-10-01 00:00:00 | 136.7106590855451 | 8.604575570526606 | 4694.228888520121 | 66 | 26.79336504763886
113 | 2026-01-01 00:00:00 | 136.7106590855451 | 8.394707873684494 | 4702.623596393806 | 67 | 26.13986833915986
114 | 2026-04-01 00:00:00 | 136.7106590855451 | 8.189958901155604 | 4710.813555294962 | 68 | 25.50231057479011
115 | 2026-07-01 00:00:00 | 136.7106590855451 | 7.990203806005466 | 4718.803759100967 | 69 | 24.88030299979523
116 | 2026-10-01 00:00:00 | 136.7106590855451 | 7.795320786346799 | 4726.599079887314 | 70 | 24.27346634126364
117 | 2027-01-01 00:00:00 | 136.7106590855451 | 7.605191011070048 | 4734.204270898384 | 71 | 23.68143057684258
118 | 2027-04-01 00:00:00 | 136.7106590855451 | 7.419698547385413 | 4741.623969445769 | 72 | 23.10383470911471
119 | 2027-07-01 00:00:00 | 138.0777656764005 | 7.311117593033432 | 4748.935087038803 | 73 | 22.76572981093255
120 | 2027-10-01 00:00:00 | 138.0777656764005 | 7.132797651739933 | 4756.067884690542 | 74 | 22.21046810822688
121 | 2028-01-01 00:00:00 | 138.0777656764005 | 6.958826977307252 | 4763.02671166785 | 75 | 21.66874937387988
122 | 2028-04-01 00:00:00 | 138.0777656764005 | 6.789099490055857 | 4769.815811157906 | 76 | 21.14024329159013
123 | 2028-07-01 00:00:00 | 138.0777656764005 | 6.623511697615471 | 4776.439322855522 | 77 | 20.62462760155135
124 | 2028-10-01 00:00:00 | 138.0777656764005 | 6.461962631819972 | 4782.901285487342 | 78 | 20.12158790395254
125 | 2029-01-01 00:00:00 | 138.0777656764005 | 6.304353787141434 | 4789.205639274483 | 79 | 19.63081746727077
126 | 2029-04-01 00:00:00 | 138.0777656764005 | 6.150589060625791 | 4795.356228335109 | 80 | 19.15201704123977
127 | 2029-07-01 00:00:00 | 138.0777656764005 | 6.000574693293454 | 4801.356803028403 | 81 | 18.68489467438027
128 | 2029-10-01 00:00:00 | 138.0777656764005 | 5.854219212969224 | 4807.211022241372 | 82 | 18.22916553598075
129 | 2030-01-01 00:00:00 | 138.0777656764005 | 5.711433378506561 | 4812.922455619879 | 83 | 17.78455174242024
130 | 2030-04-01 00:00:00 | 138.0777656764005 | 5.572130125372255 | 4818.494585745251 | 84 | 17.35078218772707
131 | 2030-07-01 00:00:00 | 139.4585433331645 | 5.49058675768388 | 4823.985172502935 | 85 | 17.09686830205301
132 | 2030-10-01 00:00:00 | 139.4585433331645 | 5.356670007496469 | 4829.341842510431 | 86 | 16.67987151419806
133 | 2031-01-01 00:00:00 | 139.4585433331645 | 5.226019519508751 | 4834.56786202994 | 87 | 16.27304537970543
134 | 2031-04-01 00:00:00 | 139.4585433331645 | 5.098555628789025 | 4839.666417658728 | 88 | 15.87614183385895
135 | 2031-07-01 00:00:00 | 139.4585433331645 | 4.974200613452707 | 4844.640618272181 | 89 | 15.48891886230142
136 | 2031-10-01 00:00:00 | 139.4585433331645 | 4.852878647270934 | 4849.493496919452 | 90 | 15.1111403534648
137 | 2032-01-01 00:00:00 | 139.4585433331645 | 4.734515753435059 | 4854.228012672887 | 91 | 14.74257595459981
138 | 2032-04-01 00:00:00 | 139.4585433331645 | 4.619039759448838 | 4858.847052432336 | 92 | 14.38300093131689
139 | 2032-07-01 00:00:00 | 139.4585433331645 | 4.506380253120818 | 4863.353432685456 | 93 | 14.03219603055306
140 | 2032-10-01 00:00:00 | 139.4585433331645 | 4.396468539630066 | 4867.749901225086 | 94 | 13.68994734688103
141 | 2033-01-01 00:00:00 | 139.4585433331645 | 4.289237599639089 | 4872.039138824725 | 95 | 13.35604619207906
142 | 2033-04-01 00:00:00 | 140.8531287664962 | 4.226468268912664 | 4876.265607093638 | 96 | 13.16059185756083
143 | 2033-07-01 00:00:00 | 140.8531287664962 | 4.123383676987965 | 4880.388990770626 | 97 | 12.83960181225447
144 | 2033-10-01 00:00:00 | 140.8531287664962 | 4.022813343402892 | 4884.411804114029 | 98 | 12.52644079244338
145 | 2034-01-01 00:00:00 | 140.8531287664962 | 3.924695944783311 | 4888.336500058813 | 99 | 12.22091784628623
146 | 2034-04-01 00:00:00 | 140.8531287664962 | 3.828971653447132 | 4892.16547171226 | 100 | 11.92284667930364
147 | 2034-07-01 00:00:00 | 140.8531287664962 | 3.735582100924031 | 4895.901053813184 | 101 | 11.63204554078404
148 | 2034-10-01 00:00:00 | 140.8531287664962 | 3.644470342364909 | 4899.545524155549 | 102 | 11.34833711296004
149 | 2035-01-01 00:00:00 | 140.8531287664962 | 3.555580821819424 | 4903.101104977369 | 103 | 11.07154840288784
150 | 2035-04-01 00:00:00 | 140.8531287664962 | 3.468859338360414 | 4906.56996431573 | 104 | 10.80151063696375
151 | 2035-07-01 00:00:00 | 140.8531287664962 | 3.38425301303455 | 4909.954217328764 | 105 | 10.53805915801342
152 | 2035-10-01 00:00:00 | 140.8531287664962 | 3.301710256619073 | 4913.255927585383 | 106 | 10.28103332489114
153 | 2036-01-01 00:00:00 | 140.8531287664962 | 3.22118073816495 | 4916.477108323547 | 107 | 10.03027641452794
154 | 2036-04-01 00:00:00 | 142.2616600541612 | 3.174041507850341 | 4919.651149831398 | 108 | 9.88349188163241
155 | 2036-07-01 00:00:00 | 142.2616600541612 | 3.096625861317406 | 4922.747775692715 | 109 | 9.642431104031619
156 | 2036-10-01 00:00:00 | 142.2616600541612 | 3.021098401285275 | 4925.768874094 | 110 | 9.407249857591825
157 | 2037-01-01 00:00:00 | 142.2616600541612 | 2.947413074424658 | 4928.716287168425 | 111 | 9.177804739113974
158 | 2037-04-01 00:00:00 | 142.2616600541612 | 2.875524950658203 | 4931.591812119083 | 112 | 8.953955843038024
159 | 2037-07-01 00:00:00 | 142.2616600541612 | 2.8053901957641 | 4934.397202314847 | 113 | 8.73556667613466
160 | 2037-10-01 00:00:00 | 142.2616600541612 | 2.736966044647903 | 4937.134168359495 | 114 | 8.522504074277716
161 | 2038-01-01 00:00:00 | 142.2616600541612 | 2.670210775266247 | 4939.804379134761 | 115 | 8.314638121246551
162 | 2038-04-01 00:00:00 | 142.2616600541612 | 2.605083683186582 | 4942.409462817947 | 116 | 8.111842069508832
163 | 2038-07-01 00:00:00 | 142.2616600541612 | 2.541545056767398 | 4944.951007874714 | 117 | 7.913992262935446
164 | 2038-10-01 00:00:00 | 142.2616600541612 | 2.479556152943803 | 4947.430564027658 | 118 | 7.720968061400436
165 | 2039-01-01 00:00:00 | 142.2616600541612 | 2.41907917360371 | 4949.849643201262 | 119 | 7.532651767219939
166 | 2039-04-01 00:00:00 | 143.6842766547028 | 2.383678014965607 | 4952.233321216228 | 120 | 7.422417838919158
167 | 2039-07-01 00:00:00 | 143.6842766547028 | 2.325539526795714 | 4954.558860743024 | 121 | 7.241383257482106
168 | 2039-10-01 00:00:00 | 143.6842766547028 | 2.268819050532405 | 4956.827679793556 | 122 | 7.064764153641079
169 | 2040-01-01 00:00:00 | 143.6842766547028 | 2.213482000519419 | 4959.041161794075 | 123 | 6.892452832820567
170 | 2040-04-01 00:00:00 | 143.6842766547028 | 2.159494634653092 | 4961.200656428729 | 124 | 6.724344227142017
171 | 2040-07-01 00:00:00 | 143.6842766547028 | 2.106824033807894 | 4963.307480462537 | 125 | 6.560335831358063
172 | 2040-10-01 00:00:00 | 143.6842766547028 | 2.0554380817638 | 4965.362918544301 | 126 | 6.400327640349332
173 | 2041-01-01 00:00:00 | 143.6842766547028 | 2.00530544562322 | 4967.368223989924 | 127 | 6.244222088145688
174 | 2041-04-01 00:00:00 | 143.6842766547028 | 1.95639555670558 | 4969.324619546629 | 128 | 6.091923988434819
175 | 2041-07-01 00:00:00 | 143.6842766547028 | 1.908678591907883 | 4971.233298138537 | 129 | 5.943340476521775
176 | 2041-10-01 00:00:00 | 143.6842766547028 | 1.862125455519886 | 4973.095423594057 | 130 | 5.798380952704171
177 | 2042-01-01 00:00:00 | 145.1211194212498 | 1.834874839097643 | 4974.930298433154 | 131 | 5.713526597298744
178 | 2042-04-01 00:00:00 | 145.1211194212498 | 1.790121794241603 | 4976.720420227396 | 132 | 5.574172290047555
179 | 2042-07-01 00:00:00 | 145.1211194212498 | 1.746460287064979 | 4978.466880514461 | 133 | 5.438216868339079
180 | 2042-10-01 00:00:00 | 145.1211194212498 | 1.703863694697541 | 4980.170744209158 | 134 | 5.305577432525931
181 | 2043-01-01 00:00:00 | 145.1211194212498 | 1.662306043607357 | 4981.833050252766 | 135 | 5.176173104903347
182 | 2043-04-01 00:00:00 | 145.1211194212498 | 1.621761993763275 | 4983.454812246529 | 136 | 5.049924980393509
183 | 2043-07-01 00:00:00 | 145.1211194212498 | 1.582206823183683 | 4985.037019069713 | 137 | 4.926756078432694
184 | 2043-10-01 00:00:00 | 145.1211194212498 | 1.54361641286213 | 4986.580635482575 | 138 | 4.806591296031896
185 | 2044-01-01 00:00:00 | 145.1211194212498 | 1.505967232060615 | 4988.086602714636 | 139 | 4.689357361982338
186 | 2044-04-01 00:00:00 | 145.1211194212498 | 1.469236323961575 | 4989.555839038598 | 140 | 4.574982792177891
187 | 2044-07-01 00:00:00 | 145.1211194212498 | 1.43340129166983 | 4990.989240330267 | 141 | 4.463397846027211
188 | 2044-10-01 00:00:00 | 145.1211194212498 | 1.398440284555932 | 4992.387680614824 | 142 | 4.354534483928986
189 | 2045-01-01 00:00:00 | 146.5723306154623 | 1.377975304781942 | 4993.765655919606 | 143 | 4.290809589042221
190 | 2045-04-01 00:00:00 | 146.5723306154623 | 1.344366151006773 | 4995.110022070612 | 144 | 4.186155696626557
191 | 2045-07-01 00:00:00 | 146.5723306154623 | 1.311576732689534 | 4996.421598803302 | 145 | 4.084054338172251
192 | 2045-10-01 00:00:00 | 146.5723306154623 | 1.279587056282473 | 4997.701185859584 | 146 | 3.984443256753416
193 | 2046-01-01 00:00:00 | 146.5723306154623 | 1.24837761588534 | 4998.949563475469 | 147 | 3.887261713905771
194 | 2046-04-01 00:00:00 | 146.5723306154623 | 1.217929381351551 | 5000.167492856821 | 148 | 3.792450452590997
195 | 2046-07-01 00:00:00 | 146.5723306154623 | 1.18822378668444 | 5001.355716643506 | 149 | 3.699951661064388
196 | 2046-10-01 00:00:00 | 146.5723306154623 | 1.159242718716527 | 5002.514959362222 | 150 | 3.609708937623793
197 | 2047-01-01 00:00:00 | 146.5723306154623 | 1.130968506064904 | 5003.645927868287 | 151 | 3.521667256218334
198 | 2047-04-01 00:00:00 | 146.5723306154623 | 1.103383908356004 | 5004.749311776643 | 152 | 3.435772932895937
199 | 2047-07-01 00:00:00 | 146.5723306154623 | 1.076472105713175 | 5005.825783882356 | 153 | 3.351973593069206
200 | 2047-10-01 00:00:00 | 146.5723306154623 | 1.050216688500659 | 5006.876000570856 | 154 | 3.270218139579714
Maturity | 2048-01-01 00:00:00 | 0 |  |  |  | 0
 | Grand Total Paid | 26991.56371271927 | 5006.876000570856 | 5006.876000570856 |  | 5345.874901313985