|
6.C. - Page 37 of 57
<br />Dec 4, 2019 10:21 pm Prepared by DBC Finance (Finance 8.000 South Bayside Waste Management Authority: l9ATII-19DEF,19DEF) Page 5
<br />ESCROW CASI-1 FLOW
<br />South Bayside Waste Management
<br />Proposed Cash Defesance
<br />City of Atherton's Portion of the 2019 Solid Waste Revenue Bonds
<br />Reflects Market Conditions as of December 4, 2019
<br />***Preliminary, Subject to Change with Market Conditions"*
<br />Date
<br />Principal
<br />Interest
<br />Net Escrow
<br />Receipts
<br />Present Value
<br />to 03/02/2020
<br />@ 1.6857844%
<br />09/01/2020
<br />53.368.00
<br />16,256.95
<br />69,624.95
<br />69,046.21
<br />03/01/2021
<br />22,599.00
<br />16,275.44
<br />38,874.44
<br />38,229.08
<br />09/01/2021
<br />62.949.00
<br />15,926.12
<br />78,875.12
<br />76,917.37
<br />03/01/2022
<br />22,437.00
<br />15,438.27
<br />37,875.27
<br />36,626.45
<br />09/01/2022
<br />62,609.00
<br />15,265.51
<br />77,874.51
<br />74,677.39
<br />03/01/2023
<br />22,092.00
<br />14,783.42
<br />36.875.42
<br />35,065.94
<br />09/01/2023
<br />67,262.00
<br />14,613.31
<br />81,875.31
<br />77,206.91
<br />03/01/2024
<br />21,654.00
<br />14,095.39
<br />35,749.39
<br />33,429.24
<br />09/01/2024
<br />71,822.00
<br />13,928.65
<br />85,750.65
<br />79,515.18
<br />03/01/2025
<br />21.124.00
<br />13,375.62
<br />34.499.62
<br />31,723.54
<br />09/01/2025
<br />71,288.00
<br />13,211.91
<br />84,499.91
<br />77,051.00
<br />03/01/2026
<br />20.594.00
<br />12,655.86
<br />33,249.86
<br />30,065.37
<br />09/01/2026
<br />70,758.00
<br />12,492.14
<br />83,250.14
<br />74,647.70
<br />03/01/2027
<br />20.085.00
<br />11,915.46
<br />32,000.46
<br />28,453.94
<br />09/01/2027
<br />75,251.00
<br />11,748.75
<br />86,999.75
<br />76.711.22
<br />03/01/2028
<br />19,505.00
<br />11,120.40
<br />30,625.40
<br />26,777.95
<br />09/01/2028
<br />79,668.00
<br />10,956.56
<br />90,624.56
<br />78,577.13
<br />03/01/2029
<br />18,842.00
<br />10,283.37
<br />29,125.37
<br />25,042.43
<br />09/01/2029
<br />1,184,001.00
<br />10.123.21
<br />1,194.124.21
<br />1.018.143.97
<br />1.987,908.00
<br />254,466.34
<br />2,242,374.34
<br />1.987.908.00
<br />Escrow Cost Summary
<br />Purchase date 03/02/2020
<br />Purchase cost of securities 1.987,908.00
<br />Target for yield calculation 1.987,908.00
<br />SBWMA BOD PACKET 8/20/2020
<br />AGENDA ITEM: 5A ATTACHMENT 2 - p13
<br />R
<br />
|