|
City of New Brighton CONCEPT PLAN 2
<br /> New Brighton Exchange
<br /> Combined Cash Balances&Projected Cash Flows
<br /> Projected
<br /> 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036
<br /> Summary of Pooled TIF(Districts#9,#20,) 4,(o}-0t-
<br /> Beginning Cash Balance 145,582 150,527 288,038
<br /> Tax increment 817,439 817,439 17,853.702
<br /> MVHC 17.111 17,111 273,214
<br /> Investment Earnings(3%of Cash Balance) 3,850 3,998 280.154
<br /> Project Costs 0 0 (39,132)
<br /> Bond Principal 0 0 (4,085,194)
<br /> Bond Interest 0 0
<br /> (524,400)
<br /> Interfund Loan Principal 0 0 (556.443)
<br /> Interfund Loan Interest 0 0 (29,690)
<br /> Administrative Costs (83,455) (83,455)
<br /> (859,55
<br /> Transfers Out (750,000) (868,368) .859,556)
<br /> (12 )
<br /> Changes in Balance Sheet 0 ,t7.253) 80,171
<br /> Ending Cash Balance 150,527 (1) (1)
<br /> Annual Cash Increase/(Decrease) 4,945 (150,528)
<br /> Pre-1990 TIF TIF 5-TIF 18(Excluding TIF#9) TOTALS
<br /> Beginning Cash Balance 1,829,854
<br /> Tax increment 10,549,367
<br /> MVHC
<br /> 135,744
<br /> Investment Earnings(3%of Cash Balance) 241,265
<br /> Other Revenues
<br /> 242,988
<br /> Bond Principal (7.179.488)
<br /> Bond Interest
<br /> 24,1
<br /> Interfund Loan Interest (1, 24.112)
<br /> 2)
<br /> Administrative Costs
<br /> Transfers Out , ,120)
<br /> (4 122
<br /> Changes in Balance Sheet (251, )787
<br /> Ending Cash Balance 0)
<br /> Annual Cash Increase/(Decrease)
<br /> FUND 460 Municipal Development Fund IETEM
<br /> Beginning Cash Balance 12,584,991 13,080,193 13,730,963 13,412,315 13,036,020 12,688,949 12,338,852 11,981,611 11,584,203 11,177,255 10,756,350 11,612,956 13,988,698 16,435,713 7,581,759
<br /> Investment Earnings(3%of Cash Balance) 377,550 392,406 411,929 402,369 391,081 380,668 370,166 359,454 347,526 335,318 322,690 348,389 419,661 493,071 8,973,494
<br /> Interest on Interfund Loans(TIF#9,#20,) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29,690
<br /> Interest on Interfund Loans(TIF#31 ) 426,666 439,306 446,048 482,684 520,890 559,016 598,061 638,129 660,264 723,579 768,241 775,532 737,978 0 12.726,922
<br /> Interest on Interfund Loans(Other TIF Districts) 17,866 16,861 15,785 14,645 14,755 14,872 14,997 15,184 15,420 15,672 15,942 0 0 0 1,159,194
<br /> Principal on Interfund Loans(TIF#9,#20,) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 556,443
<br /> Principal on Interfund Loans(TIF#31 ) (354,019) (224,709) (1,221,201) (1,273,543) (1,270,86B) (1,301,519) (1,335,600) (1,404,479) (1,443,849) (1,488,725) (243,044) 1,251,821 1,289,375 0 (16,132.239)
<br /> Principal on Interfund Loans(Other TIF Districts) 25,118 26,907 28,790 (2,450) (2,929) (3,134) (4,666) (5,896) (6,309) (6,750) (7,223) 0 0 0 3,065,679
<br /> Other Sources/(Uses) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (1,213,764)
<br /> Changes in Balance Sheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0 201.606
<br /> Ending Cash Balance 13,080,193 13,730,963 13,412,315 13,036,020 12,688,949 12.338,852 11,981,811 11,584,203 11,177,255 10,756,350 11,612,958 13,988,698 16,435,713 16.928,784 16,928,784
<br /> Annual Cash Increase/(Decrease) 495,201 650,771 (318,649) (376,295) (347,071) (350,097) (357,042) (397,608) (406,948) (420.906) 856,607 2.375.742 2,447.014 493,071
<br /> TIF#31 TIF 31 NW Quadrant-Special Law 1.- -„1,„
<br /> Beginning Cash Balance 0 0 0 0 (0) (0) (0) (0) (0) (0) (0) 0 ‘.l) 0
<br /> Tax increment 1,071,442 1,071,442 955,135 955,135 955,135 955,135 955,135 955,135 955,135 955,135 955,135 955,135 955,135 20.199.950
<br /> Investment Earnings(3%of Cash Balance) 0 0 0 0 0 0 0 0 0 0 0 0 0 16,180
<br /> Transfers In 750,000 1,419,810 950,542 948,458 953,266 953,484 954,446 950,261 950,328 949,080 972,452 1,167,732 1,167,732 28,468,956
<br /> Bond Principal (1,619,550) (1,693,650) (1,772,100) (1,872,750) (1,929,900) (2,017,500) (2,110,800) (2,238,450) (2,344,800) (2,459,400) (1,278,900) 0 0 i32(;68.950)
<br /> Bond Interest (970,314) (894,845) (813,216) (726,188) (632,965) (538,108) (440,806) (337,782) (228,734) (114,447) (27,976) 0 0 i21.834.683)
<br /> Interfund Loan Principal 1,264,727 631,490 1,221,201 1,273,543 1,270,868 1,301,519 1,335,600 1,404,479 1,443,849 1,488,725 243,044 (1,251,821) (1,289,375) 18.461,053
<br /> Interfund Loan Interest (389,161) (427,103) (446,048) (482,684) (520,890) (559,016) (598,061) (638,129) (680,264) (723,579) 95
<br /> Administrative Costs (107,144) (107,144) (95,513) (95,513) (95,513) (95,513) (95,513) (95,513) (95,513 ( ,5 ( ,5 ( ,5 (2,31,401)
<br /> 1
<br /> (95,513) (95,513)) (95,513)953) (95,513)953) 0 (2,311,4U1)
<br /> Expenditures Not Covered by Other Revenues 0 0 0 0 0 0 0 0 0 0 0 0 0 (139,917)
<br /> Changes in Balance Sheet 696.798
<br /> Ending Cash Balance 0 0 0 (0) (1) (0) (0) (0) (0i (0) 0 (0) ro) (0)
<br /> Annual Cash Increase/(Decrease) 0 0 0 (0) 0 0 0 0 0 0 0 (01 0
<br /> Interfund Loan Balance 14,236.761 14,868,251 16,089,452 17,362,995 /8,633,862 19,935,38/ 21270,981 22,675,460 24,119.308 25,608,033 25,851.077 24,599,256 23,309.880
<br /> TIF#32 TIF 32-NW Quadrant-Special Law TOTALS
<br /> Beginning Cash Balance 0 0 0 (0) (0) 0 0 (0) (0) 0 (0) in' 0 0 0
<br /> Tax increment 1,297,480 1,297,480 1,297,480 1,297,460 1,297,480 1,297,480 1,297,480 1,297,480 1,297,460 1,297,480 1,297,480 1,297,480 1,297,480 1,297,480 26,074,722
<br /> Investment Eamings(3%of Cash Balance) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (23,980)
<br /> Bond Principal (135,450) (141,350) (147,900) (157,250) (160,100) (167,500) (174,200) (186,550) (195,200) (205,600) (191,100) 0 0 0 (2.766,050)
<br /> Bond Interest (82,049) (75,956) (69,291) (62,024) (54,366) (46,746) (39,067) (30,921) (22,204) (13,053) (4,180) 0 0 0 (1.830,979)
<br /> Interfund Loan Principal (910,708) (406,781) 0 0 0 0 0 0 0 0 0 0 0 0 (2.328,815)
<br /> Interfund Loan Interest (39,525) (12,203) 0 0 0 0 0 0 0 0 0 0 0 0 (1.838,935)
<br /> Administrative Costs (129,748) (129,748) (129,748) (129,748) (129,748) (129,748) (129,748) (129,748) (129,748) (129,748) (129,748) (129,748) (129,748) (129,748) (2,815,226)
<br /> Expenditures Not Covered by Other Revenues 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (2,517.153)
<br /> Changes in Balance Sheet 669,372
<br /> Transfers Out (531,442) (050,542) (948,458) (953.266) (953.484) (954,449) (950,261) (950,328) 194906(h (212 4521 11 167.732) (1,167,732) (1,167,733) (12,616,956)
<br /> Ending Cash Balance 0 0 (0) (0) 0 0 (0) (0) 0 (10 (0) 0 0 (0) (0)
<br /> Annual Cash Increase/(Decrease) 0 0 (1) 0 0 0 (1) 0 0 (11 0 0 0 (1)
<br /> lnterfund Loan Balance 406,781 0 0 0 0 0 0 0 0 0 0 0 0 0
<br />
|