|
Prepared by William Euphrat Municipal Finance, Inc., 2/23/16 Page 2
<br />Bond Net Debt Prior Bonds Bond
<br />Payment Date Principal Coupon Interest Period Total Year Total Service Debt Service Year Savings
<br />3/1/17 107,381.39 107,381.39
<br />9/1/17 150,000 2.000%85,525.00 235,525.00 342,906.39 342,906.39 508,493.75 165,587.36
<br />3/1/18 84,025.00 84,025.00
<br />9/1/18 170,000 2.000%84,025.00 254,025.00 338,050.00 338,050.00 508,543.75 170,493.75
<br />3/1/19 82,325.00 82,325.00
<br />9/1/19 175,000 2.000%82,325.00 257,325.00 339,650.00 339,650.00 508,081.25 168,431.25
<br />3/1/20 80,575.00 80,575.00
<br />9/1/20 180,000 2.000%80,575.00 260,575.00 341,150.00 341,150.00 507,081.25 165,931.25
<br />3/1/21 78,775.00 78,775.00
<br />9/1/21 180,000 2.000%78,775.00 258,775.00 337,550.00 337,550.00 505,518.75 167,968.75
<br />3/1/22 76,975.00 76,975.00
<br />9/1/22 185,000 2.000%76,975.00 261,975.00 338,950.00 338,950.00 508,368.75 169,418.75
<br />3/1/23 75,125.00 75,125.00
<br />9/1/23 190,000 2.000%75,125.00 265,125.00 340,250.00 340,250.00 505,268.75 165,018.75
<br />3/1/24 73,225.00 73,225.00
<br />9/1/24 195,000 2.250%73,225.00 268,225.00 341,450.00 341,450.00 506,675.00 165,225.00
<br />3/1/25 71,031.25 71,031.25
<br />9/1/25 200,000 2.500%71,031.25 271,031.25 342,062.50 342,062.50 507,225.00 165,162.50
<br />3/1/26 68,531.25 68,531.25
<br />9/1/26 200,000 2.625%68,531.25 268,531.25 337,062.50 337,062.50 506,350.00 169,287.50
<br />3/1/27 65,906.25 65,906.25
<br />9/1/27 210,000 2.750%65,906.25 275,906.25 341,812.50 341,812.50 504,725.00 162,912.50
<br />3/1/28 63,018.75 63,018.75
<br />9/1/28 215,000 3.000%63,018.75 278,018.75 341,037.50 341,037.50 507,350.00 166,312.50
<br />3/1/29 59,793.75 59,793.75
<br />9/1/29 220,000 3.000%59,793.75 279,793.75 339,587.50 339,587.50 508,850.00 169,262.50
<br />3/1/30 56,493.75 56,493.75
<br />9/1/30 225,000 3.000%56,493.75 281,493.75 337,987.50 337,987.50 509,225.00 171,237.50
<br />3/1/31 53,118.75 53,118.75
<br />9/1/31 235,000 3.125%53,118.75 288,118.75 341,237.50 341,237.50 508,475.00 167,237.50
<br />3/1/32 49,446.88 49,446.88
<br />9/1/32 240,000 3.250%49,446.88 289,446.88 338,893.75 338,893.75 506,600.00 167,706.25
<br />3/1/33 45,546.88 45,546.88
<br />9/1/33 250,000 3.250%45,546.88 295,546.88 341,093.75 341,093.75 508,000.00 166,906.25
<br />3/1/34 41,484.38 41,484.38
<br />9/1/34 255,000 3.375%41,484.38 296,484.38 337,968.75 337,968.75 507,850.00 169,881.25
<br />3/1/35 37,181.25 37,181.25
<br />9/1/35 265,000 3.500%37,181.25 302,181.25 339,362.50 339,362.50 506,150.00 166,787.50
<br />3/1/36 32,543.75 32,543.75
<br />9/1/36 275,000 3.500%32,543.75 307,543.75 340,087.50 340,087.50 507,900.00 167,812.50
<br />3/1/37 27,731.25 27,731.25
<br />9/1/37 285,000 3.625%27,731.25 312,731.25 340,462.50 340,462.50 507,712.50 167,250.00
<br />3/1/38 22,565.63 22,565.63
<br />9/1/38 295,000 3.625%22,565.63 317,565.63 340,131.25 340,131.25 505,587.50 165,456.25
<br />3/1/39 17,218.75 17,218.75
<br />9/1/39 305,000 3.625%17,218.75 322,218.75 339,437.50 339,437.50 506,525.00 167,087.50
<br />3/1/40 11,690.63 11,690.63
<br />9/1/40 315,000 3.625%11,690.63 326,690.63 338,381.25 338,381.25 505,137.50 166,756.25
<br />3/1/41 5,981.25 5,981.25
<br />9/1/41 330,000 3.625%5,981.25 335,981.25 341,962.50 341,962.50 506,425.00 164,462.50
<br />Total 5,745,000 2,753,525.14 8,498,525.14 8,498,525.14 8,498,525.14 12,678,118.75 4,179,593.61
<br />NIC 3.44132%using 98.17%
<br />TIC 3.39961%using 98.17%
<br />Bond Yield 3.32000%using 99.04%
<br />All-In TIC 3.60211%using 96.00%
<br />Average Rate 3.31471%
<br />Average Life 14.6404 years
<br />8086 Av. Life 14.5993 years
<br />Dated 7/15/16
<br />Delivery 7/15/16
<br />Gross Savings 4,179,593.61
<br />Gross NPV Savings 2,791,966.05
<br />Less DSRF Contribution (505,000.00)
<br />Less City Contribution (296,478.13)
<br />Less Trustee surplus -
<br />Plus New DSRF 257,179.79
<br />Adjusted Gross NPV Savings 2,247,667.72 =39.12%of Refunding Bonds at Bond TIC
<br />Average Annual Savings 167,183.74 32.97%
<br />City of Redwood City
<br />Community Facilities District No. 2010-1
<br />Refunding Special Tax Bonds, Series 2016
<br />Savings Report
<br />Attachment 26.3.A. - Page 9
|