Capital Recovery Balance - FY2022-23CITY OF SCHERTZ
CAPITAL RECOVERY IMPACT FEE REPORT
Oct 1, 2022 TO March 31, 2023
************** IMPACTS FEES **************
Water Sewer Total
Beginning Allocated Impact Fee Balance 1 4,349,036.20 5,548,597.44 9,897,633.64
Net Change in Allocted Impact Fees (21,629.11)(3,646,586.19)(3,668,215.30)
Ending Allocated Impact Fee Balance 4,327,407.09 1,902,011.25 #6,229,418.34
Beginning Unallocated Impact Fee Balance 4,886,683.88 521,636.10 5,408,319.98
Revenues:
Impact Fees 403,129.80 184,500.54 587,630.34
Transfer In 0.00 0.00 0.00
Interest Earned 963.06 17,586.65 18,549.71
Investments Income 108,034.79 113,009.62 221,044.41
Expenses:
Professional Services 0.00 0.00 0.00
Auditor/Accounting Services 0.00 0.00 0.00
Investment Mgt Fee - Sewer 0.00 1,557.72 1,557.72
Transferred Out 0.00 0.00 0.00
Total Revenue Over/(Under) Expense 512,127.65 313,539.09 825,666.74
Ending Unallocated Impact Fee Balance 5,398,811.53 835,175.19 6,233,986.72
Estimated Cost of Unfunded Projects
Loop Lines 793,121.81
Capital Impact Fee Study - Water 78,417.12
Capital Impact Fee Study - Sewer 97,902.49
Cibolo West Trunk Line 6,000,000.00
Total Unfunded Project Costs 871,538.93 6,097,902.49 6,969,441.42
Unfunded Projects to Ending Unallocated Impact Fee Balance 2 4,527,272.60 (5,262,727.30)(735,454.70)
1
2 Negative Unfunded Projects to Ending Impact Fee Balance to be funded by future revenues or
through other sources
Allocated Impact Fee Balances only include Capital Recovery funds and not funds from any other source. It also
assumes Capital Recovery Funds are used first when allocated.
Capital Improvements Program
SE Quad Pump
Station SE Quad GST
SE Quad Elevated
Tank
SE Quad Distribution
Mains
NE Quad
Distribution Mains
IH10 Corridor
Distribution Mains
Original Cost Estimate 1,688,289$ 1,100,000$ 1,250,000$ 1,700,000$ 1,600,000$ 1,000,000$
Current Project Designation
Corbett Ground
Storage Tank
Corbett Ground
Storage Tank- RL2
Corbett Elevated
Tank - RL1
Loop Lines - WA1
Current Cost Estimate 5,000,000$ 5,650,000$ 1,806,076$
Capital Recovery Funding/Allocation
2011
2012
2013 12,251.14$
2014 500.00$
2015 86,166.10$
2016 3,050,000.00$
2017
2018
2019 1,375,000.00$
2020
2021 512,000.00$
2022 4,230,818.70$
Capital Recovery Funding Balance -$ 4,742,818.70$ 4,523,917.24$ -$ -$ -$
Other Funding Sources -$ -$ 924,031.46$ 1,012,954.19$ -$ -$
Total Project Funding Sources -$ 4,742,818.70$ 5,447,948.70$ 1,012,954.19$ -$ -$
Project Annual Expenses
First Half 2012
Second Half 2012
First Half 2013
Second Half 2013 12,251.14$
First Half 2014 6.77$
Second Half 2014 2,081.13$
First Half 2015 980.00$
Second Half 2015 120,233.32$
First Half 2016 87,843.28$
Second Half 2016 22,763.75$
First Half 2017 -$
Second Half 2017 40,403.20$
First Half 2018 6,248.00$
Second Half 2018 7,485.13$
First Half 2019 50,510.63$
Second Half 2019 1,994,741.24$
First Half 2020 1,385,858.48$
Second Half 2020 1,161,122.42$
First Half 2021 172,980.16$
Second Half 2021 114,254.48$ 91,433.48$
First Half 2022 154,707.22$ -$
Second Half 2022 124,820.80$ -$
First Half 2023 21,629.11$ 40,455.00$
Total Expenses -$ 415,411.61$ 5,156,942.13$ 40,455.00$ -$ -$
Allocated Impact Project Fee Balance -$ 4,327,407.09$ -$ -$ -$ -$
Project Balance -$ 4,327,407.09$ 291,006.57$ 972,499.19$ -$ -$
Project Status Future Future Complete Future Future Future
Capital Recovery Water Projects
Capital Improvements Program
Original Cost Estimate
Current Project Designation
Current Cost Estimate
Capital Recovery Funding/Allocation
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
Capital Recovery Funding Balance -$ -$ -$ 487,848.00$ 7,795,000.00$ -$
Other Funding Sources Bond 2007 931,739.74$ Bond 2013 3,069,305.46$
Total Project Funding Sources
Project Annual Expenses
First Half 2012
Second Half 2012
First Half 2013
Second Half 2013
First Half 2014
Second Half 2014
First Half 2015
Second Half 2015
First Half 2016
Second Half 2016
First Half 2017
Second Half 2017
First Half 2018
Second Half 2018
First Half 2019
Second Half 2019
First Half 2020
Second Half 2020
First Half 2021
Second Half 2021
First Half 2022
Second Half 2022
First Half 2023
Total Expenses
Allocated Impact Project Fee Balance
Project Balance
Project Status
-$ 6,615.06$
-$
-$
98,737.52$
143,307.30$
41,375.48$
-$ -$ -$ 152,267.99$ 1,749,743.26$ -$
9,114,562.20$ -$ -$ 931,739.74$ -$ 335,580.01$
Future Complete Future On Going On Going Future
-$ -$ -$ 152,267.99$ 1,749,743.26$ -$
3,715,891.65$
3,886,885.47$ -$
225,595.33$ 56,860.59$
225,106.41$
-$ -$
-$ 16,123.52$
68,609.20$ 212,479.83$
247,870.62$
4,048.18$
33,784.40$ 121,438.32$
83,983.26$
6,220.00$
815,683.00$ 38,315.41$
5,858.72$ 5,382.50$
46,690.62$ 34,775.84$
28,743.00$ 61,364.70$
980.00$ 17,032.55$
49,861.30$
82,262.17$
10,864,305.46$ 487,848.00$ -$ 931,739.74$ -$ -$
-$
7,795,000.00$
487,848.00$
931,740$ 487,848$ 12,000,000$ 6,000,000.0$
Capital Recovery Sewer Projects
Final South Sewershed
Master Plan Town Creek Phase III Town Creek Phase IV
Woman Hollering Creek
STP PH II
South Schertz Trunk Lines
and Lift Station
South Schertz Trunk Lines
and Lift Station
Town Creek Phase III -
QA3
Crossvines Batch Plant
Expansion - QA4
Woman Hollering Trunk
Line - QA2/Q01
Cibolo West Truck Line
15,000$ 659,126$ 1,000,000$ 600,000$ 9,600,000$
CITY OF SCHERTZ
ROADWAY IMPACT FEE REPORT
Oct 1, 2022 TO March 31, 2023
Area 1 Area 2 Area 3 Area 4 Total
Beginning Allocated Impact Fee Balance 0.00 0.00 0.00 0.00 0.00
Net Change in Allocted Impact Fees 0.00 0.00 0.00 0.00 0.00
Ending Allocated Impact Fee Balance 0.00 0.00 0.00 0.00 0.00
Beginning Unallocated Impact Fee Balance 805,970.93 564,027.75 1,183,301.24 6,053.19 2,559,353.11
Revenues:
Impact Fees 109,471.43 98,144.59 141,540.00 0.00 349,156.02
Transfer In 0.00 0.00 0.00 0.00 0.00
Interest Earned 94.09 471.99 162.39 2.34 730.81
Investments Income 17,509.00 11,584.55 27,074.48 178.82 56,346.85
Expenses:
Development Incentive Fund 0.00 102,494.88 0.00 0.00 102,494.88
Professional Services 0.00 0.00 0.00 0.00 0.00
Auditor/Accounting Services 0.00 0.00 0.00 0.00 0.00
Transferred Out 0.00 0.00 0.00 0.00 0.00
Contingency 0.00 0.00 0.00 0.00 0.00
Construction 88,172.99 0.00 0.00 0.00 88,172.99
Total Revenue Over/(Under) Expense 38,901.53 7,706.25 168,776.87 181.16 215,565.81
Ending Unallocated Impact Fee Balance 844,872.46 571,734.00 1,352,078.11 6,234.35 2,774,918.92
******************** ROADWAY IMPACTS FEES ********************