Laserfiche WebLink
<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 />