Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Packet - Parks Recreation
Tuesday, November 21, 2017 PARKS - 1 City of Otsego, Minnesota Capital Improvement Plan 2018 thru 2027 PROJECTS BY FUNDING SOURCE Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total 202 - Trail Management I Trail Maintenance PARK -2018-01 n/a 30,000 30,000 Trail Maintenance PARK -2019-01 n/a 31,000 31,000 Trail Maintenance PARK -2020-01 n/a 32,000 32,000 Trail Maintenance PARK -2021-01 n/a 33,000 33,000 Trail Maintenance PARK -2022-01 n/a 34,000 34,000 Trail Maintenance PARK -2023-01 n/a 35,000 35,000 Trail Maintenance PARK -2024-01 n/a 36,000 36,000 Trail Maintenance PARK -2025-01 n/a 37,000 37,000 Trail Maintenance PARK -2026-01 n/a 38,000 38,000 Trail Maintenance PARK -2027-01 n/a 39,000 39,000 202 - Trail Management Total 30,000 31,000 32,000 33,000 34,000 35,000 36,000 37,000 38,000 39,000 345,000 GRAND TOTAL 30,000 31,000 32,000 33,000 34,000 35,000 36,000 37,000 38,000 39,000 345,000 Tuesday, November 21, 2017 City of Otsego PARKS - 2 Trail Management Fund Cash Flow Summary Revised: November 21, 2017 15.38% 3.33% 3.23% 3.13% 3.03% 2.94% 2.86% 2.78% 2.70% 2.63% Forecast Projection - Capital Improvement Plan 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Comments Revenues Property Taxes $ 26,000 $ 30,000 31,000 $ 32,000 33,000 $ 34,000 $ 35,000 $ 36,000 $ 37,000 $ 38,000 $ 39,000 Annual Increase of $1,000 Total 26,000 30,000 31,000 32,000 33,000 34,000 35,000 36,000 37,000 38,000 39,000 Expenses Engineering Capital Outlay Capital Outlay (CIP) Total Cash Balance - Beginning Balance Sheet Effects Revenues Expenditures Cash Balance - Ending 1,031 20,670 - - - - - - - - - - - 30,000 31,000 32,000 33,000 34,000 35,000 36,000 37,000 38,000 39,000 DRAFT 2018-2027 CIP 21,701 30,000 31,000 32,000 33,000 34,000 35,000 36,000 37,000 38,000 39,000 3,260 7,559 7,559 7,559 7,559 7,559 7,559 7,559 7,559 7,559 7,559 26,000 30,000 31,000 32,000 33,000 34,000 35,000 36,000 37,000 38,000 39,000 (21,701) (30,000) (31,000) (32,000) (33,000) (34,000) (35,000) (36,000) (37,000) (38,000) (39,000) $ 7,559 $ 7,559 $ 7,559 $ 7,559 $ 7,559 $ 7,559 $ 7,559 $ 7,559 $ 7,559 $ 7,559 $ 7,559 UABudget\2018\Cash Flows\Capital Funds 202 -Trail Management PARKS - 3 City of Otsego, Minnesota Capital Improvement Plan 2018 thru 2027 PROJECTS BY FUNDING SOURCE Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total �203 - Park Development I Lefebvre Creek Park PARK -2018-02 n/a 208,478 208,478 Splash Pad Rehabilitation PARK -2018-07 n/a 200,000 200,000 Wilson Preserve Boardwalk PARK -2019-02 n/a 30,000 30,000 Trail Construction - CSAH 38 PARK -2019-03 n/a 125,000 125,000 (Maciver to CSAH1 9) Trail Construction - 70th ST (CR19 PARK -2019-04 n/a 250,000 250,000 to Kittredge) Trail Construction - CSAH 39 PARK -2020-02 n/a 123,500 123,500 (Odean to CSAH42) Prairie Park Ballfield Additions PARK -2020-03 n/a 174,420 677,147 155,040 1,006,607 Prairie Park Ballfield & Soccer PARK -2023-04 n/a 1,113,600 1,113,600 Lighting Prairie Park Concession Building PARK -2024-02 n/a 280,000 280,000 Prairie Park Shelter PARK -2024-03 n/a 65,000 65,000 203 - Park Development Total 408,478 405,000 297,920 677,147 155,040 1,113,600 345,000 3,40Z 185 GRAND TOTAL 408,478 405,000 297,920 677,147 155,040 1,113,600 345,000 3,40Z 185 Tuesday, November 21, 2017 City of Otsego Park Development Fund PARKS - 4 Cash Flow Summary Revised: November 21, 2017 Forecast Projection - Capital Improvement Plan 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Comments Revenues Park Dedication Fees $ 1,165,374 $ 174,300 $ 174,300 174,300 $ 174,300 174,300 $ 174,300 174,300 $ 174,300 $ 174,300 $ 174,300 50 New Plats at 2017 Rate ($3,486) Total 1,165,374 174,300 174,300 174,300 174,300 174,300 174,300 174,300 174,300 174,300 174,300 Expenses 2,000,000 1,500,000 1,000,000 500,000 Engineering 17,196 (500,000) (1,000,000) Expenses --*--Cash Balance - Ending Other Charges & Services 26,920 Capital Outlay 213,028 - - - - - - - Capital Outlay (CIP) - 208,478 405,000 297,920 677,147 155,040 1,113,600 345,000 DRAFT 2018-2027 CIP Total 257,144 208,478 405,000 297,920 677,147 155,040 1,113,600 345,000 Cash Balance - Beginning 502,973 1,411,203 1,377,025 1,146,325 1,022,705 519,858 539,118 (400,182) (570,882) (396,582) (222,282) Balance Sheet Effects Revenues 1,165,374 174,300 174,300 174,300 174,300 174,300 174,300 174,300 174,300 174,300 174,300 Expenditures (257,144) (208,478) (405,000) (297,920) (677,147) (155,040) (1,113,600) (345,000) - - - Cash Balance - Ending $ 2,412,203 $ 1,377,025 $ 1,146,325 $ 1,022,705 $ 519,858 $ 539,118 $ (400,182) $ (570,882) $ (396,582) $ (222,282) $ (47,982) Park Development Fund (203) 2,000,000 1,500,000 1,000,000 500,000 2017 2018 2019 2020 2021 2022 Nl.�0�23 2024 2025 2077 (500,000) (1,000,000) Expenses --*--Cash Balance - Ending UABudget\2018\Cash Flows\Capital Funds 203 -Park Development Tuesday, November 21, 2017 PARKS - 5 City of Otsego, Minnesota Capital Improvement Plan 2018 thru 2027 PROJECTS BY FUNDING SOURCE Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total 205 - Park Capital Equipment I Playground Replacement - Prairie PARK -2023-02 n/a 240,000 240,000 Park Playground Replacement - School PARK -2023-03 n/a 75,000 75,000 Knoll Park Playground Replacement - Future PARK -2027-02 n/a 819,930 819,930 (2029-2041) 205 - Park Capital Equipment Total 315,000 819,930 1,134,930 GRAND TOTAL 315,000 819,930 1,134,930 Tuesday, November 21, 2017 City of Otsego Park Equipment Fund PARKS - 6 Cash Flow Summary Revised: November 21, 2017 1.82% 1.79% 1.75% 1.72% 1.69% 1.67% 1.64% 1.61% 1.59% 1.56% Forecast Projection - Capital Improvement Plan 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Comments Revenues Property Taxes $ 55,000 $ 56,000 $ 57,000 $ 58,000 59,000 $ 60,000 $ 61,000 $ 62,000 $ 63,000 $ 64,000 $ 65,000 Annual Increase of $1,000 Miscellaneous 1,479 - - - - - - - - - - Total 56,479 56,000 57,000 58,000 59,000 60,000 61,000 62,000 63,000 64,000 65,000 Expenses Capital Outlay Capital Outlay (CIP) Total Cash Balance - Beginning Balance Sheet Effects Revenues Expenditures Cash Balance - Ending 39,315 - - Warming House / Court Repairs - 315,000 819,930 DRAFT 2018-2027 CIP 39,315 - - - - - 315,000 - - - 819,930 230,895 248,059 304,059 361,059 419,059 478,059 538,059 284,059 346,059 409,059 473,059 56,479 56,000 57,000 58,000 59,000 60,000 61,000 62,000 63,000 64,000 65,000 (39,315) - - - - - (315,000) - - - (819,930) $ 248,059 $ 304,059 361,059 $ 419,059 $ 478,059 $ 538,059 $ 284,059 $ 346,059 $ 409,059 $ 473,059 $ (281,871) UABudget\2018\Cash Flows\Capital Funds 205 -Park Equipment Tuesday, November 21, 2017 PARKS - 7 City of Otsego, Minnesota Capital Improvement Plan 2018 thru 2027 PROJECTS BY FUNDING SOURCE Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total 208 - Community Facilities I Norin Landing PARK -2016-03 n/a 581,751 581,751 208 - Community Facilities Total 581,751 581,751 GRAND TOTAL 581,751 581,751 Tuesday, November 21, 2017 :ity of Otsego :ommunity Facilities Fund :ash Flow Summary Revised: November 21, 2017 Expenses Engineering 4,068 8,286 Capital Outlay - General - - Capital Outlay - Streets - - Capital Outlay - Parks 19,322 17,224 - Capital Outlay (Parks CIP) - 581,751 - Transfers Out - - - 100,000 Total 23,390 25,510 581,751 100,000 PARKS - 8 Comments TRSA Committed to $100k (Last Year is 2021) DNR Grant Cost Estimates - Subject to Change with Bids Transfer of TRSA Donations Cash Balance - Beginning Actual Forecast 471,720 Projection - Capital Improvement Plan Balance Sheet Effects 2016 2017 2018 2019 2020 2021 Revenues 13,809 10,000 160,000 10,000 10,000 10,000 Investment Interest $ 3,809 $ - $ - $ - $ - $ TRSA Donation 10,000 10,000 10,000 10,000 10,000 10,000 Intergovernmental - - 150,000 - - - Miscellaneous - Transfers In - - - - - - Total 13,809 10,000 160,000 10,000 10,000 10,000 Expenses Engineering 4,068 8,286 Capital Outlay - General - - Capital Outlay - Streets - - Capital Outlay - Parks 19,322 17,224 - Capital Outlay (Parks CIP) - 581,751 - Transfers Out - - - 100,000 Total 23,390 25,510 581,751 100,000 PARKS - 8 Comments TRSA Committed to $100k (Last Year is 2021) DNR Grant Cost Estimates - Subject to Change with Bids Transfer of TRSA Donations Cash Balance - Beginning 484,556 487,230 471,720 49,969 59,969 69,969 Balance Sheet Effects 12,255 Revenues 13,809 10,000 160,000 10,000 10,000 10,000 Expenditures (23,390) (25,510) (581,751) - - (100,000) Cash Balance - Ending $ 487,230 471,720 $ 49,969 59,969 69,969 (20,031) Current Funding Shortfall for Norin Landing U:\Budget\2018\Cash Flows\Capital Funds 208 -Comm Facilities Source # Priority 2018 City of Otsego, Minnesota Capital Improvement Plan 2018 thru 2027 PROJECTS BY FUNDING SOURCE 2019 2020 2021 2022 2023 2024 2025 PARKS - 9 2026 2027 Total 202 - Trail Management I Trail Maintenance PARK -2018-01 n/a 30,000 30,000 Trail Maintenance PARK -2019-01 n/a 31,000 31,000 Trail Maintenance PARK -2020-01 n/a 32,000 32,000 Trail Maintenance PARK -2021-01 n/a 33,000 33,000 Trail Maintenance PARK -2022-01 n/a 34,000 34,000 Trail Maintenance PARK -2023-01 n/a 35,000 35,000 Trail Maintenance PARK -2024-01 n/a 36,000 36,000 Trail Maintenance PARK -2025-01 n/a 37,000 37,000 Trail Maintenance PARK -2026-01 n/a 38,000 38,000 Trail Maintenance PARK -2027-01 n/a 39,000 39,000 202 - Trail Management Total 30,000 31,000 32,000 33,000 34,000 35,000 36,000 37,000 38,000 39,000 345,000 !203 - Park Development Lefebvre Creek Park PARK -2018-02 n/a 208,478 208,478 Wilson Preserve Boardwalk PARK -2019-02 n/a 30,000 30,000 Trail Construction - CSAH 38 PARK -2019-03 n/a 125,000 125,000 (Maciver to CSAH 19) Trail Construction - 70th ST (CR19 PARK -2019-04 n/a 250,000 250,000 to Kittredge) Trail Construction - CSAH 39 PARK -2020-02 n/a 123,500 123,500 (Odean to CSAH42) Prairie Park Ballfield Additions PARK -2020-03 n/a 174,420 677,147 155,040 1,006,607 Prairie Park Ballfield & Soccer PARK -2023-04 n/a 1,113,600 1,113,600 Lighting Prairie Park Concession Building PARK -2024-02 n/a 280,000 280,000 Prairie Park Shelter PARK -2024-03 n/a 65,000 65,000 203 - Park Development Total 208,478 405,000 297,920 677,147 155,040 1,113,600 345,000 3,202,185 Wednesday, November 22, 2017 Wednesday, November 22, 2017 PARKS - 10 Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total �205 - Park Capital Equipment I Playground Replacement - Prairie PARK -2023-02 n1a 240,000 240,000 Park Playground Replacement - School PARK -2023-03 n/8 75,000 75,000 Knoll Park Playground Replacement - Future PARK -2027-02 n/a 819,930 819,930 (2029-2041) 205 - Park Capital Equipment Total 315,000 819,930 1,134,930 �208 - Community Facilities Norin Landing PARK -2018-03 n/a 581,751 581,751 208 - Community Facilities Total 581,751 581,751 �414 - Capital Improvements. CSAH 38 Trail Construction (Odean PARK -2018-04 n1a 187,419 187,419 toTH101) Carrick Waterfront Park Landscaping PARK -2018-05 n/a 35,000 35,000 Historic Park Signage PARK -2018-06 n/a 10,109 10,109 414 - Capital Improvements Total 232,528 232,528 GRAND TOTAL 1,052,757 436,000 329,920 710,147 189,040 1,463,600 381,000 37,000 38,000 858,930 5,496,394 Wednesday, November 22, 2017