|
<br />Cllv of San Leandro I
<br />L1brarv & Fire Stations Flnanclnll
<br />Refunding Analysis I
<br />I I
<br />Calculation of Net Present Value Savings
<br />Dated Date: 6/5/07
<br /> Refunded Bonds
<br /> Refunding
<br /> Gross Bonds 4.133412%
<br /> SemI.Annual SemJ-Annual (1H2) Bond Yield Annual
<br />Date Pr~ !nttrnt fY: 615/2007 Savlnlls
<br />5/1/2007
<br />11/1/2007 $ 545,000.00 $ 659,575.00 $ 1,204,575.00 $ 1,033998.77 $ 170,576.23 $ 167,769.31 146 $ 170,576.23
<br />5/1/2008 $ - $ 646,903.75 $ 646,903.75 $ 449,874.38 $ 197,029.37 $ 189,863.24 326
<br />11/1/2008 $ 570,000.00 $ 646,903.75 $ 1,216,903.75 $ 1,144,874.38 $ 72,029.37 $ 68,004.15 506 $ 269,058.74
<br />5/1/2009 $ - $ 633,366.25 $ 633,366.25 $ 438,059.38 $ 195,306.87 $ 180,658.85 686
<br />11/1/2009 $ 600,000.00 $ 633,366.25 $ 1,233,366.25 $ 1,163,059.38 $ 70,306.87 $ 63,717.01 866 $ 265,613.74
<br />5/1/2010 $ - $ 618,816.25 $ 618,816.25 $ 425,734.38 $ 193,081.87 $ 171,441.12 1046
<br />11/1/2010 $ 625,000.00 $ 618,816.25 $ 1,243,816.25 $ 1,170,734.38 $ 73,081.87 $ 63,576.86 1226 $ 266,163.74
<br />5/1/2011 $ - $ 603,347.50 $ 603,347.50 $ 413,069.38 $ 190,278.12 $ 162,178.83 1406
<br />11/1/2011 $ 660,000.00 $ 603,347.50 $ 1,263,347.50 $ 1,188,069.38 $ 75,278.12 $ 62,862.26 1586 $ 265,556.24
<br />5/1/2012 $ - $ 586,517.50 $ 586,517.50 $ 399,506.88 $ 187,010.62 $ 153,004.21 1766
<br />11/1/2012 $ 690,000.00 $ 586,517.50 $ 1,276,517.50 $ 1,194,506.88 $ 82,010.62 $ 65,739.00 1946 $ 269,021.24
<br />5/1/2013 $ 568,405.00 $ 568,405.00 $ 385,594.38 $ 182,810.62 $ 143,572.19 2126
<br />11/1/2013 $ 730,000.00 $ 568,405.00 $ 1,298,405.00 $ 1,215,594.38 $ 82,810.62 $ 63,719.28 2306 $ 265,621.24
<br />5/1/2014 $ 548,877.50 $ 548,877.50 $ 371,069.38 $ 177,808.12 $ 134,045.52 2486
<br />11/1/2014 $ 765,000.00 $ 648,877.50 $ 1,313,877.50 $ 1,226,069.38 $ 87,808.12 $ 64,856.17 2666 $ 265,616.24
<br />5/1/2015 $ 528031.25 $ 528,031.25 $ 356,106.88 $ 171,924.37 $ 124414.20 2846
<br />11/1/2015 $ 810,000.00 $ 528,031.25 $ 1,338,031.25 $ 1,241,106.88 $ 96,924.37 $ 68,719.72 3026 $ 268,848.74
<br />5/1/2016 $ 504,946.25 $ 504,946.25 $ 340,176.88 $ 164,769.37 $ 114,456.59 3206
<br />11/1/2016 $ 855000.00 $ 504,946.25 $ 1,359,946.25 $ 1,255,176.88 $ 104,769.37 $ 71,304.11 3386 $ 269,538.74
<br />5/1/2017 $ 480,578.75 $ 480,578.75 $ 323,249.38 $ 157,329.37 $ 104,907.35 3566
<br />11/1/2017 $ 905,000.00 $ 480,578.75 $ 1,385,578.75 $ 1,273,249.38 $ 112,329.37 $ 73,384.67 3746 $ 269,658.74
<br />5/1/2018 $ 454,786.25 $ 454 786.25 $ 305,436.88 $ 149,349.37 $ 95,594.15 3926
<br />11/1/2018 $ 955,000.00 $ 454,786.25 $ 1,409,786.25 $ 1,290,436.88 $ 119,349.37 $ 74,845.20 4106 $ 268,698.74
<br />5/1/2019 $ 427,568.75 $ 427,568.75 $ 286,721.88 $ 140,846.87 $ 86,538.01 4286
<br />11/1/2019 $ 1,010,000.00 $ 427,568.75 $ 1,437,568.75 $ 1,311,721.88 $ 125,846.87 $ 75,756.18 4466 $ 266,693.74
<br />5/112020 $ 398,783.75 $ 398,783.75 $ 266,862.50 $ 131,921.25 $ 77,804.78 4646
<br />11/1/2020 $ 1,065,000.00 $ 398,783.75 $ 1,463,783.75 $ 1,326,862.50 $ 136,921.25 $ 79,118.54 4826 $ 268,842.50
<br />5/1/2021 $ 368,431.25 $ 368,431.25 $ 246,192.50 $ 122,238.75 $ 69,204.16 5006
<br />11/1/2021 $ 1,125,000.00 $ 368,431.25 $ 1,493431.25 $ 1,351,192.50 $ 142,238.75 $ 78,896.39 5186 $ 264,477.50
<br />5/1/2022 $ 336,087.50 $ 336,087.50 $ 224,092.50 $ 111,995.00 $ 60,863.06 5366
<br />11/1/2022 $ 1,190,000.00 $ 336,087.50 $ 1,526,087.50 $ 1,374,092.50 $ 151,995.00 $ 80,928.28 5546 $ 263,990.00
<br />5/1/2023 $ 301,875.00 $ 301,875.00 $ 201,092.50 $ 100,782.50 $ 52,574.12 5726
<br />11/1/2023 $ 1,260,000.00 $ 301,875.00 $ 1,561,875.00 $ 1,396,092.50 $ 165,782.50 $ 84,730.84 5906 $ 266,565.00
<br />5/1/2024 $ 265,650.00 $ 265,650.00 $ 176,595.00 $ 89,055.00 $ 44,594.06 6086
<br />11/1/2024 $ 1,335,000.00 $ 265,650.00 $ 1,600,650.00 $ 1,421,595.00 $ 179,055.00 $ 87,845.82 6266 $ 268,110.00
<br />5/1/2025 $ 227,268.75 $ 227,268-75 $ 150,916.88 $ 76,351.87 $ 36,700.35 6446
<br />11/1/2025 $ 1,410,000.00 $ 227,268.75 $ 1,637,268.75 $ 1,445,916.88 $ 191,351.87 $ 90,115.43 6626 $ 267,703.74
<br />5/1/2026 $ 186,731.25 $ 186,731.25 $ 123,721.88 $ 63,009.37 $ 29,072.84 6806
<br />11/1/2026 $ 1,490,000.00 $ 186,731.25 $ 1,676,731.25 $ 1,473,721.88 $ 203,009.37 $ 91,772.87 6986 $ 266,018.74
<br />5/1/2027 $ 143,893.75 $ 143,893.75 $ 95,371.88 $ 48,521.87 $ 21,490.75 7166
<br />11/1/2027 $ 1,575,000.00 $ 143893.75 $ 1,718,893.75 $ 1,500,371.88 $ 218,521.87 $ 94,825.46 7346 $ 267,043.74
<br />5/112028 $ 98,612.50 $ 98,612.50 $ 65,515.63 $ 33,096.87 $ 14,071.26 7526
<br />11/1/2028 $ 1,665,000.00 $ 98,612.50 $ 1,763,612.50 $ 1,530,515.63 $ 233,096.87 $ 97,095.31 7706 $ 266,193.74
<br />5/1/2029 $ 50,743.75 $ 50,743.75 $ 33,468.75 $ 17,275.00 $ 7,050.11 7886
<br />11/1/2029 $ 1,765,000.00 $ 50,743.75 $ 1,815,743.75 $ 1,563,468.75 $ 252,275.00 $ 100,871.35 8066 $ 269,550.00
<br /> $ 23,600,000.00 $ 18,620,020.00 $ 42220,020.00 $ 36,170,858.93 $ 6,049,161.07 $ 3,944,553.97 $ 6,049,161.07
<br /> Less Reductlon in Reserve Funds $ 1,866,810.00
<br /> Netl Net Present Value SavlOlls $ 2,077,743.97
<br /> NPV Savings as a % of O/S Bonds 8.80%
<br />
|