|
)EC -3196 15x29 FROMsSPRINGSTED INC IDiS122233093 PAGE II
<br />City of St. Anthony, Minnesota
<br />Liquor Store Revenue Bonds
<br />16 Year Amortization 15 Year
<br />Bonds Dated 3/1,97 Liquor Revenue Bonds
<br />Mature 12/1
<br />765,000 444,254 1,209,254 3,992,098 142,768 3.43
<br />(Avg 1998 - 2011)
<br />Bond Years: 7,473.75
<br />Avg. Maturity: 9.77
<br />NIC 6.12%
<br />Annual interest
<br />444,254
<br />Discount@ 1.75%
<br />13,388
<br />Total interest
<br />457,641
<br />Add Back - Nonoperating Income
<br />Reserve
<br />Depreciation
<br />82,645
<br />Rev.
<br />Mat.
<br />SAV II Rent
<br />69.045
<br />Total
<br />Available
<br />Income
<br />Annual
<br />Year
<br />Year
<br />Principal
<br />Rate
<br />Interest
<br />D/S
<br />Revenue'
<br />5.50%
<br />Surplus
<br />Coverage
<br />(1)
<br />(2)
<br />(3)
<br />(4)
<br />(5)
<br />(6)
<br />(7)
<br />0
<br />(1)
<br />(2)
<br />1997
<br />1997
<br />0
<br />4.50%
<br />32,839
<br />32,839
<br />29,683
<br />3,156
<br />0
<br />1.00
<br />1998
<br />1998
<br />35,000
<br />4.75%
<br />43,785
<br />78,785
<br />264,161
<br />4,208
<br />189,584
<br />3.41
<br />1999
<br />1999
<br />35,000
<br />4.90%
<br />42,123
<br />77,123
<br />264,161
<br />4,208
<br />191,246
<br />3.48
<br />2000
<br />2000
<br />40,000
<br />5.00%
<br />40,408
<br />80,408
<br />264,161
<br />4,208
<br />187,961
<br />3.34
<br />2001
<br />2001
<br />40,000
<br />5.15%
<br />38,408
<br />78,408
<br />264,161
<br />4,208
<br />189,961
<br />3.42
<br />2002
<br />2002
<br />40,000
<br />5.25%
<br />36,348
<br />76,348
<br />264,161
<br />4,208
<br />192,021
<br />3.52
<br />2003
<br />2003
<br />45,000
<br />5.35%
<br />34,248
<br />79,248
<br />264,161
<br />4,208
<br />189,121
<br />3.39
<br />2004
<br />2004
<br />45,000
<br />5.45%
<br />31,840
<br />76,840
<br />264,161
<br />4,208
<br />191,529
<br />3.49
<br />2005
<br />2005
<br />50,000
<br />5.65%
<br />29,388
<br />79,388
<br />264,161
<br />4,208
<br />188,981
<br />3.38
<br />2006
<br />2006
<br />50,000
<br />5.75%
<br />26,563
<br />76,563
<br />264,161
<br />4,208
<br />191,806
<br />3.51
<br />2007
<br />2007
<br />55,000
<br />5.85%
<br />23,688
<br />78,688
<br />264,161
<br />4,208
<br />189,681
<br />3.41
<br />2008
<br />2008
<br />60,000
<br />5.95%
<br />20,470
<br />80,470
<br />264,161
<br />4,208
<br />187,899
<br />3.34
<br />^ 109
<br />2009
<br />60,000
<br />6.10%
<br />16,900
<br />76,900
<br />264,161
<br />4,208
<br />191,469
<br />3.49
<br />10
<br />2010
<br />65,000
<br />6.20%
<br />13,240
<br />78,240
<br />264,161
<br />4,208
<br />190,129
<br />3.43
<br />2011
<br />2011
<br />70,000
<br />6.30%
<br />9,210
<br />79,210
<br />264,161
<br />4,208
<br />189,159
<br />3.39
<br />2012
<br />2012
<br />75,000
<br />6.40%
<br />4,800
<br />79,800
<br />264,161
<br />80,708
<br />265,069
<br />4,32
<br />765,000 444,254 1,209,254 3,992,098 142,768 3.43
<br />(Avg 1998 - 2011)
<br />Bond Years: 7,473.75
<br />Avg. Maturity: 9.77
<br />NIC 6.12%
<br />Annual interest
<br />444,254
<br />Discount@ 1.75%
<br />13,388
<br />Total interest
<br />457,641
<br />Available Revenue - l two - GOmolnea 3 stores:
<br />Gross Profit From Sales
<br />946,079
<br />Total Operating Expenses
<br />(898,483
<br />Net Operating Income
<br />47,596
<br />Add Back - Nonoperating Income
<br />51,700
<br />Depreciation
<br />82,645
<br />Bond Interest & Fees (paid off)
<br />13,175
<br />SAV II Rent
<br />69.045
<br />Stores SAV I, SAV II & Stonehouse
<br />I
<br />Comoosition of Issue
<br />Improvement Cost
<br />650,000
<br />Bond Reserve
<br />76,500
<br />Bond Discount
<br />13,388
<br />Costs of Issuance
<br />25.112
<br />Total Issue
<br />765,000
<br />Prepared al• Spengsted Inoorporated (12/9/96) STANUMS S0720F2
<br />
|