|
Attachment C
<br />
<br />Period
<br />Ending Principal Coupon Interest Debt Service
<br />Annual Debt
<br />Service
<br />Prior Bonds
<br />Debt Service
<br />Bond Year
<br />Savings
<br />2/1/2025 1,220,000 5.000% 267,758.33 1,487,758.33 1,487,758.33 1,662,875.00 175,116.67
<br />8/1/2025 334,625.00 334,625.00 0
<br />2/1/2026 1,215,000 5.000% 334,625.00 1,549,625.00 1,884,250.00 2,062,500.00 178,250.00
<br />8/1/2026 304,250.00 304,250.00 0
<br />2/1/2027 1,275,000 5.000% 304,250.00 1,579,250.00 1,883,500.00 2,061,000.00 177,500.00
<br />8/1/2027 272,375.00 272,375.00 0
<br />2/1/2028 1,340,000 5.000% 272,375.00 1,612,375.00 1,884,750.00 2,061,250.00 176,500.00
<br />8/1/2028 238,875.00 238,875.00 0
<br />2/1/2029 1,405,000 5.000% 238,875.00 1,643,875.00 1,882,750.00 2,063,000.00 180,250.00
<br />8/1/2029 203,750.00 203,750.00 0
<br />2/1/2030 1,475,000 5.000% 203,750.00 1,678,750.00 1,882,500.00 2,061,000.00 178,500.00
<br />8/1/2030 166,875.00 166,875.00 0
<br />2/1/2031 1,550,000 5.000% 166,875.00 1,716,875.00 1,883,750.00 2,060,250.00 176,500.00
<br />8/1/2031 128,125.00 128,125.00 0
<br />2/1/2032 1,625,000 5.000% 128,125.00 1,753,125.00 1,881,250.00 2,060,500.00 179,250.00
<br />8/1/2032 87,500.00 87,500.00 0
<br />2/1/2033 1,710,000 5.000% 87,500.00 1,797,500.00 1,885,000.00 2,061,500.00 176,500.00
<br />8/1/2033 44,750.00 44,750.00 0
<br />2/1/2034 1,790,000 5.000% 44,750.00 1,834,750.00 1,879,500.00 2,058,000.00 178,500.00
<br />total 14,605,000 3,830,008.33 18,435,008.33 18,435,008.33 20,211,875.00 1,776,866.67
<br />9/19/2024
<br />9/19/2024
<br />Bond Par Amount 14,605,000.00
<br />True Interest Cost 2.743478%
<br />Net Interest Cost 2.952666%
<br />All-In TIC 2.962501%
<br />Average Coupon 5.000000%
<br />Average Life 5.245
<br />Par amount of refunded bonds 15,915,000.00
<br />Average coupon of refunded bonds 5.000000%
<br />Average life of refunded bonds 5.266 years
<br />PV of prior debt to 09/19/2024 @ 2.639119%17,821,834.07
<br />Gross Savings 1,776,866.67
<br />Net PV Savings 1,572,765.90
<br />Percentage savings of refunded bonds 9.882287%
<br />City of Redwood City
<br />Dated Date
<br />Delivery Date
<br />City of Redwood City Public Financing Authority
<br />2024 Water Revenue Refunding Bonds
<br />8.A. - Page 10 of 255
<br />638
|