Spreadsheet: 6daaab6f-075d-4753-b84c-815396a3397d
Sheet: Fund 47 Excess Balance

 |  | Excess OPEB (Fund 47) Balance - Payable 2013 [NAME]
 |  | Calculated Excess Balance (7) = (1)-(2)-(3)-(4)-(6)
 |  | (1) | (2) | (3) | (4) | (5) | (6) | (7)
 |  | Unreserved | Pay 11 | Pay 12 | Pay 12 | Pay 13 | Pay 13 | Est. Excess
 |  | Balance | [NAME] | [NAME] | Retainage | Required | Required | Fund 47
 |  | Ending FY 11 | Reduction | Reduction | Amount | Debt Service | 5% Excess | Balance
4 | [NAME] | 61663.92 | 0 | 0 |  | 157720.5
6 | SOUTH ST. PAUL | 1088.17 | 0 | 0 |  | 755485.5
11 | ANOKA-HENNEPIN | 347975.24 | 0 | 161906.6899999999 |  | 2217096
12 | CENTENNIAL | 61415.49 | 0 | 11618.58999999997 |  | 651672
14 | FRIDLEY | 16256.35 | 0 | 0 |  | 593646.9
15 | ST. FRANCIS | 17381.62 | 0 | 0 |  | 448302.75
16 | SPRING LAKE PARK PUBLIC SCHOOLS | 18158.05 | 0 | 0 |  | 308931
31 | BEMIDJI | 275121.85 | 0 | 0 |  | 572607
77 | MANKATO | 90989.91 | 0 | 0 |  | 2405007.15
93 | CARLTON | 18590.22 | 0 | 0 |  | 233173.5
94 | CLOQUET | 18583.23 | 0 | 0 |  | 550194.75
99 | ESKO | 27165.51 | 0 | 14005.14999999999 |  | 119952
110 | WACONIA | 48714.47 | 0 | 6167.469999999972 |  | 373891.875
112 | CHASKA | 186969.19 | 50000 | 74844.42000000004 |  | 770227.5
116 | PILLAGER | 6545.7 | 0 | 0 |  | 210556.5
138 | NORTH BRANCH | 25935.62 | 0 | 0 |  | 432718.65
152 | MOORHEAD | 227219.29 | 0 | 142430.5900000001 |  | 1376956.875
166 | COOK COUNTY | 3897.45 | 0 | 0 |  | 90720
181 | BRAINERD | 68891.34 | 0 | 0 |  | 2053290.75
182 | CROSBY-IRONTON | 45107.39 | 0 | 0 |  | 715349.25
191 | BURNSVILLE | 648396.05 | 0 | 0 |  | 1663882.5
192 | FARMINGTON PUBLIC SCHOOL DISTRICT | 20883.4 | 0 | 521.9799999999814 |  | 606415.9500000001
196 | ROSEMOUNT-APPLE | 382903.05 | 0 | 142154.5800000001 |  | 2624146.875
197 | WEST ST. PAUL-ME | 66656.47 | 0 | 3636.800000000047 |  | 697410
199 | INVER GROVE | 53671.87 | 0 | 0 |  | 643988.625
206 | ALEXANDRIA | 45974.26 | 0 | 0 |  | 749361.9
213 | [NAME] | 1978.63 | 0 | 0 |  | 51849
241 | [NAME] | 27421.35 | 0 | 0 |  | 309676.5
252 | CANNON FALLS | 9018.84 | 0 | 0 |  | 132352.5
256 | RED WING | 17387.77 | 0 | 78774.1800000002 |  | 2465358
270 | HOPKINS | 26068.15 | 0 | 0 |  | 968076.375
271 | BLOOMINGTON | 24249.14 | 0 | 0 |  | 954561.5730000001
272 | EDEN PRAIRIE | 570506.6 | 0 | 473086.01 |  | 1122003.75
276 | MINNETONKA | 1163006 | 0 | 0 |  | 548058
277 | WESTONKA | 31093.6 | 0 | 0 |  | 577156.65
278 | ORONO PUBLIC SCHOOL DISTRICT | 33737.81 | 0 | 0 |  | 448526.4
279 | OSSEO | 101604.43 | 0 | 12310.58999999997 |  | 1008000
280 | RICHFIELD | 33775.08 | 0 | 0 |  | 1268459.073
281 | ROBBINSDALE | 76967.91 | 0 | 0 |  | 1962066.75
282 | ST. ANTHONY-NEW | 4350.85 | 0 | 0 |  | 287432.25
283 | ST. LOUIS PARK | 116130.62 | 0 | 0 |  | 874739.25
284 | WAYZATA | 16291.65 | 0 | 0 |  | 1208064.375
286 | BROOKLYN CENTER | 3286.19 | 0 | 0 |  | 359100
300 | LACRESCENT-HOKAH | 30866.55 | 0 | 17704.95999999999 |  | 171748.5
314 | BRAHAM | 7239.76 | 0 | 0 |  | 156867.9
316 | GREENWAY | 34268.44 | 0 | 149363.6499999999 |  | 1663756.5
317 | DEER RIVER | 6140.59 | 0 | 0 |  | 142340.625
318 | GRAND RAPIDS | 99641.99 | 0 | 0 |  | 2017128.75
319 | NASHWAUK-KEEWATIN SCHOOL DISTRICT | 13704.54 | 0 | 0 |  | 323478.75
333 | [NAME] PUBLIC SCHOOL DISTRICT | 9689.29 | 0 | 0 |  | 139448.925
345 | NEW LONDON-SPICE | 9023.28 | 0 | 0 |  | 261114
381 | LAKE SUPERIOR PUBLIC SCHOOL DIST | 68642.3 | 0 | 12680.52000000002 |  | 832188
413 | MARSHALL | 5682.62 | 0 | 0 |  | 133329
482 | LITTLE FALLS | 9800.13 | 0 | 0 |  | 267763.125
499 | LEROY | 20448.68 | 0 | 8039.339999999997 |  | 113554.875
548 | PELICAN RAPIDS PUBLIC SCHOOL DIST | 18795.8 | 0 | 6225.920000000013 |  | 142761.15
549 | PERHAM | 2619.12 | 0 | 11890.99000000001 |  | 98437.5
564 | THIEF RIVER FALL | 23514.19 | 0 | 0 |  | 250215
621 | MOUNDS VIEW | 85994.71 | 0 | 0 |  | 2665517.4
622 | NORTH ST PAUL-MA | 226826.69 | 0 | 0 |  | 3135292.125
623 | ROSEVILLE | 58027 | 0 | 0 |  | 1420697.25
624 | WHITE BEAR LAKE | 21602.83 | 0 | 0 |  | 2661842.4
690 | WARROAD PUBLIC SCHOOL DISTRICT | 6757.31 | 0 | 16810.64 |  | 512130.15
695 | CHISHOLM | 2504.09 | 0 | 0 |  | 551158.65
704 | PROCTOR | 34135.67 | 0 | 0 |  | 449064
706 | VIRGINIA | 616857.67 | 0 | 0 |  | 448474.95
712 | MOUNTAIN IRON-BU | 14496.23 | 0 | 0 |  | 156012.15
727 | BIG LAKE PUBLIC SCHOOL DISTRICT | 10447.84 | 0 | 0 |  | 406620.9
728 | ELK RIVER | 18790.39 | 0 | 0 |  | 321980.4
738 | HOLDINGFORD | 3138.2 | 0 | 0 |  | 182054.25
742 | ST. CLOUD | 31086.84 | 0 | 0 |  | 2242983.75
750 | ROCORI | 49943.03 | 0 | 8269.099999999977 |  | 418884.375
769 | [NAME] | 16140.13 | 0 | 6113.789999999994 |  | 101346
831 | FOREST LAKE | 24769.6 | 0 | 0 |  | 530976.6
832 | MAHTOMEDI | 12113.01 | 0 | 0 |  | 346980.9
834 | STILLWATER | 208445.07 | 0 | 65720 |  | 1490236.125
861 | WINONA | 86039.28 | 0 | 0 |  | 787857
877 | BUFFALO | 26965.79 | 0 | 0 |  | 518687.4
881 | MAPLE LAKE | 35071.31 | 0 | 0 |  | 82831.875
883 | ROCKFORD | 0 | 0 | 0 |  | 299885.25
912 | MILACA | 12022.55 | 0 | 0 |  | 337326.15
2071 | LAKE CRYSTAL-WEL | 3833.85 | 0 | 0 |  | 187976.25
2134 | UNITED SOUTH CENTRAL SCHOOL DIST. | 584.65 | 0 | 0 |  | 178964.1
2137 | KINGSLAND | 16211.03 | 0 | 7307.899999999994 |  | 90371.40000000001
2149 | CHISAGO LAKES | 2964.23 | 0 | 0 |  | 81126.15000000001
2154 | EVELETH-GILBERT | 12139.25 | 0 | 0 |  | 176694
2164 | DILWORTH-GLYNDON | 99082.5 | 0 | 0 |  | 156255.75
2170 | STAPLES-MOTLEY | 9735.83 | 0 | 0 |  | 144978.75
2190 | [NAME] | 10782.85 | 0 | 0 |  | 203589.75
2198 | FILLMORE CENTRAL | 8404.57 | 0 | 0 |  | 114726.15
2365 | G.F.W. | 0 | 0 | 0 |  | 108701.25
2711 | MESABI EAST | 108159.84 | 0 | 0 |  | 1319367
2853 | LAC QUI PARLE VA | 7253.89 | 0 | 0 |  | 181198.5