Create a Tax Calculation Program by erf18734

VIEWS: 23 PAGES: 8

More Info
									                                   DISCLAIMER
This spreadsheet is designed to help districts project state funding pursuant to the SB287 (2005) Formula during the seven year phase-in.
Results from any spreadsheet model should be considered an estimate with no guarantee of future state funding amounts.



Suggestions:
Save the original file, then create a new file to make your calculations (you can always begin again if there are errors).
Only enter data in cells that are yellow. Changing other cells will interfere with built-in calculations.
Cells with formulas are not protected, so you can make adjustments particular to your district.
Look at historical data in your district to predict trends for various data elements.


Last Modified: 6-10-2010
          WEIGHTED ADA CALCULATION ESTIMATE
                                                                      District Name:                       District Code:              Date:
                                                      Required Year
   Line                                     2004-05      2005-06         2006-07       2007-08   2008-09     2009-10        2010-11       2011-12       2012-13
    1.  Regular Year ADA                     0.0000       0.0000          0.0000        0.0000    0.0000      0.0000         0.0000        0.0000        0.0000

    2.    Summer School ADA                 0.0000        0.0000         0.0000        0.0000    0.0000       0.0000        0.0000         0.0000       0.0000

    3.    Total ADA (1+2)                   0.0000        0.0000         0.0000        0.0000    0.0000       0.0000        0.0000         0.0000       0.0000

    4.    Free and Reduced Weighting
          January Count                      0.00          0.00           0.00          0.00      0.00         0.00          0.00           0.00         0.00
          26.6% of ADA (Line 3)             0.0000        0.0000         0.0000        0.0000
          27.3% of ADA (Line 3)                                                                  0.0000       0.0000
          32.0% of ADA (Line 3)                                                                                             0.0000         0.0000       0.0000
          Add-on (25%)                      0.0000        0.0000         0.0000        0.0000    0.0000       0.0000        0.0000         0.0000       0.0000

    5.    Special Education Weighting
          December Count                       0             0              0             0        0             0            0                0           0
          14.9% of ADA (Line 3)             0.0000        0.0000         0.0000        0.0000
          14.3% of ADA (Line 3)                                                                  0.0000       0.0000
          13.7 % of ADA (Line 3)                                                                                            0.0000         0.0000       0.0000
          Add-on (75%)                      0.0000        0.0000         0.0000        0.0000    0.0000       0.0000        0.0000         0.0000       0.0000

    6.    LEP Weighting
          October Count                        0             0              0             0        0             0            0                0           0
          1.1% of ADA (Line 3)              0.0000        0.0000         0.0000        0.0000
          1.3% of ADA (Line 3)                                                                   0.0000       0.0000
          .90% of ADA (Line 3)                                                                                              0.0000         0.0000       0.0000
          Add-on (60%)                      0.0000        0.0000         0.0000        0.0000    0.0000       0.0000        0.0000         0.0000       0.0000

    7a.   Weighted ADA (3+4+5+6)            0.0000        0.0000         0.0000        0.0000    0.0000       0.0000        0.0000         0.0000       0.0000
           (Use Prior Year for Prop. C)

    7b.   WADA less Summer School           0.0000        0.0000         0.0000        0.0000    0.0000       0.0000        0.0000         0.0000       0.0000
           (Line 7a - Line 2)

    8.    Formula Weighted ADA                                           0.0000        0.0000    0.0000       0.0000        0.0000         0.0000       0.0000
           (Highest 3yr ADA + Current SS)




DESE K-12 Formula Worksheet
Form Last Modified 7-17-2008                                                                                                          Estimate Calculated 11/21/2010
Local Effort 2004-05                                 District Name:    0                                      District Code:   0               Date:            1/0/1900

                                                       FORMULA YR
                                                         2006-07             2007-08           2008-09            2009-2010        2010-2011      2011-2012        2012-2013
2004-2005 Assessed Valuation*                               $0                  $0                $0                  $0               $0             $0               $0
(Divided by 100 x 3.43)                                   $0.00               $0.00             $0.00               $0.00            $0.00          $0.00            $0.00
2004-05 County Assessor & Collector Fee Rate              0.00%               0.00%             0.00%               0.00%            0.00%          0.00%            0.00%
2004-05 County Assessor & Collector Fees**                $0.00               $0.00             $0.00               $0.00            $0.00          $0.00            $0.00
Net Local Tax Revenue                                     $0.00               $0.00             $0.00               $0.00            $0.00          $0.00            $0.00

