Loading...
HomeMy Public PortalAbout054-2022 - MEMORICHMOND SANITARY DISTRICT 2022 RATE ANALYSIS NOVEMBER 7, 2022 RICHMOND SANITARY DISTRICT TABLE OF CONTENTS ACCOUNTANT'S COMPILATION REPORT PRO FORMA FINANCIAL INFORMATION Page 2 Schedule of Pro Forma Revenue Requirements 3 Schedule of Current and Proposed Wastewater Rates and Charges 4 - 5 Schedule of Pro Forma Cash Operation and Maintenance Expenses 6 Capital Improvements Plan HISTORICAL FINANCIAL INFORMATION 7 Comparative Statements of Selected Financial Information Arising From Cash Transactions 8 Comparative Statements of Receipts and Disbursements SUPPLEMENTARY INFORMATION 9 -10 Detail of Operation and Maintenance Disbursements 11 Comparison of Account Balances with Minimum Reserves Required 12 Schedule of Amortization of $817,000 Outstanding Sanitary District Bonds of 2009, Series A 13 Schedule of Amortization of $9,525,000 Outstanding Sanitary District Bonds of 2012, Series A 14 Schedule of Amortization of $521,760 Outstanding Sanitary District Bonds of 2012, Series B 15 Schedule of Amortization of $3,905,000 Outstanding Sanitary District Bonds of 2015, Series B 16 Schedule of Amortization of $10,120,000 Outstanding Sanitary District Bonds of 2017, Series B 17 Schedule of Amortization of $5,460,000 Outstanding Sanitary District Refunding Bonds of 2019 18 Schedule of Amortization of $16,125,000 Outstanding Sanitary District Bonds of 2019, Series C 19 Schedule of Amortization of $6,455,000 Outstanding Sanitary District Bonds of 2021, Series D 20 Schedule of Combined Debt Service ACCOUNTANT’S COMPILATION REPORT Members of the Sanitary Board November 7, 2022 Richmond Sanitary District 238 Liberty Avenue Richmond, IN 47374 In connection with the proposed rate adjustments in the Richmond Sanitary District’s schedule of rates and charges, we have at your request, compiled this rate study report. The purpose of this report is to consider a new schedule of sanitary sewer rates and charges and should not be used for any other purpose. The pro forma financial information, which is based on the results of operations for the twelve months ended December 31, 2021, is prepared for the purpose of showing the estimated financial effects on the Richmond Sanitary District’s revenue requirements for an adjustment in rates and charges for service and other changes that may be reasonably fixed, known or measured. We have not audited or reviewed the accompanying pro forma information and, accordingly, do not express an opinion or provide any form of assurance on the pro forma information. This report was compiled by us, with assumptions provided by management or obtained from other sources. The actual results achieved may vary from the pro forma information and the variations may be material. We have no responsibility to update this report for events or circumstances occurring after the date of this report. Management is responsible for the accompanying financial statements which comprise the statements of selected financial information arising from cash transactions as of December 31, 2021, 2020 and 2019, and the related statements of cash receipts and disbursements for the years then ended in accordance with the cash basis of accounting, and for determining that the cash basis of accounting is an acceptable financial reporting framework. We have performed a compilation engagement in accordance with Statements on Standards for Accounting and Review Services promulgated by the Accounting and Review Services Committee of the AICPA. We did not audit or review the financial statements nor were we required to perform any procedures to verify the accuracy or completeness of the information provided by management. Accordingly, we do not express an opinion, a conclusion, nor provide any form of assurance on these financial statements. The financial statements are prepared in accordance with the cash basis of accounting, which is a basis of accounting other than accounting principles generally accepted in the United States of America. The supplementary information contained on pages 9-20 is presented for purposes of additional analysis and is not a required part of the basic financial statements. Such information is the responsibility of management. The supplementary information was subject to our compilation engagement. We have not audited or reviewed the supplementary information and do not express an opinion, conclusion, nor provide any assurance on such information. Management has elected to omit substantially all the disclosures ordinarily included in the financial statements prepared in accordance with the cash basis of accounting. If the omitted disclosures were included in the financial statements, they might influence the user’s conclusions about the Richmond Sanitary District’s selected financial information arising from cash transactions and cash receipts and disbursements. Accordingly, the financial statements are not designed for those who are not informed on such matters. _______________________ O. W. Krohn & Associates LLP CITY OF RICHMOND SANITARY DISTRICT PRO FORMA FINANCIAL INFORMATION RICHMOND SANITARY DISTRICT SCHEDULE OF PRO FORMA REVENUE REQUIREMENTS BASED ON THE TEST YEAR ENDED DECEMBER 31, 2021 PRO FORMA YEAR 2023 2024 2025 REVENUE REQUIREMENTS PRO FORMA CASH OPERATION AND MAINTENANCE EXPENSES (1) 6,517,208$ 6,712,724$ 6,914,106$ DEBT SERVICE ON OUTSTANDING BONDS (2) 4,968,512 4,980,119 3,922,278 DEBT SERVICE ON PROPOSED BONDS (3) - 285,700 285,700 ALLOWANCE FOR CAPITAL IMPROVEMENTS (4) 4,038,000 4,570,000 6,222,000 TOTAL REVENUE REQUIREMENTS 15,523,720 16,548,543 17,344,084 PRO FORMA REVENUES TEST YEAR SANITARY SEWER FEES AND CHARGES 12,076,567 12,076,567 12,076,567 ADJUSTMENT - PRO FORMA ADJUSTMENT (5) (576,567) (576,567) (576,567) ADJUSTMENT - RATE INCREASES (6) - 1,581,031 2,333,324 TEST YEAR STORMWATER FEES 1,531,624 1,531,624 1,531,624 TEST/PRIOR YEAR SEWER SURCHARGES 688,961 688,961 688,961 ADJUSTMENT - PRO FORMA ADJUSTMENT (5) (188,961) (188,961) (188,961) ADJUSTMENT - RATE INCREASE (7) - 272,530 272,530 TEST YEAR SEPTIC TANK FEES 411,065 411,065 411,065 TOTAL PRO FORMA REVENUES 13,942,689 15,796,250 16,548,543 REVENUE SHORTFALL 1,581,031$ 752,293$ 795,541$ APPROXIMATE REQUIRED ACROSS-THE-BOARD INCREASE IN SEWER RATES AND CHARGES 13.75% 5.75% 5.75% ESTIMATED 4,000 GALLON BILL 49.41$ 52.24$ 55.23$ (1) SEE PAGE 4. ASSUMES A 3.0% INFLATIONARY ADJUSTMENT FOR 2024 AND 2025. (2) ANNUAL DEBT SERVICE ON ALL CURRENTLY OUTSTANDING BONDS. SEE PAGE 20. (3) ASSUMES THE DEBT SERVICE ON A PROPOSED $4,250,000 BOND ISSUE OUTSTANDING FOR 20 YEARS AT 3.00%. (4) (5) PER MANAGEMEMNT, ADJUSTMENT NEEDED BASED ON CURRENT BILLINGS AND CURRENT CUSTOMER BASE. (6) ASSUMES THE INCREASE REQUIRED IN PRIOR YEAR IS FULLY CAPTURED IN FOLLOWING YEAR. (7) ASSUMES THE IMPLEMENTATION OF THE BULK USER RATES AT $0.31 PER POUND. ALLOWANCE FOR CAPITAL IMPROVEMENTS AND WORKING CAPITAL BASED ON NEEDS PER MANAGEMENT AND CAPITAL IMPROVEMENT PLAN. SEE ACCOUNTANT'S COMPILATION REPORT - 2 - RICHMOND SANITARY DISTRICT SCHEDULE OF CURRENT AND PROPOSED WASTEWATER RATES AND CHARGES PROPOSED CURRENT 2023 2024 2025 Effective Date 1/1/2023 1/1/2024 1/1/2025 SEWER USER RATES:Proposed Increase 13.75% 5.75% 5.75% TREATMENT RATE RATE PER 1,000 GALLONS PER MONTH RESIDENTIAL / COMMERCIAL 5.25$ 5.97$ 6.31$ 6.67$ INDUSTRIAL 4.67$ 5.31$ 5.62$ 5.94$ MONTHLY BASE RATE (ALL CLASSES) WATER METER SIZE 5/8 OR 3/4 INCH 22.44$ 25.53$ 27.00$ 28.55$ 1 INCH 69.19 78.70 83.23 88.02 1 1/2 INCH 153.67 174.80 184.85 195.48 2 INCH 261.20 297.12 314.20 332.27 3 INCH 593.87 675.53 714.37 755.45 4 INCH 1,028.98 1,170.46 1,237.76 1,308.93 6 INCH 2,315.20 2,633.54 2,784.97 2,945.11 8 INCH 4,115.92 4,681.86 4,951.07 5,235.76 10 INCH 6,431.13 7,315.41 7,736.05 8,180.87 12 INCH 9,260.82 10,534.18 11,139.90 11,780.44 UNMETERED CUSTOMERS (5,000 GALLONS) CHARGE PER MONTH 48.71$ 55.38$ 58.55$ 61.90$ INDUSTRIAL SURCHARGES BOD PER POUND 0.52$ 0.52$ 0.52$ 0.52$ SUSPENDED SOLIDS PER POUND 0.52 0.52 0.52 0.52 BULK USERS (OVER 250,000 ANNUAL COMBINED LBS.) BOD PER POUND 0.310$ 0.310$ 0.310$ SUSPENDED SOLIDS PER POUND 0.310 0.310 0.310 STORM WATER RATES: RESIDENTIAL MONTHLY BASE RATE 6.00$ 6.00$ 6.00$ 6.00$ NON-RESIDENTIAL MONTHLY BASE RATE 4.50$ 4.50$ 4.50$ 4.50$ MONTHLY VARIABLE RATE - PER ERU 1.50$ 1.50$ 1.50$ 1.50$ NOTES: Sewer user rates were approved by the Common Council in Ordinance No. 46-2017 on October 30, 2017. Stormwater rates were approved by the Common Council in Ordinance No. 10-2009 adopted on March 16, 2009 effective beginning May 1, 2009. SEE ACCOUNTANT'S COMPILATION REPORT - 3 - TEST YEAR PRO FORMA ENDED PRO FORMA OPERATING 12/31/2021 ADJUSTMENTS REF. DISBURSEMENTS COLLECTION SYSTEM: SALARIES AND WAGES 485,252$ 39,548$ (1) 524,800$ EMPLOYEE PENSIONS AND BENEFITS 243,809 19,870 (1) 263,679 MATERIALS AND SUPPLIES 27,218 2,722 (2) 29,940 REPAIRS AND MAINTENANCE 13,378 (6,457) (3) 6,921 TRANSPORTATION 47,890 13,666 (3) 61,556 CONCRETE/ASPHALT 3,053 305 (2) 3,358 CONTRACTUAL SERVICES 16,320 80 (3) 16,400 MISCELLANEOUS 324 351 (3) 675 SUB-TOTALS 837,244 70,085 907,329 TREATMENT PLANT: SALARIES AND WAGES 720,497 58,721 (1) 779,218 EMPLOYEE PENSIONS AND BENEFITS 411,531 33,540 (1) 445,071 PURCHASED POWER 627,372 62,737 (2) 690,109 MATERIALS AND SUPPLIES 19,283 1,928 (2) 21,211 CHEMICALS 65,005 6,501 (2) 71,506 REPAIRS AND MAINTENANCE 178,548 (18,176) (3) 160,372 LAND APPLICATIONS - BIO SOLIDS 608,691 (8,871) (3) 599,820 TRANSPORTATION 32,794 3,127 (3) 35,921 CONTRACTUAL SERVICES: PROFESSIONAL 295,814 19,813 (3) 315,627 OTHER 119,119 (7,576) (3) 111,543 OTHER UTILITIES 60,082 6,008 (2) 66,090 PHONE AND INTERNET 842 84 (2) 926 MISCELLANEOUS 4,349 (866) (3) 3,483 SUB-TOTALS 3,143,927 156,970 3,300,897 LABORATORY: SALARIES AND WAGES 245,801 20,033 (1) 265,834 EMPLOYEE PENSIONS AND BENEFITS 110,822 9,032 (1) 119,854 MATERIALS AND SUPPLIES 19,357 1,936 (2) 21,293 REPAIRS AND MAINTENANCE 4,570 (750) (3) 3,820 TRANSPORTATION 2,584 (215) (3) 2,369 CONTRACTUAL SERVICES 32,795 (9,382) (3) 23,413 MISCELLANEOUS 1,461 293 (3) 1,754 SUB-TOTALS 417,390 20,947 438,337 (1) ASSUMES A 3% AND 5% COST-OF-LIVING/INFLATIONARY ADJUSTMENT FOR 2022 AND 2023, RESPECTIVELY. (2) ASSUMES AN ESTIMATED 10.0% INFLATIONARY ADJUSTMENT. (3) APPROXIMATES HISTORICAL DISBURSEMENTS. RICHMOND SANITARY DISTRICT SCHEDULE OF PRO FORMA CASH OPERATION AND MAINTENANCE EXPENSES SEE ACCOUNTANT'S COMPILATION REPORT - 4 - RICHMOND SANITARY DISTRICT SCHEDULE OF PRO FORMA CASH OPERATION AND MAINTENANCE EXPENSES TEST YEAR PRO FORMA ENDED PRO FORMA OPERATING 12/31/2021 ADJUSTMENTS REF. DISBURSEMENTS ADMINISTRATIVE AND GENERAL: SALARIES AND WAGES 240,713$ 19,618$ (1) 260,331$ EMPLOYEE PENSIONS AND BENEFITS 220,896 18,003 (1) 238,899 PURCHASED POWER 6,000 600 (2) 6,600 MATERIALS AND SUPPLIES 11,305 1,131 (2) 12,436 TRANSPORTATION 7,051 760 (3) 7,811 WATER SHUTOFF/DISCONNECTS 88,920 (32,457) (3) 56,463 CONTRACTUAL SERVICES: TECHNICAL 145,887 6,010 (3) 151,897 PROFESSIONAL 25,750 32,890 (3) 58,640 OTHER 154,472 7,486 (3) 161,958 PHONE AND INTERNET 17,339 1,734 (2) 19,073 POSTAGE 49,709 4,971 (2) 54,680 INSURANCE 184,800 18,480 (2) 203,280 INTERGOVERNMENTAL CHARGES 180,000 (6,782) (3) 173,218 MISCELLANEOUS 14,143 2,553 (3) 16,696 SUB-TOTALS 1,346,985 74,997 1,421,982 STORMWATER: SALARIES AND WAGES 48,940 3,989 (1) 52,929 EMPLOYEE PENSIONS AND BENEFITS 15,559 1,268 (1) 16,827 MATERIALS AND SUPPLIES 2,234 223 (2) 2,457 CONCRETE/ASPHALT 3,053 305 (2) 3,358 PROFESSIONAL 164,306 113,110 (3) 277,416 OTHER 59,046 (5,329) (3) 53,717 POSTAGE 28,000 2,800 (2) 30,800 TRAINING AND EDUCATION 775 384 (3) 1,159 MISCELLANEOUS 79,652 (69,652) (3) 10,000 SUB-TOTALS 401,565 47,098 448,663 TOTALS 6,147,111$ 370,097$ 6,517,208$ (1) ASSUMES A 3% AND 5% COST-OF-LIVING/INFLATIONARY ADJUSTMENT FOR 2022 AND 2023, RESPECTIVELY. (2) ASSUMES AN ESTIMATED 10.0% INFLATIONARY ADJUSTMENT. (3) APPROXIMATES HISTORICAL DISBURSEMENTS. (CONTINUED) SEE ACCOUNTANT'S COMPILATION REPORT - 5 - RICHMOND SANITARY DISTRICTCAPITAL IMPROVEMENTS PLANPER MANAGEMENT AND ENGINEERS2022 2023 2024 2025 2026 2027 6-YR TOTALSPAY-GO PROJECTS:LTCP PLAN PROJECTS:Flow Monitoring/Post Construction Monitoring 55,000$ 55,000$ 55,000$ 55,000$ 55,000$ 55,000$ 330,000$ Short Creek Interceptor (Niewoehner) (Hayes Lift Station) 4,382,400 4,382,400 Round Barn Road (NW Branch-College Corner) 200,000 791,504 991,504 Round Barn Road (West Branch)100,000 410,775 510,775 Midwest Industrial Park100,000 425,798 525,798 Chester Blvd Relief Interceptor Sewer Collection Improvements Phase III (North of I-70) 478,130 2,709,405 3,187,535 North/Far North Richmond Collector122,887 696,360 819,247 WWTP CSO Wet Weather Treatment Facility at WWTP 2,244,574 1,496,383 3,740,957 WWTP Roughing Tower and Intermediate Clarifier Modifications181,973 1,031,178 1,213,151 Programmed LTCP Related Projects (to be determined)700,000 700,000 TOTAL LTCP PAY-GO PROJECTS 4,437,400 2,699,574 2,152,400 3,642,738 2,714,255 755,000 16,401,367 ANNUAL MISCELLANEOUS PROJECTS:Programmed Sanitary Projects (TBD) 335,038 344,419 354,063 363,977 374,168 384,645 2,156,310 Sanitary Sewer Rehabilitation and Risk Management Program 390,876 401,821 413,072 424,638 436,528 448,751 2,515,686 Programmed Storm Projects (TBD) 390,876 401,821 413,072 424,638 436,528 448,751 2,515,686 Estimated Admin Capital 51,800 239,950 118,580 121,477 137,263 123,908 792,978 Estimated WWTP Equipment Capital 483,500 886,000 876,884 890,869 856,063 919,120 4,912,436 Estimated Lab Capital 127,800 132,800 146,798 161,477 165,998 142,726 877,599 Estimated WW Maint/Lift Station Capital 445,000 765,000 693,900 618,219 917,986 541,644 3,981,749 Estimated Sewer Maintenance Equipment Capital 233,000 143,000 62,194 77,145 60,294 67,008 642,641 TOTAL MISCELLANEOUS PAY-GO PROJECTS 2,457,890 3,314,811 3,078,563 3,082,440 3,384,828 3,076,553 18,395,085 TOTAL PAY-GO PROJECTS 6,895,290 6,014,385 5,230,963 6,725,178 6,099,083 3,831,553 34,796,452 BOND FUNDED PROJECTS*Short Creek Interceptor (Lower) (Short Creek Lift Station) 4,250,000 4,250,000 WWTP CSO Wet Weather Treatment Facility at WWTP31,000,000 31,000,000 WWTP CSO Wet Weather Treatment Facility in collection system6,000,000 6,000,000 TOTAL BOND FUNDED PROJECTS - 4,250,000 - - - 37,000,000 41,250,000 * Includes amounts for costs of issuanceTOTAL CAPITAL PROJECTS PLANNED 6,895,290$ 10,264,385$ 5,230,963$ 6,725,178$ 6,099,083$ 40,831,553$ 76,046,452$ SEE ACCOUNTANT'S COMPILATION REPORT- 6 - CITY OF RICHMOND SANITARY DISTRICT HISTORICAL FINANCIAL STATEMENTS RICHMOND SANITARY DISTRICT COMPARATIVE STATEMENTS OF SELECTED FINANCIAL INFORMATION ARISING FROM CASH TRANSACTIONS AS OF DECEMBER 31, 2021 2020 2019 UTILITY PLANT IN SERVICE 158,069,804$ 146,468,279$ 139,785,744$ CASH AND CASH EQUIVALENTS: SEWER OPERATING FUND 5,913,180$ 3,692,926$ 5,943,513$ SEWER IMPROVEMENT FUND 3,460,100 3,460,099 - STORMWATER FUND 1,235,082 1,593,021 3,200,435 STORMWATER IMPROVEMENT FUND 958,389 958,389 - BOND AND INTEREST FUND 4,838,603 4,517,894 3,005,799 DEBT SERVICE RESERVE FUND 4,133,236 3,707,021 3,281,140 CONSTRUCTION FUND 8,354,781 12,525,693 16,701,593 SANITARY DISTRICT REFUNDING ESCROW - - 7,293,321 TOTAL CASH AND CASH EQUIVALENTS 28,893,371$ 30,455,043$ 39,425,801$ BONDED DEBT: SANITARY DISTRICT BONDS OF 2009, SERIES A 817,000$ 894,000$ 968,000$ SANITARY DISTRICT BONDS OF 2012, SERIES A 9,525,000 10,230,000 10,920,000 TAXABLE SANITARY DISTRICT BONDS OF 2012, SERIES B 521,760 565,240 608,720 SANITARY DISTRICT REFUNDING BONDS OF 2015, SERIES B 3,905,000 5,160,000 6,390,000 SANITARY DISTRICT BONDS OF 2017, SERIES B 10,120,000 10,615,000 11,100,000 SANITARY DISTRICT REFUNDING BONDS OF 2019 5,460,000 5,935,000 6,030,000 SANITARY DISTRICT BONDS OF 2019, SERIES C 16,125,000 16,750,000 16,750,000 SANITARY DISTRICT BONDS OF 2021, SERIES D 6,455,000 - - TOTAL BONDED DEBT 52,928,760$ 50,149,240$ 52,766,720$ SEE ACCOUNTANT'S COMPILATION REPORT - 7 - RICHMOND SANITARY DISTRICT COMPARATIVE STATEMENTS OF RECEIPTS AND DISBURSEMENTS FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2021 2020 2019 OPERATING RECEIPTS: SANITARY SEWER FEES AND CHARGES 12,076,567$ 11,534,244$ 11,075,799$ STORMWATER FEES 1,531,624 1,490,208 1,506,395 SEWER SURCHARGES 688,961 376,930 495,763 SEPTIC TANK FEES 411,065 486,221 4,558 TOTAL OPERATING RECEIPTS 14,708,217 13,887,603 13,082,515 OPERATING DISBURSEMENTS: COLLECTION SYSTEM 837,244 791,616 769,512 TREATMENT PLANT 3,143,927 2,783,595 3,343,323 LABORATORY 417,390 402,373 350,032 ADMINISTRATIVE AND GENERAL 1,346,985 1,145,719 1,417,004 STORMWATER 401,565 273,379 693,648 TOTAL OPERATING DISBURSEMENTS 6,147,111 5,396,682 6,573,519 NET OPERATING RECEIPTS 8,561,106 8,490,921 6,508,996 NON-OPERATING RECEIPTS INTEREST AND DIVIDENDS 1,578 29,831 161,411 TAPS 8,906 3,750 3,100 BOND PROCEEDS 6,455,000 - 23,481,659 MISCELLANEOUS NON-OPERATING REVENUE 161,953 87,918 194,636 TOTAL NON-OPERATING RECEIPTS 6,627,437 121,499 23,840,806 NON-OPERATING DISBURSEMENTS: PLANT ADDITIONS AND IMPROVEMENTS 11,601,525 6,682,535 3,428,421 PRINCIPAL PAID 3,675,480 2,617,480 2,897,000 INTEREST PAID 1,218,485 836,527 755,566 LEASE PAYMENT 226,177 153,265 153,265 BOND ISSUANCE COSTS - - 171,080 BOND DEFEASANCE/ESCROW OUTFLOW - 7,293,321 - OTHER 28,548 50 - TOTAL NON-OPERATING DISBURSEMENTS 16,750,215 17,583,178 7,405,332 INCREASE (DECREASE) IN CASH (1,561,672) (8,970,758) 22,944,470 BEGINNING CASH BALANCE 30,455,043 39,425,801 16,481,331 ENDING CASH BALANCE 28,893,371$ 30,455,043$ 39,425,801$ SEE ACCOUNTANT'S COMPILATION REPORT - 8 - CITY OF RICHMOND SANITARY DISTRICT SUPPLEMENTARY INFORMATION RICHMOND SANITARY DISTRICT DETAIL OF OPERATION AND MAINTENANCE DISBURSEMENTS FOR THE TWELVE MONTHS ENDING DECEMBER 31, 2021 2020 2019 COLLECTION SYSTEM: SALARIES AND WAGES 485,252$ 460,126$ 416,130$ EMPLOYEE PENSIONS AND BENEFITS 243,809 230,059 223,941 MATERIALS AND SUPPLIES 27,218 20,663 19,717 REPAIRS AND MAINTENANCE 13,378 1,151 6,233 TRANSPORTATION 47,890 60,445 76,333 CONCRETE/ASPHALT 3,053 3,672 8,076 CONTRACTUAL SERVICES 16,320 15,378 17,502 MISCELLANEOUS 324 122 1,580 SUB-TOTALS 837,244 791,616 769,512 TREATMENT PLANT: SALARIES AND WAGES 720,497 701,770 675,478 EMPLOYEE PENSIONS AND BENEFITS 411,531 310,267 323,590 PURCHASED POWER 627,372 673,839 736,140 MATERIALS AND SUPPLIES 19,283 14,132 16,108 CHEMICALS 65,005 93,264 68,745 REPAIRS AND MAINTENANCE 178,548 144,490 158,079 LAND APPLICATIONS - BIO SOLIDS 608,691 419,078 771,692 TRANSPORTATION 32,794 31,762 43,208 CONTRACTUAL SERVICES: PROFESSIONAL 295,814 271,694 379,373 OTHER 119,119 74,313 141,196 OTHER UTILITIES 60,082 45,648 25,226 PHONE AND INTERNET 842 861 866 MISCELLANEOUS 4,349 2,477 3,622 SUB-TOTALS 3,143,927 2,783,595 3,343,323 LABORATORY: SALARIES AND WAGES 245,801 254,773 217,017 EMPLOYEE PENSIONS AND BENEFITS 110,822 107,045 92,144 MATERIALS AND SUPPLIES 19,357 15,146 13,623 REPAIRS AND MAINTENANCE 4,570 2,990 3,899 TRANSPORTATION 2,584 2,334 2,188 CONTRACTUAL SERVICES 32,795 19,388 18,056 MISCELLANEOUS 1,461 697 3,105 SUB-TOTALS 417,390 402,373 350,032 SEE ACCOUNTANT'S COMPILATION REPORT - 9 - RICHMOND SANITARY DISTRICT DETAIL OF OPERATION AND MAINTENANCE DISBURSEMENTS FOR THE TWELVE MONTHS ENDING DECEMBER 31, (CONTINUED) 2021 2020 2019 ADMINISTRATIVE AND GENERAL: SALARIES AND WAGES 240,713$ 279,783$ 251,196$ EMPLOYEE PENSIONS AND BENEFITS 220,896 157,964 118,764 PURCHASED POWER 6,000 6,000 6,000 MATERIALS AND SUPPLIES 11,305 6,252 7,374 TRANSPORTATION 7,051 7,888 8,495 WATER SHUTOFF/DISCONNECTS 88,920 20,085 60,385 CONTRACTUAL SERVICES: TECHNICAL 145,887 152,251 157,553 PROFESSIONAL 25,750 26,886 123,284 OTHER 154,472 60,178 271,225 PHONE AND INTERNET 17,339 12,594 13,284 POSTAGE 49,709 47,955 47,089 INSURANCE 184,800 169,639 175,000 INTERGOVERNMENTAL CHARGES 180,000 178,823 160,831 MISCELLANEOUS 14,143 19,421 16,524 SUB-TOTALS 1,346,985 1,145,719 1,417,004 STORMWATER: SALARIES AND WAGES 48,940 50,518 46,728 EMPLOYEE PENSIONS AND BENEFITS 15,559 15,548 14,857 MATERIALS AND SUPPLIES 2,234 3,165 3,166 CONCRETE/ASPHALT 3,053 1,335 1,316 CONTRACTUAL SERVICES: PROFESSIONAL 164,306 134,997 532,946 OTHER 59,046 37,114 64,991 POSTAGE 28,000 28,000 28,000 TRAINING AND EDUCATION 775 2,702 - MISCELLANEOUS 79,652 - 1,644 SUB-TOTALS 401,565 273,379 693,648 TOTAL OPERATION & MAINTENANCE EXPENSES 6,147,111$ 5,396,682$ 6,573,519$ SEE ACCOUNTANT'S COMPILATION REPORT - 10 - RICHMOND SANITARY DISTRICT COMPARISON OF ACCOUNT BALANCES WITH MINIMUM RESERVES REQUIRED FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2021 BALANCE MINIMUM AVAILABLE AS OF RESERVE FOR 12/31/2021 REQUIRED (1) TRANSFER SEWER OPERATING FUND 5,913,180$ 957,591$ (2) 4,955,589$ STORMWATER FUND 1,235,082 66,928 (2) 1,168,154 BOND AND INTEREST FUND 4,838,603 4,420,720 (3) 417,883 DEBT SERVICE RESERVE FUND 4,133,236 4,133,236 (4) - CONSTRUCTION FUND 8,354,781 8,354,781 (5) - SEWER IMPROVEMENT FUND 3,460,100 - (6) 3,460,100 STORMWATER IMPROVEMENT FUND 958,389 - (6) 958,389 TOTALS 28,893,371$ 17,933,256$ 10,960,115$ (1)REQUIREMENTS PER THE BOND RESOLUTIONSS APPROVING THE OUTSTANDING BONDS. (2) AN AMOUNT SUFFICIENT TO PROVIDE FOR OPERATIONS FOR 2 MONTHS. (3) (4) (5) RESERVED FOR CONSTRUCTION AND PROJECT RELATED CAPITAL OUTLAYS. (6) AN AMOUNT OF 1/6 OF THE NEXT INTEREST PAYMENT AND 1/12 OF THE NEXT PRINCIPAL PAYMENT SHOULD BE TRANSFERRED MONTHLY TO ACCRUE FUNDS FOR DEBT SERVICE PAYMENTS. MONTHLY TRANSFERS ARE TO BE MADE TO BUILD-UP FUNDS TO AN AMOUNT EQUAL TO THE MAXIMUM ANNUAL DEBT SERVICE OVER NO MORE THAN 60 MONTHS. UNRESTRICTED, FOR OPERATIONS. FUND IS ESTABLISHED TO PROVIDE A BUILD-UP OF FUNDS FOR PERIODIC MAINTENANCE AND CAPITAL IMPROVEMENTS. SEE ACCOUNTANT'S COMPILATION REPORT - 11 - RICHMOND SANITARY DISTRICT SCHEDULE OF AMORTIZATION OF $817,000 OUTSTANDING SANITARY DISTRICT BONDS OF 2009, SERIES A DATED JULY 23, 2009 BOND PAYMENT PRINCIPAL INTEREST PERIOD YEAR DATE BALANCE PRINCIPAL RATE INTEREST TOTAL TOTAL 1/1/2022 817,000$ 79,000$ 3.37% 13,766.45$ 92,766.45$ 92,766.45$ 7/1/2022 12,435.30 12,435.30 1/1/2023 738,000 82,000 3.37% 12,435.30 94,435.30 106,870.60 7/1/2023 11,053.60 11,053.60 1/1/2024 656,000 85,000 3.37% 11,053.60 96,053.60 107,107.20 7/1/2024 9,621.35 9,621.35 1/1/2025 571,000 88,000 3.37% 9,621.35 97,621.35 107,242.70 7/1/2025 8,138.55 8,138.55 1/1/2026 483,000 90,000 3.37% 8,138.55 98,138.55 106,277.10 7/1/2026 6,622.05 6,622.05 1/1/2027 393,000 93,000 3.37% 6,622.05 99,622.05 106,244.10 7/1/2027 5,055.00 5,055.00 1/1/2028 300,000 97,000 3.37% 5,055.00 102,055.00 107,110.00 7/1/2028 3,420.55 3,420.55 1/1/2029 203,000 100,000 3.37% 3,420.55 103,420.55 106,841.10 7/1/2029 1,735.55 1,735.55 1/1/2030 103,000 103,000 3.37% 1,735.55 104,735.55 106,471.10 TOTALS 817,000$ 129,930.35$ 946,930.35$ 946,930.35$ SEE ACCOUNTANT'S COMPILATION REPORT - 12 - RICHMOND SANITARY DISTRICT SCHEDULE OF AMORTIZATION OF $9,525,000 OUTSTANDING SANITARY DISTRICT BONDS OF 2012, SERIES A DATED: DECEMBER 13, 2012 BOND PAYMENT PRINCIPAL INTEREST PERIOD YEAR DATE BALANCE PRINCIPAL RATE INTEREST TOTAL TOTAL 1/1/2022 9,525,000$ 715,000$ 1.73% 82,391.25$ 797,391.25$ 797,391.25$ 7/1/2022 76,206.50 76,206.50 1/1/2023 8,810,000 730,000 1.73% 76,206.50 806,206.50 882,413.00 7/1/2023 69,892.00 69,892.00 1/1/2024 8,080,000 745,000 1.73% 69,892.00 814,892.00 884,784.00 7/1/2024 63,447.75 63,447.75 1/1/2025 7,335,000 755,000 1.73% 63,447.75 818,447.75 881,895.50 7/1/2025 56,917.00 56,917.00 1/1/2026 6,580,000 770,000 1.73% 56,917.00 826,917.00 883,834.00 7/1/2026 50,256.50 50,256.50 1/1/2027 5,810,000 785,000 1.73% 50,256.50 835,256.50 885,513.00 7/1/2027 43,466.25 43,466.25 1/1/2028 5,025,000 800,000 1.73% 43,466.25 843,466.25 886,932.50 7/1/2028 36,546.25 36,546.25 1/1/2029 4,225,000 815,000 1.73% 36,546.25 851,546.25 888,092.50 7/1/2029 29,496.50 29,496.50 1/1/2030 3,410,000 830,000 1.73% 29,496.50 859,496.50 888,993.00 7/1/2030 22,317.00 22,317.00 1/1/2031 2,580,000 845,000 1.73% 22,317.00 867,317.00 889,634.00 7/1/2031 15,007.75 15,007.75 1/1/2032 1,735,000 860,000 1.73% 15,007.75 875,007.75 890,015.50 7/1/2032 7,568.75 7,568.75 1/1/2033 875,000 875,000 1.73% 7,568.75 882,568.75 890,137.50 TOTALS 9,525,000$ 1,024,635.75$ 10,549,635.75$ 10,549,635.75$ SEE ACCOUNTANT'S COMPILATION REPORT - 13 - RICHMOND SANITARY DISTRICT SCHEDULE OF AMORTIZATION OF $521,760 OUTSTANDING SANITARY DISTRICT BONDS OF 2012, SERIES B DATED: DECEMBER 13, 2012 BOND PAYMENT PRINCIPAL INTEREST PERIOD YEAR DATE BALANCE PRINCIPAL RATE INTEREST TOTAL TOTAL 1/1/2022 521,760$ 43,480$ 0.00% - 43,480.00$ 43,480.00$ 7/1/2022 - - 1/1/2023 478,280 43,480 0.00% - 43,480.00 43,480.00 7/1/2023 - - 1/1/2024 434,800 43,480 0.00% - 43,480.00 43,480.00 7/1/2024 - - 1/1/2025 391,320 43,480 0.00% - 43,480.00 43,480.00 7/1/2025 - - 1/1/2026 347,840 43,480 0.00% - 43,480.00 43,480.00 7/1/2026 - - 1/1/2027 304,360 43,480 0.00% - 43,480.00 43,480.00 7/1/2027 - - 1/1/2028 260,880 43,480 0.00% - 43,480.00 43,480.00 7/1/2028 - - 1/1/2029 217,400 43,480 0.00% - 43,480.00 43,480.00 7/1/2029 - - 1/1/2030 173,920 43,480 0.00% - 43,480.00 43,480.00 7/1/2030 - - 1/1/2031 130,440 43,480 0.00% - 43,480.00 43,480.00 7/1/2031 - - 1/1/2032 86,960 43,480 0.00% - 43,480.00 43,480.00 7/1/2032 - - 1/1/2033 43,480 43,480 0.00% - 43,480.00 43,480.00 TOTALS 521,760$ -$ 521,760.00$ 521,760.00$ SEE ACCOUNTANT'S COMPILATION REPORT - 14 - RICHMOND SANITARY DISTRICT SCHEDULE OF AMORTIZATION OF $3,905,000 OUTSTANDING SANITARY DISTRICT BONDS OF 2015, SERIES B DATED: JUNE 9, 2015 BOND PAYMENT PRINCIPAL INTEREST PERIOD YEAR DATE BALANCE PRINCIPAL RATE INTEREST TOTAL TOTAL 1/1/2022 3,905,000$ 1,275,000$ 1.96% 38,269.00$ 1,313,269.00$ 1,313,269.00$ 7/1/2022 25,774.00 25,774.00 1/1/2023 2,630,000 1,300,000 1.96% 25,774.00 1,325,774.00 1,351,548.00 7/1/2023 13,034.00 13,034.00 1/1/2024 1,330,000 1,330,000 1.96% 13,034.00 1,343,034.00 1,356,068.00 TOTALS 3,905,000$ 115,885.00$ 4,020,885.00$ 4,020,885.00$ SEE ACCOUNTANT'S COMPILATION REPORT - 15 - RICHMOND SANITARY DISTRICT SCHEDULE OF AMORTIZATION OF $10,120,000 OUTSTANDING SANITARY DISTRICT BONDS OF 2017, SERIES B DATED: NOVEMBER 30, 2017 BOND PAYMENT PRINCIPAL INTEREST PERIOD YEAR DATE BALANCE PRINCIPAL RATE INTEREST TOTAL TOTAL 1/1/2022 10,120,000$ 505,000$ 2.00% 101,200.00$ 606,200.00$ 606,200.00$ 7/1/2022 96,150.00 96,150.00 1/1/2023 9,615,000 515,000 2.00% 96,150.00 611,150.00 707,300.00 7/1/2023 91,000.00 91,000.00 1/1/2024 9,100,000 525,000 2.00% 91,000.00 616,000.00 707,000.00 7/1/2024 85,750.00 85,750.00 1/1/2025 8,575,000 535,000 2.00% 85,750.00 620,750.00 706,500.00 7/1/2025 80,400.00 80,400.00 1/1/2026 8,040,000 550,000 2.00% 80,400.00 630,400.00 710,800.00 7/1/2026 74,900.00 74,900.00 1/1/2027 7,490,000 560,000 2.00% 74,900.00 634,900.00 709,800.00 7/1/2027 69,300.00 69,300.00 1/1/2028 6,930,000 570,000 2.00% 69,300.00 639,300.00 708,600.00 7/1/2028 63,600.00 63,600.00 1/1/2029 6,360,000 580,000 2.00% 63,600.00 643,600.00 707,200.00 7/1/2029 57,800.00 57,800.00 1/1/2030 5,780,000 595,000 2.00% 57,800.00 652,800.00 710,600.00 7/1/2030 51,850.00 51,850.00 1/1/2031 5,185,000 605,000 2.00% 51,850.00 656,850.00 708,700.00 7/1/2031 45,800.00 45,800.00 1/1/2032 4,580,000 615,000 2.00% 45,800.00 660,800.00 706,600.00 7/1/2032 39,650.00 39,650.00 1/1/2033 3,965,000 630,000 2.00% 39,650.00 669,650.00 709,300.00 7/1/2033 33,350.00 33,350.00 1/1/2034 3,335,000 640,000 2.00% 33,350.00 673,350.00 706,700.00 7/1/2034 26,950.00 26,950.00 1/1/2035 2,695,000 655,000 2.00% 26,950.00 681,950.00 708,900.00 7/1/2035 20,400.00 20,400.00 1/1/2036 2,040,000 665,000 2.00% 20,400.00 685,400.00 705,800.00 7/1/2036 13,750.00 13,750.00 1/1/2037 1,375,000 680,000 2.00% 13,750.00 693,750.00 707,500.00 7/1/2037 6,950.00 6,950.00 1/1/2038 695,000 695,000 2.00% 6,950.00 701,950.00 708,900.00 TOTALS 10,120,000$ 1,816,400.00$ 11,936,400.00$ 11,936,400.00$ SEE ACCOUNTANT'S COMPILATION REPORT - 16 - RICHMOND SANITARY DISTRICT SCHEDULE OF AMORTIZATION OF $5,460,000 OUTSTANDING SANITARY DISTRICT REFUNDING BONDS OF 2019 DATED NOVEMBER 1, 2019 BOND PAYMENT PRINCIPAL INTEREST PERIOD YEAR DATE BALANCE PRINCIPAL RATE INTEREST TOTAL TOTAL 1/1/2022 5,460,000$ 500,000$ 4.00% 109,200.00$ 609,200.00$ 609,200.00$ 7/1/2022 99,200.00 99,200.00 1/1/2023 4,960,000 520,000 4.00% 99,200.00 619,200.00 718,400.00 7/1/2023 88,800.00 88,800.00 1/1/2024 4,440,000 545,000 4.00% 88,800.00 633,800.00 722,600.00 7/1/2024 77,900.00 77,900.00 1/1/2025 3,895,000 570,000 4.00% 77,900.00 647,900.00 725,800.00 7/1/2025 66,500.00 66,500.00 1/1/2026 3,325,000 600,000 4.00% 66,500.00 666,500.00 733,000.00 7/1/2026 54,500.00 54,500.00 1/1/2027 2,725,000 635,000 4.00% 54,500.00 689,500.00 744,000.00 7/1/2027 41,800.00 41,800.00 1/1/2028 2,090,000 660,000 4.00% 41,800.00 701,800.00 743,600.00 7/1/2028 28,600.00 28,600.00 1/1/2029 1,430,000 695,000 4.00% 28,600.00 723,600.00 752,200.00 7/1/2029 14,700.00 14,700.00 1/1/2030 735,000 735,000 4.00% 14,700.00 749,700.00 764,400.00 TOTALS 5,460,000$ 1,053,200.00$ 6,513,200.00$ 6,513,200.00$ SEE ACCOUNTANT'S COMPILATION REPORT - 17 - SCHEDULE OF AMORTIZATION OF $16,125,000 OUTSTANDING SANITARY DISTRICT BONDS OF 2019, SERIES C BOND PAYMENT PRINCIPAL INTEREST PERIOD YEAR DATE BALANCE PRINCIPAL RATE INTEREST TOTAL TOTAL 1/1/2022 16,125,000$ 705,000$ 2.00% 161,250.00$ 866,250.00$ 866,250.00$ 7/1/2022 154,200.00 154,200.00 1/1/2023 15,420,000 720,000 2.00% 154,200.00 874,200.00 1,028,400.00 7/1/2023 147,000.00 147,000.00 1/1/2024 14,700,000 735,000 2.00% 147,000.00 882,000.00 1,029,000.00 7/1/2024 139,650.00 139,650.00 1/1/2025 13,965,000 750,000 2.00% 139,650.00 889,650.00 1,029,300.00 7/1/2025 132,150.00 132,150.00 1/1/2026 13,215,000 765,000 2.00% 132,150.00 897,150.00 1,029,300.00 7/1/2026 124,500.00 124,500.00 1/1/2027 12,450,000 780,000 2.00% 124,500.00 904,500.00 1,029,000.00 7/1/2027 116,700.00 116,700.00 1/1/2028 11,670,000 795,000 2.00% 116,700.00 911,700.00 1,028,400.00 7/1/2028 108,750.00 108,750.00 1/1/2029 10,875,000 810,000 2.00% 108,750.00 918,750.00 1,027,500.00 7/1/2029 100,650.00 100,650.00 1/1/2030 10,065,000 825,000 2.00% 100,650.00 925,650.00 1,026,300.00 7/1/2030 92,400.00 92,400.00 1/1/2031 9,240,000 845,000 2.00% 92,400.00 937,400.00 1,029,800.00 7/1/2031 83,950.00 83,950.00 1/1/2032 8,395,000 860,000 2.00% 83,950.00 943,950.00 1,027,900.00 7/1/2032 75,350.00 75,350.00 1/1/2033 7,535,000 875,000 2.00% 75,350.00 950,350.00 1,025,700.00 7/1/2033 66,600.00 66,600.00 1/1/2034 6,660,000 895,000 2.00% 66,600.00 961,600.00 1,028,200.00 7/1/2034 57,650.00 57,650.00 1/1/2035 5,765,000 915,000 2.00% 57,650.00 972,650.00 1,030,300.00 7/1/2035 48,500.00 48,500.00 1/1/2036 4,850,000 930,000 2.00% 48,500.00 978,500.00 1,027,000.00 7/1/2036 39,200.00 39,200.00 1/1/2037 3,920,000 950,000 2.00% 39,200.00 989,200.00 1,028,400.00 7/1/2037 29,700.00 29,700.00 1/1/2038 2,970,000 970,000 2.00% 29,700.00 999,700.00 1,029,400.00 7/1/2038 20,000.00 20,000.00 1/1/2039 2,000,000 990,000 2.00% 20,000.00 1,010,000.00 1,030,000.00 7/1/2039 10,100.00 10,100.00 1/1/2040 1,010,000 1,010,000 2.00% 10,100.00 1,020,100.00 1,030,200.00 TOTALS 16,125,000$ 3,255,350.00$ 19,380,350.00$ 19,380,350.00$ RICHMOND SANITARY DISTRICT DATED: NOVEMBER 1, 2019 SEE ACCOUNTANT'S COMPILATION REPORT - 18 - SCHEDULE OF AMORTIZATION OF $6,455,000 OUTSTANDING SANITARY DISTRICT BONDS OF 2021, SERIES D BOND PAYMENT PRINCIPAL INTEREST PERIOD YEAR DATE BALANCE PRINCIPAL RATE INTEREST TOTAL TOTAL 1/1/2022 6,455,000$ 92,163.06$ 92,163.06$ 92,163.06$ 7/1/2022 64,550.00 64,550.00 1/1/2023 6,455,000 1,000$ 2.00% 64,550.00 65,550.00 130,100.00 7/1/2023 64,540.00 64,540.00 1/1/2024 6,454,000 1,000 2.00% 64,540.00 65,540.00 130,080.00 7/1/2024 64,530.00 64,530.00 1/1/2025 6,453,000 299,000 2.00% 64,530.00 363,530.00 428,060.00 7/1/2025 61,540.00 61,540.00 1/1/2026 6,154,000 304,000 2.00% 61,540.00 365,540.00 427,080.00 7/1/2026 58,500.00 58,500.00 1/1/2027 5,850,000 315,000 2.00% 58,500.00 373,500.00 432,000.00 7/1/2027 55,350.00 55,350.00 1/1/2028 5,535,000 320,000 2.00% 55,350.00 375,350.00 430,700.00 7/1/2028 52,150.00 52,150.00 1/1/2029 5,215,000 325,000 2.00% 52,150.00 377,150.00 429,300.00 7/1/2029 48,900.00 48,900.00 1/1/2030 4,890,000 335,000 2.00% 48,900.00 383,900.00 432,800.00 7/1/2030 45,550.00 45,550.00 1/1/2031 4,555,000 340,000 2.00% 45,550.00 385,550.00 431,100.00 7/1/2031 42,150.00 42,150.00 1/1/2032 4,215,000 345,000 2.00% 42,150.00 387,150.00 429,300.00 7/1/2032 38,700.00 38,700.00 1/1/2033 3,870,000 355,000 2.00% 38,700.00 393,700.00 432,400.00 7/1/2033 35,150.00 35,150.00 1/1/2034 3,515,000 360,000 2.00% 35,150.00 395,150.00 430,300.00 7/1/2034 31,550.00 31,550.00 1/1/2035 3,155,000 370,000 2.00% 31,550.00 401,550.00 433,100.00 7/1/2035 27,850.00 27,850.00 1/1/2036 2,785,000 375,000 2.00% 27,850.00 402,850.00 430,700.00 7/1/2036 24,100.00 24,100.00 1/1/2037 2,410,000 380,000 2.00% 24,100.00 404,100.00 428,200.00 7/1/2037 20,300.00 20,300.00 1/1/2038 2,030,000 390,000 2.00% 20,300.00 410,300.00 430,600.00 7/1/2038 16,400.00 16,400.00 1/1/2039 1,640,000 400,000 2.00% 16,400.00 416,400.00 432,800.00 7/1/2039 12,400.00 12,400.00 1/1/2040 1,240,000 405,000 2.00% 12,400.00 417,400.00 429,800.00 7/1/2040 8,350.00 8,350.00 1/1/2041 835,000 415,000 2.00% 8,350.00 423,350.00 431,700.00 7/1/2041 4,200.00 4,200.00 1/1/2042 420,000 420,000 2.00% 4,200.00 424,200.00 428,400.00 TOTALS 6,455,000$ 1,645,683.06$ 8,100,683.06$ 8,100,683.06$ RICHMOND SANITARY DISTRICT DATED: APRIL 14, 2021 SEE ACCOUNTANT'S COMPILATION REPORT - 19 - RICHMOND SANITARY DISTRICTSCHEDULE OF COMBINED DEBT SERVICE2015B 2019 BONDPAYMENT 2009A 2012A 2012B REFUNDING 2017B REFUNDING 2019 2021 COMBINED YEARDATES BONDS BONDS BONDS BONDS BONDS BONDS BONDS BONDS TOTAL TOTAL1/1/2022 92,766.45$ 797,391.25$ 43,480.00$ 1,313,269.00$ 606,200.00$ 609,200.00$ 866,250.00$ 92,163.06$ 4,420,719.76$ 4,420,719.76$ 7/1/2022 12,435.30 76,206.50 - 25,774.00 96,150.00 99,200.00 154,200.00 64,550.00 528,515.80 1/1/2023 94,435.30 806,206.50 43,480.00 1,325,774.00 611,150.00 619,200.00 874,200.00 65,550.00 4,439,995.80 4,968,511.60 7/1/2023 11,053.60 69,892.00 - 13,034.00 91,000.00 88,800.00 147,000.00 64,540.00 485,319.60 1/1/2024 96,053.60 814,892.00 43,480.00 1,343,034.00 616,000.00 633,800.00 882,000.00 65,540.00 4,494,799.60 4,980,119.20 7/1/2024 9,621.35 63,447.75 - 85,750.00 77,900.00 139,650.00 64,530.00 440,899.10 1/1/2025 97,621.35 818,447.75 43,480.00 620,750.00 647,900.00 889,650.00 363,530.00 3,481,379.10 3,922,278.20 7/1/2025 8,138.55 56,917.00 - 80,400.00 66,500.00 132,150.00 61,540.00 405,645.55 1/1/2026 98,138.55 826,917.00 43,480.00 630,400.00 666,500.00 897,150.00 365,540.00 3,528,125.55 3,933,771.10 7/1/2026 6,622.05 50,256.50 - 74,900.00 54,500.00 124,500.00 58,500.00 369,278.55 1/1/2027 99,622.05 835,256.50 43,480.00 634,900.00 689,500.00 904,500.00 373,500.00 3,580,758.55 3,950,037.10 7/1/2027 5,055.00 43,466.25 - 69,300.00 41,800.00 116,700.00 55,350.00 331,671.25 1/1/2028 102,055.00 843,466.25 43,480.00 639,300.00 701,800.00 911,700.00 375,350.00 3,617,151.25 3,948,822.50 7/1/2028 3,420.55 36,546.25 - 63,600.00 28,600.00 108,750.00 52,150.00 293,066.80 1/1/2029 103,420.55 851,546.25 43,480.00 643,600.00 723,600.00 918,750.00 377,150.00 3,661,546.80 3,954,613.60 7/1/2029 1,735.55 29,496.50 - 57,800.00 14,700.00 100,650.00 48,900.00 253,282.05 1/1/2030 104,735.55 859,496.50 43,480.00 652,800.00 749,700.00 925,650.00 383,900.00 3,719,762.05 3,973,044.10 7/1/2030 22,317.00 - 51,850.00 92,400.00 45,550.00 212,117.00 1/1/2031 867,317.00 43,480.00 656,850.00 937,400.00 385,550.00 2,890,597.00 3,102,714.00 7/1/2031 15,007.75 - 45,800.00 83,950.00 42,150.00 186,907.75 1/1/2032 875,007.75 43,480.00 660,800.00 943,950.00 387,150.00 2,910,387.75 3,097,295.50 7/1/2032 7,568.75 - 39,650.00 75,350.00 38,700.00 161,268.75 1/1/2033 882,568.75 43,480.00 669,650.00 950,350.00 393,700.00 2,939,748.75 3,101,017.50 7/1/203333,350.00 66,600.00 35,150.00 135,100.00 1/1/2034673,350.00 961,600.00 395,150.00 2,030,100.00 2,165,200.00 7/1/203426,950.00 57,650.00 31,550.00 116,150.00 1/1/2035681,950.00 972,650.00 401,550.00 2,056,150.00 2,172,300.00 7/1/203520,400.00 48,500.00 27,850.00 96,750.00 1/1/2036685,400.00 978,500.00 402,850.00 2,066,750.00 2,163,500.00 7/1/203613,750.00 39,200.00 24,100.00 77,050.00 1/1/2037693,750.00 989,200.00 404,100.00 2,087,050.00 2,164,100.00 7/1/20376,950.00 29,700.00 20,300.00 56,950.00 1/1/2038701,950.00 999,700.00 410,300.00 2,111,950.00 2,168,900.00 7/1/203820,000.00 16,400.00 36,400.00 1/1/20391,010,000.00 416,400.00 1,426,400.00 1,462,800.00 7/1/203910,100.00 12,400.00 22,500.00 1/1/20401,020,100.00 417,400.00 1,437,500.00 1,460,000.00 7/1/20408,350.00 8,350.00 1/1/2041423,350.00 423,350.00 431,700.00 7/1/20414,200.00 4,200.00 1/1/2042424,200.00 424,200.00 428,400.00 TOTALS 946,930.35$ 10,549,635.75$ 521,760.00$ 4,020,885.00$ 11,936,400.00$ 6,513,200.00$ 19,380,350.00$ 8,100,683.06$ 61,969,844.16$ 61,969,844.16$ SEE ACCOUNTANT'S COMPILATION REPORT- 20 - -$2,000,000 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 $20,000,000 $22,000,000 Sewer and Stormwater Utility Fund Cash Balance Projections CSO LTCP Pay-Go Capital Other Pay-Go Replacements and Capital Asset Management Program Total Debt Service (Existing and New) Operating Costs Revenue (From Rate Adjustment) Revenue (Existing) Combined Fund Balance w/ Rate Increase Combined Fund Balance w/ No Rate Increase Minimum Fund Balance (6 Mo. Operating Costs) Minimum Fund Balance (4 Mo. Operating Costs) 0.00%13.75%5.75%5.75%3.50%3.50%3.00%3.00%3.00%3.00%2.00%2.00% $43.44 $49.41 $52.25 $55.25 $57.18 $59.18 $60.96 $62.79 $64.67 $66.61 $67.94 $69.30 4,000 Gal. Rate Rate Adjustment Richmond Sanitary District 2021 Industrial Surcharge Analysis Background The Richmond Sanitary District accepts liquid wastewater/sewage to be disposed of at the Treatment Plant under the provisions set forth in Richmond City Code Chapter 54. The criteria for standard waste and high strength waste are established in both Chapters 53 and 54 of the City Code. The rate for wastewater discharge, including that of high strength waste, is set forth in Richmond City Code Chapter 53.14, 53.15, and 53.16, stating that, “…In order that the rates and charges may be justly and equitably adjusted to the service rendered to users, the Sanitary District shall base its charges not only on the volume, but also on the strength and character of the stronger than normal domestic sewage and wastes which it is required to treat and dispose of...” This rate was set at $0.52 per pound of TSS exceeding 225 mg/L and $0.52 per pound of BOD exceeding 200 mg/L (Ord. 93-2002). High strength wastewater is derived primarily from the 14 permitted Industrial Users, however, there are a few Commercial Users whose discharge meets the high strength waste criteria. The rate for Industrial Surcharge (high strength) waste is determined by a formula distributing O&M costs of running the Treatment Facility across pounds of TSS and BOD. Purpose The Richmond Sanitary District, following Chapter 53.10, has evaluated the Industrial Surcharge rate for liquid wastewater. Through its analysis of the formula for the current rate as well as the strengths of wastes discharged as seen through both the Richmond Sanitary District’s oversight testing and the required testing of permitted entities, the District would like to establish a “Bulk User” rate. The idea is that certain portions of the O&M costs of the formula, such as natural gas use or disinfection chemical use within the District, do not increase after a certain threshold of the high strength waste. The bulk rate is being proposed to assist large, high strength dischargers currently, or in the future, using the District’s collection system and treatment process. The bulk rate is being proposed to update Chapter 53.16. Data Below are tables depicting current Industrial Surcharge rates and the proposed bulk Industrial Surcharge rate as well as the criteria that will define a “bulk” user. The assigned surcharge rate will be evaluated through the annual amount of BOD + TSS periodically reported to the Richmond Sanitary District Tier Combined Annual Total BOD + TSS (lbs.) 1 (Standard) - < 250,000 2 (Bulk) >250,000 The individual rate category will be established each calendar year (January thru December) based upon the total pounds of BOD and TSS the Richmond Sanitary District processed during the previous 12-month period. The category will be evaluated after the 15th of January; and applied to the next quarterly (Jan, Feb, Mar) surcharge invoice. Tier BOD per pound treatment rate TSS per pound treatment rate 1 0.52 0.52 2 0.31 0.31 Richmond Sanitary District 2021 Liquid Waste Hauler Analysis Background The Richmond Sanitary District allows liquid wastewater, classified as sludge, septic tank, grease trap, or leachate, to be disposed of at the Treatment Plant under the provisions set forth in Richmond City Code Chapter 54.35. The rate for liquid wastewater discharge is set forth in Richmond City Code Chapter 53.17, stating that, “Waste from septic tanks, waste from grease traps and treatment plant residuals (industrial or municipal) shall be charged at a rate per 100 gallons to be set from time to time by Common Council. (Ord. 42-1991).” The last time this rate was set was in December of 1996. Hauled liquid wastewater is derived primarily outside of the District’s boundaries. Septic tank waste generally come from surrounding communities within the county and neighboring counties. Grease trap waste has a few sources within the District and/or county, but is primarily from more distant communities such as Dayton and Indianapolis. That this waste comes from distant sources is likely due to the District’s low rate and the fact that not many wastewater treatment plants accept grease. Sludge waste is primarily sourced from local industries. Leachate come from neighboring landfills such as those in Randolph, Jay, and Hendricks county Indiana. This waste’s distant source is explained in the same manner as that of grease traps. The rate for hauled liquid waste is determined by a formula factoring in the both the current Commercial rate of wastewater and the high strength, Industrial surcharge rate. Since 1996, both the Commercial rate of wastewater treatment and Industrial surcharge have changed, however, the liquid wastewater rate went unchanged. Purpose The Richmond Sanitary District, following Chapter 53.17, has evaluated the 26 year old rate for liquid wastewater. The District samples, and analyses, wastewater of liquid wastewater hauled into the facility. The District used the current average strength (BOD + TSS) of these wastes, and placed this value into the current rates for commercial wastewater treatment and industrial surcharge. The 1996 rates were separated into three categories, Septic (gray water), Grease, and Sludge. As these categorizations do not always fit the manner in which the waste is treated, the District averaged the updated rates into a single rate. This single rate is being proposed to update Chapter 53.17. Data Below are tables depicting current commercial wastewater and industrial surcharge rates, current and proposed hauled liquid wastewater rates, a comparison of hauled liquid wastewater rates from neighboring facilities, and a breakdown of current volumes of hauled liquid wastes received. Commercial Wastewater Treatment rate per 1,000 gallons per month Industrial Surcharge (high strength waste with BOD in excess of 200 mg/L and TSS in excess of 225 mg/L) $5.25 $0.52/pound of BOD $0.52/pound of TSS Type of Liquid Waste Current Rate/100 Gallons Proposed Rate/100 Gallons Septic Tank $3.50 $9.61 Sludge $5.25 $9.61 Oil and Grease $7.00 $9.61 Leachate $3.50 $9.61 Facility In District Rate/100 Gallons Out of District Rate/100 Gallons Notes New Castle $13.16 $13.16 2019 Rate: Only Accepts Septic Muncie $6.00 $6.00 2018 Rate: Only Accepts Septic Evansville $8.30 $8.30 2020 Rate Terre Haute $8.00 $20.00 2020 Rate Connersville $5.00 Does Not Accept 2022 Rate: Only Accepts Septic Merrell Brothers (Indianapolis) $11.60 $11.60 2022 Rate Anderson $14.00 Does Not Accept 2020 Rate Type of Waste 2019 Gallons Received 2020 Gallons Received 2021 Gallons Received Septic Tank 1,517,336 1,763,152 1,967,933 Sludge 286,009 210,151 265,065 Oil and Grease 126,639 118,356 92,803 Leachate 2,406,600 12,168,916 9,094,674 2019 Revenue Received 2020 Revenue Received 2021 Revenue Received Septic Tank $53,106.77 $61,710.33 $69,709.10 Sludge $15,015.45 $11,032.94 $13,817.51 Oil and Grease $8,864.76 $8,284.92 $6,569.70 Leachate $84,231.00 $425,912.07 $322,036.46