Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Street Funds - Cash Flows
City of Otsego Pavement Management Fund Cash Flow Summary Revised: November 8, 2017 Revenues Property Taxes Intergovernmental (MSA) Intergovernmental (LGA) Special Assessments (Levied) Special Assessments (Future) Transfers In Total Expenses Capital Outlay (CIP-Maintenance) Capital Outlay (CIP-Renewal) Total Cash Balance - Beginning Balance Sheet Effects Revenues Expenditures Cash Balance - Ending 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 Forecast 2017 26.06% 33.33% 25.00% 0.00% 10.00% 0.00% 9.09% 0.00% 8.33% 0.00% I Projection - Capital Improvement Plan 1 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Comments $ 475,960 $ 600,000 $ 800,000 $ 1,000,000 $ 1,000,000 $ 1,100,000 $ 1,100,000 $ 1,200,000 $ 1,200,000 $ 1,300,000 $ 1,300,000 DRAFT 2018-2027 CIP 196,495 197,477 198,465 199,457 200,454 201,457 202,464 203,476 204,494 205,516 206,544 MSA Maintenance (1/2% Annual Inflation) 129,104 143,430 143,430 143,430 143,430 143,430 143,430 143,430 143,430 143,430 143,430 LGA (Subject to Legislative Actions) 13,310 27,099 26,428 25,757 25,087 24,416 23,745 23,074 22,403 16,641 10,959 Existing levied assessments - - 30,206 110,040 139,743 136,189 133,167 182,799 198,967 211,052 249,364 Assessments on future projects 1,074,567 - - - - - - - - - - 1,889,436 968,006 1,198,529 1,478,684 1,508,714 1,605,492 1,602,806 1,752,779 1,769,294 1,876,639 1,910,297 400,768 829,920 658,484 1,202,843 622,151 627,737 469,456 622,869 1,036,622 818,701 1,827,774 DRAFT 2018-2027 CIP 216,512 454,226 1,501,162 1,428,907 250,751 594,319 1,458,143 316,671 263,103 465,533 186,703 DRAFT 2018-2027 CIP 617,280 1,284,146 2,159,646 2,631,750 872,902 1,222,056 1,927,599 939,540 1,299,725 1,284,234 2,014,47T- Average = $1,563,608 470,794 1,742,950 1,426,810 465,693 (687,372) (51,560) 331,876 7,083 820,322 1,289,891 1,882,296 1,889,436 968,006 1,198,529 1,478,684 1,508,714 1,605,492 1,602,806 1,752,779 1,769,294 1,876,639 1,910,297 (617,280) (1,284,146) (2,159,646) (2,631,750) (872,902) (1,222,056) (1,927,599) (939,540) (1,299,725) (1,284,234) (2,014,477) 1,742,950 $ 1,426,810 465,693 $ (687,372) (51,560) $ 331,876 7,083 $ 820,322 1,289,891 $ 1,882,296 1,778,116 Pavement Management Fund (201) 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 � CIP - Maintenance CIP - Renewal -4-Revenues U:\Budget\2018\Cash Flows\Capital Funds 201 -Pavement Management City of Otsego 829,920 658,484 1,202,843 622,151 627,737 469,456 622,869 1,036,622 818,701 1,827,774 216,512 Pavement Management Fund 353,288 1,428,907 250,751 594,319 1,458,143 316,671 263,103 465,533 186,703 - Cash Flow Summary 192,639 192,639 192,639 192,639 192,639 192,639 192,639 192,639 192,639 617,280 2,432,020 Revised: November 8, 2017 2,824,389 26.06% 33.33% 25.00% 0.00% 10.00% 0.00% 9.09% 0.00% 8.33% 0.00% Forecast Projection - Capital Improvement Plan 470,794 1,742,950 1,881,036 1,951,481 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Revenues Property Taxes $ 475,960 $ 600,000 $ 800,000 1,000,000 $ 1,000,000 $ 1,100,000 $ 1,100,000 $ 1,200,000 $ 1,200,000 $ 1,300,000 $ 1,300,000 Intergovernmental (MSA) 196,495 197,477 198,465 199,457 200,454 201,457 202,464 203,476 204,494 205,516 206,544 Intergovernmental (LGA) 129,104 143,430 143,430 143,430 143,430 143,430 143,430 143,430 143,430 143,430 143,430 Special Assessments (Levied) 13,310 27,099 26,428 25,757 25,087 24,416 23,745 23,074 22,403 16,641 10,959 Special Assessments (Future) - - 106,533 108,146 137,849 134,295 131,273 180,905 197,074 209,158 247,470 Debt Issuance - 1,602,100 - - - - - - - - - Transfers In 1,074,567 - - - - - - - - - - Total 1,889,436 2,570,106 1,274,856 1,476,790 1,506,820 1,603,598 1,600,912 1,750,885 1,767,401 1,874,745 1,908,403 Expenses Capital Outlay (CIP-Maintenance) Capital Outlay (CIP-Renewal) Debt Service Total Cash Balance - Beginning Balance Sheet Effects Revenues Expenditures Cash Balance - Ending 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 S00,000 400,768 829,920 658,484 1,202,843 622,151 627,737 469,456 622,869 1,036,622 818,701 1,827,774 216,512 1,602,100 353,288 1,428,907 250,751 594,319 1,458,143 316,671 263,103 465,533 186,703 - - 192,639 192,639 192,639 192,639 192,639 192,639 192,639 192,639 192,639 617,280 2,432,020 1,204,411 2,824,389 1,065,541 1,414,695 2,120,238 1,132,179 1,492,364 1,476,873 2,207,116 470,794 1,742,950 1,881,036 1,951,481 603,883 1,045,162 1,234,065 714,739 1,333,445 1,608,482 2,006,354 1,889,436 2,570,106 1,274,856 1,476,790 1,506,820 1,603,598 1,600,912 1,750,885 1,767,401 1,874,745 1,908,403 (617,280) (2,432,020) (1,204,411) (2,824,389) (1,065,541) (1,414,695) (2,120,238) (1,132,179) (1,492,364) (1,476,873) (2,207,116) $ 1,742,950 $ 1,881,036 $ 1,951,481 $ 603,883 $ 1,045,162 $ 1,234,065 $ 714,739 $ 1,333,445 $ 1,608,482 $ 2,006,354 $ 1,707,641 2017 Pavement Management Fund (201) 2018 2019 2020 2021 CIP - Maintenance 2022 2023 2024 2025 2026 2027 CIP - Renewal --$-Revenues Comments MSA Maintenance (1/2% Annual Inflation) LGA (Subject to Legislative Actions) Existing levied assessments Assessments on future projects 10 Year Bond - Interest at 3.50% DRAFT 2018-2027 CIP DRAFT 2018-2027 CIP Average = $1,736,983 U:\Budget\2018\Cash Flows\Capital Funds 201 -With Bonds City of Otsego Collector Streets Reconstruction Fund Cash Flow Summary Revised: November 8, 2017 Cash Balance - Beginning 841,175 1,303,713 1,391,735 1,479,562 1,567,193 1,654,628 1,741,867 1,828,910 1,912,260 1,995,610 2,078,960 Balance Sheet Effects Revenues 462,538 88,022 87,827 87,631 87,435 87,239 87,043 83,350 83,350 83,350 83,350 Expenditures - - - - - - - - - - - Cash Balance - Ending $ 1,303,713 $ 1,391,735 $ 1,479,562 $ 1,567,193 $ 1,654,628 $ 1,741,867 $ 1,828,910 $ 1,912,260 $ 1,995,610 $ 2,078,960 $ 2,162,310 Collector Streets Reconstruction Fund (209) 2,500,000 - 2,000,000 1,500,000 1,000,000 500,000 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 � Expenses Revenues -4--Cash Balance - Ending U:\Budget\2018\Cash Flows\Capital Funds 209 -Collector Streets Forecast I Projection - Capital Improvement Plan 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Comments Revenues Development Fees $ 457,670 $ 83,350 $ 83,350 $ 83,350 $ 83,350 $ 83,350 $ 83,350 $ 83,350 $ 83,350 $ 83,350 $ 83,350 50 New Plats at Avg. 2017 Rate ($1,667) Special Assessments (Levied) 4,868 4,672 4,477 4,281 4,085 3,889 3,693 - - - - Existing levied assessments Total 462,538 88,022 87,827 87,631 87,435 87,239 87,043 83,350 83,350 83,350 83,350 Expenses Other Charges & Services - - - - - - - - - - - Capital Outlay - - - - - - - - - - - Capital Outlay (CIP) - - - - - - - - - - - DRAFT 2018-2027 Cl P Transfers Out - - - - - - - - - - - Total - - - - - - - - - - - Cash Balance - Beginning 841,175 1,303,713 1,391,735 1,479,562 1,567,193 1,654,628 1,741,867 1,828,910 1,912,260 1,995,610 2,078,960 Balance Sheet Effects Revenues 462,538 88,022 87,827 87,631 87,435 87,239 87,043 83,350 83,350 83,350 83,350 Expenditures - - - - - - - - - - - Cash Balance - Ending $ 1,303,713 $ 1,391,735 $ 1,479,562 $ 1,567,193 $ 1,654,628 $ 1,741,867 $ 1,828,910 $ 1,912,260 $ 1,995,610 $ 2,078,960 $ 2,162,310 Collector Streets Reconstruction Fund (209) 2,500,000 - 2,000,000 1,500,000 1,000,000 500,000 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 � Expenses Revenues -4--Cash Balance - Ending U:\Budget\2018\Cash Flows\Capital Funds 209 -Collector Streets