{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":28,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"OUTPUT","index":0,"n_rows":238,"n_cols":13,"rows_kept":238,"cut":false,"hidden":false,"merged":[]}
[]
["Special Rates 2026 Sch S-2.Z28.XLSM"]
["01/13/2026"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2024"]
["2026 SPECIAL WATER RATES"]
[]
[]
["Category","A) Component/Facility\n\n","Related Footnotes\n","B) Total Construction at 9/30/2024\n\n<Sch A-4>                  <Sch A-2Bc FSOD>","C) Ratio of Total\n\n<B/$151,577,449.33>\n                                                                            Folsom SOD <B/$6,744,363.05>","D) Cumulative Construction Repayment at 9/30/2024\n1/                                                                      Folsom SOD <$72,410.14>\n<C*$140,983,352.98>","E) Net Unpaid Construction at 9/30/2024\n\n(B-D)\n","F) Unpaid Construction: Annualized Costs Remaining Years\n(E/5)\nFolsom SOD (E/48)","G) Annual Interest @ 0.023630\n                              Folsom SOD @ 0.01875                2/","H) FY 2026 Projected Deliveries\n\n\n<Sch S-6>","I) Unpaid Construction Cost Per Acre Foot Construction Only\n\n(F/H)","J) Unpaid Construction Cost Per Acre Foot Interest\n\n(G/H)","K) Unpaid Construction Cost Per Acre Foot Total\n\n(I+J)"]
["Storage","San Felipe Unit","-",9430234.459999999,6.2213967193685348E-2,8771133.6999999993,659100.75999999978,131820.15199999994,15574.318306286361,90985.42857142858,1.45,0.17,1.6199999999999999]
["Storage","All Other Contractors","-",40518050.973788038,0.26730922807144286,37686151.259999998,2831899.71378804,566379.94275760802,66916.790619413325,254422.71428571432,2.23,0.26,2.4900000000000002]
["Folsom SOD","San Felipe Unit Contractors","8/",1776559.6500000001,0.26341400022942119,16705.939999999999,1759853.7100000002,36663.61895833334,32997.257062500001,90985.42857142858,0.4,0.36,0.76]
["Folsom SOD","All Other Contractors","8/",4967803.4000000004,0.7365859997705787,55704.2,4912099.2,102335.40000000001,92101.86,254422.71428571432,0.4,0.36,0.76]
["Total","Total Storage","-",56692648.483788036,1.3295231952651281,46529695.099999994,10162953.38378804,837199.11371594132,207590.2259881997,"-","-","-","-"]
["Conveyance","Contra Costa Canal System","3/",0,"-",0,0,0,0,"-",0,0,0]
["Conveyance","All Other Contractors","-",27431747.949999996,0.18097512572627439,25514480.030000001,1917267.9199999943,383453.58399999887,45304.364183272213,184004.85714285716,2.08,0.25,2.33]
["Total","Total Conveyance","-",27431747.949999996,0.18097512572627439,25514480.030000001,1917267.9199999943,383453.58399999887,45304.364183272213,"-","-","-","-"]
["Conveyance Pumping","Dos Amigos Pumping Plant, Capital only","4/",279645.47999999992,1.8449016079481856E-3,260100.41,19545.06999999992,3909.0139999999838,461.84310498845002,12092.285714285714,0.32,0.04,0.36]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",658041.29143471003,4.3412875354330686E-3,612049.27,45992.021434710012,9198.4042869420027,1086.7752320202437,12370.285714285714,0.74,0.09,0.83]
["Total","Total Dos Amigos Pumping Plant","-","-","-","-","-",0,"-","-",1.06,0.13,1.19]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Capital only","-",1677015.6650000003,1.1063754353951285E-2,1559805.19,117210.47500000033,23442.095000000067,2769.6421507403898,103525.71428571429,0.23,0.03,0.26]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only","-",1968070.3219206519,1.298392558129856E-2,1830517.36,137552.96192065184,27510.592384130367,3250.3279360878287,103525.71428571429,0.27,0.03,0.30000000000000004]
["Total","Total O'Neill P-Generator/Pumping Plant","-","-","-","-","-","-","-","-",0.5,0.06,0.56000000000000005]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Capital only","5/, 6/",1587189.2230389828,1.0471143498198689E-2,1476256.92,110932.30303898291,22186.46060779658,2621.2911634004763,53232.285714285725,0.42,0.05,0.47]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","5/, 6/",2782112.7811598754,1.8354397658975407E-2,2587664.52,194448.26115987543,38889.652231975087,4594.7437739379939,53232.285714285725,0.73,0.09,0.82]
["Total","Total Friant Kern/Madera","-","-","-","-","-","-","-","-",1.1499999999999999,0.14000000000000001,1.29]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Capital only","5/, 7/",3135722.706961018,2.0687263974915743E-2,2916559.84,219162.86696101818,43832.573392203638,5178.741185140173,112313.28571428571,0.39,0.05,0.44]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","5/, 7/",5536465.2114531249,3.6525652304335701E-2,5149508.93,386956.28145312518,77391.256290625039,9143.6403410730509,112313.28571428571,0.69,0.08,0.76999999999999991]
["Total","Total All Other Contractors","-","-","-","-","-","-",0,"-",1.08,0.13,1.21]
["Total","Total Conveyance Pumping","-",17624262.680968363,0.11627232651505665,16392462.439999999,1231800.2409683638,246360.04819367273,29107.004887388604,"-","-","-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",888486.64507437299,5.8616017685613944E-3,826388.27,62098.375074372976,12419.675014874596,1467.3626832283489,3495,3.55,0.42,3.9699999999999998]
["Direct Pumping","Colusa County WD Relift PP","-",36796.619897131168,2.4275787763591069E-4,34224.82,2571.7998971311681,514.35997942623362,60.77072376307887,110.42857142857143,4.66,0.55000000000000004,5.21]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5714369.3129848,3.7699336795772379E-2,5314978.91,399390.40298479982,79878.080596959961,9437.4542438113058,77293.857142857145,1.03,0.12,1.1499999999999999]
["Direct Pumping","Kanawha WD","-",88.0099493743176,5.806269320573928E-7,81.86,6.1499493743176004,1.2299898748635201,0.14532113287681384,32.428571428571431,0.04,0,0.04]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",211384.90287728308,1.3945669610475045E-3,196610.73,14774.172877283068,2954.8345754566135,349.10849003255464,5182.8571428571431,0.56999999999999995,7.0000000000000007E-2,0.6399999999999999]
["Direct Pumping","Pleasant Valley WD Canalside Relift PP (City of Coalinga)","-",44139.770827478846,2.9120275490982422E-4,41054.74,3085.0308274788476,617.00616549576955,72.898189484505508,5182.8571428571431,0.12,0.01,0.13]
["Direct Pumping","San Benito County WD, Pacheco PP","-",256199.15343007899,1.6902194525658587E-3,238292.81,17906.343430078996,3581.2686860157992,423.12057458669887,"-","-","-","-"]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",411999.95567201509,2.7180821256037537E-3,383204.33,28795.62567201507,5759.1251344030143,680.43047021313396,"-","-","-","-"]
["Total","Total San Benito County WD","-",668199.10910209408,4.4083015781696128E-3,621497.14,46701.969102094066,9340.3938204188125,1103.5510447998329,5086.7142857142853,1.84,0.22,2.06]
["Direct Pumping","San Luis WD Canalside Relift PP","-",87392.440291731502,5.7655304715360063E-4,81284.38,6108.0602917314973,1221.6120583462994,144.33130864151136,466.85714285714283,2.62,0.31,2.93]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1586882.6107762652,1.0469120688974294E-2,1475971.74,110910.87077626516,22182.174155253033,2620.7847265977175,"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5513432.4100559205,3.6373698293374203E-2,5128085.95,385346.4600559203,77069.292011184065,9105.6008296994933,"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",9087385.3042712901,5.9952092770799728E-2,8452247.0600000005,635138.24427128956,127027.64885425792,15008.092518019439,"-","-","-","-"]
["Total","Total Santa Clara WD","-",16187700.325103477,0.10679491175314823,15056304.75,1131395.575103475,226279.11502069503,26734.478074316648,85898.71428571429,2.63,0.31,2.94]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",600282.07923531893,3.960233411259572E-3,558326.98,41955.09923531895,8391.0198470637897,991.38418542058582,937.14285714285711,8.9499999999999993,1.06,10.01]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",18460.35019719959,1.2178823616995396E-4,17170.11,1290.2401971995896,258.04803943991794,30.48792042471943,278,0.93,0.11,1.04]
["Direct Pumping","Westlands WD Relifts","-",888432.29470333166,5.8612432035421184E-3,826337.72,62094.574703331687,12418.914940666338,1467.2728818021162,3164.5714285714284,3.92,0.46,4.38]
["Total","Total Direct Pumping","-",25345731.860243592,0.16721307801430216,23574260.41,1771471.4502435913,354294.29004871822,41859.245066858086,"-","-","-","-"]
["Subtotal","Subtotal","-",127094390.97499998,1.7939837300000001,112010897.97999999,15083492.99499999,1821307.0359583311,323860.84012571856,"-","-","-","-"]
["Other Costs","Deferred Interest Capitalized ","-",21277763,0.14037551821771058,19790611.23,1487151.7699999996,297430.35399999993,35140.871383211823,"-","-","-","-"]
["Other Costs","Programmatic EIS Capitalized  ","-",1943034.8413000002,1.2818759319885017E-2,1807231.67,135803.17130000028,27160.634260000057,3208.9810013712281,"-","-","-","-"]
["Other Costs","All others","-",8006623.5649999995,5.2821996941643169E-2,7447022.2400000002,559601.32499999925,111920.26499999985,13223.181779019029,"-","-","-","-"]
["Total","Total Other Costs","-",31227421.406300001,0.20601627447923876,29044865.140000001,2182556.2662999993,436511.25325999985,51573.034163602075,345408.1428571429,1.26,0.15,1.41]
["Grand Total","Total","-",158321812.38129997,2.0000000044792388,141055763.12,17266049.26129999,2257818.2892183308,375433.87428932067,"-","-","-","-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2.4207491611354961E-2]

{"sheet":"Footnotes","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Special Rates 2026 Sch S-2.Z28.XLSM"]
["01/13/2026"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I UNPAID CAPITAL COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2024"]
["2026 SPECIAL WATER RATES"]
[]
["Footnotes:"]
[]
["1/"]
["Refer to M&I Water Rates, Schedule A-2Ba.  Total Allocation of Construction Repayment is being reduced by the Assignment "]
[]
["Repayment as of 09/30/2024 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted M&I Construction Repayment"]
[141762497.98216638,-779145,140983352.98216638]
[]
["2/"]
["Annual Interest of 0.023630 is from M&I Schedule A-13 and 0.018750 is from M&I Schedule A-13 FSOD."]
[]
["3/"]
["Contra Costa WD's conveyance costs are recovered through a repayment contract."]
[]
["4/"]
["Cross Valley Canal contractors are charged for PUE construction component only.  Therefore their deliveries are not included in determining the \"Construction only\" rate."]
[]
["5/"]
["Suballocation of Jones Pumping Plant costs:"]
[]
["Facility/Contractor\n<Ref>","Historical & Projected Deliveries (1981-2030)\n<Sch A-7>","Ratio","M&I Construction Costs at 9/30/2024","Project Use Energy: BOR","Project Use Energy: DOE","Project Use Energy: Total"]
["Jones Pumping Plant: Delta-Mendota Exchange",2506602.9959571436,0.33444571699999998,1587189.2230389828,1387427.3808619054,1394685.40029797,2782112.7811598754]
["Jones Pumping Plant: All Other Contractors",4988194.7142857127,0.66555428299999997,3158541.2269610181,2761010.7971097548,2775454.4143433701,5536465.2114531249]
["Jones Pumping Plant: Total  a/",7494797.7102428563,1,4745730.4500000011,4148438.1779716602,4170139.8146413402,8318577.9926130008]
[]
["a/"]
["Jones Pumping Plant - Conveyance Pumping:"]
[]
["Total Construction Cost (M&I Sch A-5)","less:  BOR PUE (M&I Sch A-5)","less:  DOE PUE (M&I Sch A-5)","   Capital Allocation"]
[13064308.442613,4148438.1779716602,4170139.8146413402,4745730.4500000011]
[]
["6/"]
["FY 2026 projected deliveries include Friant Dam and Friant-Kern Canal."]
[]
["7/"]
["FY 2026 projected deliveries for Jones PP do not include Delta Mendota Exchange contractors' deliveries."]
[]
["8/"]
["Folsom SOD has a repayment period of 50 years beginning in 2024."]