Where Do All These Numbers Come From?

Miscellaneous Levies including: Reemployment, Safe Schools, Judgment, Health Benefits, District Reorganization Retirement/Severance, Economic Development

Abatement, and Administrative Services

Daley Lehmann 651-582-8817

[email protected]

Miscellaneous Levies including: Swimming Pool Levy, Ice Arena Levy, Consolidation Transition Revenue,

Reorganization Operating Debt, and Taconite Adjustments

Bill Kiesow 651-582-8801

[email protected]

Non-public Transportation Revenue Greg Sogaard 651-582-8858

[email protected]

Other Postemployment Benefits (OPEB) Jan Carlson [email protected]

(6)

Class Rates Used In Computing Net Tax Capacity

Property Tax Class Tax Rate

Pay 2021

Tax Rate Pay 2020

Subject to State Levy?

Residential Homestead (1a) & Migrant Housing (1d) Up to $500,000

Over $500,000

Disabled homestead up to $50,000 (1b)

1.00%

1.25%

0.45%

1.00%

1.25%

0.45%

No

Residential Non-Homestead Single unit (4bb)

Up to $500,000 Over $500,000

1-3 units, undeveloped resident land, & unclassified mftg homes (all 4b) Apartments:

Regular 4+ units (4a), including for profit hospitals Low-income rental housing (4d)

Up to 150,000 (Pay 20)/ Up to $162,000 (Pay 21) Over 150,000 (Pay 20)/ Up to $162,000 (Pay 21)

1.00%

1.25%

.75%

.25%

1.00%

1.25%

.75%

.25%

No

Commercial-Industrial-Public Utility (3a)

Up to $150,000 Over $150,000

Other public utility machinery Electric generating machinery

1.50%

2.00%

1.50%

2.00%

Yes Yes Yes No Commercial Seasonal Recreational Residential--Homestead Resorts (1c)

Up to $600,000 (tier one)

$600,000 to $2.3 million (tier two) Over $2.3 million (tier three)

0.50%

1.00%

1.25%

0.50%

1.00%

1.25%

No No Yes Commercial Seasonal Recreational Residential--Seasonal Resorts (4c(1))

Up to $500,000 Over $500,000

Non-Commercial Seasonal Recreational Residential--Cabins (4c(1)):

Up to $500,000 Over $500,000

1.00%

1.25%

1.00%

1.25%

1.00%

1.25%

1.00%

1.25%

Yes¹

Qualifying Golf Courses (4c(2))

Nonprofit Community Service Oriented Organization (4c(3)) Postsecondary Student Housing (4c(4))

Manufactured Home Parks (4c(5))

Qualifying Metro Nonprofit Recreational Property (4c(6))

Certain Non-commercial Aircraft Storage Hangars (4c(7) and 4c(8)) Bed and Breakfast--up to 5 units (4c(9))

1.25%

1.50%

1.00%

1.25%

1.50%

1.25%

1.50%

1.00%

1.25%

1.50%

1.25%

No

Agricultural Homestead (2a) House, Garage and One Acre

Up to $500,000 Over $500,000 Land and Buildings

Up to $1,880,000 (Pay 20)/ Up to $1,900,000 (Pay 21) Over $1,8800,000 (Pay 20)/ Up to $1,900,000 (Pay 21) Agricultural Non-Homestead and Timberland (2b)

1.00%

1.25%

0.50%

1.00%

1.25%

0.50%

1.00%

No

Miscellaneous and Iron Ore Property (5) 2.00% 2.00% Only for iron

1 For the purposes of the state general tax only, the tax rate for the first $76,000 of non-commercial class 4c(1) seasonal residential recreational property is 0.40 percent.

(7)

School District Tax Base and Levy Trends

STATE TOTALS AMOUNT PERCENT CHANGE

M arket Value

2008 581.3 billion 3.50%

2009 583.2 billion 0.33%

2010** 560.3 billion -3.93%

2011** 522.3 billion -6.78%

2012** 516.3 billion -1.15%

2013** 546.3 billion 5.81%

2014** 593.2 billion 8.59%

