Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Fund #206 Cash Flow
City of Otsego Capital Equipment Revolving Fund Cash Flow Summary Revised: October 3, 2017 Revenues Property Taxes Investment Interest Sales of Fixed Assets Sales of Fixed Assets (Est.) Utility Fund Contributions Transfers In Total Expenses Capital Outlay - Streets Capital Outlay - Parks Capital Outlay (Fleet CIP) Transfers Out Total Actual 2016 3.00% 7.32% 7.69% 7.14% 6.67% 6.25% 5.88% 5.56% 5.26% 5.00% Forecast I Projection - Capital Improvement Plan 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Comments $ 168,000 $ 235,200 $ 242,256 $ 260,000 $ 280,000 $ 300,000 $ 320,000 $ 340,000 $ 360,000 $ 380,000 $ 400,000 $ 420,000 Annual $20k Increase 3,998 - - - - - - - - - - - 31,160 78,500 - - - - - - - - 84,000 - - - - - - - - 42,390 115,474 - 47,000 - - 35,000 400,000 48,000 51,240 460,212 - - - - - - - - - - - 663,370 356,090 441,730 260,000 327,000 300,000 320,000 375,000 360,000 780,000 448,000 471,240 332,546 - - - - - - 19,424 - - - - - - - - - - - - 351,712 584,531 447,700 368,100 454,600 382,320 376,600 384,095 554,800 667,290 130,408 DRAFT 2018-2027 CIP 351,970 351,712 584,531 447,700 368,100 454,600 382,320 376,600 384,095 554,800 667,290 130,408 Average = $435k Cash Balance - Beginning 302,318 613,718 618,096 475,295 287,595 246,495 91,895 29,575 27,975 3,880 229,080 9,790 Balance Sheet Effects - Revenues 663,370 356,090 441,730 260,000 327,000 300,000 320,000 375,000 360,000 780,000 448,000 471,240 Expenditures (351,970) (351,712) (584,531) (447,700) (368,100) (454,600) (382,320) (376,600) (384,095) (554,800) (667,290) (130,408) Cash Balance - Ending $ 613,718 $ 618,096 $ 475,295 $ 287,595 $ 246,495 $ 91,895 $ 29,575 $ 27,975 $ 3,880 $ 229,080 $ 9,790 $ 350,622 Interfund Receivable Capital Equipment Revolving Fund (206) 900,000 800,000 700,000 600,000 500,000 400,000 300,000 - 200,000 100,000 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Expenses Revenues --4--Cash Balance - Ending U:\Budget\2018\Cash Flows\Capital Funds 206 -Capital Equipment