{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Table A","Table B","Table C"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Table A","index":0,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[57,1,57,15],[3,1,3,15],[58,1,58,15],[0,0,58,0],[22,15,24,15],[40,13,42,13],[0,1,2,1],[0,2,2,15],[21,1,21,15],[39,1,39,15],[40,10,42,10],[40,11,42,11],[40,12,42,12],[40,1,42,1],[22,14,24,14],[40,2,42,2],[40,3,42,3],[40,4,42,4],[40,5,42,5],[40,6,42,6],[40,7,42,7],[40,8,42,8],[40,9,42,9],[22,8,24,8],[22,9,24,9],[22,10,24,10],[4,1,6,1],[22,11,24,11],[22,12,24,12],[22,13,24,13],[4,13,6,13],[22,6,24,6],[22,7,24,7],[4,7,6,7],[4,8,6,8],[4,9,6,9],[4,6,6,6],[22,1,24,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5],[4,15,6,15],[4,10,6,10],[4,11,6,11],[4,12,6,12],[4,14,6,14]]}
["This cell intentionally left blank","Table A","Tax Year 2021 Minnesota Individual Income Tax Sample - Selected Fields from Federal Form 1040",null,null,null,null,null,null,null,null,null,null,null,null,null,"This cell intentionally left blank"]
[]
[]
[null,"This cell intentionally left blank"]
[null,"Federal Adjusted Gross Income Range","FAGI","Number of Returns","Wages","Count","Interest","Count","Dividends","Count","State Tax Refund","Count","Business Income (Schedule C)","Count","Capital Gains (Schedule D)","Count"]
[]
[]
[null,"Less than Zero",-2500418537,18436,304238290,6408,90647781,8176,55841509,5387,310548,111,-147381929,7435,514868813,7998]
[null,"$ 0 - 4,999",355481276,157263,341122712,95898,6325880,26729,14519233,16384,466723,369,27404533,14894,10503288,14472]
[null,"$ 5,000 - 9,999",1051847757,141133,819742578,109410,17407717,25023,15942963,14890,106373,330,59837312,16190,20300705,14226]
[null,"$ 10,000 - 19,999",4041353498,269582,2726270900,195860,30862139,56162,47406963,29058,191676,464,239299978,39925,63974254,29374]
[null,"$ 20,000 - 29,999",6622282994,263951,4479986719,202801,39459288,59721,56833824,32190,1447889,1884,342172580,40156,108065565,32087]
[null,"$ 30,000 - 39,999",9152568485,260535,7060786469,222632,26144823,55158,62195949,32753,753922,1894,302672177,32918,112814986,33342]
[null,"$ 40,000 - 49,999",11366326486,253395,8983520775,218569,27019097,62775,77657426,37751,1699734,3659,246754009,26242,220690111,39500]
[null,"$ 50,000 - 99,999",54529804198,761755,40158405138,642516,196747127,273418,585273410,184078,18236433,30462,1366036151,103573,1252104808,179820]
[null,"$100,000 - 249,999",92879613640,627791,67628211044,546325,347511653,349630,1567510723,270771,20137007,23221,1784611172,111336,4135764590,266725]
[null,"$250,000 - 499,999",37086215462,110742,23567351232,96674,263932085,80744,1093195043,77363,2859788,1361,993765815,24410,3849326482,78740]
[null,"$500,000 & Over",266020086772,59425,43830465717,49756,5755504605,54175,16516001761,50745,9626859,944,2394309219,15797,134382051235,52767]
[null,"Resident",258877834914,2747228,164687307750,2230459,1563507629,966670,5819443625,683338,43747046,59682,5922732964,401047,28037790920,674599]
[null,"Nonresident",221727327117,176780,35212793825,156390,5238054567,85040,14272935178,68034,12089906,5016,1686748051,31830,116632673917,74450]
[null,"TOTALS",480605162031,2924008,199900101575,2386849,6801562197,1051710,20092378803,751372,55836952,64698,7609481016,432877,144670464836,749050]
[null,"This cell intentionally left blank"]
[null,"Federal Adjusted Gross Income Range","Taxable IRA Distributions","Count","Taxable Pensions","Count","Schedule E Income","Count","Farm Income","Count","Taxable Unemployment Compensation","Count","Taxable Social Security Benefits","Count","Other Income","Count"]
[]
[]
[null,"Less than Zero",26519418,2373,35199396,3303,-1068403427,7586,-182433716,4005,20320281,1369,183121,27,-2117206376,7770]
[null,"$ 0 - 4,999",25997096,7067,24202382,10594,-18192487,3364,-20726385,1672,10115466,2079,805286,273,-54745802,11650]
[null,"$ 5,000 - 9,999",47869276,10674,91090603,16917,13450426,4375,-7304708,1448,26646727,4440,2419499,986,-48320709,6834]
[null,"$ 10,000 - 19,999",186160986,26413,409529768,43247,5302115,9777,-19585501,3075,393508154,35841,38183706,24974,-35829451,13752]
[null,"$ 20,000 - 29,999",260273016,26629,572580835,43283,17162865,13892,-33989561,3237,692428594,49493,168011613,48683,-23297534,15133]
[null,"$ 30,000 - 39,999",249464482,21280,563859442,37519,52153613,13764,-15101576,2899,559315408,40075,266691603,37840,-19729511,15568]
[null,"$ 40,000 - 49,999",302783390,23681,692604931,39677,62517780,16505,-16527379,4021,430390174,32464,447170899,39892,-26433102,14376]
[null,"$ 50,000 - 99,999",2003843042,108384,4068024859,169984,776864318,80489,-30827660,16505,1204042679,89897,3283619144,169517,19198381,58036]
[null,"$100,000 - 249,999",3660115192,119854,5930968442,158992,3457450161,126800,43796914,18993,782704412,60473,3637333502,130622,274309801,63752]
[null,"$250,000 - 499,999",1302634830,23575,1370493818,25164,4028056337,45190,30056431,4319,56252827,4313,661316046,20360,189830475,16082]
[null,"$500,000 & Over",1157415425,10884,632056447,9993,53177684991,41734,-908141276,2233,15761039,1154,363921540,10637,1121300296,15465]
[null,"Resident",8284506761,359698,13434138952,528947,20757791895,315014,-201861375,57581,3918535628,299919,8279514788,460563,-424744523,216168]
[null,"Nonresident",938569393,21117,956471970,29725,39746254798,48462,-958923041,4827,272950135,21678,590141173,23249,-296179008,22250]
[null,"TOTALS",9223076153,380815,14390610922,558672,60504046693,363476,-1160784417,62408,4191485763,321597,8869655961,483812,-720923531,238418]
[null,"This cell intentionally left blank"]
[null,"Federal Adjusted Gross Income Range","Federal Gross Income","Count","IRA Deduction","Count","Student Loan Interest Deduction","Count","Self-Employment Tax Deduction","Count","Standard Deduction","Count","Federal Taxable Income","Count"]
[]
[]
[null,"Less than Zero",-2460915646,18275,538212,103,1161185,842,4800484,2614,308210108,16951,0,0]
[null,"$ 0 - 4,999",367005769,141687,436107,62,1439120,1461,2808057,12985,1639948791,155473,8144461,5258]
[null,"$ 5,000 - 9,999",1069709623,141133,145936,186,697987,1417,6904526,15436,1641903816,138246,24117128,5701]
[null,"$ 10,000 - 19,999",4100733876,269582,6676421,2055,3792405,6112,22074873,31670,3895185330,265623,535568394,155410]
[null,"$ 20,000 - 29,999",6696582048,263951,12183144,2828,9701115,10392,30488561,32387,3980598567,258158,2543996448,240694]
[null,"$ 30,000 - 39,999",9245509847,260535,17925005,3758,12208622,11467,28020380,25399,4050311708,255076,4908689722,259017]
[null,"$ 40,000 - 49,999",11466962922,253395,27725185,5590,14717623,17817,24907009,20305,3916821236,244275,7174869388,252259]
[null,"$ 50,000 - 99,999",55023693538,761755,89846309,17060,48156441,56559,129786044,85628,13083716103,689010,39229194905,759775]
[null,"$100,000 - 249,999",93781587163,627791,110667126,18590,30806959,43298,201214675,92532,12648303980,525458,76006413966,627352]
[null,"$250,000 - 499,999",37666925971,110742,13493596,1325,9888,40,95962227,24916,1748227513,70958,32852906148,110706]
[null,"$500,000 & Over",267189695260,59425,8551692,828,0,0,241317168,20668,529866142,21807,231640083007,59328]
[null,"Resident",261453666641,2731489,269274894,48927,112353781,139149,570491264,335065,44762273743,2500161,204638048221,2305330]
[null,"Nonresident",222693823731,176780,18913839,3460,10337564,10255,217792739,29475,2680819551,140875,190285935346,170168]
[null,"TOTALS",484147490372,2908270,288188734,52387,122691345,149404,788284004,364540,47443093294,2641037,394923983567,2475498]
[null,"This cell intentionally left blank"]
[null,"Note: Parts may not sum to totals due to rounding."]

