|
ESTIMATE OF DEBT SERVICE
<br />City of Mounds View
<br />PREPARED ON 01/18/2023
<br />DATE
<br />PRINCIPAL
<br />RATE
<br />INTEREST
<br />TOTAL
<br />ANNUAL
<br />DEBT
<br />SERVICE
<br />TOTALS
<br />16,500,000.00
<br />5,888,809.13
<br />22,388,809.13
<br />22,388,809.13
<br />1
<br />11/01/2023
<br />207,625.03
<br />207,625.03
<br />207,625.03
<br />2
<br />05/01/2024
<br />247,500.04
<br />247,500.04
<br />3
<br />11/01/2024
<br />614,059.00
<br />3.000%
<br />247,500.04
<br />861,559.04
<br />1,109,059.08
<br />4
<br />05/01/2025
<br />238,289.15
<br />238,289.15
<br />5
<br />11/01/2025
<br />632,481.00
<br />3.000%
<br />238,289.15
<br />870,770.15
<br />1,109,059.30
<br />6
<br />05/01/2026
<br />228,801.93
<br />228,801.93
<br />7
<br />11/01/2026
<br />651,456.00
<br />3.000%
<br />228,801.93
<br />880,257.93
<br />1,109,059.86
<br />8
<br />05/01/2027
<br />219,030.09
<br />219,030.09
<br />9
<br />11/01/2027
<br />670,999.00
<br />3.000%
<br />219,030.09
<br />890,029.09
<br />1,109,059.18
<br />10
<br />05/01/2028
<br />208,965.10
<br />208,965.10
<br />11
<br />11/01/2028
<br />691,129.00
<br />3.000%
<br />208,965.10
<br />900,094.10
<br />1,109,059.20
<br />12
<br />05/01/2029
<br />198,598.16
<br />198,598.16
<br />13
<br />11/01/2029
<br />711,862.00
<br />3.000%
<br />198,598.16
<br />910,460.16
<br />1,109,058.32
<br />14
<br />05/01/2030
<br />187,920.23
<br />187,920.23
<br />15
<br />11/01/2030
<br />733,219.00
<br />3.000%
<br />187,920.23
<br />921,139.23
<br />1,109,059.46
<br />16
<br />05/01/2031
<br />176,921.94
<br />176,921.94
<br />17
<br />11/01/2031
<br />755,216.00
<br />3.000%
<br />176,921.94
<br />932,137.94
<br />1,109,059.88
<br />18
<br />05/01/2032
<br />165,593.70
<br />165,593.70
<br />19
<br />11/01/2032
<br />777,871.00
<br />3.000%
<br />165,593.70
<br />943,464.70
<br />1,109,058.40
<br />20
<br />05/01/2033
<br />153,925.63
<br />153,925.63
<br />21
<br />11/01/2033
<br />801,208.00
<br />3.000%
<br />153,925.63
<br />955,133.63
<br />1,109,059.26
<br />22
<br />05/01/2034
<br />141,907.51
<br />141,907.51
<br />23
<br />11/01/2034
<br />825,244.00
<br />3.000%
<br />141,907.51
<br />967,151.51
<br />1,109,059.02
<br />24
<br />05/01/2035
<br />129,528.85
<br />129,528.85
<br />25
<br />11/01/2035
<br />850,002.00
<br />3.000%
<br />129,528.85
<br />979,530.85
<br />1,109,059.70
<br />26
<br />05/01/2036
<br />116,778.82
<br />116,778.82
<br />27
<br />11/01/2036
<br />875,502.00
<br />3.000%
<br />116,778.82
<br />992,280.82
<br />1,109,059.64
<br />28
<br />05/01/2037
<br />103,646.29
<br />103,646.29
<br />29
<br />11/01/2037
<br />901,766.00
<br />3.000%
<br />103,646.29
<br />1,005,412.29
<br />1,109,058.58
<br />30
<br />05/01/2038
<br />90,119.80
<br />90,119.80
<br />31
<br />11 /01 /2038
<br />928,820.00
<br />3.000%
<br />90,119.80
<br />1,018,939.80
<br />1,109,059.60
<br />32
<br />05/01 /2039
<br />76,187.50
<br />76,187.50
<br />33
<br />11 /01 /2039
<br />956,684.00
<br />3.000%
<br />76,187.50
<br />1,032,871.50
<br />1,109,059.00
<br />34
<br />05/01/2040
<br />61,837.24
<br />61,837.24
<br />35
<br />11/01/2040
<br />985,385.00
<br />3.000%
<br />61,837.24
<br />1,047,222.24
<br />1,109,059.48
<br />36
<br />05/01/2041
<br />47,056.46
<br />47,056.46
<br />37
<br />11/01/2041
<br />1,014,946.00
<br />3.000%
<br />47,056.46
<br />1,062,002.46
<br />1,109,058.92
<br />38
<br />05/01 /2042
<br />31,832.27
<br />31,832.27
<br />39
<br />11/01/2042
<br />1,045,395.00
<br />3.000%
<br />31,832.27
<br />1,077,227.27
<br />1,109,059.54
<br />40
<br />05/01 /2043
<br />16,151.34
<br />16,151.34
<br />41
<br />11/01/2043
<br />1,076,756.00
<br />3.000%
<br />16,151.34
<br />1,092,907.34
<br />1,109,058.68
<br />
|