2015** 611.6 billion 3.10%

2016** 636.2 billion 4.02%

2017** 662.5 billion 4.13%

2018** 698.3 billion 5.40%

2019** 738.8 billion 5.80%

Referendum M arket Value

2008 (b) 487.1 billion 1.60%

2009 (b) 471.8 billion -3.14%

2010 446.8 billion -5.30%

2011 435.2 billion -2.60%

2012 418.1 billion -3.93%

2013 421.9 billion 0.91%

2014 449.8 billion 6.61%

2015 472.8 billion 5.11%

2016 497.6 billion 5.25%

2017 530.8 billion 6.67%

2018 565.9 billion 6.61%

2019 602.7 billion 6.50%

Net Tax Capacity

2008 (a) 6,212,181,699 3.80%

2009 (a) 6,241,705,585 0.48%

2010** 5,735,119,057 -8.12%

2011** 5,646,621,985 -1.54%

2012** 5,579,057,073 -1.20%

(8)

School District Tax Base and Levy Trends (Continued)

Average Sales Ratio

2008 91.30% 3.40%

2009 94.90% 3.94%

2010 98.70% 4.00%

2011 98.80% 0.10%

2012 98.20% -0.61%

2013 93.70% -4.58%

2014 93.30% -0.43%

2015 94.97% 1.79%

2016 95.67% 0.74%

2017 95.35% -0.33%

2018 95.57% 0.23%

2019 94.48% -1.14%

Adjusted Net Tax Capacity

2008 (a) 6,800,159,077 0.40%

2009 (a) 6,555,622,984 -3.60%

2010 (a) 5,806,925,965 -11.42%

2011 (a) 5,709,940,559 -1.67%

2012 (a) 5,664,825,992 -0.79%

2013 (a) 6,091,347,874 7.53%

2014 (a) 6,743,123,307 10.70%

2015 (a) 6,911,737,796 2.50%

2016 (a) 6,847,327,016 -0.93%

2017 (a) 7,627,909,045 11.40%

2018 (a) 8,063,401,149 5.71%

2019 (a) 8,575,101,746 6.35%

Total Certified Levy Before Credits

2008 Pay 2009 2,126,937,400 7.5%

2009 Pay 2010 2,196,356,600 3.3%

2010 Pay 2011 2,240,361,600 2.0%

2011 Pay 2012 2,279,658,400 1.8%

2012 Pay 2013 2,316,384,400 1.6%

2013 Pay 2014 2,356,123,300 1.7%

2014 Pay 2015 2,469,286,500 4.8%

2015 Pay 2016 2,641,453,600 7.0%

2016 Pay 2017 2,703,156,800 2.3%

2017 Pay 2018 2,883,978,000 6.7%

2018 Pay 2019 3,105,536,712 7.7%

2019 Pay 2020 3,305,503,632 6.4%

2020 Pay 2021* 3,482,682,000 5.4%

(9)

School District Levy Limitation and Certification Calendar

2020 Payable 2021 Levy

March 15, 2020 Deadline for eligible school districts to have submitted locally approved integration plan and budget for Fiscal Year (FY) 2020. Plan and budget should have been submitted to the Minnesota Department of Education (MDE), Office of Equity and Innovation.

May 1, 2020 CTE Budget System opens to enter 2020-2021 CTE Budget.

June 4, 2020 Deadline for districts to have submit Career and Technical estimated expenditures.

July 1, 2020 Deadline for filing a board resolution with the commissioner requesting sparsity revenue adjustment for a school facility closed for FY 2021.

School districts making a transfer from the debt redemption fund to the general fund must notify the department of the amount transferred by this date.

Department of Revenue certifies final 2019 adjusted net tax capacity for each district before this date.

Deadline for board resolution adopting a population estimate for community education and/or adult basic education revenue.

Deadline to submit population estimated for community education and/or adult basic education revenue to the state demographer.

July 15, 2020 Due date for FY 2020 Early Childhood Family Education (ECFE) Annual Report. A district may not certify a levy for ECFE unless it has submitted the report.

Deadline for county auditors to submit Six-Month Supplemental School Tax Abatement Report for current year to MDE, School Finance.

