Page 64 - Grapevine FY22 Adopted Budget v2

LONG-RANGE FINANCIAL FORECAST - DEBT SERVICE FUND
2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025
Actual Estimated Approved Projected Projected Projected

REVENUE AND OTHER FUNDING SOURCES
Taxes 12,865,818 13,152,069 13,422,507 14,781,053 14,800,000 14,900,000
Transfers In 2,387,064 2,399,369 2,057,569 2,458,497 2,049,148 2,000,000
Interest & Miscellaneous 118,855 7,430 150,000 50,000 75,000 75,000
TOTAL SOURCES OF FUNDS 15,371,737 15,558,868 15,630,076 17,289,550 16,924,148 16,975,000

EXPENDITURES AND OTHER FUNDING USES
G.O. Bond Principal & Interest 11,257,383 10,665,083 8,034,132 7,378,808 7,250,000 7,000,000
Cert. of Obligation Principal & Interest 2,434,552 3,830,481 5,318,375 5,402,342 5,250,000 5,000,000
Tax Notes & Notes Payable 2,013,957 1,498,306 1,398,894 1,000,000 750,000 700,000
Fiscal Agent & Bond Fees 126,020 358,211 0 100,000 100,000 100,000
Payments on Future Debt Issues 0 0 0 2,881,103 2,750,000 2,500,000
TOTAL USES OF FUNDS 15,831,910 16,352,081 14,751,401 16,762,253 16,100,000 15,300,000

NET CHANGE IN FUND BALANCE (460,173) (793,213) 878,675 527,297 824,148 1,675,000

BEGINNING FUND BALANCE 7,304,467 6,844,294 6,051,081 6,929,756 7,457,053 8,281,201

ENDING FUND BALANCE 6,844,294 6,051,081 6,929,756 7,457,053 8,281,201 9,956,201

FUND BALANCE REQUIREMENT 3,123,007 3,225,616 2,909,865 3,306,527 3,175,890 3,018,082

PERCENTAGE OF COVERAGE 43% 37% 47% 44% 51% 65%

LONG-RANGE FINANCIAL FORECAST - CAPITAL / STREET MAINT. FUND
2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025
Actual Estimated Approved Projected Projected Projected

REVENUE AND OTHER FUNDING SOURCES
Transfers In 3,298,149 0 1,640,000 2,635,000 2,850,000 3,045,000
Interest & Miscellaneous 118,767 38,890 10,000 15,000 20,000 30,000
TOTAL SOURCES OF FUNDS 3,416,916 38,890 1,650,000 2,650,000 2,870,000 3,075,000

EXPENDITURES AND OTHER FUNDING USES
Facilities Capital Maintenance 517,614 185,030 850,000 400,000 420,000 425,000
Parks Capital Maintenance 2,291,184 1,005,521 800,000 1,000,000 1,100,000 1,150,000
Streets and Traffic Capital Maintenance 1,703,363 1,132,965 0 1,250,000 1,350,000 1,500,000
TOTAL USES OF FUNDS 4,512,161 2,323,516 1,650,000 2,650,000 2,870,000 3,075,000

NET CHANGE IN FUND BALANCE (1,095,245) (2,284,626) 0 0 0 0

BEGINNING FUND BALANCE 1,909,576 814,331 (1,470,295) (1,470,295) (1,470,295) (1,470,295)

ENDING FUND BALANCE 814,331 (1,470,295) (1,470,295) (1,470,295) (1,470,295) (1,470,295)

64