{"sheet":"Table B","index":1,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,4,6,4],[21,1,21,11],[22,8,25,8],[4,2,6,2],[4,1,6,1],[22,2,25,2],[22,1,25,1],[4,5,6,5],[4,6,6,6],[0,0,41,0],[4,8,6,8],[4,9,6,9],[4,10,6,10],[4,11,6,11],[0,2,2,13],[0,1,2,1],[3,1,3,13],[22,9,25,9],[4,3,6,3],[4,7,6,7],[22,3,25,3],[22,4,25,4],[22,5,25,5],[22,6,25,6],[22,7,25,7]]}
["This cell intentionally left blank","Table B","Tax Year 2021 Minnesota Individual Income Tax Sample - Selected Fields from Federal Schedule A(Itemizers Only)",null,null,null,null,null,null,null,null,null,null,null,"This cell intentionally left blank"]
[]
[]
[null,"This cell intentionally left blank"]
[null,"Federal Adjusted Gross Income Range","Total Itemized Deductions - 1040","Count","Medical Expense Deduction","Count","State Income Tax Deduction","Count","Real Estate Taxes Deduction","Count","Total Taxes Deduction","Count"]
[]
[]
[null,"Less than Zero",137327461,1467,15076356,848,26079597,1201,16266271,1206,10972338,1368]
[null,"$ 0 - 4,999",20158323,1362,10872090,629,859701,1327,4092718,840,4745694,1362]
[null,"$ 5,000 - 9,999",43183655,2297,35428440,1267,756940,1992,930810,311,1730037,2055]
[null,"$ 10,000 - 19,999",90399042,3804,58391307,3055,10012633,3526,9002902,2024,12879702,3526]
[null,"$ 20,000 - 29,999",139593961,5425,76874098,4107,6304187,4738,13307256,3749,19201346,4874]
[null,"$ 30,000 - 39,999",132220826,5273,61529912,3186,11386155,5235,13585783,4404,24291190,5273]
[null,"$ 40,000 - 49,999",190381619,8643,51943496,3344,25284902,8571,33760337,7624,47380948,8643]
[null,"$ 50,000 - 99,999",1730557095,72196,494794004,22661,271964413,71062,221772153,63051,484448458,71363]
[null,"$100,000 - 249,999",3141362770,102205,375113767,19821,875087651,101590,1059709852,92427,944340603,102103]
[null,"$250,000 - 499,999",1615561594,39752,52748444,1751,912988086,39651,306724654,37557,394731152,39721]
[null,"$500,000 & Over",25917563967,37591,37854131,465,13089680299,37469,809752519,34146,451134720,37559]
[null,"Resident",9415402219,245508,1187577214,57304,5069062234,242163,1863026597,217428,2004153561,243474]
[null,"Nonresident",23742908094,34507,83048833,3831,10161342330,34199,625878657,29910,391702626,34373]
[null,"TOTALS",33158310313,280016,1270626047,61135,15230404564,276362,2488905255,247338,2395856187,277847]
[null,"This cell intentionally left blank",null,null,null,null,null,null,null,null,null,null,"This cell intentionally left blank"]
[null,"Federal Adjusted Gross Income Range","Total Home Mortgage Interest Deduction (& Points)","Count","Investment Interest Deduction","Count","Charitable Contributions Deduction - Cash","Count","Charitable Contributions Deduction - Non-Cash","Count"]
[]
[]
[]
[null,"Less than Zero",18612019,1106,38089508,338,0,0,0,0]
[null,"$ 0 - 4,999",4198119,529,39487,64,192468,507,21323,332]
[null,"$ 5,000 - 9,999",2113214,372,0,0,1345618,726,5800,124]
[null,"$ 10,000 - 19,999",7373134,1154,0,0,8020452,2183,340253,747]
[null,"$ 20,000 - 29,999",22186845,2978,75669,138,14026848,3393,780913,1421]
[null,"$ 30,000 - 39,999",27094184,3729,27977,244,7681722,3289,2245267,2113]
[null,"$ 40,000 - 49,999",54690375,6852,3635174,59,21993220,5489,2586208,3455]
[null,"$ 50,000 - 99,999",429512009,57439,2067672,786,178254390,45228,40299666,29696]
[null,"$100,000 - 249,999",807755040,83272,30850701,2547,604158965,80908,131506021,50419]
[null,"$250,000 - 499,999",491672780,33056,23015405,3185,427610771,34223,112834473,22009]
[null,"$500,000 & Over",467266484,27120,1818538320,12160,10736403675,35024,10418978597,19204]
[null,"Resident",1981482128,191966,164415247,11003,2202915419,183674,1174751602,114730]
[null,"Nonresident",350992076,25640,1751924668,8519,9796772710,27295,9534846919,14790]
[null,"TOTALS",2332474204,217606,1916339914,19522,11999688129,210969,10709598521,129520]
[null,"This cell intentionally left blank"]
[null,"Note: Parts may not sum to totals due to rounding."]
[null,"*Counts less than 10 have $ amount included in next higher non-zero FAGI range"]