2004-2005 Incidental and Teachers Fund Revenues
  School District Trust Fund (Prop C) x 1/2                $0.00                $0.00            $0.00              $0.00            $0.00             $0.00         $0.00
  Financial Institution Tax                                $0.00                $0.00            $0.00              $0.00            $0.00             $0.00         $0.00
  Merchant's and Manufacturer's Tax                        $0.00                $0.00            $0.00              $0.00            $0.00             $0.00         $0.00
  In Lieu Of Tax                                           $0.00                $0.00            $0.00              $0.00            $0.00             $0.00         $0.00
  Fines, Escheats, etc. Fines***                           $0.00                $0.00            $0.00              $0.00            $0.00             $0.00         $0.00
  State Assessed Utilities                                 $0.00                $0.00            $0.00              $0.00            $0.00             $0.00         $0.00
  Federal Properties                                       $0.00                $0.00            $0.00              $0.00            $0.00             $0.00         $0.00
  Local Earnings and Income Taxes                          $0.00                $0.00            $0.00              $0.00            $0.00             $0.00         $0.00
Total Receipts                                             $0.00                $0.00            $0.00              $0.00            $0.00             $0.00         $0.00
  * enter 2004-05 amount in first column, then enter lower of 2004-05 or prior year December 31st AV thereafter
 ** fees prorated to equivalent $3.43 levy (not actual)
*** enter 2004-05 amount in first column, then enter higher of 2004-05 or second prior year therafter


This section will only be needed when the district's prior year        All districts complete this section.
ADA is less than or equal to 350.
State Funding For 2004-05                                              State Funding For 2005-06
  Recalculated Basic Formula                                $0.00          Recalculated Basic Formula                                $0.00
  Recalculated Line 14                                      $0.00          Recalculated Line 14                                      $0.00
  Exceptional Pupil Aid                                     $0.00          Exceptional Pupil Aid                                     $0.00
  Gifted Aid                                                $0.00          Gifted Aid                                                $0.00
  Remedial Reading                                          $0.00          Remedial Reading                                          $0.00
  Fair Share                                                $0.00          Fair Share                                                $0.00
  Free Textbook                                             $0.00          Free Textbook                                             $0.00
  2004-2005 State Funding Total                             $0.00          2005-2006 State Funding Total                             $0.00

Note: The hold harmless calculation for districts with ADA ≤ 350
     will use the higher of 2004-05 or 2005-06 state revenue.




DESE K-12 Formula Worksheet
Form Last Modified 7-17-2008                                                                                                                                   Estimate Calculated 11/21/2010
       SB 287 FORMULA CALCULATION ESTIMATE
                                                                 District Name:   0                                District Code:   0                 Date:              1/0/1900

                                                                       Year 1             Year 2        Year 3           Year 4            Year 5          Year 6              Year 7
LINE                                                                  2006-07            2007-08       2008-09         2009-2010         2010-2011       2011-2012           2012-2013
 1.    Formula Payment Weighted ADA                                   0.0000             0.0000        0.0000           0.0000            0.0000          0.0000              0.0000
 2.    State Adequacy Target (SAT)                                    $6,117             $6,117        $6,117           $6,117            $6,124          $6,131              $6,131
 3.    Payment Weighted ADA x SAT = District Total                     $0.00              $0.00         $0.00            $0.00             $0.00           $0.00               $0.00
 4.    District Dollar Value Modifer (DVM)                            0.0000             0.0000        0.0000           0.0000            0.0000          0.0000              0.0000
 5.    District Total Modified                                         $0.00              $0.00         $0.00            $0.00             $0.00           $0.00               $0.00
 6.    Local Effort (2004-05 or as Adjusted)                           $0.00              $0.00         $0.00            $0.00             $0.00           $0.00               $0.00
 7.    State Funding Estimate Before Phase-in or Hold Harmless         $0.00              $0.00         $0.00            $0.00             $0.00           $0.00               $0.00
 8.    2005-2006 State Funding Total                                   $0.00               $0            $0               $0                $0              $0                  $0
    Phase-In Estimate:                                               15.00%             30.00%         44.00%           58.00%            72.00%          86.00%             100.00%
    Phase-Out Estimate (2005-06):                                     85.00%             70.00%        56.00%           42.00%            28.00%              14.00%          0.00%
 9. SB 287 Formula Phase Amount (Line 7 x %)                          $0.00              $0.00          $0.00            $0.00             $0.00              $0.00           $0.00
