|
8.A. - Page 18 Attachment 5
<br /> Projected Debt Service Comparison and Savings Report
<br /> City of Redwood City
<br /> Redwood City Public Financing Authority
<br /> Water Revenue Refunding Bonds,Series 2015
<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 175,460.00 175,460.00
<br /> 2/1/16 595,000 3.00% 438,650.00 1,033,650.00 1,209,110.00 1,209,110.00 1,569,593.75 360,483.75
<br /> 8/1/16 429,725.00 429,725.00
<br /> 2/1/17 610,000 4.00% 429,725.00 1,039,725.00 1,469,450.00 1,469,450.00 1,573,906.25 104,456.25
<br /> 8/1/17 417,525.00 417,525.00
<br /> 2/1/18 635,000 4.00% 417,525.00 1,052,525.00 1,470,050.00 1,470,050.00 1,571,200.00 101,150.00
<br /> 8/1/18 404,825.00 404,825.00
<br /> 2/1/19 660,000 4.00% 404,825.00 1,064,825.00 1,469,650.00 1,469,650.00 1,571,600.00 101,950.00
<br /> 8/1/19 391,625.00 391,625.00
<br /> 2/1/20 685,000 4.00% 391,625.00 1,076,625.00 1,468,250.00 1,468,250.00 1,570,800.00 102,550.00
<br /> 8/1/20 377,925.00 377,925.00
<br /> 2/1/21 715,000 4.00% 377,925.00 1,092,925.00 1,470,850.00 1,470,850.00 1,573,800.00 102,950.00
<br /> 8/1/21 363,625.00 363,625.00
<br /> 2/1/22 740,000 5.00% 363,625.00 1,103,625.00 1,467,250.00 1,467,250.00 1,569,356.25 102,106.25
<br /> 8/1/22 345,125.00 345,125.00
<br /> 2/1/23 780,000 5.00% 345,125.00 1,125,125.00 1,470,250.00 1,470,250.00 1,573,675.00 103,425.00
<br /> 8/1/23 325,625.00 325,625.00
<br /> 2/1/24 820,000 5.00% 325,625.00 1,145,625.00 1,471,250.00 1,471,250.00 1,570,212.50 98,962.50
<br /> 8/1/24 305,125.00 305,125.00
<br /> 2/1/25 860,000 5.00% 305,125.00 1,165,125.00 1,470,250.00 1,470,250.00 1,570,262.50 100,012.50
<br /> 8/1/25 283,625.00 283,625.00
<br /> 2/1/26 900,000 5.00% 283,625.00 1,183,625.00 1,467,250.00 1,467,250.00 1,573,612.50 106,362.50
<br /> 8/1/26 261,125.00 261,125.00
<br /> 2/1/27 945,000 5.00% 261,125.00 1,206,125.00 1,467,250.00 1,467,250.00 1,570,050.00 102,800.00
<br /> 8/1/27 237,500.00 237,500.00
<br /> 2/1/28 995,000 5.00% 237,500.00 1,232,500.00 1,470,000.00 1,470,000.00 1,569,787.50 99,787.50
<br /> 8/1/28 212,625.00 212,625.00
<br /> 2/1/29 1,045,000 5.00% 212,625.00 1,257,625.00 1,470,250.00 1,470,250.00 1,572,612.50 102,362.50
<br /> 8/1/29 186,500.00 186,500.00
<br /> 2/1/30 1,095,000 5.00% 186,500.00 1,281,500.00 1,468,000.00 1,468,000.00 1,571,862.50 103,862.50
<br /> 8/1/30 159,125.00 159,125.00
<br /> 2/1/31 1,150,000 5.00% 159,125.00 1,309,125.00 1,468,250.00 1,468,250.00 1,568,925.00 100,675.00
<br /> 8/1/31 130,375.00 130,375.00
<br /> 2/1/32 1,210,000 5.00% 130,375.00 1,340,375.00 1,470,750.00 1,470,750.00 1,573,800.00 103,050.00
<br /> 8/1/32 100,125.00 100,125.00
<br /> 2/1/33 1,270,000 5.00% 100,125.00 1,370,125.00 1,470,250.00 1,470,250.00 1,569,400.00 99,150.00
<br /> 8/1/33 68,375.00 68,375.00
<br /> 2/1/34 1,335,000 5.00% 68,375.00 1,403,375.00 1,471,750.00 1,471,750.00 1,572,525.00 100,775.00
<br /> 8/1/34 35,000.00 35,000.00
<br /> 2/1/35 1,400,000 5.00% 35,000.00 1,435,000.00 1,470,000.00 1,470,000.00 1,572,725.00 102,725.00
<br /> Total 18,445,000 10,685,110.00 29,130,110.00 29,130,110.00 29,130,110.00 31,429,706.25 2,299,596.25
<br /> NIC 3.34420% using 112.97%
<br /> TIC 3.51271% using 112.97%
<br /> Bond Yield 2.93082% using 113.97%
<br /> All-In TIC 3.61836% using 111.92%
<br /> Average Rate 4.30909%
<br /> Average Life 11.7304 years
<br /> 8086 Av.Life 11.7956 years
<br /> Dated 5/19/15
<br /> Delivery 5/19/15
<br /> Gross Savings 2,299,596.25
<br /> Gross NPV Savings 1,716,242.22
<br /> Less DSRF Contribution (1,533,631.25)
<br /> Less City Contribution (265,378.13)
<br /> Less Trustee surplus -
<br /> Plus New DSRF 1,471,750.00
<br /> Adjusted Gross NPV Savings 1,388,982.85 = 7.53% of Refunding Bonds at Bond TIC
<br />
|