CVPIA EXPENDITURES, CREDITS, AND OFFSETS

TO DETERMINE WATER AND POWER CONTRACTOR REPAYMENT OBLIGATIONS

FY 1993 - FY 2011

PLANT IN SERVICE

Reconciliation 1/

Expenditures by Source of Funds Percentage Cost Share Obligation Dollar Cost Share Obligation Amount To Pay (+) or Credit/Offset (-)

(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16) (12)-(1) (13)-(2) (15)

Water and Water and Water and

Restoration State Power Federal Power Federal Power

Activity Fund Trust WRR Bay-Delta ARRA Total Contractors State Taxpayers Other Total Contractors State Taxpayers Other Total Contractors State Other

Water Transfer Program 3405(a) - - - 1,169,522 - 1,169,522 100% 100% 1,169,522 - - 1,169,522 1,169,522 -

Anadromous Fish Restoration (b)(1) 79,992,865 - - 2,061,835 - 82,054,699 100% 100% 82,054,699 - - 82,054,699 2,061,835 -

Other CVP Impacts (b)(1) 27,116,586 2,058,274 0 29,174,860 100% 100% 29,174,860 - - 29,174,860 2,058,274 (2,058,274)

Other CVP Impacts-SJ River Restoration (b)(1) 8,306,415 900,174 0 9,206,589 100% 100% 9,206,589 - - 9,206,589 900,174 (900,174)

Other CVP Impacts-Trinity River (b)(1) 9,037,172 40,588,471 116,300 5,099,087 54,841,031 100% 100% 54,841,031 - - 54,841,031 45,803,858 -

Other CVP Impacts-Smelt Turbidity (b)(1) 824,072 824,072 100% 100% 824,072 - - 824,072 824,072 -

Dedicated Project Yield (b)(2) 16,504,294 - 41,269 - - 16,545,563 100% 100% 16,545,563 - - 16,545,563 41,269 -

Water Acquisition - Instream Flow (b)(3) 63,574,087 - 7,869,963 2,664,858 - 74,108,909 100% 100% 74,108,909 - - 74,108,909 10,534,821 -

Water Acquisition - Refuge (Level 4) (b)(3) 95,087,163 225,754 2,003,773 - - 97,316,690 25% 75% 100% - 24,329,172 72,987,517 97,316,690 (95,087,163) 24,103,418

Water Acquisition - Permanent (b)(3) 1,286 - - - - 1,286 100% 100% 1,286 - - 1,286 - -

Flow Fluctuation Study (b)(9) 947,450 - 251,032 - - 1,198,482 100% 100% 1,198,482 - - 1,198,482 251,032 -

Reservoir Storage (b)(19) - - - - - - 100% 100% - - - - - -

Trinity River Restoration (b)(23) 4,863,910 - 47,611,793 883,539 - 53,359,242 100% 100% 53,359,242 - - 53,359,242 48,495,332 -

San Joaquin Comprehensive Plan (c)(1) 27,435,226 - 895,530 - - 28,330,756 100% 100% 28,330,756 - - 28,330,756 895,530 -

Amer Rvr Folsom-South Op Study (c)(2) - - 651,107 - - 651,107 100% 100% 651,107 - - 651,107 651,107 -

Stanislaus Rvr Basin Water Needs (c)(2) 276,311 - - - - 276,311 100% 100% 276,311 - - 276,311 - -

Refuge Water Conveyance - Reim. (d)(5) 98,957,938 3,811,056 12,040,575 293,928 - 115,103,497 100% 100% 115,103,497 - - 115,103,497 16,145,559 (3,811,056)

 Refuge Water Convey. - Reim. (d)(5) - IDC 261,879

Refuge Water Conveyance - Non-reim. (d)(5) 49,478,969 1,905,528 6,020,288 146,964 - 57,551,749 25% 75% 100% - 14,387,937 43,163,811 57,551,749 (49,478,969) 12,482,409

Private Wetlands Investigation (d)(6) 1,996,640 - 11,390 - - 2,008,030 100% 100% 2,008,030 - - 2,008,030 11,390 -

Supporting Investigations (e) 1,947,325 - - - - 1,947,325 100% 100% 1,947,325 - - 1,947,325 - -

Project Fisheries Impact Report (f) 1,416,344 - - - - 1,416,344 100% 100% 1,416,344 - - 1,416,344 - -

Eco/Water System Ops Model (g) 50,077,862 14,789,731 9,540,727 - - 74,408,321 25% 75% 100% - 18,602,080 55,806,241 74,408,321 (50,077,862) 3,812,349

Land Retirement (h) 26,950,190 7,745,958 6,845,114 - - 41,541,261 100% 100% 41,541,261 - - 41,541,261 14,591,072 (7,745,958)

Water Conservation (i) 55,217 - (451) - - 54,766 100% 100% - - 54,766 54,766 (55,217) -

Water Augmentation (j) 1,788,307 - - - - 1,788,307 100% 100% 1,788,307 - - 1,788,307 - -

 Subtotal - Habitat Rest, Imp & Acq 565,811,558 31,436,475 134,370,581 8,161,018 5,099,087 744,878,718 515,547,194 57,319,190 172,012,335 744,878,718 (50,002,485) 25,882,715