10. 2005-2006 State Funding Phase Amount (Line 8 x %)                 $0.00              $0.00          $0.00            $0.00             $0.00              $0.00           $0.00
11. Estimated Formula Phase Total (before Hold Harmless)              $0.00              $0.00          $0.00            $0.00             $0.00              $0.00           $0.00
     Hold Harmless Calculation (Prior Year ADA > 350)             1+(1/3 DVM>1)       1+(2/3 DVM>1)    Full DVM        Full DVM           Full DVM        Full DVM           Full DVM
12.  DVM Calculation                                                   N/A                N/A            N/A              N/A               N/A                N/A             N/A
13.  2005-2006 State Funding Modified by DVM                           N/A                N/A            N/A              N/A               N/A                N/A             N/A
14.  FY06 Modified (Line 13) Per 2005-06 Weighted ADA                  N/A                N/A            N/A              N/A               N/A                N/A             N/A
15.  Est. Total (Line 11) per Payment Weighted ADA (Line 1)            N/A                N/A            N/A              N/A               N/A                N/A             N/A
     "On Formula/Hold Harmless" Determination                          N/A                 N/A           N/A             N/A                N/A             N/A                N/A
     Hold Harmless Calculation (Prior Year ADA ≤ 350)             1+(1/3 DVM>1)       1+(2/3 DVM>1)    Full DVM        Full DVM           Full DVM        Full DVM           Full DVM
12A. DVM Calculation                                                  0.6667             0.3333        0.0000           0.0000            0.0000          0.0000              0.0000
13A. Greater of 2004-05 and 2005-06 State Funding                      $0.00              $0.00         $0.00            $0.00             $0.00           $0.00               $0.00
14A. State Funding Modified by DVM                                      $0                 $0            $0               $0                $0              $0                  $0
     "On Formula/Hold Harmless" Determination                       On Formula         On Formula     On Formula      On Formula         On Formula      On Formula         On Formula

16. ESTIMATED STATE FORMULA PAYMENT                                     $0                 $0            $0              $0                  $0             $0                  $0
    APPROPRIATION ADJUSTMENT PERCENTAGE                                                                             0.00000000%         0.00000000%    0.00000000%         0.00000000%
    ESTIMATED STATE FORMULA PAYMENT AFTER ADJUSTMENT                                                                     $0                  $0             $0                  $0
    Revenue Sources:
     Classroom Trust Fund - Per ADA (DESE) *                          $0.00              $0.00          $0.00            $0.00             $0.00              $0.00           $0.00
     Basic Formula - Classroom Trust Fund Total                        $0                 $0             $0               $0                $0                 $0              $0
     Basic Formula - State Monies Total                                $0                 $0             $0               $0                $0                 $0              $0

17. Small School Allocation                                             $0                 $0            $0               $0                $0                 $0               $0

18. TOTAL SB 287 PAYMENT                                                $0                 $0            $0               $0                $0                 $0               $0

       Estimated Increase (Prior Year Comparison)                     $0.00              $0.00          $0.00            $0.00             $0.00              $0.00           $0.00
       Fund Placement:
        Minimum Fund 2 (75% of Basic Formula-State Monies)            $0.00              $0.00          $0.00            $0.00             $0.00              $0.00           $0.00
        Maximum Fund 1 (25% of Basic Formula-State Monies)            $0.00              $0.00          $0.00            $0.00             $0.00              $0.00           $0.00

    7% Capital Projects Transfer Maximum                             $162,326           $162,326      $162,326         $162,326          $162,326        $162,326            $162,326
 OR 5% Designated Levy Transfer Maximum                                 $0                 $0            $0               $0                $0              $0                  $0

       1% Professional Development Committee Calculation                $0                 $0            $0               $0                $0                 $0               $0



          DESE K-12 Formula Worksheet
          Form Last Modified 7-17-2008                                                                                                                         Estimate Calculated 11/21/2010
