August 4, 2016
Bond Oversight Committee 2014 Bond program
1
1 AGENDA Welcome, introductions, meeting schedule Stewart - - PowerPoint PPT Presentation
Bond Oversight Committee 2014 Bond program August 4, 2016 1 AGENDA Welcome, introductions, meeting schedule Stewart Jacobson, Chair Program Management: Oscar Perez & Ron Holleyhead Review Bond Monthly Report Zandra
Bond Oversight Committee 2014 Bond program
1
2
(data from February 2016 Monthly report)
**
*
3
(data from June 2016 Monthly report)
**
*
(data from February 2016 Monthly report)
4
(data from June 2016 Monthly report)
Committed Cost: 28.4% - $137.5M as of 7/11/2016 Cost to Date: 15.8% - $76.3M as of 7/11/2016
$480M $400M $300M $200M $100M
5
6
7
8 2014 BOND PROGRAM CONTINGENCY Date Description Current Budget Proposed Budget Surplus (Shortage) Cumulative 07/18/16 Bond 2014 Interest as of May 2016* $0 $0 $70,235 $0 $70,235 05/16/16 Classrooms Additions-Unallocated funds $10,194,244 $6,906,260 $3,287,984 $0 $3,358,219 05/16/16 Temporary Classrooms Buildings Relocation $433,878 $1,307,749 $0 ($873,871) $2,484,348 05/16/16 ES47-Sullivan Elementary School savings as of May 2016 $42,984,737 $40,484,737 $2,500,000 $0 $4,984,348 05/16/16 Bid Package 05-ES50 $32,702,895 $31,696,470 $1,006,425 $0 $5,990,773 05/16/16 Bid Package 06-ES49 $30,447,522 $33,734,879 $0 ($3,287,357) $2,703,416 05/16/16 Bid Package 07 $15,171,388 $12,561,186 $2,627,278 ($17,076) $5,313,618 05/16/16 Bid Package 09 $12,456,496 $9,344,890 $3,347,281 ($235,675) $8,425,224 05/16/16 Bid Package 02-Paving & Lighting Improvements $3,296,432 $3,296,432 $1,383,482 ($1,383,482) $8,425,224 06/20/16 Bid Package 03-ES48 $30,447,522 $31,393,711 $0 ($946,189) $7,479,035 07/18/16 Bid Package 12 $1,950,330 $2,567,765 $68,625 ($686,060) $6,861,600 07/18/16 Bid Package 13 $1,828,437 $2,247,034 $32,515 ($451,112) $6,443,003 TOTAL AS OF JULY 2016 $181,913,881 $175,541,113 $14,323,825 ($7,880,822) $6,443,003 * Bond 2014 Interest includes $47,335.95 plus additional $22,899.28 of interest reported as per May 31, 2016 reconciliation.
9
10
11
12
13
New Construction Comparison Construction Contingency Other Soft Costs Total Budget $ 126,475,939 $ 8,379,784 $ 19,969,337 $ 154,825,060 Estimate $ 137,306,237 $ 7,749,128 $ 9,769,695 $ 154,825,060 Difference $ (10,830,298) $ 630,656 $ 10,199,642 $ 0 Additions Comparison Construction Contingency Other Soft Costs Total Budget $ 12,824,894 $ 1,247,441 $ 2,146,865 $ 16,219,200 Estimate $ 19,075,744 $ 1,659,479 $ 2,277,965 $ 23,013,188 Difference $ (6,250,850) $ (412,039) $ (131,100) $ (6,793,988) Life Cycle/Deficiency Comparison Construction Contingency Other Soft Costs Total Budget $ 81,132,617 $ 12,698,855 $ 12,581,092 $ 106,412,564 Estimate $ 77,451,648 $ 5,826,664 $ 12,224,224 $ 95,502,536 Difference $ 3,680,969 $ 6,872,191 $ 356,868 $ 10,910,028 Net for New, Additions, Life Cycle/Deficiency $ 4,116,040
14
15
16
$0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,000,000 $45,000,000 931 - Infrastructure Cameras 990 - DSTW - WAN Cabling/Fiber 991 - DSTW - Wireless Cabling/Fiber 992 - DSTW - WAN Design Contingency 993- DSTW Wireless Contingency 994 - DSTW - WAN Network Electronics 995 - DSTW - Wireless Electronics Total 931 - Infrastructure Cameras 990 - DSTW - WAN Cabling/Fiber 991 - DSTW - Wireless Cabling/Fiber 992 - DSTW - WAN Design Contingency 993- DSTW Wireless Contingency 994 - DSTW - WAN Network Electronics 995 - DSTW - Wireless Electronics Total % of Budget 39.5% 19.1% 8.0% 5.8% 4.5% 22.6% 55.7% 33.8% Total Exp & Enc $1,184,438 $675,000 $315,000 $74,250 $74,270 $2,818,911 $9,214,449 $14,356,318 Initial Budget $3,000,000 $3,528,000 $3,955,799 $1,280,124 $1,640,902 $12,473,570 $16,555,452 $42,433,847
Total Exp & Enc Initial Budget
As of April 1, 2016
17 * Middle School schedule are experience a delay due to proper asset tracking and documentation requirements.
18
19
20
21
22
23
24
25
Summary Statistics Principal Composition
Total Outstanding Principal 835,985,328 $ Total Fixed Rate 754,345,328 90.23% Total Variable Rate 81,640,000 9.77% Total Interest Payments 420,248,324 Callable Principal (%) 75.57% Percent of Principal Retired w/in 5 years 25.61% w/in 10 years 56.46% w/in 15 years 85.56% w/in 20 years 97.49% Noncallable 24.43% w/in 25 years 100.00% Callable & Advance Refundable 62.00% Final Maturity 8/1/2040 Callable & Partially Advance Refundable 7.96% Callable & Non-Advance Refundable 5.61%
Summary of Variable Rate Debt Underlying Ratings Voted Authorization
Bond Issue Rate Period Tender Date Interest Rate Stepped Rate Fitch AA+ Amount Issued Balance Series 2015A Term 8/1/2018 0.90% 7.00% S&P AA+ 428,000,000 $ 380,000,000 $ 48,000,000 $ Series 2015B Initial 8/1/2017 2.00% 8.00% 484,000,000 $ 85,000,000 $ 399,000,000 $ 912,000,000 $ 465,000,000 $ 447,000,000 $ 11/4/2014 11/6/2007 Date 24.43% 62.00% 7.96% 5.61%
26
$0 $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 $90,000,000 $100,000,000 Aggregate Debt Service
Principal Interest
Period Ending 8/31
27
Callable Call Call Bond Issue Principal Date Feature Unlimited Tax School Building & Refunding Bonds, Series 2008 159,620,000 $ 8/15/2018 100.000% Adv Refundable Unlimited Tax Refunding Bonds, Series 2009 28,390,000 2/15/2019 0.000% Adv Refundable Unlimited Tax School Building Bonds, Series 2009 166,730,000 8/15/2019 100.000% Adv Refundable Unlimited Tax School Building & Refunding Bonds, Series 2010 66,580,000 8/15/2020 80.032% Adv Refundable Unlimited Tax Refunding Bonds, Series 2012 46,870,000 8/15/2022 0.000% Adv Refundable Unlimited Tax Refunding Bonds, Series 2014 46,145,000 8/15/2024 100.000% Adv Refundable Variable Rate Unlimited Tax School Building Bonds, Series 2015A 33,155,000 AID 100.000% Adv Refundable Variable Rate Unlimited Tax School Building Bonds, Series 2015B 48,485,000 AID 100.000% Adv Refundable Unlimited Tax Refunding Bonds, Series 2016A 35,755,000 8/15/2024 100.000% Adv Refundable
28
$100,000,000 Commercial Cash Paper Program Defeasance Est. Less: Est. Est. Tax Assessed
Existing 8/16 @ 2.00%
Total Other Total Net I&S Year Valuation Growth D/S Principal Interest Total D/S Total D/S Debt D/S Funds D/S Tax Rate Change 2015 31,884,598,081 $ 95,043,057 $
500,000 $
95,543,057 $ (500,000) $ 95,043,057 $ 0.3000 $ 2016 35,455,673,066 11.20% 91,129,288 745,000 298,395 1,043,395 2,000,000 11,125,000 105,297,683
0.3000 (0.0000) 2017 38,114,848,546 7.50% 76,432,953 780,000 291,690 1,071,690 2,000,000
0.2107 (0.0893) 2018 40,020,590,973 5.00% 76,396,578 820,000 2,214,100 3,034,100 1,500,000
0.2043 (0.0064) 2019 42,021,620,522 5.00% 76,353,903 860,000 2,156,700 3,016,700
0.1908 (0.0135) 2020 43,282,269,138 3.00% 76,322,696 905,000 2,096,500 3,001,500
0.1851 (0.0057) 2021 44,580,737,212 3.00% 76,277,078 950,000 2,033,150 2,983,150
0.1796 2022 44,580,737,212 0.00% 76,239,336 1,000,000 1,966,650 2,966,650
0.1795 2023 44,580,737,212 0.00% 75,127,144 1,050,000 1,896,650 2,946,650
0.1769 2024 44,580,737,212 0.00% 77,899,929 1,100,000 1,823,150 2,923,150
0.1831 2025 44,580,737,212 0.00% 73,014,788 1,155,000 1,746,150 2,901,150
0.1720 2026 44,580,737,212 0.00% 71,645,713 1,215,000 1,665,300 2,880,300
0.1689 2027 44,580,737,212 0.00% 66,426,463 1,275,000 1,580,250 2,855,250
0.1570 2028 44,580,737,212 0.00% 62,973,513 1,340,000 1,491,000 2,831,000
0.1491 2029 44,580,737,212 0.00% 62,917,738 1,405,000 1,397,200 2,802,200
0.1489 2030 44,580,737,212 0.00% 32,746,513 1,475,000 1,298,850 2,773,850
0.0805 2031 44,580,737,212 0.00% 32,676,738 1,550,000 1,195,600 2,745,600
0.0803 2032 44,580,737,212 0.00% 32,608,663 1,625,000 1,087,100 2,712,100
0.0800 2033 44,580,737,212 0.00% 32,544,038 1,710,000 973,350 2,683,350
0.0798 2034 44,580,737,212 0.00% 4,046,400 1,795,000 853,650 2,648,650
0.0152 2035 44,580,737,212 0.00% 3,971,800 1,880,000 728,000 2,608,000
0.0149 2036 44,580,737,212 0.00% 3,886,400 1,975,000 596,400 2,571,400
0.0146 2037 44,580,737,212 0.00% 3,800,200 2,075,000 458,150 2,533,150
0.0143 2038 44,580,737,212 0.00% 3,712,400 2,180,000 312,900 2,492,900
0.0141 2039 44,580,737,212 0.00% 3,607,200 2,290,000 160,300 2,450,300
0.0137 1,287,800,523 $ 33,155,000 $ 30,321,185 $ 63,476,185 $ 6,000,000 $ 11,125,000 $ 1,368,401,708 $ (500,000) $ 1,367,901,708 $ (0.1149) $
Assumptions: (1) Assessed valuations and grow th assumptions provided by the District. (2) Actual I&S tax rate for period ending 8/31/2016. (3) Est. tax collections rate: 99.00% (4) Commercial Paper Notes, assumes an all in estimated rate of 2.00% (includes the Liquidity Fee, Dealer Fee, annual rating fees, and annual issuing and paying agent fee), for purposes of illustration only. Preliminary, subject to change. (5) Series 2015A Bonds at 0.66% through 8/1/2016 and at 0.90% through 8/1/2018 and 7.00% thereafter. (6) Series 2015B Bonds at 2.00% through 8/1/2017 and 8.00% thereafter.
Two Year @ 0.90% PRELIMINARY FINAL $33,155,000 Variable Rate Unlimited Tax School Building Bonds Series 2015A (2016 Remarketing)
29
$100,000,000 Commercial Cash Paper Program Defeasance Est. Less: Est. Est. Tax Assessed
Existing 8/16 @ 2.00%
Total Other Total Net I&S Year Valuation Growth D/S Principal Interest Total D/S Total D/S Debt D/S Funds D/S Tax Rate Change 2015 31,884,598,081 $ 95,043,057 $
500,000 $
95,543,057 $ (500,000) $ 95,043,057 $ 0.3000 $ 2016 35,455,673,066 11.20% 91,129,288 745,000 298,395 1,043,395 2,000,000 4,125,000 98,297,683
0.2800 (0.0200) 2017 38,114,848,546 7.50% 76,432,953 780,000 291,690 1,071,690 2,000,000
0.2107 (0.0693) 2018 40,020,590,973 5.00% 76,396,578 820,000 2,214,100 3,034,100 1,500,000
0.2043 (0.0064) 2019 42,021,620,522 5.00% 76,353,903 860,000 2,156,700 3,016,700
0.1908 (0.0135) 2020 43,282,269,138 3.00% 76,322,696 905,000 2,096,500 3,001,500
0.1851 (0.0057) 2021 44,580,737,212 3.00% 76,277,078 950,000 2,033,150 2,983,150
0.1796 2022 44,580,737,212 0.00% 76,239,336 1,000,000 1,966,650 2,966,650
0.1795 2023 44,580,737,212 0.00% 75,127,144 1,050,000 1,896,650 2,946,650
0.1769 2024 44,580,737,212 0.00% 77,899,929 1,100,000 1,823,150 2,923,150
0.1831 2025 44,580,737,212 0.00% 73,014,788 1,155,000 1,746,150 2,901,150
0.1720 2026 44,580,737,212 0.00% 71,645,713 1,215,000 1,665,300 2,880,300
0.1689 2027 44,580,737,212 0.00% 66,426,463 1,275,000 1,580,250 2,855,250
0.1570 2028 44,580,737,212 0.00% 62,973,513 1,340,000 1,491,000 2,831,000
0.1491 2029 44,580,737,212 0.00% 62,917,738 1,405,000 1,397,200 2,802,200
0.1489 2030 44,580,737,212 0.00% 32,746,513 1,475,000 1,298,850 2,773,850
0.0805 2031 44,580,737,212 0.00% 32,676,738 1,550,000 1,195,600 2,745,600
0.0803 2032 44,580,737,212 0.00% 32,608,663 1,625,000 1,087,100 2,712,100
0.0800 2033 44,580,737,212 0.00% 32,544,038 1,710,000 973,350 2,683,350
0.0798 2034 44,580,737,212 0.00% 4,046,400 1,795,000 853,650 2,648,650
0.0152 2035 44,580,737,212 0.00% 3,971,800 1,880,000 728,000 2,608,000
0.0149 2036 44,580,737,212 0.00% 3,886,400 1,975,000 596,400 2,571,400
0.0146 2037 44,580,737,212 0.00% 3,800,200 2,075,000 458,150 2,533,150
0.0143 2038 44,580,737,212 0.00% 3,712,400 2,180,000 312,900 2,492,900
0.0141 2039 44,580,737,212 0.00% 3,607,200 2,290,000 160,300 2,450,300
0.0137 1,287,800,523 $ 33,155,000 $ 30,321,185 $ 63,476,185 $ 6,000,000 $ 4,125,000 $ 1,361,401,708 $ (500,000) $ 1,360,901,708 $ (0.1149) $
Assumptions: (1) Assessed valuations and grow th assumptions provided by the District. (2) Actual I&S tax rate for period ending 8/31/2016. (3) Est. tax collections rate: 99.00% (4) Commercial Paper Notes, assumes an all in estimated rate of 2.00% (includes the Liquidity Fee, Dealer Fee, annual rating fees, and annual issuing and paying agent fee), for purposes of illustration only. Preliminary, subject to change. (5) Series 2015A Bonds at 0.66% through 8/1/2016 and at 0.90% through 8/1/2018 and 7.00% thereafter. (6) Series 2015B Bonds at 2.00% through 8/1/2017 and 8.00% thereafter.
Two Year @ 0.90% FINAL PRELIMINARY $33,155,000 Variable Rate Unlimited Tax School Building Bonds Series 2015A (2016 Remarketing)
Bond Oversight Committee 2014 Bond program
30