Page 59 - GrapevineFY24 Adopted Budget

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

REVENUE AND OTHER FUNDING SOURCES
Taxes 13,057,580 13,132,258 13,175,949 14,781,053 14,800,000 14,900,000
Transfers In 2,057,569 2,060,869 2,057,569 2,458,497 2,049,148 2,000,000
Interest & Miscellaneous 78,703 324,128 150,000 50,000 75,000 75,000
TOTAL SOURCES OF FUNDS 15,193,852 15,517,255 15,383,518 17,289,550 16,924,148 16,975,000

EXPENDITURES AND OTHER FUNDING USES
G.O. Bond Principal & Interest 8,034,132 8,080,543 7,099,543 7,378,808 7,250,000 7,000,000
Cert. of Obligation Principal & Interest 4,647,637 4,359,063 5,346,850 5,402,342 5,250,000 5,000,000
Tax Notes & Notes Payable 1,398,894 1,401,444 1,398,169 1,000,000 750,000 700,000
Fiscal Agent & Bond Fees 8,681 0 100,000 100,000 100,000
Miscellaneous Expenses 118,173 0 0 0
Transfers Out 670,738 661,919 659,556 2,881,103 2,750,000 2,500,000
TOTAL USES OF FUNDS 14,878,255 14,502,969 14,504,118 16,762,253 16,100,000 15,300,000

NET CHANGE IN FUND BALANCE 315,597 1,014,286 879,400 527,297 824,148 1,675,000

BEGINNING FUND BALANCE 6,681,805 6,997,402 6,997,402 7,876,802 8,404,099 9,228,247

ENDING FUND BALANCE 6,997,402 8,011,688 7,876,802 8,404,099 9,228,247 10,903,247

FUND BALANCE REQUIREMENT 2,934,889 2,860,860 2,861,086 3,306,527 3,175,890 3,018,082

PERCENTAGE OF COVERAGE 47% 55% 54% 50% 57% 71%

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

REVENUE AND OTHER FUNDING SOURCES
Transfers In 5,124,000 1,640,000 2,670,000 2,670,000 2,670,000 2,670,000
Interest & Miscellaneous 165,283 247,203 10,000 15,000 20,000 30,000
TOTAL SOURCES OF FUNDS 5,289,283 1,887,203 2,680,000 2,685,000 2,690,000 2,700,000

EXPENDITURES AND OTHER FUNDING USES
Facilities Capital Maintenance 277,306 832,592 700,000 721,000 742,630 764,909
Parks Capital Maintenance 572,682 1,117,324 1,162,000 1,196,860 1,232,766 1,269,749
Streets and Traffic Capital Maintenance 109,335 2,268,968 2,308,000 2,377,240 2,448,557 2,522,014
TOTAL USES OF FUNDS 959,323 4,218,884 4,170,000 4,295,100 4,423,953 4,556,672

NET CHANGE IN FUND BALANCE 4,329,960 (2,331,681) (1,490,000) (1,610,100) (1,733,953) (1,856,672)

BEGINNING FUND BALANCE 0 4,329,960 1,998,279 508,279 (1,101,821) (2,835,774)

ENDING FUND BALANCE 4,329,960 1,998,279 508,279 (1,101,821) (2,835,774) (4,692,446)

59