{"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 2025 Sch S-2.Z27.XLSM"]
["01/12/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I UNPAID CONSTRUCTION COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2023"]
["2025 SPECIAL WATER RATES"]
[]
["Category","A) Component/Facility\n\n","Related Footnotes\n","B) Total Construction at 9/30/2023\n\n<Sch A-4>                  <Sch A-2Bc FSOD>","C) Ratio of Total\n\n<B/$150,840,233.68>\n                                                                            Folsom SOD <B/$6,744,363.05>","D) Cumulative Construction Repayment at 9/30/2023\n1/ \n                                                                            Folsom SOD <$0.00>\n\n<C*$140,255,138.20>","E) Net Unpaid Construction at 9/30/2023\n\n(B-D)\n","F) Unpaid Construction: Annualized Costs Remaining Years\n(E/6)\nFolsom SOD (E/49)","G) Annual Interest @ 0.023607\n                              Folsom SOD @ 0.018750                 2/","H) FY 2025 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","-",9842239.2899999991,6.5249430135964251E-2,9151567.8399999999,690671.44999999925,115111.90833333321,16304.372155543568,97963.71428571429,1.18,0.17,1.3499999999999999]
["Storage","All Other Contractors","-",41163133.285328753,0.27289226672301758,38274542.579999998,2888590.7053287551,481431.78422145918,68189.669436494238,245858.42857142849,1.96,0.28000000000000003,2.2400000000000002]
["Folsom SOD","San Felipe Unit Contractors","8/",1896015.8100000003,0.28112600047531544,0,1896015.8100000003,38694.200204081637,35550.296437500001,97963.71428571429,0.39,0.36,0.75]
["Folsom SOD","All Other Contractors","8/",4848347.24,0.71887399952468445,0,4848347.24,98945.862040816326,90906.510750000001,245858.42857142849,0.4,0.37,0.77]
["Total","Total Storage","-",57749735.625328757,1.3381416968589817,47426110.420000002,10323625.205328755,734183.75479969033,210950.8487795378,"-","-","-","-"]
["Conveyance","Contra Costa Canal System","3/",0,"-",0,0,0,0,"-",0,0,0]
["Conveyance","All Other Contractors","-",26941175.07,0.17860735435449335,25050599.170000002,1890575.8999999985,315095.9833333331,44629.980089522636,187030.42857142855,1.68,0.24,1.92]
["Total","Total Conveyance","-",26941175.07,0.17860735435449335,25050599.170000002,1890575.8999999985,315095.9833333331,44629.980089522636,"-","-","-","-"]
["Conveyance Pumping","Dos Amigos Pumping Plant, Capital only","4/",287465,1.9057581187944238E-3,267292.37,20172.630000000005,3362.1050000000009,476.20625823766608,12093.142857142855,0.28000000000000003,0.04,0.32]
["Conveyance Pumping","Dos Amigos Pumping Plant, PUE only","-",607830.8669254391,4.0296335536396033E-3,565176.81000000006,42654.056925439043,7109.0094875731738,1006.9152533467243,12371.142857142855,0.56999999999999995,0.08,0.64999999999999991]
["Total","Total Dos Amigos Pumping Plant","-","-","-","-","-",0,"-","-",0.85,0.12,0.97]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, Capital only","-",1664792.9699999997,1.1036796544585883E-2,1547967.42,116825.54999999981,19470.92499999997,2757.848531998915,110534.85714285714,0.18,0.02,0.19999999999999998]
["Conveyance Pumping","O'Neill P-Generator/Pumping Plant, PUE only","-",1933709.842837644,1.2819589280018539E-2,1798013.27,135696.57283764402,22616.095472940669,3203.3283318382064,110534.85714285714,0.2,0.03,0.23]
["Total","Total O'Neill P-Generator/Pumping Plant","-","-","-","-","-","-","-","-",0.38,0.05,0.43]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, Capital only","5/, 6/",1528846.1426592106,1.0135532843164657E-2,1421560.56,107285.58265921054,17880.930443201756,2532.6427878264003,48778.71428571429,0.37,0.05,0.42]
["Conveyance Pumping","Jones Pumping Plant, Friant Kern/Madera, PUE only","5/, 6/",2717251.5405722177,1.8014103227356928E-2,2526570.54,190681.00057221763,31780.166762036271,4501.3211365850666,48778.71428571429,0.65,0.09,0.74]
["Total","Total Friant Kern/Madera","-","-","-","-","-","-","-","-",1.02,0.14000000000000001,1.1599999999999999]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, Capital only","5/, 7/",3040430.5173407886,2.0156628261014515E-2,2827070.68,213359.83734078845,35559.972890131408,5036.690297608885,118936.14285714286,0.3,0.04,0.33999999999999997]
["Conveyance Pumping","Jones Pumping Plant, All Other Contractors, PUE only","5/, 7/",5444379.2175142411,3.609368060659001E-2,5062324.16,382055.05751424097,63675.842919040158,9019.0029450613511,118936.14285714286,0.54,0.08,0.62]
["Total","Total All Other Contractors","-","-","-","-","-","-",0,"-",0.84000000000000008,0.12,0.96]
["Total","Total Conveyance Pumping","-",17224706.09784954,0.11419172243516457,16015975.810000001,1208730.2878495404,201455.04797492339,28533.955542503216,"-","-","-","-"]
["Direct Pumping","Bella Vista WD (Wintu PP)","-",882405.83327223803,5.8499367951928977E-3,820483.69,61922.143272238085,10320.35721203968,1461.7683539394297,3487.1428571428573,2.96,0.42,3.38]
["Direct Pumping","Colusa County WD Relift PP","-",38257.458734849097,2.5362900731699966E-4,35572.769999999997,2684.6887348491,447.44812247484998,63.376246773737648,116.28571428571429,3.85,0.55000000000000004,4.4000000000000004]
["Direct Pumping","Contra Costa PP (Contra Costa WD)","-",5524310.6969774608,3.6623588824753195E-2,5136646.51,387664.18697746098,64610.697829576828,9151.4151567387889,75905.428571428565,0.85,0.12,0.97]
["Direct Pumping","Kanawha WD","-",2030.9602069455466,1.3464313580209342E-5,1888.44,142.52020694554653,23.753367824257754,3.3644108117184786,28.857142857142858,0.82,0.12,0.94]
["Direct Pumping","Pleasant Valley PP (City of Coalinga)","-",214646.77166816572,1.4230074192671098E-3,199584.1,15062.671668165713,2510.4452780276188,355.57775630444303,5430,0.46,7.0000000000000007E-2,0.53]
["Direct Pumping","Pleasant Valley WD Canalside Relift PP (City of Coalinga)","-",39926.8866050219,2.646965310757999E-4,37125.050000000003,2801.8366050218974,466.97276750364955,66.141704173962594,5430,0.09,0.01,9.9999999999999992E-2]
["Direct Pumping","San Benito County WD, Pacheco PP","-",265976.79726804898,1.7633014134051895E-3,247312.08,18664.717268048989,3110.7862113414981,440.60963648674272,"-","-","-","-"]
["Direct Pumping","San Benito County WD, Gianelli, WR PGP","-",429721.51274010004,2.8488520749484878E-3,399566.14,30155.372740100021,5025.8954566833372,711.86440331900917,"-","-","-","-"]
["Total","Total San Benito County WD","-",695698.31000814901,4.6121534883536777E-3,646878.22,48820.090008149011,8136.6816680248357,1152.474039805752,6512.5714285714284,1.25,0.18,1.43]
["Direct Pumping","San Luis WD Canalside Relift PP","-",85437.353435033307,5.6640958014757747E-4,79441.850000000006,5995.5034350333008,999.25057250555017,141.53316930158744,497,2.0099999999999998,0.28000000000000003,2.29]
["Direct Pumping","Santa Clara Valley WD, Coyote PP","-",1557831.687735518,1.0327693411779462E-2,1448512.07,109319.61773551791,18219.936289252986,2580.6593445575995,"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Pacheco PP","-",5412499.5153633691,3.5882333134032399E-2,5032681.59,379817.92536336929,63302.987560561545,8966.1919664854395,"-","-","-","-"]
["Direct Pumping","Santa Clara Valley WD, Gianelli, WR PGP","-",8947424.3380522802,5.9317226704266451E-2,8319545.8300000001,627878.50805228017,104646.41800871336,14822.047246562524,"-","-","-","-"]
["Total","Total Santa Clara WD","-",15917755.541151168,0.10552725325007831,14800739.49,1117016.0511511674,186169.34185852789,26368.898557605564,91451.142857142855,2.04,0.28999999999999998,2.33]
["Direct Pumping","Shasta Pumping Plant (City of Shasta Lake)","-",598053.86964352999,3.9648166474164828E-3,556085.91,41967.959643529961,6994.6599405883271,990.71886153242156,1120.8571428571429,6.24,0.88,7.12]
["Direct Pumping","State Delta PP (Cross Valley Canal)  ","-",17539.656543939338,1.1627969616989246E-4,16308.82,1230.8365439393383,205.13942398988971,29.055808047415375,278,0.74,0.1,0.84]
["Direct Pumping","Westlands WD Relifts","-",913610.02857523935,6.0568059741856152E-3,849498.16,64111.868575239321,10685.311429206553,1513.4602202508904,2971.5714285714284,3.6,0.51,4.1100000000000003]
["Total","Total Direct Pumping","-",24929673.36682174,0.16527204152753777,23180253.009999998,1749420.3568217396,291570.05947028991,41297.784285285707,"-","-","-","-"]
["Subtotal","Subtotal","-",126845290.16000003,1.79621282,111672938.41,15172351.750000034,1542304.8455782367,325412.56869684934,"-","-","-","-"]
["Other Costs","Deferred Interest Capitalized ","-",21277763,0.1410615886700419,19784612.609999999,1493150.3900000006,248858.39833333343,35248.133743989354,"-","-","-","-"]
["Other Costs","Programmatic EIS Capitalized  ","-",1624377.1273268,1.0768858464115676E-2,1510387.73,113989.39732680004,18998.232887800008,2690.8967437444721,"-","-","-","-"]
["Other Costs","All others","-",7837166.455000001,5.195673768966505E-2,7287199.4299999997,549967.0250000013,91661.170833333555,12982.825696468508,"-","-","-","-"]
["Total","Total Other Costs","-",30739306.582326803,0.20378718482382263,28582199.77,2157106.8123268019,359517.80205446703,50921.856184202334,343822.14285714278,1.05,0.15,1.2]
["Grand Total","Total","-",157584596.74232683,2.0000000048238227,140255138.18000001,17329458.562326834,1901822.6476327037,376334.42488105199,"-","-","-","-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2.4207491611354961E-2]

{"sheet":"Footnotes","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Special Rates 2025 Sch S-2.Z27.XLSM"]
["01/12/2025"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I UNPAID CAPITAL COSTS BY COMPONENT AND/OR FACILITY"]
["AS OF SEPTEMBER 30, 2023"]
["2025 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/2023 (Column C of A-2Ba)","Construction Repayment per Assignment","Adjusted M&I Construction Repayment"]
[141034283.19849169,-779145,140255138.19849169]
[]
["2/"]
["Annual Interest of 0.023607 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/2023","Project Use Energy: BOR","Project Use Energy: DOE","Project Use Energy: Total"]
["Jones Pumping Plant: Delta-Mendota Exchange",2514767.9085849989,0.33292997699999999,1528846.1426592106,1366825.3309636072,1350426.2096086103,2717251.5405722177]
["Jones Pumping Plant: All Other Contractors",5038675.9999999991,0.66707002299999996,3063249.0373407886,2738618.5322773624,2705760.6852368792,5444379.2175142411]
["Jones Pumping Plant: Total  a/",7553443.908584998,1,4592095.18,4105443.8632409694,4056186.8948454894,8161630.7580864588]
[]
["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"]
[12753725.938086459,4105443.8632409698,4056186.8948454899,4592095.18]
[]
["6/"]
["FY 2025 projected deliveries include Friant Dam and Friant-Kern Canal."]
[]
["7/"]
["FY 2025 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."]