|
| |
| Comparitive Calculations |
| |
Incorporated Village of Munsey Park
Bond Issue Variance Analysis - Original vs. Current Plan
Comparative Calculations
| |
Old Plan |
New Plan |
Difference |
|
Principal |
$ 3,000,000 |
$ 3,000,000 |
$ 0.00 |
|
Interest |
$ 1,080,489 |
$ 922,252 |
$ 158,237 |
|
Total P + I |
$ 4,080,489 |
$ 3,922,252 |
$ 158,237 |
|
Original Plan |
Principal Cash |
|
|
Effective Interest |
|
Interest |
|
WA |
|
|
Flows |
|
Prin Bal |
Rate |
|
Expense |
|
Rate |
|
Year 1 |
3,000,000$ |
$ |
3,000,000 |
0.0379 |
$ |
113,700 |
|
0.0042 |
|
Year 2 |
- |
|
3,000,000 |
0.0379 |
|
113,700 |
|
0.0042 |
|
Year 3 |
(170,000) |
|
2,830,000 |
0.0383 |
|
108,389 |
|
0.0040 |
|
Year 4 |
(175,000) |
|
2,655,000 |
0.0388 |
|
103,014 |
|
0.0038 |
|
Year 5 |
(180,000) |
|
2,475,000 |
0.0393 |
|
97,268 |
|
0.0036 |
|
Year 6 |
(185,000) |
|
2,290,000 |
0.0397 |
|
90,913 |
|
0.0033 |
|
Year 7 |
(195,000) |
|
2,095,000 |
0.0402 |
|
84,219 |
|
0.0031 |
|
Year 8 |
(200,000) |
|
1,895,000 |
0.0406 |
|
76,937 |
|
0.0028 |
|
Year 9 |
(205,000) |
|
1,690,000 |
0.0410 |
|
69,290 |
|
0.0025 |
|
Year 10 |
(215,000) |
|
1,475,000 |
0.0414 |
|
61,065 |
|
0.0022 |
|
Year 11 |
(225,000) |
|
1,250,000 |
0.0417 |
|
52,125 |
|
0.0019 |
|
Year 12 |
(230,000) |
|
1,020,000 |
0.0420 |
|
42,840 |
|
0.0016 |
|
Year 13 |
(240,000) |
|
780,000 |
0.0422 |
|
32,916 |
|
0.0012 |
|
Year 14 |
(250,000) |
|
530,000 |
0.0425 |
|
22,525 |
|
0.0008 |
|
Year 15 |
(260,000) |
|
270,000 |
0.0428 |
|
11,556 |
|
0.0004 |
|
|
(270,000) |
|
|
|
|
32 |
|
|
|
Totals |
- |
$ |
27,255,000 |
|
$ |
1,080,489 |
|
|
|
Average |
- |
$ |
1,817,000 |
|
|
|
|
0.0396 |
|
|
|
|
|
Presentation |
$ |
1,080,489 |
$ |
1,080,489 |
[a] |
|
|
|
|
|
diff rounding |
|
- |
|
|
|
Back |
|
|