July 31, 2020 Deadline for school districts to submit annual Long-Term Facilities Application.

Minimum submission includes Ten-year Revenue Projection and Expenditure spreadsheets, statement of assurances, and board resolution approving the plan.

Additional documentation may be required.

(10)

August 14, 2020 Deadline for school districts to submit Disabled Access Revenue Levy Authority Application.

Deadline for consolidating districts to request levy authority for retirement incentives.

Deadline for cooperative secondary facilities districts, and school districts participating in an agreement for secondary education or reorganizing under dissolution and attachment, to request levy authority for severance pay and/or early retirement incentives.

Deadline for Building/Lease information and estimates to be submitted via the Levy Information System in order for it to appear on the initial levy report by September 8, 2020. (Data may be revised through September 30, 2020.) Deadline for districts to submit Debt Service data via Levy Information System in order for it to appear on the initial levy report by September 8, 2020 (Data may be revised through September 30, 2020.)

August 17, 2020 ADM Web Estimates System (ADMWE) district-wide resident, adjusted, extended-time, and English Learner (EL) ADM estimates are due to MDE.

August 21, 2020 Last day to adopt resolution calling for referendum election. **

Last day to notify county auditors of the date of the election and the questions to be voted on. **

 At least 74 days prior to election, when election is held on General Election Day.

 Minnesota Statutes, section 205A.07, subdivision 3

o Last day to notify the commissioner of education of the date of the election and the questions to be voted on. **

o At least 74 days prior to election day, when election is held on general election day

 Minnesota Statutes, section 205A.07, subdivision 3a

o Last day for school districts to review and update the ADMWE ADM and EL estimates for 2020-21, and 2021-22 for the initial levy report and forecast. Additional changes can be made for 2021-22 through September 30, 2020, for levy purposes.

August 28, 2020 Deadline for districts to submit the following data via Levy Information System.

After this date, data may be revised through September 30, 2020. (Please work with MDE when updating the information.)

 Contact Information

 Health Benefits and Annual Other Postemployment Benefits (OPEB)

 Pupil Transportation

 Elementary Sparsity

 Secondary Sparsity

 Building/Land Lease (due August 14)

 Debt Service (due August 14)

 General and Community Service

(11)

September 8, 2020 Deadline for MDE to certify levy limitations to school districts. Levy limit reruns will continue through September 30.

September 16, 2020 Deadline for districts to request approval from the commissioner to retain debt excess.

September 17, 2020 (pending)

Deadline to adjust the 2020 Payable 2021 maximum costs for Health and Safety projects.

September 30, 2020 Deadline for school districts to submit data changes to MDE.

Deadline for school boards to certify proposed property tax levies to home county auditor.

For those school districts that have reached an agreement with their home county auditor as to a delayed date for certifying the proposed levy, this date may be extended to October 7.

Deadline for MDE to certify school district levy limitations to county auditors.

October 7, 2020 Deadline for school district to submit copy of proposed levies to MDE. For those school districts that have reached an agreement with their home county auditor as to a delayed date for certifying the proposed levy, this date is extended to October 8, 2020.

October 15, 2020 Deadline for districts to submit Career and Technical actual expenditures from the 2019-2020 fiscal year in the CTE budget system.

October 19, 2020 Deadline for school districts holding referendum elections on November 3 to deliver by mail a notice of the referendum to each taxpayer in the district (at least 15 days prior to date of election).

The notice may not be mailed to taxpayers prior to October 4 (no more than 30 days prior to election). **

Deadline for school districts holding referendum elections on November 3 to provide copy of first class mail notice to county auditors and to MDE. ***

November 1, 2020 Annual Community Education Report is due.

November 2, 2020 MDE, Division of School Finance, removes ECFE and home visiting levy authorities from levy report if ECFE Annual Reports are not received.

(12)

This notice cannot be mailed earlier than November 10. (Minnesota Statutes, section 275.065, subdivision 3)

After November 24, 2020, but before final levy is adopted

