|
JAN -09 -97 15130 FROM:SPRINGSTED INC
<br />ID:6122233093
<br />To
<br />Annual
<br />PF
<br />811/96 -
<br />7/31/97
<br />61,380
<br />$10.50
<br />8/1197 -
<br />7/31/02
<br />67,840
<br />$11.50
<br />8/1/02 -
<br />7/31/07
<br />74,301
<br />$12.50
<br />8/1/07
<br />7/31/11
<br />80,762
<br />City of St. Anthony,
<br />Minnesota
<br />_
<br />Liquor Store Revenue
<br />Loan
<br />Tires Plus Site -15
<br />Year Amortization
<br />Loan Dated
<br />211/97
<br />Mature
<br />12/1
<br />Reserve
<br />Rev.
<br />Mat.
<br />Total
<br />Available
<br />Income
<br />Annual
<br />Cumulative
<br />Annual
<br />Year
<br />Year
<br />Principa l
<br />Rae
<br />Interest
<br />D/S
<br />Revenue'
<br />S.50o,6
<br />Sumtus
<br />Surplus
<br />Coverage
<br />(1)
<br />(2)
<br />(3)
<br />(4)
<br />(5)
<br />(6)
<br />O
<br />(8)
<br />(9)
<br />(10)
<br />(11)
<br />1997
<br />1997
<br />25,000
<br />4.50%
<br />32,600
<br />57,600
<br />58,418
<br />0
<br />818
<br />818
<br />1.01
<br />1998
<br />1998
<br />30,000
<br />4.75%
<br />37,995
<br />67,995
<br />67,840
<br />0
<br />(155)
<br />663
<br />1.00
<br />1999
<br />1999
<br />30,000
<br />4.90%
<br />36,570
<br />66,570
<br />67,840
<br />0
<br />1,270
<br />1,933
<br />1.02
<br />2000
<br />2000
<br />30,000
<br />5.00%
<br />35,100
<br />65,100
<br />67,840
<br />0
<br />2,740
<br />4,673
<br />1.04
<br />2001
<br />2001
<br />35,000
<br />5.15%
<br />33,600
<br />68,600
<br />67,840
<br />0
<br />(760)
<br />3,913
<br />0.99
<br />2002
<br />2002
<br />40,000
<br />5.25%
<br />31,798
<br />71,798
<br />69,994
<br />0
<br />(1,804)
<br />2,109
<br />0.97
<br />2003
<br />2003
<br />45,000
<br />5.35%
<br />29,698
<br />74,698
<br />74,301
<br />0
<br />(397)
<br />1,713
<br />0.99
<br />2004
<br />2004
<br />45,000
<br />5.45%
<br />27,290
<br />72,290
<br />74,301
<br />0
<br />2,011
<br />3,724
<br />1.03
<br />2005
<br />2005
<br />50,000
<br />5.65%
<br />24,838
<br />74,838
<br />74,301
<br />0
<br />(537)
<br />3,187
<br />0.99
<br />2006
<br />2006
<br />50,000
<br />5.75%
<br />22,013
<br />72,013
<br />74,301
<br />0
<br />2,289
<br />5,476
<br />1.03
<br />2007
<br />2007
<br />60,000
<br />5.85%
<br />19,138
<br />79,138
<br />76,455
<br />0
<br />(2,683)
<br />2,793
<br />0.97
<br />2008
<br />2008
<br />65,000
<br />5.95%
<br />15,628
<br />80,628
<br />80,762
<br />0
<br />135
<br />2,928
<br />1.00
<br />2009
<br />2009
<br />70,000
<br />6.10%
<br />11,760
<br />81,760
<br />80,762
<br />0
<br />(998)
<br />1,930
<br />0.99
<br />2010
<br />2010
<br />70,000
<br />6.20%
<br />7,490
<br />77,490
<br />80,762
<br />0
<br />3,272
<br />5,202
<br />1.04
<br />2011
<br />2011
<br />50,000
<br />6.30%
<br />3,150
<br />53,150
<br />53,841
<br />0
<br />691
<br />5,893
<br />1.01
<br />695,000 368,665 1,063,665 1,069,558 0 5,893 1.01
<br />(Avg 1998 - 2011)
<br />Bond Years: 6,299.17
<br />Avg. Maturity: 9.06
<br />NIC 5.85%
<br />Annual Interest 368,665
<br />Discount 1.75% 0
<br />Total Interest 368,665
<br />Available Revenue - Scheduled Lease Pavments
<br />Base
<br />From
<br />To
<br />Annual
<br />$9.50
<br />811/96 -
<br />7/31/97
<br />61,380
<br />$10.50
<br />8/1197 -
<br />7/31/02
<br />67,840
<br />$11.50
<br />8/1/02 -
<br />7/31/07
<br />74,301
<br />$12.50
<br />8/1/07
<br />7/31/11
<br />80,762
<br />Composition of Issue
<br />Purchase Price
<br />675,000
<br />Bond Reserve
<br />0
<br />Bond Discount
<br />0
<br />Costs / Legal
<br />20.000
<br />Total Issue
<br />695,000
<br />Based on Current Lease Schedule
<br />" This schedule demonstrates the amount that can be supported by Tires Plus lease payments.
<br />Actual bond issues will require additional reserves and costs plus a coverage factor of 1.5 - 2.0 times.
<br />Prepared by: Springsted Inoorporeted (176!97) STANLOJQS
<br />
|