工资年终奖优化公式（终极版）.xls

1、月工资 税前年收入 月薪税率速算扣除数 月薪个税 年终奖税率速算扣除数1006012072085600.2555457180000.03010000120720 100600.255575700.0306012072035600.0301.8780000.255512072036600.0304.8768000.255512072037600.0307.8756000.255512072038600.03010.8744000.255512072039600.03013.8732000.255512072040600.03016.8720000.255512072041600.03019.87

2、08000.255512072042600.03022.8696000.255512072043600.03025.8684000.255512072044600.03028.8672000.255512072045600.03031.8660000.255512072046600.03034.8648000.255512072047600.03037.8636000.255512072048600.03040.8624000.255512072049600.03043.8612000.255512072050600.110551600000.255512072051600.110561588

3、000.255512072052600.110571576000.255512072053600.110581564000.255512072054600.110591552000.255512072055600.1105101540000.110512072056600.1105111528000.110512072057600.1105121516000.110512072058600.1105131504000.110512072059600.1105141492000.110512072060600.1105151480000.110512072061600.1105161468000

4、.110512072062600.1105171456000.110512072063600.1105181444000.110512072064600.1105191432000.110512072065600.1105201420000.110512072066600.1105211408000.1105此项输入 税前月收入的整百位数绿色为节约的个税金额此项输入税前月收入低于百位的金额12072067600.1105221396000.110512072068600.1105231384000.110512072069600.1105241372000.110512072070600.11

5、05251360000.110512072071600.1105261348000.110512072072600.1105271336000.110512072073600.1105281324000.110512072074600.1105291312000.110512072075600.1105301300000.110512072076600.1105311288000.110512072077600.1105321276000.110512072078600.1105331264000.110512072079600.1105341252000.110512072080600.25

6、55357240000.110512072081600.2555377228000.110512072082600.2555397216000.110512072083600.2555417204000.110512072084600.2555437192000.110512072085600.2555457180000.03012072086600.2555477168000.03012072087600.2555497156000.03012072088600.2555517144000.03012072089600.2555537132000.03012072090600.2555557

7、120000.03012072091600.2555577108000.03012072092600.255559796000.03012072093600.255561784000.03012072094600.255563772000.03012072095600.255565760000.03012072096600.255567748000.03012072097600.255569736000.03012072098600.255571724000.03012072099600.255573712000.030120720 100600.255575700.030120720 101

8、600.2555777-120000120720 102600.2555797-240000120720 103600.2555817-360000120720 104600.2555837-480000120720 105600.2555857-600000120720 106600.2555877-720000120720 107600.2555897-840000120720 108600.2555917-960000120720 109600.2555937-1080000120720 110600.2555957-1200000120720 111600.2555977-132000

9、0120720 112600.2555997-1440000120720 113600.25551017-1560000120720 114600.25551037-1680000120720 115600.25551057-1800000120720 116600.25551077-1920000120720 117600.25551097-2040000120720 118600.25551117-2160000120720 119600.25551137-2280000120720 120600.25551157-2400000120720 121600.25551177-2520000

10、120720 122600.25551197-2640000120720 123600.25551217-2760000120720 124600.25551237-2880000120720 125600.2510051260-3000000120720 126600.2510051285-3120000120720 127600.2510051310-3240000120720 128600.2510051335-3360000120720 129600.2510051360-3480000120720 130600.2510051385-3600000120720 131600.2510

11、051410-3720000120720 132600.2510051435-3840000120720 133600.2510051460-3960000120720 134600.2510051485-4080000120720 135600.2510051510-4200000120720 136600.2510051535-4320000120720 137600.2510051560-4440000120720 138600.2510051585-4560000120720 139600.2510051610-4680000120720 140600.2510051635-48000

12、00120720 141600.2510051660-4920000120720 142600.2510051685-5040000120720 143600.2510051710-5160000120720 144600.2510051735-5280000120720 145600.2510051760-5400000120720 146600.2510051785-5520000120720 147600.2510051810-5640000120720 148600.2510051835-5760000120720 149600.2510051860-5880000120720 150

13、600.2510051885-6000000120720 151600.2510051910-6120000120720 152600.2510051935-6240000120720 153600.2510051960-6360000120720 154600.2510051985-6480000120720 155600.2510052010-6600000120720 156600.2510052035-6720000120720 157600.2510052060-6840000120720 158600.2510052085-6960000120720 159600.25100521

14、10-7080000120720 160600.2510052135-7200000120720 161600.2510052160-7320000120720 162600.2510052185-7440000120720 163600.2510052210-7560000120720 164600.2510052235-7680000120720 165600.2510052260-7800000120720 166600.2510052285-7920000120720 167600.2510052310-8040000120720 168600.2510052335-816000012

15、0720 169600.2510052360-8280000120720 170600.2510052385-8400000120720 171600.2510052410-8520000120720 172600.2510052435-8640000120720 173600.2510052460-8760000120720 174600.2510052485-8880000120720 175600.2510052510-9000000120720 176600.2510052535-9120000120720 177600.2510052560-9240000120720 178600.

16、2510052585-9360000120720 179600.2510052610-9480000120720 180600.2510052635-9600000120720 181600.2510052660-9720000120720 182600.2510052685-9840000120720 183600.2510052710-9960000120720 184600.2510052735-10080000120720 185600.2510052760-10200000120720 186600.2510052785-10320000120720 187600.2510052810-10440000120720 188600.2510052835-10560000120720 189600.2510052860-10680000120720 190600.2510052885-10800000120720 191600.2510052910-10920000120720 192600.2510052935-11040000120720 193600.2510052960-