Better Analysis

Administrative records, particularly corporate tax and unemployment insurance (UI) records, represent some of the most reliable data sets available for conducting policy analysis and program evaluation of economic and workforce development programs. Government agencies can use these data to measure state-specific program performance and impact; improve policies, program outcomes, and regulatory initiatives; and ensure that taxpayer dollars are directed to the most effective programs.

Identifying "Evaluation-Relevant" Data Elements in State Corporate Income Tax Forms

State corporate income tax forms include a variety of data elements that could enhance economic and workforce development policy analysis and program evaluation. These "evaluation-relevant" data elements can be grouped into four categories: 1) Company background information, 2) General tax information, 3) Tax credit information, and 4) Reported economic impact (of tax credits) information. Examples of evaluation-relevant data elements include:

1. Company Background Information
  • Company identification number
  • Business type
  • Industry classification code
2. General Tax Information
  • State taxable income
  • Total sales
  • Total wages
3. Tax Credit Information
  • Value of tax credits claimed
  • Value of tax credits sold
  • Sales price of tax credits sold
4. Economic Impact Information
  • Number of new jobs created
  • Average wages for new jobs
  • Job titles for new jobs

For detailed descriptions of "evaluation-relevant" data elements, download the Data Element Glossary.

Validating Program Impacts with Corporate Income Tax Data

Analyzing these data elements can help leaders answer critical questions about the impact of public investment in economic and workforce development, such as:

  • Which companies and workers are most at risk of downsizing or closing and therefore need help?
  • How are trends in tax credit claims impacting the state budget? Can recognizable patterns aid government service planning?
  • Are companies fulfilling their promises to create or retain jobs and generate new economic activity?
  • What types of jobs are actually created as a result of tax credit program participation? Do they offer high enough wages to help increase the state's overall economic prosperity?
Assessing the Value of State Corporate Income Tax Data for Measuring Economic & Workforce Development Program Impacts

The data elements collected on corporate income tax forms vary from state to state. The manner in which the data must be reported may also differ. For example, one state form may ask for only the sum of all tax credits claimed while another form asks for the value of individual tax credits claimed. These differences could have an impact on the value of the data for conducting policy analysis and program evaluation. Microdata that is specific to individual tax credit programs can facilitate more rigorous analysis than aggregated information can.

SDS gathered and analyzed the 2015 corporate income tax forms for all 50 states and the District of Columbia that tax businesses. The forms were collected from state revenue department websites. The goal of the study was to determine which "evaluation-relevant" data elements are the most and least commonly collected and to identify states that collect the greatest number of "evaluation-relevant" data elements.

The results of the 2015 corporate income tax form analysis can be accessed through the SDS Initiative's State Tax Data Comparison Tool.

State Tax Data Comparison Tool

The State Tax Data Comparison Tool can be used to compare what types of "evaluation-relevant" data elements different states collected on their 2015 corporate income tax forms and attached schedules for economic development tax credit programs.

How It Works

The tool identifies 24 "evaluation-relevant" data elements and tabulates the elements collected by individual states and territories. It also provides the Tax Form ID for all forms and schedules analyzed. Upon review, a score of 1, 0, or N/A is assigned for each data elements.

Score Definition
1 Yes; the state collects the data element.
0 No; the state or territory does not collect the data element.
N/A The state or territory does not collect corporate income tax.

Download the tool by clicking on the "Download Tool" button at the bottom of the screen. A Data Elements Glossary containing detailed descriptions of the 24 data elements and sample program impact evaluation questions is also available for download.

  • To compare the number of data elements different states collect, sort the "Individual State Frequency Count" column (Column Z) largest to smallest.
  • To compare how often different data elements are collected by all states, view the "Frequency Count" row (Row 55).
