Spreadsheet: 177394d1346296347-program-a-loop-to-calculate-present-value-of-a-lease-present-value-future-pmts-evaluation-index-cpi
Sheet: Example Sheet

Lease Data |  | 2012-07-31 00:00:00 |  | CPI Data
Account | 1 |  |  | Dates | CPI Index | Average Computed
Dated | 1980-02-22 00:00:00 |  |  | 1980-02-22 00:00:00 | 78.9 | 1
Next CPI Date | 2010-02-22 00:00:00
Last CPI Date | 2007-02-22 00:00:00 |  |  | 2007-02-22 00:00:00 | 203.499 | 124.599 | 2.579201520912547
Initial [NAME] | 42.5 |  |  | Total Rise In CPI | 124.599 | 123.599
Current Qtrly Lease | 130.45 | Actual Current Lease |  | % Rise In CPI | 1.579201520912547 | 123.599
Calculated CPI [NAME] (Triennial) | 0.1073322222222222 |  |  | Average Annual CPI % | 0.05848894521898323 | 0.0357774074074074
Owner | [NAME] |  |  | Computed Current Lease | 109.6160646387833
 |  |  |  | Years Elapsed Last CPI/Lease date | 5 | 27
Present Value - Lease Date (Disc 10%) | 2359.992311392233 |  |  |  |  | Color Grid
Present Value - Remainder (Disc 10%) | 5329.860318228541 |  |  |  |  | OK TO Enter
Lot Type | Normal |  |  |  |  | Computed Cell
In House Appraisal | 4100 |  |  |  |  | Text Header
 |  | Discount Rate | 0.1
