个税及年终奖筹划（自动）.xlsx

个税及年终奖筹划（自动计算表）姓名全年工资累计应税额累计已预扣税额(预计)年终奖(预计)年终奖个税不考虑避税全部纳入年综合所得补发工资调整后年终奖调整后个税总额赵四507522555.2900000307840310395.2246843.2600000300000200895.6王五901521229612.35925009040238652.35265389.45092500238652.35赵乙602541127842.3919008980136822.3157134.35091900136822.3朱九25148754.443700034904244.443694.810852261481864.44张三752895008.95050048409848.910058.914500360007538.9李正914295234083.25905008840242923.25270237.75090500242923.25陈美丽13522405.668800264669.66669.6608800669.66高盛954842248274.7814007930256204.7284388.9081400256204.7孙悟空876082220708.7879008580229288.7251871.9087900229288.7胡扯750312176689.2760007390184079.2203289.2076000184079.2罗辉24053731187.42970089132078.437127.402970032078.4拉拉652371142791.3655006340149131.3165334.85065500149131.3张杨954814248264.9889008680256944.9287751.3088900256944.9王华665914139.180002404379.14939.1080004379.1陆由903137230177.95897008760238937.95264856.65089700238937.95范黎68150429512200366466155150122004661白玲476812248.14960047506998.17208.113600360004688.1陈三26546136172.23320099637168.242812.203320037168.2人与人49972996998.7534005130102128.7113018.7053400102128.7太让人584973329.76830066209949.710159.732300360007639.7第三方45474583503.546700446087963.597513.504670087963.5东方科技734276171076.6731007100178176.6196661.6073100178176.6也是45444383412.948900468088092.998082.904890088092.9