Page 60 - Grapevine FY23 Adopted Budget (1)

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

REVENUE AND OTHER FUNDING SOURCES
Taxes 13,152,069 13,224,889 13,171,524 14,781,053 14,800,000 14,900,000
Transfers In 2,399,369 2,057,569 2,060,869 2,458,497 2,049,148 2,000,000
Interest & Miscellaneous 7,430 31,389 150,000 50,000 75,000 75,000
TOTAL SOURCES OF FUNDS 15,558,868 15,313,847 15,382,393 17,289,550 16,924,148 16,975,000

EXPENDITURES AND OTHER FUNDING USES
G.O. Bond Principal & Interest 10,665,083 8,034,132 8,080,543 7,378,808 7,250,000 7,000,000
Cert. of Obligation Principal & Interest 3,830,481 4,030,062 4,359,063 5,402,342 5,250,000 5,000,000
Tax Notes & Notes Payable 1,498,306 2,016,469 1,401,444 1,000,000 750,000 700,000
Fiscal Agent & Bond Fees 358,211 125,547 0 100,000 100,000 100,000
Transfers Out 0 670,738 661,919 2,881,103 2,750,000 2,500,000
TOTAL USES OF FUNDS 16,352,081 14,876,948 14,502,969 16,762,253 16,100,000 15,300,000

NET CHANGE IN FUND BALANCE (793,213) 436,899 879,424 527,297 824,148 1,675,000

BEGINNING FUND BALANCE 6,844,294 6,051,081 6,051,081 6,930,505 7,457,802 8,281,950

ENDING FUND BALANCE 6,051,081 6,487,980 6,930,505 7,457,802 8,281,950 9,956,950

FUND BALANCE REQUIREMENT 3,225,616 2,934,631 2,860,860 3,306,527 3,175,890 3,018,082

PERCENTAGE OF COVERAGE 37% 44% 48% 44% 51% 65%

LONG-RANGE FINANCIAL FORECAST - CAPITAL / STREET MAINT. FUND

2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2026
Actual Estimated Approved Projected Projected Projected

REVENUE AND OTHER FUNDING SOURCES
Transfers In 2,290,841 1,640,000 1,640,000 2,635,000 2,850,000 3,045,000
Interest & Miscellaneous 38,890 10,000 10,000 15,000 20,000 30,000
TOTAL SOURCES OF FUNDS 2,329,731 1,650,000 1,650,000 2,650,000 2,870,000 3,075,000

EXPENDITURES AND OTHER FUNDING USES
Facilities Capital Maintenance 498,465 850,000 605,000 623,150 641,845 661,100
Parks Capital Maintenance 2,276,667 800,000 1,162,000 1,196,860 1,232,766 1,269,749
Streets and Traffic Capital Maintenance 1,681,274 0 2,045,000 2,106,350 2,169,541 2,234,627
TOTAL USES OF FUNDS 4,456,406 1,650,000 3,812,000 3,926,360 4,044,151 4,165,475

NET CHANGE IN FUND BALANCE (2,126,675) 0 (2,162,000) (1,276,360) (1,174,151) (1,090,475)

BEGINNING FUND BALANCE 814,331 (1,312,344) (1,312,344) (3,474,344) (4,750,704) (5,924,855)

ENDING FUND BALANCE (1,312,344) (1,312,344) (3,474,344) (4,750,704) (5,924,855) (7,015,330)

60