EXCEL個(gè)人所得稅及年終獎(jiǎng)金個(gè)人所得稅計(jì)算表(含函數(shù)公式)

1、每每個(gè)個(gè)月月的的個(gè)個(gè)人人所所得得稅稅算算法法應(yīng)發(fā)每月工資每月稅金實(shí)發(fā)工資按實(shí)發(fā)金額計(jì)算應(yīng)交稅金按實(shí)發(fā)工資計(jì)算就應(yīng)發(fā)總額5552.7100.275452.43100.275552.74822.439.674782.7339.672061864822.402062年年終終獎(jiǎng)獎(jiǎng)的的算算法法（全全年年除除1212找找稅稅率率和和扣扣除除）應(yīng)發(fā)年終獎(jiǎng)（含稅）年終應(yīng)交稅金實(shí)發(fā)年終獎(jiǎng)金（不含稅）按實(shí)發(fā)年終獎(jiǎng)（不含稅）計(jì)算應(yīng)交稅金按實(shí)發(fā)年終獎(jiǎng)計(jì)算含稅獎(jiǎng)金總額按年終獎(jiǎng)金總額（含稅）計(jì)算應(yīng)交稅金少交稅收1800054017460540180005400180011695.116305.9504.3116810.2

2、1504.311190.79下下載載后后，請(qǐng)請(qǐng)看看函函數(shù)數(shù)公公式式。平時(shí)工資的算法年終獎(jiǎng)算法工工資資、薪薪金金所所得得適適用用個(gè)個(gè)人人所所得得稅稅累累進(jìn)進(jìn)稅稅率率表表每每個(gè)個(gè)月月的的算算法法級(jí)數(shù)全月應(yīng)納稅所得額（含稅級(jí)距）全月應(yīng)納稅所得額（不含稅級(jí)距）稅率%速算扣除數(shù)（元）應(yīng)發(fā)每月工資一不超過1500元的不超過1455元的 305552.7二超過1500元至4500元的部分超過1455元至4155元的部分101054822.4三超過4500元至9000元的部分超過4155元至7755元的部分205557000四超過9000元至35000元的部分超過7755元至27255元的部分25100580

3、000五超過35000元至55000元的部分超過27255元至41255元的部分3027555552.7六超過55000元至80000元的部分超過41255元至57505元的部分355505七超過80000元的部分超過57505元的部分4513505年年終終獎(jiǎng)獎(jiǎng)的的算算法法（全全年年除除1212找找稅稅率率和和扣扣除除）年終獎(jiǎng)算法：按照對(duì)應(yīng)的稅級(jí)距，共有6個(gè)需要避免的區(qū)域。分別是：18001元，19283.33元；54001元，60187.50元；108001元，114600元；420001元，447500元；660001元，706538.46元；960001元，1120000元.應(yīng)發(fā)年終獎(jiǎng)（

4、含稅）118000218001316810.21454000554001540026012960130601876018853999.566018861014610006108000710800184200009420001106600001166000112960000139600011454001151050001611000017105556.3年終獎(jiǎng)算法：按照對(duì)應(yīng)的稅級(jí)距，共有6個(gè)需要避免的區(qū)域。分別是：18001元，19283.33元；54001元，60187.50元；108001元，114600元；420001元，447500元；660001元，706538.46元；960001元

5、，1120000元.每月稅金實(shí)發(fā)工資按實(shí)發(fā)金額計(jì)算應(yīng)交稅金按實(shí)發(fā)工資計(jì)算就應(yīng)發(fā)總額平時(shí)工資的算法100.275452.43100.275552.739.674782.73 39.67206186 4822.402062456755245700021270587302127080000100.275452.435552.75552.700000000年終應(yīng)交稅金實(shí)發(fā)年終獎(jiǎng)金（不含稅）按實(shí)發(fā)年終獎(jiǎng)（不含稅）計(jì)算應(yīng)交稅金按實(shí)發(fā)年終獎(jiǎng)計(jì)算含稅獎(jiǎng)金總額按年終獎(jiǎng)金總額（含稅）計(jì)算應(yīng)交稅金少交稅收年終獎(jiǎng)算法540174605401800054001695.116305.9504.3116810.21504.

6、311190.79504.3116305.9504.3116810.21504.3105295487055295540005295010245.243755.84745.0948500.894745.095500.1110245.443756.64745.1848501.784745.185500.2211470.848658.25289.8539485289.8618111471486595289.8953948.895289.896181.1111482.448704.65294.9653999.565294.966187.4411482.648705.411482.66018811482

7、.605294.9648704.65294.9653999.565294.96011482.648705.411482.66018811482.6011647.849366.211647.86101411647.8011645493551164561000116450210458695521045108000210450每每個(gè)個(gè)月月的的算算法法年年終終獎(jiǎng)獎(jiǎng)的的算算法法（全全年年除除1212找找稅稅率率和和扣扣除除）25995.2582005.7519807.69101813.4419807.696187.561039953160051039954200001039950123245.3296755.797578.57394334.2797578.5725666.731952454647551952456600001952450225495.35434505.65182280.99616786.64182280.9943214.363304956295053304959600003304950418495.45541505.55283110.68824616.23283110.68135384.7710245.243755.84745.0948500.8947