*Per Section 163.043.5, RSMo, "For the 2010-2011 school year and for each subsequent year, all proceeds a school district receives from the classroom trust fund in excess of the amount the
district received from the classroom trust fund in the 2009-2010 school year shall be placed to the credit of the district's teachers' and incidental funds."




   DESE K-12 Formula Worksheet
   Form Last Modified 7-17-2008                                                                                                                                       Estimate Calculated 11/21/2010
           SMALL SCHOOL ALLOCATION ESTIMATE
           DISTRICTS ≤ 350 ADA IN PRIOR YEAR                    District Name: 0                                      District Code: 0                    Date:             1/0/1900

   Line                                                             2006-07           2007-08           2008-09           2009-10           2010-11           2011-12           2012-13
   1)   $10 Million Appropriation

        a) District ADA (Prior Year)                                0.0000            0.0000            0.0000            0.0000            0.0000            0.0000            0.0000

        b) Allocation per ADA (DESE)                                $0.0000           $0.0000           $0.0000           $0.0000           $0.0000           $0.0000           $0.0000

        c) District Allocation                                  $             -   $             -   $             -   $             -   $             -   $             -   $             -

   2)      $5 Million Appropriation
           (districts with tax rate ≥ $3.43)

        a) District ADA (Prior Year)                                0.0000            0.0000            0.0000            0.0000            0.0000            0.0000            0.0000

        b) District Tax Rate Current Year (I+T)                     $0.0000           $0.0000           $0.0000           $0.0000           $0.0000           $0.0000           $0.0000

        c) District Tax Rate (I+T) ÷ Performance Levy               0.0000            0.0000            0.0000            0.0000            0.0000            0.0000            0.0000

        d) District Tax-Rate-Weighted ADA (Line 2a X Line 2c)       0.0000            0.0000            0.0000            0.0000            0.0000            0.0000            0.0000

        e) Allocation per Tax-Rate-Weighted ADA (DESE)              $0.0000           $0.0000           $0.0000           $0.0000           $0.0000           $0.0000           $0.0000

        f) District Tax-Rate-Weighted Allocation                $             -   $             -   $             -   $             -   $             -   $             -   $             -

   3)      Total District Allocation (1 + 2)                    $             -   $             -   $             -   $             -   $             -   $             -   $             -




DESE K-12 Formula Worksheet
Form Last Modified 7-17-2008                                                                                                                              Estimate Calculated 11/21/2010
CERTIFICATED SALARY COMPLIANCE ESTIMATE (Section 163.031.6, RSMo)
                                                                                                           District Name:     0                                       District Code:         0                    Date:              1/0/1900
                                                                                         Incidental Fund    Teachers Fund     Incidental Fund        Teachers Fund     Incidental Fund           Teachers Fund    Incidental Fund        Teachers Fund

                             Revenue Placement                                                     2006-2007                            2007-2008                                 2008-2009                                 2009-2010
 1                           5311 - Basic Formula - State Monies                        $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
 2                           5113 - School District Trust Fund (Prop C)                 $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -

                                                                                         Incidental Fund    Teachers Fund     Incidental Fund        Teachers Fund     Incidental Fund           Teachers Fund    Incidental Fund        Teachers Fund
                             Revenue                                                               2006-2007                            2007-2008                                 2008-2009                                 2009-2010
 3                           5111 - Current Taxes                                       $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
 4                           5112 - Delinquent Taxes                                    $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
 5                           5114 - Financial Institution Tax                           $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
 6                           5115 - M & M Surtax                                        $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
 7                           5116 - In Lieu of Tax                                      $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
 8                           5117 - City Sales Tax                                      $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
 9                           5221 - State Assessed Utilities                            $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
10                           5222 - County Stock Insurance Fund                         $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
11          Sum 3-10         Total Local and County Tax Sources                         $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -
12                           5899 -Total Fund Revenue (Include revenues listed above)   $            -      $             -   $           -      $                -   $                -     $                -   $           -      $                 -


                             Certificated Compensation & Tuition
                             Expenditures                                                        Teachers Fund                         Teachers Fund                             Teachers Fund                             Teachers Fund
13                           6199 - Certificated Salary                                  $                                -   $                                   -   $                                       -   $                                    -
14                           6299 - Certificated Benefits                                $                                -   $                                   -   $                                       -   $                                    -
15                           6311 - Tuition Paid from the Teachers Fund                  $                                -   $                                   -   $                                       -   $                                    -
16         Sum 13-15         Subtotal                                                    $                                -   $                                   -   $                                       -   $                                    -
17                           6311 - Tuition Paid from the Incidental Fund                $                                -   $                                   -   $                                       -   $                                    -
18           16 + 17         Total Certificated Compensation & Tuition                   $                                -   $                                   -   $                                       -   $                                    -
19                           Teachers Fund Balance Used to Cover Expenditures            $                                -   $                                   -   $                                       -   $                                    -
20         16 - 12 -19       Total Teachers Fund Transfer Needed                         $                                -   $                                   -   $                                       -   $                                    -

                             Total Local & County Revenue to Total Revenue
