1
Basic Personal Amount Calculations
2
Data Source: Canadian Income Survey - https://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=5200
3
Accompanying UBI Works Article: How to Pay for Basic Income
4
5
6
7
8
1. Utilizing an individual's Market Income (MTINC, Column AV) the sum of earnings, net investment income, private retirement income, and "Other income"; we ask in Column AW if they are over the 3rd federal tax bracket (\$151,978).
9
2. If they fall above the 3rd tax bracket then we calculate a percentage of their BPA to be included in the lowest bracket (Additional Tax Potential, Column AX).
10
This percentage is defined as amount of income they make in the 3rd tax bracket where \$151,978 would correspond to 0% and \$216,511 (bottom of 4th bracket) would correspond to 100%
11
3. The value of additional income tax is then multipled by the FWEIGHT (Column D) to create Weighted Tax Potential (Column AY), and all entries summed to achieve an estimate of the total available additional revenue. (FWEIGHT is the statistical weight or multiplier to be applied to each case (or line) to determine the total number of cases represented by that line. I.e. If for any given line the FWEIGHT is 100, you can assume 100 people share the exact same details.)
12
13
YEARPUMFID
PERSONID
FWEIGHTPROVUSZGAP
MBMREGP
AGEGPSEXMARSTCMPHIHLEV2G
STUDTFP
FLLPRTP
FWORKED
SCSUMALFSTWKSEM
WKSUEM
WKSNLFUSHRWKALHRWKFPDWKFSEMPFUNFWIMMSTP
YRIMMGP
ALIMOALIPATINCCAPGNCCARCHFEDCHPRVCHTXBCPQPPCQPCEARNGEIPRFDITXFMSEGIGSTXCGTRINCTXINVAMAJRIMTINC
Over 3rd Bracket?
Weighted Tax Potential
NFMSEOASOASGIOGOVTROTHINCOTTXMPENPENGIVPENRECPHPRPRPENPVITXPVTXCRPPCRSPWISAPISSEMPTTINCUDPDUIBENWGSALWKRCP
14
20172129212901752.8642240818042062111112015200#NULL!520122260012075000000501240010000007540000212400NO0034000000000000400750003400124750090000
15
20172129212902752.8642240818041062111121058044#NULL!320122260010530000000011100750000057000211100NO00460000000000005700000460011100225065000
16
20172129212903752.8642240818102021226230030052#NULL!999666626006250004000220062000000000062000500450NO000000000000000000062500000
17
20172129212904752.8642240818101021226111015200#NULL!2080212260010358518000000057501200000773000001674032503120325NO001200000000000000901000001200001203250000
18
20172130213001138.023812050716101136623096969696#NULL!9996666660069570250000800000028600001500059804250660550NO00070007000012512533000270000060000312000000755500000
19
20172130213002138.0238120507152011366230030052#NULL!999666666002245250000185000036000009100743042504575NO000725072500150150440000440000038300000096750000
20
2017213121310184.0902480838151041466111015200#NULL!166412226006358032000000125002400550008258110000195001232014000256400NO000700070000000000042100650000759007750550000
21
20172132213201290.6734350422092011326111015200#NULL!208012266005053008250600006000022005000080036500006000547000250000NO0000000000000182001250000560001750500000
22
20172132213202290.6734350422101011326111015200#NULL!228812266004147000000023004900077550800000753000249000NO000000000000024500250004900000490000
23
20172132213203290.673435042202296666669696969696#NULL!9996666660000000000000000000960NO000000000000000000000000
24
20172132213204290.673435042201296666669696969696#NULL!9996666660000000000000000000960NO000000000000000000000000
25
201721332133011036.7699350826151021366111015200#NULL!1872122150070760000009750825310004258130000170001234000666100NO00072507250011001100165001750000340004210000008310000310000
26
201721332133021036.7699350826142021366230030052#NULL!999666626005900000082500075000015509600040NO000000001950001950000210000725015500000
27
2017213421340199.4647470130122011366111015200#NULL!1664212660072750000004757250000000025037275NO007250000000000000000725072750000
28
2017213421340299.4647470130131011266111015200#NULL!260011266006259500000026007500082581800000125801750275175NO00000000000004400000007517500750000
29
20172135213501220.9550240617062021312111015200#NULL!208012266002162000000085020000275800050017008000220000NO0000000000000012002500021700250200000
30
20172135213502220.95502406170710213261210438140#NULL!15201226600559000000032557507516000001600025750NO000000000000000000057500057500
31
20172136213601135.4107240617151012166230030052#NULL!99966666600191900000095000500000012900100046300NO000340034000006250000625010000001920000500
32
20172136213602135.4107240617142012166112015200#NULL!1196122660022975000001700700160001250003006975000216000NO0000000000000077500002297500160004200
33
20172137213701114.8913350623122021366111015200#NULL!15601226600516800000002300550008252490000200352000255000NO000000000000010302002900000552006000550000
34
20172137213702114.8913350623121021366230030052#NULL!999666666003200000000000000000000632000NO000000003200000032000000000320000000
35
20172138213802756.3312350825132991266111015200#NULL!195012215004838000000460025005250080057300004600872000252500NO0000000000000299004400000571009250525000
36
20172138213803756.3312350825071061213112015200#NULL!1248122260016350000000575150002250003001350000215000NO0000062500000000425150000163502250150000
37
20172139213901549.2181350623102011426111015200#NULL!1934122660049925029001050018001230001600350005250008251422507000235700NO00000000000000110021000004992500350000
38
20172139213902549.21813506231010114111210513039#NULL!4841226600875000000022587501750000000028750NO000000000000000000087500087500
39
20172139213903549.218135062302296666669696969696#NULL!9996666660000000000000000000960NO000000000000000000000000
40
20172139213904549.218135062302196666669696969696#NULL!9996666660000000000000000000960NO000000000000000000000000
41
20172140214001529.803135062316205136623096969696#NULL!9996666660034775130000001050000029200012517875455014500621450NO000725072500002000000020000163000000393250000
42
20172141214101330.801259044116103136623096969696#NULL!99966666600201500000067500000057505002015000040NO0007000127500000000001500000201500000
43
201721422142011961.91472408191110613261210734162#NULL!13601221300296600000008251957522517200042512525244000219575NO0057500000000007206000005753210077511500190000
44
201721422142021961.9147240819112041426111015200#NULL!364021213850004065000000028003100000004751150000339500NO00310000008500000000067500031000406500000
45
2017214321430179.38301301101320612661210440120#NULL!16001226600273800000001200270004502220003754050367000227000NO0000000000000145027510000003105003400270000
46
2017214321430279.3830130110121061266111015200#NULL!20801226600334603750000017003800057532100045075055402500238250NO0000000000000233030000003900000380000
47
2017214321430379.38301301101320612661210440120#NULL!160012266003072500000014503200052527100042532754600500232050NO0000000000000189035013000003532502500320000
48
2017214421440154.7292460127152992166111015200#NULL!2080122660041410000003800190039000750411000010550814000239000NO00067506750000000004030000004955000390000
49
2017214421440254.7292460127151991366111015200#NULL!2080122660038910000009250160035000575382000011650774000235000NO0001700170000000000392070000004665000350000
50
2017214421440354.7292460127071061226111015200#NULL!2080122660027460000000135031000600210000450450399000231000NO00000000000001890000003145000310000
51
20172145214501980.2246240818122042166111015200#NULL!26002122600165300000001150140000700032526007000314000NO00140000013500000000092500014000166000000
52
20172146214601494.5935590642152031366230030052#NULL!999666666001930000000170000000145003751930000040NO0002600171000000000001250000193000000
53
20172146214602494.5935590642091011326111015200#NULL!1716122660055565000000260062500850499000007010750262575NO0000000000095002020000006257513500625000
54
20172147214701228.5450240617141051266122074084#NULL!80021266001458000000100000-175012001000350119751202900042725NO00-17501000000000000625000-175147000000
55
20172147214702228.5450240617142062166230060484#NULL!99966666600124250000000000003251242500040NO0000000000000060000115000124250000
56
20172148214801218.806724021508206141212107231613#NULL!736122660017300000000550125501000004254750000212550NO00550000000000001025000550173002253300120000
57
20172149214901652.24074802351210113661210720284#NULL!800122660044415000000170037000550499000015075766000237000NO0000000000000267075000052075015000370000
58
20172150215001301.8298590240152051266230030052#NULL!99966666600203250000075000000052504252032500040NO0007000122500000000001500000203250000
59
20172151215101173.2754240114151022166230020520#NULL!99966666600200000000044000000065006002000000040NO00072501375000000000012500000200000000
60
20172151215102173.2754240114142022166230020520#NULL!99966666600141000000016000250050001000001160000042500NO00001000000000000000000141000025000
61
20172152215201110.8803470130112011326112015200#NULL!10401226600204100000006501600030011300006000159000216000NO00000000000004600200000220002756000160000
62
20172152215202110.8803470130121011266111015200#NULL!20801226600326750000001700380005503380000125545000238000NO0000000000000207000000381250038000125
63
20172153215301861.5245240819102011426111015200#NULL!2080122110037100021004000200060000165033000400600006000190000233000NO00000000000001840000003900000330000
64
20172153215302861.5245240819091011326111015200#NULL!2080122120270029010020000000130030000350990000099000230000NO00000000000000000003000000300000
65
20172153215303861.524524081901196666669696969696#NULL!9996666660000000000000000000960NO000000000000000000000000
66
20172154215401186.44144701301620114661220513039#NULL!26021266005984000000135000-1200008550-12000002050014660170000654000NO00070007000000490000004900061100000-12000745000000
67
20172154215402186.44144701301610114661220513039#NULL!26021266005526000000140000-1300008450-13000002100014240125000648500NO00070007000000490000004900057900000-13000695000000
68
2017215521550175.595913021116105236623096969696#NULL!99966666600361000000010500000129000400181752650500620575NO00070007000052552520000000200001360275000038750225000
69
20172156215601149.8536460528131011366230020520#NULL!999666666002888000000000027600000512000634000NO000000003200020000034000236000000340000000
70
20172156215602149.8536460528122011266111015200#NULL!208012266004037000000025005000082552200000963000250000NO00000000210002100004410000005000000500000
71
20172156215603149.8536460528061061226111015200#NULL!1872122660042420000000240052500825556000001008000252500NO0000000000000452000000525007500525000
72
20172157215701157.6332240617122041366111015200#NULL!1560122660029295000009000020000010800045010375108000220000NO0000000000000092500003037500200000
73
2017215821580134.8033110405142049966230030052#NULL!99966666600109250000000000003501092500040NO000000000000007500105000109250000
74
2017215821580234.8033110405092061326230030052#NULL!99966666600208750065000650008001150000007509375000311500NO00115000019000000000022500011500208750000
75
2017215821580334.803311040502296666669696969696#NULL!9996666660000000000000000000960NO000000000000000000000000
76
20172159215901955.72962408181519921661220424280#NULL!50412226004772000000925040011000100344000016500628000737500NO0007250725001950019500700000070002840000005400000110000
77
20172159215902955.7296240818071062126230030052#NULL!9996666260075000000000000025075000040NO0000000000000050000007500000
78
20172159215903955.7296240818071061326111015200#NULL!20801222600220050000001050220002259200045092592000222000NO0000000000000047500002292500220000
79
20172160216001110.2355240617061021311111015200#NULL!260012266006684090000000290072500700873000001241000279250NO0000006750675000000368001350000792507000725000
80
20172160216002110.2355240617062022211111015200#NULL!15601226600190000000008251900030000000000219000NO00000000000000000001900000190000
81
20172161216101163.536347063216105216623096969696#NULL!99966666600235500000085000000004501627507250047275NO00070007000000250002503250000235500000
82
20172162216201525.746524081816202146623096969696#NULL!9996666260010200000002800000000098000004400NO00070007000000400000400000000102000000
83
20172162216202525.746524081816102126623096969696#NULL!9996666260049080000008500000326000015500642000640000NO000700070000004000000040000316000000555000000
84
20172163216301774.9934480838132011266121055101#NULL!2550212260011295028000000052501200000135700000180501100003131000NO001200000000000000448000001200001310000000
85
20172163216302774.9934480838131011266112015200#NULL!10401222600263709750000011002400035012000000143038000227800NO000000000000023006250002780000240000
86
20172163216303774.99344808380520612261220426260#NULL!3901222600507500000025390050000250117500023900NO0000077500000000150000050750039000
87
201721642164011197.9869350826132011466111015200#NULL!36402121200197450000008752000003600015017543000220000NO0000000000000702500002017500200000
88
201721642164021197.9869350826131011466111015200#NULL!3640212120021520000000825220000400000048000222000NO000000000000080000002200000220000
89
2017216521650181.7603470531112021326111015200#NULL!195012266125000698300000002500700008506670000010470-22000280300NO00000012500000000380003000008030000700000
90
2017216521650281.7603470531121021266111015200#NULL!2080122660075970000004700260010000087516650000470026730-20000298000NO00000000000001008000000102700001000000
91
2017216521650381.76034705310520612111220528024#NULL!560122660019000000000190000000000021900NO000000000000000000019000019000
92
201721662166011011.6301240819152052166230030052#NULL!99966662600214500000010000000002254251855000042900NO000700072250002900000290009000000214500000
93
20172167216701180.0550590240082022126111015200#NULL!1820122660044745008500085000170037000650710003258975123000237000NO0000000000018500520150400000459759250370000
94
20172167216702180.0550590240042062111230030052#NULL!9996666660000000000000000000010NO000000000000000000000000
95
20172167216703180.055059024002196666669696969696#NULL!9996666660000000000000000000960NO000000000000000000000000
96
20172167216704180.0550590240121021266112015200#NULL!624122660012100000000400120002250000001000212100NO00000000000000000001210000120000
97
20172168216801366.0709590441141042366230030052#NULL!999666666003825000000925000000003825000040NO0000000000095000000003825000029000
98
20172168216802366.0709590441142042166230030052#NULL!9996666660013075000004750000003501307500040NO0000000000000025000120000130750000
99
20172169216901400.9294350120132011366111015200#NULL!195012266003627000000016504100062531000000473000241000NO00000000000001630019000004100000410000
100
20172169216902400.92943501201410121661220416360#NULL!32012266003346000000800050360050357000026500539000412350NO00000000875000087501820000003885001850036000