|
<br />
<br /> CITY OF NEW BRIGHTON
<br /> Transoma NW Quad - East - Area D) - PHASE 2
<br /> CASH FLOW AND PRESENT VALUE ANALYSIS
<br /> ANNUAL --------------a r- ____ti_ _ SEMI - ANNUAL y
<br /> a b c d e h i
<br /> _ Original Estimated Captured Estimated Less: Available Cumulative r------ Present Value -----_,T
<br /> Tax Tax Tax Tax Admin Tax Avail. Tax Semi Annual Cumulative
<br /> Date Capacity Capacity Capacity Increment Fees Increment Increment Balance Balance
<br /> sae assumptions (c) - (b) (d) x (e x (e) - Total of ) P.V. of Total of f
<br /> Inflation 2.511/6 (prev. ear) 1.0917 10.00% 6.00% 12/01108
<br /> 1 06/01/07 10,350 0 0 0 0 0 0
<br /> 12/Q1/07 -10,350 0 0 0 0 0 0
<br /> 2 06/01/08 10,350 10,350 0 0 0 0 0 0
<br /> 12/01/08 10,350 10 350 0 0 0 0 0 0-
<br /> 3 06/01/09 10 350 10 609 0 0 0 0 0 0 0
<br /> 12/01/09 10,350 10,609 0 0 0 0 0 0 0
<br /> 4 06/01/10 10,350 10 874 259 141 (14 127 127 116 116
<br /> 12/01/10 10,350 10,874 259 141 14 127 254 113 229
<br /> 5 06/01/11 10,350 11,146 524 286 29 257 512 222 451
<br /> _ 12/01/11 10,350 11,146 524 286 (29) 257 769 216 667
<br /> 6 06/01/12 10 350 11,424 796 434 TI43 391 1 160 318 985
<br /> 12/01/12 10,350 11424 796 434 43 391 1,551 mm 309 1,293
<br /> 7 06/01/13 10,350 11,710 1,074 586 59 528 2,079 405 1,698
<br /> 12/01/13 10,350 11,710 1,074 586 59 528 2,607 393 2,091
<br /> 8 06/01/14 10,350 12,003 1,360 742 74 668 3,275 483 2,573
<br /> -12/01/14 10,350 12,003 1,360 742 74) 668 3,943 469 3,042
<br /> 9 06/01/15 10,350 158,424 1,653 902 90 812 4,755 553 3,595
<br /> 12/01/15 10,350 158 424 1,653 902 90 812 5,567 537 4,132
<br /> 10 06/01/16 10,350 162,385 148,074 80,826 (8,083) 72 744 78,311 46,691 50 823
<br /> 12/01/16 10,350 162,385 148,b74 80,825 (8,083) 72 744 151,054 45,331 96,155
<br /> 11 06/01/17 10,350 16-6-1444 152,035 8-2-,-98-8- (8,299) 74,689 225,744 45,188 141,343
<br /> 12/01/17 10,350 166,444 152,035 82,988 8,299 74,689 300,433 43,872 186,215
<br /> 12 06/01118 10,350 170,606 156,094 85,204 8 520 76,684 377 117 43 732 228,947
<br /> 12/01/18 10,350 170,606 156,094 85,204 (8,520) 76,684 453,801 42,458 271,405
<br /> 13 06/01/19 10,350 174,871 160,256 87,476 8,748 78,728 532,529 42,320 313,725
<br /> 12/01/19 10,350 174,871 160,256 _ 87,476 (8,748) 78,728 611,257 41,088 354,812
<br /> 14 06/01/20 10,350 179,243 164,521 J 89,804 8,980 80,823 692,080 40,952 395,765
<br /> 12/01/20 10,350 179,243 164,521 89,804 8,98080,823 772,903 39,760 435,525
<br /> 15 06/01121 10350 183.724 168,893 92,190 (9,219 82,971 855,874 3.9,6 27 475,152
<br /> 12101/21 10,350 183 724 168,893 92,190 9,219 82,971 938,845 38,473 513,625
<br /> 16 06/01/22 10,350 188,317 173,374 94,636 9,464 85,172 1,024 018 38,344 551,969
<br /> 12/01/22 10,350 188,317 173,374 94,636 (9,464) 85,172 1,109,190 37,227 589,196
<br /> 17 06/01/23 10,350 193,025 177,967 97,143 9,714 87 429 1,196,619 37,100 626,296
<br /> 12101/23 10,350 193,025 177,967 97,143 9,714 871429 1,284 048 36,020 662,315
<br /> 18 06/01/24 10,350 197,850 182,675 99,713 9,971 89,742 1,373 789 35,895 698,211
<br /> 12/01/24 10,350 197 850 182,675 99 713 9 971 89,742 1,463,531 34,850 733,061
<br /> 19 06/01/25 10,350 202,796 187,500 102,347 10,235 92,112 1,555,643 34,729 767,790
<br /> 12/01/25 10,350 202,796 187,500 102 347 10,235 92,112 1,647,755 33,717 801,507
<br /> 20 06/01/26 10,350 207,866 192,446 10-5-047 10,505 94 542 1,742,298 33,599 835 106
<br /> 12101/26 10,350 207,866 192,446 105,047 (10,505) 94,542 1,836,840 32,620 867,726
<br /> 21 06/01/27 10,350 213,063 197,516 107,814 (10,781) 97 033 1,933,873 32,504 900,230
<br /> 12/01/27 -10,350 213 063 197,516 107,814 (10,781) 97,033 21030,906 31,558 931,788
<br /> 22 06/01128 10,350 216,390 202,713 110,651 (11,065) 99,586 2,130,491 31,445 963,232
<br /> 12/01/28 10,350 218,390 202,713 110 651 (11,065) 99,586 2,230,077 30 529 993,761
<br /> 23 06/01/29 10,350 223,849 208,040 113,558 (11,356) 102,203 2,332,280 30,418 1,024,179
<br /> 12/01/29 10,350 223,849 208,040 113,558 11,356 102f203 2,434,482 29,532 1,053,712
<br /> 24 06/01/30 10,350 229 446 213,499 116,539 11,654 104,885 2,539,367 29,425 1,083 136
<br /> 12/01/30 10,35D 229,446 213,499 116,539 11,654) 104,885 2,644,252 28,568 1,111,704
<br /> 25 06/01/31 10,350 235 182 219,096 119,593 11,959 107,634 2,751 886 28,463 1,140 167
<br /> 12/01/31 10,350 235,182 219,096 119,593 (11,959) 107,634 2,859,520 27,634 1,167 800
<br /> 26 06/01/32 10-13-5-0- 241,,061 224,832 122,724 12,272 110,452 2,969 972 27,531 1,195,331
<br /> . 12/01/32 10,350 241,061 224,832 122,724 (12,272)1 110,452 3 080,424 26,729 1,222,061
<br /> - - - -
<br /> 3,422 693 342,269) 3,080,424 3,080,424 1 222,06 ]TL,_22_,~61
<br /> Transoma 2007b - Area D.xls Prepared by Krass Monroe, P.A. 7120/2007
<br />
|