City of Elk River, Minnesota
<br />Minnesota Sports Federation Volley Ball Complex
<br />Gross Revenue Bond Issue
<br />
<br />Bonds Dated October 1, 1996
<br />Bonds Mature April 1
<br />
<br />Schedule A
<br />
<br />Reserve Projected
<br />Earnings @ Annual
<br />Principal Rate Interest Total 6.00% Net Cost Covera~le*
<br />69,069 69,069 (6,156) 62,913 0
<br />65,000 4.70% 138,138 203,138 (12,311) 190,826 1.26
<br />65,000 4.90% 135,083 200,083 (12,311) 187,771 1.28
<br />70,000 5.10% 131,898 201,898 (12,311) 189,586 1.27
<br />75,000 5.20% 128,328 203,328 (12,311) 191,016 1.26
<br />80,000 5.30% 124,428 204,428 (12,311) 192,116 1.25
<br />85,000 5.40% 120,188 205,188 (12,311) 192,876 1.25
<br />85,000 5.50% 115,598 200,598 (12,311) 188,286 1.28
<br />90,000 5.60% 110,923 200,923 (12,311) 188,611 1.28
<br />95,000 5.70% 105,883 200,883 (12,311) 188,571 1.28
<br />100,000 5.80% 100,468 200,468 (12,311) 188,156 1.28
<br />110,000 5.90% 94,668 204,668 (12,311) 192,356 1.25
<br />115,000 6.00% 88,178 203,178 (12,311) 190,866 1.26
<br />120,000 6.05% 81,278 201,278 (12,311) 188,966 1.27
<br />130,000 6.10% 74,018 204,018 (12,311) 191,706 1.26
<br />135,000 6.15% 66,088 201,088 (12,311) 188,776 1.28
<br />145,000 6.20% 57,785 202,785 (12,311) 190,474 1.26
<br />155,000 6.25% 48,795 203,795 (12,311) 191,484 1.26
<br />165,000 6.30% 39,108 204,108 (12,311) 191,796 1.26
<br />175,000 6.35% 28,713 203,713 (12,311) 191,401 1.26
<br />275,000 6.40% 17,600 292,600 (217,499) 75,101 3.21
<br />2,335,000 1,876,226 4,211,226 (457,568) 3,753,658
<br />
<br />Year
<br />1997
<br />1998
<br />1999
<br />2000
<br />2001
<br />2002
<br />2003
<br />2004
<br />2005
<br />2006
<br />2007
<br />2008
<br />2009
<br />2010
<br />2011
<br />2012
<br />2013
<br />2014
<br />2015
<br />2016
<br />2017
<br />
<br />Bond Years:
<br />Average Maturity:
<br />Avg Coupon Rate:
<br />Net Interest Rate:
<br />
<br />30,697.50
<br /> 13.15
<br /> 6.112%
<br /> 6.257%
<br />
<br />Coverage of Net Income of:
<br />Average 1998-2016 (Times)
<br />
<br />240,776
<br /> 1.265
<br />
<br />Composition of Issue
<br />
<br />Project Costs
<br />Capitalized Interest
<br />Reserve Fund
<br />Costs of Issuance
<br />Discount
<br />Sub Total Costs
<br />MSF Contribution - 10%
<br />Total Bond Issue
<br />
<br />2,100,000
<br /> 190,826
<br /> 205,188
<br /> 54,066
<br /> 44,365
<br /> 2,594,445
<br /> (259,444)
<br />2,335,000
<br />
<br />Prepared by: Springsted Incorporated (9/4/96) elkrvvb.xls E0894W2
<br />
<br />
<br />
|