Rate and Balance Variance Analysis   Incorporated Village of Munsey Park Bond Issue Variance Analysis - Original vs Current Plan Original Plan   Current Plan             Average Interest   Average Interest             Prinbal o/s Expense   Prinbal o/s Expense   Balance Change Rate Change Total Change Check Year 1  $3,000,000  $               113,700 3.79000%  $2,000,000  $75,000 3.7500%  $37,900  $800  $38,700  $38,700 Year 2 3,000,000 113,700 3.79000% 3,000,000 120,000 4.0000% - -6,300 -6,300 -6,300 Year 3 2,830,000 108,389 3.83000% 2,765,000 117,513 4.2500% 2,490 -11,613 -9,124 -9,124 Year 4 2,655,000 103,014 3.88000% 2,530,000 110,055 4.3500% 4,850 -11,891 -7,041 -7,041 Year 5 2,475,000 97,268 3.93000% 2,285,000 101,683 4.4500% 7,467 -11,882 -4,415 -4,415 Year 6 2,290,000 90,913 3.97000% 2,030,000 92,365 4.5500% 10,322 -11,774 -1,452 -1,452 Year 7 2,095,000 84,219 4.02000% 1,765,000 82,073 4.6500% 13,266 -11,120 2,147 2,147 Year 8 1,895,000 76,937 4.06000% 1,495,000 71,013 4.7500% 16,240 -10,316 5,924 5,925 Year 9 1,690,000 69,290 4.10000% 1,215,000 58,928 4.8500% 19,475 -9,113 10,363 10,363 Year 10 1,475,000 61,065 4.14000% 925,000 45,788 4.9500% 22,770 -7,493 15,278 15,278 Year 11 1,250,000 52,125 4.17000% 625,000 31,563 5.0500% 26,063 -5,500 20,563 20,563 Year 12 1,020,000 42,840 4.20000% 316,000 16,274 5.1500% 29,568 -3,002 26,566 26,566 Year 13 780,000 32,916 4.22000% -32,916       - 32,916 32,916 Year 14 530,000 22,525 4.25000% -22,525       - 22,525 22,525 Year 15 270,000 11,556 4.28000% -11,556       - 11,556 11,556 Calc Rounding           32   32 32    $27,255,000  $1,080,457 3.96425%  $20,951,000  $922,252 4.40%  $257,439  $(99,202)  $158,237  $158,237   Download PDF: 2006 Bond Detail   Back