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

个税及年终奖筹划（自动计算表）

姓名 全年工资累计应税额 累计已预扣税额 (预计)年终奖 (预计)年终奖个税 不考虑避税 全部纳入年综合所得 补发工资 调整后年终奖 调整后个税总额

Alex 50,752 2,555 900,000 307,840 310,395 246,843 600,000 300,000 200,896

Chris 901,521 229,612 92,500 9,040 238,652 265,389 0 92,500 238,652

Dan 602,541 127,842 91,900 8,980 136,822 157,134 0 91,900 136,822

Jackson 25,148 754 37,000 3,490 4,244 3,695 10,852 26,148 1,864

Jayce 75,289 5,009 50,500 4,840 9,849 10,059 14,500 36,000 7,539

Ben 914,295 234,083 90,500 8,840 242,923 270,238 0 90,500 242,923

Liz 13,522 406 8,800 264 670 670 0 8,800 670

Sarah 954,842 248,275 81,400 7,930 256,205 284,389 0 81,400 256,205

Trish 876,082 220,709 87,900 8,580 229,289 251,872 0 87,900 229,289

Lily 750,312 176,689 76,000 7,390 184,079 203,289 0 76,000 184,079

Olivia 240,537 31,187 29,700 891 32,078 37,127 0 29,700 32,078

Liz 652,371 142,791 65,500 6,340 149,131 165,335 0 65,500 149,131

Lucas 954,814 248,265 88,900 8,680 256,945 287,751 0 88,900 256,945

Charlie 66,591 4,139 8,000 240 4,379 4,939 0 8,000 4,379

Trish 903,137 230,178 89,700 8,760 238,938 264,857 0 89,700 238,938

Jacob 68,150 4,295 12,200 366 4,661 5,515 0 12,200 4,661

Harper 47,681 2,248 49,600 4,750 6,998 7,208 13,600 36,000 4,688

Jerry 265,461 36,172 33,200 996 37,168 42,812 0 33,200 37,168

Ethan 499,729 96,999 53,400 5,130 102,129 113,019 0 53,400 102,129

Daniel 58,497 3,330 68,300 6,620 9,950 10,160 32,300 36,000 7,640

Fred 454,745 83,504 46,700 4,460 87,964 97,514 0 46,700 87,964

Liam 734,276 171,077 73,100 7,100 178,177 196,662 0 73,100 178,177

Bella 454,443 83,413 48,900 4,680 88,093 98,083 0 48,900