Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
8.f1 Example of Long Prairie FMP Option I
CITY OF LONG PRAIRIE, MN Financial Management Plan Summary OPTION 1 - Storm Water Utility 1 Inflation Assumptions Revenues-non-property tax 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 2 Expenditures 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 3 4 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 5 GENERAL FUND Actual Actual Actual YTD Prelim 6 REVENUE 7 Taxes 297,827 316,984 354,006 353,282 408,837 559,126 626,867 699,456 821,185 873,199 936,919 1,037,401 1,089,701 1,138,875 8 Special assessments 15,164 9,177 14,491 (2,793) 9,500 9,500 9,500 9,500 9,500 9,500 9,500 9,500 9,500 9,500 9 Other taxes - - - - - - - - - 10 Licenses and Permits 147,409 39,055 83,939 38,147 51,200 51,712 52,229 52,751 53,279 53,812 54,350 54,893 55,442 55,997 11 LGA 1,006,356 1,032,722 1,109,129 1,063,403 1,085,459 1,085,500 1,085,500 1,085,500 1,096,355 1,107,319 1,118,392 1,129,576 1,140,871 1,152,280 12 Intergovernmental-Federal Grant 40,805 42,029 43,289 13 Intergovernmental-School Resource Officer 10,510 10,826 11,150 44,588 45,926 47,304 48,723 50,184 51,690 14 Charges for Services 17,146 41,976 11,118 7,882 24,250 24,493 24,737 24,985 25,235 25,487 25,742 25,999 26,259 26,522 15 Fines and Fees 30,448 33,049 45,024 47,108 33,200 33,532 33,867 34,206 34,548 34,894 35,242 35,595 35,951 36,310 16 Miscellaneous 99,835 83,910 23,121 57,432 79,100 79,891 80,690 81,497 82,312 83,135 83,966 84,806 85,654 86,511 17 Franchise fees 79,546 99,225 78,239 78,547 80,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000 18 Transfer in 177,060 156,762 282,300 158,167 146,000 147,460 148,935 150,424 151,928 153,447 154,982 156,532 158,097 159,678 19 from 20 from 21 from 22 Interest on Investments 36,591 8,134 4,698 36,000 36,000 36,000 36,000 36,000 36,000 36,000 36,000 36,000 36,000 23 TOTAL REVENUE 1,870,791 1,849,451 2,009,501 1,805,873 1,953,546 2,126,528 2,199,180 2,276,758 2,402,930 2,470,718 2,550,397 2,667,025 2,735,660 2,801,362 24 25 EXPENSES 26 General Government 522,082 418,097 451,035 470,783 452,041 465,602 479,570 493,957 508,776 524,039 539,761 555,953 572,632 589,811 27 Public Safety 600,082 617,802 695,979 707,551 729,625 751,514 774,059 797,281 821,199 845,835 871,210 897,347 924,267 951,995 28 Health and Welfare - - - - - - - - - 29 Economic Development 32,367 28,214 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 30 Public Works 310,011 436,312 441,363 616,922 537,875 554,011 570,632 587,751 605,383 623,545 642,251 661,518 681,364 701,805 31 Culture & Recreation - - - - - - - - - 32 Capital Outlay 196,362 17,101 17,205 - - - - - - - - - 33 Services to other cities - - - - - - - - - 34 Other - - - - - - - - - 35 Transfer out 293,917 331,721 42,459 36 to Fire Dept Fund 39,852 84,213 62,841 84,213 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 37 to Park Fund 77,340 77,247 75,125 75,000 85,000 85,000 85,000 85,000 95,000 95,000 95,000 95,000 38 to Airport 9,852 9,750 9,000 6,363 8,239 10,179 12,186 14,261 16,406 18,625 20,918 23,288 39 to TIF 1-2 350 40 to 2010 GO Bonds 27,517 41 to Library 5,622 42 to Street improvements 45,826 43 to Police equip 30,000 32,500 30,000 31,000 31,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 44 to Public works equp 52,898 48,750 14,539 50,000 50,000 50,000 100,000 100,000 100,000 150,000 150,000 150,000 45 to EDA Fund 46 Contingency 15,000 25,000 35,000 30,000 35,000 40,000 40,000 40,000 35,000 47 New Employees - Positions Added 48 Police Officer-School Liaison (grant reimb cost share with school)61,825 63,680 65,590 67,558 69,585 71,672 73,822 76,037 78,318 49 Public Works (2021 gen fd 35% of 60000 )20,828 21,453 22,096 22,759 23,442 24,145 50 51 52 53 59 TOTAL EXPENSES 1,954,821 1,849,247 1,926,839 2,122,175 1,943,046 2,126,528 2,199,180 2,276,758 2,402,930 2,470,718 2,550,397 2,667,025 2,735,660 2,801,362 60 61 REVENUE OVER (UNDER) EXPENSES (84,030) 204 82,662 (316,302) 10,500 - - - - - - - - - 62 Prior period adjustment 97,985 63 Ending Fund Balance 1,097,285 1,097,489 1,180,151 863,849 874,349 889,349 914,349 949,349 979,349 1,014,349 1,054,349 1,094,349 1,134,349 1,169,349 64 Fund Balance as a Percent of Next Yr Expenses 59%57%56%44%41%40%40%40%40%40%40%40%40%41% Projected 5/14/2020 1 CITY OF LONG PRAIRIE, MN Financial Management Plan Summary OPTION 1 - Storm Water Utility 1 Inflation Assumptions Revenues-non-property tax 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 2 Expenditures 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 3 4 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 5 GENERAL FUND Actual Actual Actual YTD Prelim Projected 65 66 GENERAL FUND OPERATING TAX LEVY 285,749 316,022 352,775 356,715 399,837 559,126 626,867 699,456 821,185 873,199 936,919 1,037,401 1,089,701 1,138,875 67 ANNUAL INCREASE 10.6%11.6%1.1%12.1%39.8%12.1%11.6%17.4%6.3%7.3%10.7%5.0%4.5% 68 69 DEBT AND SPECIAL LEVIES 70 71 GO Bonds of 2010 145,000 179,000 170,000 125,772 125,608 129,189 130,974 127,253 128,645 129,852 130,725 0 0 0 72 GO Bonds of 2012A 180,000 185,000 180,000 74,673 78,934 77,758 76,471 80,325 0 0 0 0 0 0 73 2016 Bonds 119,790 116,955 119,370 116,430 118,740 120,945 117,795 119,895 0 0 0 74 2018B Bonds 94,629 162,645 162,645 158,550 159,705 160,702 161,542 162,225 0 0 0 75 2021B-Levy 0 19,144 19,144 19,144 19,144 19,144 197,644 195,592 198,610 76 2021B-Storm Water 77 2021A - Storm Water 78 EDA 79 Police Garage/Equipment Debt Levy 0 0 0 0 0 80 Public Works Debt Levy 0 0 0 0 81 82 83 84 85 TOTAL SPECIAL LEVIES 325,000 364,000 350,000 414,864 484,142 488,963 501,570 505,168 429,436 428,334 431,990 197,644 195,592 198,610 86 87 TOTAL TAX LEVIES-Based on Tax Capacity 610,749 680,022 702,775 771,579 883,979 1,048,089 1,128,437 1,204,624 1,250,621 1,301,532 1,368,909 1,235,046 1,285,293 1,337,485 88 89 90 NET LEVY TO TAXPAYERS 610,749 680,022 702,775 771,579 883,979 1,048,089 1,128,437 1,204,624 1,250,621 1,301,532 1,368,909 1,235,046 1,285,293 1,337,485 91 92 EXISTING TAX CAPACITY (TAX BASE)1,104,292 1,212,518 1,319,947 1,535,019 1,554,041 1,569,581 1,654,730 1,692,737 1,726,592 1,761,124 1,796,346 1,832,273 1,868,918 1,906,297 93 TAX INCREMENT CAPTURED TAX CAPACITY 94 TIF 1-10 LP Packing 52,703 95 TIF 1-11 Impact Technology 4,816 96 97 98 NEW REDEVELOMENT TAX CAPACITY 0 0 0 0 0 0 0 0 99 TOTAL TAX CAPACITY 1,104,292 1,212,518 1,319,947 1,535,019 1,554,041 1,622,284 1,659,546 1,692,737 1,726,592 1,761,124 1,796,346 1,832,273 1,868,918 1,906,297 100 101 TAX RATE ON TAX CAPACITY 55.307%56.083%53.243%50.265%56.883%64.606%67.997%71.164%72.433%73.904%76.205%67.405%68.772%70.161% 102 TAX RATE % CHANGE 1.40%-5.07%-5.59%13.17%13.58%5.25%4.66%1.78%2.03%3.11%-11.55%2.03%2.02% 103 104 City Taxes (incl MVHC or MV Exclusion)531 539 512 483 547 638 690 741 776 812 861 781 818 856 105 Market Value 122,300 122,300 122,300 122,300 122,300 124,746 127,241 129,786 132,381 135,029 137,730 140,484 143,294 146,160 106 % tax increase on median home 1.40%-5.07%-5.59%13.17%16.70%8.12%7.49%4.61%4.74%5.93%-9.23%4.77%4.65% 107 Amount increase on median value home $7 -$27 -$29 $64 $91 $52 $52 $34 $37 $48 -$79 $37 $38 5/14/2020 2 CITY OF LONG PRAIRIE Financial Management Plan Airport Special Revenue Fund 612 Inflation Assumptions 1 Revenue inflation 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% Capital inflation 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2 Expense inflation 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 3 Interest Income 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Actual Actual Actual YTD REVENUE 4 General Property Tax 5 Intergovernmental (Capital)199,483 82,680 311,002 968,284 0 442,000 0 0 105,287 0 0 0 0 0 6 Intergovernmental (Operating)30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 7 Intergovernmental (County)9,000 9,090 9,181 9,273 9,365 9,459 9,554 9,649 9,746 9,843 7 Intergovernmental (COVID Response)20,000 8 Charges for services 29,778 26,679 29,264 30,000 30,000 30,300 30,603 30,909 31,218 31,530 31,845 32,163 32,485 9 Interest Earnings 10 Contributions & Donations 11 Miscellaneous Revenue 32,936 14,376 9,159 185 187 189 191 193 195 197 199 201 203 205 12 Total Revenue 232,419 126,834 346,840 997,733 89,187 511,279 69,672 70,069 175,757 70,874 71,283 71,695 72,112 72,533 EXPENSES 13 Total Current 49,581 50,103 65,514 71,300 73,439 75,642 77,911 80,248 82,655 85,135 87,689 90,320 93,030 95,821 14 Total Capital Projects 76,282 155,138 191,250 1,049,206 0 442,000 0 0 116,986 0 0 0 0 0 Future Debt 0 0 0 0 0 0 0 0 0 0 15 Existing Debt: 16 Total Expenses 125,863 205,241 256,764 1,120,506 73,439 517,642 77,911 80,248 199,641 85,135 87,689 90,320 93,030 95,821 17 Revenues Over / (Under) Expenses 106,556 (78,407)90,076 (122,773)15,748 (6,363)(8,239)(10,179)(23,884)(14,261)(16,406)(18,625)(20,918)(23,288) OTHER FINANCING SOURCES / (USES) 18 Bond Proceeds 0 0 0 0 0 0 0 0 19 Sale of assets 20 Transfers In 9,750 9,000 21 Transfers In-from General Fd 9,852 9,750 9,000 6,363 8,239 10,179 12,186 14,261 16,406 18,625 20,918 23,288 22 Transfers Out 23 21 Total Other Sources / (Uses)9,750 9,000 9,852 9,750 9,000 6,363 8,239 10,179 12,186 14,261 16,406 18,625 20,918 23,288 22 Prior Period Adjustments 23 Ending Fund Balance 22,594 (46,813)53,115 (59,908)(35,160)(35,160)(35,160)(35,160)(46,859)(46,859)(46,859)(46,859)(46,859)(46,859) Project 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Capital Project Name First Year Costs 24 - - - - - - - - - - - 25 snowbloer - - - - - - - - - - - 26 8 Unit Hangar Design 90,100 - - - - - - - - - - - 27 Master Plan and ALP Update 2021 375,000 - - 390,000 - - - - - - - - 28 Replace fuel system pump and card reader 2021 50,000 - - 52,000 - - - - - - - - 29 Hangar construction 1,218,159 - - - - - - - - - - - 30 RWY/TWY apron pavement 250,000 - - - - - - - - - - - 31 RWY extension justification 50,000 - - - - - - - - - - - 32 Environmental assessment 100,000 - - - - - - - - - - - 33 RWY extension design 250,000 - - - - - - - - - - - 34 RWY extension construction 1,500,000 - - - - - - - - - - - 62 Sealcoating Runway 2024 100,000 - - - - - 116,986 - - - - - 63 Total Capital Projects - - - - - 442,000 - - 116,986 - - - - - CASH FLOW ANALYSISCAPITAL PROJECTS & DEBT LEVYProjected 5/14/2020 3 CITY OF LONG PRAIRIE Financial Management Plan Tourism Fund 617 Inflation Assumptions 1 Capital Inflation Rate 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2 Expense inflation 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 3 Interest Income 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Actual Actual Actual YTD Budget REVENUE 4 Other taxes 7,901 9,936 5,577 7,412 3,000 3,500 3,570 3,641 3,714 3,789 3,864 3,942 4,020 4,101 5 0 0 0 0 0 0 0 0 0 0 6 Charges for services 7 Interest Earnings 48 34 20 45 8 (51)(114)(179)(247)(318)(393)(470)(551) 8 Contributions & Donations 9 Miscellaneous Revenue 5,564 7,459 4,612 2,538 0 0 0 0 0 0 0 0 0 10 Total Revenue 13,513 17,429 10,209 9,995 3,000 3,508 3,519 3,527 3,535 3,542 3,546 3,549 3,550 3,550 EXPENSES 11 Total Current 16,605 16,980 16,227 9,682 9,200 9,476 9,760 10,053 10,355 10,666 10,986 11,316 11,655 12,005 12 13 Total Capital Projects 0 0 0 0 0 0 0 0 0 0 0 14 Existing Debt: Interest 15 Total Expenses 16,605 16,980 16,227 9,682 9,200 9,476 9,760 10,053 10,355 10,666 10,986 11,316 11,655 12,005 16 Revenues Over / (Under) Expenses (3,092)449 (6,018)313 (6,200)(5,968)(6,241)(6,526)(6,820)(7,124)(7,440)(7,767)(8,105)(8,455) OTHER FINANCING SOURCES / (USES) 17 Bond Proceeds 0 0 0 0 0 0 0 0 0 0 18 Sale of assets 19 Transfers In 20 Transfers In-from General Fd 0 0 0 0 0 0 0 0 0 0 0 0 0 21 22 Transfers Out 0 0 0 0 0 20 Total Other Sources / (Uses)0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Prior Period Adjustments 22 Ending Fund Balance 12,300 12,749 6,731 7,044 844 (5,124)(11,365)(17,891)(24,710)(31,835)(39,275)(47,042)(55,147)(63,602)CASH FLOW ANALYSISProjected 5/14/2020 4 CITY OF LONG PRAIRIE Financial Management Plan Park Fund 228 Inflation Assumptions 1 Capital Inflation Rate 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2 Expense inflation 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 3 Interest Income 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Actual Actual Actual Budget Budget REVENUE 4 General Property Tax 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 6 Charges for services 1,890 1,890 2,550 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 7 Interest Earnings 18 100 100 27 2 53 79 80 55 103 124 116 8 Contributions & Donations 9 Miscellaneous Revenue 1,164 1,818 390 500 500 520 541 563 586 609 633 658 684 711 10 Total Revenue 3,054 3,708 2,958 3,100 3,100 3,047 3,043 3,116 3,165 3,189 3,188 3,261 3,308 3,327 EXPENSES 11 Total Current 98,006 76,007 78,385 77,247 78,225 80,572 82,989 85,479 88,043 90,684 93,405 96,207 99,093 102,066 12 13 Total Capital Projects 3,794 0 5,137 0 0 0 0 0 0 0 0 0 0 0 14 Existing Debt: Interest 15 Total Expenses 101,800 76,007 83,522 77,247 78,225 80,572 82,989 85,479 88,043 90,684 93,405 96,207 99,093 102,066 16 Revenues Over / (Under) Expenses (98,746)(72,299)(80,564)(74,147)(75,125)(77,525)(79,946)(82,363)(84,878)(87,495)(90,217)(92,946)(95,785)(98,739) OTHER FINANCING SOURCES / (USES) 17 Bond Proceeds 0 0 0 0 0 0 0 0 0 0 18 Sale of assets 19 Transfers In-from General Fd 66,079 66,834 77,340 77,247 75,125 75,000 85,000 85,000 85,000 85,000 95,000 95,000 95,000 95,000 20 Transfers In 0 0 0 0 0 0 0 0 0 0 0 0 0 21 22 Transfers Out 0 0 0 0 0 20 Total Other Sources / (Uses)66,079 66,834 77,340 77,247 75,125 75,000 85,000 85,000 85,000 85,000 95,000 95,000 95,000 95,000 21 Prior Period Adjustments (2,183) 22 Ending Fund Balance 8,321 2,856 (368)2,732 2,732 207 5,261 7,898 8,020 5,525 10,308 12,362 11,577 7,838CASH FLOW ANALYSISProjected 5/14/2020 5 CITY OF LONG PRAIRIE Financial Management Plan Economic Development Authority Inflation Assumptions 1 Capital Inflation Rate 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2 Expense inflation 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 3 Interest Income 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Actual Actual Actual Budget Budget REVENUE 4 General Property Tax (469.107)18,634 19,006 19,387 19,774 20,170 20,573 20,985 21,404 21,832 5 City contribution 30,177 31,597 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 6 Charges for services 1,800 2,255 7 Interest Earnings 17 92 166 1,240 1,686 2,138 2,596 3,060 3,531 4,008 4,491 4,981 8 Contributions & Donations 9 Miscellaneous Revenue 100 167 325 325 338 352 366 381 396 412 428 445 463 10 Total Revenue 31,994 34,044 32,333 32,325 32,325 52,212 53,044 53,891 54,751 55,626 56,516 57,421 58,340 59,276 EXPENSES 11 Total Current 5,878 10,749 16,692 6,795 7,395 7,617 7,846 8,081 8,323 8,573 8,830 9,095 9,368 9,649 12 EDA director 90-100 13 Total Capital Projects 0 0 0 0 0 0 0 0 0 0 0 0 0 14 Existing Debt: Interest 15 Total Expenses 5,878 10,749 16,692 6,795 7,395 7,617 7,846 8,081 8,323 8,573 8,830 9,095 9,368 9,649 16 Revenues Over / (Under) Expenses 26,116 23,295 15,641 25,530 24,930 44,595 45,198 45,810 46,428 47,053 47,686 48,326 48,972 49,627 OTHER FINANCING SOURCES / (USES) 17 Bond Proceeds 0 0 0 0 0 0 0 0 0 0 18 Sale of assets 19 Transfers In 20 Transfers In-from General Fd 0 0 0 0 0 0 0 0 0 0 0 0 0 21 22 Transfers Out 0 0 0 0 0 20 Total Other Sources / (Uses)0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Prior Period Adjustments 22 Ending Fund Balance 34,593 57,888 73,529 99,059 123,989 168,584 213,782 259,592 306,020 353,073 400,759 449,084 498,057 547,684CASH FLOW ANALYSISProjected 5/14/2020 6 CITY OF LONG PRAIRIE Financial Management Plan Fire Department Fund 226 (and Fire Capital Fd 410) Inflation Assumptions Inflation Rate - Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 1 Inflation Rate - Equipment 2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Interest Income 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Actual Actual Actual REVENUE 3 General Property Tax 4 5 Charges for services 90,068 85,989 80,067 82,600 90,734 109,890 110,989 112,099 113,220 114,352 115,495 116,650 117,817 118,995 6 Intergovernmental 47,302 48,022 37,256 37,302 37,000 37,000 37,000 37,000 37,000 37,000 37,000 37,000 37,000 37,000 7 Interest Earnings 640 360 258 485 275 2,394 0 0 668 1,328 1,935 2,486 2,977 3,406 8 Contributions & Donations 9 Miscellaneous Revenue 2,466 10,713 1,518 10,000 10,000 11,525 11,525 11,525 11,525 11,525 11,525 11,525 11,525 11,525 10 Total Revenue 140,476 145,084 119,099 130,387 138,009 160,809 159,514 160,624 162,413 164,205 165,955 167,661 169,319 170,926 EXPENSES 11 Total Current 170,778 177,487 172,809 107,481 143,850 156,878 163,153 169,679 176,466 183,525 190,866 198,501 206,441 214,699 12 13 Total Capital Projects 62,469 22,898 11,850 0 408,000 0 0 0 0 0 0 0 0 14 Future Debt 0 0 0 0 0 0 0 0 0 0 0 0 0 15 Total Expenses 233,247 200,385 184,659 107,481 143,850 564,878 163,153 169,679 176,466 183,525 190,866 198,501 206,441 214,699 16 Revenues Over / (Under) Expenses (92,771)(55,301)(65,560)22,906 (5,841)(404,069)(3,639)(9,055)(14,053)(19,320)(24,911)(30,840)(37,122)(43,773) OTHER FINANCING SOURCES / (USES) 17 Bond Proceeds 18 Bond costs 19 Transfers In (Between Fd 226 and 410)47,000 48,000 20 Transfers In-from General Fd 73,177 78,888 39,852 84,213 62,841 84,213 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 21 22 Transfers Out (Between Fd 226 and 410)(37,921)(46,673)(44,000)(48,000) 21 Total Other Sources / (Uses)35,256 32,215 39,852 87,213 62,841 84,213 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 22 Prior Period Adjustments (6,677) 23 Ending Fund Balance 121,069 97,983 72,275 182,394 239,394 (80,462)(4,101)66,844 132,791 193,471 248,560 297,720 340,598 376,825 Project 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Capital Project Name First Year Costs 24 - - - - - - - - - - - 25 Unit 141 (1991 Pumper)500,000 - - - - - - - - - - - 26 Unit 149 (1999 Rescue)2021 400,000 - - 408,000 - - - - - - - - 27 Unit 144 (2001 Tanker)300,000 - - - - - - - - - - - 28 Unit 140 (2005 Pumper)500,000 - - - - - - - - - - - 29 Unit 148 (2005 Ladder)900,000 - - - - - - - - - - - 30 Unit 143 (2010 Tanker)300,000 - - - - - - - - - - - 31 Unit 145-01 (1999 4x4 Grass Rig)100,000 - - - - - - - - - - - 32 Unit 145-02 (2008 Kubota)50,000 - - - - - - - - - - - 67 68 Total Capital Projects - - - - - 408,000 - - - - - - - - CASH FLOW ANALYSISCAPITAL PROJECTS & DEBT LEVYProjected Projected 5/14/2020 7 CITY OF LONG PRAIRIE Financial Management Plan Police Equipment Fund 412 Inflation Assumptions 1 Inflation Rate - Equipment 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% 2 Interest Income 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Actual Actual Actual Budget REVENUE 3 General Property Tax 0 0 0 0 0 0 0 0 0 0 4 Special assessments 0 0 0 0 0 0 0 0 0 0 5 Intergovernmental 6 Interest Earnings 51 37 70 400 150 696 2,270 744 600 452 348 578 612 883 7 Contributions & Donations 8 Miscellaneous Revenue 250 0 0 0 0 0 0 0 0 0 0 9 Total Revenue 51 287 70 400 150 696 2,270 744 600 452 348 578 612 883 EXPENSES 10 Total Current 11,426 0 0 0 0 0 0 0 0 0 11 12 Total Capital Projects 37,220 6,830 47,562 40,000 61,300 185,850 67,200 55,350 63,900 17,300 50,200 13,500 56,900 13 Bond repayment 0 0 0 0 0 0 0 0 0 0 14 Total Expenses 48,646 0 6,830 47,562 40,000 61,300 185,850 67,200 55,350 63,900 17,300 50,200 13,500 56,900 15 Revenues Over / (Under) Expenses (48,595)287 (6,760)(47,162)(39,850)(60,604)(183,580)(66,456)(54,750)(63,448)(16,952)(49,622)(12,888)(56,017) OTHER FINANCING SOURCES / (USES) 16 Bond Proceeds 0 0 0 0 0 0 0 0 17 Sale of Assets 6,921 12,000 12,000 13,000 13,000 15,000 18 Bond costs 4,992 19 Transfers In-from General Fd 35,104 44,798 30,000 32,500 30,000 31,000 31,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 20 Transfers In-from Street Project Fund 0 0 175,000 0 0 0 0 0 0 0 0 21 Transfers Out 0 (4,992)0 0 0 0 0 0 0 0 0 0 20 Total Other Sources / (Uses)35,104 44,798 30,000 39,421 30,000 218,000 31,000 52,000 40,000 53,000 40,000 53,000 40,000 55,000 21 Prior Period Adjustments 22 Ending Fund Balance 18,874 63,959 87,199 79,458 69,608 227,004 74,424 59,968 45,218 34,770 57,818 61,196 88,308 87,291CASH FLOW ANALYSISProjected 5/14/2020 8 CITY OF LONG PRAIRIE Financial Management Plan Police Equipment Fund 412 Inflation Assumptions 1 Inflation Rate - Equipment 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% 2 Interest Income 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%CASH FLOW ANALYSISProject 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Capital Project Name First Year Last Year Costs 23 24 Patrol vehicle 2019 42,317 42,317 - - - - - - - - - - 25 Patrol vehicle 2021 43,000 - - 43,000 - - - - - - - - 26 Patrol vehicle 2023 43,000 - - - - 43,000 - - - - - - 27 Patrol vehicle 2025 43,000 - - - - - - 43,000 - - - - 28 Patrol vehicle 2027 44,000 - - - - - - - - 44,000 - - 29 Patrol vehicle 2029 44,000 - - - - - - - - - - 44,000 30 Squad radios 2022 6,750 - - - 6,750 - - - - - - - 31 Squad radios 2024 6,750 - - - - - 6,750 - - - - - 32 Portable radios 2023 12,500 - - - - 12,500 - - - - - - 33 Portable radios 2025 12,500 - - - - - - 12,500 - - - - 34 Squad cameras 2019 5,245 5,245 - - - - - - - - - - 35 Squad cameras 2023 2025 6,200 - - - - 6,200 6,200 6,200 - - - - 36 Squad cameras 2027 2029 6,200 - - - - - - - - 6,200 6,200 6,200 37 Watch guard server 2026 5,400 - - - - - - - 5,400 - - - 38 Light bars 2021 2,200 - - 2,200 - - - - - - - - 39 Light bars 2025 2,200 - - - - - - 2,200 - - - - 40 Light bars 2029 2,200 - - - - - - - - - - 2,200 41 Patrol rifles 2019 1,100 1,100 - - - - - - - - - - 42 Patrol rifles 2021 1,100 - - 1,100 - - - - - - - - 43 Patrol rifles 2023 1,100 - - - - 1,100 - - - - - - 44 Squad computers and dock 2020 4,100 - 4,100 - - - - - - - - - 45 Squad computers and dock 2022 4,100 - - - 4,100 - - - - - - - 46 Squad computers and dock 2024 4,100 - - - - - 4,100 - - - - - 47 Squad computers and dock 2026 4,300 - - - - - - - 4,300 - - - 48 Squad computers and dock 2028 4,300 - - - - - - - - - 4,300 - 49 Computers and software 2019 5,500 5,500 - - - - - - - - - - 50 Computers and software 2026 4,100 - - - - - - - 4,100 - - - 51 Video equipment 2028 3,000 - - - - - - - - - 3,000 - 52 Tasers 2023 4,400 - - - - 4,400 - - - - - - 53 Tasers 2024 3,300 - - - - - 3,300 - - - - - 54 Tasers 2029 4,500 - - - - - - - - - - 4,500 55 Office furniture 2020 4,000 - 4,000 - - - - - - - - - 56 Copy machine/scanner 2026 3,500 - - - - - - - 3,500 - - - 57 Police garage 2022 175,000 - - - 175,000 - - - - - - - 58 LETG upgrade 2024 35,000 - - - - - 35,000 - - - - - 59 Computer server 2021 15,000 - - 15,000 - - - - - - - - 60 - - - - - - - - - - - 61 - - - - - - - - - - - 62 - - - - - - - - - - - 63 - - - - - - - - - - - 64 - - - - - - - - - - - 65 66 Total Capital Projects 608,962 - - - 54,162 8,100 61,300 185,850 67,200 55,350 63,900 17,300 50,200 13,500 56,900 CAPITAL PROJECTS & DEBT LEVYProjected 5/14/2020 9 CITY OF LONG PRAIRIE Financial Management Plan Public Works Equipment Fund 701 Inflation Assumptions 1 Inflation Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% 2 Interest Income 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00% 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Actual Actual Actual YTD REVENUE 3 General Property Tax 0 0 0 0 0 0 0 0 0 0 4 Special assessments 0 0 0 0 0 0 0 0 0 0 5 Intergovernmental 6 Interest Earnings 27 629 581 2,268 800 (231)(104)695 202 1,394 978 888 1,647 343 7 Charges for services 0 0 0 0 0 0 0 0 0 0 8 Miscellaneous Revenue 4,725 0 0 0 0 0 0 0 0 0 0 9 Total Revenue 4,752 629 581 2,268 800 (231)(104)695 202 1,394 978 888 1,647 343 EXPENSES 10 Total Current 7,998 3,669 13,225 20,975 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 11 12 Total Capital Projects 56,994 213,156 340,599 132,000 67,100 175,000 150,000 36,000 168,000 185,000 120,000 337,000 0 13 Future debt 0 0 0 0 0 0 0 0 0 0 14 Capital lease payments 15 Existing Debt: Interest 16 Total Expenses 7,998 60,663 226,381 361,574 148,000 83,100 191,000 166,000 52,000 184,000 201,000 136,000 353,000 16,000 17 Revenues Over / (Under) Expenses (3,246)(60,034)(225,800)(359,306)(147,200)(83,331)(191,104)(165,305)(51,798)(182,606)(200,022)(135,112)(351,353)(15,657) OTHER FINANCING SOURCES / (USES) 18 Bond Proceeds 19 Sale of assets 25,000 5,000 5,000 25,000 30,000 50,000 20,000 30,000 20 Transfer In - Street Project Fund 500 175,000 21 Transfers In-Utility Funds 130,000 120,000 64,822 37,917 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 22 Transfers In-from General Fd 0 52,898 48,750 14,539 50,000 50,000 50,000 100,000 100,000 100,000 150,000 150,000 150,000 23 Transfers Out 0 0 0 0 0 0 0 0 0 0 0 0 0 22 Total Other Sources / (Uses)130,000 120,000 117,720 86,667 80,539 96,000 271,000 116,000 171,000 141,000 191,000 211,000 221,000 191,000 23 Prior Period Adjustments (607) 24 Ending Cash Balance 364,343 424,309 316,229 43,590 (23,071)(10,402)69,494 20,189 139,391 97,785 88,763 164,651 34,298 209,641CASH FLOW ANALYSISProjected 5/14/2020 10 CITY OF LONG PRAIRIE Financial Management Plan Public Works Equipment Fund 701 Inflation Assumptions 1 Inflation Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% 2 Interest Income 1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%CASH FLOW ANALYSISProject 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Capital Project Name First Year Costs 25 Pickup #1 - 2010 3/4 ton 2021 32,000 - - - 32,000 - - - - - - - 26 Pickup #2 - 2012 3/4 ton 2023 34,000 - - - - - 34,000 - - - - - 27 Pickup #3 - 2016 3/4 ton 2027 34,000 - - - - - - - - - 34,000 - 28 Pickup #4 - 2020 1/2 ton DC 2020 30,000 - - 30,000 - - - - - - - - 29 Pickup - dump - 2006 F450 2020 60,000 - - 60,000 - - - - - - - - 30 Snowplow #2 - 2009 International 2025 158,000 - - - - - - - 158,000 - - - 31 Motorgrader - 850 Dresser 2019 139,000 - 139,000 - - - - - - - - - 32 Street sweeper - 2018 2019 173,208 - 173,208 - - - - - - - - - 33 Street sweeper - 2018 2028 230,000 - - - - - - - - - - 230,000 34 Jetter/vac - 1995 2023 116,000 - - - - - 116,000 - - - - - 35 Aerial bucket truck - 1998 Ford 2024 36,000 - - - - - - 36,000 - - - - 36 Sprayer 2027 5,000 - - - - - - - - - 5,000 - 37 Bobcat/blower/sweeper 2027 51,000 - - - - - - - - - 51,000 - 38 Loader - 2011 Case 621 2026 185,000 - - - - - - - - 185,000 - - 39 Leaf vac 2021 8,100 - - - 8,100 - - - - - - - 40 Snow truck - 1999 F 750 2028 52,000 - - - - - - - - - - 52,000 41 Land Pride Mower 2021 27,000 - - - 27,000 - - - - - - - 42 Simplicity mower - 2018 2028 9,000 - - - - - - - - - - 9,000 43 2018 JD Z950R 2028 15,000 - - - - - - - - - - 15,000 44 2019 JD 1585 2028 15,000 - - - - - - - - - - 15,000 45 2019 JD 1585 2019 26,060 - 26,060 - - - - - - - - - 46 Paint Sprayer 2028 16,000 - - - - - - - - - - 16,000 47 Kubota tractor 2920 2027 30,000 - - - - - - - - - 30,000 - 48 Snogo Snowblower 2025 10,000 - - - - - - - 10,000 - - - 49 Garage 2022 175,000 - - - - 175,000 - - - - - - 50 Miller - grader 2019 11,853 - 11,853 - - - - - - - - - 51 Karcher Pressure Washer 2019 3,732 - 3,732 - - - - - - - - - 52 Bobcat Angle Broom 2019 2,371 - 2,371 - - - - - - - - - 53 Snowhauling 2019 20,975 - 20,975 - - - - - - - - - 54 - - - - - - - - - - - 55 56 57 58 Total Capital Projects - - - 377,199 90,000 67,100 175,000 150,000 36,000 168,000 185,000 120,000 337,000 - CAPITAL PROJECTS & DEBT LEVYProjected 5/14/2020 11