21           11 / 12
                                 (Incidental Fund)                                                       0.00%                                0.00%                                        0.00%                                  0.00%
                             Total Local & County Revenue Transferred
22           20 x 21
                                to Teachers Fund                                         $                                -   $                                   -   $                                       -   $                                    -
                             Total Local & County Tax Sources Used for
23         11 (TF) + 22
                                Teachers Fund Expenditures                               $                                -   $                                   -   $                                       -   $                                    -
24                           1st Preceding Year Weighted ADA                                                         0.0000                                  0.0000                                      0.0000                                   0.0000
25                           2nd Preceding Year Weighted ADA                                                         0.0000                                  0.0000                                      0.0000                                   0.0000
                             Local & County Tax Sources Used for
26           23 / 25             Allowable Teachers Fund Expenditures per
                                2nd Preceeding Year Weighted ADA                         $                            -       $                               -       $                                   -       $                                -
                             Local & County Tax Sources Used for
27      > 2PY 26 x CY 25*
                                 Allowable Teachers Fund Expenditures                                                         $                               -       $                                   -       $                                -


                             Compliance Year                                                                                            2007-2008                                 2008-2009                                 2009-2010
28       1 (IF & TF) x .75     Minimum Placement Required for 5311 Basic Formula - State Monies                               $                                   -   $                                       -   $                                    -
29                             Placed at Least Minimum 5311 Revenue in Teachers Fund                                                            Yes                                        Yes                                      Yes
                               Estimated Penalty for Minimum Placement of 5311 Basic Formula - State Monies                   $                                   -   $                                       -   $                                    -
30    2 ((IF & TF) x .5) x .75 Minimum Placement Required for 5113 School District Trust Fund (Prop C)                        $                                   -   $                                       -   $                                    -
31                             Placed at Least Minimum 5113 Revenue in Teachers Fund                                                            Yes                                        Yes                                      Yes
                               Estimated Penalty for Minimum Placement of 5113 School District Trust Fund (Prop C)            $                                   -   $                                       -   $                                    -
32         27 + 28 + 30        Total Minimum Required Teachers Fund Expenditures                                              $                                   -   $                                       -   $                                    -
33                             District Meets Teacher Fund Expenditures                                                                         Yes                                        Yes                                      Yes
                               Estimated Penalty for Teacher Fund Expenditures                                                $                                   -   $                                       -   $                                    -

34     29, 31, & 33 = Yes    District Meets Salary Compliance                                                                         In Compliance                            In Compliance                              In Compliance
35           32 - 18         Estimated Penalty to be withheld from Following Year Basic Formula - State Monies                $                                   -   $                                       -   $                                    -

* For 2007-2008 the calculation is current year 25 x prior year 26.



      DESE K-12 Formula Worksheet
      Form Last Modified 7-17-2008                                                                                                                                                                                                       Estimate Calculated 11/21/2010
CERTIFICATED SALARY COMPLIANCE ESTIMATE (Section 163.031.6, RSMo)
                                                                                         Incidental Fund    Teachers Fund    Incidental Fund    Teachers Fund    Incidental Fund    Teachers Fund

                             Revenue Placement                                                     2010-2011                           2011-2012                           2012-2013
 1                           5311 - Basic Formula - State Monies                        $            -      $           -    $           -      $           -    $           -      $           -
 2                           5113 - School District Trust Fund (Prop C)                 $            -      $           -    $           -      $           -    $           -      $           -

                                                                                         Incidental Fund    Teachers Fund    Incidental Fund    Teachers Fund    Incidental Fund    Teachers Fund
                             Revenue                                                               2010-2011                           2011-2012                           2012-2013
 3                           5111 - Current Taxes                                       $            -      $           -    $           -      $           -    $           -      $           -
 4                           5112 - Delinquent Taxes                                    $            -      $           -    $           -      $           -    $           -      $           -
 5                           5114 - Financial Institution Tax                           $            -      $           -    $           -      $           -    $           -      $           -
 6                           5115 - M & M Surtax                                        $            -      $           -    $           -      $           -    $           -      $           -
 7                           5116 - In Lieu of Tax                                      $            -      $           -    $           -      $           -    $           -      $           -
 8                           5117 - City Sales Tax                                      $            -      $           -    $           -      $           -    $           -      $           -
 9                           5221 - State Assessed Utilities                            $            -      $           -    $           -      $           -    $           -      $           -
