WCCUSD 10/23/2016 AVAILABLE FUNDS EXISTING BONDS (FUND 21) DRAFT MASTER PLAN (In Millions of Dollars) Summary i A I 1 Description 6.15.2016 10.19.2016 2 Estimated Funds Available I 3 Revenues I 4 Cash bale?nee 9.30.16 119.8 5 interest Income thru 2021 (estimated)_ 1.7 Available bond sales 2021 6 [excludes Measure .1) 255.0 7 Total Revenues 376.5 8 I 9 Less: Ant?pated?E?xpendituresLj 10 Pinole Valley High School ?1729 1 1 Project costs 20.5 12 Technology cost 10.4 13 Program costs_ 17.9 14 Total Anticipated E?Jenditures 221 .7 15 16 "??11et Revenue grailable 164.7 154.8 17 Estimated Project Costs ?Egan 18 Plan Existing Bonds 19 P?ects commence 203?17 64.1 64.1 20 Projects commence a?er 2016-17 1 17-7 117.7 I 21 _'?Teta1 MEter 1316? Projects 181.8 181.8 10 22 . ??721 - I it? 23 Estimated Available Funds A (17.1) 6 (27.0? ?1 24 AMP 25 26 Notes: I I 27 Ma?ster Plan was app1 oved by the Bo?ard of _Education on June 15, 2016?. 28 The June 15_, 2016 Board agenda packet did not pro?vide any d?etails on computation 164. 7 million .1 29 estimated funds? I I I 30 October 19 Board action ad_justed budgets f?or active projee_ts and established? budgets for master plan 31 projects in 2016?17. I I I I I pane/{7 C:\Users\Anton\Documents\0000 CBOC 2.11.15\Available Funds, Existing Bonds 10.22.16 - aj.xlsx Page 1 of 13 WCCUSD AVAILABLE FUNDS EXISTING BONDS (FUND 21) MASTER PLAN MLEMENTATION 10/23/2016 4:11 PM (111 Millions of Dollars} Master Plan Projects A I . 10.19.2016 6.15.2016 10.19.2016 Start After 1 Description All Projects Start FY2017 FY2017 Estimated Project Costs Master 2 Plan Existing Bonds 3 4 Education speci?cations school size 0.2 0.2 0 5 Harmon Knolls soils testing 0.1 0.1 0 6 Valley View ES 1.0 1.0 0 7 Crespi MS 3.1 3.1 0 8 Riverside ES 6.9 0 6.9 9 Richmond HS 15.1 15.1 0 10 Kennedy HS 12.2 0 12.2 11 Highland ES 0.8 0.8 12 Grant ES 0.9 0.9 13 Olinda ES 1.0 1.0 0 14 Chavez ES 0.6 0.6 0 15 Ohlone ES 0.3 0.3 0 16 Harmon Knolls 0.2 0.2 0 17 Fairmont ES 3.0 0 3.0 18 Stege ES 2.9 0 2.9 19 Cameron School 1.3 0 1-3 20 Hercules MSD 7.5 7.5 21 Hercules HS 7.2 0 7.2 22 Collins ES 3.5 0 3.5 23 Shannon ES 7.1 0 7.1 7 24 Wilson ES replacement 40.3 "40.3 0 25 Lake ES replacement 66.1 0 66.1 26 Total Master Plan 181.8 64.1 117.7 27 28 Master Plan Projects on Board Action 63.9 29 Is education speci?cations school size missing? 0.2 30 1 i 31 Notes: . 32 Master Plan was approved by the Board of Education on June 15, 2016. 33 October 19, Board action adjusted budgets for active projects and established budgets for master plan 34 projects commencing in 2016-17. I 1 I 1 7m hf? C:\Users\Anton\Documents\0000 CBOC 2.1 1.15\Available Funds, Existing Bonds 10.22.16 aj.xlsx Page 3 of 13 WCCUSD Bond Program - inventory of Schools School Name City New School Modernized Modernized Unimproyed Level Comments Korematsu Middle El Cerrito New School Middle subsidized by nearly 30% with matching State seismic funds El Cerrito High El Cerrito New School High Includes full new soccer track and ?eld facility from State modernlzatloni Ohlone E5 Hercules New School Elementary Hanna Ranch ES Hercules New School Elementary State paid for reconstruction (sm amt for play structures pd by Band prog) Hercules Middle High Hercules New School Middle State paid for reconstruction ism amt for minor upgrades pd by Bond prog) Lupine Hills ES Hercules New School Elementary Pinole Valley High Pinole New School High Construction ongoing Pinole Middle High Pinole New School Middle Includes full new track and field facility DeAnza High Pinole New School High 10 Coronado ES Richmond New School Elementary 11 Downer ES Richmond New School Elementary 12 Ford ES Richmond New School Elementary 13 King ES Richmond New School Elementary 14 ES Richmond New School Elementary 15 Greenwaod Alternative HS Richmond New School High 16 Leadership High Richmond New School High Charter 17 DeJean Middle Richmond New School Middle 18 Chavez E5 Richmond New School Elementary State paid for reconstruction ism amt for new siding painting pd by Bond progi 19 Vista ES Richmond New School Elementary 20 Helms Middle San Pablo New School Middle Includes full new track and field facility 21 Dover ES San Pablo New School Elementary 22 Harding ES El Cerrito Modernized+ Elementary 23 Madera ES El Cerrito Modernlzed+ Elementary 24 Crespi Middle El Sobrante Modernized+ All Paid by Insurance comp b/c Fire caused need for replacement Ln 2 Kensington ES Modernized+ Elementary 26 Eilerhorst ES Plnole Modernlzed+ Elementary 27 Stewart K-B Plnole Modernized+ K-S 23 Washington ES Richmond Modernized-i- Elementary 29 Lincoln ES Richmond Modernized+ Elementary 30 Montalvin ES Richmond Modernized+ Elementary 31 Murphy E5 Richmond Modernized+ Elementary 32 Sheldon ES Richmond Modernized+ Elementary 33 Peres ES Richmond Modernized+ Elementary 34 Bayyiew ES San Pablo Modernized+ Elementary 35 Riverside ES San Pablo Modernized+ Elementary 36 Tara Hills ES Unincorp Modernized+ Elem entary 37 Verde ES Unlncorp Modernized+ Elementary 38 Portola Middle El Cerrito Demolished 8: Cleared n/a 39 Sea View ES Unincorp Demolished Cleared n/a 40 Richmond High Richmond Modernlzed High Gating and fencing, new track and field 41 Richmond College Prep ES Richmond Modernized Elementary Charter 42 Kennedy High School Richmond Modernlzed High Includes swim center, track and field facility 43 Mira Vista K-8 ni ncorp Modernized K-S 44 Valley View ES Richmond Temp Campus Elementary Moved in 2016 to portables, waiting for demo 45 Portable Campus El Cerrlto Temp Campus as needed any 46 Fairmont ES El Cerrito unimproved Elementary 7o: ao/7 Page 1 of 2 WCCUSD Bond Program - inventory of Schools School Name City New School Modernized Modernized Unimproved Level Comments 47 Cameron Special Needs El Cerrlto unimproved n/a 48 Collins ES Plnole unimproved Elementary 49 Shannon ES Pinole unimproved Elementary 50 Highland ES Richmond unimproved Elementary 51 Grant ES Richmond unimproved Elementary 52 Ollnda ES Richmond Elementary 53 Stage ES unimproved Elementary 54 Wllson ES Richmond unimproved Elementary 55 Lake ES San Pablo unimproved Elementary "Modernized+" means all portables replaced with new constructior 7149?? 7 Page 2 of 2 West Contra Costa Unified School District Bond Program Spending to Date by School Site June 30, 2018 Report 2 Staff Reports Page 36 of 64 Bayview 17,732,392 18,926,097 19,850,802 0 (924,705) Chavez 1,339,784 1,221,609 994,003 0 227,605 Collins 993,294 1 ,827, 950 1 835,735 0 (207,785) Coronado 11,278,047 42,778,309 42,024,938 161,898 591,673 Dover 13,070,243 33,891,743 35,184,280 18,815 (1,311,352) Downer 28,819,079 33,350,762 33,837,618 0 (286,854) Ellerhorst 11,238,341 12,909,131 14,134,299 0 (1,225,188) Fairmont 10,971,358 35,246,948 4,069,755 0 31,177,191 Ford 11,839,322 31,642,900 30,898,634 0 746,266? Grant 1,409,800 1,888,360 1,950,813 413 (82,887) Hanna Ranch 680,923 1,063,812 1,054,745 0 9,087 Harding? 15,574,211 22,819,188 22,841,387 0 (222,199)? Highland 13,504,714 54,897,831 1,890,679 0 53,007,152 Kensington 16,397,920 19,056,884 19,625,816 0 (568,752) King 16,688,732 25,309,778 25,301,717 141,557 (133,496) Lake 822,857 1,845,712 1,518,179 0 127,533 Lincoln 15,225,821 17,314,352 17,682,529 3,514 (371,691) Lupine Hills .. 16,111,242 . 15,982,926 15,685,249 0 297,878 Madera 11,088,784 12,524,010 12,407,506 0 116,504 Mira Vista 13,928,384 18,879,022 16,850,139 0 28,883 Montalvin 15,904,716 16,975,148 16,791,028 418 183,704 Murphy 13,554,495 15,842,288 15,849,565 0 (207,277) 20,999,690 49,486,844 39,101,117 4,581,827 5,803,899 phlone 14,174,928 34,559,048 34,146,392 443,539 (30,885) Olinda 1,170,598 1,474,049 1,457,950 0 18,099 Peres 19,752,789 22,443,686 21,708,954 2,009 734,723 Riverside 13,439,831 14,839,144 14,611,005 0 228,139 Shannon 1,157,738 1,380,741 1,726,991 0 (346,250) Sheldon 14,988,745 15,291,352 15,330,366 0 (39,014) Stege 13,000,749 31,792,284 3,373,588 25,283 28,393,416 Stewart 12,710,427 18,724,195 16,948,287 0 (224,072) Tara Hills 14,160,935 15,189,442 15,212,814 0 (23,173) Valley View 11,117,405 35,394,192 8,987,487 213,546 28,193,179 Verde 15,709,890 16,231,040 16,293,189 2.. 0 (62,149) Washington 14,051,720 15,478,771 15,322,847 0 155,924 Wiison 13,673,885 50,299,584 3,840,331 76,697 46,382,558 Elementary Schools Total 438,283,142 753,979,107 560,138,291 5,889,313 188,173,503 Middle Schools Crespi MS 1,205,711 1,134,024 1,604,197 588,596 (1,056,770) Dejean MS 64,929 479,697 727,643 0 (247,948) Helms MS 81,287,986 88,824,934 83,601,212 28,918 4,993,904 Hercules MS 602, 982 515,228 699,000 0 (183,774) Korematsu MS 37,937,901 70,781,527 89,853,425 1,217,497 (289,394) Pinole MS 38,828,979 53,589,172 56,832,351 20,073 (3,283,252) Middle Schools Total 139,928,488 215,103,880 213,317,829 1,853,084 (87,232Meeting Packet Page 105 of 134 June 30, 2016 West Contra Costa Uni?ed School District Bond Program Spending to Date by School Site Report 2 High Schools De Anza HS 105,389,888 131,730,043 132,007,640 457,860 (735,457) El Cern'to HS 93,605,815 149,047,560 144,429,810 252,451 4,355,299 Greenwood Academy I LPS 35,315,772 80,181,895 79,410,138 363,790 407,968 Hercules HS 12,603,343 30,403,028 4,068,686 18,000 26,316,342 Kennedy HS 89,403,130 38,395,795 34,408,975 687,942 3,298,878 Mid College HS 0 0 ,0 27,333 0 (27,333) Pinole Valley HS 124,040,286 216,549,580 38,466,677 137,045,951 41,036,952 Richmond HS 94,720,910 58,523,927 20,530,283 2,368,815 35,624,829 Vista HS 3,566,208 6,701,320 7,481,165 0 (779,845) High Schools Total 558,645,352 711,533,148 460,830,709 141,194,808 109,507,632 Closed Adams MS 703,660 690,082 691,211 0 (1,129) Cameron 284,012 284,012 242,138 0 41,874 up Castro 11,901,504 651,957 620,944 0 31,013 Delta NSS 152,564 152,564 152,226 0 338 El Sobrante 187,343 505,382 536,231 0 (30,849) Harbour Way Com Day 121,639 121,639 121,944 0 (305) Kappa NSS 109,809 109,809 109,831 0 (22) North Campus 169,849 201,662 492,569 0 (290,907) 117,742 .., 118,638 118,313 0 325 Seaview 178,534 510,649 499,1 16 0 1 1,533 Sigma NSS 110,728 110,728 110,949 0 (221) Trans Learning Center 118,020 ?118,020 116,673 0 1,347 West Hercules Elementary 0 216,685 56,847 0 159,838 Closed Total 14,155,404 3,791,827 3,868,993 0 (77,166) AdministrationiOther Central 67,713,312 69,924,746 85,244,563 1 ,483,418 (16,803,235) Information Technoiogy 35,000,000 34,770,000 12,137,467 214,061 22,418,472 Alvarado Adult Ed 0 0 167, 323 0 (167,323) Richmond College Prep 8,148,550 4,663,306 4,415,204 0 248,104 Serra Adult Ed 0 0 204,212 0 (204,212) AdministrationIOther Total 1 10,861,862 109,358,054 102,168,769 1 597,479 5,491,807 Grand Total 1,261,854,248 1,793,765,815 1,340,322,589 150,414,683 303,028,543 71712016 2 of 2 Staff Reports Page 37 of 64 7412517 Meeting Packet Page 106 of 134 7440 747 Table 1 - Bonds Authorized Bond information (Key Performance Indicators) for WCCUSD Bond Program BOND PROGRAM KPI SUMMARY as of Semptember 30, 2016 4. Report 1 Voter Approved Bonds issued Bond Payments Bond Mon Measures th Year WT Amount Latest issue Total Issued Tax Rate per $100k 4 Not Yet Scheduled Issued Issues 5 Principal Paid Finish Date Interest Paid 7 Msr1998-E Jun 1998 40,000,000 Jan 2001 40,000,000 $8.70 0 0 21,595,000 A092025 26,392,111 2 2000-M Nov 2000 150,000,000 Apr 2003 150,000,000 $55.60 0 0 77,650,000 Aug 2032 80,858,888 3 2002-0 Mar 2002 300,000,000 Oct 2005 299,997,483 $60.00 2,517 0 78,268,573 Aug 2034 102,198,372 3 2005-J Nov 2005 400,000,000 Jun 2010 322,409,709 $60.00 77,590,292 0 10,728,674 Aug 2036 128,596,173 3 2010-D Jun 2010 380,000,000 Mar 2016 250,000,000 $48.00 130,000,000 130,000,000 28,215,000 Aug 2045 31,556,341 3 2012-E Nov 2012 Mar 2016 235,000,000 $48.00 125,000,000 125,000, 000 24,000,000 Aug 2045 16,972,539 Grand Totals 1,630,000,000 ?h ,297,407,191 $280.30 332,592,809 255,000,000 240,457,247 386,574,424 Table 2 Funds From Other Sources Source Prior 2017 Total 3 School Facilities 141,777,571 141,777,571 7 Developer Fees 24,900,038 24,900,038 ?5 Interest Earnings 39,916,648 39,916,648 9 Net Transfers (3,920,753) (3,920,753) 1? Other Revenue 12,909,269 12,909,269 ?1 Fund Adjustments 948,394 948,394 Total Other Revenue 216,531,168 216,531,168 Table 4 Avera Spending 3 Months 6 Months 12 Months 2,509,239 4,703,628 4,755,141 10/6/2016 1of5 Table 3 Program Summary- Revenues Actuals to Date 12 Bonds lssued 1,297,407,191 1 less: 1998E (40,000,000) 13 Other Revenue 216,531,168 Program Revenue 1,475,938,359 1? Audit Adjustment (2,403,614) ?5 School KPI Actuals (1,352,120,565) 16 Net Retentions 338,039 Cash on Hand 17 119,752,220 do