Rental Period | Rent Date | Rent | Present Val | Cumulative PV | Remaining Pmts | Remaining PV
1 | 1980-02-22 00:00:00 | 18.16438356164383 | 18.16438356164383 | 18.16438356164383 | 0 | 0
2 | 1980-04-01 00:00:00 | 42.5 | 40.45211183819156 | 58.61649539983539 | 0 | 0
3 | 1980-07-01 00:00:00 | 42.5 | 39.46547496408932 | 98.08197036392471 | 0 | 0 |  | Base Period:  1982-84=100
4 | 1980-10-01 00:00:00 | 42.5 | 38.50290240398959 | 136.5848727679143 | 0 | 0
5 | 1981-01-01 00:00:00 | 42.5 | 37.56380722340447 | 174.1486799913188 | 0 | 0 |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Annual | Percent | Percent
6 | 1981-04-01 00:00:00 | 42.5 | 36.64761680332145 | 210.7962967946402 | 0 | 0 |  | 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 | 0.01249999999999996
7 | 1981-07-01 00:00:00 | 42.5 | 35.75377249104531 | 246.5500692856855 | 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 | 0.03086419753086411
8 | 1981-10-01 00:00:00 | 42.5 | 34.88172925955641 | 281.4317985452419 | 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 | 0.04191616766467066
9 | 1982-01-01 00:00:00 | 42.5 | 34.03095537517699 | 315.4627539204189 | 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 | 0.05459770114942541
10 | 1982-04-01 00:00:00 | 42.5 | 33.2009320733434 | 348.6636859937623 | 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 | 0.05722070844686633
11 | 1982-07-01 00:00:00 | 42.5 | 32.39115324228624 | 381.0548392360485 | 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 | 0.04381443298969079
12 | 1982-10-01 00:00:00 | 42.5 | 31.60112511442561 | 412.6559643504741 | 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 | 0.03209876543209877
13 | 1983-01-01 00:00:00 | 42.5 | 30.83036596529328 | 443.4863303157674 | 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 | 0.06220095693779903
14 | 1983-04-01 00:00:00 | 47.06161944444445 | 33.3067879573391 | 476.7931182731065 | 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 | 0.1103603603603602
15 | 1983-07-01 00:00:00 | 47.06161944444445 | 32.49442727545278 | 509.2875455485593 | 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 | 0.09127789046653145
16 | 1983-10-01 00:00:00 | 47.06161944444445 | 31.70188026873442 | 540.9894258172936 | 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 | 0.05762081784386619
17 | 1984-01-01 00:00:00 | 47.06161944444445 | 30.92866367681407 | 571.9180894941077 | 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 | 0.06502636203866441
18 | 1984-04-01 00:00:00 | 47.06161944444445 | 30.17430602616007 | 602.0923955202677 | 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 | 0.07590759075907583
19 | 1984-07-01 00:00:00 | 47.06161944444445 | 29.43834734259519 | 631.5307428628629 | 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 | 0.1134969325153372
20 | 1984-10-01 00:00:00 | 47.06161944444445 | 28.72033887082457 | 660.2510817336874 | 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 | 0.1349862258953169 | 0.03515305739735034 | 0.105459172192051
21 | 1985-01-01 00:00:00 | 47.06161944444445 | 28.01984280080447 | 688.2709245344919 | 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 | 0.1031553398058251
22 | 1985-04-01 00:00:00 | 47.06161944444445 | 27.33643200078485 | 715.6073565352767 | 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 | 0.06160616061606161
23 | 1985-07-01 00:00:00 | 47.06161944444445 | 26.66968975686327 | 742.27704629214 | 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 | 0.03212435233160615
24 | 1985-10-01 00:00:00 | 47.06161944444445 | 26.01920951889099 | 768.296255811031 | 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 | 0.0431726907630523
25 | 1986-01-01 00:00:00 | 52.11284764079321 | 28.10917960684796 | 796.405435417879 | 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 | 0.03561116458132818
26 | 1986-04-01 00:00:00 | 52.11284764079321 | 27.42358986033948 | 823.8290252782184 | 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 | 0.01858736059479549
27 | 1986-07-01 00:00:00 | 52.11284764079321 | 26.75472181496535 | 850.5837470931838 | 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 | 0.03649635036496357
28 | 1986-10-01 00:00:00 | 52.11284764079321 | 26.10216762435644 | 876.6859147175402 | 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 | 0.04137323943661975
29 | 1987-01-01 00:00:00 | 52.11284764079321 | 25.46552938961603 | 902.1514441071562 | 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 | 0.04818258664412522
30 | 1987-04-01 00:00:00 | 52.11284764079321 | 24.84441891669858 | 926.9958630238548 | 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 | 0.05403225806451606
31 | 1987-07-01 00:00:00 | 52.11284764079321 | 24.23845747970592 | 951.2343205035608 | 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 | 0.0420811017597551
32 | 1987-10-01 00:00:00 | 52.11284764079321 | 23.647275589957 | 974.8815960935177 | 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 | 0.03010279001468441
33 | 1988-01-01 00:00:00 | 52.11284764079321 | 23.07051277068976 | 997.9521088642075 | 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 | 0.02993585174625801
34 | 1988-04-01 00:00:00 | 52.11284764079321 | 22.5078173372583 | 1020.459926201466 | 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 | 0.02560553633217988
35 | 1988-07-01 00:00:00 | 52.11284764079321 | 21.95884618269103 | 1042.418772384157 | 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 | 0.02834008097166008
36 | 1988-10-01 00:00:00 | 52.11284764079321 | 21.42326456847905 | 1063.842036952636 | 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 | 0.02952755905511806
37 | 1989-01-01 00:00:00 | 57.70623538440764 | 23.14406942621318 | 1086.986106378849 | 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 | 0.02294455066921608
38 | 1989-04-01 00:00:00 | 57.70623538440764 | 22.57957992801286 | 1109.565686306862 | 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 | 0.01557632398753883
39 | 1989-07-01 00:00:00 | 57.70623538440764 | 22.02885846635401 | 1131.594544773216 | 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 | 0.02208588957055202
40 | 1989-10-01 00:00:00 | 57.70623538440764 | 21.49156923546733 | 1153.086114008683 | 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 | 0.03361344537815114
41 | 1990-01-01 00:00:00 | 57.70623538440764 | 20.96738461996813 | 1174.053498628651 | 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 | 0.02845528455284563
42 | 1990-04-01 00:00:00 | 57.70623538440764 | 20.45598499509085 | 1194.509483623742 | 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 | 0.01581027667984203
43 | 1990-07-01 00:00:00 | 57.70623538440764 | 19.95705853179596 | 1214.466542155538 | 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 | 0.0227904391328515
44 | 1990-10-01 00:00:00 | 57.70623538440764 | 19.47030100663021 | 1233.936843162169 | 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 | 0.02663043478260874
45 | 1991-01-01 00:00:00 | 57.70623538440764 | 18.99541561622459 | 1252.932258778393 | 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 | 0.03388035997882488
46 | 1991-04-01 00:00:00 | 57.70623538440764 | 18.53211279631667 | 1271.46437157471 | 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 | 0.032258064516129
47 | 1991-07-01 00:00:00 | 57.70623538440764 | 18.080110045187 | 1289.544481619897 | 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 | 0.0284821428571429
48 | 1991-10-01 00:00:00 | 57.70623538440764 | 17.63913175140195 | 1307.183613371299 | 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 | 0.03839550115268486
49 | 1992-01-01 00:00:00 | 63.89997386429474 | 19.05597947351267 | 1326.239592844811 | 0 | 0 |  | 2009 | 211.143 | 212.193 | 212.709 | 213.24 | 213.82 | 214 |  |  |  |  |  |  |  | 0.04531524476393412 | 0.04569177317143033
50 | 1992-04-01 00:00:00 | 63.89997386429474 | 18.59119948635382 | 1344.830792331165 | 0 | 0
51 | 1992-07-01 00:00:00 | 63.89997386429474 | 18.13775559644275 | 1362.968547927608 | 0 | 0 |  |  |  | 1.518377693282636
52 | 1992-10-01 00:00:00 | 63.89997386429474 | 17.69537131360268 | 1380.663919241211 | 0 | 0
53 | 1993-01-01 00:00:00 | 63.89997386429474 | 17.26377689131969 | 1397.92769613253 | 0 | 0
54 | 1993-04-01 00:00:00 | 63.89997386429474 | 16.84270916226312 | 1414.770405294793 | 0 | 0
55 | 1993-07-01 00:00:00 | 63.89997386429474 | 16.43191137781767 | 1431.202316672611 | 0 | 0
56 | 1993-10-01 00:00:00 | 63.89997386429474 | 16.03113305152944 | 1447.23344972414 | 0 | 0
57 | 1994-01-01 00:00:00 | 63.89997386429474 | 15.64012980637019 | 1462.873579530511 | 0 | 0
58 | 1994-04-01 00:00:00 | 63.89997386429474 | 15.25866322572701 | 1478.132242756238 | 0 | 0
59 | 1994-07-01 00:00:00 | 63.89997386429474 | 14.88650070802636 | 1493.018743464264 | 0 | 0
60 | 1994-10-01 00:00:00 | 70.75850005909142 | 16.08224576598196 | 1509.100989230246 | 0 | 0
61 | 1995-01-01 00:00:00 | 70.75850005909142 | 15.68999586925069 | 1524.790985099497 | 0 | 0
62 | 1995-04-01 00:00:00 | 70.75850005909142 | 15.30731304317141 | 1540.098298142668 | 0 | 0
63 | 1995-07-01 00:00:00 | 70.75850005909142 | 14.93396394455747 | 1555.032262087226 | 0 | 0
64 | 1995-10-01 00:00:00 | 70.75850005909142 | 14.56972092151948 | 1569.601983008745 | 0 | 0
65 | 1996-01-01 00:00:00 | 70.75850005909142 | 14.21436187465316 | 1583.816344883398 | 0 | 0
66 | 1996-04-01 00:00:00 | 70.75850005909142 | 13.86767012161284 | 1597.684015005011 | 0 | 0
67 | 1996-07-01 00:00:00 | 70.75850005909142 | 13.52943426498813 | 1611.21344927 | 0 | 0
68 | 1996-10-01 00:00:00 | 70.75850005909142 | 13.19944806340306 | 1624.412897333402 | 0 | 0
69 | 1997-01-01 00:00:00 | 70.75850005909142 | 12.87751030575908 | 1637.290407639162 | 0 | 0
70 | 1997-04-01 00:00:00 | 70.75850005909142 | 12.56342468854545 | 1649.853832327707 | 0 | 0
71 | 1997-07-01 00:00:00 | 70.75850005909142 | 12.2569996961419 | 1662.110832023849 | 0 | 0
72 | 1997-10-01 00:00:00 | 78.35316711154493 | 13.24153240127406 | 1675.352364425123 | 0 | 0
73 | 1998-01-01 00:00:00 | 78.35316711154493 | 12.91856819636494 | 1688.270932621488 | 0 | 0
74 | 1998-04-01 00:00:00 | 78.35316711154493 | 12.60348116718531 | 1700.874413788673 | 0 | 0
75 | 1998-07-01 00:00:00 | 78.35316711154493 | 12.29607918749786 | 1713.170492976171 | 0 | 0
76 | 1998-10-01 00:00:00 | 78.35316711154493 | 11.99617481707108 | 1725.166667793242 | 0 | 0
77 | 1999-01-01 00:00:00 | 78.35316711154493 | 11.70358518738642 | 1736.870252980628 | 0 | 0
78 | 1999-04-01 00:00:00 | 78.35316711154493 | 11.4181318901331 | 1748.288384870762 | 0 | 0
79 | 1999-07-01 00:00:00 | 78.35316711154493 | 11.13964086842253 | 1759.428025739184 | 0 | 0
80 | 1999-10-01 00:00:00 | 78.35316711154493 | 10.86794231065613 | 1770.29596804984 | 0 | 0
81 | 2000-01-01 00:00:00 | 78.35316711154493 | 10.60287054698159 | 1780.898838596822 | 0 | 0
82 | 2000-04-01 00:00:00 | 78.35316711154493 | 10.34426394827472 | 1791.243102545097 | 0 | 0
83 | 2000-07-01 00:00:00 | 78.35316711154493 | 10.0919648275851 | 1801.335067372682 | 0 | 0
84 | 2000-10-01 00:00:00 | 86.76298665577619 | 10.90259301377396 | 1812.237660386456 | 0 | 0
85 | 2001-01-01 00:00:00 | 86.76298665577619 | 10.63667611099899 | 1822.874336497455 | 0 | 0
86 | 2001-04-01 00:00:00 | 86.76298665577619 | 10.37724498634048 | 1833.251581483795 | 0 | 0
87 | 2001-07-01 00:00:00 | 86.76298665577619 | 10.12414145008827 | 1843.375722933883 | 0 | 0
88 | 2001-10-01 00:00:00 | 86.76298665577619 | 9.877211170817827 | 1853.252934104701 | 0 | 0
89 | 2002-01-01 00:00:00 | 86.76298665577619 | 9.636303581285686 | 1862.889237685987 | 0 | 0
90 | 2002-04-01 00:00:00 | 86.76298665577619 | 9.401271786620182 | 1872.290509472607 | 0 | 0
91 | 2002-07-01 00:00:00 | 86.76298665577619 | 9.171972474751396 | 1881.462481947358 | 0 | 0
92 | 2002-10-01 00:00:00 | 86.76298665577619 | 8.948265829025754 | 1890.410747776384 | 0 | 0
93 | 2003-01-01 00:00:00 | 86.76298665577619 | 8.730015442951954 | 1899.140763219336 | 0 | 0
94 | 2003-04-01 00:00:00 | 86.76298665577619 | 8.517088237026298 | 1907.657851456362 | 0 | 0
95 | 2003-07-01 00:00:00 | 96.07545082017766 | 9.201215848164955 | 1916.859067304527 | 0 | 0
96 | 2003-10-01 00:00:00 | 96.07545082017766 | 8.976795949429224 | 1925.835863253956 | 0 | 0
97 | 2004-01-01 00:00:00 | 96.07545082017766 | 8.75784970676022 | 1934.593712960717 | 0 | 0
98 | 2004-04-01 00:00:00 | 96.07545082017766 | 8.544243616351435 | 1943.137956577068 | 0 | 0
99 | 2004-07-01 00:00:00 | 96.07545082017766 | 8.335847430586767 | 1951.473804007655 | 0 | 0
100 | 2004-10-01 00:00:00 | 96.07545082017766 | 8.132534078621235 | 1959.606338086276 | 0 | 0
101 | 2005-01-01 00:00:00 | 96.07545082017766 | 7.934179588898767 | 1967.540517675175 | 0 | 0
102 | 2005-04-01 00:00:00 | 96.07545082017766 | 7.740663013559775 | 1975.281180688735 | 0 | 0
103 | 2005-07-01 00:00:00 | 96.07545082017766 | 7.551866354692462 | 1982.833047043427 | 0 | 0
104 | 2005-10-01 00:00:00 | 96.07545082017766 | 7.367674492382891 | 1990.20072153581 | 0 | 0
105 | 2006-01-01 00:00:00 | 96.07545082017766 | 7.187975114519894 | 1997.38869665033 | 0 | 0
106 | 2006-04-01 00:00:00 | 96.07545082017766 | 7.012658648312091 | 2004.401355298642 | 0 | 0
107 | 2006-07-01 00:00:00 | 106.3874424577092 | 7.575944277776891 | 2011.977299576419 | 0 | 0
108 | 2006-10-01 00:00:00 | 106.3874424577092 | 7.391165149050627 | 2019.36846472547 | 0 | 0
109 | 2007-01-01 00:00:00 | 106.3874424577092 | 7.210892828342073 | 2026.579357553812 | 0 | 0
110 | 2007-04-01 00:00:00 | 106.3874424577092 | 7.035017393504464 | 2033.614374947316 | 0 | 0
111 | 2007-07-01 00:00:00 | 106.3874424577092 | 6.863431603418988 | 2040.477806550735 | 0 | 0
112 | 2007-10-01 00:00:00 | 106.3874424577092 | 6.696030832603892 | 2047.173837383339 | 0 | 0
113 | 2008-01-01 00:00:00 | 106.3874424577092 | 6.532713007418432 | 2053.706550390757 | 0 | 0
114 | 2008-04-01 00:00:00 | 106.3874424577092 | 6.37337854382286 | 2060.07992893458 | 0 | 0
115 | 2008-07-01 00:00:00 | 106.3874424577092 | 6.217930286656448 | 2066.297859221237 | 0 | 0
116 | 2008-10-01 00:00:00 | 106.3874424577092 | 6.066273450396536 | 2072.364132671634 | 0 | 0
117 | 2009-01-01 00:00:00 | 106.3874424577092 | 5.918315561362474 | 2078.282448232996 | 0 | 0
118 | 2009-04-01 00:00:00 | 106.3874424577092 | 5.773966401329244 | 2084.056414634325 | 0 | 0
119 | 2009-07-01 00:00:00 | 117.8062430732339 | 6.237755167044253 | 2090.29416980137 | 0 | 0
120 | 2009-10-01 00:00:00 | 117.8062430732339 | 6.085614797116344 | 2096.379784598486 | 0 | 0
121 | 2010-01-01 00:00:00 | 117.8062430732339 | 5.937185167918384 | 2102.316969766404 | 0 | 0
122 | 2010-04-01 00:00:00 | 117.8062430732339 | 5.792375773578913 | 2108.109345539983 | 0 | 0
123 | 2010-07-01 00:00:00 | 117.8062430732339 | 5.651098315686745 | 2113.76044385567 | 0 | 0
124 | 2010-10-01 00:00:00 | 117.8062430732339 | 5.513266649450483 | 2119.273710505121 | 0 | 0
125 | 2011-01-01 00:00:00 | 117.8062430732339 | 5.378796731171201 | 2124.652507236292 | 0 | 0
126 | 2011-04-01 00:00:00 | 117.8062430732339 | 5.247606566996295 | 2129.900113803288 | 0 | 0
127 | 2011-07-01 00:00:00 | 117.8062430732339 | 5.119616162923214 | 2135.019729966211 | 0 | 0
128 | 2011-10-01 00:00:00 | 117.8062430732339 | 4.994747476022649 | 2140.014477442234 | 0 | 0
129 | 2012-01-01 00:00:00 | 117.8062430732339 | 4.872924366851366 | 2144.887401809085 | 0 | 0
130 | 2012-04-01 00:00:00 | 130.4506489339353 | 5.264337724747646 | 2150.151739533833 | 0 | 0
131 | 2012-07-01 00:00:00 | 130.4506489339353 | 5.13593924365624 | 2155.287678777489 | 0 | 130.4506489339353
132 | 2012-10-01 00:00:00 | 130.4506489339353 | 5.010672432835356 | 2160.298351210324 | 1 | 127.2689257892052
133 | 2013-01-01 00:00:00 | 130.4506489339353 | 4.888460910083276 | 2165.186812120407 | 2 | 124.1648056480051
134 | 2013-04-01 00:00:00 | 130.4506489339353 | 4.769230156178806 | 2169.956042276586 | 3 | 121.1363957541513
135 | 2013-07-01 00:00:00 | 130.4506489339353 | 4.652907469442737 | 2174.608949746029 | 4 | 118.1818495162452
136 | 2013-10-01 00:00:00 | 130.4506489339353 | 4.539421921407548 | 2179.148371667437 | 5 | 115.2993653817026
137 | 2014-01-01 00:00:00 | 130.4506489339353 | 4.428704313568342 | 2183.577075981005 | 6 | 112.4871857382465
138 | 2014-04-01 00:00:00 | 130.4506489339353 | 4.320687135188625 | 2187.897763116193 | 7 | 109.7435958421917
139 | 2014-07-01 00:00:00 | 130.4506489339353 | 4.215304522135245 | 2192.113067638329 | 8 | 107.0669227728699
140 | 2014-10-01 00:00:00 | 130.4506489339353 | 4.112492216717312 | 2196.225559855046 | 9 | 104.4555344125561
141 | 2015-01-01 00:00:00 | 130.4506489339353 | 4.012187528504694 | 2200.237747383551 | 10 | 101.9078384512742
142 | 2015-04-01 00:00:00 | 144.4522069743456 | 4.334462957962331 | 2204.572210341513 | 11 | 110.0934958186465
143 | 2015-07-01 00:00:00 | 144.4522069743456 | 4.228744349231542 | 2208.800954690745 | 12 | 107.4082886035576
144 | 2015-10-01 00:00:00 | 144.4522069743456 | 4.125604243152724 | 2212.926558933897 | 13 | 104.7885742473733
145 | 2016-01-01 00:00:00 | 144.4522069743456 | 4.024979749417293 | 2216.951538683315 | 14 | 102.232755363291
146 | 2016-04-01 00:00:00 | 144.4522069743456 | 3.926809511626627 | 2220.878348194941 | 15 | 99.73927352516193
147 | 2016-07-01 00:00:00 | 144.4522069743456 | 3.831033669879636 | 2224.709381864821 | 16 | 97.30660831723115
148 | 2016-10-01 00:00:00 | 144.4522069743456 | 3.737593824272816 | 2228.446975689094 | 17 | 94.9332764070548
149 | 2017-01-01 00:00:00 | 144.4522069743456 | 3.646432999290552 | 2232.093408688384 | 18 | 92.61783064102907
150 | 2017-04-01 00:00:00 | 144.4522069743456 | 3.557495609063954 | 2235.650904297448 | 19 | 90.35885916197958
151 | 2017-07-01 00:00:00 | 144.4522069743456 | 3.470727423477028 | 2239.121631720925 | 20 | 88.15498454827276
152 | 2017-10-01 00:00:00 | 144.4522069743456 | 3.38607553509954 | 2242.507707256025 | 21 | 86.00486297392466
153 | 2018-01-01 00:00:00 | 144.4522069743456 | 3.30348832692638 | 2245.811195582951 | 22 | 83.9071833891948
154 | 2018-04-01 00:00:00 | 159.9565833538065 | 3.568838117210303 | 2249.380033700162 | 23 | 90.64695399294108
155 | 2018-07-01 00:00:00 | 159.9565833538065 | 3.481793285083222 | 2252.861826985245 | 24 | 88.43605267604009
156 | 2018-10-01 00:00:00 | 159.9565833538065 | 3.396871497642168 | 2256.258698482887 | 25 | 86.27907578150253
157 | 2019-01-01 00:00:00 | 159.9565833538065 | 3.314020973309432 | 2259.572719456197 | 26 | 84.17470807951467
158 | 2019-04-01 00:00:00 | 159.9565833538065 | 3.233191193472617 | 2262.805910649669 | 27 | 82.1216664190387
159 | 2019-07-01 00:00:00 | 159.9565833538065 | 3.154332871680601 | 2265.96024352135 | 28 | 80.11869894540362
160 | 2019-10-01 00:00:00 | 159.9565833538065 | 3.077397923590831 | 2269.037641444941 | 29 | 78.16458433697913
161 | 2020-01-01 00:00:00 | 159.9565833538065 | 3.002339437649591 | 2272.03998088259 | 30 | 76.25813106046748
162 | 2020-04-01 00:00:00 | 159.9565833538065 | 2.929111646487407 | 2274.969092529078 | 31 | 74.39817664435849
163 | 2020-07-01 00:00:00 | 159.9565833538065 | 2.857669899012104 | 2277.82676242809 | 32 | 72.58358697010586
164 | 2020-10-01 00:00:00 | 159.9565833538065 | 2.78797063318254 | 2280.614733061273 | 33 | 70.81325558059108
165 | 2021-01-01 00:00:00 | 177.1250789042446 | 3.011911918763238 | 2283.626644980036 | 34 | 76.50126796570352
166 | 2021-04-01 00:00:00 | 177.1250789042446 | 2.93845065245194 | 2286.565095632488 | 35 | 74.63538338117417
167 | 2021-07-01 00:00:00 | 177.1250789042446 | 2.866781124343356 | 2289.431876756832 | 36 | 72.81500817675528
168 | 2021-10-01 00:00:00 | 177.1250789042446 | 2.796859633505714 | 2292.228736390337 | 37 | 71.03903236756614
169 | 2022-01-01 00:00:00 | 177.1250789042446 | 2.728643544883623 | 2294.957379935221 | 38 | 69.30637304152796
170 | 2022-04-01 00:00:00 | 177.1250789042446 | 2.662091263301096 | 2297.619471198522 | 39 | 67.61597369905165
171 | 2022-07-01 00:00:00 | 177.1250789042446 | 2.59716220809863 | 2300.216633406621 | 40 | 65.96680360883089
172 | 2022-10-01 00:00:00 | 177.1250789042446 | 2.533816788388908 | 2302.75045019501 | 41 | 64.3578571793472
173 | 2023-01-01 00:00:00 | 177.1250789042446 | 2.472016378916007 | 2305.222466573926 | 42 | 62.7881533457046
174 | 2023-04-01 00:00:00 | 177.1250789042446 | 2.411723296503423 | 2307.63418987043 | 43 | 61.25673497141912
175 | 2023-07-01 00:00:00 | 177.1250789042446 | 2.352900777076509 | 2309.987090647506 | 44 | 59.76266826479916
176 | 2023-10-01 00:00:00 | 177.1250789042446 | 2.295512953245375 | 2312.282603600751 | 45 | 58.30504220956015
177 | 2024-01-01 00:00:00 | 196.1363072343237 | 2.479898009421559 | 2314.762501610173 | 46 | 62.98834337236362
178 | 2024-04-01 00:00:00 | 196.1363072343237 | 2.419412692118593 | 2317.181914302291 | 47 | 61.45204231450109
179 | 2024-07-01 00:00:00 | 196.1363072343237 | 2.360402626457164 | 2319.542316928748 | 48 | 59.9532120141474
180 | 2024-10-01 00:00:00 | 196.1363072343237 | 2.302831830689917 | 2321.845148759438 | 49 | 58.49093855038772
181 | 2025-01-01 00:00:00 | 196.1363072343237 | 2.24666520067309 | 2324.091813960112 | 50 | 57.06433029306119
182 | 2025-04-01 00:00:00 | 196.1363072343237 | 2.191868488461551 | 2326.283682448573 | 51 | 55.67251735908408
183 | 2025-07-01 00:00:00 | 196.1363072343237 | 2.138408281425904 | 2328.42209073 | 52 | 54.31465108203326
184 | 2025-10-01 00:00:00 | 196.1363072343237 | 2.08625198187893 | 2330.508342711878 | 53 | 52.9899034946666
185 | 2026-01-01 00:00:00 | 196.1363072343237 | 2.035367787198957 | 2332.543710499077 | 54 | 51.69746682406498
186 | 2026-04-01 00:00:00 | 196.1363072343237 | 1.985724670438007 | 2334.529435169516 | 55 | 50.43655299908778
187 | 2026-07-01 00:00:00 | 196.1363072343237 | 1.937292361402934 | 2336.466727530918 | 56 | 49.20639316984175
188 | 2026-10-01 00:00:00 | 196.1363072343237 | 1.890041328197984 | 2338.356768859117 | 57 | 48.00623723887
189 | 2027-01-01 00:00:00 | 217.1880529482441 | 2.04185723321494 | 2340.398626092332 | 58 | 51.86229596316596
190 | 2027-04-01 00:00:00 | 217.1880529482441 | 1.992055837282869 | 2342.390681929614 | 59 | 50.59736191528387
191 | 2027-07-01 00:00:00 | 217.1880529482441 | 1.943469109544262 | 2344.334151039159 | 60 | 49.36327991735012
192 | 2027-10-01 00:00:00 | 217.1880529482441 | 1.896067423945622 | 2346.230218463104 | 61 | 48.15929748034158
193 | 2028-01-01 00:00:00 | 217.1880529482441 | 1.849821877020119 | 2348.080040340124 | 62 | 46.98468046862595
194 | 2028-04-01 00:00:00 | 217.1880529482441 | 1.804704270263531 | 2349.884744610388 | 63 | 45.83871265231797
195 | 2028-07-01 00:00:00 | 217.1880529482441 | 1.76068709294003 | 2351.645431703328 | 64 | 44.72069527055414
196 | 2028-10-01 00:00:00 | 217.1880529482441 | 1.717743505307347 | 2353.363175208635 | 65 | 43.62994660541868
197 | 2029-01-01 00:00:00 | 217.1880529482441 | 1.67584732225107 | 2355.039022530887 | 66 | 42.56580156626212
198 | 2029-04-01 00:00:00 | 217.1880529482441 | 1.634972997318118 | 2356.673995528205 | 67 | 41.52761128415817
199 | 2029-07-01 00:00:00 | 217.1880529482441 | 1.595095607139627 | 2358.269091135344 | 68 | 40.51474271625187
200 | 2029-10-01 00:00:00 | 240.4993293112968 | 1.723220256888612 | 2359.992311392233 | 69 | 43.76905374121833
Maturity | 2030-01-01 00:00:00 | 0 |  |  |  | 0
 | Grand Total Paid | 21702.7883918576 | 2359.992311392233 | 2359.992311392233 |  | 5329.860318228541
CUSTOMER_N | BILLING_NA |  | Original |  | Circle Square | Lot | Lot | Suffix | LESSEE | Type | Original | ORIG LEASE | C.O.L DATE | CURR LEASE | Annual | 13 | Cost Basis | Gain | 0.21 | AT Cash Flow
1 | [NAME] | 1 | 42.5 | 2 | Circle | 1 | 1 |  | [NAME] | Normal | 42.5 | 1980-02-22 00:00:00 | 2010-02-22 00:00:00 | 130.45 | 522 | 6786 | 3150 | 3636 | 763.56 | 6022.440000000001
In House Appraisal | BILLING_NA | Original
1 | [NAME] | 4100