|
<br />::ity of San Leandro I
<br />_ibrary & Fire Stations Financing
<br />~efunding Analysis
<br />I I
<br />:::alculation of Net Present Value Savings
<br />Jated Date: 615/07
<br /> Refunded Bonds
<br /> Refunding
<br /> Gross Bonds 4.133412%
<br /> Semi-Annual Semi-Annual (1)-(2) Bond Yield Annual
<br />Date Principal Interest Debt Service Debt Service Difference PV 6/5/2007 Savill9..s
<br />5/1/2007
<br />11/1/2007 $ 545,000.00 $ 659,575.00 $ 1,204.575.00 $ 1,105,964.16 $ 98,610.84 $ 96,988.15 146 $ 98,610.84
<br />5/1/2008 $ - $ 646,90375 $ 646,903.75 $ 482,35438 $ 164,549 37 $ 158,56456 326
<br />11/1/2008 $ 570,000.00 $ 646,903.75 $ 1,216,903.75 $ 1,227,35438 $ (10,45063) $ (9,86662) 506 $ 154,098.74
<br />5/1/2009 $ $ 633,36625 $ 633,36625 $ 469,689.38 $ 163,676.87 $ 151,40110 686
<br />11/1/2009 $ 600,000'.00 $ 633,366.25 $ 1,233,36625 $ 1,244,68938 $ (11,323.13) $ (10,261.81) 866 $ 152,35374
<br />5/1/2010 $ - $ 618,816.25 $ 618,816.25 $ 456,514.38 $ 162,301.87 $ 144,110.97 1046
<br />11/1/2010 $ 625,00000 $ 618,816.25 $ 1,243,816.25 $ 1,256,514.38 $ (12,698.13) $ (11,046.61 ) 1226 $ 149,603.74
<br />5/1/2011 $ - $ 603,347.50 $ 603,347.50 $ 442,914.38 $ 160,433.12 $ 136,741.19 1406
<br />11/1/2011 $ 660,00000 $ 603,34750 $ 1,263,347.50 $ 1,272,914.38 $ (9,566.88) $ (7,98898) 1586 $ 150,866.24
<br />5/1/2012 $ - $ 586,51750 $ 586,517.50 $ 428,389.38 $ 158,128.12 $ 129,373.77 1766
<br />11/1/2012 $ 690,00000 $ 586,517.50 $ 1,276,517.50 $ 1,283,389.38 $ (6,87188) $ (5,508.44) 1946 $ 151,256.24
<br />5/1/2013 $ 568,405 00 $ 568,40500 $ 413,426.88 $ 154,978.12 $ 121,713.65 2126
<br />11/1/2013 $ 730,000.00 $ 568,405 00 $ 1,298,405.00 $ 1,303,42688 $ (5,021.88) $ (3,864.12) 2306 $ 149,95624
<br />5/1/2014 $ 548,87750 $ 548,877.50 $ 397,851.88 $ 151,025.62 $ 113,854.80 2486
<br />11/1/2014 $ 765,000.00 $ 548,877.50 $ 1,313,877.50 $ 1,312,851.88 $ 1,025.62 $ 757.54 2666 $ 152,051.24
<br />5/1/2015 $ 528,03125 $ 528,031.25 $ 381,839.38 $ 146,191.87 $ 105,792.71 2846
<br />11/1/2015 $ 810,000.00 $ 528,031.25 $ 1,338,03125 $ 1,331,839.38 $ 6,191.87 $ 4,39006 3026 $ 152,383.74
<br />5/1/2016 $ 504,946.25 $ 504,946.25 $ 364,73938 $ 140,206.87 $ 97,394.32 3206
<br />11/1/2016 $ 855,000.00 $ 504,946.25 $ 1,359,94625 $ 1,349,739.38 $ 10,206.87 $ 6,946.61 3386 $ 150,413.74
<br />5/1/2017 $ 480,578.75 $ 480,578.75 $ 346,516 88 $ 134,061.87 $ 89,392.56 3566
<br />11/1/2017 $ 905,000.00 $ 480,578.75 $ 1,385,578.75 $ 1,366,516.88 $ 19,06187 $ 12,453.10 3746 $ 153,123.74
<br />5/1/2018 $ 454,78625 $ 454,78625 $ 327,391.88 $ 127,394.37 $ 81,541.40 3926
<br />11/1/2018 $ 955,000.00 $ 454,786.25 $ 1,409,78625 $ 1,387,391.88 $ 22,394.37 $ 14,043.74 4106 $ 149,78874
<br />5/1/2019 $ 427,568.75 $ 427,568.75 $ 307,251.88 $ 120,316.87 $ 73,924.13 4286
<br />11/1/2019 $ 1,010,000.00 $ 427,56875 $ 1,437,568.75 $ 1,407,251.88 $ 30,316.87 $ 18,249.88 4466 $ 150,633.74
<br />5/1/2020 $ 398,783,75 $ 398,78375 $ 285,93938 $ 112,84437 $ 66,55358 4646
<br />11/1/2020 $ 1,065,000 00 $ 398,78375 $ 1,463,783.75 $ 1,425,939.38 $ 37,844.37 $ 21,867.98 4826 $ 150,688.74
<br />5/1/2021 $ 368,431.25 $ 368,43125 $ 263,709.38 $ 104,72187 $ 59,287.17 5006
<br />11/1/2021 $ 1,125,000.00 $ 368,431.25 $ 1,493,431.25 $ 1,443,709.38 $ 49,721.87 $ 27,579.52 5186 $ 154,443.74
<br />5/112022 $ 336,087.50 $ 336,087.50 $ 240,109.38 $ 95,978.12 $ 52,158.77 5366
<br />11/1/2022 $ 1,190,000.00 $ 336,08750 $ 1,526,0.87.50 $ 1,470,10938 $ 55,978.12 $ 29,805.01 5546 $ 151,956.24
<br />5/1/2023 $ 301,875.00 $ 301,875.00 $ 215,509.38 $ 86,365.62 $ 45,053.43 5726
<br />11/1/2023 $ 1,260.00000 $ 301,875.00 $ 1,561,875.00 $ 1,495,509.38 $ 66,365.62 $ 33,919.23 5906 $ 152,731.24
<br />5/1/2024 $ 265,650.00 $ 265,65000 $ 189,269.38 $ 76,380.62 $ 38,247.40 6086
<br />11/1/2024 $ 1,335,000.00 $ 265.650.00 $ 1,600,650.00 $ 1,524.269 38 $ 76,380.62 $ 37,47294 6266 $ 152,761.24
<br />5/1/2025 $ 227.268.75 $ 227,268.75 $ 161,735.00 $ 65,533.75 $ 31,50036 6446
<br />11/1/2025 $ 1,410,000.00 $ 227,268.75 $ 1,637,268.75 $ 1,551,735.00 $ 85,533 75 $ 40,281.34 6626 $ 151,067.50
<br />5/1/2026 $ 186,731.25 $ 186,73125 $ 132,545.00 $ 54,186.25 $ 25,001.81 6806
<br />11/1/2026 $ 1,490,000.00 $ 186731.25 $ 1,676,731.25 $ 1,577,545.00 $ 99,186.25 $ 44,838.36 6986 $ 153,37250
<br />5/1/2027 $ 143,893.75 $ 143,89375 $ 102,200.00 $ 41,693.75 $ 18,466.52 7166
<br />11/1/2027 $ 1,575,00000 $ 143,893.75 $ 1,718,893.75 $ 1,607,20000 $ 111,693.75 $ 48,468.42 7346 $ 153,387.50
<br />5/1/2028 $ 98,612.50 $ 98,612.50 $ 70,21875 $ 28,393.75 $ 12,071.71 7526
<br />11/1/2028 $ 1,665,000.00 $ 98,61250 $ 1,763,612.50 $ 1,640,218.75 $ 123,393.75 $ 51,399.04 7706 $ 151,787.50
<br />5/1/2029 $ 50,743.75 $ 50,743.75 $ 35,875.00 $ 14,868.75 $ 6,068.09 7886
<br />11/1/2029 $ 1,765,000.00 $ 50,743.75 $ 1,815,743.75 $ 1,675,875.00 $ 139,868.75 $ 55,926.07 8066 $ 154,737.50
<br /> $ 23,600,000.00 $ 18,620,02000 $ 42,220,020.00 $ 38,777,945.58 $ 3,442,074.42 $ 2,255,064.39 $ 3,442,074.42
<br /> Less Reduction in Reserve Funds $ 149,956.24
<br /> (Net) Net Present Value SavinQs $ 2,105,108.15
<br /> NPV SavinQs as a % of O/S Bonds 8.92%
<br />
|