{"sheet":"Table C","index":2,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,1,39,13],[4,1,6,1],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5],[22,7,24,7],[22,9,24,9],[4,6,6,6],[4,8,6,8],[4,7,6,7],[4,9,6,9],[4,10,6,10],[4,11,6,11],[21,1,21,13],[3,1,3,13],[0,0,40,0],[40,1,40,13],[0,1,2,1],[0,2,2,13],[22,11,24,11],[22,13,24,13],[22,4,24,4],[22,6,24,6],[22,8,24,8],[22,10,24,10],[22,12,24,12],[22,1,24,1],[22,2,24,2],[22,3,24,3],[22,5,24,5]]}
["This cell intentionally left blank","Table C","Tax Year 2021 Minnesota Individual Income Tax Sample - Selected Fields from Minnesota Form M-1",null,null,null,null,null,null,null,null,null,null,null,"This cell intentionally left blank"]
[]
[]
[null,"This cell intentionally left blank"]
[null,"Federal Adjusted Gross Income Range","Federal Taxable Income","Count","Total Other Additions","Count","Total Other Subtractions","Count","State Income Tax Refund Subtraction","Count","Nonitemizer Charitable Contributions","Count"]
[]
[]
[null,"Less than Zero",-1821186455,16894,990295305,4424,249312285,6352,324639,124,2209207,1592]
[null,"$ 0 - 4,999",-941394303,121075,14738529,2512,43669664,15464,466723,369,3255105,6563]
[null,"$ 5,000 - 9,999",-483648605,114392,27284515,2947,38910370,14626,246902,540,5545441,8206]
[null,"$ 10,000 - 19,999",132373552,247449,40076539,5675,146543480,50304,207894,601,18843662,23617]
[null,"$ 20,000 - 29,999",2486042934,259141,60792084,6110,312571379,70205,1436775,1884,21659702,26285]
[null,"$ 30,000 - 39,999",4906266187,259814,34026999,5461,329613738,66204,758068,1986,24891581,29167]
[null,"$ 40,000 - 49,999",7181372370,253028,39142470,7270,402620833,73780,1691965,3659,33647035,35961]
[null,"$ 50,000 - 99,999",39164562903,759958,145507998,33266,1617486156,316535,18329545,30670,193834188,182665]
[null,"$100,000 - 249,999",75966436069,627059,604077714,76204,1545011666,348795,21061126,24269,379754700,268084]
[null,"$250,000 - 499,999",32846864677,110692,686201249,33975,736376853,73739,2951441,1525,80719588,50050]
[null,"$500,000 & Over",231135613913,59355,8059495536,31906,5085086505,40245,10321228,1258,37058740,16312]
[null,"Resident",200957677904,2652823,4876796868,185435,7550164424,1015047,45291813,61735,751718229,610516]
[null,"Nonresident",189615625339,176033,5824842070,24316,2957038506,61201,12504492,5148,49700720,37987]
[null,"TOTALS",390573303243,2828856,10701638938,209751,10507202930,1076248,57796305,66883,801418948,648503]
[null,"This cell intentionally left blank"]
[null,"Federal Adjusted Gross Income Range","Dependent Education Subtraction","Count","Tax Liability (Line 20 on the M1 Form)","Count","Marriage Credit","Count","Dependent Care Credit","Count","Working Family Credit","Count","Education Credit","Count"]
[]
[]
[null,"Less than Zero",915631,391,13957644,840,11086,24,87356,94,919297,1374,128983,386]
[null,"$ 0 - 4,999",657385,1172,840404,6117,0,0,141173,344,5836221,37440,396883,1565]
[null,"$ 5,000 - 9,999",205995,450,2276593,6085,0,0,193590,211,15790834,45161,195735,942]
[null,"$ 10,000 - 19,999",656269,1512,27964881,140690,0,0,2160992,3626,52891779,129850,1243030,3780]
[null,"$ 20,000 - 29,999",2108473,3920,116961511,206646,0,0,3525627,5605,65014384,79434,1940092,6424]
[null,"$ 30,000 - 39,999",4860846,7374,224772628,240355,0,0,4635793,8097,59238325,55044,1457919,5289]
[null,"$ 40,000 - 49,999",7886913,9802,350782575,246760,0,0,3648556,6906,20805822,31352,0,0]
[null,"$ 50,000 - 99,999",46653112,42886,2085321996,752112,9997816,80993,7233080,15815,2320020,6808,0,0]
[null,"$100,000 - 249,999",93286178,67342,4466207769,625986,56511426,310577,0,0,null,0,0,0]
[null,"$250,000 - 499,999",27972003,12765,2284817718,110372,12533184,25458,0,0,0,0,0,0]
[null,"$500,000 & Over",17105244,5973,5543493446,58912,9020458,9922,0,0,0,0,0,0]
[null,"Resident",198288576,151422,14152881871,2226424,85227456,399198,21234797,39563,220139671,379335,5362642,18386]
[null,"Nonresident",4019472,2166,964515295,168451,2846514,27776,388070,1136,2677010,7130,0,0]
[null,"TOTALS",202308049,153588,15117397165,2394875,88073970,426974,21622867,40698,222816681,386465,5362642,18386]
[null,"This cell intentionally left blank"]
[null,"Note: Parts may not sum to totals due to rounding"]
[null,"*Counts less than 10 have $ amount included in next higher non-zero FAGI range"]