10                           5222 - County Stock Insurance Fund                         $            -      $           -    $           -      $           -    $           -      $           -
11          Sum 3-10         Total Local and County Tax Sources                         $            -      $           -    $           -      $           -    $           -      $           -
12                           5899 -Total Fund Revenue (Include revenues listed above)   $            -      $           -    $           -      $           -    $           -      $           -


                             Certificated Compensation & Tuition
                             Expenditures                                                        Teachers Fund                       Teachers Fund                       Teachers Fund
13                           6199 - Certificated Salary                                  $                              -    $                              -    $                              -
14                           6299 - Certificated Benefits                                $                              -    $                              -    $                              -
15                           6311 - Tuition Paid from the Teachers Fund                  $                              -    $                              -    $                              -
16         Sum 13-15         Subtotal                                                    $                              -    $                              -    $                              -
17                           6311 - Tuition Paid from the Incidental Fund                $                              -    $                              -    $                              -
18           16 + 17         Total Certificated Compensation & Tuition                   $                              -    $                              -    $                              -
19                           Teachers Fund Balance Used to Cover Expenditures            $                              -    $                              -    $                              -
20         16 - 12 -19       Total Teachers Fund Transfer Needed                         $                              -    $                              -    $                              -

                             Total Local & County Revenue to Total Revenue
21           11 / 12
                                 (Incidental Fund)                                                       0.00%                               0.00%                               0.00%
                             Total Local & County Revenue Transferred
22           20 x 21
                                to Teachers Fund                                         $                              -    $                              -    $                              -
                             Total Local & County Tax Sources Used for
23         11 (TF) + 22
                                Teachers Fund Expenditures                               $                              -    $                              -    $                              -
24                           1st Preceding Year Weighted ADA                                                        0.0000                              0.0000                              0.0000
25                           2nd Preceding Year Weighted ADA                                                        0.0000                              0.0000                              0.0000
                             Local & County Tax Sources Used for
26           23 / 25             Allowable Teachers Fund Expenditures per
                                2nd Preceeding Year Weighted ADA                         $                          -        $                          -        $                          -
                             Local & County Tax Sources Used for
27      > 2PY 26 x CY 25*
                                 Allowable Teachers Fund Expenditures                    $                          -        $                          -        $                          -


                             Compliance Year                                                       2010-2011                           2011-2012                           2012-2013
28       1 (IF & TF) x .75                                                                $
                               Minimum Placement Required for 5311 Basic Formula - State Monies                   -          $                              -    $                              -
29                             Placed at Least Minimum 5311 Revenue in Teachers Fund                   Yes                                   Yes                                 Yes
                                                                                          $
                               Estimated Penalty for Minimum Placement of 5311 Basic Formula - State Monies       -          $                              -    $                              -
30                                                                                        $
      2 ((IF & TF) x .5) x .75 Minimum Placement Required for 5113 School District Trust Fund (Prop C)            -          $                              -    $                              -
31                             Placed at Least Minimum 5113 Revenue in Teachers Fund                   Yes                                   Yes                                 Yes
                               Estimated Penalty for Minimum Placement of 5113 School$District Trust Fund (Prop C)-          $                              -    $                              -
32         27 + 28 + 30        Total Minimum Required Teachers Fund Expenditures          $                       -          $                              -    $                              -
33                             District Meets Teacher Fund Expenditures                                Yes                                   Yes                                 Yes
                               Estimated Penalty for Teacher Fund Expenditures            $                       -          $                              -    $                              -

34     29, 31, & 33 = Yes    District Meets Salary Compliance                                   In Compliance                       In Compliance                       In Compliance
35           32 - 18                                                                      $
                             Estimated Penalty to be withheld from Following Year Basic Formula - State Monies          -    $                              -    $                              -

* For 2007-2008 the calculation is current year 25 x prior year 26.



      DESE K-12 Formula Worksheet
      Form Last Modified 7-17-2008                                                                                                                                                                   Estimate Calculated 11/21/2010

								
To top