|
<br />
<br /> CITY OF NEW BRIGHTON
<br /> Transoma (NW Quad - East - Area C) - PHASE I
<br /> CASH FLOW AND PRESENT VALUE ANALYSIS
<br /> ANNUAL a--_____------ SEMI - ANNUAL -
<br /> a b c d e h 1
<br /> Original Estimated Captured Estimated Less: Available Cumulative Present Value
<br /> Tax Tax Tax Tax Admin Tax Avail. Tax Semi Annual Cumulative
<br /> Date Capacity Capaci Capacity Increment Fees Increment Increment Balance Balance
<br /> (see assumptions) (c) - (b) d x (e x e - Total of (g) P.V. of Total of (i)
<br /> Inflation rev. ear) 1.0917 10.00% 6.00% 12101108
<br /> 1 06/01/07 28 942 0 0 0 0 0 0
<br /> 12/01/07 28,942 0 0 0 0 0 0
<br /> 2 06/01/08 28,942 28,942 0 0 0 0 0 0
<br /> _ 12/01/08 28,942 28,942 0 0 0 0 0 0
<br /> 3 06/01/09 28,942 216,000 0 0 0 0 0 0 0
<br /> 12/01/09 28,942 216,000 0 0 0 0 0 0 0-
<br /> 4 06/01/10 28,942 221,400 187,058 102,106 R100,211807) 91 895 91,895 84,097 84,097
<br /> 12/01/10 28,942 221,400 187 058 102,106 0 211 91,895 81,648 165 75 06/01/11 28,942 226,935 192 458 105,053 0,505 94,548 278 338 81,558 247,302
<br /> 12/01/11 28,942 226,935 192,458 105,053 0,505 94,548 372,886 79,182 326,485
<br /> 6 06/01/12 28 942 232 608 197,993 108 97 267 470,153 79,087 405,572
<br /> 12/01/12 28,942 232,608 197,993 108,074 10,807 97,267 567,420 76,783 482,355
<br /> 7 06/01/13 28,942 238,424 203,666 111,171 11,117 100,054 667,474 75,683 559,038
<br /> 12/01/13 28,942 238,424 203,666 111,171 (11,117) 100,054 767,528 74,450 633,488
<br /> 8 06/01/14 28,942 244,384 209,482 114,346 11,435 102,911 870,439 74,345 707,833
<br /> 12/01/14 28,942 244,384 209,482 114,346 (11,435) 102,911 973,350 72,180 780,013
<br /> 9 06/01115 28,942 250,494 215,442 117,599 (11,760) 105,839 1 079,189 72,0_L1 852,084
<br /> 12/01/15 28,942 250,494 215 442 117,598 (111,760) 105,839 1,185,029 69,972 922,056
<br /> 10 06101/16 28,942 256,756 221,552 120,934 (12,09 3 108,841 1,293 869 69,861 991,917
<br /> 12/01/16 28,942 __256,756 221,552 120,934 12,093 108,841 1,402,710 67,826 1,059,743
<br /> 11 06/01117 28,942 263,175 227,814 124,352 (12,435) 111,917 1,514,627 67,712 1,127,455
<br /> 12/01/17 28,942 263,175 227,814 124,352 12,435 111,917 1,626,544 6--5,740- 1,193,194
<br /> .12 06/01118 28,942 269 754 234,233 127 856 12,786 115,070 1,741 615 65,623 1,258,817
<br /> 12101/18 28,942 269,754 234,233 127,856 (12,786) 115,070 1,856,685 63,712 1,322,529
<br /> 13 06/01/19 28 942 276 498 240 812 131,447 13,145 118,303 1,974,988 63,594 1,386,122
<br /> 12/01/19 28,942 276,498 240,812 131,447 13,145 118,303 210930,290 61,741 1,447,864
<br /> 14 06/01/20 28,942 283,411 247 556 135,129 13,513 121,616 2,214,906 61,622 1,509,485
<br /> 12/01/20 28,942 283,411 247,556 135,129 (13,513) 121,616 2,336,522 59,827 __1,569 312
<br /> 15 06101/21 28 942 290 496 254469 138,902 13,890 125,012 2,461,533 59,706 1,629,019
<br /> 12/01/21 28,942 290,496 254,469 138,902 13,890 125,012 .....?_586,545 57,967 1,686,986
<br /> 16 06101/22 28,942 297,758 261,554 142,769 14,277 128,492 2,715,037 g 846 1,744,832
<br /> 12/01/22 28,942 297,758 261,554 142,769 (14,277) 128,492 2,843,530 161 1,800,993
<br /> 17 06/01/23 28,942 305,202 268,816 146,733 (14,673) 132,060 2,975,590 039 1,867,032
<br /> 12/01/23 28,942 305,202 268,816 146,733 14,673 132,060 3,107 650 407 1 911 439
<br /> 18 06/01/24 28,942 312,832 276,260 150,797 15,080 135 717 3,243,367 285 1 965 724
<br /> 12/01/24 28 942 312,832 276 260 150 797 15,080 135 717 3 379,084 ,704 2,018 428
<br />
<br /> 19 06/01/25 28,942 320,653 283,890 154,962 15,496 139,465 3,518 549 52,582 2,071,010
<br /> 12/01/25 28,942 320,653 283,890 154,962 (15,496) 139,465 3,658,015 51,051 2,122,061
<br /> 20 06/01/26 28,942 328,670 291,711 159,231 (15,923) 143,308 3,801 322 50,929 2,172,990
<br /> 12/01/26 28,942 328,570 291,711 159,231 15,923 143,308 3,944,630 49,446 2,222,435
<br /> 21 06/01/27 28,942 336,886 299,728 163,606 16,361 147,246 4,091,875 49,325 2,271,760
<br /> 12/01/27 28,942 336 886 299,728 163,606 16,361 147,246 4 239 121 47,888 2,319,648
<br /> 4 390 403 47,768 2,367,416
<br /> 22 06/01/28 28,942 345 308 307,944 168,091 (16,809) 151,282
<br /> 12/01/28 28,942 345,308 307,944 168,091 16,809 151,282 4,541M6 46,377 2,413,793
<br /> 46,257 2,460,050
<br /> 23 06/01/29 28,942 353,941 316,366 172 689 17,269 155,420 4,697,105
<br /> 2,504 960
<br /> 12/01/29 28,942 353,941 316,3 6 172,689 17,269 155,420 4,852,525 441910
<br /> 24 06/01/30 28,942 362,790 324,999 177,401 17,740 159,661 5,012,186 44,792 2,549,752
<br /> 12/01/30 28,942 362,790 W324,999 177,401 17,740 159,661 5,171,847 43,487 2,593,239
<br /> 25 06/01/31 28,942 371,859 333,848 182,231 18,223 164,008 5,335,854 43,370 2,636,609
<br /> 12/01131 28,942 371,859 333,848 182 82,231 18,223 164,008 5,499,862 42,107 2,678,716
<br /> 26 06/01/32 28,942 381,156 342,917 187,181 18,718 168,463 5,668,325 41,991 2,720 707
<br /> 12/01/32 28,942 381,156 342,917 187,181 (18,718) - 168,463 5,836,789 40,768 ___2,761 474
<br /> - -
<br /> 6,485,321 648,532 5,836,789 5,83fi,789 761,47 2,761,474
<br /> Transoma 2007b - Area C.xis Prepared by Krass Monroe, P.A. 712012007
<br />
|