Tracy Pumping Plant (b)(4) 43,868 265,435 23,329,425 518,756 - 24,157,484 37.5% 25% 37.5% 100% 9,059,057 6,039,371 9,059,057 24,157,484 9,015,189 5,773,936

Tracy Test Facility (b)(4) - 3,270,279 - - - 3,270,279 37.5% 25% 37.5% 100% 1,226,355 817,570 1,226,355 3,270,279 1,226,355 (2,452,709)

Contra Costa Canal Pump (b)(5) - 995,987 704,826 - 18,994 1,719,807 37.5% 25% 37.5% 100% 644,928 429,952 644,928 1,719,807 644,928 (566,035)

Shasta Temp. Control Device (b)(6) 30,496,545 7,719,113 45,898,784 - - 84,114,442 37.5% 25% 37.5% 100% 31,542,916 21,028,610 31,542,916 84,114,442 1,046,371 13,309,498

 Shasta Temp. Control Device (b)(6) - IDC 2,558,370

Research Pumping Plant Eval. (b)(10) 1,554,746 - 31,070,514 - - 32,625,260 37.5% 25% 37.5% 100% 12,234,473 8,156,315 12,234,473 32,625,260 10,679,727 8,156,315

Fish Passage Program (b)(10) 679,449 2,554,034 861,903 - 399,956 4,495,342 37.5% 25% 37.5% 100% 1,685,753 1,123,836 1,685,753 4,495,342 1,006,304 (1,430,199)

Coleman Fish Hatchery (b)(11) 12,784,171 - 6,890,786 6,207 - 19,681,164 50% 50% 100% 9,840,582 - 9,840,582 19,681,164 (2,943,589) -

Keswick Fish Trap Modification (b)(11) 298,949 - 2,285,871 - - 2,584,820 50% 50% 100% 1,292,410 - 1,292,410 2,584,820 993,461 -

 Keswick Fish Trap Modification (b)(11) - IDC 231,148

Clear Creek Restoration (b)(12) 8,794,037 5,213,503 2,848,540 - - 16,856,080 50% 50% 100% - 8,428,040 8,428,040 16,856,080 (8,794,037) 3,214,537

Spawning Gravel (b)(13) 838,944 1,237,171 - - - 2,076,114 37.5% 25% 37.5% 100% 778,543 519,029 778,543 2,076,114 (60,401) (718,142)

Riparian Habitat (b)(13) 7,552,271 - - - - 7,552,271 37.5% 25% 37.5% 100% 2,832,101 1,888,068 2,832,101 7,552,271 (4,720,169) 1,888,068

Delta Cross Channel (b)(14) - - 749,943 - - 749,943 37.5% 25% 37.5% 100% 281,229 187,486 281,229 749,943 281,229 187,486

South Delta Barrier (b)(15) - - 1,228,169 - - 1,228,169 37.5% 25% 37.5% 100% 460,564 307,042 460,564 1,228,169 460,564 307,042

Comp. Asses. Monit. Program (b)(16) 14,181,393 - - - - 14,181,393 37.5% 25% 37.5% 100% 5,318,022 3,545,348 5,318,022 14,181,393 (8,863,371) 3,545,348

Sacramento River Information Center b(16) - - 498,310 - - 498,310 37.5% 25% 37.5% 100% 186,866 124,577 186,866 498,310 186,866 124,577

Anderson-Cottonwood ID (b)(17) 102,909 - 321,351 - - 424,260 50% 50% 100% - 212,130 212,130 424,260 (102,909) 212,130

GCID - Hamilton City Pump Plant (b)(20) - 6,500,000 37,222,981 - - 43,722,981 25% 75% 100% - 10,930,745 32,792,236 43,722,981 - 4,430,745

Anadromous Fish Screen Program (b)(21) 61,059,594 21,021,582 28,904,188 2,394,708 - 113,380,071 50% 50% 100% 56,690,036 - - 56,690,036 113,380,071 (4,369,558) (21,021,582) 56,690,036

Ag Waterfowl Incentive Program (b)(22) 4,952,313 - - - - 4,952,313 100% 100% 4,952,313 - - 4,952,313 - -

 Subtotal - Projects and Facilities 143,339,188 48,777,104 182,815,591 2,919,671 418,950 378,270,504 139,026,146 63,738,119 118,816,203 56,690,036 378,270,504 (1,523,524) 14,961,015 56,690,036

TOTAL 709,150,745 80,213,579 317,186,172 11,080,689 5,518,038 1,123,149,222 654,573,340 121,057,309 290,828,538 56,690,036 1,123,149,222 (51,526,009) 40,843,730 56,690,036

1/ Water and power contractor payments made into the Restoration Fund are offset against reimbursable activities pursuant to Public Law 102-575.

I:\DATAFILE\WORK\Gail\CVPIA CREDITS & OFFSETS\FY2011\[ECO Report (Repayment 11).xlsx]Sheet1