|
Midwest Consortium of Municipal Ut titles-Series 2005-8 (
<br /> I
<br /> Elk River-Substation&Feeders
<br /> Variable Rate Financing Projection
<br /> Financing Term(yrs) 15
<br /> Pmts per Yr 12 2 Pen per Yr
<br /> Financing Size 53,560,000 00 LOC+Liqurdny Fee 0 600%
<br /> 11111111 Prop Share COI"' (£55,377 78) Administrative Fee 0 150%
<br /> Prop Share Exp Fund $0 00 Remarketing Fee 0 100%
<br /> Legal Fees incl 53,504,622 Project Prop Share Yrly Trustee Fee(mit) 0 006% 8 47 yrs Wtd Avg Mal
<br /> Net Finance •Proceeds $3,504,622 22 +lyr Cap Int+Fees Prop Share Yrly Rating Fee(inn) 0 008% 3 837% All-in Yield
<br /> So 00
<br /> Pint Variable Rate Financing Projection Principal I Investment I Total Total Annual 3 837%
<br /> Date # Principal I Rate' 1 Interest(Act/Act)1Balance Total Fees" Earnings(est)" Debt Service Debt Service Present Value
<br /> 16yr aero i3MA++rip FYE Mo 9
<br /> 5/12011 68 0 00 2 945% 6,027 16 2,490,000 00 1.840 52 - 7,867.68 6,332 27
<br /> 6/12011 69 0 00 2 945% 6,228 07 2,490,000 00 1,881 97 - 8,110.04 6.506 53
<br /> I
<br /> 7/12011 70 0 00 2 945% 6,027 16 2,490,000 00 1.840 52 - 7,867.68 6,291 97
<br /> 8/1/2011 71 0 00 2 945% 6,228 07 2,490,000 00 1.881 97 8,110.04
<br /> 118,110.046,465 12
<br /> 9/1/2011 72 110,000 00 2945% 6,228 07 2,380,000 00 1,861 97 312,605.02 93,854 17
<br /> 10/12011 73 0 00 2 945% 5,760 90 2,380,000 00 1.762 67 - 7,523.57 5,959 42
<br /> 11/1/2011 74 0 00 2 945% 5,952 93 2,380,000 00 1.802 29 - 7,755.22 6,123 33
<br /> I
<br /> 12/1/2011 75 0 00 2 945% 5,760 90 2,380,000 00 1,762 67 - 7,523.57 5,921 49
<br /> 1/1/2012 76 0 00 2945% 5.952.93 2.380,000 00 7,802 29 7,755.22 6,064 36
<br /> 2/1/2012 77 0 00 2945% 5.952.93 2,380,000 00 1,602 29 7,755.22
<br /> 117,273.586,064 96
<br /> 3112012 78 110,000 00 2945% 5,553 66 2,270,000 00 1,719 92 91,421 32
<br /> 4/1/2012 79 0 00 2 945% 5,662 29 2,270,000 00 1,719 42 - 7,381 71 5,736 11
<br /> I
<br /> 5/1/2012 80 0 00 2 945% 5,479 63 2,270,000 00 1,681 73 - 7,161.36 5,547 15
<br /> 6/1/2012 81 0 00 2945% 5,662.29 2.270,000 00 1,719 42 7,381.71 5,699 60
<br /> 7/1/2012 82 0 00 2945% 5,479 63 2,270,000 00 1,681 73 7,161.36 5,511 84
<br /> 8/12012 83 0 00 2945% 5,662 29 2,270,000 00 1.719 42 7,381.71 5.663 32
<br /> 9/1/2012 84 115,000 00 2 945% 5,662 29 2,155,000 00 1.719 42 - 122,361.71 314,435 94 93,593.22
<br /> 10/1/2012 85 0 00 2 945% 5,202 03 2,155,000 00 1,600 50 - 6,802.53 5,185.75
<br /> I
<br /> 11/1/2012 86 0 00 2945% 5,375 43 2,155,000 00 1,636 28 - 7,011.71 5.328 18
<br /> 1211/2012 87 0 00 2945% 5.202 03 2,155,000 00 1,600 50 6,602.53 5,152 74
<br /> 1/1/2013 88 0 00 2945% 5.375 43 2,155,000 00 1,636 28 7,011 71 5,294 26
<br /> 2/1/2013 89 0 00 2 945% 5,375 43 2,155.000 00 1,636 28 - 7,011 71 5,277 39
<br /> 3/1/2013 90 115 000 00 2 945% 4.868.53 2.040,000 00 1,531 70 - 121,400.23 91,081.04
<br /> 4/1/2013 91 0 00 2945% 5,102 52 2,040,000 00 1,556 01 - 6,658.53 4,979.67
<br /> 5/1/2013 92 U 00 2945% 4,937 92 2,040.000 00 1,522 06 6,459.98 4,815 78
<br /> 6712013 93 0 00 2945% 5,102 52 2,040.000 00 1,556 01 6,658.53 4,947 97
<br /> 7/1/2013 94 0 00 2 945% 4,937 92 2,040,000 00 1,522 06 - 6,459.98 4,785 13
<br /> 8/1/2013 95 0 00 2 945% 5,102.52 2.040,000 00 1,556 01 - 6,658.53 4,916 48
<br /> I
<br /> 9/12013 96 120,000 00 2 945% 5,102 52 1,920.000 00 1,556 01 - 126,658.53 315.594 50 93.223 08
<br /> 10/1/2013 97 0 00 2945% 4,647 45 1,920,000 00
<br /> 1,437 13 6,084.58 4,464 09
<br /> 11/1/2013 98 0 00 2945% 4,802.37 7,920.000 00 1,469 09 6,271.46 4,586 53
<br /> 12/1/2013 99 0 00 2.945% 4,647 45 1,920,000.00 1,437 13 -
<br /> 6,084.58 4,435 68
<br /> 1/1/2014 100 0 00 2 945% 4,802 37 1,920,000 00 1,469 09 - 6,271.46 4,557 34
<br /> M 2/12074 101 0 00 2945%
<br /> 3/1/20144,802 37 1.920.000 00 1.469 09 6,271.46 4.542 81
<br /> 102 120 000 00 2945%
<br /> 4,337 62 1,800,000 00 1,373 21 125,710.83 90,769 99
<br /> 4/12014 103 0 00 2945% 4,502 22 1,800,000 00 1.382 17 5,884.39 4.235 30
<br /> 5/1/2014 104 0 00 2945% 4,356 99 1,800,000 00 1,352 21 5,708.20 4,096 11
<br /> 6/1/2014 105 0 00 2 945% 4,502 22 1,800,000 00 1,382 17 - 5,884 39 4,208 34
<br /> 7/1/2014 106 0 00 2 945% 4,356 99 1,800,000 00 1,352 21 - 5,709 20 4,070 04
<br /> 2014 107 000 2.945% 4,50222 1,800,000 00 1,38217 - 5,88439 4,18156
<br /> 9/1/2014 108 125,000 00 2945% 4,502 22 1,675,000 00 1,382 17 730,684.39 376,650 33 92,71244
<br /> 10/1/2014 109 0 00 2945% 4.054 42 1,675,000 00 1,263 75 5,318.17 3,755 14
<br /> 11/1/2014 110 0 00 2 945% 4,189 57 1,675,000 00 1,29163 - 5,481.20 3,857 91
<br /> 12/1/2014 111 0 00 2 945% 4,054 42 1,675,000 00 1,263 75 - 5,318 17 3,731 24
<br /> 1/12015 112 0 00 2 945% 4,189 57 1,675,000 00 1,291 63 - 5,481.20 3,633 36
<br /> 2/1/2015 113 0 00 2945% 4,189 57 1,675,000 00 1,291 63 5,461.20
<br /> 129,992.113,821 14
<br /> 3112015 114 725,000 00 2945% 3,784 12 1,550,000 00 1,207 99 90,333 26
<br /> 4/1/2015 115 0 00 2 945% 3,876 91 1,550,000 00 1,201 09 - 5,078.00 3,517 52
<br /> 5/1/2015 116 0 00 2 945% 3,751 85 1,550,000 00 1,175 29 - 4,927.14 3,402 14
<br /> 6/1/2015 117 0 00 2945% 3,876 91 7,550,1700 00 1,201 09 - 5,076 00 3,495 13
<br /> 7/1/2015 118 0 00 2945% 3,751 85 1.550,000 00 1,175 29 4,927.14 3,380 49
<br /> 8/1/2015 119 0 00 2945% 3,876 91 1.550,000 00 1,201 09 5,078 00
<br /> 135,076.003,472 89
<br /> 9/1/2015 120 130,000 00 2.945% 3,876 91 1,420.000 00 1,201 09 317,238 33 92,086 48
<br /> 10/1/2015 121 0 00 2.945% 3,437 18 1,420,000 00 1,083 28 - 4,520.46 3,071 90
<br /> 11/1/2015 122 0 00 2 945% 3,551 75 1.420,000 00 1,106 92 - 4,658 67 3.155 73
<br /> I
<br /> 12/1/2015 123 0 00 2945% 3,437 18 1,420.000 00 1,083 28 - 4,520.46 3.052 35
<br /> 1/1/2016 124 0 00 2945%
<br /> 3,551 75 1,420,000 00 1,106 92 4,658.67 3.135 65
<br /> 2/1/2016 125 0 00 2945% 3,551 75 1,420,000 00 1,106 92 4,658.67 3.725 65
<br /> 3/1/2016 126 130,000 00 2 945% 3.313 53 1,290,000 00 1,057 77 - 134,371.30 89.866 61
<br /> 4/1/2016 127 0 00 2 945% 3.217 77 1,290,000 00 1,010 94 - 4,228 71 2.819 12
<br /> I
<br /> 5/72016 128 0 00 2945% 3,173 98 1,290,000 00 989 52 - 4,103.50 2.726 92
<br /> 6/1/2016 129 0 00 2945% 3,217 77 1.290,000 00 1,010 94 4,226 77 2.801 17
<br /> 7/1/2016 130 0 00 2945% 3,173 98 1,290,000 00 989 52 4,103.50 2,709 57
<br /> 8/1/2016 131 0 00 2 945% 3,217 77 1.290,000 00 1,010 94 - 4,228 71 2,783 34
<br /> 9/1/2016 132 135,000 00 2 945% 3,217 77 1,155.000 00 1,010 94 - 139,228 71 317,510 07 91,348 45
<br /> I
<br /> 10/1/2016 133 0 00 2945% 2,788 09 1,155,000 00 894 17 - 3,682.26 2,408 24
<br /> 11/1/2016 134 0 00 2.945% 2.861.03
<br /> 1,155,000.00 913 34 3,794 37 2,473 65
<br /> 12/1/2016 135 0 00 2945% 2.788 09 1,155,000 00 894 17 3,682.26 2,392 91
<br /> MOTE.Interest computed at assumed rate shown,ecte i rata will vary over term
<br /> Lawrenson Semcec Inc Page 2 8/11/2005 Model MMUA'058 Fnanarg Ell,River 83560K 15yr ver xis
<br />
|