【年终奖】高管层年薪避税测算表（自动生成最少个税方案） (2).xlsx

高管层年薪避税测算表 模板为月工资与年终奖调节自动计算表，只需要在第四行黄色选框输入四种基础数据，第六行黄色选框输入月工资起始计算值，就可自动计算不同月工资下年收入实发数，免去您日常计算的烦劳；轻松便捷，一键搞定；年收入实发列下红色选框即为最优选择，方便您的查找年收入120,000级差100月个人社保-月个人公积金年工资标准月工资月个人社保月个人公积金其他抵扣项月计税工资月工资扣税月工资实发54,0004,500-4,500-4,50055,2004,600-4,600-4,60056,4004,700-4,700-4,70057,6004,800-4,800-4,80058,8004,900-4,900-4,90060,0005,000-5,000-5,00061,2005,100-5,10035,09762,4005,200-5,20065,19463,6005,300-5,30095,29164,8005,400-5,400125,38866,0005,500-5,500155,48567,2005,600-5,600185,58268,4005,700-5,700215,67969,6005,800-5,800245,77670,8005,900-5,900275,87372,0006,000-6,000305,97073,2006,100-6,100336,06774,4006,200-6,200366,16475,6006,300-6,300396,26176,8006,400-6,400426,35878,0006,500-6,500456,45579,2006,600-6,600486,55280,4006,700-6,700516,64981,6006,800-6,800546,74682,8006,900-6,900576,84384,0007,000-7,000606,94085,2007,100-7,100637,03786,4007,200-7,200667,13487,6007,300-7,300697,23188,8007,400-7,400727,32890,0007,500-7,500757,42591,2007,600-7,600787,52292,4007,700-7,700817,61993,6007,800-7,800847,71694,8007,900-7,900877,81396,0008,000-8,000907,91097,2008,100-8,1001008,00098,4008,200-8,2001108,09099,6008,300-8,3001208,180100,8008,400-8,4001308,270102,0008,500-8,5001408,360103,2008,600-8,6001508,450104,4008,700-8,7001608,540105,6008,800-8,8001708,630106,8008,900-8,9001808,720108,0009,000-9,0001908,810109,2009,100-9,1002008,900110,4009,200-9,2002108,990111,6009,300-9,3002209,080112,8009,400-9,4002309,170114,0009,500-9,5002409,260115,2009,600-9,6002509,350116,4009,700-9,7002609,440117,6009,800-9,8002709,530118,8009,900-9,9002809,620120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,0002909,710120,00010,000-10,