Districts are required to discuss the Payable 2021 Levy and 2021-2022 fiscal year budget at a regularly scheduled board meeting and allow the public to speak.

 The meeting must take place at 6 p.m. or later.

 The district may adopt the final levy at the same meeting.

(Minnesota Statutes, section 275.065, subdivision 3) Five business days after

December 20, 2020 (December 28, 2020)

School districts must adopt their final property tax levy. **

Deadline for school districts to certify final adopted levies to home county auditor. **

Minnesota Statutes, section 275.07, subdivision 1

December 28, 2020 Deadline (on or before) for school districts to submit the Certificate of Truth-in- Taxation (TNT) Compliance and Supplement (if applicable) to the Department of Revenue, Property Tax Division.

December 31, 2020 Deadline for districts to submit FY 2020 actual building/land lease costs via Levy Information System.

January 7, 2021 Deadline for school districts to notify MDE of final certified levies.

February 1, 2021 Deadline for county auditors to submit School Tax Abatement Report for previous year to MDE.

April 1, 2021 Deadline for county auditors to submit School Tax Report to MDE.

Notes

* Minnesota Statutes require information to be turned in by the date listed. However, these dates fall on weekends.

The information and data will be due to MDE on the following Monday at the start of business hours.

** Common School Districts 323 and 815 are exempt from the public hearing requirements of Truth-in-Taxation.

However, these districts must comply with other levy certification requirements, including certification of proposed levies by September 30, 2020, and certification of final levies no later than five working days after December 20, 2020.

