|
Attachment 2
<br /> 7.1.B. - Page 8 City of Redwood City
<br /> Redwood City Public Financing Authority
<br /> Water Revenue Refunding Bonds, Series 201 5
<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 /> 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/1/16 423,175.00 423,175.00
<br /> 2/1/17 580,000 4.00% 423,175.00 1,003,175.00 1,426,350.00 1,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 1,428,150.00 1,428,150.00 1,571,200.00 143,050.00
<br /> 8/1/18 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,571,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 147,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 1,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,173,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 1,569,787.50 143,287.50
<br /> 8/1/28 206,625.00 206,625.00
<br /> 2/1/29 1,015,000 5.00% 206,625.00 1,221,625.00 1,428,250.00 1,428,250.00 1,572,612.50 144,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/31 1,120,000 5.00% 154,625.00 1,274,625.00 1,429,250.00 1,429,250.00 1,568,925.00 139,675.00
<br /> 8/1/31 126,625.00 126,625.00
<br /> 2/1/32 1,175,000 5.00% 126,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 1,235,000 5.00% 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 /> 8/1/34 34,000.00 34,000.00
<br /> 2/1/35 1,360,000 5.00% 34,000.00 1,394,000.00 1,428,000.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 112.21%
<br /> Bond Yield 3.07951% using 113.21%
<br /> All -In TIC 3.73638% using 111.12%
<br /> Average Rate 4.37663%
<br /> Average Life 11.7605 years
<br /> 8086 Av. Life 11.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 (1,573,906.25)
<br /> Less City Contribution (265,378.13)
<br /> Less Trustee surplus -
<br /> Plus New DSRF 71 5,375.00
<br /> Adjusted Gross Savings 1,165,758.79 = 6.53% of Refunding Bonds at TIC
<br />
|