Spreadsheet: 92220d1291843355-return-marginal-tax-rate-example
Sheet: YTD Earnings

File # | YTD Gross | Marginal Tax Rate
954107 | 47884.01000000002
954191 | 44135.37000000001 |  |  | Federal and Ontario Combined
954193 | 32699.39000000001 |  |  | *from TaxTips.ca
954194 | 32314.12000000001 |  |  | 0 | 0.2005
954195 | 47673.72000000002 |  |  | 37106.01 | 0.2415
954197 | 47486.72000000002 |  |  | 40970.01 | 0.3115
954200 | 33075.96000000001 |  |  | 65345.01 | 0.3298
954202 | 7803.530000000002 |  |  | 74214.01 | 0.3539
954203 | 48056.63000000001 |  |  | 76986.01 | 0.3941
954204 | 44266.83000000001 |  |  | 81941.01 | 0.4341
954210 | 43883.34000000001 |  | over | 127021.01 | 0.4641
954211 | 40857.87000000001
954212 | 39719.38000000001 |  |  | NOTICE THE EXTRA PENNIES ADDED
954213 | 41571.21000000001
954214 | 39511.49000000001
954215 | 48547.87000000002
954216 | 14176.72
954220 | 31341.74000000001
954223 | 37239.57000000001
954225 | 39865.11000000002
954227 | 41101.33000000001
954231 | 46009.79000000002
954232 | 44718.70000000001
954233 | 37645.17000000001
954236 | 59548.06000000002
954237 | 45015.69000000001
954238 | 34719.85000000001
954239 | 49206.42000000001
954240 | 33978.93000000001
954241 | 35195.27000000001
954242 |  |  | To avoid this change formula in C2 to =IF(B2="","",VLOOKUP(B2,$E$5:$F$12,2,1))
954243 | 33429.79000000001
954246 | 30395.95000000001
954247 | 33909.69000000001
954250 | 34012.86000000001
954251 | 35850.22000000001
954252 | 30541.49000000001
954255 | 45072.29000000002
954257 | 45118.76000000001
954258 | 49041.93000000001
954259 | 35443.33000000001
954260 | 58450.63000000002
954261 | 22171.54
954264 | 33120.76000000001
954265 | 56897.59000000002
954266 | 61001.20000000002
954271 | 11032.47
954273 | 41204.50000000001
954274 | 35358.39000000001
954276 | 31960.79000000001
954278 | 33209.50000000001
954280 | 33953.46000000001
954281 | 33664.84000000001
954282 | 33534.78000000001
954283 | 34123.59000000001
954285 | 51501.50000000001
954286 | 47289.49000000001
954288 | 36786.15000000001
954289 | 32443.67000000001
954290 | 36101.02000000001
954291 | 45779.04000000002
954295 | 45976.79000000002
954299 | 36358.12000000001
954302 | 29828.83000000001
954305 | 33785.17000000001
954309 | 40645.61000000001
954310 | 40946.48000000001
954311 | 40782.33000000001
954315 | 17342.53000000001
954316 | 32379.12000000001
954318 | 32195.87000000001
954320 | 33219.82000000001
954321 | 33467.84000000001
954328
954329 | 59503.29000000002
954332 | 67349.91000000002
954335 | 37097.93000000001
954336 | 31241.55000000001
954338 | 35994.40000000001
954341 | 34305.94000000001
954344 | 17074.14000000001
954346 | 59292.37000000002
954347 | 82998.49000000002
954350 | 34665.79000000001
954351 | 39947.16000000001
954353 | 47401.09000000001
954356 | 30715.18000000001
954361 | 51788.17000000001
954363 | 47822.52000000001
954365 | 712.9500000000003
954366 | 33206.06000000001
954368 | 34136.45000000001
954369 | 37390.07000000001
954371 | 16982.45
954372 | 46849.14000000001
954383 | 35075.79000000001
954387 | 35161.33000000001
954389 | 34280.60000000001
954390 | 35257.96000000001
954391 | 32932.16000000001
954392 | 31110.57000000001
954394 | 33425.28000000001
954395 | 41224.29000000001
954396 | 105.17
954397 | 44953.44000000001
954398 | 34601.98000000001
954399 | 63420.78000000002
954400 | 55007.34000000002
954401 | 56806.83000000002
954506 | 47445.03000000001
954507 | 36606.49000000001
954508 | 33071.38000000001
954509 | 46768.42000000001
954510 | 47331.18000000001
954511 | 32721.85000000001
954513 | 34931.90000000001
954514 | 40972.94000000001
954517 | 12638.96
954518 | 33486.53000000001
954519 | 35016.13000000001
954520 | 35368.49000000001
954521 | 33908.57000000001
954437 | 32147.41000000001
954441 | 46528.85000000001
954082 | 56848.17000000001
954083 | 58024.02000000002
954084 | 6184.320000000002
954085 | 33277.02000000001
954086 | 80379.46000000002
954087 | 44909.36000000002
954088 | 59110.04000000002
954089 | 73039.80000000002
954090 | 62573.75000000001
954091 | 129.1900000000001
954092 | 33433.91000000001
954093 | 59317.63000000002
954095 | 32620.14000000001
954100 | 41778.00000000001
954102 | 26381.44000000001
954104 | 31269.84000000001
954105
954106 | 33738.11000000001
954108
954109 | 56220.64000000001
954110 | 34833.90000000001
954114 | 36674.41000000001
954115 | 37534.18000000001
954118 | 36925.66000000001
954124 | 88692.13000000002
954125 | 124900.43
954127 | 100923.36
954129 | 85235.14000000003
954131 | 42413.34000000001
954133 | 61513.53000000002
954136
954137 | 33204.45000000001
954138 | 42137.00000000001
954139 | 56517.48000000002
954142 | 42302.74000000001
954143 | 45192.06000000001
954144 | 40495.05000000001
954146 | 51867.59000000001
954147 | 57287.85000000001
954148 | 34292.91000000001
954151 | 32310.97000000001
954152
954153 | 81177.32000000002
954154 | 32099.27000000001
954158 | 43415.66000000001
954159 | 59528.62000000002
954161 | 45084.31000000001
954163 | 733.6300000000003
954165 | 2158.160000000001
954170 | 64794.67000000002
954171 | 56491.35000000001
954172 | 31021.29000000001
954174 | 48115.41000000001
954177
954178 | 3700.910000000001
954179 | 26817.83000000001
954184 | 40645.79000000001
954185 | 64852.50000000002
954190 | 31764.80000000001
954198 | 53124.32000000001
954208 | 61788.56000000002
954209 | 89232.50000000003
954224
954267 | 109333.81
954272
954292 | 48257.24000000001
954297 | 7288.370000000003
954301 | 48446.92000000001
954307
954313
954402 | 75239.39000000001
954404 | 2341.800000000001
954406 | 35269.68000000001
954407 | 45785.40000000002
954408 | 39332.98000000001
954412 | 55026.13000000001
954413 | 46858.53000000001
954414 | 33700.48000000001
954415 | 30783.54000000001
954416 | 57873.64000000001
954417 | 46159.83000000002
954418 | 67505.68000000002
954419 | 33753.11000000001
954420 | 46343.38000000001
954421 | 43222.68000000001
954425 | 43859.29000000002
954430 | 33870.70000000001
954431 | 59531.26000000002
954432 | 37523.92000000001
954433 | 46525.02000000001
954434 | 59924.87000000002
954436 | 49122.80000000002
954438 | 11538.6
954439 | 37115.90000000001
954440 | 34985.74000000001
954442 | 44797.67000000001
954443
954444 | 37916.07000000001
954445 | 38282.33000000001
954446 | 53886.90000000002
954447 | 36791.44000000001
954448 | 61709.68000000001
954450 | 56460.70000000002
954451 | 61918.35000000002
954454 | 44104.90000000002
954455 | 48264.35000000001
954456 | 41958.56000000001
954457 | 35947.62000000001
954458 | 43009.76000000001
954459 | 64687.84000000002
954460 | 32752.34000000001
954461 | 59879.17000000002
954462 | 55192.86000000002
954464 | 47358.52000000001
954465 | 40036.88000000001
954467 | 44102.37000000001
954468 | 4448.860000000001
954470 | 50429.54000000002
954471 | 55363.56000000001
954473 | 44411.35000000001
954474 | 67193.65000000002
954476 | 49713.02000000001
954477 | 66588.59000000003
954478 | 43821.39000000001
954480 | 55081.25000000001
954481 | 11102.87
954482 | 56881.73000000002
954483 | 33858.37000000001
954484 | 34196.96000000001
954485 | 40572.66000000001
954487 | 46630.45000000001
954488 | 30914.70000000001
954489 | 32758.62000000001
954490 | 43960.87000000001
954491 | 52948.33000000002
954492 | 40815.53000000001
954493 | 46738.13000000001
954495 | 55930.02000000002
954496 | 63183.65000000002
954498 | 101423.99
954499 | 146401.38
954502
954504 | 100542.9
954522 | 44598.54000000002
954524
954525
954526 | 101892.91
954527 | 70306.01000000002
954529 | 85901.37000000002
954530 | 88940.12000000002
954531 | 83104.28000000003
954532 | 326258.6100000001
954533 | 88732.78000000003
954534 | 109352.57
954535 | 95531.74000000002
954536
954537 | 101683.63
954538 | 74502.99000000002
954539 | 145183.99
954540 | 60056.85000000001
954541 | 76204.24000000002
954542 | 78308.37000000002
954543 | 73280.44000000002
954544 | 62358.12000000002
954545 | 62938.32000000001
954546 | 83824.80000000002
954549 | 81011.89000000003
954550
954551 | 39055.90000000001
954552 | 34502.46000000001
954553 | 35157.70000000001
954554 | 46480.48000000001
954555 | 41535.52000000001
954556 | 40475.37000000001
954557 | 32558.78000000001
954558
954559 | 46884.58000000002
954561 | 34213.95000000001
954562 | 34197.74000000001
954563 | 35962.36000000001
954564 | 36830.29000000001
954565 | 31439.77000000001
954567
954568 | 47769.44000000002
954569 | 34876.87000000001
954570 | 42940.94000000001
954571 | 6787.170000000002
954572 | 49118.77000000001
954573 | 29493.11000000001
954574 | 21237.80000000001
954575 | 37640.51000000001
954576 | 33439.35000000001
954577 | 13722.04
954578 | 31316.27000000001
954579 | 38785.69000000001
954580 | 44023.13000000001
954581 | 36494.40000000001
954582 | 35327.30000000001
954583 | 38396.78000000001
954584 | 32338.73000000001
954585
954586 | 31495.34000000001
954587 | 3881.120000000001
954590 | 50497.12000000002
954591 | 34315.00000000001
954592 | 36112.92000000001
954593 | 32286.60000000001
954594 | 33318.87000000001
954595 | 34986.97000000001
954596 | 6925.870000000003
954598
954599
954600 | 35539.51000000001
954601 | 43869.59000000001
954602 | 29365.15000000001
954603 | 31356.76000000001
954605 | 57174.81000000002
954606 | 45801.79000000002
954607 | 81630.75000000003
954608 | 48037.47000000002
954701 | 45478.26000000002
954711
954721 | 33813.42000000001
954722 | 36772.31000000001
954723 | 37708.86000000001
954724 | 47759.60000000001
954725 | 35089.07000000001
954726 | 34443.12000000001
954727 | 44879.33000000002
954728 | 34097.05000000001
954729 | 15469.15000000001
954730 | 32386.43000000001
954731 | 34948.83000000001
954732 | 34864.72000000001
954734
954735 | 5576.450000000002
954737 | 53217.25000000001
954738
954739 | 36429.99000000001
954740 | 32331.74000000001
954741 | 35018.19000000001
954742 | 31929.16000000001
954743 | 31947.68000000001
954744 | 29838.86000000001
954745 | 33645.31000000001
954746 | 35997.41000000001
954747 | 34803.69000000001
954748
954749 | 37383.90000000001
954750 | 78223.04000000002
954751 | 77273.91000000002
954752 | 74359.07000000002
954754
954755 | 30429.25000000001
954756
954757 | 31021.63000000001
954758 | 31449.24000000001
954759 | 226.7400000000001
954760
954761
954762
954763 | 32409.40000000001
954764 | 30981.44000000001
954765 | 31587.43000000001
954766 | 37105.42000000001
954767 | 36925.82000000001
954768
954769 | 34788.01000000001
954770 | 35332.02000000001
954771 | 33504.51000000001
954772 | 33004.75000000001
954773 | 38503.84000000001
954774 | 31769.26000000001
954775
954776
954777 | 31099.85000000001
954778
954779 | 61878.11000000002
954780 | 96538.60000000002
954781 | 90792.59000000003
954783 | 103015.96
954784
954786 | 34785.96000000001
954787 | 32806.56000000001
954788 | 37808.89000000001
954789 | 30763.40000000001
954790 | 34885.58000000001
954791 | 21873.52000000001
954792 | 33571.29000000001
954793 | 31107.35000000001
954794 | 32157.25000000001
954795 | 31455.97000000001
954796 | 30926.73000000001
954797 | 40640.57000000001
954798 | 31512.53000000001
954799
954800 | 37783.26000000001
954801 | 34924.52000000001
954802 | 34929.85000000001
954803 | 40011.06000000001
954804 | 8635.670000000004
954805 | 40331.75000000001
954806 | 34060.36000000001
954807 | 33789.90000000001
954808 | 40905.31000000001
954809 | 40097.07000000001
954810 | 79346.22000000002
954811 | 81414.48000000003
954812 | 51663.45000000001
954813 | 146513.59
954814 | 83358.78000000003
954815
954816 | 118719.54
954817 | 80560.44000000002
954818 | 94368.31000000003
954819 | 100064.45
954820 | 33383.67000000001
954821 | 30261.36000000001
954822 | 24235.18000000001
954823 | 35930.97000000001
954825 | 35675.35000000001
954826 | 2456.660000000001
954827 | 29080.04000000001
954828 | 30858.96000000001
954829 | 31903.97000000001
954830 | 32690.75000000001
954831 | 29830.25000000001
954832 | 34047.22000000001
954833 | 35536.08000000001
954834 | 33783.75000000001
954835 | 35745.41000000001
954836 | 33490.92000000001
954837 | 33116.77000000001
954838 | 31737.76000000001
954839 | 27517.56000000001
954840 | 31630.30000000001
954841 | 33786.86000000001
954842 | 31807.57000000001
954843 | 34505.38000000001
954844 | 43635.24000000001
954845 | 34307.09000000001
954846 | 33032.54000000001
954847 | 34866.88000000001
954848 | 34904.21000000001
954849 | 33872.49000000001
954850 | 24751.38000000001
954851 | 40569.92000000001
954852 | 17635.53000000001
954853 | 32306.77000000001
954854 | 14800.90000000001
954855 | 34418.60000000001
954856 | 34491.60000000001
954857 | 30976.11000000001
954858 | 33731.25000000001
954859 | 32176.97000000001
954860 | 33343.59000000001
954861
954862 | 27794.69000000001
954863 | 31886.46000000001
954864 | 5067.500000000002
954865 | 31183.42000000001
954866 | 33762.93000000001
954867 | 36763.02000000001
954868 | 33192.80000000001
954869 | 33234.19000000001
954870 | 33524.47000000001
954871 | 30798.19000000001
954872 | 18158.68
954873 | 26166.96000000001
954874 | 35863.06000000001
954875 | 31819.45000000001
954876 | 33246.10000000001
954877 | 34457.32000000001
954878 | 35313.25000000001
954880 | 44086.20000000001
954881 | 36231.77000000001
954882
954883
954884
954885
954886
954887
954888
954889 | 30390.64000000001
954890
954891 | 93069.02000000003
954892 | 73613.99000000002
954893 | 80859.44000000002
954894 | 79167.79000000002
954895 | 24863.85000000001
954896 | 47047.94000000002
954897 | 67394.00000000001
954898 | 63740.50000000001
954899 | 73282.10000000002
954900 | 1701.190000000001
954901 | 78500.59000000003
954902 | 37677.50000000001
954905 | 37327.67000000001
954906 | 58795.35000000002
954907 | 58170.47000000002
954908 | 64863.70000000002
954909 | 82171.44000000002
954910 | 83421.01000000002
954911 | 82454.96000000002
954912 | 86103.90000000002
954913 | 30903.80000000001
954914 | 82350.24000000002
954915 | 29885.42000000001
954916 | 32230.90000000001
954917 | 30074.70000000001
954918 | 31658.72000000001
954919 | 31456.38000000001
954920 | 76754.52000000002
954921 | 33299.90000000001
954922 | 17847.59
954923 | 33153.68000000001
954924 | 36685.23000000001
954925 | 32297.83000000001
954926 | 33752.91000000001
954927 | 33687.21000000001
954928 | 30929.86000000001
954929 | 30603.44000000001
954930 | 30742.19000000001
954931 | 30621.17000000001
954932 | 31168.21000000001
954933 | 33370.17000000001
954934 | 31014.74000000001
954935 | 20920.44000000001
954936 | 33060.01000000001
954937 | 37849.75000000001
954939 | 37604.76000000001
954940 | 12022.4
954941 | 113533.98
954942 | 59951.74000000002
954943 | 10616
954944 | 28800.10000000001
954945 | 4856.500000000002
954946 | 22098.06
954947 | 24187.50000000001
954948 | 21619.91000000001
954949 | 23754.30000000001
954950 | 22677.05000000001
954951 | 15606.22
954952 | 21431.17000000001
954953 | 23304.60000000001
954954 | 24214.37000000001
954955 | 22890.50000000001
954956 | 25682.54000000001
954957 | 21544.82000000001
954958 | 23425.58000000001
954959 | 23439.59000000001
954960 | 22927.52000000001
954961 | 24018.27000000001
954962 | 24977.33000000001
954963 | 24011.86000000001
954964 | 23285.82000000001
954965 | 22374.82000000001
954966 | 21228.21000000001
954967 | 22492.98000000001
954968 | 22612.25000000001
954969 | 23179.34000000001
954970 | 22773.63000000001
954971 | 25920.04000000001
954972 | 23587.29000000001
954973 | 22335.89000000001
954974 | 25105.14000000001
954975 | 23592.78000000001
954976 | 24280.37000000001
954977 | 27369.15000000001
954978 | 24400.91000000001
954979 | 25453.94000000001
954980 | 20441.08000000001
954981 | 23964.62000000001
954982 | 22590.36000000001
954983 | 25596.78000000001
954984 | 23753.72000000001
954985 | 2627.180000000001
954986 | 24579.84000000001
954987 | 24153.84000000001
954988 | 22495.32000000001
954989 | 25770.33000000001
954990 | 21540.21000000001
954991 | 22886.49000000001
954992 | 22847.82000000001
954993 | 22683.99000000001
954994 | 23534.86000000001
954995 | 22573.50000000001
954996 | 24478.14000000001
954997 | 18861.05000000001
954998 | 25505.72000000001
954999 | 23061.86000000001
955000 | 24731.93000000001
955001 | 21349.06
955002 | 28359.74000000001
955003 | 25447.22000000001
955004 | 22829.30000000001
955005 | 21712.77000000001
955006 | 23534.73000000001
955007 | 24598.82000000001
955008 | 2124.150000000001
955010 | 26128.41000000001
955011 | 24278.70000000001
955012 | 22840.48000000001
955013 | 24917.66000000001
955014 | 24077.06000000001
955016 | 7791.530000000002
955017 | 84617.05000000002
955018 | 19500.00000000001
955019 | 13759.15
955020 | 47821.79000000002
955021 | 20678.13
955022 | 26424.00000000001
955023 | 11288
955024 | 11288
955027 | 3472.200000000001
955028 | 3614.990000000001
955030 | 3708.190000000001
955038 | 3999.370000000001
955041 | 3498.280000000001
955044 | 7474.500000000003
955045 | 3837.920000000001
955049 | 3841.550000000002
955050 | 7715.030000000002
955051 | 9313.180000000004
955052 | 5852.720000000002
955053 | 9253.900000000003
955054 | 5098.680000000002
955055 | 5698.320000000002
955056 | 7231.920000000003
955058 | 10019.24
955060 | 3074.270000000001
955066 | 9435.790000000003
955067 | 5227.370000000002
955071 | 6908.340000000002
955074 | 9800.150000000003
955077 | 9129.090000000004
955079 | 4100.050000000001
955083 | 4808.920000000002
955085 | 2802.250000000001
955088 | 6848.260000000002
955089 | 4881.720000000002
955090 | 3267.150000000001
955091 | 2599.630000000001
955096 | 2934.900000000001
955097 | 6172.740000000003
955102 | 7739.380000000003
955103 | 8963.120000000003
955104 | 3549.560000000001
955105 | 3260.520000000001
955106 | 7975.130000000003
955107 | 7438.990000000003
955108 | 1794.780000000001
955112 | 5869.650000000002
955113 | 9192.090000000004
955117 | 1937.020000000001
955118 | 7092.150000000002
955119 | 3678.210000000001
955120 | 6283.810000000002
955122 | 6689.900000000002
955124 | 9766.960000000003
955125 | 17612.15000000001
955128 | 2984.530000000001
955132 | 4972.960000000002
955133 | 7711.410000000003
955134 | 3112.670000000001
955136 | 6155.770000000002
955138 | 5428.470000000002
955140 | 5544.790000000002
955142 | 3986.920000000001
955143 | 8290.180000000002
955144 | 1822.450000000001
955145 | 5572.030000000002
955146 | 3386.400000000001
955148 | 9576.800000000003
955149 | 3517.360000000001
955152 | 8882.800000000003
955154 | 4181.770000000001
955155 | 5386.800000000002
955157 | 10285.46
955159 | 3837.330000000001
955160 | 7553.420000000003
955161 | 10006.96
955162 | 4347.470000000001
955163 | 6162.540000000002
955164 | 9529.200000000003
955165 | 3039.210000000001
955170 | 42590.33000000001
955173 | 6667.410000000003
955174 | 5194.750000000002
955175 | 50518.15000000002
955176 | 36163.43000000001
955177 | 42432.61000000002
955178 | 4165.820000000002
955179 | 6969.330000000003
955181 | 4163.440000000001
955182 | 5603.520000000002
955183 | 6470.000000000002
955184 | 5583.050000000002
955185 | 6431.990000000003
955186 | 6579.960000000002
955187 | 6203.560000000002
955188 | 6327.080000000002
955189 | 6685.290000000003
955190 | 6280.050000000002
955191 | 6447.780000000002
955192 | 4347.530000000002
955193 | 6192.080000000002
955194 | 3549.310000000001
955195 | 16031.74000000001
955196
955197
955198 | 3603.720000000001
955199 | 3359.710000000001
955201 | 6571.080000000003
955202 | 2572.510000000001
955211 | 1760.940000000001
955216 | 2257.600000000001
955221 | 1794.780000000001
955222 | 1848.980000000001
955237 | 1856.170000000001
955240 | 1865.910000000001
955241 | 2482.780000000001
955242 | 17585.95
955243 | 2257.600000000001
955244 | 2514.970000000001
955245 | 3260.520000000001
955246 | 43525.25000000001
955247 | 5900.690000000002
955248 | 15382.87
955249 | 2387.980000000001
955250 | 28306.71000000001
955254 | 2347.910000000001
955264 | 26629.24000000001
955280 | 1794.780000000001
955286 | 25045.52000000001
955287 | 30696.36000000001
955288 | 65499.78000000002
955289 | 2399.600000000001
955290 | 24890.00000000001
955291 | 2393.040000000001
955297 | 27908.52000000001
955301 | 4515.200000000002
955303 | 10009.44
955304 | 13398.15
955305 | 1760.940000000001
955345 | 20843.51000000001
955410 | 10014.25
955411 | 9934.350000000004
955482 | 6565.680000000002
955484 | 10820
955507 | 7200.000000000003