USVI Public Records

Document text

U.S. Virgin Islands Water and Power Authority Preliminary Draft - Work in Process / Subject to Material Change Information contained herein has not been independently verified and is subject to material change based on continuing review. Accordingly, the information contained herein is not intended to be and should not be relied upon by any third party or as legal, auditing, or accounting advice. The attached preliminary cash flow tool and their accompanying analyses, assumptions and underlying data are the product of U.S. Virgin Islands Water and Power Authority ("WAPA") and its management (“Management”) and consist of information obtained solely from WAPA. With respect to prospective financial information relative to WAPA, there has not been any examination, compilation or application of agreed upon procedures to such information in accordance with attestation standards established by the AICPA. Consequently, no assurance of any kind is given with respect to, or on, the information presented. It is WAPA’s responsibility to make its own decision based on the information available to it. Management has the knowledge, experience and ability to form its own conclusions related to WAPA's cash flow forecast. There will usually be differences between forecasted and actual results because events and circumstances frequently do not occur as expected and those differences may be material. As a result, no responsibility for the achievement of forecasted results is made. Accordingly, reliance on this report is prohibited by any third party as the projected financial information contained herein is subject to material change and may not reflect actual results. Many of numbers set forth herein are estimates or based on assumptions which are subject to change. Such changes may be material and can materially affect the calculation of other amounts reflected herein. Preliminary Draft - Subject to Material Change 1 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B1 - Differential Analysis Total Cost ($) $ / kgal Current As Approved Proposed LEAC Current As Approved Proposed LEAC Difference Cross Reference (Col E-F) Line # Jan-Dec 2023 Jan-Dec 2024 Jan-Dec 2023 Jan-Dec 2024 2024 vs. 2023 WS # Line # 1 Total Fuel Cost - $ - $ - $ - $ - $ B2 1 2 Regulatory Expense (Docket 289 Costs) 10,080 10,080 0.01 0.01 (0.00) B2 2 3 Current Fuel Costs 10,080 $ 10,080 $ 0.01 $ 0.01 $ (0.00) $ B2 3 Net Water Production Charge / RO - Excludes Sales to Electric 4 Total Cost of Purchased Water - Due to Seven Seas 11,993,669 $ 12,593,012 $ 9.67 $ 9.82 $ 0.15 $ B2 4 5 Less: Electric System Billings for Internal Plant Use - Water (1,555,229) (1,617,571) (1.25) (1.26) (0.01) B2 5 6 Less: Electric System Billings for STT Station #2 Use - Water (289,248) (298,851) (0.23) (0.23) 0.00 B2 6 7 Net Water Production Charge / RO (Sum Lines 4-6) 10,149,193 $ 10,676,591 $ 8.18 $ 8.32 $ 0.14 $ B2 7 Net Electricity Charge for Purchased Water 8 Total Electricy Charges for Purchased Water 5,392,750 $ 5,434,993 $ 4.35 $ 4.24 $ (0.11) $ B2 8 9 Less: Electric System Billings for Internal Plant Use - Electricity (153,427) (197,346) (0.12) (0.15) (0.03) B2 9 10 Net Electricity Charge for Purchased Water (Line 8+9) 5,239,323 $ 5,237,647 $ 4.22 $ 4.08 $ (0.14) $ B2 10 11 Current Purchased Water Costs (Line 7+10) 15,388,515 $ 15,914,238 $ 12.40 $ 12.40 $ 0.00 $ B2 11 12 Total Current Water Costs - Net (Line 3+11) 15,398,595 $ 15,924,318 $ 12.41 $ 12.41 $ 0.00 $ B2 12 13 Less: Base Rate Recovery (3,572,926) (3,694,846) (2.88) (2.88) - B2 13 14 Current LEAC Costs (Line 12+13) 11,825,669 $ 12,229,472 $ 9.53 $ 9.53 $ 0.00 $ B2 14 Deferred Fuel Costs 15 Amortized GO Note Principal and Interest - $ - $ - $ - $ - $ B2 15 16 Other Amortized Deferred Fuel Costs - - - - - B2 16 17 Total Deferred Costs - $ - $ - $ - $ - $ B2 17 18 Total Period Costs (Line 14+17) 11,825,669 $ 12,229,472 $ 9.53 $ 9.53 $ 0.00 $ B2 18 Preliminary Draft - Subject to Material Change 2 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B2 - 12-Month Comparison Current As Approved Proposed LEAC Cross Reference Line # Jan-Dec 2023 Jan-Dec 2024 WS # Line # Summary of Costs 1 Total Fuel Cost - $ - $ B4 22 2 Regulatory Expense (Docket 289 Costs) 10,080 10,080 B5 3 3 Current Fuel Costs 10,080 $ 10,080 $ B5 4 Net Water Production Charge / RO - Excludes Sales to Electric 4 Total Cost of Purchased Water - Due to Seven Seas 11,993,669 $ 12,593,012 $ B4 16 5 Less: Electric System Billings for Internal Plant Use - Water (1,555,229) (1,617,571) B4 18 6 Less: Electric System Billings for STT Station #2 Use - Water (289,248) (298,851) B4 20 7 Net Water Production Charge / RO (Sum Lines 4-6) 10,149,193 $ 10,676,591 $ Net Electricity Charge for Purchased Water 8 Total Electricy Charges for Purchased Water 5,392,750 $ 5,434,993 $ B4 17 9 Less: Electric System Billings for Internal Plant Use - Electricity (153,427) (197,346) B4 19 10 Net Electricity Charge for Purchased Water (Line 8+9) 5,239,323 $ 5,237,647 $ 11 Current Purchased Water Costs (Line 7+10) 15,388,515 $ 15,914,238 $ B4 21 12 Total Current Water Costs - Net (Line 3+11) 15,398,595 $ 15,924,318 $ B5 11 13 Less: Base Rate Recovery (3,572,926) (3,694,846) B5 13 14 Current LEAC Costs (Line 12+13) 11,825,669 $ 12,229,472 $ B5 14 Deferred Fuel Costs 15 Amortized GO Note Principal and Interest - $ - $ B5 15 16 Other Amortized Deferred Fuel Costs - - B5 16+17 17 Total Deferred Costs - $ - $ 18 Total Period Costs (Line 14+17) 11,825,669 $ 12,229,472 $ B5 18 Summary of Costs - $/kgal 19 Sales Forecast 1,240,599 1,282,933 B4 6 20 Total Fuel Cost - $ - $ 21 Regulatory Expense (Docket 289 Costs) 0.01 0.01 22 Current Fuel Costs 0.01 $ 0.01 $ Net Water Production Charge / RO - Excludes Sales to Electric 23 Total Cost of Purchased Water - Due to Seven Seas 9.67 $ 9.82 $ 24 Less: Electric System Billings for Internal Plant Use - Water (1.25) (1.26) 25 Less: Electric System Billings for STT Station #2 Use - Water (0.23) (0.23) 26 Net Water Production Charge / RO (Sum Lines 23-25) 8.18 $ 8.32 $ Net Electricity Charge for Purchased Water 27 Total Electricy Charges for Purchased Water 4.35 $ 4.24 $ 28 Less: Electric System Billings for Internal Plant Use - Electricity (0.12) (0.15) 29 Net Electricity Charge for Purchased Water (Line 27+28) 4.22 $ 4.08 $ 30 Current Purchased Water Costs (Line 26+29) 12.40 $ 12.40 $ 31 Total Current Water Costs - Net (Line 3+11) 12.41 $ 12.41 $ 32 Less: Base Rate Recovery (2.88) (2.88) 33 Current LEAC Costs (Line 31+32) 9.53 $ 9.53 $ Deferred Fuel Costs 34 Amortized GO Note Principal and Interest - - 35 Other Amortized Deferred Fuel Costs - - 36 Total Deferred Costs - $ - $ 37 Total Period Costs - LEAC Rate (Line 33+36) 9.53 $ 9.53 $ Preliminary Draft - Subject to Material Change 3 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B3 - Monthly Bill Comparison Line # Rate Class Residential Commercial Large Power 1 Average Monthly Usage - kgal 2.4 25.0 95.0 2 Change in LEAC Rate - $ / kgal - - - 3 Impact to Bill (Monthly) - $ - $ - $ Avg. Monthly Usage - gal Change in LEAC Rate ($/kgal) Impact to Bill 4 2,000 - - $ 5 8,000 - - $ 6 14,000 - - $ 7 20,000 - - $ 8 26,000 - - $ 9 32,000 - - $ 10 38,000 - - $ 11 44,000 - - $ 12 50,000 - - $ 13 56,000 - - $ 14 62,000 - - $ 15 68,000 - - $ 16 74,000 - - $ 17 80,000 - - $ 18 86,000 - - $ 19 92,000 - - $ 20 98,000 - - $ Preliminary Draft - Subject to Material Change 4 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B4 - Water Sales and Costs Current As Approved Proposed LEAC Cross Reference Line # Jan-Dec 2023 Jan-Dec 2024 WS # Line # Water Sales and Production 1 Gross Production - kgal 2,086,898 2,096,505 B8 / B10 18 2 Less: Ultra Pure Water Production (Line 2+10) (39,696) (46,520) B10 19 3 Available Production Before Plant Use and Line Loss (Line 1+2) 2,047,203 2,049,986 4 Well Storage Available for Sale - kgal - - B8 / B10 24 5 Line Loss - kgal (Approved includes UPW Production) (806,603) (767,053) B8 / B10 25 6 Sales Forecast - kgal (Line 3+4-5) 1,240,599 1,282,933 B8 / B10 26 59% Water Production Costs 7 Gross Production - kgal 2,086,898 2,096,505 B9 / B11 71 8 % Provided by Electric System 0% 0% B9 / B11 72 9 Quantity Provided by Electric System - kgal (Line 15x16) - - B9 / B11 73 9 Net Purchases from Seven Seas - kgal 2,086,898 2,096,505 B9 / B11 74 10 Net Purchases - Millions of Gallons per Day (MGD) 5.718 5.744 B9 / B11 75 11 Sales to Electric System - kgal 178,850 178,850 B9 / B11 76 12 % Ultra Pure Water (UPW) 100% 100% B9 / B11 77 13 Ultra Pure Water Sales to Electric System - kgal (Line 11x12) 178,850 178,850 B9 / B11 78 14 Regular Water Sales to Electric System - kgal (Line 11-13) - - B9 / B11 79 15 Power from Electic System - kWh 24,269,800 24,459,915 B9 / B11 80 Summary of Projected Costs ($) 16 Total Cost of Purchased Water - Due to Seven Seas 11,993,669 $ 12,593,012 $ B9 / B11 81 17 Total Electricy Charges - Due to Electric System 5,392,750 5,434,993 B9 / B11 82 18 Less: Electric System Billings for Internal Plant Use - Water (1,555,229) (1,617,571) B9 / B11 83 19 Less: Electric System Billings for Internal Plant Use - Electricity (153,427) (197,346) B9 / B11 84 20 Less: Electric System Billings for STT Station #2 Use - Water (289,248) (298,851) B9 / B11 85 21 Total Water Purchase Costs - Billed to Customers (Sum Lines 16-20) 15,388,515 $ 15,914,238 $ B9 / B11 86 Fuel Costs to Produce Water ($) 22 Allocated Fuel Costs - Due to Electric System - $ - $ 23 Total Water Production Costs (Line 21+22) 15,388,515 $ 15,914,238 $ 24 Average Cost per kgal Sold (Line 23/6) 12.40 $ 12.40 $ Preliminary Draft - Subject to Material Change 5 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B4a - Production and Sales Trailing Twelve Months Line # Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 1 Gross Production - kgal 2,086,898 2,069,068 2,067,293 2,076,901 2,081,600 2,099,739 2,095,293 2,096,607 2,096,505 2 Less: Ultra Pure Water Production (39,696) (39,380) (39,714) (40,378) (41,068) (42,776) (44,545) (46,082) (46,520) 3 Available Production Before Plant Use and Line Loss (Line 1+2) 2,047,203 2,029,688 2,027,579 2,036,523 2,040,531 2,056,964 2,050,748 2,050,525 2,049,986 4 Line Loss - kgal (806,603) (706,451) (615,235) (672,766) (619,472) (637,420) (679,791) (740,983) (718,653) 5 Line Loss Percentage -39% -35% -30% -33% -30% -31% -33% -36% -35% 6 Sales Forecast - kgal (Line 3+4-5) 1,240,599 1,323,237 1,412,344 1,363,756 1,421,059 1,419,544 1,370,957 1,309,542 1,331,333 7 Average Line Loss 34% 8 Standard Deviation - Line Loss 3% Preliminary Draft - Subject to Material Change 6 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B5 - Water LEAC True-Up Current As Approved Proposed LEAC Cross Reference Line # Jan-Dec 2023 Jan-Dec 2024 WS # Line # Water Sales 1 Water Sales - kgal 1,240,599 1,282,933 B4 6 Cost of Fuel ($) 2 Total Fuel Cost - $ - $ B4 22 3 Regulatory Expense 10,080 10,080 4 Current Fuel Costs 10,080 $ 10,080 $ Current Non-Fuel Expenses ($) 5 Total Cost of Purchased Water 11,993,669 $ 12,593,012 $ B4 16 6 Total Electricity Charge - Due to Electric System 5,392,750 5,434,993 B4 17 7 Less: Electric System Billings for Internal Plant Use - Water (1,555,229) (1,617,571) B4 18 8 Less: Electric System Billings for Internal Plant Use - Electricity (153,427) (197,346) B4 19 9 Less: Electric System Billings for STT Station #2 Use - Water (289,248) (298,851) B4 20 10 Total Purchased Water Costs (Sum Lines 5-9) 15,388,515 $ 15,914,238 $ B4 21 11 Total Current Costs (Lines 4+10) 15,398,595 $ 15,924,318 $ Recovery of Current and Prior Period Costs ($) 12 Base Rate / kgal 2.88 $ 2.88 $ 13 Base Rate Recovery (Line 1x12) 3,572,926 3,694,846 14 Unrecovered Costs - Current Fuel & Purchased Water (Line 11-13) 11,825,669 $ 12,229,472 $ 15 Refinanced GO Note Principal & Interest - - 16 Prior Period Billing Adjustments - - 17 Planned Recovery of Deferred Balance - - 18 Total Costs (sum Lines 14-17) 11,825,669 $ 12,229,472 $ LEAC Detail 19 LEAC Rate - $/kgal (Line 18/1) 9.53 $ 9.53 $ 20 LEAC Cost Recovery (Line 1x19) 11,825,669 $ 12,229,472 $ 21 Base Rate Recovery (Line 13) 3,572,926 3,694,846 22 Less: Regulatory Expense (Line 3) (10,080) (10,080) 23 Less: Purchased Water Cost (Line 10) (15,388,515) (15,914,238) 24 Less: Debt Service Recovery (Line 15) - - 25 Less: Prior Period Billing Adjustments (Line 16) - - 26 Less: Community Disaster Loan Payments to Seven Seas - - 27 Net LEAC Recovery - $ - $ 28 Over / (Under) Recovery - $ - $ Preliminary Draft - Subject to Material Change 7 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B6 - Historical Water Sales Cross Reference Line # Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 WS # Line # St. Thomas 1 Gross Production - kgal 77,046 65,478 72,454 75,773 73,030 88,181 81,767 87,645 56,791 83,419 68,229 74,087 71,700 76,255 87,642 82,017 90,859 81,022 74,239 87,648 B7 1 2 Less: Ultra Pure Water Production (2,287) (1,774) (1,937) (2,270) (1,564) (1,696) (1,952) (2,434) (2,095) (2,533) (2,228) (2,345) (1,625) (1,778) (2,180) (2,421) (2,510) (2,374) (2,512) (2,433) B7 18a 3 Available Production Before Plant Use and Line Loss (Line 1+2) 74,758 63,704 70,517 73,503 71,466 86,485 79,815 85,211 54,695 80,886 66,001 71,743 70,075 74,478 85,462 79,596 88,349 78,648 71,727 85,216 Well Storage Available for Sale 3 Beginning Inventory - kgal - - - - - - - - - - - - - - - - - - - - 4 Less: Ending Inventory - - - - - - - - - - - - - - - - - - - - 5 Less: Inventory Adjustments - - - - - - - - - - - - - - - - - - - - 6 Total Well Storage Available for Sale - kgal (Sum Lines 3-5) - - - - - - - - - - - - - - - - - - - - 7 Less: Plant Use and Line Loss (13,401) 24,706 (28,601) 2,878 (20,110) (15,907) 418 (41,107) 10,027 (4,670) 4,148 (58,593) 77,876 110,564 (76,711) 47,748 (26,745) (37,095) (12,635) (22,268) 8 Sales - kgal (Line 3+6-7) 61,357 88,410 41,916 76,381 51,356 70,579 80,232 44,103 64,722 76,215 70,149 13,150 147,951 185,042 8,750 127,344 61,604 41,553 59,091 62,947 St. Croix 9 Gross Production - kgal 104,494 96,404 106,701 105,428 103,958 97,561 92,887 102,447 93,126 95,918 85,910 98,167 92,009 83,852 101,120 103,883 104,269 100,274 101,729 102,342 B7 36 10 Less: Ultra Pure Water Production (1,042) (970) (1,107) (956) (1,016) (1,024) (1,006) (1,190) (1,292) (1,232) (1,264) (2,481) (1,389) (1,301) (1,527) (1,496) (1,777) (2,115) (1,983) (1,629) B7 53a 11 Available Production Before Plant Use and Line Loss (Line 9+10) 103,452 95,434 105,594 104,472 102,943 96,537 91,881 101,257 91,834 94,686 84,646 95,685 90,621 82,551 99,594 102,387 102,492 98,159 99,746 100,713 Well Storage Available for Sale 12 Beginning Inventory - kgal - - - - - - - - - - - - - - - - - - - - 13 Less: Ending Inventory - - - - - - - - - - - - - - - - - - - - 14 Less: Inventory Adjustments - - - - - - - - - - - - - - - - - - - - 15 Total Well Storage Available for Sale - kgal (Sum Lines 12-14) - - - - - - - - - - - - - - - - - - - - 16 Less: Plant Use and Line Loss (51,122) (46,271) (55,052) (68,456) (54,732) (52,648) (16,590) (63,160) (61,737) (57,926) (77,416) (61,281) (42,247) (40,913) (64,473) (60,032) (66,045) (73,831) (64,729) (59,668) 17 Sales - kgal (Line 11+15-16) 52,329 49,163 50,542 36,016 48,211 43,889 75,291 38,097 30,097 36,760 7,230 34,405 48,373 41,638 35,120 42,354 36,447 24,328 35,017 41,044 Combined Systems 18 Gross Production - kgal (Line 1+9) 181,539 161,882 179,155 181,201 176,989 185,742 174,654 190,092 149,916 179,337 154,138 172,254 163,709 160,107 188,762 185,900 195,128 181,296 175,968 189,990 B7 71 19 Less: Ultra Pure Water Production (Line 2+10) (3,329) (2,744) (3,044) (3,226) (2,580) (2,720) (2,958) (3,625) (3,387) (3,765) (3,491) (4,826) (3,014) (3,078) (3,707) (3,917) (4,287) (4,489) (4,496) (4,062) 20 Available Production Before Plant Use and Line Loss (Line 18+19) 178,210 159,138 176,111 177,975 174,409 183,022 171,695 186,468 146,529 175,572 150,647 167,428 160,695 157,029 185,055 181,983 190,841 176,807 171,473 185,928 3,527,759 Well Storage Available for Sale 21 Beginning Inventory - kgal (Line 3+12) - - - - - - - - - - - - - - - - - - - - 22 Less: Ending Inventory (Line 4+13) - - - - - - - - - - - - - - - - - - - - 23 Less: Inventory Adjustments (Line 5+14) - - - - - - - - - - - - - - - - - - - - 24 Total Well Storage Available for Sale - kgal (Sum Lines 21-23) - - - - - - - - - - - - - - - - - - - - 25 Less: Plant Use and Line Loss (64,523) (21,565) (83,653) (65,578) (74,842) (68,555) (16,172) (104,267) (51,710) (62,597) (73,267) (119,874) 35,629 69,651 (141,185) (12,284) (92,789) (110,926) (77,364) (81,937) -36% -13% -47% -36% -42% -37% -9% -55% -34% -35% -48% -70% 22% 44% -75% -7% -48% -61% -44% -43% 26 Sales - kgal (Line 20+24-25) 113,687 137,572 92,458 112,396 99,567 114,467 155,523 82,201 94,819 112,975 77,380 47,554 196,324 226,680 43,871 169,699 98,052 65,881 94,108 103,991 2,239,205 59% 64% 68% 66% 68% 68% 65% 62% 64% Preliminary Draft - Subject to Material Change 8 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B7 - Historical Water Costs Line # Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 St. Thomas 1 Gross Production - kgal 77,046 65,478 72,454 75,773 73,030 88,181 81,767 87,645 56,791 83,419 68,229 74,087 71,700 76,255 87,642 82,017 90,859 81,022 74,239 87,648 2 % Provided by Electric System 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 3 Quantity Provided by Electric System - kgal (Line 1x2) - - - - - - - - - - - - - - - - - - - - 4 Net Purchases from Seven Seas - kgal 77,046 65,478 72,454 75,773 73,030 88,181 81,767 87,645 56,791 83,419 68,229 74,087 71,700 76,255 87,642 82,017 90,859 81,022 74,239 87,648 5 Net Purchases - Millions of Gallons per Day (MGD) 2.485 2.338 2.337 2.526 2.356 2.939 2.638 2.827 1.893 2.691 2.274 2.390 2.313 2.723 2.827 2.734 2.931 2.701 2.395 2.827 6 Sales to Electric System - Max of Consumption or Minimum Take - kgal 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 10,500 10,850 10,500 10,850 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 7 % Ultra Pure Water (UPW) 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 8 Ultra Pure Water Sales to Electric System - kgal (Line 6x7) 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 10,500 10,850 10,500 10,850 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 9 Regular Water Sales to Electric System - kgal (Line 6-8) - - - - - - - - - - - - - - - - - - - - First Pass Charges (Regular Water) 10 Net Purchases from Seven Seas - kgal (Line 4+9) 77,046 65,478 72,454 75,773 73,030 88,181 81,767 87,645 56,791 83,419 68,229 74,087 71,700 76,255 87,642 82,017 90,859 81,022 74,239 87,648 11 Water Rate / kgal - First Pass - Due to Seven Seas 5.95 $ 5.95 $ 5.95 $ 5.95 $ 5.95 $ 5.95 $ 5.95 $ 5.95 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 12 Amount Due to Seven Seas - Regular Water (Line 10x11) 458,422 $ 389,592 $ 431,103 $ 450,849 $ 434,530 $ 524,679 $ 486,512 $ 521,488 $ 365,732 $ 537,218 $ 439,393 $ 477,122 $ 461,748 $ 491,084 $ 564,414 $ 528,192 $ 585,132 $ 521,782 $ 478,099 $ 564,455 $ 13 Power from Electric System - kWh 883,920 764,540 843,280 883,920 845,820 995,680 906,780 985,520 635,000 914,400 756,920 828,040 828,040 881,380 1,018,540 947,420 1,046,480 934,720 848,360 995,680 14 kWh per kgal (Line 13/10) 11.47 11.68 11.64 11.67 11.58 11.29 11.09 11.24 11.18 10.96 11.09 11.18 11.55 11.56 11.62 11.55 11.52 11.54 11.43 11.36 15 Electric Rate / kWh - Due to Electric System 0.17 $ 0.17 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 16 Amount Due to Electric System - Regular Water (Line 13x15) 152,145 $ 131,596 $ 187,377 $ 196,407 $ 187,941 $ 221,240 $ 201,487 $ 218,983 $ 141,097 $ 203,180 $ 168,188 $ 183,990 $ 183,990 $ 195,843 $ 226,320 $ 210,517 $ 232,528 $ 207,695 $ 188,506 $ 221,240 $ 17 Total First Pass Charges - Regular Water (Line 12+16) 610,566 $ 521,189 $ 618,480 $ 647,256 $ 622,472 $ 745,919 $ 687,998 $ 740,470 $ 506,829 $ 740,398 $ 607,580 $ 661,113 $ 645,738 $ 686,927 $ 790,734 $ 738,708 $ 817,660 $ 729,476 $ 666,605 $ 785,695 $ Second Pass Charges (Ultra Pure Water) 18a Ultra Pure Water Consumption 2,287 1,774 1,937 2,270 1,564 1,696 1,952 2,434 2,095 2,533 2,228 2,345 1,625 1,778 2,180 2,421 2,510 2,374 2,512 2,433 18b Max of Consumption or Minimum Take - Sales to Electric System - kgal (Line 8) 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 10,500 10,850 10,500 10,850 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 19 Water Rate / kgal - UPW - Due to Seven Seas 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 20 Amount Due to Seven Seas - Ultra Pure Water (Line 18b x 19) 29,946 $ 27,048 $ 29,946 $ 28,980 $ 29,946 $ 28,980 $ 29,946 $ 29,946 $ 31,395 $ 32,442 $ 31,395 $ 32,442 $ 32,442 $ 29,302 $ 32,442 $ 31,395 $ 32,442 $ 31,395 $ 32,442 $ 32,442 $ 21 Power from Electric System - kWh 17,033 14,801 15,412 16,353 17,146 17,199 17,811 17,508 15,885 17,538 17,055 17,112 15,247 15,611 17,054 17,309 18,060 18,023 17,050 18,940 22 Ultra Pure Water - kWh per kgal (Line 21/18a) 7.45 8.34 7.96 7.20 10.96 10.14 9.12 7.19 7.58 6.92 7.66 7.30 9.38 8.78 7.82 7.15 7.20 7.59 6.79 7.79 23 Electric Rate / kWh - Due to Electric System 0.17 $ 0.17 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 24 Amount Due to Electric System - Ultra Pure Water (Line 21x23) 2,932 $ 2,548 $ 3,425 $ 3,634 $ 3,810 $ 3,822 $ 3,958 $ 3,890 $ 3,530 $ 3,897 $ 3,790 $ 3,802 $ 3,388 $ 3,469 $ 3,789 $ 3,846 $ 4,013 $ 4,005 $ 3,789 $ 4,208 $ 25 Total Second Pass Charges - Ultra Pure Water (Line 20+24) 32,878 $ 29,596 $ 33,371 $ 32,614 $ 33,756 $ 32,802 $ 33,904 $ 33,836 $ 34,925 $ 36,338 $ 35,185 $ 36,244 $ 35,829 $ 32,771 $ 36,231 $ 35,241 $ 36,454 $ 35,400 $ 36,230 $ 36,650 $ Invoice Adjustments 26 Plus: Late Fees - - - - - - - - - - - - - - - - - - - - 27 Less: Credits - - - - - - - - - - - - - - - - - - - - 28 Total Invoice Adjustments - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 29 Total Water and Electric Charges (Lines 17+25) 643,444 $ 550,784 $ 651,851 $ 679,870 $ 656,228 $ 778,721 $ 721,902 $ 774,307 $ 541,754 $ 776,736 $ 642,765 $ 697,357 $ 681,568 $ 719,698 $ 826,965 $ 773,949 $ 854,114 $ 764,876 $ 702,835 $ 822,345 $ Summary of Projected Costs ($) 30 Total Cost of Purchased Water - Due to Seven Seas (Lines 12+20) 488,368 $ 416,640 $ 461,049 $ 479,829 $ 464,476 $ 553,659 $ 516,458 $ 551,434 $ 397,127 $ 569,660 $ 470,788 $ 509,564 $ 494,190 $ 520,386 $ 596,856 $ 559,587 $ 617,573 $ 553,177 $ 510,541 $ 596,897 $ 31 Total Electricy Charges - Due to Electric System (Lines 16+24) 155,077 134,144 190,801 200,041 191,751 225,062 205,444 222,873 144,627 207,077 171,977 187,793 187,378 199,311 230,109 214,363 236,541 211,699 192,294 225,449 32 Less: Electric System Billings for Internal Plant Use - Water (91,032) (82,222) (91,032) (88,095) (91,032) (88,095) (91,032) (91,032) (95,655) (98,844) (95,655) (98,844) (98,844) (89,278) (98,844) (95,655) (98,844) (95,655) (98,844) (98,844) 33 Less: Electric System Billings for Internal Plant Use - Electricity (7,449) (6,113) (8,434) (9,518) (7,836) (8,077) (8,768) (9,973) (8,736) (10,067) (9,281) (9,625) (7,559) (8,034) (9,420) (10,060) (10,437) (10,091) (10,168) (10,349) 34 Less: Electric System Billings for STT Station #2 Use - Water (24,655) (20,953) (23,185) (24,247) (23,370) (28,218) (26,165) (28,046) (18,173) (26,694) (21,833) (23,708) (22,944) (24,402) (28,045) (26,246) (29,075) (25,927) (23,756) (28,047) 35 Total Water Purchase Costs - Billed to Customers (Sum Lines 30-34) 520,309 $ 441,496 $ 529,200 $ 558,009 $ 533,991 $ 654,331 $ 595,937 $ 645,256 $ 419,190 $ 641,132 $ 515,996 $ 565,180 $ 552,222 $ 597,984 $ 690,656 $ 641,989 $ 715,759 $ 633,203 $ 570,067 $ 685,105 $ Preliminary Draft - Subject to Material Change 9 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B7 - Historical Water Costs Line # Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 St. Croix 36 Gross Production - kgal 104,494 96,404 106,701 105,428 103,958 97,561 92,887 102,447 93,126 95,918 85,910 98,167 92,009 83,852 101,120 103,883 104,269 100,274 101,729 102,342 37 % Provided by Electric System 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 38 Quantity Provided by Electric System - kgal (Line 36x37) - - - - - - - - - - - - - - - - - - - - 39 Net Purchases from Seven Seas - kgal 104,494 96,404 106,701 105,428 103,958 97,561 92,887 102,447 93,126 95,918 85,910 98,167 92,009 83,852 101,120 103,883 104,269 100,274 101,729 102,342 40 Net Purchases - Millions of Gallons per Day (MGD) 3.371 3.443 3.442 3.514 3.353 3.252 2.996 3.305 3.104 3.094 2.864 3.167 2.968 2.995 3.262 3.463 3.364 3.342 3.282 3.301 41 Sales to Electric System - Max of Consumption or Minimum Take - kgal 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 4,200 4,340 4,200 4,340 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 42 % Ultra Pure Water (UPW) 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 43 Ultra Pure Water Sales to Electric System - kgal (Line 41x42) 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 4,200 4,340 4,200 4,340 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 44 Regular Water Sales to Electric System - kgal (Line 41-43) - - - - - - - - - - - - - - - - - - - - First Pass Charges (Regular Water) 45 Net Purchases from Seven Seas - kgal (Line 39+44) 104,494 96,404 106,701 105,428 103,958 97,561 92,887 102,447 93,126 95,918 85,910 98,167 92,009 83,852 101,120 103,883 104,269 100,274 101,729 102,342 46 Water Rate / kgal - First Pass - Due to Seven Seas 4.41 $ 4.41 $ 4.41 $ 4.41 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 47 Amount Due to Seven Seas - Regular Water (Line 45x46) 460,817 $ 425,143 $ 470,549 $ 464,936 $ 495,881 $ 465,364 $ 443,071 $ 488,673 $ 444,209 $ 457,527 $ 409,789 $ 468,255 $ 438,884 $ 399,972 $ 482,344 $ 495,520 $ 521,346 $ 501,368 $ 508,646 $ 511,709 $ 48 Power from Electric System - kWh 1,260,382 1,118,311 1,235,100 1,217,663 1,185,358 1,121,585 1,070,926 1,218,530 1,084,739 1,081,891 973,887 1,133,983 1,075,183 1,008,296 1,202,986 1,203,709 1,209,087 1,160,049 1,163,384 1,172,697 49 kWh per kgal (Line 48/45) 12.06 11.60 11.58 11.55 11.40 11.50 11.53 11.89 11.65 11.28 11.34 11.55 11.69 12.02 11.90 11.59 11.60 11.57 11.44 11.46 50 Electric Rate / kWh - Due to Electric System 0.17 $ 0.17 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 51 Amount Due to Electric System - Regular Water (Line 50x48) 216,943 $ 192,489 $ 274,439 $ 270,565 $ 263,387 $ 249,216 $ 237,960 $ 270,757 $ 241,029 $ 240,396 $ 216,398 $ 251,971 $ 238,906 $ 224,043 $ 267,303 $ 267,464 $ 268,659 $ 257,763 $ 258,504 $ 260,573 $ 52 Total First Pass Charges - Regular Water (Line 47+51) 677,760 $ 617,632 $ 744,988 $ 735,501 $ 759,268 $ 714,580 $ 681,031 $ 759,430 $ 685,238 $ 697,923 $ 626,187 $ 720,226 $ 677,789 $ 624,015 $ 749,647 $ 762,984 $ 790,005 $ 759,130 $ 767,150 $ 772,282 $ Second Pass Charges (Ultra Pure Water) 53a Ultra Pure Water Consumption 1,042 970 1,107 956 1,016 1,024 1,006 1,190 1,292 1,232 1,264 2,481 1,389 1,301 1,527 1,496 1,777 2,115 1,983 1,629 53b Max of Consumption or Minimum Take - Sales to Electric System - kgal (Line 43) 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 4,200 4,340 4,200 4,340 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 54 Water Rate / kgal - UPW - Due to Seven Seas 2.67 $ 2.67 $ 2.67 $ 2.67 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 55 Amount Due to Seven Seas - Ultra Pure Water (Line 53b x 54) 11,588 $ 10,466 $ 11,588 $ 11,214 $ 12,543 $ 12,138 $ 12,543 $ 12,543 $ 12,138 $ 12,543 $ 12,138 $ 12,543 $ 12,543 $ 11,329 $ 12,543 $ 12,138 $ 13,150 $ 12,726 $ 13,150 $ 13,150 $ 56 Power from Electric System - kWh 10,262 8,738 10,764 9,951 7,652 9,530 10,311 9,194 10,240 9,637 11,657 14,834 11,803 10,843 12,015 12,043 14,084 15,099 15,861 12,045 57 Ultra Pure Water - kWh per kgal (Line 56/53a) 9.85 9.01 9.73 10.41 7.53 9.31 10.25 7.72 7.93 7.82 9.22 5.98 8.50 8.34 7.87 8.05 7.92 7.14 8.00 7.39 58 Electric Rate / kWh - Due to Electric System 0.17 $ 0.17 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 59 Amount Due to Electric System - Ultra Pure Water (Line 56x58) 1,766 $ 1,504 $ 2,392 $ 2,211 $ 1,700 $ 2,118 $ 2,291 $ 2,043 $ 2,275 $ 2,141 $ 2,590 $ 3,296 $ 2,623 $ 2,409 $ 2,670 $ 2,676 $ 3,130 $ 3,355 $ 3,524 $ 2,676 $ 60 Total Second Pass Charges - Ultra Pure Water (Line 55+59) 13,354 $ 11,970 $ 13,980 $ 13,425 $ 14,243 $ 14,256 $ 14,834 $ 14,586 $ 14,413 $ 14,684 $ 14,728 $ 15,839 $ 15,165 $ 13,738 $ 15,212 $ 14,814 $ 16,280 $ 16,081 $ 16,675 $ 15,827 $ Invoice Adjustments 61 Plus: Late Fees - - - - - - - - - - - - - - - - - - - - 62 Less: Credits - - - - - - - - - - - - - - - - - - - - 63 Total Invoice Adjustments - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 64 Total Water and Electric Charges (Lines 52+60) 691,115 $ 629,603 $ 758,968 $ 748,926 $ 773,511 $ 728,835 $ 695,865 $ 774,016 $ 699,651 $ 712,608 $ 640,915 $ 736,065 $ 692,955 $ 637,753 $ 764,860 $ 777,798 $ 806,285 $ 775,211 $ 783,824 $ 788,109 $ Summary of Projected Costs ($) 65 Total Cost of Purchased Water - Due to Seven Seas (Lines 47+55) 472,405 $ 435,610 $ 482,137 $ 476,150 $ 508,424 $ 477,502 $ 455,614 $ 501,216 $ 456,347 $ 470,070 $ 421,927 $ 480,798 $ 451,426 $ 411,300 $ 494,887 $ 507,658 $ 534,496 $ 514,094 $ 521,796 $ 524,859 $ 66 Total Electricy Charges - Due to Electric System (Lines 51+59) 218,710 193,993 276,831 272,776 265,087 251,334 240,251 272,800 243,304 242,538 218,988 255,267 241,528 226,453 269,973 270,140 271,789 261,118 262,028 263,250 67 Less: Electric System Billings for Internal Plant Use - Water (30,727) (27,754) (30,727) (29,736) (33,244) (32,172) (33,244) (33,244) (32,172) (33,244) (32,172) (33,244) (33,244) (30,027) (33,244) (32,172) (34,850) (33,726) (34,850) (34,850) 68 Less: Electric System Billings for Internal Plant Use - Electricity (3,930) (3,442) (5,238) (4,664) (4,274) (4,732) (4,869) (5,189) (5,619) (5,228) (5,773) (9,665) (6,228) (5,884) (6,705) (6,527) (7,709) (8,791) (8,564) (6,825) 69 Less: Electric System Billings for STT Station #2 Use - Water - - - - - - - - - - - - - - - - - - - - 70 Total Water Purchase Costs - Billed to Customers (Sum Lines 65-69) 656,458 $ 598,408 $ 723,003 $ 714,526 $ 735,993 $ 691,931 $ 657,751 $ 735,583 $ 661,860 $ 674,135 $ 602,970 $ 693,155 $ 653,482 $ 601,841 $ 724,910 $ 739,099 $ 763,726 $ 732,694 $ 740,410 $ 746,434 $ Preliminary Draft - Subject to Material Change 10 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B7 - Historical Water Costs Line # Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Combined Systems 71 Gross Production - kgal (Lines 1+36) 181,539 161,882 179,155 181,201 176,989 185,742 174,654 190,092 149,916 179,337 154,138 172,254 163,709 160,107 188,762 185,900 195,128 181,296 175,968 189,990 72 % Provided by Electric System 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 73 Quantity Provided by Electric System - kgal (Line 71x72) - 74 Net Purchases from Seven Seas - kgal (Lines 4+39) 181,539 161,882 179,155 181,201 176,989 185,742 174,654 190,092 149,916 179,337 154,138 172,254 163,709 160,107 188,762 185,900 195,128 181,296 175,968 189,990 75 Net Purchases - Millions of Gallons per Day (MGD) 5.856 5.782 5.779 6.040 5.709 6.191 5.634 6.132 4.997 5.785 5.138 5.557 5.281 5.718 6.089 6.197 6.294 6.043 5.676 6.129 76 Sales to Electric System - Max of Consumption or Minimum Take - kgal (Lines 6+41) 15,190 13,720 15,190 14,700 15,190 14,700 15,190 15,190 14,700 15,190 14,700 15,190 15,190 13,720 15,190 14,700 15,190 14,700 15,190 15,190 77 % Ultra Pure Water (UPW) 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 78 Ultra Pure Water Sales to Electric System - kgal (Line 76x77) 15,190 13,720 15,190 14,700 15,190 14,700 15,190 15,190 14,700 15,190 14,700 15,190 15,190 13,720 15,190 14,700 15,190 14,700 15,190 15,190 79 Regular Water Sales to Electric System - kgal (Line 76-78) - - - - - - - - - - - - - - - - - - - - 80 Power from Electic System - kWh (Lines 13+21+48+56) 2,171,597 1,906,390 2,104,556 2,127,887 2,055,976 2,143,994 2,005,828 2,230,752 1,745,864 2,023,466 1,759,519 1,993,969 1,930,273 1,916,130 2,250,595 2,180,481 2,287,711 2,127,891 2,044,655 2,199,362 Summary of Projected Costs ($) 81 Total Cost of Purchased Water - Due to Seven Seas (Lines 30+65) 960,773 $ 852,250 $ 943,186 $ 955,979 $ 972,900 $ 1,031,161 $ 972,071 $ 1,052,649 $ 853,474 $ 1,039,730 $ 892,715 $ 990,362 $ 945,616 $ 931,687 $ 1,091,743 $ 1,067,244 $ 1,152,069 $ 1,067,270 $ 1,032,337 $ 1,121,756 $ 82 Total Electricy Charges - Due to Electric System (Lines 31+66) 373,786 328,137 467,632 472,817 456,838 476,395 445,695 495,673 387,931 449,614 390,965 443,060 428,907 425,764 500,082 484,503 508,329 472,817 454,322 488,698 83 Less: Electric System Billings for Internal Plant Use - Water (Lines 32+67) (121,759) (109,976) (121,759) (117,831) (124,276) (120,267) (124,276) (124,276) (127,827) (132,088) (127,827) (132,088) (132,088) (119,305) (132,088) (127,827) (133,694) (129,381) (133,694) (133,694) 84 Less: Electric System Billings for Internal Plant Use - Electricity (Lines 33+68) (11,378) (9,555) (13,672) (14,182) (12,109) (12,809) (13,637) (15,161) (14,355) (15,296) (15,054) (19,290) (13,787) (13,919) (16,125) (16,587) (18,146) (18,882) (18,732) (17,174) 85 Less: Electric System Billings for STT Station #2 Use - Water (Lines 34+69) (24,655) (20,953) (23,185) (24,247) (23,370) (28,218) (26,165) (28,046) (18,173) (26,694) (21,833) (23,708) (22,944) (24,402) (28,045) (26,246) (29,075) (25,927) (23,756) (28,047) 86 Total Water Purchase Costs - Billed to Customers (Sum Lines 81-85) 1,176,767 $ 1,039,904 $ 1,252,202 $ 1,272,535 $ 1,269,983 $ 1,346,262 $ 1,253,688 $ 1,380,839 $ 1,081,050 $ 1,315,266 $ 1,118,965 $ 1,258,335 $ 1,205,704 $ 1,199,825 $ 1,415,566 $ 1,381,088 $ 1,479,485 $ 1,365,897 $ 1,310,477 $ 1,431,539 $ Preliminary Draft - Subject to Material Change 11 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B10 - Projected Water Sales Cross Reference Line # Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 12-Month Total WS # Line # St. Thomas 1 Gross Production - kgal 77,046 65,478 72,454 75,773 73,030 88,181 81,767 87,645 56,791 83,419 68,229 74,087 903,900 B9 1 2 Less: Ultra Pure Water Production (2,287) (1,774) (1,937) (2,270) (1,564) (1,696) (1,952) (2,434) (2,095) (2,533) (2,228) (2,345) (25,116) B9 18a 3 Available Production Before Plant Use and Line Loss (Line 1+2) 74,758 63,704 70,517 73,503 71,466 86,485 79,815 85,211 54,695 80,886 66,001 71,743 878,783 Well Storage Available for Sale 3 Beginning Inventory - kgal - - - - - - - - - - - - - 4 Less: Ending Inventory - - - - - - - - - - - - - 5 Less: Inventory Adjustments - - - - - - - - - - - - - 6 Total Well Storage Available for Sale - kgal (Sum Lines 3-5) - - - - - - - - - - - - - 7 Less: Plant Use and Line Loss (13,401) 24,706 (28,601) 2,878 (20,110) (15,907) 418 (41,107) 10,027 (4,670) 4,148 (58,593) (140,212) 8 Sales - kgal (Line 3+6-7) 61,357 88,410 41,916 76,381 51,356 70,579 80,232 44,103 64,722 76,215 70,149 13,150 738,571 St. Croix 9 Gross Production - kgal 104,494 96,404 106,701 105,428 103,958 97,561 92,887 102,447 93,126 95,918 85,910 98,167 1,182,999 B9 36 10 Less: Ultra Pure Water Production (1,042) (970) (1,107) (956) (1,016) (1,024) (1,006) (1,190) (1,292) (1,232) (1,264) (2,481) (14,579) B9 53a 11 Available Production Before Plant Use and Line Loss (Line 9+10) 103,452 95,434 105,594 104,472 102,943 96,537 91,881 101,257 91,834 94,686 84,646 95,685 1,168,419 Well Storage Available for Sale 12 Beginning Inventory - kgal - - - - - - - - - - - - - 13 Less: Ending Inventory - - - - - - - - - - - - - 14 Less: Inventory Adjustments - - - - - - - - - - - - - 15 Total Well Storage Available for Sale - kgal (Sum Lines 12-14) - - - - - - - - - - - - - 16 Less: Plant Use and Line Loss (51,122) (46,271) (55,052) (68,456) (54,732) (52,648) (16,590) (63,160) (61,737) (57,926) (77,416) (61,281) (666,391) 17 Sales - kgal (Line 11+15-16) 52,329 49,163 50,542 36,016 48,211 43,889 75,291 38,097 30,097 36,760 7,230 34,405 502,028 Combined Systems 18 Gross Production - kgal (Line 1+9) 181,539 161,882 179,155 181,201 176,989 185,742 174,654 190,092 149,916 179,337 154,138 172,254 2,086,898 B9 71 19 Less: Ultra Pure Water Production (Line 2+10) (3,329) (2,744) (3,044) (3,226) (2,580) (2,720) (2,958) (3,625) (3,387) (3,765) (3,491) (4,826) (39,696) 20 Available Production Before Plant Use and Line Loss (Line 18+19) 178,210 159,138 176,111 177,975 174,409 183,022 171,695 186,468 146,529 175,572 150,647 167,428 2,047,203 Well Storage Available for Sale 21 Beginning Inventory - kgal (Line 3+12) - - - - - - - - - - - - - 22 Less: Ending Inventory (Line 4+13) - - - - - - - - - - - - - 23 Less: Inventory Adjustments (Line 5+14) - - - - - - - - - - - - - 24 Total Well Storage Available for Sale - kgal (Sum Lines 21-23) - - - - - - - - - - - - - 25 Less: Plant Use and Line Loss (64,523) (21,565) (83,653) (65,578) (74,842) (68,555) (16,172) (104,267) (51,710) (62,597) (73,267) (119,874) (806,603) 26 Sales - kgal (Line 20+24-25) 113,687 137,572 92,458 112,396 99,567 114,467 155,523 82,201 94,819 112,975 77,380 47,554 1,240,599 Preliminary Draft - Subject to Material Change 12 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B9 - Approved Water Costs Line # Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 12-Month Total St. Thomas 1 Gross Production - kgal 77,046 65,478 72,454 75,773 73,030 88,181 81,767 87,645 56,791 83,419 68,229 74,087 903,900 2 % Provided by Electric System 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 3 Quantity Provided by Electric System - kgal (Line 1x2) - - - - - - - - - - - - - 4 Net Purchases from Seven Seas - kgal 77,046 65,478 72,454 75,773 73,030 88,181 81,767 87,645 56,791 83,419 68,229 74,087 903,900 5 Net Purchases - Millions of Gallons per Day (MGD) 2.485 2.338 2.337 2.526 2.356 2.939 2.638 2.827 1.893 2.691 2.274 2.390 30 6 Sales to Electric System - Max of Consumption or Minimum Take - kgal 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 10,500 10,850 10,500 10,850 127,750 7 % Ultra Pure Water (UPW) 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 8 Ultra Pure Water Sales to Electric System - kgal (Line 6x7) 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 10,500 10,850 10,500 10,850 127,750 9 Regular Water Sales to Electric System - kgal (Line 6-8) - - - - - - - - - - - - First Pass Charges (Regular Water) 10 Net Purchases from Seven Seas - kgal (Line 4+9) 77,046 65,478 72,454 75,773 73,030 88,181 81,767 87,645 56,791 83,419 68,229 74,087 903,900 11 Water Rate / kgal - First Pass - Due to Seven Seas 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 12 Amount Due to Seven Seas - Regular Water (Line 10x11) 496,174 $ 421,676 $ 466,606 $ 14 $ 470,315 $ 567,888 $ 526,577 $ 564,434 $ 365,732 $ 537,218 $ 439,393 $ 477,122 $ 5,821,114 $ 13 Power from Electric System - kWh 883,920 764,540 843,280 883,920 845,820 995,680 906,780 985,520 635,000 914,400 756,920 828,040 10,243,820 14 kWh per kgal (Line 13/10) 11.47 11.68 11.64 11.67 11.58 11.29 11.09 11.24 11.18 10.96 11.09 11.18 15 Electric Rate / kWh - Due to Electric System 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 16 Amount Due to Electric System - Regular Water (Line 13x15) 196,407 $ 169,881 $ 187,377 $ 196,407 $ 187,941 $ 221,240 $ 201,487 $ 218,983 $ 141,097 $ 203,180 $ 168,188 $ 183,990 $ 2,276,177 $ 17 Total First Pass Charges - Regular Water (Line 12+16) 692,581 $ 591,557 $ 653,983 $ 684,385 $ 658,257 $ 789,128 $ 728,064 $ 783,416 $ 506,829 $ 740,398 $ 607,580 $ 661,113 $ 8,097,291 $ Second Pass Charges (Ultra Pure Water) 18a Ultra Pure Water Consumption 2,287 1,774 1,937 2,270 1,564 1,696 1,952 2,434 2,095 2,533 2,228 2,345 25,116 18b Sales to Electric System - kgal (Line 8) 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 10,500 10,850 10,500 10,850 127,750 19 Water Rate / kgal - UPW - Due to Seven Seas 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 20 Amount Due to Seven Seas - Ultra Pure Water (Line 18b x 19) 32,442 $ 29,302 $ 32,442 $ 31,395 $ 32,442 $ 31,395 $ 32,442 $ 32,442 $ 31,395 $ 32,442 $ 31,395 $ 32,442 $ 381,973 $ 21 Power from Electric System - kWh 17,033 14,801 15,412 16,353 17,146 17,199 17,811 17,508 15,885 17,538 17,055 17,112 200,853 22 Ultra Pure Water - kWh per kgal (Line 21/18a) 7.45 8.34 7.96 7.20 10.96 10.14 9.12 7.19 7.58 6.92 7.66 7.30 23 Electric Rate / kWh - Due to Electric System 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 24 Amount Due to Electric System - Ultra Pure Water (Line 21x23) 3,785 $ 3,289 $ 3,425 $ 3,634 $ 3,810 $ 3,822 $ 3,958 $ 3,890 $ 3,530 $ 3,897 $ 3,790 $ 3,802 $ 44,630 $ 25 Total Second Pass Charges - Ultra Pure Water (Line 20+24) 36,226 $ 32,591 $ 35,866 $ 35,029 $ 36,251 $ 35,217 $ 36,399 $ 36,332 $ 34,925 $ 36,338 $ 35,185 $ 36,244 $ 426,602 $ Invoice Adjustments 26 Plus: Late Fees - - - - - - - - - - - - - 27 Less: Credits - - - - - - - - - - - - - 28 Total Invoice Adjustments - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 29 Total Water and Electric Charges (Lines 17+25) 728,807 $ 624,148 $ 689,849 $ 719,414 $ 694,508 $ 824,345 $ 764,463 $ 819,748 $ 541,754 $ 776,736 $ 642,765 $ 697,357 $ 8,523,893 $ Summary of Projected Costs ($) 30 Total Cost of Purchased Water - Due to Seven Seas (Lines 12+20) 528,616 $ 450,978 $ 499,047 $ 519,373 $ 502,757 $ 599,283 $ 559,019 $ 596,875 $ 397,127 $ 569,660 $ 470,788 $ 509,564 $ 6,203,086 $ 31 Total Electricy Charges - Due to Electric System (Lines 16+24) 200,192 173,170 190,801 200,041 191,751 225,062 205,444 222,873 144,627 207,077 171,977 187,793 2,320,806 32 Less: Electric System Billings for Internal Plant Use - Water (98,844) (89,278) (98,844) (95,655) (98,844) (95,655) (98,844) (98,844) (95,655) (98,844) (95,655) (98,844) (1,163,803) 33 Less: Electric System Billings for Internal Plant Use - Electricity (9,616) (7,891) (8,434) (9,518) (7,836) (8,077) (8,768) (9,973) (8,736) (10,067) (9,281) (9,625) (107,821) 34 Less: Electric System Billings for STT Station #2 Use - Water (24,655) (20,953) (23,185) (24,247) (23,370) (28,218) (26,165) (28,046) (18,173) (26,694) (21,833) (23,708) (289,248) 35 Total Water Purchase Costs - Billed to Customers (Sum Lines 30-34) 595,694 $ 506,025 $ 559,386 $ 589,993 $ 564,459 $ 692,395 $ 630,686 $ 682,886 $ 419,190 $ 641,132 $ 515,996 $ 565,180 $ 6,963,022 $ Preliminary Draft - Subject to Material Change 13 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B9 - Approved Water Costs Line # Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 12-Month Total St. Croix 36 Gross Production - kgal 104,494 96,404 106,701 105,428 103,958 97,561 92,887 102,447 93,126 95,918 85,910 98,167 1,182,999 37 % Provided by Electric System 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 38 Quantity Provided by Electric System - kgal (Line 36x37) - - - - - - - - - - - - - 39 Net Purchases from Seven Seas - kgal 104,494 96,404 106,701 105,428 103,958 97,561 92,887 102,447 93,126 95,918 85,910 98,167 1,182,999 40 Net Purchases - Millions of Gallons per Day (MGD) 3.371 3.443 3.442 3.514 3.353 3.252 2.996 3.305 3.104 3.094 2.864 3.167 39 41 Sales to Electric System - Max of Consumption or Minimum Take - kgal 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 4,200 4,340 4,200 4,340 51,100 42 % Ultra Pure Water (UPW) 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 43 Ultra Pure Water Sales to Electric System - kgal (Line 41x42) 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 4,200 4,340 4,200 4,340 51,100 44 Regular Water Sales to Electric System - kgal (Line 41-43) - - - - - - - - - - - - First Pass Charges (Regular Water) 45 Net Purchases from Seven Seas - kgal (Line 39+44) 104,494 96,404 106,701 105,428 103,958 97,561 92,887 102,447 93,126 95,918 85,910 98,167 1,182,999 46 Water Rate / kgal - First Pass - Due to Seven Seas 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 47 Amount Due to Seven Seas - Regular Water (Line 45x46) 498,435 $ 459,849 $ 508,961 $ 502,890 $ 495,881 $ 465,364 $ 443,071 $ 488,673 $ 444,209 $ 457,527 $ 409,789 $ 468,255 $ 5,642,904 $ 48 Power from Electric System - kWh 1,260,382 1,118,311 1,235,100 1,217,663 1,185,358 1,121,585 1,070,926 1,218,530 1,084,739 1,081,891 973,887 1,133,983 13,702,355 49 kWh per kgal (Line 48/45) 12.06 11.60 11.58 11.55 11.40 11.50 11.53 11.89 11.65 11.28 11.34 11.55 50 Electric Rate / kWh - Due to Electric System 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 51 Amount Due to Electric System - Regular Water (Line 50x48) 280,057 $ 248,489 $ 274,439 $ 270,565 $ 263,387 $ 249,216 $ 237,960 $ 270,757 $ 241,029 $ 240,396 $ 216,398 $ 251,971 $ 3,044,663 $ 52 Total First Pass Charges - Regular Water (Line 47+51) 778,492 $ 708,337 $ 783,401 $ 773,455 $ 759,268 $ 714,580 $ 681,031 $ 759,430 $ 685,238 $ 697,923 $ 626,187 $ 720,226 $ 8,687,567 $ Second Pass Charges (Ultra Pure Water) 53a Ultra Pure Water Consumption 1,042 970 1,107 956 1,016 1,024 1,006 1,190 1,292 1,232 1,264 2,481 14,579 53b Max of Consumption or Minimum Take - Sales to Electric System - kgal (Line 43) 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 4,200 4,340 4,200 4,340 51,100 54 Water Rate / kgal - UPW - Due to Seven Seas 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 55 Amount Due to Seven Seas - Ultra Pure Water (Line 53b x 54) 12,543 $ 11,329 $ 12,543 $ 12,138 $ 12,543 $ 12,138 $ 12,543 $ 12,543 $ 12,138 $ 12,543 $ 12,138 $ 12,543 $ 147,679 $ 56 Power from Electric System - kWh 10,262 8,738 10,764 9,951 7,652 9,530 10,311 9,194 10,240 9,637 11,657 14,834 122,772 57 Ultra Pure Water - kWh per kgal (Line 56/53b) 2.36 2.23 2.48 2.37 1.76 2.27 2.38 2.12 2.44 2.22 2.78 3.42 58 Electric Rate / kWh - Due to Electric System 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 59 Amount Due to Electric System - Ultra Pure Water (Line 56x58) 2,280 $ 1,942 $ 2,392 $ 2,211 $ 1,700 $ 2,118 $ 2,291 $ 2,043 $ 2,275 $ 2,141 $ 2,590 $ 3,296 $ 27,280 $ 60 Total Second Pass Charges - Ultra Pure Water (Line 55+59) 14,823 $ 13,270 $ 14,934 $ 14,349 $ 14,243 $ 14,256 $ 14,834 $ 14,586 $ 14,413 $ 14,684 $ 14,728 $ 15,839 $ 174,959 $ Invoice Adjustments 61 Plus: Late Fees - - - - - - - - - - - - - 62 Less: Credits - - - - - - - - - - - - - 63 Total Invoice Adjustments - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 64 Total Water and Electric Charges (Lines 52+60) 793,315 $ 721,608 $ 798,335 $ 787,804 $ 773,511 $ 728,835 $ 695,865 $ 774,016 $ 699,651 $ 712,608 $ 640,915 $ 736,065 $ 8,862,526 $ Summary of Projected Costs ($) 65 Total Cost of Purchased Water - Due to Seven Seas (Lines 47+55) 510,977 $ 471,177 $ 521,504 $ 515,028 $ 508,424 $ 477,502 $ 455,614 $ 501,216 $ 456,347 $ 470,070 $ 421,927 $ 480,798 $ 5,790,583 $ 66 Total Electricy Charges - Due to Electric System (Lines 51+59) 282,337 250,430 276,831 272,776 265,087 251,334 240,251 272,800 243,304 242,538 218,988 255,267 3,071,943 67 Less: Electric System Billings for Internal Plant Use - Water (33,244) (30,027) (33,244) (32,172) (33,244) (32,172) (33,244) (33,244) (32,172) (33,244) (32,172) (33,244) (391,426) 68 Less: Electric System Billings for Internal Plant Use - Electricity (3,340) (2,982) (3,456) (2,956) (2,971) (3,131) (3,109) (3,706) (4,044) (3,695) (3,962) (8,254) (45,606) 69 Less: Electric System Billings for STT Station #2 Use - Water - - - - - - - - - - - - - 70 Total Water Purchase Costs - Billed to Customers (Sum Lines 29-33) 756,730 $ 688,599 $ 761,634 $ 752,676 $ 737,295 $ 693,532 $ 659,511 $ 737,065 $ 663,435 $ 675,668 $ 604,781 $ 694,567 $ 8,425,494 $ Preliminary Draft - Subject to Material Change 14 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B9 - Approved Water Costs Line # Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 12-Month Total Combined Systems 71 Gross Production - kgal (Lines 1+36) 181,539 161,882 179,155 181,201 176,989 185,742 174,654 190,092 149,916 179,337 154,138 172,254 2,086,898 72 % Provided by Electric System 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 73 Quantity Provided by Electric System - kgal (Line 71x72) - - - - - - - - - - - - 74 Net Purchases from Seven Seas - kgal (Lines 4+39) 181,539 161,882 179,155 181,201 176,989 185,742 174,654 190,092 149,916 179,337 154,138 172,254 2,086,898 75 Net Purchases - Millions of Gallons per Day (MGD) 5.856 5.782 5.779 6.040 5.709 6.191 5.634 6.132 4.997 5.785 5.138 5.557 5.718 76 Sales to Electric System - Max of Consumption or Minimum Take - kgal (Lines 6+41) 15,190 13,720 15,190 14,700 15,190 14,700 15,190 15,190 14,700 15,190 14,700 15,190 178,850 77 % Ultra Pure Water (UPW) 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 78 Ultra Pure Water Sales to Electric System - kgal (Line 6x7) 15,190 13,720 15,190 14,700 15,190 14,700 15,190 15,190 14,700 15,190 14,700 15,190 178,850 79 Regular Water Sales to Electric System - kgal (Line 76-78) - - - - - - - - - - - - - 80 Power from Electic System - kWh (Lines 13+21+48+56) 2,171,597 1,906,390 2,104,556 2,127,887 2,055,976 2,143,994 2,005,828 2,230,752 1,745,864 2,023,466 1,759,519 1,993,969 24,269,800 Summary of Projected Costs ($) 81 Total Cost of Purchased Water - Due to Seven Seas (Lines 30+65) 1,039,593 $ 922,156 $ 1,020,551 $ 1,034,401 $ 1,011,181 $ 1,076,784 $ 1,014,632 $ 1,098,091 $ 853,474 $ 1,039,730 $ 892,715 $ 990,362 $ 11,993,669 $ 82 Total Electricy Charges - Due to Electric System (Lines 31+66) 482,529 423,600 467,632 472,817 456,838 476,395 445,695 495,673 387,931 449,614 390,965 443,060 5,392,750 83 Less: Electric System Billings for Internal Plant Use - Water (Lines 32+67) (132,088) (119,305) (132,088) (127,827) (132,088) (127,827) (132,088) (132,088) (127,827) (132,088) (127,827) (132,088) (1,555,229) 84 Less: Electric System Billings for Internal Plant Use - Electricity (Lines 33+68) (12,956) (10,873) (11,890) (12,474) (10,807) (11,208) (11,877) (13,679) (12,779) (13,762) (13,243) (17,879) (153,427) 85 Less: Electric System Billings for STT Station #2 Use - Water (Lines 34+69) (24,655) (20,953) (23,185) (24,247) (23,370) (28,218) (26,165) (28,046) (18,173) (26,694) (21,833) (23,708) (289,248) 86 Total Water Purchase Costs - Billed to Customers (Sum Lines 81-85) 1,352,424 $ 1,194,624 $ 1,321,020 $ 1,342,669 $ 1,301,754 $ 1,385,927 $ 1,290,197 $ 1,419,951 $ 1,082,625 $ 1,316,800 $ 1,120,776 $ 1,259,747 $ 15,388,515 $ Preliminary Draft - Subject to Material Change 15 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B6 - Historical Water Sales Cross Reference Line # Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 12-Month Total WS # Line # St. Thomas 1 Gross Production - kgal 71,700 76,255 87,642 82,017 90,859 81,022 74,239 87,648 56,791 83,419 68,229 74,087 933,909 B11 1 2 Less: Ultra Pure Water Production (1,625) (1,778) (2,180) (2,421) (2,510) (2,374) (2,512) (2,433) (2,095) (2,533) (2,228) (2,345) (27,035) B11 18a 3 Available Production Before Plant Use and Line Loss (Line 1+2) 70,075 74,478 85,462 79,596 88,349 78,648 71,727 85,216 54,695 80,886 66,001 71,743 906,874 Well Storage Available for Sale 3 Beginning Inventory - kgal - - - - - - - - - - - - - 4 Less: Ending Inventory - - - - - - - - - - - - - 5 Less: Inventory Adjustments - - - - - - - - - - - - - 6 Total Well Storage Available for Sale - kgal (Sum Lines 3-5) - - - - - - - - - - - - - 7 Less: Plant Use and Line Loss (26,220) (27,868) (31,978) (29,783) (33,058) (29,428) (26,838) (31,886) (20,466) (30,265) (24,696) (26,844) (339,329) 8 Sales - kgal (Line 3+6-7) 43,854 46,610 53,484 49,813 55,291 49,220 44,888 53,330 34,230 50,620 41,305 44,898 567,545 St. Croix 9 Gross Production - kgal 92,009 83,852 101,120 103,883 104,269 100,274 101,729 102,342 93,126 95,918 85,910 98,167 1,162,597 B11 36 10 Less: Ultra Pure Water Production (1,389) (1,301) (1,527) (1,496) (1,777) (2,115) (1,983) (1,629) (1,292) (1,232) (1,264) (2,481) (19,485) B11 53a 11 Available Production Before Plant Use and Line Loss (Line 9+10) 90,621 82,551 99,594 102,387 102,492 98,159 99,746 100,713 91,834 94,686 84,646 95,685 1,143,112 Well Storage Available for Sale 12 Beginning Inventory - kgal - - - - - - - - - - - - - 13 Less: Ending Inventory - - - - - - - - - - - - - 14 Less: Inventory Adjustments - - - - - - - - - - - - - 15 Total Well Storage Available for Sale - kgal (Sum Lines 12-14) - - - - - - - - - - - - - 16 Less: Plant Use and Line Loss (33,908) (30,888) (37,265) (38,311) (38,350) (36,729) (37,322) (37,684) (34,362) (35,429) (31,672) (35,803) (427,724) 17 Sales - kgal (Line 11+15-16) 56,713 51,662 62,328 64,076 64,142 61,430 62,423 63,028 57,472 59,257 52,974 59,882 715,388 Combined Systems 18 Gross Production - kgal (Line 1+9) 163,709 160,107 188,762 185,900 195,128 181,296 175,968 189,990 149,916 179,337 154,138 172,254 2,096,505 B11 71 19 Less: Ultra Pure Water Production (Line 2+10) (3,014) (3,078) (3,707) (3,917) (4,287) (4,489) (4,496) (4,062) (3,387) (3,765) (3,491) (4,826) (46,520) 20 Available Production Before Plant Use and Line Loss (Line 18+19) 160,695 157,029 185,055 181,983 190,841 176,807 171,473 185,928 146,529 175,572 150,647 167,428 2,049,986 Well Storage Available for Sale 21 Beginning Inventory - kgal (Line 3+12) - - - - - - - - - - - - - 22 Less: Ending Inventory (Line 4+13) - - - - - - - - - - - - - 23 Less: Inventory Adjustments (Line 5+14) - - - - - - - - - - - - - 24 Total Well Storage Available for Sale - kgal (Sum Lines 21-23) - - - - - - - - - - - - - 25 Less: Plant Use and Line Loss (60,128) (58,756) (69,243) (68,094) (71,408) (66,157) (64,161) (69,570) (54,827) (65,694) (56,368) (62,647) (767,053) 26 Sales - kgal (Line 20+24-25) 100,567 98,272 115,812 113,890 119,433 110,650 107,312 116,359 91,701 109,877 94,279 104,781 1,282,933 Preliminary Draft - Subject to Material Change 16 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B11 - Projected Water Costs Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-22 Oct-22 Nov-22 Dec-22 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 Line # Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 12-Month Total St. Thomas 1 Gross Production - kgal 71,700 76,255 87,642 82,017 90,859 81,022 74,239 87,648 56,791 83,419 68,229 74,087 933,909 2 % Provided by Electric System 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 3 Quantity Provided by Electric System - kgal (Line 1x2) - - - - - - - - - - - - - 4 Net Purchases from Seven Seas - kgal 71,700 76,255 87,642 82,017 90,859 81,022 74,239 87,648 56,791 83,419 68,229 74,087 933,909 5 Net Purchases - Millions of Gallons per Day (MGD) 2.313 2.629 2.827 2.734 2.931 2.701 2.395 2.827 1.893 2.691 2.274 2.390 30.605 6 Sales to Electric System - Max of Consumption or Minimum Take - kgal 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 10,500 10,850 10,500 10,850 127,750 7 % Ultra Pure Water (UPW) 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 8 Ultra Pure Water Sales to Electric System - kgal (Line 6x7) 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 10,500 10,850 10,500 10,850 127,750 9 Regular Water Sales to Electric System - kgal (Line 6-8) - - - - - - - - - - - - First Pass Charges (Regular Water) 10 Net Purchases from Seven Seas - kgal (Line 4+9) 71,700 76,255 87,642 82,017 90,859 81,022 74,239 87,648 56,791 83,419 68,229 74,087 933,909 11 Water Rate / kgal - First Pass - Due to Seven Seas 6.67 $ 6.67 $ 6.67 $ 6.67 $ 6.67 $ 6.67 $ 6.67 $ 6.67 $ 6.67 $ 6.67 $ 6.67 $ 6.67 $ 12 Amount Due to Seven Seas - Regular Water (Line 10x11) 478,239 $ 508,623 $ 584,572 $ 547,056 $ 606,030 $ 540,417 $ 495,174 $ 584,614 $ 378,794 $ 556,405 $ 455,085 $ 494,163 $ 6,229,171 $ 13 Power from Electric System - kWh 828,040 881,380 1,018,540 947,420 1,046,480 934,720 848,360 995,680 635,000 914,400 756,920 828,040 10,634,980 14 kWh per kgal (Line 13/10) 11.55 11.56 11.62 11.55 11.52 11.54 11.43 11.36 11.18 10.96 11.09 11.18 15 Electric Rate / kWh - Due to Electric System 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 16 Amount Due to Electric System - Regular Water (Line 13x15) 183,990 $ 195,843 $ 226,320 $ 210,517 $ 232,528 $ 207,695 $ 188,506 $ 221,240 $ 141,097 $ 203,180 $ 168,188 $ 183,990 $ 2,363,093 $ 17 Total First Pass Charges - Regular Water (Line 12+16) 662,229 $ 704,466 $ 810,892 $ 757,572 $ 838,557 $ 748,112 $ 683,680 $ 805,854 $ 519,891 $ 759,584 $ 623,273 $ 678,153 $ 8,592,263 $ Second Pass Charges (Ultra Pure Water) 18a Ultra Pure Water Consumption 1,625 1,778 2,180 2,421 2,510 2,374 2,512 2,433 2,095 2,533 2,228 2,345 27,035 18b Max of Consumption or Minimum Take - Sales to Electric System - kgal (Line 8) 10,850 9,800 10,850 10,500 10,850 10,500 10,850 10,850 10,500 10,850 10,500 10,850 127,750 19 Water Rate / kgal - UPW - Due to Seven Seas 3.10 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 20 Amount Due to Seven Seas - Ultra Pure Water (Line 18b x 19) 33,635 $ 30,380 $ 33,635 $ 32,550 $ 33,635 $ 32,550 $ 33,635 $ 33,635 $ 32,550 $ 33,635 $ 32,550 $ 33,635 $ 396,025 $ 21 Power from Electric System - kWh 15,247 15,611 17,054 17,309 18,060 18,023 17,050 18,940 15,885 17,538 17,055 17,112 204,884 22 Ultra Pure Water - kWh per kgal (Line 21/18a) 9.38 8.78 7.82 7.15 7.20 7.59 6.79 7.79 7.58 6.92 7.66 7.30 23 Electric Rate / kWh - Due to Electric System 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 24 Amount Due to Electric System - Ultra Pure Water (Line 21x23) 3,388 $ 3,469 $ 3,789 $ 3,846 $ 4,013 $ 4,005 $ 3,789 $ 4,208 $ 3,530 $ 3,897 $ 3,790 $ 3,802 $ 45,525 $ 25 Total Second Pass Charges - Ultra Pure Water (Line 20+24) 37,023 $ 33,849 $ 37,424 $ 36,396 $ 37,648 $ 36,555 $ 37,424 $ 37,843 $ 36,080 $ 37,532 $ 36,340 $ 37,437 $ 441,550 $ Invoice Adjustments 26 Plus: Late Fees - - - - - - - - - - - - - 27 Less: Credits - - - - - - - - - - - - - 28 Total Invoice Adjustments - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 29 Total Water and Electric Charges (Lines 17+25) 699,252 $ 738,314 $ 848,316 $ 793,968 $ 876,205 $ 784,666 $ 721,103 $ 843,698 $ 555,970 $ 797,116 $ 659,612 $ 715,590 $ 9,033,814 $ Summary of Projected Costs ($) 30 Total Cost of Purchased Water - Due to Seven Seas (Lines 12+20) 511,874 $ 539,003 $ 618,207 $ 579,606 $ 639,665 $ 572,967 $ 528,809 $ 618,249 $ 411,344 $ 590,040 $ 487,635 $ 527,798 $ 6,625,196 $ 31 Total Electricy Charges - Due to Electric System (Lines 16+24) 187,378 199,311 230,109 214,363 236,541 211,699 192,294 225,449 144,627 207,077 171,977 187,793 2,408,618 32 Less: Electric System Billings for Internal Plant Use - Water (102,533) (92,610) (102,533) (99,225) (102,533) (99,225) (102,533) (102,533) (99,225) (102,533) (99,225) (102,533) (1,207,238) 33 Less: Electric System Billings for Internal Plant Use - Electricity (7,559) (8,034) (9,420) (10,060) (10,437) (10,091) (10,168) (10,349) (8,736) (10,067) (9,281) (9,625) (113,826) 34 Less: Electric System Billings for STT Station #2 Use - Water (22,944) (24,402) (28,045) (26,246) (29,075) (25,927) (23,756) (28,047) (18,173) (26,694) (21,833) (23,708) (298,851) 35 Total Water Purchase Costs - Billed to Customers (Sum Lines 30-34) 566,217 $ 613,269 $ 708,318 $ 658,438 $ 734,161 $ 649,423 $ 584,646 $ 702,769 $ 429,837 $ 657,823 $ 529,273 $ 579,725 $ 7,413,899 $ Preliminary Draft - Subject to Material Change 17 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B11 - Projected Water Costs Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-22 Oct-22 Nov-22 Dec-22 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 Line # Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 12-Month Total St. Croix 36 Gross Production - kgal 92,009 83,852 101,120 103,883 104,269 100,274 101,729 102,342 93,126 95,918 85,910 98,167 1,162,597 37 % Provided by Electric System 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 38 Quantity Provided by Electric System - kgal (Line 36x37) - - - - - - - - - - - - - 39 Net Purchases from Seven Seas - kgal 92,009 83,852 101,120 103,883 104,269 100,274 101,729 102,342 93,126 95,918 85,910 98,167 1,162,597 40 Net Purchases - Millions of Gallons per Day (MGD) 2.968 2.891 3.262 3.463 3.364 3.342 3.282 3.301 3.104 3.094 2.864 3.167 38.102 41 Sales to Electric System - Max of Consumption or Minimum Take - kgal 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 4,200 4,340 4,200 4,340 51,100 42 % Ultra Pure Water (UPW) 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 43 Ultra Pure Water Sales to Electric System - kgal (Line 41x42) 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 4,200 4,340 4,200 4,340 51,100 44 Regular Water Sales to Electric System - kgal (Line 41-43) - - - - - - - - - - - - First Pass Charges (Regular Water) 45 Net Purchases from Seven Seas - kgal (Line 39+44) 92,009 83,852 101,120 103,883 104,269 100,274 101,729 102,342 93,126 95,918 85,910 98,167 1,162,597 46 Water Rate / kgal - First Pass - Due to Seven Seas 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 47 Amount Due to Seven Seas - Regular Water (Line 45x46) 460,046 $ 419,258 $ 505,602 $ 519,413 $ 521,346 $ 501,368 $ 508,646 $ 511,709 $ 465,628 $ 479,588 $ 429,548 $ 490,833 $ 5,812,983 $ 48 Power from Electric System - kWh 1,075,183 1,008,296 1,202,986 1,203,709 1,209,087 1,160,049 1,163,384 1,172,697 1,084,739 1,081,891 973,887 1,133,983 13,469,891 49 kWh per kgal (Line 48/45) 11.69 12.02 11.90 11.59 11.60 11.57 11.44 11.46 11.65 11.28 11.34 11.55 50 Electric Rate / kWh - Due to Electric System 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 51 Amount Due to Electric System - Regular Water (Line 50x48) 238,906 $ 224,043 $ 267,303 $ 267,464 $ 268,659 $ 257,763 $ 258,504 $ 260,573 $ 241,029 $ 240,396 $ 216,398 $ 251,971 $ 2,993,010 $ 52 Total First Pass Charges - Regular Water (Line 47+51) 698,951 $ 643,301 $ 772,905 $ 786,877 $ 790,005 $ 759,130 $ 767,150 $ 772,282 $ 706,657 $ 719,985 $ 645,946 $ 742,804 $ 8,805,993 $ Second Pass Charges (Ultra Pure Water) 53a Ultra Pure Water Consumption 1,389 1,301 1,527 1,496 1,777 2,115 1,983 1,629 1,292 1,232 1,264 2,481 19,485 53b Max of Consumption or Minimum Take - Sales to Electric System - kgal (Line 43) 4,340 3,920 4,340 4,200 4,340 4,200 4,340 4,340 4,200 4,340 4,200 4,340 51,100 54 Water Rate / kgal - UPW - Due to Seven Seas 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 55 Amount Due to Seven Seas - Ultra Pure Water (Line 53b x 54) 13,150 $ 11,878 $ 13,150 $ 12,726 $ 13,150 $ 12,726 $ 13,150 $ 13,150 $ 12,726 $ 13,150 $ 12,726 $ 13,150 $ 154,833 $ 56 Power from Electric System - kWh 11,803 10,843 12,015 12,043 14,084 15,099 15,861 12,045 10,240 9,637 11,657 14,834 150,160 57 Ultra Pure Water - kWh per kgal (Line 56/53b) 8.50 8.34 7.87 8.05 7.92 7.14 8.00 7.39 7.93 7.82 9.22 5.98 58 Electric Rate / kWh - Due to Electric System 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 0.22 $ 59 Amount Due to Electric System - Ultra Pure Water (Line 56x58) 2,623 $ 2,409 $ 2,670 $ 2,676 $ 3,130 $ 3,355 $ 3,524 $ 2,676 $ 2,275 $ 2,141 $ 2,590 $ 3,296 $ 33,366 $ 60 Total Second Pass Charges - Ultra Pure Water (Line 55+59) 15,773 $ 14,287 $ 15,820 $ 15,402 $ 16,280 $ 16,081 $ 16,675 $ 15,827 $ 15,001 $ 15,292 $ 15,316 $ 16,446 $ 188,199 $ Invoice Adjustments 61 Plus: Late Fees - - - - - - - - - - - - - 62 Less: Credits - - - - - - - - - - - - - 63 Total Invoice Adjustments - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 64 Total Water and Electric Charges (Lines 52+60) 714,724 $ 657,588 $ 788,725 $ 802,279 $ 806,285 $ 775,211 $ 783,824 $ 788,109 $ 721,658 $ 735,276 $ 661,262 $ 759,251 $ 8,994,192 $ Summary of Projected Costs ($) 65 Total Cost of Purchased Water - Due to Seven Seas (Lines 47+55) 473,196 $ 431,135 $ 518,752 $ 532,139 $ 534,496 $ 514,094 $ 521,796 $ 524,859 $ 478,354 $ 492,739 $ 442,274 $ 503,984 $ 5,967,816 $ 66 Total Electricy Charges - Due to Electric System (Lines 51+59) 241,528 226,453 269,973 270,140 271,789 261,118 262,028 263,250 243,304 242,538 218,988 255,267 3,026,375 67 Less: Electric System Billings for Internal Plant Use - Water (34,850) (31,478) (34,850) (33,726) (34,850) (33,726) (34,850) (34,850) (33,726) (34,850) (33,726) (34,850) (410,333) 68 Less: Electric System Billings for Internal Plant Use - Electricity (6,228) (5,884) (6,705) (6,527) (7,709) (8,791) (8,564) (6,825) (5,619) (5,228) (5,773) (9,665) (83,520) 69 Less: Electric System Billings for STT Station #2 Use - Water - - - - - - - - - - - - - 70 Total Water Purchase Costs - Billed to Customers (Sum Lines 29-33) 673,646 $ 620,226 $ 747,170 $ 762,026 $ 763,726 $ 732,694 $ 740,410 $ 746,434 $ 682,313 $ 695,198 $ 621,763 $ 714,735 $ 8,500,339 $ Preliminary Draft - Subject to Material Change 18 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Worksheet B11 - Projected Water Costs Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-22 Oct-22 Nov-22 Dec-22 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 Line # Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 12-Month Total Combined Systems 71 Gross Production - kgal (Lines 1+36) 163,709 160,107 188,762 185,900 195,128 181,296 175,968 189,990 149,916 179,337 154,138 172,254 2,096,505 72 % Provided by Electric System 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 73 Quantity Provided by Electric System - kgal (Line 71x72) - - - - - - - - - - - - 74 Net Purchases from Seven Seas - kgal (Lines 4+39) 163,709 160,107 188,762 185,900 195,128 181,296 175,968 189,990 149,916 179,337 154,138 172,254 2,096,505 75 Net Purchases - Millions of Gallons per Day (MGD) 5.281 5.521 6.089 6.197 6.294 6.043 5.676 6.129 4.997 5.785 5.138 5.557 5.744 76 Sales to Electric System - Max of Consumption or Minimum Take - kgal (Lines 6+41) 15,190 13,720 15,190 14,700 15,190 14,700 15,190 15,190 14,700 15,190 14,700 15,190 178,850 77 % Ultra Pure Water (UPW) 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 78 Ultra Pure Water Sales to Electric System - kgal (Line 6x7) 15,190 13,720 15,190 14,700 15,190 14,700 15,190 15,190 14,700 15,190 14,700 15,190 178,850 79 Regular Water Sales to Electric System - kgal (Line 76-78) - - - - - - - - - - - - - 80 Power from Electic System - kWh (Lines 13+21+48+56) 1,930,273 1,916,130 2,250,595 2,180,481 2,287,711 2,127,891 2,044,655 2,199,362 1,745,864 2,023,466 1,759,519 1,993,969 24,459,915 Summary of Projected Costs ($) 81 Total Cost of Purchased Water - Due to Seven Seas (Lines 30+65) 985,070 $ 970,138 $ 1,136,959 $ 1,111,744 $ 1,174,161 $ 1,087,060 $ 1,050,605 $ 1,143,109 $ 889,697 $ 1,082,778 $ 929,910 $ 1,031,781 $ 12,593,012 $ 82 Total Electricy Charges - Due to Electric System (Lines 31+66) 428,907 425,764 500,082 484,503 508,329 472,817 454,322 488,698 387,931 449,614 390,965 443,060 5,434,993 83 Less: Electric System Billings for Internal Plant Use - Water (Lines 32+67) (137,383) (124,088) (137,383) (132,951) (137,383) (132,951) (137,383) (137,383) (132,951) (137,383) (132,951) (137,383) (1,617,571) 84 Less: Electric System Billings for Internal Plant Use - Electricity (Lines 33+68) (13,787) (13,919) (16,125) (16,587) (18,146) (18,882) (18,732) (17,174) (14,355) (15,296) (15,054) (19,290) (197,346) 85 Less: Electric System Billings for STT Station #2 Use - Water (Lines 34+69) (22,944) (24,402) (28,045) (26,246) (29,075) (25,927) (23,756) (28,047) (18,173) (26,694) (21,833) (23,708) (298,851) 86 Total Water Purchase Costs - Billed to Customers (Sum Lines 81-85) 1,239,863 $ 1,233,494 $ 1,455,488 $ 1,420,464 $ 1,497,887 $ 1,382,117 $ 1,325,056 $ 1,449,203 $ 1,112,149 $ 1,353,020 $ 1,151,036 $ 1,294,460 $ 15,914,238 $ Preliminary Draft - Subject to Material Change 19 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Water Rate Schedule Line # Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual St. Thomas First Pass (Regular Water) Charges 1 Base Water Charge (Line 6 - Sum Lines 2-5) 5.22 $ 5.22 $ 5.22 $ 5.22 $ 5.22 $ 5.22 $ 5.22 $ 5.22 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 2 Station #2 (100% Billed to Electric) 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 3 Station #3 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 4 Post-Treatment Capital Cost 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 5 Facility Expansion Credit - - - - - - - - - - - - 6 Total First Pass Water Rate/kgal - Due to Seven Seas 5.95 $ 5.95 $ 5.95 $ 5.95 $ 5.95 $ 5.95 $ 5.95 $ 5.95 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ Ultra Pure Water Charges 7 Ultra Pure Water Charge 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 8 Total Ultra Pure Water Rate per kgal - Due to Seven Seas (Line 13) 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.76 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ St. Croix First Pass (Regular Water) Charges 9 Base Water Charge (Line 13 - Sum Lines 10-12) 4.19 $ 4.19 $ 4.19 $ 4.19 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 10 Civil Site Charge 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 11 Intake Pump Upgrade 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 12 Facility Expansion Credit - - - - - - - - - - - - 13 Total First Pass Water Rate/kgal - Due to Seven Seas 4.41 $ 4.41 $ 4.41 $ 4.41 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ Ultra Pure Water Charges 14 Ultra Pure Water Charge 2.67 $ 2.67 $ 2.67 $ 2.67 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 15 Total Ultra Pure Water Rate per kgal - Due to Seven Seas (Line 14) 2.67 $ 2.67 $ 2.67 $ 2.67 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ Preliminary Draft - Subject to Material Change 20 of 21 1/10/2024 6:39 AM U.S. Virgin Islands Water and Power Authority Water Rate Schedule Line # St. Thomas First Pass (Regular Water) Charges 1 Base Water Charge (Line 6 - Sum Lines 2-5) 2 Station #2 (100% Billed to Electric) 3 Station #3 4 Post-Treatment Capital Cost 5 Facility Expansion Credit 6 Total First Pass Water Rate/kgal - Due to Seven Seas Ultra Pure Water Charges 7 Ultra Pure Water Charge 8 Total Ultra Pure Water Rate per kgal - Due to Seven Seas (Line 13) St. Croix First Pass (Regular Water) Charges 9 Base Water Charge (Line 13 - Sum Lines 10-12) 10 Civil Site Charge 11 Intake Pump Upgrade 12 Facility Expansion Credit 13 Total First Pass Water Rate/kgal - Due to Seven Seas Ultra Pure Water Charges 14 Ultra Pure Water Charge 15 Total Ultra Pure Water Rate per kgal - Due to Seven Seas (Line 14) Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Actual Actual Actual Actual Actual Actual Actual Actual Forecast Forecast Forecast Forecast 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.94 $ 5.94 $ 5.94 $ 5.94 $ 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.32 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.26 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 - - - - - - - - - - - - 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.44 $ 6.67 $ 6.67 $ 6.67 $ 6.67 $ 1.035714286 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 3.10 $ 3.10 $ 3.10 $ 3.10 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.78 $ 4.78 $ 4.78 $ 4.78 $ 4.78 $ 4.78 $ 4.78 $ 4.78 $ 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 - - - - - - - - - - - - 4.77 $ 4.77 $ 4.77 $ 4.77 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ 3.03 $ Preliminary Draft - Subject to Material Change 21 of 21 1/10/2024 6:39 AM