Page 64 - Grapevine FY20 Approved Budget

LONG-RANGE FINANCIAL FORECAST - DEBT SERVICE FUND
2017-18 2018-19 2019-20 2020-21 2021-22 2022-23
Actual Estimate Approved Projected Projected Projected

REVENUE AND OTHER FUNDING SOURCES
Taxes 11,309,205 12,152,154 13,071,947 15,948,205 14,781,053 14,001,420
Transfers In 3,097,099 2,454,135 2,387,064 2,653,563 2,458,497 2,049,148
Interest & Miscellaneous 195,190 184,778 150,000 150,000 150,000 150,000
Bond Refunding Proceeds 0 5,984,173 0 0 0 0
TOTAL SOURCES OF FUNDS 14,601,494 20,775,240 15,609,011 18,751,768 17,389,550 16,200,568

EXPENDITURES AND OTHER FUNDING USES
G.O. Bond Principal & Interest 10,335,020 9,722,770 11,472,976 8,140,615 7,378,808 6,711,215
Cert. of Obligation Principal & Interest 4,524,603 3,510,864 3,620,344 5,960,093 5,402,342 4,913,568
Tax Notes & Notes Payable 760,718 2,618,681 612,563 436,104 395,293 359,529
Fiscal Agent & Bond Fees 15,064 47,175 0 30,000 30,000 30,000
Bond Refunding Payments 0 6,077,493 0 0 0 0
Transfers Out 970,000 0 0 0 0 0
Payments on Future Debt Issues 0 0 0 1,917,855 963,248 1,599,563
TOTAL USES OF FUNDS 16,605,405 21,976,983 15,705,883 16,484,667 14,169,691 13,613,875

NET CHANGE IN FUND BALANCE (2,003,911) (1,201,743) (96,872) 2,267,101 3,219,859 2,586,693

BEGINNING FUND BALANCE 10,922,692 8,918,781 7,717,038 7,620,166 9,887,267 13,107,126

ENDING FUND BALANCE 8,918,781 7,717,038 7,620,166 9,887,267 13,107,126 15,693,819

FUND BALANCE REQUIREMENT 3,275,587 4,335,186 3,098,147 3,251,770 2,795,117 2,685,477

PERCENTAGE OF COVERAGE 54% 35% 49% 60% 93% 115%

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

2017-18 2018-19 2019-20 2020-21 2021-22 2022-23
Actual Estimate Approved Projected Projected Projected

REVENUE AND OTHER FUNDING SOURCES
Transfers In 3,114,775 3,020,000 3,279,000 3,300,000 3,350,000 3,400,000
Interest & Miscellaneous 97,354 80,507 24,000 5,000 5,000 5,000
TOTAL SOURCES OF FUNDS 3,212,129 3,100,507 3,303,000 3,305,000 3,355,000 3,405,000

EXPENDITURES AND OTHER FUNDING USES
Facilities Capital Maintenance 524,960 384,356 392,000 400,000 420,000 430,000
Parks Capital Maintenance 712,840 1,084,229 1,162,000 1,150,000 1,155,000 1,175,000
Streets and Traffic Capital Maintenance 1,708,150 1,948,922 1,725,000 1,755,000 1,780,000 1,800,000
TOTAL USES OF FUNDS 2,945,950 3,417,507 3,279,000 3,305,000 3,355,000 3,405,000

NET CHANGE IN FUND BALANCE 266,179 (317,000) 24,000 0 0 0

BEGINNING FUND BALANCE 836,677 1,102,856 785,856 809,856 809,856 809,856

ENDING FUND BALANCE 1,102,856 785,856 809,856 809,856 809,856 809,856

56