State Tax Data Comparison Tool (Excel) Data Elements Glossary (PDF)
Summary
Company Background Information
General Tax Information
Tax Credit Information
Reported Economic Impact Information
State Total Data Elements Collected Company Background Information General Tax Information Tax Credit Information Reported Economic Impact Information References
Total 132 278 91 17
Alabama 14 3 9 2 0 20C; Schedule BC;
Alaska 13 2 9 2 0 6000; 6300; 6390
Arizona 13 3 8 2 0 120
Arkansas 14 3 9 2 0 AR1100CT; AR1100BIC;
California 7 3 2 1 1 100; 100-S; 3554
Colorado 18 4 9 3 2 112; DR 0086; DR 0074; DR 0075
Connecticut 16 4 9 3 0 CT-1120; CT-1120A; CT-1120K; CT-1120 CR
Delaware 10 1 9 0 0 1100
District of Columbia 14 2 9 2 1 D-20; Schedule UB
Florida 13 3 8 2 0 F-1120; F-851
Georgia 12 2 6 4 0 600
Hawaii 8 3 3 2 0 N-300; Schedule CR
Idaho 5 2 2 1 0 41
Illinois 13 4 4 3 2 IL-1120; IL-477; Schedule M; Schedule 1299-B; Schedule 1299-D
Indiana 11 4 5 2 0 IT-20S; IT-20X; IN-EDGE; Schedule E
Iowa 17 4 5 4 4 IA 1120; IA 133; IA 148;
Kansas 14 4 8 2 0 KS-120
Kentucky 15 4 9 2 0 720; 5695-K; Schedule A; Schedule TCS; 750
Louisiana 14 4 8 2 0 R-10609; R-6906A; CIFT-620; R-6140
Maine 12 2 8 2 0 1120ME
Maryland 14 4 8 2 0 500; 502S
Massachusetts 15 4 9 2 0 355; Schedule H; Schedule F
Michigan 9 2 5 2 0 4891; 4893; 4902
Minnesota 13 4 5 2 2 C101; M4; JOBZ
Mississippi 14 4 8 2 0 83-105; 83-110; 83-401; 83-125
Missouri 21 3 8 5 5 1120; MO-TC; 4458; MO-JTC; MO-NJD; MO-MS; MO-TF; MO-QJP: MO-RJC
Montana 11 3 6 2 0 CIT
Nebraska 10 4 4 2 0 1120N; 3800N; CDN
Nevada 0 0 0 0 0 N/A
New Hampshire 1 0 1 0 0 BET; DP-160,
New Jersey 11 3 6 2 0 CBT-100
New Mexico 14 4 8 2 0 CIT-1; CIT-CR
New York 8 2 4 2 0 CT-3
North Carolina 14 3 9 2 0 CD-401S, CD-425
North Dakota 10 2 6 2 0 Form 40
Ohio 0 0 0 0 0 N/A
Oklahoma 14 4 8 2 0 512
Oregon 8 3 3 2 0 20-I; See Schedule ASC-CORP
Pennsylvania 7 3 4 0 0 RCT-101
Rhode Island 9 3 5 1 0 RI-1065
South Carolina 5 1 3 1 0 SC1120S; SC1120-TC
South Dakota 0 0 0 0 0 N/A
Tennessee 11 3 6 2 0 FAE 170
Texas 0 0 0 0 0 N/A
Utah 11 1 8 2 0 TC-20
Vermont 6 2 2 2 0 CO-411 ;See Schedule BA-404
Virginia 8 4 2 2 0 500 ;See Schedule 500CR, Part XXXV
Washington 0 0 0 0 0 N/A
West Virginia 12 3 7 2 0 CNF-120
Wisconsin 9 2 4 3 0 5S
Wyoming 0 0 0 0 0 N/A
State FEIN Business Organization Type NAICS Code Business Activity Survey or Questionnaire
Total 42 28 37 25
Alabama 1 1 1 0
Alaska 1 0 1 0
Arizona 1 1 1 0
Arkansas 1 1 1 0
California 1 1 0 1
Colorado 1 1 1 1
Connecticut 1 1 1 1
Delaware 1 0 0 0
District of Columbia 1 0 0 1
Florida 1 1 1 0
Georgia 1 0 1 0
Hawaii 1 1 1 0
Idaho 1 0 1 0
Illinois 1 1 1 1
Indiana 1 1 1 1
Iowa 1 1 1 1
Kansas 1 1 1 1
Kentucky 1 1 1 1
Louisiana 1 1 1 1
Maine 1 0 1 0
Maryland 1 1 1 1
Massachusetts 1 1 1 1
Michigan 1 0 1 0
Minnesota 1 1 1 1
Mississippi 1 1 1 1
Missouri 1 1 0 1
Montana 1 0 1 1
Nebraska 1 1 1 1
Nevada N/A N/A N/A N/A
New Hampshire 0 0 0 0
New Jersey 1 1 0 1
New Mexico 1 1 1 1
New York 0 0 1 1
North Carolina 1 1 1 0
North Dakota 1 0 1 0
Ohio N/A N/A N/A N/A
Oklahoma 1 1 1 1
Oregon 1 0 1 1
Pennsylvania 1 0 1 1
Rhode Island 1 1 1 0
South Carolina 1 0 0 0
South Dakota N/A N/A N/A N/A
Tennessee 1 1 1 0
Texas N/A N/A N/A N/A
Utah 0 0 1 0
Vermont 1 0 1 0
Virginia 1 1 1 1
Washington N/A N/A N/A N/A
West Virginia 1 1 0 1
Wisconsin 1 0 1 0
Wyoming N/A N/A N/A N/A
State Gross Income State Taxable Income Corporate Tax Owed Total Property Value, State vs. Everywhere (in Dollars) Total Property Value, State vs. Everywhere (as a Percentage) Total Sales, State vs. Everywhere (in Dollars) Total Sales, State vs. Everywhere (as a Percentage) Total Wage, State vs. Everywhere (in Dollars) Total Wage, State vs. Everywhere (as a Percentage)
Total 20 41 41 31 26 38 33 25 23
Alabama 1 1 1 1 1 1 1 1 1
Alaska 1 1 1 1 1 1 1 1 1
Arizona 0 1 1 1 1 1 1 1 1
Arkansas 1 1 1 1 1 1 1 1 1
California 0 1 1 0 0 0 0 0 0
Colorado 1 1 1 1 1 1 1 1 1
Connecticut 1 1 1 1 1 1 1 1 1
Delaware 1 1 1 1 1 1 1 1 1
District of Columbia 1 1 1 1 1 1 1 1 1
Florida 0 1 1 1 1 1 1 1 1
Georgia 0 1 1 1 1 1 1 0 0
Hawaii 1 1 1 0 0 0 0 0 0
Idaho 0 1 1 0 0 0 0 0 0
Illinois 0 1 1 0 0 1 1 0 0
Indiana 1 1 1 0 0 1 1 0 0
Iowa 1 1 1 0 0 1 1 0 0
Kansas 0 1 1 1 1 1 1 1 1
Kentucky 1 1 1 1 1 1 1 1 1
Louisiana 1 1 0 1 1 1 1 1 1
Maine 0 1 1 1 1 1 1 1 1
Maryland 0 1 1 1 1 1 1 1 1
Massachusetts 1 1 1 1 1 1 1 1 1
Michigan 1 1 1 0 0 1 1 0 0
Minnesota 1 1 1 0 0 1 1 0 0
Mississippi 0 1 1 1 1 1 1 1 1
Missouri 0 1 1 1 1 1 1 1 1
Montana 0 1 1 1 1 1 1 0 0
Nebraska 0 1 1 0 0 1 1 0 0
Nevada N/A N/A N/A N/A N/A N/A N/A N/A N/A
New Hampshire 0 0 1 0 0 0 0 0 0
New Jersey 1 1 1 1 0 1 0 1 0
New Mexico 0 1 1 1 1 1 1 1 1
New York 0 0 1 1 0 1 0 1 0
North Carolina 1 1 1 1 1 1 1 1 1
North Dakota 0 0 0 1 1 1 1 1 1
Ohio N/A N/A N/A N/A N/A N/A N/A N/A N/A
Oklahoma 1 1 1 1 1 1 0 1 1
Oregon 0 1 1 0 0 1 0 0 0
Pennsylvania 0 1 1 1 0 1 0 0 0
Rhode Island 0 1 0 0 0 1 1 1 1
South Carolina 0 0 0 1 0 1 1 0 0
South Dakota N/A N/A N/A N/A N/A N/A N/A N/A N/A
Tennessee 0 1 1 1 1 1 1 0 0
Texas N/A N/A N/A N/A N/A N/A N/A N/A N/A
Utah 0 1 1 1 1 1 1 1 1
Vermont 0 1 1 0 0 0 0 0 0
Virginia 0 1 1 0 0 0 0 0 0
Washington N/A N/A N/A N/A N/A N/A N/A N/A N/A
West Virginia 1 1 1 1 1 1 1 0 0
Wisconsin 1 1 1 1 0 0 0 0 0
Wyoming N/A N/A N/A N/A N/A N/A N/A N/A N/A
State Combined Value of All Tax Credits Claimed Value of Tax Credits Claimed, by Program (on Income Tax Form) Value of Tax Credits Claimed, by Program (on an Attached Schedule) Value of Tax Credits Sold Discount Rate Applied to Tax Credits Sold Sales Price for Tax Credits Sold
Total 37 15 31 4 2 2
Alabama 1 0 1 0 0 0
Alaska 1 0 1 0 0 0
Arizona 1 1 0 0 0 0
Arkansas 1 0 1 0 0 0
California 0 1 0 0 0 0
Colorado 1 1 1 0 0 0
Connecticut 1 0 1 1 0 0
Delaware 0 0 0 0 0 0
District of Columbia 1 0 1 0 0 0
Florida 1 1 0 0 0 0
Georgia 1 1 0 1 0 1
Hawaii 1 0 1 0 0 0
Idaho 1 0 0 0 0 0
Illinois 1 1 1 0 0 0
Indiana 1 0 1 0 0 0
Iowa 1 1 1 0 1 0
Kansas 1 0 1 0 0 0
Kentucky 1 0 1 0 0 0
Louisiana 0 0 1 1 0 0
Maine 1 1 0 0 0 0
Maryland 1 0 1 0 0 0
Massachusetts 1 0 1 0 0 0
Michigan 1 0 1 0 0 0
Minnesota 1 1 0 0 0 0
Mississippi 1 0 1 0 0 0
Missouri 1 0 1 1 1 1
Montana 1 0 1 0 0 0
Nebraska 0 1 1 0 0 0
Nevada N/A N/A N/A N/A N/A N/A
New Hampshire 0 0 0 0 0 0
New Jersey 1 0 1 0 0 0
New Mexico 1 0 1 0 0 0
New York 1 1 0 0 0 0
North Carolina 1 0 1 0 0 0
North Dakota 1 1 0 0 0 0
Ohio N/A N/A N/A N/A N/A N/A
Oklahoma 1 0 1 0 0 0
Oregon 1 0 1 0 0 0
Pennsylvania 0 0 0 0 0 0
Rhode Island 0 0 1 0 0 0
South Carolina 0 0 1 0 0 0
South Dakota N/A N/A N/A N/A N/A N/A
Tennessee 1 1 0 0 0 0
Texas N/A N/A N/A N/A N/A N/A
Utah 1 0 1 0 0 0
Vermont 1 0 1 0 0 0
Virginia 1 0 1 0 0 0
Washington N/A N/A N/A N/A N/A N/A
West Virginia 1 1 0 0 0 0
Wisconsin 1 1 1 0 0 0
Wyoming N/A N/A N/A N/A N/A N/A
State Number of New Jobs, Attributable to Program Average Hourly Wage of New Jobs, Attributable to Program Gross Wages for New Jobs, Attributable to Program Job Titles for New Jobs, Attributable to Program Counties Where New Jobs Were Created, Attributable to Program
Total 6 3 5 2 1
Alabama 0 0 0 0 0
Alaska 0 0 0 0 0
Arizona 0 0 0 0 0
Arkansas 0 0 0 0 0
California 1 0 0 0 0
Colorado 1 0 1 0 0
Connecticut 0 0 0 0 0
Delaware 0 0 0 0 0
District of Columbia 0 0 1 0 0
Florida 0 0 0 0 0
Georgia 0 0 0 0 0
Hawaii 0 0 0 0 0
Idaho 0 0 0 0 0
Illinois 1 0 1 0 0
Indiana 0 0 0 0 0
Iowa 1 1 1 1 0
Kansas 0 0 0 0 0
Kentucky 0 0 0 0 0
Louisiana 0 0 0 0 0
Maine 0 0 0 0 0
Maryland 0 0 0 0 0
Massachusetts 0 0 0 0 0
Michigan 0 0 0 0 0
Minnesota 1 1 0 0 0
Mississippi 0 0 0 0 0
Missouri 1 1 1 1 1
Montana 0 0 0 0 0
Nebraska 0 0 0 0 0
Nevada N/A N/A N/A N/A N/A
New Hampshire 0 0 0 0 0
New Jersey 0 0 0 0 0
New Mexico 0 0 0 0 0
New York 0 0 0 0 0
North Carolina 0 0 0 0 0
North Dakota 0 0 0 0 0
Ohio N/A N/A N/A N/A N/A
Oklahoma 0 0 0 0 0
Oregon 0 0 0 0 0
Pennsylvania 0 0 0 0 0
Rhode Island 0 0 0 0 0
South Carolina 0 0 0 0 0
South Dakota N/A N/A N/A N/A N/A
Tennessee 0 0 0 0 0
Texas N/A N/A N/A N/A N/A
Utah 0 0 0 0 0
Vermont 0 0 0 0 0
Virginia 0 0 0 0 0
Washington N/A N/A N/A N/A N/A
West Virginia 0 0 0 0 0
Wisconsin 0 0 0 0 0
Wyoming N/A N/A N/A N/A N/A