{"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":1,"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":55,"n_cols":18,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
["2026 Full Cost Additional Service Water Rates Sch TR-2b.Z28.xlsm"]
["01/14/2026"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"]
["AS OF SEPTEMBER 30, 2024"]
["2026 SPECIAL WATER RATES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT PUBLISH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027 rates will be 4 years remaining"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Category","A) Component / Facility\n<Ref>","Related Footnotes","B) Total M&I Construction at 9/30/2024\n<Sch A-4>","C) Ratio of Total\n\n<B/$151,577,449.33>\n                                                                            Folsom SOD <B/$6,744,363.05>","D) Allocation of Construction Repayment at 9/30/2024  1/\n<C*$140,983,352.98>\n                                                                            Folsom SOD <C/$72,410.14>","E) Unpaid M&I Construction: Net Unpaid Construction at 9/30/2024\n(B-D)","F) Unpaid M&I Construction: Annualized Costs Remaining Years\n(E/5)\nFolsom SOD                         (E/48)","G) Unpaid M&I Construction: Annual Interest @\n(E*0.08012) ","H) FY 2026 Projected Deliveries\n<Sch S-6>","I) Unpaid M&I Construction Cost Per Acre Foot: Construction Only\n(F/H)","J) Unpaid M&I Construction Cost Per Acre Foot: Interest\n(G/H)","K) Unpaid M&I Construction Cost Per Acre Foot: Total\n(I+J)",null,null,null,"Folsom SOD 50 year repayment begins with 2024 rates (decrease by 1 every year)(2027 rates will be 47)"]
["Storage","San Felipe Unit","-",9430234.459999999,6.2213967193685348E-2,8771133.6972882599,659100.76271173917,131820.15254234785,52807.153108464539,90985.42857142858,1.45,0.57999999999999996,2.0299999999999998,null,null,null,48]
["Storage","All Other Contractors","-",40518050.973788038,0.26730922807144286,37686151.256586649,2831899.7172013894,566379.94344027783,226891.8053421753,254422.71428571432,2.23,0.89,3.12]
["Folsom SOD","San Felipe Unit","7/",1776559.6500000001,0.26341400022942119,16705.939999999999,1759853.7100000002,36663.61895833334,140999.4792452,90985.42857142858,0.4,1.55,1.9500000000000002]
["Folsom SOD","All Other Contractors","7/",4967803.4000000004,0.7365859997705787,55704.2,4912099.2,102335.40000000001,393557.387904,254422.71428571432,0.4,1.55,1.9500000000000002]
["Total","Storage","-",56692648.483788036,1.3295231952651281,46529695.093874909,10162953.389913129,837199.11494095903,814255.82559983991,"-",0,0,0]
["Conveyance","Contra Costa Canal System","2/",0,"-",0,0,0,0,"-",0,0,0]
["Conveyance","All Other Contractors","-",27431747.949999996,0.18097512572627439,25514480.031259283,1917267.9187407121,383453.58374814241,153611.50564950585,184004.85714285716,2.08,0.83,2.91]
["Total","Conveyance","-",27431747.949999996,0.18097512572627439,25514480.031259283,1917267.9187407121,383453.58374814241,153611.50564950585,"-",0,0,0]
["Conveyance Pumping","Dos Amigos Pumping Plant, Construction only","3/",279645.47999999992,1.8449016079481856E-3,260100.41461072539,19545.065389274532,3909.0130778549064,1565.9506389886756,12092.285714285714,0.32,0.13,0.45]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",658041.29143471003,4.3412875354330686E-3,612049.27300503943,45992.018429670599,9198.4036859341195,3684.8805165852082,12370.285714285714,0.74,0.3,1.04]
["Conveyance Pumping","Dos Amigos Pumping Plant, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",1.06,0.43,1.49]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Construction only  ","-",1677015.6650000003,1.1063754353951285E-2,1559805.1853910943,117210.47960890597,23442.095921781194,9390.9036262655463,103525.71428571429,0.23,0.09,0.32]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only  ","-",1968070.3219206519,1.298392558129856E-2,1830517.3633223947,137552.95859825728,27510.591719651457,11020.743042892373,103525.71428571429,0.27,0.11,0.38]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",0.5,0.2,0.7]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Construction only","4/, 5/",1587189.2230389828,1.0471143498198689E-2,1476256.9199334623,110932.30310552055,22186.46062110411,8887.8961248143059,53232.285714285725,0.42,0.17,0.59]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","4/, 5/",2782112.7811598754,1.8354397658975407E-2,2587664.5239303783,194448.25722949719,38889.651445899435,15579.194369227314,53232.285714285725,0.73,0.28999999999999998,1.02]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",1.1499999999999999,0.45999999999999996,1.6099999999999999]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Construction only Construction only  4/  6/","4/, 6/",3135722.706961018,2.0687263974915743E-2,2916559.8392108004,219162.86775021767,43832.573550043533,17559.32896414744,112313.28571428571,0.39,0.16,0.55000000000000004]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","4/, 6/",5536465.2114531249,3.6525652304335701E-2,5149508.9317260394,386956.27972708549,77391.255945417099,31002.937131734088,112313.28571428571,0.69,0.28000000000000003,0.97]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Unpaid M&I Construction Per Acre Foot Total","-",0,"-",0,0,0,0,"-",1.08,0.44000000000000006,1.52]
["Total","Conveyance Pumping","-",17624262.680968363,0.11627232651505665,16392462.451129936,1231800.2298384293,246360.04596768584,98691.83441465495,"-",0,0,0]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",888486.64507437299,5.8616017685613944E-3,826388.27117798175,62098.373896391247,12419.67477927825,4975.3217165788665,3495,3.55,1.42,4.97]
["Direct Pumping","Colusa County WD Relift PP","-",36796.619897131168,2.4275787763591069E-4,34224.819551945147,2571.8003451860204,514.36006903720408,206.05264365630396,110.42857142857143,4.66,1.87,6.53]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5714369.3129848,3.7699336795772379E-2,5314978.9066719506,399390.40631284937,79878.081262569875,31999.15935378549,77293.857142857145,1.03,0.41,1.44]
["Direct Pumping","Kanawha WD","-",88.0099493743176,5.806269320573928E-7,81.858731713199745,6.1512176611178546,1.230243532223571,0.49283555900876247,32.428571428571431,0.04,0.02,0.06]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",37041.310827478846,2.4437217403308029E-4,34452.408470725153,2588.9023567536933,517.78047135073871,207.42285682310589,5182.8571428571431,0.1,0.04,0.14000000000000001]
["Direct Pumping","Canalside Relift PP (City of Coalinga)","-",218483.36287728307,1.4413975419242484E-3,203213.05844073326,15270.304436549806,3054.0608873099613,1223.4567914563704,5182.8571428571431,0.59,0.24,0.83]
["Direct Pumping","San Benito County WD, Pacheco PP","-",256199.15343007899,1.6902194525658587E-3,238292.80569841649,17906.347731662507,3581.2695463325012,1434.6565802608,"-",0,0,0]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",411999.95567201509,2.7180821256037537E-3,383204.33174851112,28795.623923503968,5759.1247847007935,2307.105388751138,"-",0,0,0]
["Total","San Benito County WD","-",668199.10910209408,4.4083015781696128E-3,621497.13744692761,46701.971655166475,9340.3943310332943,3741.7619690119382,5086.7142857142853,1.84,0.74,2.58]
["Direct Pumping","San Luis WD Canalside Relift PP","-",87392.440291731502,5.7655304715360063E-4,81284.381759799697,6108.0585319318052,1221.611706386361,489.37764957837624,466.85714285714283,2.62,1.05,3.67]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1586882.6107762652,1.0469120688974294E-2,1475971.7375065638,110910.87326970138,22182.174653940274,8886.1791663684744,"-",0,0,0]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5513432.4100559205,3.6373698293374203E-2,5128085.9457615977,385346.46429432277,77069.292858864559,30873.95871926114,"-",0,0,0]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",9087385.3042712901,5.9952092770799728E-2,8452247.0571252424,635138.24714604765,127027.64942920953,50887.276361341334,"-",0,0,0]
["Total","Santa Clara WD","-",16187700.325103477,0.10679491175314823,15056304.740393404,1131395.5847100718,226279.11694201437,90647.414246970948,85898.71428571429,2.63,1.06,3.69]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",600282.07923531893,3.960233411259572E-3,558326.98491137708,41955.094323941856,8391.0188647883715,3361.4421572342212,937.14285714285711,8.9499999999999993,3.59,12.54]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",18460.35019719959,1.2178823616995396E-4,17170.113889024062,1290.2363081755284,258.04726163510566,103.37373301102333,278,0.93,0.37,1.3]
["Direct Pumping","Westlands WD Relifts","-",888432.29470333166,5.8612432035421184E-3,826337.71947930218,62094.575224029482,12418.915044805897,4975.0173669492415,3164.5714285714284,3.92,1.57,5.49]
["Total","Direct Pumping","-",25345731.860243592,0.16721307801430213,23574260.400924888,1771471.4593187082,354294.29186374164,141930.29332061487,"-",0,0,0]
["Subtotal","-","-",127094390.97499998,1.7939837300000001,112010897.97718903,15083492.997810978,1821307.0365205288,1208489.4589846155,"-",0,0,0]
["Other Costs","Other Costs: Deferred Interest Capitalized ","-",21277763,0.14037551821771058,19790611.234942019,1487151.765057981,297430.35301159619,119150.59941644543,"-",0,0,0]
["Other Costs","Other Costs: Programmatic EIS Capitalized  ","-",1943034.8413000002,1.2818759319885017E-2,1807231.6699887842,135803.17131121596,27160.634262243191,10880.550085454623,"-",0,0,0]
["Other Costs","Other Costs: All others","-",8006623.5649999995,5.2821996941643169E-2,7447022.2400465915,559601.32495340798,111920.26499068159,44835.258155267045,"-",0,0,0]
["Total","Other Costs","-",31227421.406300001,0.20601627447923876,29044865.144977394,2182556.261322605,436511.25226452097,174866.40765716712,345408.1428571429,1.26,0.51,1.77]
["Grand Total","-","-",158321812.38129997,2.0000000044792388,141055763.12216642,17266049.259133585,2257818.2887850497,1383355.8666417827,"-",0,0,0]

