Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
3-SRF Cash Flows
City of OtsegoInsurance Reserves FundCash Flow SummaryRevised: June 3, 2021Actual Actual Actual Actual Actual Actual Actual Actual Actual Forecast2012 2013 2014 2015 2016 2017 2018 2019 2020 2021RevenuesRefunds & Reimbursements20,007$ 14,114$ 17,824$ 26,204$ 42,751$ 11,013$ 5,344$ 6,864$ 12,471$ ‐$ Investment Interest1,377 (637) 1,413 609 1,011 1,645 2,798 7,232 6,564 ‐ Miscellaneous‐ 22,167 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers In‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total21,384 35,644 19,237 26,813 43,762 12,658 8,142 14,096 19,035 ‐ ExpensesSupplies‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Other Charges & Services14,582 20,197 20,823 ‐ ‐ ‐ ‐ 11,596 ‐ ‐ Capital Outlay‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Capital Outlay (CIP)‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers Out‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total14,582 20,197 20,823 ‐ ‐ ‐ ‐ 11,596 ‐ ‐ Cash Balance ‐ Beginning92,603 102,879 102,721 101,833 128,646 172,408 185,066 193,208 195,708 214,743 Balance Sheet Effects3,474 (15,605) 698 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Revenues21,384 35,644 19,237 26,813 43,762 12,658 8,142 14,096 19,035 ‐ Expenditures(14,582) (20,197) (20,823) ‐ ‐ ‐ ‐ (11,596) ‐ ‐ Cash Balance ‐ Ending102,879$ 102,721$ 101,833$ 128,646$ 172,408$ 185,066$ 193,208$ 195,708$ 214,743$ 214,743$ X:\Budget\2022\Cash Flows\Special Revenue Funds204-Insurance ReserveItem 3.2 City of OtsegoVireo Health Donations FundCash Flow SummaryRevised: June 3, 2021Actual Actual Actual Actual Actual Forecast2016 2017 2018 2019 2020 2021RevenuesDonations 20,000$ ‐$ ‐$ 20,000$ ‐$ ‐$ Investment Interest ‐ 191 276 538 909 ‐ Rain Barrel Sales‐ ‐ 2,096 2,580 1,440 ‐ Transfers In‐ ‐ ‐ ‐ ‐ ‐ Total20,000 191 2,372 23,118 2,349 ‐ ExpensesSupplies‐ ‐ 10,322 7,327 2,339 ‐ Other Charges & Services‐ ‐ ‐ ‐ ‐ ‐ Capital Outlay‐ ‐ ‐ ‐ ‐ ‐ Capital Outlay (CIP)‐ ‐ ‐ ‐ ‐ ‐ Transfers Out‐ ‐ ‐ ‐ ‐ ‐ Total‐ ‐ 10,322 7,327 2,339 ‐ Cash Balance ‐ Beginning‐ 20,000 20,191 12,241 28,032 28,042 Balance Sheet Effects‐ ‐ ‐ ‐ ‐ ‐ Revenues20,000 191 2,372 23,118 2,349 ‐ Expenditures‐ ‐ (10,322) (7,327) (2,339) ‐ Cash Balance ‐ Ending20,000$ 20,191$ 12,241$ 28,032$ 28,042$ 28,042$ X:\Budget\2022\Cash Flows\Special Revenue Funds215-Vireo HealthItem 3.2 City of OtsegoStreet Light DistrictCash Flow Summaryvised: June 3, 2021Actual Actual Actual Actual Actual Actual Actual Actual Actual Forecast2012 2013 2014 2015 2016 2017 2018 2019 2020 2021RevenuesCharges for Services 24,209$ 34,889$ 34,476$ 27,006$ 12,401$ 11,323$ ‐$ ‐$ ‐$ ‐$ Development Fees ‐ ‐ ‐ ‐ 7,400 ‐ ‐ 4,181 55,650 ‐ Investment Interest692 ‐ 1,223 623 903 1,117 1,293 3,150 2,824 ‐ Miscellaneous ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers In ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 24,901 34,889 35,699 27,629 20,704 12,440 1,293 7,331 58,474 ‐ ExpensesPersonal Servcies 511 796 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Supplies 111 524 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Utility Fees 10,474 10,713 9,683 9,500 9,326 10,384 ‐ ‐ ‐ ‐ Services & Other Charges 587 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ 7,400 ‐ 35,000 31,800 26,500 ‐ Capital Outlay (CIP) ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers Out‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total11,683 12,033 9,683 9,500 16,726 10,384 35,000 31,800 26,500 ‐ Cash Balance ‐ Beginning39,142 52,360 71,527 95,889 110,670 116,431 118,589 89,513 65,044 97,266 Balance Sheet Effects(3,689) (1,654) (3,348) 1,783 102 4,631 ‐ 248 ‐ Revenues24,901 34,889 35,699 27,629 20,704 12,440 1,293 7,331 58,474 ‐ Expenditures(11,683) (12,033) (9,683) (9,500) (16,726) (10,384) (35,000) (31,800) (26,500) ‐ Cash Balance ‐ Ending52,360$ 71,527$ 95,889$ 110,670$ 116,431$ 118,589$ 89,513$ 65,044$ 97,266$ 97,266$ Item 3.2 City of OtsegoDevelopment Revolving FundCash Flow Summaryvised: June 3, 2021Actual Actual Actual Actual Actual Actual Actual Actual Actual Forecast2012 2013 2014 2015 2016 2017 2018 2019 2020 2021RevenuesProperty Taxes 14,879$ 16,764$ 22,911$ 23,000$ 88,814$ 81,385$ 65,546$ 60,816$ 56,491$ 45,874$ Investment Interest‐ (674) 3,730 1,710 2,285 2,829 5,300 13,669 12,426 ‐ Conduit Debt Issuance Fees ‐ 53,000 83,000 ‐ ‐ 50,000 ‐ ‐ ‐ ‐ Transfers In 150,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 164,879 69,090 109,641 24,710 91,099 134,214 70,846 74,485 68,917 45,874 ExpensesAbatement ‐ Boondox‐ 2,000 6,000 2,600 ‐ ‐ ‐ ‐ ‐ ‐ Abatement ‐ Gateway 2nd 14,879 16,593 15,999 15,155 14,930 14,904 ‐ ‐ ‐ ‐ Abatement ‐ Family Speech ‐ ‐ 2,338 5,130 4,721 4,713 4,551 3,548 ‐ ‐ Abatement ‐ Gateway 3rd ‐ ‐ ‐ ‐ 62,280 61,620 58,751 56,491 54,985 45,874 Services & Other Charges ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 100,000 Total 14,879 18,593 24,337 22,885 81,931 81,237 63,302 60,039 54,985 145,874 Cash Balance ‐ Beginning‐ 164,879 216,259 285,615 287,322 296,490 349,467 357,011 371,457 385,389 Balance Sheet Effects 14,879 883 (15,948) (118) ‐ ‐ ‐ ‐ ‐ Revenues 164,879 69,090 109,641 24,710 91,099 134,214 70,846 74,485 68,917 45,874 Expenditures (14,879) (18,593) (24,337) (22,885) (81,931) (81,237) (63,302) (60,039) (54,985) (145,874) Cash Balance ‐ Ending164,879$ 216,259$ 285,615$ 287,322$ 296,490$ 349,467$ 357,011$ 371,457$ 385,389$ 285,389$ Item 3.2 City of OtsegoTax Increment District No. 1Great River CenterCash Flow Summaryvised: June 3, 2021Actual Actual Actual Forecast2018 2019 2020 2021 2022 2023 2024 2025 2026 2027RevenuesTax Increments 96,938$ 97,419$ 98,016$ 94,744$ 94,744$ 94,744$ 94,744$ 94,744$ 94,744$ ‐$ Investment Interest‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Miscellaneous ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers In ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 96,938 97,419 98,016 94,744 94,744 94,744 94,744 94,744 94,744 ‐ ExpensesPersonal Services 476 482 505 500 500 500 500 500 500 500 Services & Other Charges 2,064 908 851 2,500 2,500 2,500 2,500 2,500 2,500 2,500 PAYGO Note Payment 43,622 87,461 87,946 85,270 85,270 85,270 85,270 85,270 85,270 47,372 Transfers Out ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 46,162 88,851 89,302 88,270 88,270 88,270 88,270 88,270 88,270 50,372 Cash Balance ‐ Beginning(17,178) 33,598 42,166 50,880 57,354 63,829 70,303 76,778 83,252 89,726 Balance Sheet Effects‐ ‐ Revenues96,938 97,419 98,016 94,744 94,744 94,744 94,744 94,744 94,744 ‐ Expenditures(46,162) (88,851) (89,302) (88,270) (88,270) (88,270) (88,270) (88,270) (88,270) (50,372) Cash Balance ‐ Ending33,598$ 42,166$ 50,880$ 57,354$ 63,829$ 70,303$ 76,778$ 83,252$ 89,726$ 39,354$ ProjectedItem 3.2 City of OtsegoTax Increment District No. 3Riverview LandingCash Flow Summaryvised: June 3, 2021Actual Forecast2020 2021 2022 2023 2024 2025 2026 2027 2028 2029RevenuesTax Increments 168,042$ 175,868$ 175,868$ 175,868$ 175,868$ 175,868$ 175,868$ 175,868$ 175,868$ 175,868$ Investment Interest‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Miscellaneous ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers In ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 168,042 175,868 175,868 175,868 175,868 175,868 175,868 175,868 175,868 175,868 ExpensesPersonal Services 729 500 500 500 500 500 500 500 500 500 Services & Other Charges 851 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 PAYGO Note Payment 75,619 158,281 158,281 158,281 158,281 158,281 158,281 158,281 158,281 158,281 Transfers Out ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 77,199 161,281 161,281 161,281 161,281 161,281 161,281 161,281 161,281 161,281 Cash Balance ‐ Beginning(1,634) 89,209 103,796 118,383 132,969 147,556 162,143 176,730 191,317 205,903 Balance Sheet EffectsRevenues168,042 175,868 175,868 175,868 175,868 175,868 175,868 175,868 175,868 175,868 Expenditures(77,199) (161,281) (161,281) (161,281) (161,281) (161,281) (161,281) (161,281) (161,281) (161,281) Cash Balance ‐ Ending89,209$ 103,796$ 118,383$ 132,969$ 147,556$ 162,143$ 176,730$ 191,317$ 205,903$ 220,490$ ProjectedItem 3.2 City of OtsegoTax Increment District No. 4Riverbend NorthCash Flow Summaryvised: June 3, 2021Actual Forecast2020 2021 2022 2023 2024 2025 2026 2027 2028 2029RevenuesTax Increments 9,387$ 21,800$ 151,384$ 243,250$ 243,250$ 243,250$ 243,250$ 243,250$ 243,250$ 243,250$ Investment Interest‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Miscellaneous ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers In ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 9,387 21,800 151,384 243,250 243,250 243,250 243,250 243,250 243,250 243,250 ExpensesPersonal Services 640 500 500 500 500 500 500 500 500 500 Services & Other Charges 1,248 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 PAYGO Note Payment (A) ‐ 5,178 71,907 115,544 115,544 115,544 115,544 115,544 115,544 115,544 PAYGO Note Payment (B) ‐ 5,178 71,907 71,648 71,648 71,648 71,648 71,648 71,648 71,648 PAYGO Note Payment (B2) ‐ ‐ ‐ 43,479 43,479 43,479 43,479 43,479 43,479 43,479 Transfers Out ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total1,888 13,355 146,815 233,671 233,671 233,671 233,671 233,671 233,671 233,671 Cash Balance ‐ Beginning(1,233) 6,663 15,108 19,677 29,256 38,836 48,415 57,994 67,573 77,153 Balance Sheet Effects397 Revenues9,387 21,800 151,384 243,250 243,250 243,250 243,250 243,250 243,250 243,250 Expenditures(1,888) (13,355) (146,815) (233,671) (233,671) (233,671) (233,671) (233,671) (233,671) (233,671) Cash Balance ‐ Ending6,663$ 15,108$ 19,677$ 29,256$ 38,836$ 48,415$ 57,994$ 67,573$ 77,153$ 86,732$ ProjectedItem 3.2