|
AnA�7.A. - Page 18
<br /> City of Redwood City
<br /> Redwood City Public Financing Authority
<br /> Water Revenue Refunding Bonds, Series 2013
<br /> Refunding of PFA 2005A Bonds
<br /> Savings Report
<br /> Bond Prior Bonds Bond
<br /> Payment Date Principal Coupon Interest Period Total Year Total Debt Service Year Savings
<br /> 8/1/1 3 139,400.00 139,400.00
<br /> 2/1/14 800,000 1.00°� 612,d00.00 1,412,0OO.Ofl 1,551,400.00 2,147,636.25 596,236.Z5
<br /> 8/1/14 608,d00.00 608,000.00
<br /> 2/1/15 810,000 2.00% 608,Q00.00 1,418,000.00 2,026,000.04 2,146,356.25 120,356.25
<br /> 8/1/15 599,900.00 599,900.00
<br /> 2/1/16 825,000 4.00% 599,900.00 1,424,900.00 2,024,800.00 2,144,056.25 119,256.Z5
<br /> 8/1/16 583,400.00 583,400.00
<br /> 2/1/17 855,000 4.00% 583,400.00 1,438,400.Ofl 2,021,800A0 2,143,776.25 121,976.25
<br /> 8/1/17 566,300.00 566,300.00
<br /> Z/1/18 890,000 4.00% 566,300.00 1,456,300.00 2,022,60D.04 Z,146,982.50 124,382.50
<br /> 8/1/18 548,500.00 548,500.00
<br /> 2/1/19 925,000 5A0% 548,500.00 1,473,500.00 2,022,000.04 2,147,420.00 125,420.00
<br /> 8/1/19 525,375.00 525,375.00
<br /> 2/1/20 975,000 5.00% 525,375.00 1,500,375.00 2,025,750.00 2,148,620.00 122,870.00
<br /> 8/1/20 501,000.00 501,000.00
<br /> 2/1/21 1,020,000 5.Q0% 501,000.00 1,521,000.00 2,022,Q00.00 2,148,020.00 126,020.00
<br /> 8/1/21 475,500.00 475,500.00
<br /> Z/1/22 1,075,000 5.00% 475,500.00 1,550,50�.�0 2,026,000.00 2,144,435.00 118,435.00
<br /> 8/1/22 448,625.00 448,625.00
<br /> 2/1/23 1,125,000 5.00% 448,625.00 1,573,b25.00 2,022,250.00 2,143,697.50 121,447.50
<br /> 8/1/23 420,500.00 420,500.00
<br /> 2/1/24 1,185,000 5.D0% 420,500.00 1,605,5Dfl.fl0 2,026,000.00 2,144,937.50 118,937.50
<br /> 8/1/24 390,875.00 390,875.00
<br /> 2/1/25 1,245,000 5.00% 390,875.00 1,635,875.Ofl 2,026,750.00 2,148,200.00 121,450.00
<br /> $/1/25 359,750.00 359,750.00
<br /> Z/1/26 1,305,Oa0 5.00% 359,750.00 1,664,75fl.fl0 2,024,500.00 Z,153,91250 129,412.50
<br /> 8/1/26 327,125.00 327,125.00
<br /> 2/1/27 1,370,000 5.00°� 327,125.00 1,597,125.Ofl 2,024,250.00 2,156,862.50 132,612.50
<br /> 8/1/27 292,875.00 292,875.00
<br /> 2/1/28 1,440,000 5.00% 292,875.00 1,732,875.00 2,025,750.00 2,162,050.00 136,300.00
<br /> 8/1/28 256,875.00 256,875.00
<br /> 2/1/29 1,510,000 5.00% 256,875.00 1,756,875.00 2,023,750.00 2,162,268.75 138,518.75
<br /> 8/1/29 219,1Z5.00 219,125.00
<br /> 2/1/30 1,585,000 5.00% 219,125.00 1,804,125.00 2,023,250.00 2,164,425.00 141,175.00
<br /> 8/1/30 179,500_00 179,500.00
<br /> 2/1/31 1,665,060 5.00% 179,500.00 1,844,500Aa 2,024,000.04 2,158,300.00 134,300.00
<br /> 8/1/31 137,875.00 137,875.00
<br /> 2/1/32 1,750,000 5.00% 137,875.00 1,887,875.00 2,d25,750.00 2,156,850.00 131,100.00
<br /> 8/1/32 94,125.04 94,125.00
<br /> 2/1/33 1,$35,000 5.00% 94,125.00 1,929,125.00 2,023,250.00 2,156,800.00 133,550.00
<br /> 8/1/33 48,25D.OD 48,250.00
<br /> 2/1/34 1,930,000 5.�0% 48,250.00 1,978,250A0 2,026,500.00 2,157,925.00 131,425.00
<br /> 26,120,000 15,918,350.00 42,038,350.00 42,038,350.00 45,183,531.25 3,145,181.25
<br /> Total�ebt Service 15,91 8,350.00 42,fl38,350.00
<br /> NIC 3.17121% using 115.31%
<br /> TIC 3.35104% using 11 5.31%
<br /> Bond Yield 2.65560% using 11 6.31%
<br /> All-In TIC 3.42832% using 114.49%
<br /> Average Rate 4.81894°/u
<br /> Average Life 12.3053 years
<br /> 8086 Av.�ife 12.3717 years
<br /> Dated 6/2fl/13
<br /> Delivery 5/24/13
<br /> Gross Savings 3,145,18125
<br /> Gross NPV Savings 2,369,163.78
<br /> Less DSRF Contribution (2,164,425)
<br /> Less City Contribution** (474,004)
<br /> Less Trustee surplus -
<br /> Plus New DSRF 2,OZ6,750
<br /> Adjusted Gross 5avings 1,757,484.78 = 6.73% discounted at TIC
<br />
|