*** Districts holding a referendum election on November 3, 2020, should also reference "Important Election Dates" on the Minnesota School Boards Association (MSBA) website (http://www.mnmsba.org/Elections-Referendums).

(13)

Important Dates for the November 3, 2020 Referendum Elections

Source: MSBA Website

(14)

Truth in Taxation

(15)

Department of Education Website

https://education.mn.gov/

Most of the supporting documentation for levy data can be found under:

 Districts, Schools and Educators: Data Submissions o ADM Web Estimates (ADMWE)

o Long-Term Facilities Maintenance/Health and Safety o Levy Information System

o Levy Certification System

 Districts, Schools and Educators: School Finance o Facilities and Technology

o General Education o Integration

o Levy Certification Process

 Data Center: Data Reports and Analytics

o Minnesota Funding Reports (MFR) System o School Finance Spreadsheets

(16)

Data Collection Systems

ADM/EL (ADM WE)

ADM represents the portion of the school year during which a student is enrolled in the school, district or charter school.

The actual ADM is calculated based on year-end MARSS files submitted by the enrolling district or charter school.

Data entered into the ADM WE system does not update or change data in the MARSS data system, and data in the MARSS system does not update or change data in the ADM WE system. Both systems are used for student data, but the systems are independent of each other.

Main Menu of the ADM and EL Projections System:

 Users may select one of three school years when accessing data.

(17)

View Estimated ADM and EL Counts

If the District Resident ADM screen is chosen, the school-level adjusted ADM are displayed. This is where the district can update individual school’s adjusted ADM (held to 1.0 per student), EL ADM and, for learning year programs, the

extended-time ADM.

(18)

Sum School Adjusted ADM and Authorized Submission

Completion of this step authorizes the department to use the current estimates for future calculations. Districts can modify all data but without the Sum & Authorize step, the modifications will not be used. This step can also be performed without changing the data.

 An updated message will appear for the user confirming the Sum & Authorize took place.

Data 19-20 20-21 21-22__

EL NA NA P2, L118

RES P1, L40 P1, L41 P1, L42

ADJ P1, L51 P1, L52 P1, L53

EXT P2, L82 P2, L83 P2, L84

Data must be Summed and Authorized to be included in the Levy Report.

(19)

LTFM Ten-Year Revenue Projection

(20)

Health and Safety Reporting System FY 2020, FY 2021, FY 2022

https://education.mn.gov/MDE/dse/datasub/HealthSafety/

Locate H&S Approved Projects for

FY20, FY21 and FY22

Capital Expenditure Report (next page)

H&S Funded = Yes and (Ye1 and Ok1 – Pay-as-you-go) Yes = Initial revenue (FY21 $380 X APU plus

average building age calc.) P10, L453 Ye1 = Approvals for proj/per site/per year $100k - $499,999

Ok1 = Approvals for proj/per site/per year $500,000 – above P10, L455 Yeb and Okb = bonded projects (same ranges as PayGo) P10, L767

(21)

FY20 and FY21 District Totals:

Used for LTFM levy adjustments

FY22 Asbestos (358), Fire Safety (363) &

Indoor Air Quality (366) if > $100K located on P10, L455

P9, L409 FY22 District Total for H&S

Hold Harmless:

P10, L459 FY 2020 & 2021 See cap on FIN Code 352 For H&S Hold Harmless

(22)

Levy Information System

http://education.state.mn.us/MDE/dse/datasub/LevyInfo/index.html

 Contact Information

 Health Benefits and OPEB

 Pupil Transportation

 Elementary / Secondary Sparsity

 Building/Land Lease Payable 2021

 Building/Land Lease FY 2020 Actual Costs

 Building/Land Lease FY 2019 Payable 2019 Levy Adjustment

 Debt Service

 General and Community Services

 Levy Information Status

Changes for the Health Benefits and OPEB, Pupil Transportation Data, Secondary Sparsity Revenue, Building/Land Lease, Debt Service and General and Community Services should be made through the Levy Information System. After

October 1, 2020 any changes should be made through School Finance staff (with the exception that the Building/Land Lease FY 2020 Actual Costs and FY Levy Adjustment screens will remain open through December 31, 2020). Instructions on how to access this system can be found on the web site under Levy Certification Process.

(23)

Health Benefits and Annual OPEB

(A) + (B) = P12, L556

Click here to Save changes P09, L381

(24)

Pupil Transportation

P09, L403

P09, L402

P09, L400

P09, L404

P09, L406

(25)

Elementary and Secondary Sparsity

P02, L129

The information provided in the Elementary Sparsity section will be used in the calculation on P03 L135

(26)

Building/Land Lease Payable 2021

Non-joint (stand-alone) – P11, L522, L523, L526, L527, L531, L532, L535, L536, L539, L540 Intermediate District – P11, L506 – L521

Approved Joint Lease – P11, L524, L525, L528, L529, L533, L534, L537, L538, L541, L542

(27)

Building/Land Lease FY 2020 Actual Costs

(Will be used to adjust Payable 22 levy)

(28)

FY 2019/Payable 2019 Building/Land Lease Adjustments FY 2019/Payable 2018 Building/Land Lease Adjustments FY 2018/Payable 2018 Building/Land Lease Adjustments

Non-joint (stand-alone) – P22, L1252, L1253, L1261, L1262, L1271, L1272, L1280, L1281 Intermediate District – P22, L1248, L1249, L1258, L1259, L1267, L1268, L1277, L1278 Approved Joint Lease – P22, L1251, L1254, L1260, L1263, L1270, L1273, L1279, L1282

(29)

Debt Service

Facility Maintenance – H&S>100 – P13, L703 Facility Maintenance – VPK – P13, L704

(30)

General and Community Services

P08, L356

P08, L363

P08, L364

P08, L340

P08, L341

P04, L170

P09, L360

(31)

P08, L332

P10, L469

H&S Report

P12, L603

P12, L604

P12, L628

P12, L612

(32)

Levy Information Status

Check for date last modified. This is the date the data was saved and made available for levy processing.

(33)

Spreadsheet Data on MDE Website

Referendum, Inflation and Tax Base Replacement Aid

 Referendum Phaseout FY 2021 Conversion

 Estimated Cap Inflation Calculation Estimates Spreadsheet

 Tax Base Replacement Aid spreadsheet

Click on: Districts, Schools and Educators > Business > School Finance >General Education >Referendum

(34)

Referendum Phaseout FY 2021 Conversion

Phase Out Report With 2019 Elections

Authority After 2019 Elections (see detail below) 1,009.83 1,045.51 1,075.48 245.78 250.64 256.15 262.24 268.52 - - -

Elections Before 2019 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031

(1) Authority without CPI - - - - - - - - - - -

With Inflation Adjustment 2021* 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031

(2)Base Authority 1,009.83 1,009.83 1,009.83 231.54 231.54 231.54 231.54 231.54 - - -

(3)Subtraction Included in CPI Adjustment * 534.97 534.97 - - - - - - - - (4)Amount Subject to CPI Adjustment 1,009.83 1,544.80 1,544.80 231.54 231.54 231.54 231.54 231.54 - - -

(5)Cumulative CPI Factor * 1.0231 1.0425 1.0615 1.0825 1.1063 1.1326 1.1597 1.1874 - -

(6)Cumulative CPI Applied (4) * [(5)-1] * 35.68 65.65 14.24 19.10 24.61 30.70 36.98 - - - (7) Authority with CPI (2) + (6) 1,009.83 1,045.51 1,075.48 245.78 250.64 256.15 262.24 268.52 - - - (8) Total Authority (1) + (7) 1,009.83 1,045.51 1,075.48 245.78 250.64 256.15 262.24 268.52 - - - (9)Non-CPI Adjusted Phase Out/Cancel - - - - - - - - - - - (10) CPI Adjusted Phase Out/Cancel - - - 829.70 - - - - 268.52 - -

2019 Elections

Years

Delayed 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031

(11) Authority without CPI 0 - - - - - - - - - - -

With Inflation Adjustment 2021* 2022 2023 2024 2025 2026 2027 2028 2029 2030

(12)Authority 1 0 - - - - - - - - - - - (13)Cumulative CPI Factor - - - - - - - - - - - (14)Authority with CPI (12) * (13) - - - - - - - - - - - (15)Authority 2 0 - - - - - - - - - - - (16)Cumulative CPI Factor - - - - - - - - - - - (17)Authority with CPI (15) * (16) - - - - - - - - - - - (18) Authority with CPI (14) + (17) - - - - - - - - - - - (19) Total Authority (11) + (18) - - - - - - - - - - - (20)Non-CPI Adjusted Phase Out/Cancel - - - - - - - - - - (21) CPI Adjusted Phase Out/Cancel - - - - - - - - - -

P04, L187

(35)

Estimated Cap Inflation Calculation Estimates Spreadsheet

Referendum Cap Inflation Estimates

FY 2015 - FY 2029

^{no data} ^{no data} ^{no data} ^{no data}

Bureau of Labor Statistics CPI - Urban Consumers (Actual) / Minnesota Management and Budget (Estimate) June 2020 Update

no data no data A B C D E F G H I

Fiscal Year

Actual or Estimate

BLS Fiscal

Year Average Inflation Factor

Annual Projected

Inflation

Annual Projected

Inflation

%

Cumulative Avg %

Projected Inflation Ratio Standard

Cap

Projected Standard Cap

Standard Cap Increase over FY 2015 or FY2021

Projected Inflation Ratio for Inflation Based Alternative

Cap

Projected Inflation Ratio for Formula Allowance

Based Alternative

Cap Old Law Formula before FY 2021

2015 Actual 236.677 1.0000 $ 1,845.00 $ - 1.0000 1.0000 2016 Actual 238.274 0.0067 0.67% 0.67% 1.0067 $ 1,857.36 $ 12.36 1.0067 1.0050 2017 Actual 242.657 0.0184 1.84% 2.53% 1.0253 $ 1,891.68 $ 46.68 1.0253 1.0101 2018 Actual 248.126 0.0225 2.25% 4.84% 1.0484 $ 1,934.30 $ 89.30 1.0484 1.0153 2019 Actual 253.269 0.0207 2.07% 7.01% 1.0701 $ 1,974.33 $ 129.33 1.0701 1.0206 2020 Actual 257.230 0.0156 1.56% 8.68% 1.0868 $ 2,005.15 $ 160.15 1.0868 1.0260

2021 Estimate 259.221 0.0077 0.77% 9.53% 1.0953 na na na na

New Law Formula for FY 2021 and Out

2021 Estimate 259.221 1.0000 $ 1,779.50 $ - 1.0953 na

2022 Estimate 265.199 0.0231 2.31% 2.31% 1.0231 $ 1,827.54 $ 48.04 1.1205 na 2023 Estimate 270.249 0.0190 1.90% 4.25% 1.0425 $ 1,867.88 $ 88.38 1.1418 na 2024 Estimate 275.177 0.0182 1.82% 6.16% 1.0615 $ 1,907.39 $ 127.89 1.1627 na 2025 Estimate 280.634 0.0198 1.98% 8.26% 1.0825 $ 1,951.06 $ 171.56 1.1857 na 2026 Estimate 286.802 0.0220 2.20% 10.64% 1.1063 $ 2,000.55 $ 221.05 1.2118 na 2027 Estimate 293.628 0.0238 2.38% 13.27% 1.1326 $ 2,055.24 $ 275.74 1.2406 na 2028 Estimate 300.633 0.0239 2.39% 15.98% 1.1597 $ 2,111.60 $ 332.10 1.2702 na 2029 Estimate 311.704 0.0368 3.68% 20.25% 1.2024 $ 2,200.39 $ 420.89 1.3170 na

Notes:

1. Finalized calculation through FY 2020 based on actual Bureau of Labor Statistics data.

2. Projected Inflation based Standard Cap for FY 2021 is calculated as $2,079.50 - $300.00 = $1,779.50 End of Worksheet

P04, L185

(36)

Tax Base Replacement Aid Spreadsheet

276 = District Number Enter the district number in cell A1. For Minneapolis enter district = 1.2. You don't need to run a macro.

TAX BASE REPLACEMENT AID PHASEOUT REPORT MINNETONKA #276

Initial Calculations

1 Pay 2001 Referendum Levy 12,643,434.53 7 Initial Tax Base Replacement Aid =(3) X (6) = 51,014.24

2 Equalized Referendum Levy 2,904,175.78

3 Unequalized Referendum Levy 8 FY 2002 Referendum Allowance 1,471.25

= Greater of zero or [(1)-(2)] = 9,739,258.75 9 Transition/Suppl/Interest Conversion 16.20

10 Adjusted FY 2002 Allowance = zero or [(8)+(9)-415] 1,072.45 4 RMV 2000 Old Law--Ag & Seas Rec Only 19,039,495

5 RMV 2000 Old Law Total 3,634,876,185 11 Adjusted Initial Tax Base Replacement Aid

6 Tax Base Loss Ratio = (4)/(5) = 0.5% If (8)>415, then (7), Else zero 51,014.24

FY 2003 FY 2004 FY 2005 FY 2006 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011

TBRA, FY 2003 and FY 2004

12 FY 2002-Based Allowance Before Phaseout: 1,072.45 1,072.45 See Line (14) from Prior Year

13 Phaseout From Prior Year 0.00 1,072.45

14 Remaining FY 2002 Allowance = (12)-(13) = 1,072.45 0.00

15 Phaseout Percent = (13)/(10) = 0.0% 100.0%

16 Reduction for Phaseouts = (11) X (15) = 0.00 51,014.24 17 Uncapped TBRA = Prior (17)- Current (16) = 51,014.24 0.00

18 Current RMCPU 8,900.53 8,897.32

19 Cap on Authority = (14)*(18) = 9,545,373.40 0.00

20 Capped TBRA = Lesser of (17) or (19) = 51,014.24 0.00

21 Cap reduction = (17)-(20) = 0.00 0.00

TBRA, After FY 2004

10 Adjusted FY 2002 Allowance 1,072.45 1,072.45 1,072.45 1,072.45 1,072.45 1,072.45 1,072.45

22 FY 2004 RMCPU, New Law 8,897.32 8,897.32 8,897.32 8,897.32 8,897.32 8,897.32 8,897.32

23 FY 2004 RMCPU, Old Law 8,882.03 8,882.03 8,882.03 8,882.03 8,882.03 8,882.03 8,882.03

24 Converted Adjusted FY 2002 Allowance

= (10) X [(23)/(22)] = 1,070.61 1,070.61 1,070.61 1,070.61 1,070.61 1,070.61 1,070.61

25 Uncapped Current Referendum Allowance 1,382.96 1,382.96 1,382.96 1,382.96 1,382.96 1,382.96 0.00

P06, L266

(37)

Sparsity Revenue

 Sparsity Revenue: 2020 spreadsheet

 For districts with multiple high schools or elementary sparsity, FY 2020 projected sparsity revenue shown on this spreadsheet and adjusted for formula allowance changes is also used for FY 2021 and FY 2022 projected sparsity revenue

Click on: Data Center > Data Reports and Analytics

o Under “School Finance Spreadsheets” click on: General Education o From Subcategory drop down, choose Sparsity Revenue

Summary by District No Data No Data No Data No Data No Data No Data No Data Sparsity FY 2020

No DataNo DataNo Data A B C D E F G H

No DataNo DataNo Data InitialNo Data No Data No Data No Data HoldNo Data No Data

No DataNo DataNo Data SecondaryNo Data RevisedNo Data No Data Harmless RevisedNo Data

No DataNo DataNo Data Including Hold SecondaryNo Data Preliminary For Combined Adjusted

No DataNo DataNo Data Multiple Harmless = greater ofNo Data Total Closed = greater of Sum of

No DataNo DataNo Data High School Secondary A or B Elementary = C+D Schools E or F Sites

No DataNo DatastatewideColumn A. Initial secondary including multiple high schoolcolumn C. revised secondary equals greater of column a or bcolumn B. hold harmless secondary column e. preliminary total equals columns c plus dcolumn d. elementarycolumn f. hold harmless for closed schoolscolumn g. revised combined equals greater of column e or fcolumn h. adjusted sum of sites No DataNo DataTotal 22,696,004.08 1,894,340.42 22,944,988.86 1,346,940.16 24,291,929.02 4,374,897.23 25,675,388.09 25,675,388.09 district numberdistrict typedistrict nameColumn A. Initial secondary including multiple high schoolcolumn C. revised secondary equals greater of column a or bcolumn B. hold harmless secondary column e. preliminary total equals columns c plus dcolumn d. elementarycolumn f. hold harmless for closed schoolscolumn g. revised combined equals greater of column e or fcolumn h. adjusted sum of sites

1 1 Aitkin 0.00 0.00 0.00 0.00 0.00 92,989.00 92,989.00 92,989.00

1 3 Minneapolis 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2 1 Hill City 344,052.25 0.00 344,052.25 0.00 344,052.25 0.00 344,052.25 344,052.25

4 1 McGregor 576,975.47 0.00 576,975.47 0.00 576,975.47 0.00 576,975.47 576,975.47

6 3 South St. Paul 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

11 1 Anoka-Hennepin 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

12 1 Centennial 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

13 1 Columbia Heights 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

14 1 Fridley 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

15 1 St. Francis 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

16 1 Spring Lake Park 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

22 1 Detroit Lakes 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

23 1 Frazee-Vergas 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

25 1 Pine Point 0.00 0.00 0.00 140,530.65 140,530.65 0.00 140,530.65 140,530.65

31 1 Bemidji 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

32 1 Blackduck 353,699.48 0.00 353,699.48 0.00 353,699.48 0.00 353,699.48 353,699.48

36 1 Kelliher 581,239.14 0.00 581,239.14 0.00 581,239.14 0.00 581,239.14 581,239.14

38 1 Red Lake 797.40 0.00 797.40 49,442.92 50,240.32 0.00 50,240.32 50,240.32

47 1 Sauk Rapids-Rice 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

51 1 Foley 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

75 1 St. Clair 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

77 1 Mankato 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

81 1 Comfrey 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

84 1 Sleepy Eye 65,988.20 0.00 65,988.20 0.00 65,988.20 0.00 65,988.20 65,988.20

85 1 Springfield 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

88 1 New Ulm 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

91 1 Barnum 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

93 1 Carlton 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

94 1 Cloquet 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

95 1 Cromwell-Wright 429,489.25 0.00 429,489.25 0.00 429,489.25 0.00 429,489.25 429,489.25

P03, L137

Where Do All These Numbers Come From?