|
City of Redwood City 8.3.C. - Page 9
<br /> Redwood City Public Financing Authority
<br /> Water Revenue Refunding Bonds,Series 2017
<br /> Savings Report
<br /> Bond Net Debt Prior Bonds Bond
<br /> Payment Date Principal Coupon Interest Period Total Year Total Service Debt Service Year Savings
<br /> 2/1/17 - - - - 686,400.00 686,400.00
<br /> 8/1/17 237,925.00 237,925.00
<br /> 2/1/18 365,000 3.000% 237,925.00 602,925.00 840,850.00 840,850.00 948,675.00 107,825.00
<br /> 8/1/18 232,450.00 232,450.00
<br /> 2/1/19 380,000 4.000% 232,450.00 612,450.00 844,900.00 844,900.00 945,875.00 100,975.00
<br /> 8/1/19 224,850.00 224,850.00
<br /> 2/1/20 395,000 4.000% 224,850.00 619,850.00 844,700.00 844,700.00 947,475.00 102,775.00
<br /> 8/1/20 216,950.00 216,950.00
<br /> 2/1/21 410,000 4.000% 216,950.00 626,950.00 843,900.00 843,900.00 947,675.00 103,775.00
<br /> 8/1/21 208,750.00 208,750.00
<br /> 2/1/22 425,000 5.000% 208,750.00 633,750.00 842,500.00 842,500.00 947,050.00 104,550.00
<br /> 8/1/22 198,125.00 198,125.00
<br /> 2/1/23 445,000 5.000% 198,125.00 643,125.00 841,250.00 841,250.00 949,950.00 108,700.00
<br /> 8/1/23 187,000.00 187,000.00
<br /> 2/1/24 470,000 5.000% 187,000.00 657,000.00 844,000.00 844,000.00 946,787.50 102,787.50
<br /> 8/1/24 175,250.00 175,250.00
<br /> 2/1/25 495,000 5.000% 175,250.00 670,250.00 845,500.00 845,500.00 947,775.00 102,275.00
<br /> 8/1/25 162,875.00 162,875.00
<br /> 2/1/26 515,000 5.000% 162,875.00 677,875.00 840,750.00 840,750.00 947,700.00 106,950.00
<br /> 8/1/26 150,000.00 150,000.00
<br /> 2/1/27 545,000 5.000% 150,000.00 695,000.00 845,000.00 845,000.00 950,793.75 105,793.75
<br /> 8/1/27 136,375.00 136,375.00
<br /> 2/1/28 570,000 5.000% 136,375.00 706,375.00 842,750.00 842,750.00 947,575.00 104,825.00
<br /> 8/1/28 122,125.00 122,125.00
<br /> 2/1/29 600,000 5.000% 122,125.00 722,125.00 844,250.00 844,250.00 948,262.50 104,012.50
<br /> 8/1/29 107,125.00 107,125.00
<br /> 2/1/30 630,000 5.000% 107,125.00 737,125.00 844,250.00 844,250.00 947,637.50 103,387.50
<br /> 8/1/30 91,375.00 91,375.00
<br /> 2/1/31 660,000 5.000% 91,375.00 751,375.00 842,750.00 842,750.00 950,700.00 107,950.00
<br /> 8/1/31 74,875.00 74,875.00
<br /> 2/1/32 695,000 5.000% 74,875.00 769,875.00 844,750.00 844,750.00 947,231.25 102,481.25
<br /> 8/1/32 57,500.00 57,500.00
<br /> 2/1/33 730,000 5.000% 57,500.00 787,500.00 845,000.00 845,000.00 947,450.00 102,450.00
<br /> 8/1/33 39,250.00 39,250.00
<br /> 2/1/34 765,000 5.000% 39,250.00 804,250.00 843,500.00 843,500.00 950,100.00 106,600.00
<br /> 8/1/34 20,125.00 20,125.00
<br /> 2/1/35 805,000 5.000% 20,125.00 825,125.00 845,250.00 845,250.00 950,950.00 105,700.00
<br /> Total 9,900,000 5,285,850.00 15,185,850.00 15,185,850.00 15,185,850.00 17,756,062.50 2,570,212.50
<br /> NIC 2.55856% using 119.66%
<br /> TIC 2.76625% using 119.66%
<br /> Bond Yield 1.72149% using 120.66%
<br /> All-In TIC 2.97726% using 117.53%
<br /> Average Rate 4.04931%
<br /> Average Life 10.7657 years
<br /> 8086 Av.Life 10.9282 years
<br /> Dated 2/1/17
<br /> Delivery 2/1/17
<br /> Gross Savings 2,570,212.50
<br /> Gross NPV Savings 2,152,775.63
<br /> Less DSRF Contribution -
<br /> Less City Contribution (686,400.00)
<br /> Plus New DSRF -
<br /> Adjusted Gross NPV Savings 1,466,375.63 = 14.81% of Refunding Bonds at Bond TIC
<br /> Prepared by William Euphrat Municipal Finance,Inc.,9/27/16 Page 2
<br />
|