Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
6c. 404 CIP Spreadsheet - Updated
CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund Inflation Assumptions 4 CIP Inflation Factor 4.00% 0.00% 2.00% 4.00% 4.00% 4.00%4.00% 4.00% 4.00% 4.00% 4.00% 2022 2023 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 ACTUAL Proposed ACTUAL REVENUE 5 Property taxes 20,000 20,000 60,000 62,400 64,896 67,492 70,192 72,999 75,919 78,956 82,114 6 Intergovernmental 10,125 112,500 7 Charges for services 8 Investment Income 620 66 66 66 66 66 66 66 66 66 66 9 Sale of capital assets 10 Park Dedication Fees 21,000 - - - - - - - - - 11 Rental and lease income - - - - - - - - - - - Transfer from General Fund 200,000 12 Miscellaneous Revenue 7,949 8,068 5,000 5,075 5,151 5,228 5,307 5,386 5,467 5,549 5,632 13 Total Revenue 38,694 361,634 65,066 67,541 70,113 72,786 75,564 78,451 81,452 84,571 87,812 EXPENSES 14 Total Current 15 Debt service 16 Total Capital Projects 48,113 352,125 150,000 49,000 128,009 64,042 - - 17 Total Expenses 48,113 352,125 150,000 49,000 128,009 64,042 - - - - - 18 Revenue Over / (Under) Expenses (9,419) 9,509 (84,934) 18,541 (57,896) 8,744 75,564 78,451 81,452 84,571 87,812 OTHER FINANCING SOURCES / (USES) 19 Bond Proceeds 20 Transfers In 21 Transfers Out 8,000 22 Transfers Out- 22 Total Other Sources / (Uses) - 8,000 - - - - - - - - - 23 Prior Period Adjustments 24 Ending Fund Balance 138,798 140,306 140,306 55,372 73,912 16,016 24,760 100,324 178,775 260,227 344,797 432,610 CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund 404 CASH FLOW ANALYSIS 2021 2016 2022 2023 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Capital Project Name Year Costs ACTUAL Proposed ACTUAL 25 25 Park Planning 2022 15000 10,500 4,500 26 Community Center Park-concrete, grill, table, benches 2022 112500 33,488 27 Playground Equipment - Community Center Park 2022 122500 180,319 28 Lilleskogen Park Picnic Shelter 2024 43700 3,000 29 Gateway Trail Improvements @ Annex 2024 0 50,000 30 Hay Lake Park - sign 2023 8653 8,653 31 Park signage at Orwell Park (Liten)2023 8653 8,653 32 Replace rink boards 2024 134984 150,000 33 Lilleskogen Praire/Wetland Restoration Project 2025 12878 1,125 34 Nature park trails 2025 42700 49,000 35 Playground Equipment - Erickson ballfield 2025 66682 78,009 36 Tennis Court/Pickle Ball - repaint 2024 60533 150,000 37 Expanded Pleasure Rink 2027 12653 16,010 38 Hay Lake Park Shelter water & doors 2027 101226 128,083 39 New Ballfield to Replace South Ball Field 2027 44286 56,036 40 Settlers MonutPossible Reloc/Imp 2027 37960 48,032 41 CIP Place Holder 2031 50000 42 Total Capital Projects 874,908 - 48,113 352,125 150,000 49,000 128,009 64,042 128,083 56,036 - - - PROJECTED NEW DEBT TERMS 43 Par Amount (Line 19) - - - - - - - - - - - - 44 Number of Years 10 10 10 10 10 10 10 10 10 10 10 10 45 Interest Rate 2.00% 2.50% 3.00% 3.00% 3.00% 3.00%3.00% 3.00% 3.00% 3.00% 3.00% 46 New Debt Levy 0 0 0 0 0 0 0 0 0 0 0 0CAPITAL OUTLAYProject CAPITAL OUTLAY