|
<br />Schedule 6 - Pro Forma
<br />FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034
<br />Sanitation
<br />Sanitation User Charge Revenue
<br />Revenue from Growth
<br />$5,935,520
<br />-
<br />5,935,520
<br />14,839
<br />13,120,540
<br />32,801
<br />13,613,708
<br />34,034
<br />14,125,414
<br />35,314
<br />14,656,353
<br />36,641
<br />15,207,248
<br />38,018
<br />15,778,851
<br />39,447
<br />16,371,938
<br />40,930
<br />16,987,319
<br />42,468
<br />17,625,829
<br />44,065
<br />Revenue Before Charge Increase
<br />User Charge Increase
<br />Revenue from Charge Increase
<br />$5,935,520 5,950,358
<br />120.5%
<br />7,170,182
<br />13,153,341
<br />3.5%
<br />13,647,743
<br />3.5%
<br />14,160,727
<br />3.5%
<br />14,692,994
<br />3.5%
<br />15,245,266
<br />3.5%
<br />15,818,298
<br />3.5%
<br />16,412,868
<br />3.5%
<br />17,029,787
<br />3.5%
<br />17,669,894
<br />3.5%0.0%
<br />-460,367 477,671 495,625 514,255 533,584 553,640 574,450 596,043 618,446
<br />Total Sanitation User Charge Revenue
<br />Plus: Other Operating Revenues
<br />Operating Income
<br />$
<br />$
<br />$
<br />5,935,520
<br />15,432
<br />13,120,540
<br />15,432
<br />13,613,708
<br />15,432
<br />14,125,414
<br />15,432
<br />14,656,353
<br />15,432
<br />15,207,248
<br />15,432
<br />15,778,851
<br />15,432
<br />16,371,938
<br />15,432
<br />16,987,319
<br />15,432
<br />17,625,829
<br />15,432
<br />18,288,340
<br />15,432
<br />5,950,951 13,135,973 13,629,140 14,140,845 14,671,784 15,222,680 15,794,282 16,387,370 17,002,750 17,641,261 18,303,772
<br />Less: Operating Expenses
<br />Personal Services
<br />Fixed Operations & Maintenance
<br />$ (3,249,280)
<br />(4,374,890)
<br />(4,210,152)
<br />(8,318,478)
<br />(4,378,473)
<br />(8,771,554)
<br />(4,553,524)
<br />(9,090,364)
<br />(4,735,574)
<br />(9,520,966)
<br />(4,924,904)(5,121,804)(5,326,577)(5,539,539)(5,761,015)(5,991,348)
<br />(9,763,803) (10,119,334) (10,488,037) (10,870,407) (11,266,958) (11,678,224)
<br />Total Operating Expenses
<br />Net Operating Income
<br />$ (7,624,170) (12,528,630) (13,150,027) (13,643,888) (14,256,540) (14,688,707) (15,241,138) (15,814,614) (16,409,945) (17,027,973) (17,669,571)
<br />$ (1,673,219)607,343 479,113 496,957 415,244 533,973 553,144 572,756 592,805 613,288 634,201
<br />Plus (Less): Non-Operating Income in Debt Service Coverage Test
<br />Non-Operating Revenue
<br />Interest Earnings
<br />Capital Outlay
<br />$30,017
<br />39,443
<br />(398,030)
<br />30,017
<br />29,536
<br />(398,030)
<br />30,017
<br />27,295
<br />(398,030)
<br />30,017
<br />27,576
<br />(398,030)
<br />30,017
<br />27,437
<br />(398,030)
<br />30,017
<br />27,111
<br />(398,030)
<br />30,017
<br />27,293
<br />(398,030)
<br />30,017
<br />27,841
<br />(398,030)
<br />30,017
<br />28,522
<br />(398,030)
<br />30,017
<br />29,117
<br />(398,030)
<br />30,017
<br />29,532
<br />(398,030)
<br />Total Non-Operating $(128,571)(338,478)
<br />268,865
<br />(340,719)
<br />138,395
<br />(340,438)
<br />156,520
<br />(340,576)
<br />74,667
<br />(340,903)
<br />193,070
<br />(340,721)
<br />212,423
<br />(340,172)
<br />232,584
<br />(339,491)
<br />253,314
<br />(338,897)
<br />274,391
<br />(338,482)
<br />295,719Net Income Before Debt Service $ (1,801,790)
<br />Debt Service & Coverage
<br />Existing Senior Lien Debt Service $80,254 88,032 103,925 120,767 145,077 204,322 155,613 152,210 163,438 215,741 250,541
<br />Total Senior Lien Debt Service $80,254 88,032 103,925 120,767 145,077 204,322 155,613 152,210 163,438 215,741 250,541
<br />Senior Lien Debt Service Coverage -22.45 3.05 1.33 1.30 0.51 0.94 1.37 1.53 1.55 1.27 1.18
<br />Total Debt Service
<br />Net Cash Flow
<br />$80,254 88,032 103,925
<br />34,470
<br />120,767
<br />35,753
<br />145,077
<br />(70,410)
<br />204,322
<br />(11,252)
<br />155,613
<br />56,810
<br />152,210
<br />80,374
<br />163,438
<br />89,876
<br />215,741
<br />58,650
<br />250,541
<br />45,178$ (1,882,044)180,833
<br />Fund Balance
<br />Balance at Beginning of Fiscal Year
<br />Net Cash Flow
<br />$
<br />$
<br />$
<br />$
<br />$
<br />5,871,357
<br />(1,882,044)
<br />3,989,313
<br />180,832
<br />3,394,627
<br />34,470
<br />3,429,096
<br />35,753
<br />3,464,849
<br />(70,410)
<br />3,394,439
<br />(11,252)
<br />3,383,187
<br />56,810
<br />3,439,997
<br />80,374
<br />3,520,371
<br />89,876
<br />3,610,247
<br />58,650
<br />3,668,897
<br />45,178
<br />Total Funds Available
<br />Less: Planned Cash Funded Capital
<br />3,989,313 4,170,145
<br />(775,518)
<br />3,429,096 3,464,849 3,394,439 3,383,187 3,439,997 3,520,371 3,610,247 3,668,897 3,714,075
<br />----------
<br />Balance of Working Capital
<br />Less: Working Capital Reserve Target
<br />3,989,313
<br />(1,524,834)
<br />3,394,627
<br />(2,505,726)
<br />3,429,096
<br />(2,630,005)
<br />3,464,849
<br />(2,728,778)
<br />3,394,439
<br />(2,851,308)
<br />3,383,187
<br />(2,937,741)
<br />3,439,997
<br />(3,048,228)
<br />3,520,371
<br />(3,162,923)
<br />3,610,247
<br />(3,281,989)
<br />3,668,897
<br />(3,405,595)
<br />3,714,075
<br />(3,533,914)
<br />Surplus/Deficit of Working Capital
<br />Add Back: Working Capital Reserve
<br />2,464,479
<br />1,524,834
<br />888,901
<br />2,505,726
<br />799,091
<br />2,630,005
<br />736,071
<br />2,728,778
<br />543,131
<br />2,851,308
<br />445,445
<br />2,937,741
<br />391,769
<br />3,048,228
<br />357,448
<br />3,162,923
<br />328,258
<br />3,281,989
<br />263,302
<br />3,405,595
<br />180,161
<br />3,533,914
<br />Balance at End of Fiscal Year 3,989,313 3,394,627 3,429,096 3,464,849 3,394,439 3,383,187 3,439,997 3,520,371 3,610,247 3,668,897 3,714,075
|