|
02/09/2015
<br /> City of Redwood City
<br /> Redwood City Public Financing Authority
<br /> Water Revenue Refunding Bonds,Series 2015
<br /> Savfngs Report
<br /> Bond Net Debt Prior Bonds Bond
<br /> Pavment Date Princi al Coupon Interest Period Total Year Total Service Debt Service Year Savinqs
<br /> 8/1/15 171,550.00 171,550.00
<br /> 2/1/16 570,000 2.00% 428,875.00 998,875.00 1,170,425.00 1,170,425.00 1,569,593.75 399,168.75
<br /> 8/7/16 423,175.00 423,775.00
<br /> 2/1/77 580,000 4.00% 423,175.00 1,003,175.00 1,426,350.00 7,426,350.00 1,573,906.25 147,556.25
<br /> 8/1/17 411,575.00 411,575.00
<br /> 2/1/18 605,000 4.00% 411,575.00 1,016,575.00 7,428,150.00 1,428,150.00 1,571,200.00 143,050.00
<br /> 8/1/1 S 399,475.00 399,475.00
<br /> 2/1/19 630,000 4.00% 399,475.00 1,029,475.00 1,428,950.00 1,428,950.00 1,577,600.00 142,650.00
<br /> 8/1/19 386,875.00 386,875.00
<br /> 2/1/20 655,000 5.00% 386,875.00 1,041,875.00 1,428,750.00 1,428,750.00 1,570,800.00 142,050.00
<br /> 8/1/20 370,500.00 370,500.00
<br /> 2/1/21 685,000 5.00% 370,500.00 1,055,500.00 1,426,000.00 1,426,000.00 1,573,800.00 747,800.00
<br /> 8/1/21 353,375.00 353,375.00
<br /> 2/1/22 720,000 5.00% 353,375.00 1,073,375.00 1,426,750.00 1,426,750.00 1,569,356.25 142,606.25
<br /> 8/1/22 335,375.00 335,375.00
<br /> 2/1/23 760,000 5.00% 335,375.00 1,095,375.00 1,430,750.00 1,430,750.00 1,573,675.00 142,925.00
<br /> 8/1/23 316,375.00 316,375.00
<br /> 2/1/24 795,000 5.00% 316,375.00 1,111,375.00 1,427,750.00 1,427,750.00 1,570,212.50 142,462.50
<br /> 8/1/24 296,500.00 296,500.00
<br /> 2/1/25 835,000 5.00% 296,500.00 1,131,500.00 1,428,000.00 7,428,000.00 1,570,262.50 142,262.50
<br /> 8/1/25 275,625.00 275,625.00
<br /> 2/1/26 875,000 5.00% 275,625.00 1,150,625.00 1,426,250.00 1,426,250.00 1,573,612.50 147,362.50
<br /> 8/1/26 253,750.00 253,750.00
<br /> 2/1/27 920,000 5.00% 253,750.00 1,773,750.00 1,427,500.00 1,427,500.00 1,570,050.00 142,550.00
<br /> 8/1/27 230,750.00 230,750.00
<br /> 2/1/28 965,000 5.00% 230,750.00 1,195,750.00 1,426,500.00 1,426,500.00 7,569,787.50 143,287.50
<br /> 8/1/28 206,625.00 206,625.00
<br /> 2/1/29 7,015,000 5.00% 206,625.00 1,221,625.00 1,428,250.00 1,428,250.00 1,572,672.50 744,362.50
<br /> 8/1/29 181,250.00 181,250.00
<br /> 2/1/30 1,065,000 5.00% 181,250.00 1,246,250.00 1,427,500.00 1,427,500.00 1,571,862.50 144,362.50
<br /> 8/1/30 154,625.00 154,625.00
<br /> 2/1/37 1,720,000 5.00% 154,625.00 1,274,625.00 1,429,250.00 1,429,250.00 1,568,925.00 739,675.00
<br /> S/1/31 126,625.00 126,625.00
<br /> 2/1/32 1,175,000 5.00% 726,625.00 1,301,625.00 1,428,250.00 1,428,250.00 1,573,800.00 145,550.00
<br /> 8/1/32 97,250.00 97,250.00
<br /> 2/1/33 7,235,000 5.004fi 97,250.00 1,332,250.00 1,429,500.00 1,429,500.00 1,569,400.00 139,900.00
<br /> 8/1/33 66,375.00 66,375.00
<br /> 2/1/34 1,295,000 5.00% 66,375.00 1,361,375.00 1,427,750.00 1,427,750.00 1,572,525.00 144,775.00
<br /> S/1/34 34,000.00 34,000.00
<br /> 2/1/35 1,360,000 5.0096 34000.00 1 394000.00 1428000.00 1,428,000.00 1,572,725.00 144,725.00
<br /> Total 17,860,000 10,440,625.00 28,300,625.00 28,300,625.00 28,300,625.00 31,429,706.25 3,129,081.25
<br /> NIC 3.46287% using 112.21%
<br /> TIC 3.62664% using 17 2.21%
<br /> Bond Yield 3.07951% using 113.21%
<br /> All-In TIC 3.73638% using 11 1.12%
<br /> Average Rate 4.37663%
<br /> Average Life 11.7605 years
<br /> 8086 Av.Life 17.7988 years
<br /> Dated 5/19/15
<br /> Delivery 5/19/15
<br /> Gross Savings 3,129,081.25
<br /> Gross NPV Savings 2,289,668.17
<br /> Less DSRF Contribution (7,573,906.25)
<br /> Less City Contribution (265,378.13)
<br /> Less Trustee surplus -
<br /> Plus New DSRF 715,375.00
<br /> Adjusted Gross Savings 1,165,758.79 = 6.53% of Refunding Bonds at TIC
<br /> 2 RESO.#15391
<br /> MUFF#505
<br />
|