Spreadsheet: 1df77834-f32e-4f31-99c0-b6a32aed632b
Sheet: REPORT 2 - Summary

 |  |  |  |  |  |  |  |  |  | PERCENT |  | DIFFERENCE
 |  |  |  |  |  |  | CURRENT | PROPOSED | DIFFERENCE | CHANGE | ADM | PER ADM
 |  |  |  |  |  | COMBINED REVENUE BY STRATA:
 |  |  |  |  | 1 | STATE | 9051689745.83361 | 9685561782.120716 | 633872036.2871056 | 0.0700280338904534 | 830024.43 | 763.6787706201678
 |  |  |  |  | 2 | Metro Districts | 4847023131.671917 | 5171258139.613894 | 324235007.9419776 | 0.06689363742114782 | 422598.17 | 767.2418646346188
 |  |  |  |  | 3 | Rural Districts | 3685812843.332469 | 3962602704.991011 | 276789861.6585411 | 0.07509601638055119 | 365649.26 | 756.981872897927
 |  |  |  |  | 4 | MPLS & ST PAUL | 992220645.1583056 | 1051669771.233421 | 59449126.07511497 | 0.05991522789331807 | 72789.15 | 816.7305989301286
 |  |  |  |  |  | OTHER METRO, INNER | 993430919.4970427 | 1067592057.306134 | 74161137.80909097 | 0.07465152971747398 | 86993.01999999999 | 852.4952669661426
 |  |  |  |  |  | OTHER METRO, OUTER | 2861371567.016569 | 3051996311.07434 | 190624744.0577717 | 0.06662005950402591 | 262816.0000000001 | 725.3163584324076
 |  |  |  |  |  | NONMET>=2K | 1842158401.927951 | 1985395776.649525 | 143237374.7215738 | 0.07775518900636647 | 184386.4 | 776.8326444985846
 |  |  |  |  |  | NONMET 1K-2K | 921736663.0512888 | 989924074.8386028 | 68187411.78731394 | 0.07397710704225263 | 93852 | 726.5419147947187
 |  |  |  |  |  | NONMET < 1K | 921917778.3532315 | 987282853.5028819 | 65365075.14965034 | 0.07090119822443189 | 87410.85999999999 | 747.7912372633143
 |  |  |  |  |  | CHARTER | 426043327.5277228 | 458131402.0395046 | 32088074.51178181 | 0.07531645830010993 | 41777 | 768.0799126740027
 |  |  |  |  |  | NONCHARTER FUDGE, COOPS, S DAKOTA | 92810443.3015011 | 93569535.47630611 | 759092.1748050153 | 0.008178952150234347 | 0 | 0
 |  |  |  |  | 12
 |  |  |  |  | 13 | COMBINED LEVIES BY STRATA:
 |  |  |  |  | 14 | STATE | 1973797771.529745 | 1973797771.667865 | 0.1381194591522217 | 6.997649969235474e-11 | 830024.43 | 1.66404089036538e-07
 |  |  |  |  | 15 | Metro Districts | 1293658088.384564 | 1293833928.881779 | 175840.4972147644 | 0.0001359250166590327 | 422598.17 | 0.4160938444545662
 |  |  |  |  | 16 | Rural Districts | 680139683.145181 | 679963842.7860856 | -175840.3590953052 | -0.0002585356559143319 | 407426.26 | -0.4315881825960487
 |  |  |  |  | 17 | MPLS & ST PAUL | 223168926.0326041 | 228117969.120205 | 4949043.087600976 | 0.0221762194924841 | 72789.15 | 67.99149444114921
 |  |  |  |  |  | OTHER METRO, INNER | 288695088.6473293 | 295391780.5748776 | 6696691.92754823 | 0.02319641791942268 | 86993.01999999999 | 76.97964649977929
 |  |  |  |  |  | OTHER METRO, OUTER | 781794073.7046311 | 770324179.1866966 | -11469894.51793444 | -0.01467124771563294 | 262816.0000000001 | -43.6422992433278
 |  |  |  |  |  | NONMET>=2K | 346552505.7543032 | 342162169.8954692 | -4390335.858833969 | -0.01266860226353868 | 184386.4 | -23.81051888227097
 |  |  |  |  |  | NONMET 1K-2K | 165270693.7766007 | 165940463.0084004 | 669769.2317997217 | 0.00405255896550577 | 93852 | 7.136440691724435
 |  |  |  |  |  | NONMET < 1K | 167656596.1742771 | 171924354.6622159 | 4267758.487938821 | 0.02545535687425347 | 87410.85999999999 | 48.82412194478835
 |  |  |  |  |  | CHARTER | 0 | 0 | 0 | 0 | 41777 | 0
 |  |  |  |  |  | NONCHARTER FUDGE, COOPS, S DAKOTA | 659887.4399999983 | -63144.78000000049 | -723032.2199999988 | -1.095690228624446 | 0 | 0
 |  |  |  |  | 25
 |  |  |  |  | 26 | REVENUE BY FUNDING COMPONENT:
 |  |  |  |  | 27 | BASIC | 5000822727.279998 | 5520204270 | 519381542.7200022 | 0.1038592189814534 | 830024.43 | 625.7424769051703
 |  |  |  |  |  | DECLINING ENROLLMENT | 0 | 9507183.839999998 | 9507183.839999998 | 0 | 830024.43 | 11.45410122446637
 |  |  |  |  |  | GIFTED & TALENTED | 11487341.64 | 0 | -11487341.64 | -1 | 830024.43 | -13.83976329467797
 |  |  |  |  |  | EXTENDED TIME | 72139677.13 | 0 | -72139677.13 | -1 | 830024.43 | -86.91271548477192
 |  |  |  |  |  | COMPENSATORY INCLUDING CURRENT PILOT | 456359810.0399997 | 546096797.5599996 | 89736987.51999986 | 0.1966364818850601 | 830024.43 | 108.1136702446214
 |  |  |  |  |  | LEP REGULAR | 33577243 | 36962037 | 3384794 | 0.1008061918603621 | 830024.43 | 4.07794503108782
 |  |  |  |  |  | LEP CONCENTRATION | 8953592.5 | 12976505.6484539 | 4022913.148453899 | 0.4493071522356974 | 830024.43 | 4.846740653710516
 |  |  |  |  |  | SPARSITY | 25040627.06999999 | 26138900.24 | 1098273.170000013 | 0.04385965123516428 | 830024.43 | 1.323181740566375
 |  |  |  |  |  | SMALL SCHOOLS | 15727607.19999999 | 15733460.29973053 | 5853.099730532616 | 0.0003721544959828739 | 830024.43 | 0.007051719827731596
 |  |  |  |  |  | TRANSPORTATION SPARSITY | 61050313.88000005 | 63959705.92000004 | 2909392.039999992 | 0.0476556442562878 | 830024.43 | 3.505188443670256
 |  |  |  |  |  | EQUITY | 93683394.51999998 | 54232545.36000008 | -39450849.1599999 | -0.4211082376138467 | 830024.43 | -47.52974458836097
 |  |  |  |  |  | TRANSITION | 29777252.13999999 | 793606.6691624299 | -28983645.47083756 | -0.9733485593153046 | 830024.43 | -34.91902698675696
 |  |  |  |  |  | OPERATING CAPITAL | 197413824.89 | 197438688.4223518 | 24863.53235185146 | 0.0001259462571362748 | 830024.43 | 0.02995518138165097
 |  |  |  |  |  | Q COMP | 63679791.17000002 | 63679791.17000002 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | OPTIONS: REFERENDUM AID | 524829.87 | 2553241.396768005 | 2028411.526768005 | 3.864893449696384 | 830024.43 | 2.443797379274733
 |  |  |  |  |  | OPTIONS: CHARTER TRANSPORTATION | -299052.7199999997 | -299052.7199999997 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | OPTIONS: FARIBAULT | -1173414.879999999 | -1173414.879999999 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | PENSION | -31058527.49999995 | 7069609.610000003 | 38128137.10999995 | -1.227622175906441 | 830024.43 | 45.9361625175297
 |  |  |  |  |  | INTEGRATION | 97376461.78862318 | 101487855.8 | 4111394.011376828 | 0.04222164099884327 | 830024.43 | 4.953340965369932
 |  |  |  |  |  | ALL DAY KINDERGARTEN | 0 | 62999080.44923566 | 62999080.44923566 | 0 | 830024.43 | 75.90027253684045
 |  |  |  |  |  | LITERACY INCENTIVE AID | 48584999.98999999 | 48584999.98999999 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | SAFE SCHOOLS LEVY | 29454100 | 0 | -29454100 | -1 | 830024.43 | -35.48582298957152
 |  |  |  |  |  | COMBINED SPECIAL EDUCATION | 965892143.2928745 | 1160457477.412912 | 194565334.1200372 | 0.2014358802596055 | 830024.43 | 234.4091656676144
 |  |  |  |  |  | CHARTER SCHOOL LEASE AID | 49975642.52999998 | 49967709.23999999 | -7933.289999984205 | -0.0001587431316210074 | 830024.43 | -0.009557899398195067
 |  |  |  |  |  | REFERENDUM | 858977106.2699999 | 448805001.1600005 | -410172105.1099994 | -0.4775122667600772 | 830024.43 | -494.1687139377323
 |  |  |  |  |  | REGIONAL COST ADJUSTMENT FROM REFERENDUM | 0 | 206134987.92 | 206134987.92 | 0 | 830024.43 | 248.3480973204607
 |  |  |  |  |  | REGIONAL COST ADJUSTMENT NEW DOLLARS | 0 | 53144144.14192802 | 53144144.14192802 | 0 | 830024.43 | 64.02720476785005
 |  |  |  |  |  | [NAME] FOR ICE ARENA | 1809300 | 1809300 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | LEVY FOR SWIMMING POOLS | 536000 | 536000 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | [NAME] FOR TREE GROWTH | 631700 | 631700 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | LEASE LEVY (NON-INTERMEDIATE) | 44557360.23999999 | 44557360.23999999 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | HEALTH & SAFETY | 56294162.22400005 | 0 | -56294162.22400005 | -1 | 830024.43 | -67.82229557267374
 |  |  |  |  |  | DEBT EXCLUDING ALT FACILITIES | 640075676.77 | 640075676.77 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | DEFERRED MAINTENANCE | 26096486.46411429 | 93437342.82617143 | 67340856.36205713 | 2.580456815696575 | 830024.43 | 81.13117388852896
 |  |  |  |  |  | ALTERNATIVE FACILITIES PAY AS YOU GO | 62373415.034 | 85711116.63399999 | 23337701.59999999 | 0.3741610361927195 | 830024.43 | 28.11688518613842
 |  |  |  |  |  | ALTERNATIVE FACILITIES DEBT SERVICE | 131348154 | 131348154 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | TOTAL ABOVE | 9051689745.83361 | 9685561782.120712 | 633872036.2871044 | 0.07002803389045327 | 830024.43 | 763.6787706201663
 |  |  |  |  |  | LEVIES, RMV
 |  |  |  |  |  | GENERAL | 0 | 292936061.8675855 | 292936061.8675855 | 0 | 830024.43 | 352.9246264083884
 |  |  |  |  |  | REFERENDUM | 764418983.1031847 | 364330417.6855991 | -400088565.4175856 | -0.5233891023917441 | 830024.43 | -482.0202285101242
 |  |  |  |  |  | EQUITY | 73599985.80000004 | 35711823.66000001 | -37888162.14000003 | -0.5147849110046976 | 830024.43 | -45.64704455747167
 |  |  |  |  |  | TRANSITION | 23474332.02 | 0 | -23474332.02 | -1 | 830024.43 | -28.28149530490326
 |  |  |  |  |  | REGIONAL COST ADJUSTMENT | 0 | 168514997.7099999 | 168514997.7099999 | 0 | 830024.43 | 203.0241419641105
 |  |  |  |  |  | LEVIES, NTC
 |  |  |  |  |  | GENERAL | 0 | 184623432.0000066 | 184623432.0000066 | 0 | 830024.43 | 222.4313228949256
 |  |  |  |  |  | OPERATING CAPITAL | 114050288.8893388 | 0 | -114050288.8893388 | -1 | 830024.43 | -137.405942243578
 |  |  |  |  |  | INTEGRATION | 29788451.62658696 | 0 | -29788451.62658696 | -1 | 830024.43 | -35.88864441807689
 |  |  |  |  |  | Q COMP | 17053253.68 | 17135584.82 | 82331.1400000006 | 0.004827884551823579 | 830024.43 | 0.09919122501008867
 |  |  |  |  |  | SAFE SCHOOLS | 29454100 | 0 | -29454100 | -1 | 830024.43 | -35.48582298957152
 |  |  |  |  |  | ICE ARENA | 1809300 | 1809300 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | SWIMMING POOLS | 536000 | 536000 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | TREE GROWTH | 631700 | 631700 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | LEASE LEVY (NON-INTERMEDIATE) | 44557360.23999999 | 44557360.23999999 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | HEALTH & SAFETY LEVY | 56201199.64400005 | 0 | -56201199.64400005 | -1 | 830024.43 | -67.71029576081278
 |  |  |  |  |  | DEBT LEVY Excluding Alt Facilities | 621206113.182635 | 610810629.5225542 | -10395483.66008079 | -0.01673435505459122 | 830024.43 | -12.52431047129636
 |  |  |  |  |  | DEFERRED MAINTENANCE | 22581198.31000002 | 54427257.39 | 31846059.07999998 | 1.410290926230299 | 830024.43 | 38.36761657726144
 |  |  |  |  |  | ALTERNATIVE FACILITIES PAY AS YOU GO | 59543588.034 | 82881289.634 | 23337701.6 | 0.3919431524125475 | 830024.43 | 28.11688518613844
 |  |  |  |  |  | ALTERNATIVE FACILITIES DEBT SERVICE | 114891917 | 114891917 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | [NAME], RMV | 861493300.9231848 | 861493300.9231845 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | [NAME], NTC | 1112304470.606561 | 1112304470.606561 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  |  | 1973797771.529746 | 1973797771.529745 | 0 | 0 | 830024.43 | 0
 |  |  |  |  |  | EXTENDED TIME PLUS COMPENSATORY | 528499487.1699997 | 546096797.5599996 | 17597310.38999987 | 0.03329674071062898 | 830024.43 | 21.2009547598495
 |  |  |  |  |  | EQUALIZED STATE AID
 |  |  |  |  |  |  | 94558123.16681516 | 84474583.47440141 | -10083539.69241375 | -0.1066385346357269 | 830024.43 | -12.14848542760813
 |  |  |  |  |  |  | 20083408.71999994 | 18520721.70000007 | -1562687.019999869 | -0.07780985000039743 | 830024.43 | -1.882700030889294
 |  |  |  |  |  |  | 6302920.11999999 | 793606.6691624299 | -5509313.45083756 | -0.874089048559538 | 830024.43 | -6.637531681853702
 |  |  |  |  |  |  | 0 | 37619990.21000004 | 37619990.21000004 | 0 | 830024.43 | 45.32395535635022
 |  |  |  |  |  |  | 83363536.00066118 | 197438688.4223518 | 114075152.4216906 | 1.368405874971353 | 830024.43 | 137.4358974249597
 |  |  |  |  |  |  | 67588010.16203623 | 101487855.8 | 33899845.63796379 | 0.5015659664590203 | 830024.43 | 40.84198538344683
 |  |  |  |  |  |  | 46626537.49000002 | 46544206.35000002 | -82331.1400000006 | -0.001765757108120202 | 830024.43 | -0.09919122501008867
 |  |  |  |  |  |  | 18869563.58736503 | 29265047.24744582 | 10395483.66008079 | 0.5509127761196108 | 830024.43 | 12.52431047129636
 |  |  |  |  |  |  | 3515288.154114269 | 39010085.43617143 | 35494797.28205716 | 10.09726535234794 | 830024.43 | 42.76355731126752
 |  |  |  |  |  |  | 19286064 | 19286064 | 0 | 0 | 830024.43 | 0
 |  |  |  |  | FUNDING PROPOSAL, FALL 2012
 |  |  |  |  | PARAMETERS: |  | CURRENT | PROPOSED
 |  |  |  |  | 1 | WEIGHT, PRE-K | 1.25 | 1
 |  |  |  |  |  | WEIGHT, [NAME] | 1 | 1
 |  |  |  |  |  | WEIGHT, REGULAR K | 0.612 | 0.5
 |  |  |  |  |  | WEIGHT, GRADES 1-3 | 1.115 | 1
 |  |  |  |  |  | WEIGHT, GRADES 4-6 | 1.06 | 1
 |  |  |  |  |  | WEIGHT, GRADES 7-12 | 1.3 | 1.2
 |  |  |  |  |  | FORMULA ALLOWANCE | 5224 | 6300
 |  |  |  |  |  | DECLINING PUPIL MULTIPLIER | N/A | 0.28
 |  |  |  |  |  | LEP CONCENTRATION CAP #1 | 0.115 | 0.16
 |  |  |  |  |  | LEP CONCENTRATION CAP #2 | 250 | 350
 |  |  |  |  |  | INFLATION MULTIPLIER | 1.0483 | 1.043859649122807
 |  |  |  |  |  | TRANSPORT SPARSITY MULTIPLIER #1 | 0.1469 | 0.1324
 |  |  |  |  |  | TRANSPORT SPARSITY MULTIPLIER #2 | 0.0485 | 0.0437
 |  |  |  |  |  | EQUIPMENT MULTIPLIER | 73 | 80
 |  |  |  |  |  | FACILITIES MULTIPLIER | 100 | 109
 |  |  |  |  |  | YEAR ROUND PU MULTIPLIER | 30 | 33
 |  |  |  |  |  | FORMULA ALLOWANCE FOR FULL-DAY K | N/A | 6300
 |  |  |  |  |  | PRORATION RATE FOR FULL-DAY K | N/A | 0.9
 |  |  |  |  |  | SPED: 1=NO CHANGE;2=FULL;3=90-10 ONLY | N/A | 2
 |  |  |  |  |  | SPED, INITIAL AID PERCENT | N/A | 0.6
 |  |  |  |  |  | SPED, INI AID MAX % OF COST | N/A | 0.7
 |  |  |  |  |  | SPED, GEN ED DEDUCT % | N/A | 0.051
 |  |  |  |  |  | SPED, EXCESS COST AID % | N/A | 0.75
 |  |  |  |  |  | SPED TUITION ADJUSTMENT PERCENT | N/A | 0.1
 |  |  |  |  |  | LEASE AID Percent | N/A | 0.9
 |  |  |  |  |  | LEASE AID Maximum / PU | N/A | 1314
 |  |  |  |  |  | LEASE AID PARAMETER #1 | N/A | 1
 |  |  |  |  |  | LEASE AID PARAMETER #1 | N/A | 1.0841623
 |  |  |  |  |  | INTEGRATION per adm rate | N/A | 0
 |  |  |  |  |  | INTEGRATION rate for minority percent | N/A | 500
 |  |  |  |  |  | INTEGRATION hold harmless factor | N/A | 0.6
 |  |  |  |  |  | INTEGRATION PER MINORITY, STANDARD | N/A | 0
 |  |  |  |  |  | INTEGRATION PER MINORITY, MPLS | N/A | 0
 |  |  |  |  |  | EQUITY: MAXIMUM REFER/APU | N/A | 1400
 |  |  |  |  |  | EQUITY: MAXIMUM REVENUE/APU | N/A | 100
 |  |  |  |  |  | REFERENDUM ROLL-IN TO BASIC | N/A | 300
 |  |  |  |  |  | [NAME] TO BASIC, METRO | N/A | 400
 |  |  |  |  |  | [NAME] TO BASIC, CENTERS | N/A | 200
 |  |  |  |  |  | MULTIPLIER, METRO | N/A | 0.015
 |  |  |  |  |  | MULTIPLIER, CENTERS | N/A | 0.005
 |  |  |  |  |  | EQUALIZING FACTOR, REFERENDUM TIER 1 | N/A | 669768.2350257504
 |  |  |  |  |  | EQUALIZING FACTOR, REFERENDUM TIER 2 | N/A | 401860.9410154502
 |  |  |  |  |  | EQUALIZING FACTOR, OPERATING CAPITAL | N/A | 11156.18544245524
 |  |  |  |  |  | NEW CAP ON REFERENDUM/APU, TIER 1 | N/A | 700
 |  |  |  |  |  | NEW CAP ON REFERENDUM/APU, TIER 2 | N/A | 1400
 |  |  |  |  |  | ROLL EXTENDED TIME INTO COMPENSATORY? YES = 1 | N/A | 1
 |  |  |  |  |  | KEEP LEVY FOR ICE ARENA? YES = 1 | N/A | 1
 |  |  |  |  |  | KEEP LEVY FOR SWIMMING POOLS? YES = 1 | N/A | 1
 |  |  |  |  |  | KEEP [NAME] FOR TREE GROWTH? YES = 1 | N/A | 1
 |  |  |  |  |  | EVALUATION REVENUE PER PY ENROLL | N/A | 0
 |  |  |  |  |  | Q Comp INITIAL AID PERCENT | N/A | 0.65
 |  |  |  |  |  | Q Comp EQUALIZING FACTOR | N/A | 7321.246696611253
 |  |  |  |  |  | ADDED FACILITIES PER PROPOSED APU | N/A | 0
 |  |  |  |  |  | DEBT: ANTC PERCENT FOR UNEQUALIZED | N/A | 0.15
 |  |  |  |  |  | DEBT: ANTC PERCENT FOR TIER 1 | N/A | 0.25
 |  |  |  |  |  | DEBT: TIER 1 EQUALIZING FACTOR | N/A | 5229.461926150895
 |  |  |  |  |  | DEBT: TIER 2 EQUALIZING FACTOR | N/A | 8715.769876918159
 |  |  |  |  |  | DEFERRED MAINT PER PU | N/A | 230
 |  |  |  |  |  | DEFERRED MAINT EQUALIZING FACTOR | N/A | 11156.18544245524
 |  |  |  |  |  | KEEP LEASE LEVY? | N/A | 1
 |  |  |  |  |  | KEEP HEALTH & SAFETY? | N/A | 0
 |  |  |  |  |  | SMALL SCHOOLS CAP ON APU | 1000 | 950
 |  |  |  |  |  | SMALL SCHOOLS MAXIMUM PER APU | 522.4 | 535
 |  |  |  |  |  | PROPOSED COMPENS: WT FOR REDUCED | N/A | 0.5
 |  |  |  |  |  | PROPOSED COMPENS: PER ADJ COUNT | N/A | 260
 |  |  |  |  |  | COMPENSATORY GUARANTEE PER FREE + HALF REDUCED | 0 | 0
 |  |  |  |  |  | AVERAGE RMV PER NEW APU | 535814.5880206003
 |  |  |  |  |  | AVERAGE ANTC PER NEW APU | 6972.615901534527
 |  |  |  |  |  | pupil units | 957278.4699999997 | 876222.8999999996
 |  |  |  |  |  |  |  | 1.092505651244678
 |  |  |  |  |  | BASED ON:
 |  |  |  |  | * | USING PRELIMINARY ACTUAL FY 2012 ADM.
 |  |  |  |  | * | TAKING UNFUDGED FY 2013 ADM PROJECTIONS AS OF OCTOBER 2012 AND
 |  |  |  |  |  | FUDGING THEM TO PROJECTED STATE TOTALS FROM THE FEBRUARY STATE BUDGET
 |  |  |  |  |  | FORECAST.