20120518073419 - Laserfiche WebLink

Home Browse Search

City of New Brighton Ejli=1M=rCONCEPT PLAN 2 New Brighton Exchange Combined Cash Balances&Projected Cash Flows Per Audit Actual Actual Projected 2008 2009 2010 2011 2012 201S 2014 2015 2016 2017 2018 2019 2020 2021 2022 Summary of Pooled TIF(Districts#9,#20,&#26) 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 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 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 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 Project Costs (39,132) 0 0 0 0 0 0 0 0 0 0 0 0 0 Bond Principal (322,462) (368,869) (391,413) (593,824) (674,570) (542,247) (824,526) (58,464) Bond Interest (104,485) (100,779) (72,369)11 ((7,785) ((5,700) ((1,676) 0 0 Interfund Loan Principal (77,160) (68,485) (55,943) (37,792) (35,965) (17,031) (11,599) (7,785) (5,700) (1,676) 0 0 p (370,633) (185,810) 0 0 0 0 0 0 0 0 0 0 0 0 Interfund Loan Interest (22,258) (7,432) 0 0 0 0 0 0 0 0 0 0 0 0 Administrative Costs (17,811) 23,804 (5,519) (6,484) 0 0 (75,874) (216) (171) (100,115) (42,201) (122,457) (50,000) (83,455) 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) Changes in Balance Sheet 65,624 15,612 0 11,656 0 0 0 0 0 0 0 4,532 0 0 Ending Cash Balance 288,038 158,716 627,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 145,682 Annual Cash Increase/(Decrease] 129,322) 368,626 174,302 161.8 114) 466,519 629,449 (455,683) 186,816 183 993 (912,911) 106,320 (706,121) 4,661 4.801 Pre-1990 TIF TIF 5-TIF 18(Excluding TIF#9) Beginning Cash Balance 1,829,854 2,175,565 2,514,247 2,352,892 2,305,827 1,749,958 693,397 679,940 611,799 669,889 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 MVHC 14,550 13,466 13,466 13,466 13,466 13,466 13,466 13,466 13,466 13,466 Investment Earnings(3%of Cash Balance) 21,675 30,956 22,487 22,852 33,792 34,730 17,273 19,955 17,901 19,644 Other Revenues 297,679 (58,442) 3,749 0 0 (0) 0 0 0 0 Bond Principal (1,228,894) (1,245,248) (1,312,765) (1,214,782) (893,590) (589,189) (305,000) (180,000) (210,000) Bond Interest (342,847) (263,379) (191,143) (115,599) (79,280) (56,491) 0 ( (19,511) (11,010) (3,885) 0 Interfund Loan Interest (11,870) (4,760) (6,885) (597) 0 0 0 0 0 0 Administrative Costs (74,260) 5,791 (70,768) (88,382) (52,196) (42,799) (7,828) (7,742) 0 0 Transfers Out (41,058) 0 (431,360) (363,461) (739,764) (1,333,491) (63,707) (221,163) 0 (928,516) Changes in Balance Sheet (134.1131) 150.393 (199,649) (14.646) (39.593) (10 9771 12,279 328 0 i 15.(19 i) Ending Cash Balance 1,829,854 2,175,565 2,514,247 2,352,892 2,306,827 1,749,958 693,397 679.940 611.799 669,889 0 Annual Cash Increase/(Decrease] 345,711 338,682 (161,355) (47,064) (555,870) (1,056,561) (13�) (68,141) 58,090 (669.889) FUND 460 Municipal Development Fund Beginning Cash Balance 7,561,759 6,116,153 7,352,665 8,000,760 8,355,069 8,401,380 8,980,676 8,769,226 8,774,602 8,666,747 10,251,586 10,398,012 11,690,895 12,098,287 Investment Earnings(3%of Cash Balance) 144,457 124,562 220,580 240,023 250,652 252,041 269,420 263,077 263,238 260,002 307,548 311,940 350,727 362,949 Interest on Interfund Loans(TIF#9,#20,&#26) 22,258 7,432 0 0 0 0 0 0 0 0 0 0 0 0 Interest on Interfund Loans(TIF#31&#32) 287,105 401,723 252,131 263,982 279,487 304,119 319,007 356,632 390,116 426,801 401,856 420,813 406,163 418,573 Interest on Interfund Loans(Other TIF Districts) 138,698 122,167 129,700 112,072 102,005 92,596 75,526 60,374 42,718 25,962 24,338 22,554 19,680 18,805 Principal on Interfund Loans(TIF#9,#20,&#26) 370,633 185,810 0 0 0 0 0 0 0 0 0 0 0 0 Principal on lnterfund Loans(TIF#31&#32) (2,865,432) 1,638,706 (395,045) (516,828) (821,062) (496,254) (1,254,189) (1,116,103) (1,222,837) 831,491 (631,913) 488,355 (413,673) (337,097) Principal on Interfund Loans(Other TIF Districts) 413,291 (188,346) 440,729 255,060 235,229 426,794 378,786 441,396 418,910 40,583 44,596 49,221 44,496 23,474 Other Sources/(Uses) (148,367) (1,065,397) 0 0 0 0 0 0 0 0 0 0 0 0 Changes in Balance Sheet 191,751 9,855 0 0 0 0 0 0 0 0 0 0 0 0 Ending Cash Balance 7,561,759 6.116,153 7,352,665 8,000,760 8,355,069 8,401,380 8,980,676 8,769,226 8,774,602 8,666,747 10,251,586 10,398,012 11,690,895 12,098,287 12,584,991 Annual Cash Increase/(Decrease] (1,445,606) 1,236,512 648,095 354,309 46,311 579,296 (211.450) 5,376 (107.855) 1,584,839 146.425 1,292,883 407,393 486,704 TIF#31 TIF 31 NW Quadrant-Special Law Beginning Cash Balance 0 (1) 0 0 (0) 0 0 0 0 (0) (0) 0 (0) (0) Tax increment 61,411 154,915 118,276 116,307 540,121 540,121 540,121 555,050 569,979 670,272 770,564 870,857 971,149 1,071,442 Investment Earnings(3%of Cash Balance) (2,523) 18,703 0 0 0 0 0 0 0 0 0 0 0 0 Transfers In 565,715 320,000 1,131,360 1,057,420 739,764 1,333,491 813,707 1,221,163 1,000,000 2,928,516 1,000,000 1,770,229 750,000 750,000 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) Bond Interest 0 (144,494) (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) Interfund Loan Principal 345,868 (1,149,870) 365,039 463,530 741,040 411,125 1,149,376 1,092,896 1,331,604 (643,729) 1,174,163 344,662 1,273,772 1,223,731 Interfund Loan Interest (193,953) (207,787) (121,345) (132,296) (146,202) (168,433) (180,767) (215,248) (248,035) (287,983) (268,671) (303,896) (314,236) (352,449) Administrative Costs (118,584) (206,282) 0 (11,631) (54,012) (54,012) (54,012) (55,505) (56,998) (67,027) (77,056) (87,086) (97,115) (107,144) Expenditures Not Covered by Other Revenues (990,417) 850,500 0 0 0 0 0 0 0 0 0 0 0 0 Changes in Balance Sheet 332,482 364.316 Ending Cash Balance 0 (1) 0 0 (0) 0 0 0 0 0,1 (0) 0 (0, (0) 0 Annual Cash Increase/(Decrease) 11) 1 0 (n! 0 0 0 0 0(1) 0 0 t°1 (0) 0 lnterfund Loan Balance 4,646,827 5,194,695 4,044,825 4,409,864 4,873,394 5,614,434 6,025,559 7,174,935 8,267,631 9,599,435 8,955,705 10,129,868 10,474,530 11,748,302 12,972,033 TIF#32 TIF 32-NW Quadrant-Special Law Beginning Cash Balance 0 (0) 0 0 0 0 0 0 0 0 (0) 0 0 0 Tax increment 117,211 287,553 223,914 223,913 223,913 223,913 223,913 373,074 522,234 605,147 992,771 1,297,480 1,297,480 1,297,480 Investment Earnings(3%of Cash Balance) (21,624) (2,356) 0 0 0 0 0 0 0 0 0 0 0 0 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) 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) Interfund Loan Principal 2,519,564 (488,836) 30,006 53,298 80,022 85,129 104,813 23,207 (108,767) (187,762) (542,250) (833,017) (860,098) (886,634) Interfund Loan Interest (93,152) (193,936) (130,786) (131,686) (133,285) (135,686 Administrative Costs (156,679) (113,943) 0 (22,391) (22,391 ) (138,240) (141,384) (152,22 ) (138,818) (133,185) (116,917) (21,748) (66,124) (22 39 ) (22,391) (37,307) (52,22 ) (60,515) (99,27 ) (129 74 ) (129 74 ) (129 74 ) Expenditures Not Covered by Other Revenues (2,177,375) (339,778) 0 0 0 0 000 300 0 0 0 Changes in Balance Sheet (187,945) 857,317 Transfers Out Ending Cash Balance 0 (9) 0 0 0 0 0 0 0 0 (0) 0 0 0 0 Annual Cash Increase/(Decrease) (0) 0 0 0 0 0 0 0 0 (D) 0 0 0 0 lnterfund Loan Balance 2,328,8/5 4,848,379 4,359,543 4,389,549 4,442,847 4,522,869 4,607,999 4,712,812 4,736,019 4,627,252 4,439,490 3,897,240 3,064,222 2,204,124 1,317,490