|
7.B. - Page 14 City of Redwood City
<br /> Community Facilities District No.2010-1
<br /> Refunding Special Tax Bonds,Series 2016
<br /> Savings Report
<br /> DS Reduction
<br /> Bond Net Debt Prior Bonds Attributable to Net Bond
<br /> Payment Date Principal Coupon Interest Period Total Year Total Service Debt Service Development Fee Year Savings
<br /> 9/1/16 - - - - 296,478.13 296,478.13
<br /> 3/1/17 93,406.96 93,406.96
<br /> 9/1/17 100,000 1.05% 69,476.25 169,476.25 262,883.21 262,883.21 508,493.75 124,750.00 120,860.54
<br /> 3/1/18 68,951.25 68,951.25
<br /> 9/1/18 125,000 1.30% 68,951.25 193,951.25 262,902.50 262,902.50 508,543.75 128,650.00 116,991.25
<br /> 3/1/19 68,138.75 68,138.75
<br /> 9/1/19 130,000 1.55% 68,138.75 198,138.75 266,277.50 266,277.50 508,081.25 127,212.50 114,591.25
<br /> 3/1/20 67,131.25 67,131.25
<br /> 9/1/20 130,000 1.80% 67,131.25 197,131.25 264,262.50 264,262.50 507,081.25 125,712.50 117,106.25
<br /> 3/1/21 65,961.25 65,961.25
<br /> 9/1/21 130,000 2.00% 65,961.25 195,961.25 261,922.50 261,922.50 505,518.75 129,150.00 114,446.25
<br /> 3/1/22 64,661.25 64,661.25
<br /> 9/1/22 135,000 2.25% 64,661.25 199,661.25 264,322.50 264,322.50 508,368.75 127,200.00 116,846.25
<br /> 3/1/23 63,142.50 63,142.50
<br /> 9/1/23 140,000 2.45% 63,142.50 203,142.50 266,285.00 266,285.00 505,268.75 125,175.00 113,808.75
<br /> 3/1/24 61,427.50 61,427.50
<br /> 9/1/24 140,000 2.65% 61,427.50 201,427.50 262,855.00 262,855.00 506,675.00 128,112.50 115,707.50
<br /> 3/1/25 59,572.50 59,572.50
<br /> 9/1/25 145,000 2.85% 59,572.50 204,572.50 264,145.00 264,145.00 507,225.00 125,662.50 117,417.50
<br /> 3/1/26 57,506.25 57,506.25
<br /> 9/1/26 150,000 3.10% 57,506.25 207,506.25 265,012.50 265,012.50 506,350.00 128,037.50 113,300.00
<br /> 3/1/27 55,181.25 55,181.25
<br /> 9/1/27 155,000 3.20% 55,181.25 210,181.25 265,362.50 265,362.50 504,725.00 125,037.50 114,325.00
<br /> 3/1/28 52,701.25 52,701.25
<br /> 9/1/28 160,000 3.30% 52,701.25 212,701.25 265,402.50 265,402.50 507,350.00 127,037.50 114,910.00
<br /> 3/1/29 50,061.25 50,061.25
<br /> 9/1/29 165,000 3.40% 50,061.25 215,061.25 265,122.50 265,122.50 508,850.00 128,662.50 115,065.00
<br /> 3/1/30 47,256.25 47,256.25
<br /> 9/1/30 170,000 3.45% 47,256.25 217,256.25 264,512.50 264,512.50 509,225.00 124,912.50 119,800.00
<br /> 3/1/31 44,323.75 44,323.75
<br /> 9/1/31 175,000 3.50% 44,323.75 219,323.75 263,647.50 263,647.50 508,475.00 126,162.50 118,665.00
<br /> 3/1/32 41,261.25 41,261.25
<br /> 9/1/32 180,000 3.60% 41,261.25 221,261.25 262,522.50 262,522.50 506,600.00 127,037.50 117,040.00
<br /> 3/1/33 38,021.25 38,021.25
<br /> 9/1/33 190,000 3.65% 38,021.25 228,021.25 266,042.50 266,042.50 508,000.00 127,387.50 114,570.00
<br /> 3/1/34 34,553.75 34,553.75
<br /> 9/1/34 195,000 3.70% 34,553.75 229,553.75 264,107.50 264,107.50 507,850.00 127,350.00 116,392.50
<br /> 3/1/35 30,946.25 30,946.25
<br /> 9/1/35 200,000 3.75% 30,946.25 230,946.25 261,892.50 261,892.50 506,150.00 126,925.00 117,332.50
<br /> 3/1/36 27,196.25 27,196.25
<br /> 9/1/36 210,000 3.80% 27,196.25 237,196.25 264,392.50 264,392.50 507,900.00 126,112.50 117,395.00
<br /> 3/1/37 23,206.25 23,206.25
<br /> 9/1/37 215,000 3.95% 23,206.25 238,206.25 261,412.50 261,412.50 507,712.50 129,912.50 116,387.50
<br /> 3/1/38 18,960.00 18,960.00
<br /> 9/1/38 225,000 3.95% 18,960.00 243,960.00 262,920.00 262,920.00 505,587.50 127,937.50 114,730.00
<br /> 3/1/39 14,516.25 14,516.25
<br /> 9/1/39 235,000 3.95% 14,516.25 249,516.25 264,032.50 264,032.50 506,525.00 125,575.00 116,917.50
<br /> 3/1/40 9,875.00 9,875.00
<br /> 9/1/40 245,000 3.95% 9,875.00 254,875.00 264,750.00 264,750.00 505,137.50 127,825.00 112,562.50
<br /> 3/1/41 5,036.25 5,036.25
<br /> 9/1/41 255,000 3.95% 5,036.25 260,036.25 265,072.50 265,072.50 506,425.00 129,300.00 112,052.50
<br /> Total 4,300,000 2,302,060.71 6,602,060.71 6,602,060.71 6,602,060.71 12,974,596.88 3,176,837.50 3,195,698.67
<br /> NIC 3.68418% using 98.80%
<br /> TIC 3.66714% using 98.80%
<br /> Average Rate 3.60341%
<br /> Average Life 14.8571 years
<br /> 8086 Av.Life 14.8571 years
<br /> Dated 6/29/16
<br /> Delivery 6/29/16
<br /> Gross Savings 6,372,536.17
<br /> Gross NPV Savings 4,221,372.29
<br /> Less DSRF Contribution (505,000.00)
<br /> Less Available CFD Bond Fund (296,478.13)
<br /> Less Benefitted Property Fee (1,402,578.00)
<br /> Plus New DSRF 199,713.75
<br /> Adjusted Gross NPV Savings(1) 2,217,029.91 = 38.88% of Refunding Bonds at Bond TIC
<br /> Average Annual Savings(1) 115,968.82 22.87%
<br /> (1)Excludes savings due to bonds called with Benefitted Property fee
<br /> Prepared by William Euphrat Municipal Finance,Inc.,5/11/16 Page 2
<br />
|