{"sheet":"Footnotes","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["2026 Full Cost Additional Service Water Rates Sch TR-2b.Z28.xlsm"]
["01/14/2026"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I FULL COST ADDITIONAL SERVICE WATER RATES"]
["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 9/30/2024 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted M&I Construction Repayment"]
[141762497.98216638,-779145,140983352.98216638]
[]
["2/"]
["Contra Costa WD's conveyance costs are recovered through a repayment contract."]
[]
["3/"]
["Cross Valley Canal contractors are charged for PUE constrcution component only.  Therefore their deliveries are not included in determining"]
[" the \"Construction only\" rate."]
[]
["4/"]
["Suballocation of Jones Pumping Plant costs:"]
[]
["Component/Facility","Historical & Projected Deliveries (1981-2030) (Sch A-7)","Ratio","M&I\nConstruction\nCosts\nat 9/30/2024","Project Use Energy\nBOR","Project Use Energy\nDOE","Project Use Energy\nTotal"]
["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]
["Total",7494797.7102428563,1,4745730.4500000011,4148438.1779716602,4170139.8146413402,8318577.9926130008]
[]
["a/"]
["Jones Pumping Plant - Conveyance Pumping:"]
[]
["Component/Facility","M&I\nConstruction\nCosts\nat 9/30/2021"]
["Total Construction Cost (M&I Sch A-5)",13064308.442613]
["less:  BOR PUE (M&I Sch A-5)",4148438.1779716602]
["less:  DOE PUE (M&I Sch A-5)",4170139.8146413402]
["Capital Allocation",4745730.4500000011]
[]
["5/"]
["FY 2026 projected deliveries include Friant Dam and Friant-Kern Canal"]
[]
["6/"]
["FY 2026 projected deliveries for Jones PP do not include Delta Mendota Exchange contractors' deliveries."]
[]
["7/"]
["Folsom SOD has a repayment period of 50 years beginning in 2024."]