Page 63 - CityofGrapevineFY25AdoptedBudget

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

REVENUE AND OTHER FUNDING SOURCES
Taxes 13,096,408 12,990,000 13,070,000 13,135,350 13,201,027 13,267,032
Transfers In 1,401,444 2,057,569 3,971,468 4,050,897 4,091,406 4,132,320
Interest & Miscellaneous 349,270 365,000 150,000 153,000 156,060 159,181
TOTAL SOURCES OF FUNDS 14,847,122 15,412,569 17,191,468 17,339,247 17,448,493 17,558,533

EXPENDITURES AND OTHER FUNDING USES
G.O. Bond Principal & Interest 8,080,543 7,099,543 7,136,168 7,207,530 7,279,605 7,352,401
Cert. of Obligation Principal & Interest 4,722,281 5,346,850 7,868,923 7,947,612 8,027,088 8,107,359
Tax Notes & Notes Payable 1,401,444 1,398,169 1,398,453 1,000,000 750,000 700,000
Fiscal Agent & Bond Fees 199,725 150,000 0 100,000 100,000 100,000
Transfers Out 661,919 659,556 666,056 1,084,105 1,291,800 1,298,773
TOTAL USES OF FUNDS 15,065,912 14,654,118 17,069,600 17,339,247 17,448,493 17,558,533

NET CHANGE IN FUND BALANCE (218,790) 758,451 121,868 0 0 0

BEGINNING FUND BALANCE 6,997,402 6,778,612 7,537,063 7,658,931 7,658,931 7,658,931

ENDING FUND BALANCE 6,778,612 7,537,063 7,658,931 7,658,931 7,658,931 7,658,931

FUND BALANCE REQUIREMENT 2,971,906 2,890,675 3,367,154 3,420,345 3,441,895 3,463,601

PERCENTAGE OF COVERAGE 45% 51% 45% 44% 44% 44%

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

REVENUE AND OTHER FUNDING SOURCES
Transfers In 1,640,000 2,670,000 4,899,450 4,899,450 4,899,450 4,899,450
Interest & Miscellaneous 255,332 10,000 30,000 15,000 20,000 30,000
TOTAL SOURCES OF FUNDS 1,895,332 2,680,000 4,929,450 4,914,450 4,919,450 4,929,450

EXPENDITURES AND OTHER FUNDING USES
Facilities Capital Maintenance 832,592 700,000 755,000 755,000 705,000 710,000
Parks Capital Maintenance 1,139,750 1,162,000 1,862,000 1,832,351 1,841,809 1,800,356
ADA 50,000 50,000 50,000 50,000
Streets and Traffic Capital Maintenance 2,265,370 2,308,000 2,232,450 2,277,099 2,322,641 2,369,094
TOTAL USES OF FUNDS 4,237,712 4,170,000 4,899,450 4,914,450 4,919,450 4,929,450

NET CHANGE IN FUND BALANCE (2,342,380) (1,490,000) 30,000 0 0 0

BEGINNING FUND BALANCE 4,329,960 1,987,580 497,580 527,580 527,580 527,580

ENDING FUND BALANCE 1,987,580 497,580 527,580 527,580 527,580 527,580

55 Back to Table of Contents
of
Contents
Table
Back
Back to Table of Contents
to