|
City Financing Scenarios (20 yrs.)
<br />** PRELIMINARY, For Discussion Purposes Only ""
<br />City of Louisville, Colorado
<br />Water Enterprise Revenue Bonds, Series 2020
<br />Financing Comparisons - 20 Year Terms
<br />Market Rates as of 6/4/2O2Ox
<br />ProjectScenario 1:
<br />$15.6 Million
<br />id
<br />Series 2020
<br />Bonding Sources Summal�
<br />Par Amount
<br />$12,975,000
<br />Prennum
<br />2,840,087
<br />$15,815,087
<br />Total Sources of Funds
<br />Uses of Funds Summal-N
<br />Project Fund
<br />$15,600,000
<br />Cast of Issuance
<br />150,212
<br />Underwriter's Discount
<br />64,975
<br />$15,815,087
<br />Total Use of Funds
<br />Finance Statistics
<br />Dated Date
<br />12/1/2020
<br />Final Maturity
<br />12/1/2040
<br />Total Debt Service
<br />$19,647,850
<br />Maximum Annual Debt Service
<br />$985,100
<br />1VIC
<br />2.506%
<br />TIC
<br />2.213%
<br />Series 2020
<br />$14,215,000
<br />3,110,246
<br />$17,325,246
<br />$17,100,000
<br />154,171
<br />$17,325,246
<br />12/1/2020
<br />12/1/2040
<br />$21,522,700
<br />$1,078,400
<br />2.506%
<br />2.213%
<br />Scenario 3- M—
<br />Debt Service Cashflows
<br />Year
<br />Endmp
<br />Series 2020
<br />Series 2020
<br />Series 2020
<br />977,600
<br />1,078,300
<br />1,135,100
<br />Project
<br />2021
<br />Series 2020
<br />2022
<br />982,850
<br />1,076,300
<br />1,137,100
<br />2023
<br />991,850
<br />1,078,300
<br />1,137,850
<br />$15,035,000
<br />2024
<br />984,850
<br />1,074,050
<br />1,137,350
<br />3,291,250
<br />2025
<br />2026
<br />2027
<br />981,600
<br />992,350
<br />981,850
<br />1,073,900
<br />1,077,300
<br />1,074,300
<br />1,140,600
<br />1,137,350
<br />1,137,850
<br />$18,326,250
<br />2028
<br />985,100
<br />1,075,050
<br />1,136,850
<br />$18,100,000
<br />2029
<br />981,850
<br />1,074,300
<br />1,139,350
<br />2030
<br />992,350
<br />1,077,050
<br />1,140,100
<br />151,075
<br />2031
<br />991,350
<br />1,078,050
<br />1,139,100
<br />75,175
<br />2032
<br />2033
<br />2034
<br />993,850
<br />994,600
<br />980,800
<br />1,077,300
<br />1,074,800
<br />1,078,400
<br />1,141,350
<br />1,136,600
<br />1,138,400
<br />$18,326,250
<br />2035
<br />981,000
<br />1,075,600
<br />1,138,800
<br />12/l/2020
<br />2036
<br />980,000
<br />1,076,600
<br />1,137,800
<br />12/1/2040
<br />2037
<br />982,800
<br />1,076,200
<br />1,140,400
<br />$22,769,150
<br />2038
<br />984,200
<br />1,074,400
<br />1,136,400
<br />$1,141,350
<br />2039
<br />984,200
<br />1,076,200
<br />1,141,000
<br />2.506%
<br />2040
<br />982,800
<br />1,076,400
<br />1,138,800
<br />$19,647,950
<br />$21522,700
<br />$22,768,150
<br />2.213%
<br />'Assumes a rating of AA- and MMD as of 6/4/2020
<br />plus applicable credit spreads.
<br />H illtop5ecurities 4*
<br />nwwuewnw.p�r
<br />6/15/2020
<br />21
<br />
|