|
20
<br />Date Pdnclpal
<br />
<br />9/1/99
<br />9/1/00
<br />9/1/01
<br />9/1/02
<br />9/1/03
<br />9/1/04
<br />9/1/05
<br />911106
<br />9/1/07
<br />9/1/08
<br />9/1/09
<br />9/1/10
<br />9/1/11
<br />9/1/12
<br />9/1/13
<br />9/1/14
<br />9/1/15
<br />9/1/16
<br />9/1/17
<br />9/1/18
<br />TOTAL
<br />
<br />90,000.00
<br />95,000.00
<br />95,000.00
<br />100 000.00
<br />105 000.00
<br />· 110000.00
<br />115000.00
<br />12C 300.00
<br />125 300.00
<br />13C 300.00
<br />135 O00.00
<br />145000.00
<br />150 000.00
<br />160 000.00
<br />165 000.00
<br />175 000.00
<br />185 000.00
<br />190 000.00
<br />200 000.00
<br />210 000.00
<br />
<br /> CITY OF ELK RIVER
<br />BANK QUALIFIED COMPARISON
<br />
<br />BANK QUALIFIED
<br /> Coupon Interest
<br /> 3.80% 132,612.50
<br /> 3.95% 129,192.50
<br /> 4.10% 125,440.00
<br /> 4.20% 121,545.00
<br /> 4.30% 117,345.00
<br /> 4.40% 112,830.00
<br /> 4.45% 107,990.00
<br /> 4.55% 102,872.50
<br /> 4.65% 97,412.50
<br /> 4.70% 91,600.00
<br /> 4.75% 85,490.00
<br /> 4.80% 79,077.50
<br /> 4.90% 72,117.50
<br /> 4.95% 64,767.50
<br /> 5.00% 56,847.50
<br /> 5.00% 48,597.50
<br /> 5.05% 39,847.50
<br /> 5.05% 30,505.00
<br /> 5.10% 20,910.00
<br /> 5.10% 10,710.00
<br />
<br /> Int. Rate
<br />Total P+I Spread
<br />222,612.50 0.05%
<br />224 192.50 0.05%
<br />220 440.00 0.05%
<br />221 545.00 0.05%
<br />
<br />0.05%
<br />0.05%
<br />0.05%
<br />0.05%
<br />0.12%
<br />0.12%
<br />0.12%
<br />0.12%
<br />0.20%
<br />0.20%
<br />0.20%
<br />0.20%
<br />0.20%
<br />0.20%
<br />0.20%
<br />0.20%
<br />
<br />222 345.00
<br />222 E~30.00
<br />222 990.00
<br />222 872.50
<br />222 412.50
<br />221 600.00
<br />220 490.00
<br />224 077.50
<br />222 117.50
<br />224 767.50
<br />221 847.50
<br />223 597.50
<br />224 847.50
<br />220 505.00
<br />220 910.00
<br />220,710.00
<br />
<br />Principal
<br />90,000.00
<br />95,000.00
<br />95,000.00
<br />10C 000.00
<br />105 000.00
<br />110 000.00
<br />115 000.00
<br />
<br />125 000.00
<br />130 000.00
<br />135 000.00
<br />145 000.00
<br />150 000.00
<br />160 000.00
<br />165 000.00
<br />175,000.00
<br />185,000.00
<br />190,000.00
<br />200,000.00
<br />210,000.00
<br />
<br />20 NON-BANK QUALIFIED
<br />
<br />2,800,000.00 1,647,710.00 4,447,710.00 2,800,000.00 1,704,507.50 4,504,507.50
<br />
<br />Coupon Interest Total P+I DIFFERENCE
<br />3.85% 136,539.50 226,539.50 3,927.00
<br />4.00% 133,074.50 228,074.50 3,882.00
<br />4.15% 129,274.50 224,274.50 3,834.50
<br />4.25% 125,332.00 225,332.00 3,787.00
<br />4.35% 121,082.00 226,082.00 3,737.00
<br />4.45% 116,514.50 226,514.50 3,684.50
<br />4.50% 111,61 9.50 226,619.50 3,629.50
<br />4.60% 106,444.50 226,444.50 3,572.00
<br />4.77% 100,924.50 225,924.50 3,512.00
<br />4.82% 94,962.00 224,962.00 3,362.00
<br />4.87% 88,696.00 223,696.00 3,206.00
<br />4.92% 82,121.50 227,121.50 3,044.00
<br />5.10% 74,987.50 224,987.50 2,870.00
<br />5.15% 67,337.50 227,337.50 2,570.00
<br />5.20% 59,097.50 224,097.50 2,250.00
<br />5.20% 50,51.7.50 225,517.50 1,920.00
<br />5.25% 41,41 7.50 226,417.50 1,570.00
<br />5.25% 31,705.00 221,705.00 1,200.00
<br />5.30% 21,730.00 221,730.00 820.00
<br />5.30% 11,130.00 221,130.00 420.00
<br /> 56,797.50
<br />
<br />PV Savings at
<br />$.00%
<br /> 3,740.00
<br /> 3,521.09
<br /> 3,312.39
<br /> 3,115.57
<br /> 2,928.04
<br /> 2,749.43
<br /> 2,579.42
<br /> 2,417.67
<br /> 2,263.87
<br /> 2,063.98
<br /> 1,874.48
<br /> 1,695.01
<br /> 1,522.02
<br /> 1,298.02
<br /> 1,082.29
<br /> 879.57
<br /> 684.99
<br /> 498.62
<br /> 324.50
<br /> 158.29
<br /> 38,709.26
<br />
<br />Cumulative
<br /> Total
<br /> 3,740.00
<br /> 7,261.09
<br /> 10,573.47
<br /> 13,689.05
<br /> 16,617.09
<br /> 19,366.52
<br /> 21,945.93
<br /> 24,363.60
<br /> 26,627.47
<br /> 28,691.45
<br /> 30,565.93
<br /> 32,260.94
<br /> 33,782.96
<br /> 35,080.99
<br /> 36,163.28
<br /> 37,042.85
<br /> 37,727.84
<br /> 38,226.46
<br /> 38,550.96
<br /> 38,709.26
<br /> 38,709.26
<br />
<br />
<br />
|