Page 9
<br />
<br />$10,000,000
<br />City of Elk River, Minnesota
<br />Electric Revenue Bonds, Series 2018A
<br />Coverage Ratio Including the Bonds
<br />Date Net Electric
<br />Fund Revenues
<br />Total Electric Parity
<br />Debt Service
<br />Coverage
<br />08/01/2019 5,197,389.00 1,494,052.95 3.4787181x
<br />08/01/2020 5,197,389.00 1,503,397.50 3.4570957x
<br />08/01/2021 5,197,389.00 1,491,317.50 3.4850989x
<br />08/01/2022 5,197,389.00 1,498,072.50 3.4693842x
<br />08/01/2023 5,197,389.00 1,253,540.00 4.1461692x
<br />08/01/2024 5,197,389.00 1,252,952.50 4.1481134x
<br />08/01/2025 5,197,389.00 1,251,437.50 4.1531351x
<br />08/01/2026 5,197,389.00 1,251,722.50 4.1521895x
<br />08/01/2027 5,197,389.00 1,258,872.50 4.1286064x
<br />08/01/2028 5,197,389.00 1,255,222.50 4.1406117x
<br />08/01/2029 5,197,389.00 1,255,390.00 4.1400593x
<br />08/01/2030 5,197,389.00 1,259,141.25 4.1277251x
<br />08/01/2031 5,197,389.00 1,256,285.00 4.1371098x
<br />08/01/2032 5,197,389.00 1,256,782.50 4.1354721x
<br />08/01/2033 5,197,389.00 1,255,648.75 4.1392061x
<br />08/01/2034 5,197,389.00 1,251,915.00 4.1515510x
<br />08/01/2035 5,197,389.00 1,251,375.00 4.1533425x
<br />08/01/2036 5,197,389.00 1,259,400.00 4.1268771x
<br />08/01/2037 5,197,389.00 571,637.50 9.0921064x
<br />08/01/2038 5,197,389.00 573,337.50 9.0651475x
<br />08/01/2039 5,197,389.00 569,285.00 9.1296785x
<br />08/01/2040 5,197,389.00 569,660.00 9.1236685x
<br />08/01/2041 5,197,389.00 573,280.00 9.0660567x
<br />08/01/2042 5,197,389.00 571,060.00 9.1013011x
<br />08/01/2043 5,197,389.00 573,210.00 9.0671639x
<br />08/01/2044 5,197,389.00 569,520.00 9.1259113x
<br />08/01/2045 5,197,389.00 570,200.00 9.1150281x
<br />08/01/2046 5,197,389.00 569,080.00 9.1329672x
<br />08/01/2047 5,197,389.00 572,080.00 9.0850738x
<br />08/01/2048 5,197,389.00 568,980.00 9.1345724x
<br />-
<br />Electric Fund Net Revenues Available for Debt Service*
<br />Operating Revenue 36,120,824$
<br />Operating Expense (33,394,471)
<br />Net Operating Income (Loss)2,726,353$
<br />Add Back Depreciation 2,046,935
<br />Add Other Income 424,101
<br />Available for Debt Service 5,197,389$
<br />*Source: Elk River Municipal Utilities Annual Financial Report for year ended December 31, 2017.
<br />
<br />Series 2018A Electric Rev | SINGLE PURPOSE | 6/28/2018 | 1:07 PM
|