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 20 2/21/2023 4:26 PM 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 2022 Jan-Dec 2023 Jan-Dec 2022 Jan-Dec 2023 2023 vs. 2022 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 10,062,212 $ 11,993,669 $ 8.42 $ 9.67 $ 1.25 $ B2 4 5 Less: Electric System Billings for Internal Plant Use - Water (1,379,072) (1,555,229) (1.15) (1.25) (0.10) B2 5 6 Less: Electric System Billings for STT Station #2 Use - Water (256,012) (289,248) (0.21) (0.23) (0.02) B2 6 7 Net Water Production Charge / RO (Sum Lines 4-6) 8,427,127 $ 10,149,193 $ 7.05 $ 8.18 $ 1.13 $ B2 7 Net Electricity Charge for Purchased Water 8 Total Electricy Charges for Purchased Water 4,866,762 $ 5,392,750 $ 4.07 $ 4.35 $ 0.28 $ B2 8 9 Less: Electric System Billings for Internal Plant Use - Electricity (509,976) (153,427) (0.43) (0.12) 0.30 B2 9 10 Net Electricity Charge for Purchased Water (Line 8+9) 4,356,786 $ 5,239,323 $ 3.64 $ 4.22 $ 0.58 $ B2 10 11 Current Purchased Water Costs (Line 7+10) 12,783,913 $ 15,388,515 $ 10.70 $ 12.40 $ 1.71 $ B2 11 12 Total Current Water Costs - Net (Line 3+11) 12,793,993 $ 15,398,595 $ 10.70 $ 12.41 $ 1.71 $ B2 12 13 Less: Base Rate Recovery (3,442,454) (3,572,926) (2.88) (2.88) - B2 13 14 Current LEAC Costs (Line 12+13) 9,351,539 $ 11,825,669 $ 7.82 $ 9.53 $ 1.71 $ B2 14 Preliminary Draft - Subject to Material Change 2 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B2 - 12-Month Comparison Current As Approved Proposed LEAC Cross Reference Line # Jan-Dec 2022 Jan-Dec 2023 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 10,062,212 $ 11,993,669 $ B4 16 5 Less: Electric System Billings for Internal Plant Use - Water (1,379,072) (1,555,229) B4 18 6 Less: Electric System Billings for STT Station #2 Use - Water (256,012) (289,248) B4 20 7 Net Water Production Charge / RO (Sum Lines 4-6) 8,427,127 $ 10,149,193 $ Net Electricity Charge for Purchased Water 8 Total Electricy Charges for Purchased Water 4,866,762 $ 5,392,750 $ B4 17 9 Less: Electric System Billings for Internal Plant Use - Electricity (509,976) (153,427) B4 19 10 Net Electricity Charge for Purchased Water (Line 8+9) 4,356,786 $ 5,239,323 $ 11 Current Purchased Water Costs (Line 7+10) 12,783,913 $ 15,388,515 $ B4 21 12 Total Current Water Costs - Net (Line 3+11) 12,793,993 $ 15,398,595 $ B5 11 13 Less: Base Rate Recovery (3,442,454) (3,572,926) B5 13 14 Current LEAC Costs (Line 12+13) 9,351,539 $ 11,825,669 $ 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) 9,351,539 $ 11,825,669 $ B5 18 Summary of Costs - $/kgal 19 Sales Forecast 1,195,296 1,240,599 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 8.42 $ 9.67 $ 24 Less: Electric System Billings for Internal Plant Use - Water (1.15) (1.25) 25 Less: Electric System Billings for STT Station #2 Use - Water (0.21) (0.23) 26 Net Water Production Charge / RO (Sum Lines 23-25) 7.05 $ 8.18 $ Net Electricity Charge for Purchased Water 27 Total Electricy Charges for Purchased Water 4.07 $ 4.35 $ 28 Less: Electric System Billings for Internal Plant Use - Electricity (0.43) (0.12) 29 Net Electricity Charge for Purchased Water (Line 27+28) 3.64 $ 4.22 $ 30 Current Purchased Water Costs (Line 26+29) 10.70 $ 12.40 $ 31 Total Current Water Costs - Net (Line 3+11) 10.70 $ 12.41 $ 32 Less: Base Rate Recovery (2.88) (2.88) 33 Current LEAC Costs (Line 31+32) 7.82 $ 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) 7.82 $ 9.53 $ Preliminary Draft - Subject to Material Change 3 of 20 2/21/2023 4:26 PM 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 1.71 1.71 1.71 3 Impact to Bill (Monthly) 4.10 $ 42.72 $ 162.32 $ Avg. Monthly Usage - Gallons Change in LEAC Rate ($/kgal) Impact to Bill 4 2,000 1.71 3.42 $ 5 8,000 1.71 13.67 $ 6 14,000 1.71 23.92 $ 7 20,000 1.71 34.17 $ 8 26,000 1.71 44.42 $ 9 32,000 1.71 54.68 $ 10 38,000 1.71 64.93 $ 11 44,000 1.71 75.18 $ 12 50,000 1.71 85.43 $ 13 56,000 1.71 95.68 $ 14 62,000 1.71 105.93 $ 15 68,000 1.71 116.19 $ 16 74,000 1.71 126.44 $ 17 80,000 1.71 136.69 $ 18 86,000 1.71 146.94 $ 19 92,000 1.71 157.19 $ 20 98,000 1.71 167.44 $ Preliminary Draft - Subject to Material Change 4 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B4 - Water Sales and Costs Current As Approved Proposed LEAC Cross Reference Line # Jan-Dec 2022 Jan-Dec 2023 WS # Line # Water Sales and Production 1 Gross Production - kgal 1,946,742 2,086,898 B8 / B10 15 / 18 2 Less: Ultra Pure Water Production See Plant Use (39,696) B10 19 3 Available Production Before Plant Use and Line Loss (Line 1+2) 1,946,742 2,047,203 4 Well Storage Available for Sale - kgal - - B8 / B10 19 / 24 5 Line Loss - kgal (Approved includes UPW Production) (751,446) (806,603) B8 / B10 20 / 25 6 Sales Forecast - kgal (Sum Line 3-5) 1,195,296 1,240,599 B8 / B10 21 / 26 Water Production Costs 7 Gross Production - kgal 1,946,742 2,086,898 B9 / B11 71 8 % Provided by Electric System 0% 0% B9 / B11 72 9 Quantity Provided by Electric System - kgal (Line 7x8) - - B9 / B11 73 9 Net Purchases from Seven Seas - kgal 1,946,742 2,086,898 B9 / B11 74 10 Net Purchases - Millions of Gallons per Day (MGD) 5.334 5.718 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 22,854,205 24,269,800 B9 / B11 80 Summary of Projected Costs ($) 16 Total Cost of Purchased Water - Due to Seven Seas 10,062,212 $ 11,993,669 $ B9 / B11 81 17 Total Electricy Charges - Due to Electric System 4,866,762 5,392,750 B9 / B11 82 18 Less: Electric System Billings for Internal Plant Use - Water (1,379,072) (1,555,229) B9 / B11 83 19 Less: Electric System Billings for Internal Plant Use - Electricity (509,976) (153,427) B9 / B11 84 20 Less: Electric System Billings for STT Station #2 Use - Water (256,012) (289,248) B9 / B11 85 21 Total Water Purchase Costs - Billed to Customers (Sum Lines 16-20) 12,783,913 $ 15,388,515 $ B9 / B11 86 Fuel Costs to Produce Water ($) 22 Allocated Fuel Costs - Due to Electric System - $ - $ 23 Total Water Production Costs (Line 21+22) 12,783,913 $ 15,388,515 $ 24 Average Cost per kgal Sold (Line 23/6) 10.70 $ 12.40 $ Preliminary Draft - Subject to Material Change 5 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B5 - Water LEAC True-Up Current As Approved Proposed LEAC Cross Reference Line # Jan-Dec 2022 Jan-Dec 2023 WS # Line # Water Sales 1 Water Sales - kgal 1,195,296 1,240,599 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 10,062,212 $ 11,993,669 $ B4 16 6 Total Electricity Charge - Due to Electric System 4,866,762 5,392,750 B4 17 7 Less: Electric System Billings for Internal Plant Use - Water (1,379,072) (1,555,229) B4 18 8 Less: Electric System Billings for Internal Plant Use - Electricity (509,976) (153,427) B4 19 9 Less: Electric System Billings for STT Station #2 Use - Water (256,012) (289,248) B4 20 10 Total Purchased Water Costs (Sum Lines 5-9) 12,783,913 $ 15,388,515 $ B4 21 11 Total Current Costs (Lines 4+10) 12,793,993 $ 15,398,595 $ Recovery of Current and Prior Period Costs ($) 12 Base Rate / kgal 2.88 $ 2.88 $ 13 Base Rate Recovery (Line 1x12) 3,442,454 3,572,926 14 Unrecovered Costs - Current Fuel & Purchased Water (Line 11-13) 9,351,539 $ 11,825,669 $ 15 Refinanced GO Note Principal & Interest - - 16 Prior Period Billing Adjustments - - 17 Planned Recovery of Deferred Balance - - 18 Total Costs (sum Lines 14-17) 9,351,539 $ 11,825,669 $ LEAC Detail 19 LEAC Rate - $/kgal (Line 18/1) 7.82 $ 9.53 $ 20 LEAC Cost Recovery (Line 1x19) 9,351,539 $ 11,825,669 $ 21 Base Rate Recovery (Line 13) 3,442,454 3,572,926 22 Less: Regulatory Expense (Line 3) (10,080) (10,080) 23 Less: Purchased Water Cost (Line 10) (12,783,913) (15,388,515) 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 6 of 20 2/21/2023 4:26 PM 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 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 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) 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 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) 8 Sales - kgal (Lines 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 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 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) 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 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) 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 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 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) 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 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) 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 Preliminary Draft - Subject to Material Change 7 of 20 2/21/2023 4:26 PM 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 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 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 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 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 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 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 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 $ 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 $ 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 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.17 $ 0.17 $ 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 $ 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 $ 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 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 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 $ 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 $ 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 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.17 $ 0.17 $ 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 $ 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 $ 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 $ 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 $ 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 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) 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) 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) 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 $ Preliminary Draft - Subject to Material Change 8 of 20 2/21/2023 4:26 PM 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 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 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 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 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 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 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 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 $ 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 $ 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 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.17 $ 0.17 $ 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 $ 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 $ 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 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 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 $ 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 $ 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 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 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 $ 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 $ 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 $ 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 $ 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 $ 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 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) 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) 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 $ Preliminary Draft - Subject to Material Change 9 of 20 2/21/2023 4:26 PM 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 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 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 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 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 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 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 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 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 $ 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 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) 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) 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) 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 $ Preliminary Draft - Subject to Material Change 10 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B8 - Approved 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 12-Month Total WS # Line # St. Thomas 1 Gross Production - kgal 59,412 54,238 70,757 76,798 76,626 80,452 73,809 56,920 62,932 65,743 47,036 75,316 800,039 B9 1 Well Storage Available for Sale 2 Beginning Inventory - kgal - - - - - - - - - - - - - 3 Less: Ending Inventory - - - - - - - - - - - - - 4 Less: Inventory Adjustments - - - - - - - - - - - - - 5 Total Well Storage Available for Sale - kgal (Sum Lines 2-4) - - - - - - - - - - - - - 6 Less: Plant Use and Line Loss (Includes UPW Production) (17,194) (14,909) (17,804) (21,185) (18,480) (18,672) (19,988) (25,062) (17,585) (18,255) (16,263) (20,480) (225,879) 7 Sales Forecast - kgal (Line 1+5+6) 42,218 39,329 52,953 55,613 58,146 61,780 53,821 31,858 45,347 47,488 30,773 54,836 574,160 St. Croix 8 Gross Production - kgal 98,486 87,792 102,459 96,396 104,288 101,345 106,712 102,407 92,332 89,613 83,948 80,926 1,146,703 B9 36 Well Storage Available for Sale 9 Beginning Inventory - kgal - - - - - - - - - - - - - 10 Less: Ending Inventory - - - - - - - - - - - - - 11 Less: Inventory Adjustments - - - - - - - - - - - - - 12 Total Well Storage Available for Sale - kgal (Sum Lines 9-11) - - - - - - - - - - - - - 13 Less: Plant Use and Line Loss (Includes UPW Production) (45,192) (40,254) (46,907) (44,158) (47,569) (46,158) (48,716) (46,894) (42,316) (41,250) (38,686) (37,467) (525,567) 14 Sales Forecast - kgal (Line 8+12+13) 53,293 47,538 55,552 52,239 56,719 55,187 57,996 55,513 50,016 48,363 45,262 43,459 621,136 Combined Systems 15 Gross Production (Line 1+8) 157,898 142,030 173,216 173,194 180,914 181,797 180,521 159,327 155,264 155,356 130,984 156,242 1,946,742 B9 71 Well Storage Available for Sale 16 Beginning Inventory - kgal (Line 2+9) - - - - - - - - - - - - - 17 Less: Ending Inventory (Line 3+10) - - - - - - - - - - - - - 18 Less: Inventory Adjustments (Line 4+11) - - - - - - - - - - - - - 19 Total Well Storage Available for Sale - kgal (Sum Lines 16-18) - - - - - - - - - - - - - 20 Less: Plant Use and Line Loss (Includes UPW Production) (62,387) (55,163) (64,711) (65,343) (66,049) (64,830) (68,704) (71,956) (59,901) (59,506) (54,949) (57,948) (751,446) 21 Sales Forecast - kgal (Line 15+19+20) 95,511 86,867 108,504 107,851 114,865 116,968 111,817 87,371 95,363 95,850 76,035 98,294 1,195,296 Preliminary Draft - Subject to Material Change 11 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B9 - Approved 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 12-Month Total St. Thomas 1 Gross Production - kgal 59,412 54,238 70,757 76,798 76,626 80,452 73,809 56,920 62,932 65,743 47,036 75,316 800,039 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 59,412 54,238 70,757 76,798 76,626 80,452 73,809 56,920 62,932 65,743 47,036 75,316 800,039 5 Net Purchases - Millions of Gallons per Day (MGD) 1.917 1.937 2.282 2.560 2.472 2.682 2.381 1.836 2.098 2.121 1.568 2.430 26 6 Sales to Electric System - 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) 59,412 54,238 70,757 76,798 76,626 80,452 73,809 56,920 62,932 65,743 47,036 75,316 800,039 11 Water Rate / kgal - First Pass - Due to Seven Seas 5.65 $ 5.65 $ 5.65 $ 5.65 $ 5.65 $ 5.65 $ 5.65 $ 5.65 $ 5.66 $ 5.66 $ 5.66 $ 5.66 $ 12 Amount Due to Seven Seas - Regular Water (Line 10x11) 335,680 $ 306,445 $ 399,775 $ 433,909 $ 432,939 $ 454,552 $ 417,021 $ 321,598 $ 356,495 $ 372,418 $ 266,448 $ 426,647 $ 4,523,926 $ 13 Power from Electric System - kWh 669,652 611,331 797,518 865,611 863,676 906,793 831,921 641,561 709,324 741,007 530,156 848,907 9,017,457 14 kWh per kgal (Line 13/10) 11.27 11.27 11.27 11.27 11.27 11.27 11.27 11.27 11.27 11.27 11.27 11.27 15 Electric Rate / kWh - Due to Electric System 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 16 Amount Due to Electric System - Regular Water (Line 13x15) 142,703 $ 130,275 $ 169,951 $ 184,462 $ 184,049 $ 193,238 $ 177,282 $ 136,717 $ 151,157 $ 157,909 $ 112,976 $ 180,902 $ 1,921,620 $ 17 Total First Pass Charges - Regular Water (Line 12+16) 478,383 $ 436,719 $ 569,726 $ 618,370 $ 616,988 $ 647,789 $ 594,303 $ 458,315 $ 507,652 $ 530,327 $ 379,424 $ 607,549 $ 6,445,546 $ Second Pass Charges (Ultra Pure Water) 18 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.62 $ 2.62 $ 2.62 $ 2.62 $ 2.62 $ 2.62 $ 2.62 $ 2.62 $ 2.63 $ 2.63 $ 2.63 $ 2.63 $ 20 Amount Due to Seven Seas - Ultra Pure Water (Line 18x19) 28,427 $ 25,676 $ 28,427 $ 27,510 $ 28,427 $ 27,510 $ 28,427 $ 28,427 $ 27,593 $ 28,512 $ 27,593 $ 28,512 $ 335,041 $ 21 Power from Electric System - kWh 18,687 16,878 18,687 18,084 18,687 18,084 18,687 18,687 18,084 18,687 18,084 18,687 220,021 22 Ultra Pure Water - kWh per kgal (Line 21/18) 1.72 1.72 1.72 1.72 1.72 1.72 1.72 1.72 1.72 1.72 1.72 1.72 23 Electric Rate / kWh - Due to Electric System 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 24 Amount Due to Electric System - Ultra Pure Water (Line 21x23) 3,982 $ 3,597 $ 3,982 $ 3,854 $ 3,982 $ 3,854 $ 3,982 $ 3,982 $ 3,854 $ 3,982 $ 3,854 $ 3,982 $ 46,887 $ 25 Total Second Pass Charges - Ultra Pure Water (Line 20+24) 32,409 $ 29,273 $ 32,409 $ 31,364 $ 32,409 $ 31,364 $ 32,409 $ 32,409 $ 31,446 $ 32,494 $ 31,446 $ 32,494 $ 381,927 $ Invoice Adjustments 26 Plus: Late Fees - - - - - - - - - - - - - 27 Less: Credits - - - - - - - - - - - - - 28 Total Invoice Adjustments - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 29 Total Water and Electric Charges (Lines 17+25) 510,792 $ 465,992 $ 602,135 $ 649,734 $ 649,397 $ 679,153 $ 626,712 $ 490,724 $ 539,098 $ 562,821 $ 410,870 $ 640,044 $ 6,827,473 $ Summary of Projected Costs ($) 30 Total Cost of Purchased Water - Due to Seven Seas (Lines 12+20) 364,107 $ 332,121 $ 428,202 $ 461,419 $ 461,366 $ 482,062 $ 445,448 $ 350,025 $ 384,087 $ 400,931 $ 294,040 $ 455,159 $ 4,858,966 $ 31 Total Electricy Charges - Due to Electric System (Lines 16+24) 146,685 133,871 173,933 188,315 188,032 197,091 181,265 140,699 155,011 161,891 116,830 184,884 1,968,507 32 Less: Electric System Billings for Internal Plant Use - Water (86,258) (77,910) (86,258) (83,475) (86,258) (83,475) (86,258) (86,258) (83,713) (86,503) (83,713) (86,503) (1,016,578) 33 Less: Electric System Billings for Internal Plant Use - Electricity (30,043) (27,135) (30,043) (29,074) (30,043) (29,074) (30,043) (30,043) (29,074) (30,043) (29,074) (30,043) (353,730) 34 Less: Electric System Billings for STT Station #2 Use - Water (19,012) (17,356) (22,642) (24,575) (24,520) (25,745) (23,619) (18,214) (20,138) (21,038) (15,052) (24,101) (256,012) 35 Total Water Purchase Costs - Billed to Customers (Sum Lines 30-34) 375,479 $ 343,591 $ 463,193 $ 512,610 $ 508,577 $ 540,860 $ 486,793 $ 356,209 $ 406,173 $ 425,238 $ 283,032 $ 499,397 $ 5,201,152 $ Preliminary Draft - Subject to Material Change 12 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B9 - Approved 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 12-Month Total St. Croix 36 Gross Production - kgal 98,486 87,792 102,459 96,396 104,288 101,345 106,712 102,407 92,332 89,613 83,948 80,926 1,146,703 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 98,486 87,792 102,459 96,396 104,288 101,345 106,712 102,407 92,332 89,613 83,948 80,926 1,146,703 40 Net Purchases - Millions of Gallons per Day (MGD) 3.177 3.135 3.305 3.213 3.364 3.378 3.442 3.303 3.078 2.891 2.798 2.611 38 41 Sales to Electric System - 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) 98,486 87,792 102,459 96,396 104,288 101,345 106,712 102,407 92,332 89,613 83,948 80,926 1,146,703 46 Water Rate / kgal - First Pass - Due to Seven Seas 4.41 $ 4.41 $ 4.41 $ 4.41 $ 4.42 $ 4.42 $ 4.42 $ 4.42 $ 4.42 $ 4.42 $ 4.42 $ 4.42 $ 47 Amount Due to Seven Seas - Regular Water (Line 45x46) 434,321 $ 387,162 $ 451,843 $ 425,108 $ 461,220 $ 448,206 $ 471,941 $ 452,902 $ 408,345 $ 396,320 $ 371,266 $ 357,901 $ 5,066,534 $ 48 Power from Electric System - kWh 1,156,657 1,031,066 1,203,320 1,132,121 1,224,802 1,190,242 1,253,271 1,202,713 1,084,388 1,052,454 985,922 950,430 13,467,385 49 kWh per kgal (Line 48/45) 11.74 11.74 11.74 11.74 11.74 11.74 11.74 11.74 11.74 11.74 11.74 11.74 50 Electric Rate / kWh - Due to Electric System 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 0.21 $ 51 Amount Due to Electric System - Regular Water (Line 50x48) 246,484 $ 219,720 $ 256,427 $ 241,255 $ 261,005 $ 253,641 $ 267,072 $ 256,298 $ 231,083 $ 224,278 $ 210,100 $ 202,537 $ 2,869,900 $ 52 Total First Pass Charges - Regular Water (Line 47+51) 680,805 $ 606,882 $ 708,270 $ 666,363 $ 722,226 $ 701,847 $ 739,013 $ 709,200 $ 639,428 $ 620,598 $ 581,366 $ 560,438 $ 7,936,434 $ Second Pass Charges (Ultra Pure Water) 53 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.67 $ 2.67 $ 2.67 $ 2.67 $ 2.68 $ 2.68 $ 2.68 $ 2.68 $ 2.68 $ 2.68 $ 2.68 $ 2.68 $ 55 Amount Due to Seven Seas - Ultra Pure Water (Line 53x54) 11,588 $ 10,466 $ 11,588 $ 11,214 $ 11,623 $ 11,248 $ 11,623 $ 11,623 $ 11,248 $ 11,623 $ 11,248 $ 11,623 $ 136,712 $ 56 Power from Electric System - kWh 12,684 11,456 12,684 12,275 12,684 12,275 12,684 12,684 12,275 12,684 12,275 12,684 149,342 57 Ultra Pure Water - kWh per kgal (Line 56/53) 2.92 2.92 2.92 2.92 2.92 2.92 2.92 2.92 2.92 2.92 2.92 2.92 58 Electric Rate / kWh - Due to Electric System 0.19 $ 0.19 $ 0.19 $ 0.19 $ 0.19 $ 0.19 $ 0.19 $ 0.19 $ 0.19 $ 0.19 $ 0.19 $ 0.19 $ 59 Amount Due to Electric System - Ultra Pure Water (Line 56x58) 2,408 $ 2,175 $ 2,408 $ 2,331 $ 2,408 $ 2,331 $ 2,408 $ 2,408 $ 2,331 $ 2,408 $ 2,331 $ 2,408 $ 28,356 $ 60 Total Second Pass Charges - Ultra Pure Water (Line 55+59) 13,996 $ 12,642 $ 13,996 $ 13,545 $ 14,031 $ 13,578 $ 14,031 $ 14,031 $ 13,578 $ 14,031 $ 13,578 $ 14,031 $ 165,067 $ Invoice Adjustments 61 Plus: Late Fees - - - - - - - - - - - - - 62 Less: Credits - - - - - - - - - - - - - 63 Total Invoice Adjustments - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 64 Total Water and Electric Charges (Lines 52+60) 694,801 $ 619,524 $ 722,266 $ 679,907 $ 736,256 $ 715,425 $ 753,043 $ 723,231 $ 653,006 $ 634,629 $ 594,944 $ 574,468 $ 8,101,501 $ Summary of Projected Costs ($) 65 Total Cost of Purchased Water - Due to Seven Seas (Lines 47+55) 445,909 $ 397,628 $ 463,431 $ 436,322 $ 472,843 $ 459,454 $ 483,563 $ 464,525 $ 419,592 $ 407,942 $ 382,514 $ 369,523 $ 5,203,246 $ 66 Total Electricy Charges - Due to Electric System (Lines 51+59) 248,892 221,895 258,836 243,586 263,414 255,971 269,480 258,706 233,414 226,686 212,431 204,945 2,898,255 67 Less: Electric System Billings for Internal Plant Use - Water (30,727) (27,754) (30,727) (29,736) (30,817) (29,822) (30,817) (30,817) (29,822) (30,817) (29,822) (30,817) (362,494) 68 Less: Electric System Billings for Internal Plant Use - Electricity (13,270) (11,986) (13,270) (12,842) (13,270) (12,842) (13,270) (13,270) (12,842) (13,270) (12,842) (13,270) (156,246) 69 Less: Electric System Billings for STT Station #2 Use - Water - - - - - - - - - - - - - 70 Total Water Purchase Costs - Billed to Customers (Sum Lines 65-69) 650,803 $ 579,784 $ 678,269 $ 637,329 $ 692,170 $ 672,760 $ 708,957 $ 679,144 $ 610,341 $ 590,542 $ 552,280 $ 530,382 $ 7,582,761 $ Preliminary Draft - Subject to Material Change 13 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B9 - Approved 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 12-Month Total Combined Systems 71 Gross Production - kgal (Lines 1+36) 157,898 142,030 173,215 173,194 180,914 181,797 180,521 159,327 155,264 155,356 130,984 156,242 1,946,742 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) 157,898 142,030 173,215 173,194 180,914 181,797 180,521 159,327 155,264 155,356 130,984 156,242 1,946,742 75 Net Purchases - Millions of Gallons per Day (MGD) 5.093 5.072 5.588 5.773 5.836 6.060 5.823 5.140 5.175 5.011 4.366 5.040 5.334 76 Sales to Electric System - 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 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 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,857,680 1,670,732 2,032,208 2,028,091 2,119,849 2,127,393 2,116,562 1,875,644 1,824,070 1,824,832 1,546,436 1,830,708 22,854,205 Summary of Projected Costs ($) 81 Total Cost of Purchased Water - Due to Seven Seas (Lines 30+65) 810,016 $ 729,749 $ 891,633 $ 897,741 $ 934,209 $ 941,516 $ 929,011 $ 814,550 $ 803,680 $ 808,873 $ 676,554 $ 824,683 $ 10,062,212 $ 82 Total Electricy Charges - Due to Electric System (Lines 31+66) 395,577 355,767 432,769 431,901 451,445 453,062 450,745 399,405 388,424 388,577 329,260 389,829 4,866,762 83 Less: Electric System Billings for Internal Plant Use - Water (Lines 32+67) (116,985) (105,664) (116,985) (113,211) (117,074) (113,297) (117,074) (117,074) (113,535) (117,319) (113,535) (117,319) (1,379,072) 84 Less: Electric System Billings for Internal Plant Use - Electricity (Lines 33+68) (43,313) (39,121) (43,313) (41,916) (43,313) (41,916) (43,313) (43,313) (41,916) (43,313) (41,916) (43,313) (509,976) 85 Less: Electric System Billings for STT Station #2 Use - Water (Lines 34+69) (19,012) (17,356) (22,642) (24,575) (24,520) (25,745) (23,619) (18,214) (20,138) (21,038) (15,052) (24,101) (256,012) 86 Total Water Purchase Costs - Billed to Customers (Sum Lines 81-85) 1,026,283 $ 923,375 $ 1,141,462 $ 1,149,939 $ 1,200,746 $ 1,213,620 $ 1,195,750 $ 1,035,353 $ 1,016,515 $ 1,015,780 $ 835,312 $ 1,029,778 $ 12,783,913 $ Preliminary Draft - Subject to Material Change 14 of 20 2/21/2023 4:26 PM 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 B11 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) B11 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 B11 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) B11 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 B11 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 15 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B11 - Projected 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 $ 487,978 $ 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 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 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 16 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B11 - Projected 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 17 of 20 2/21/2023 4:26 PM U.S. Virgin Islands Water and Power Authority Worksheet B11 - Projected 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 18 of 20 2/21/2023 4:26 PM 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 19 of 20 2/21/2023 4:26 PM 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 Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 5.71 $ 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.44 $ 6.44 $ 6.44 $ 6.44 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 2.99 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 4.55 $ 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 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 4.77 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ 2.89 $ Preliminary Draft - Subject to Material Change 20 of 20 2/21/2023 4:26 PM