|
01/20/99 17:07 FAX 15152436994 PFM DES MOINES Cj007/007
<br /> City of Mounds View,Minnesota =STT 3
<br /> Proposed Taxable TIP Bonds,Series 1999
<br /> 411 SOURCES&USES DEBT SERVICE SCHEDULE
<br /> SOURCES Debt Annual
<br /> Date Principal Coupon Interest Service Debt Service
<br /> Par Amount of Bunds 2,305,000.00
<br /> Accrued Interest
<br /> 'Other Monies 2/1/00 99,544 99,544
<br /> 8/1100 80,000 5.350% 66,363 146,363 245,906
<br /> Total Sources 2,305,000.00 2/1/01 64,223 64,223
<br /> 8/1/01 135,000 5.370% 64,223 199,223 263,445
<br /> 2/1/02 60,598 60,598
<br /> USES 8/1/02 145,000 5.440% 60,598 205,598 266,196
<br /> 2/1/03 56,654 56,654
<br /> Deposit to TIP Project 2,253,650.00 8/1/03 150,000 5.460% 56,654 206,654 263,308
<br /> Deposit to Reserve Account 2/1/04 52,559 52,559
<br /> Capitalized Interest Account - 0.00 8/1/04 160,000 5.510% 52,559 212,559 265,118
<br /> Municipal Bond insurance 2/1/05 48,151 48,151
<br /> Underwriters'Discount($10.00 per bond) 23,050.00 8/1/05 165,000 5.590% 48,151 213,151 261,302
<br /> Costs of Issuance 28,300.00 2/1/06 43,539 43,539
<br /> Accrued Interest 8/1/06 175,000 5.640% 43,539 218,539 262,078
<br /> Rounding Amount 2/1/07 38,604 38,604
<br /> 8/1/07 185,000 5.710% 38,604 223,604 262,208
<br /> Total Uses 2,305,000.00 2/1/08 33,322 33,322
<br /> 8/1/08 195,000 5.790% 33,322 228,322 261,645
<br /> 2/1/09 27,677 27,677
<br /> ASSUMPTIONS 8/1/09 210,000 5.890% 27,677 237,677 265,354
<br /> 2/1/10 21,493 21,493
<br /> 4110
<br /> Dated Date 5/1/99 8/1/10 220,000 6.000% 21,493 241,493 262,985
<br /> Delivery Date 5/1199 2/1/11 14,893 14,893
<br /> First interest Date 2/1/00 8/1/11 235,000 6.100% 14,893 249,893 264,785
<br /> First Principal Date 8/1/00 2/1/12 7,725 7,725
<br /> Last Principal Date 8/1/12 8/1112 250,000 6.180% 7,725 257,725 265,450
<br /> 2/1/13
<br /> 8/1/13
<br /> 2/1/14
<br /> 8/1/14
<br /> 2/1/15
<br /> Arbitrage Yield 5.85161% 8/1/15
<br /> TIC 6.01403% 2/1/16
<br /> AIC 6.21666% 8/1/16
<br /> Average Life _ 8.16 Years 2/1/17
<br /> 8/1/17
<br /> -Assumes interest payment is capitalized 2/1/18
<br /> 8/1/18
<br /> 2/1/19
<br /> 8/1/19
<br /> 2/1/20
<br /> 8/1/20
<br /> 2/1/21
<br /> 2,305,000 1,104,778 3,409,778 3,409,778
<br /> Scale: January 15,1999 Treasury&75bps
<br /> S
<br /> Prepared by Public Financial Management,Inc. 1/20/99 Mermaid TiF Cashflow.xls
<br />
|