|
03/05/37 15:54 FAX 612 223 3002 SPRINGSTBD INC 002/003
<br /> • City of St. Anthony, Minnesota
<br /> Liquor Store Revenue Loan
<br /> Tires Plus Site-15 Year Amortization
<br /> Loan Dated +4/1/97 Schedule 14
<br /> Mature 1211
<br /> Reserve
<br /> Rev. Mat. Total Available Income Annual Cumulative Annual
<br /> Year Year PrInal al Rate Interest DIS Revenue* 8.5096 Surplus Sumlus Coverage_
<br /> (1) (2) (3) (4) (8) (9} (10) (11}
<br /> 1997 1997 18,000 5.00% 24,233 40,233 40,920 0 667 687 1.02
<br /> 1998 1998 32,000 5.00% 35,550 67,550 87,840 0 290 977 1.00
<br /> 1999 1999 34,000 5.00% 33,950 67,950 67,840 0 (116) 887 1.00
<br /> 2000 2000 36,000 5.00% 32,250 88,250 67,840 0 (410) 457 0.99
<br /> 2001 2001 37,000 5.00% 30,450 67,450 87,840 0 390 847 1.01
<br /> 2002 2002 41,000 5.00% 28,800 69,600 69,994 0 394 1,240 1.01
<br /> 2003 2003 48,000 5.00% 26,550 74,550 74,301 0 (249) 991 1.00
<br /> 2004 2004 50,000 5.00% 24,150 74,150 74,301 0 151 1,142 1.00
<br /> 2005 2005 53,000 5.00% 21,650 74,650 74,301 0 (349) 793 1.00
<br /> 2006 2006 55,000 5.00% 19,000 74,000 74,301 0 301 1,094 1.00
<br /> 2007 2007 60,000 5.00% 16,250 78,250 76,455 0 205 1,299 1.00
<br /> 2008 2008 68,000 5.00% 13,250 81,250 80,762 0 (488) 811 0.99
<br /> 2009 2009 71,000 5.00% 9,850 80,850 80,782 0 (88) 723 1.00
<br /> 2010 2010 75,000 5.00% 6,300 81,300 80,782 0 (538) 185 0.99
<br /> 2011 2011 51,000 5.00% 2,550 53,550 53,841 0 291 478 1.01
<br /> 727,000 324,583 1,051,583 1,052,060 0 476 1.00
<br /> (Avg 1998-2011)
<br /> Bond Years: 6,491.67 Annual Interest 324,583
<br /> Avg. Maturity: 8.93. Discount C 1.75% 0
<br /> NIC 5.00% Total Interest 324,583
<br /> • Available Revenue-scheduled Lease Payments Composition of Issue
<br /> Base From To Annual Purchase Price 725,000
<br /> $9.50 8/1196 - 7/31/97 61,380 Bond Reserve 0
<br /> $10.50 8/1197 - 7/31/02 67,840 Bond Discount 0
<br /> $11.50 811102 - 7/31/07 74,301 Costs/Legal 2.000
<br /> $12.50 8/1/07 - 7/31/11 80,762 Total Issue 727,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 /> •
<br /> Prepared by:SpdnpsW Inearporatad(3/5197) File 60720F2 STANLQ.XLS
<br />
|