Laserfiche WebLink
City of New Brighton MINIMUM DEVELOPMENT SCENARIO <br /> North West Quadrant <br /> Combined Cash Balances&Projected Cash Flows <br /> Per Audit Actual Actual Projected <br /> 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 <br /> Summary of Pooled TIF(Districts#9,#20,&#26) <br /> Beginning Cash Balance 288,038 158,716 527,241 701,543 637,739 1,104,258 1,733,707 1,278,024 1,464,840 1,648,832 735,922 842,242 136,120 140,782 <br /> Tax increment 1,153,443 1,292,382 1,326,022 1,263,176 1,170,546 1,170,546 1,170,546 1,207,457 1,207,457 1,207,457 1,207,457 1,207,457 817,439 817,439 <br /> MVHC 16,549 17,111 17,111 17,111 17,111 17,111 17,111 17,111 17,111 17,111 17,111 17,111 17,111 17,111 <br /> Investment Earnings(3%of Cash Balance) (1,157) 2,506 5,262 7,005 9,375 21,831 43,025 37,959 43,564 49,083 21,696 24,886 3,566 3,706 <br /> Project Costs (39,132) 0 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Bond Principal (322,462) (368,869) (391,413) (593,824) (674,570) (542,247) (824,526) (58,464) (72,369) (78,662) (92,043) (65,745) 0 0 <br /> Bond Interest (104,485) (100,779) (77,160) (68,485) (55,943) (37,792) (35,965) (17,031) (11,599) (7,785) (5,700) (1,676) 0 0 <br /> Interfund Loan Principal (370,633) (185,810) 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Interfund Loan Interest (22,258) (7,432) 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Administrative Costs (17,811) 23,369 (5,519) (6,484) 0 0 (75,874) (216) (171) (100,115) (42,201) (122,457) (63,455) (83,455) <br /> Transfers Out (487,000) (320,000) (700,000) (693,959) 0 0 (750,000) (1,000,000) (1,000,000) (2,000,000) (1,000,000) (1,770,229) (750,000) (750,000) <br /> Changes in Balance Sheet 65,624 16,047 0 11,656 0 0 0 0 0 0 0 4,532 0 0 <br /> Ending Cash Balance 288,038 168,716 627,241 701,543 637,739 1,104,268 1,733,707 1,278,024 1,464,840 1,648,832 735,922 842,242 136,120 140,782 145,582 <br /> Annual Cash Increase/(Decrease) (129,322) 366,525 174,302 (63,804) 466,519 629,449 (455,683) 186,816 183,993 (912,911) 106,320 (706,121) 4,661 4,801 <br /> Pre-1990 TIF TIF 5-TIF 18(Excluding TIF#9) <br /> Beginning Cash Balance 1,829,854 2,175,565 2,514,247 2,276,015 2,228,585 1,703,350 646,042 627,634 558,320 615,202 <br /> Tax increment 1,845,667 1,709,905 2,011,413 1,714,085 1,201,296 928,190 339,571 318,024 240,608 240,608 <br /> MVHC 14,550 13,466 13,466 13,466 13,466 13,466 13,466 13,466 13,466 13,466 <br /> Investment Earnings(3%of Cash Balance) 21,675 30,956 22,487 22,487 33,239 33,982 16,320 18,783 16,694 18,400 <br /> Other Revenues 297,679 (58,442) 3,749 0 0 (0) 0 0 0 0 <br /> Bond Principal (1,228,894) (1,245,248) (1,312,765) (1,214,782) (893,590) (589,189) (305,000) (180,000) (210,000) 0 <br /> Bond Interest (342,847) (263,379) (189,444) (115,599) (79,280) (56,491) (19,511) (11,010) (3,885) 0 <br /> Interfund Loan Interest (11,870) (4,760) (8,584) (597) 0 0 0 0 0 0 <br /> Administrative Costs (74,260) 5,791 (156,631) (88,382) (52,196) (42,799) (7,828) (7,742) 0 0 <br /> Transfers Out (41,058) 0 (383,662) (363,461) (739,764) (1,333,491) (63,707) (221,163) 0 (885,807) <br /> Changes in Balance Sheet (134.931) 150.393 (238.261) (14,647) (8,406) (10.977) 8,281 328 0 (1,869) <br /> Ending Cash Balance 1,828,864 2,175.565 2,614,247 2,276,015 2,228,686 1,703,350 648,042 627,634 658,320 816,202 0 <br /> Annual Cash Increase!(Decrease) 345,711 338,682 (238,232) (47,430) (525,235) (1,057,308) (18,408) (69,314) 56,883 (615.202) <br /> FUND 460 Municipal Development Fund <br /> Beginning Cash Balance 7,561,759 6,116,153 7,352,666 7,714,705 8,059,307 7,876,763 8,235,469 7,848,789 7,552,032 6,814,586 8,030,340 7,513,402 8,088,842 7,968,879 <br /> Investment Earnings(3%of Cash Balance) 144,457 124,562 220,580 231,441 241,779 236,303 247,064 235,464 226,561 204,438 240,910 225,402 242,665 239,066 <br /> Interest on Interfund Loans(TIF#9,#20,&#26) 22,258 7,432 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Interest on Interfund Loans(TIF#31&#32) 287,105 401,724 252,131 265,413 280,290 311,908 333,993 379,031 421,928 466,785 453,268 491,763 497,466 524,634 <br /> Interest on Interfund Loans(Other TIF Districts) 138,698 122,167 112,460 103,676 94,079 83,867 65,357 46,629 27,749 23,520 20,702 18,650 17,461 16,340 <br /> Principal on Interfund Loans(TIF#9,#20,&#26) 370,633 185,810 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Principal on Interfund Loans(TIF#31&#32) (2,865,432) 1,638,706 (442,743) (495,867) (1,053,974) (736,152) (1,501,284) (1,429,881) (1,495,247) 450,561 (1,283,134) (190,113) (905,588) (856,103) <br /> Principal on Interfund Loans(Other TIF Districts) 413,291 (188,346) 219,611 239,938 255,282 462,780 468,189 472,000 81,563 70,450 51,316 29,736 28,033 115 <br /> Other Sources/(Uses) (148,367) (1,065,397) 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Changes in Balance Sheet 191,751 9.855 <br /> Ending Cash Balance 7,661,769 6,116,153 7,362,666 7,714,705 8,059,307 7,876,763 8,236,469 7,848,789 7,652,032 6,814,686 8,030,340 7,613,402 8,088,842 7,968,879 7,892,931 <br /> Annual Cash Increase/(Decrease) (1,445,606) 1,236,513 362,039 344,602 (182,644) 368,706 (386,680) (296,757) (737,446) 1,215,754 (516,938) 575,440 (119.963) (75.948) <br /> TIF#31 TIF 31 NW Quadrant-Special Law <br /> Beginning Cash Balance 0 (1) 0 0 (0) 0 0 0 0 (0) 0 0 0 (0) <br /> Tax increment 61,411 155,397 118,276 116,307 282,223 282,223 282,223 380,456 481,807 481,807 568,396 654,984 741,572 1328,161 <br /> Investment Earnings(3%of Cash Balance) (2,523) 18,703 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Transfers In 565,715 320,000 1,083,662 1,057,420 739,764 1,333,491 813,707 1,221,163 1,000,000 2,885,807 1,000,000 1,770,229 750,000 750,000 <br /> Bond Principal 0 0 0 0 (334,350) (595,500) (831,750) (1,204,200) (1,253,400) (1,310,100) (1,365,450) (1,420,800) (1,472,700) (1,542,900) <br /> Bond Interest 0 (144,495) (1,493,330) (1,493,330) (1,486,361) (1,466,792) (1,436,675) (1,394,156) (1,343,150) (1,289,948) (1,233,550) (1,173,966) (1,110,870) (1,042,680) <br /> Interfund Loan Principal 345,868 (1,149,870) 412,737 464,961 974,623 651,715 1,397,184 1,273,164 1,439,499 (399,625) 1,395,216 584,680 1,533,324 1,503,404 <br /> Interfund Loan Interest (193,953) (207,788) (121,345) (133,727) (147,676) (176,914) (196,466) (238,381) (276,576) (319,761) (307,772) (349,629) (367,169) (413,169) <br /> Administrative Costs (118,584) (206,762) 0 (11,631) (28,222) (28,222) (28,222) (38,046) (48,181) (48,181) (56,840) (65,498) (74,157) (82,816) <br /> Expenditures Not Covered by Other Revenues (990,417) 850,500 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Changes in Balance Sheet 332.482 364,316 <br /> Ending Cash Balance 0 (1) 0 0 (0) 0 0 0 0 (0) 0 0 0 (0) 0 <br /> Annual Cash Increase/(Decrease) (1) 1 0 (0) 0 0 0 0 (0) 0 0 116 (0) 0 <br /> lnte,fund Loan Balance 4,848,827 5,194,695 4,044,825 4,457,562 4,922,523 5,897,145 6,548,860 7,946,043 9,219,207 10,658,707 10,259,082 11,654,298 12,238,978 13,772,302 15,275,706 <br /> TIF#32 TIF 32-NW Quadrant-Special Law <br /> Beginning Cash Balance 0 (0) 0 0 0 0 0 0 0 0 (0) (0) 0 0 <br /> Tax increment 117,211 287,553 223,914 223,914 223,913 223,913 223,913 223,913 343,075 462,237 528,484 838,332 1,081,934 1,081,934 <br /> Investment Earnings(3%of Cash Balance) (21,624) (2,356) 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Bond Principal 0 0 0 0 (25,650) (29,500) (48,250) (100,800) (106,600) (109,900) (114,550) (119,200) (122,300) (127,100) <br /> Bond Interest 0 (6,021) (123,134) (123,134) (122,609) (121,465) (119,845) (116,789) (112,563) (108,153) (103,508) (98,598) (93,407) (87,874) <br /> Interfund Loan Principal 2,519,564 (488,836) 30,006 30,906 79,351 84,437 104,100 156,717 55,748 (50,936) (112,082) (394,567) (627,736) (647,301) <br /> Interfund Loan Interest (93,152) (193,936) (130,786) (131,686) (132,614) (134,994) (137,527) (140,650) (145,352) (147,024) (145,496) (142,134) (130,297) (111,465) <br /> Administrative Costs (156,679) (113,943) 0 0 (22,391) (22,391) (22,391) (22,391) (34,307) (46,224) (52,848) (83,833) (108,193) (108,193) <br /> Expenditures Not Covered by Other Revenues (2,177,375) (339,778) 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Changes in Balance Sheet (187,945) 857,317 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Transfers Out 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <br /> Ending Cash Balance 0 (0) 0 0 0 0 0 0 0 0 (II (0] 0 0 0 <br /> Annual Cash Increase/(Decrease) (0, 0 01 0 0 0 0 0 0 (0) (0) 0 0 _ 0 <br /> Infeffund Loan Balance 2,328,815 4,848,379 4,359,543 4,389,549 4,420,455 4,499,806 4,584,243 4,688,344 4,845,061 4,900,809 4,849,873 4,737,791 4,343,224 3,715,486 3,068,186 <br /> 2/14/2012 4:41 <br /> EHLERS <br />