Excel表格模板：工资年终奖调节计算表(自动生成税后年收入最多方案).xlsx

《Excel表格模板：工资年终奖调节计算表(自动生成税后年收入最多方案).xlsx》由会员分享，可在线阅读，更多相关《Excel表格模板：工资年终奖调节计算表(自动生成税后年收入最多方案).xlsx（24页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、分类月工资税前年收入月薪税率优化后80080960960375800.25优化前80000960960800800.3580工资年终奖调节计算表优化前税后年收入705384备注：全表格只需输入黄色和绿色两个区域数值，其中黄色区域输入：税前月收入的整百位数；绿色区域输入：税前月收入低于百位的金额1）年奖调整，是指把部分年终奖转移到某月工资中去发放，以期减少年奖的税率，减少个税。2）调整的前提是：年奖的税率要高于该月工资的税率，或者调整后，剩余年奖的税率要比调整前低。3）是否调整的唯一判断依据是：调整后，该月工资和年奖的个税之和 不调整的月工资和年奖的个税之和。96096035800.039609

2、6036800.0396096037800.0396096038800.0396096039800.0396096040800.0396096041800.0396096042800.0396096043800.0396096044800.0396096045800.0396096046800.0396096047800.0396096048800.0396096049800.0396096050800.196096051800.196096052800.196096053800.196096054800.196096055800.196096056800.196096057800.19609

3、6058800.196096059800.196096060800.196096061800.196096062800.196096063800.196096064800.196096065800.196096066800.196096067800.196096068800.196096069800.196096070800.196096071800.196096072800.196096073800.196096074800.196096075800.196096076800.196096077800.196096078800.196096079800.196096080800.296096

4、081800.296096082800.296096083800.296096084800.296096085800.296096086800.296096087800.296096088800.296096089800.296096090800.296096091800.296096092800.296096093800.296096094800.296096095800.296096096800.296096097800.296096098800.296096099800.2960960100800.2960960101800.2960960102800.2960960103800.296

5、0960104800.2960960105800.2960960106800.2960960107800.2960960108800.2960960109800.2960960110800.2960960111800.2960960112800.2960960113800.2960960114800.2960960115800.2960960116800.2960960117800.2960960118800.2960960119800.2960960120800.2960960121800.2960960122800.2960960123800.2960960124800.296096012

6、5800.25960960126800.25960960127800.25960960128800.25960960129800.25960960130800.25960960131800.25960960132800.25960960133800.25960960134800.25960960135800.25960960136800.25960960137800.25960960138800.25960960139800.25960960140800.25960960141800.25960960142800.25960960143800.25960960144800.2596096014

7、5800.25960960146800.25960960147800.25960960148800.25960960149800.25960960150800.25960960151800.25960960152800.25960960153800.25960960154800.25960960155800.25960960156800.25960960157800.25960960158800.25960960159800.25960960160800.25960960161800.25960960162800.25960960163800.25960960164800.2596096016

8、5800.25960960166800.25960960167800.25960960168800.25960960169800.25960960170800.25960960171800.25960960172800.25960960173800.25960960174800.25960960175800.25960960176800.25960960177800.25960960178800.25960960179800.25960960180800.25960960181800.25960960182800.25960960183800.25960960184800.2596096018

9、5800.25960960186800.25960960187800.25960960188800.25960960189800.25960960190800.25960960191800.25960960192800.25960960193800.25960960194800.25960960195800.25960960196800.25960960197800.25960960198800.25960960199800.25960960200800.25960960205800.25960960210800.25960960215800.25960960220800.2596096022

10、5800.25960960230800.25960960235800.25960960240800.25960960245800.25960960250800.25960960255800.25960960260800.25960960265800.25960960270800.25960960275800.25960960280800.25960960285800.25960960290800.25960960295800.25960960300800.25960960305800.25960960310800.25960960315800.25960960320800.2596096032

11、5800.25960960330800.25960960335800.25960960340800.25960960345800.25960960350800.25960960355800.25960960360800.25960960365800.25960960370800.25960960375800.25速算扣除数月薪个税年终奖税率速算扣除数100575155100000.3275555052129800.030优化后税后年收入720535工资年终奖调节计算表备注：全表格只需输入黄色和绿色两个区域数值，其中黄色区域输入：税前月收入的整百位数；绿色区域输入：税前月收入低于百位的金额1）年

12、奖调整，是指把部分年终奖转移到某月工资中去发放，以期减少年奖的税率，减少个税。2）调整的前提是：年奖的税率要高于该月工资的税率，或者调整后，剩余年奖的税率要比调整前低。3）是否调整的唯一判断依据是：调整后，该月工资和年奖的个税之和 不调整的月工资和年奖的个税之和。02.49180000.35550505.49168000.35550508.49156000.355505011.49144000.355505014.49132000.355505017.49120000.355505020.49108000.355505023.49096000.355505026.49084000.355505

13、029.49072000.355505032.49060000.355505035.49048000.355505038.49036000.355505041.49024000.355505044.49012000.355505105539000000.355505105638988000.355505105738976000.355505105838964000.355505105938952000.3555051051038940000.3555051051138928000.3555051051238916000.3555051051338904000.35550510514388920

14、00.3555051051538880000.3555051051638868000.3555051051738856000.3555051051838844000.3555051051938832000.3555051052038820000.3555051052138808000.3555051052238796000.3555051052338784000.3555051052438772000.3555051052538760000.3555051052638748000.3555051052738736000.3555051052838724000.35550510529387120

15、00.3555051053038700000.3555051053138688000.3555051053238676000.3555051053338664000.3555051053438652000.3555055553618640000.3555055553818628000.3555055554018616000.3555055554218604000.3555055554418592000.3555055554618580000.3555055554818568000.3555055555018556000.3555055555218544000.35550555554185320

16、00.3555055555618520000.3555055555818508000.3555055556018496000.3555055556218484000.3555055556418472000.3555055556618460000.3555055556818448000.3555055557018436000.3555055557218424000.3555055557418412000.3555055557618400000.3555055557818388000.3555055558018376000.3555055558218364000.35550555584183520

17、00.3555055558618340000.3555055558818328000.3555055559018316000.3555055559218304000.3555055559418292000.3555055559618280000.3555055559818268000.35550555510018256000.35550555510218244000.35550555510418232000.35550555510618220000.35550555510818208000.35550555511018196000.35550555511218184000.3555055551

18、1418172000.35550555511618160000.35550555511818148000.35550555512018136000.35550555512218124000.35550555512418112000.355505100512658100000.355505100512908088000.355505100513158076000.355505100513408064000.355505100513658052000.355505100513908040000.355505100514158028000.355505100514408016000.35550510

19、0514658004000.355505100514907992000.355505100515157980000.355505100515407968000.355505100515657956000.355505100515907944000.355505100516157932000.355505100516407920000.355505100516657908000.355505100516907896000.355505100517157884000.355505100517407872000.355505100517657860000.355505100517907848000.

20、355505100518157836000.355505100518407824000.355505100518657812000.355505100518907800000.355505100519157788000.355505100519407776000.355505100519657764000.355505100519907752000.355505100520157740000.355505100520407728000.355505100520657716000.355505100520907704000.355505100521157692000.35550510052140

21、7680000.355505100521657668000.355505100521907656000.355505100522157644000.355505100522407632000.355505100522657620000.355505100522907608000.355505100523157596000.355505100523407584000.355505100523657572000.355505100523907560000.355505100524157548000.355505100524407536000.355505100524657524000.355505

22、100524907512000.355505100525157500000.355505100525407488000.355505100525657476000.355505100525907464000.355505100526157452000.355505100526407440000.355505100526657428000.355505100526907416000.355505100527157404000.355505100527407392000.355505100527657380000.355505100527907368000.35550510052815735600

23、0.355505100528407344000.355505100528657332000.355505100528907320000.355505100529157308000.355505100529407296000.355505100529657284000.355505100529907272000.355505100530157260000.355505100530407248000.355505100530657236000.355505100530907224000.355505100531157212000.355505100531407200000.355505100532

24、657140000.355505100533907080000.355505100535157020000.355505100536406960000.355505100537656900000.355505100538906840000.355505100540156780000.355505100541406720000.355505100542656660000.355505100543906600000.32755100545156540000.32755100546406480000.32755100547656420000.32755100548906360000.32755100

25、550156300000.32755100551406240000.32755100552656180000.32755100553906120000.32755100555156060000.32755100556406000000.32755100557655940000.32755100558905880000.32755100560155820000.32755100561405760000.32755100562655700000.32755100563905640000.32755100565155580000.32755100566405520000.32755100567655

26、460000.32755100568905400000.32755100570155340000.32755100571405280000.32755100572655220000.32755100573905160000.32755100575155100000.32755年终奖个税个税合计税后年收入1502452404257205350255576705384节约的个税金额15151节约的个税金额15151315795315823.8645136.2315375315439.8645520.2314955315055.8645904.2314535314671.8646288.231411

27、5314287.8646672.2313695313903.8647056.2313275313519.8647440.2312855313135.8647824.2312435312751.8648208.2312015312367.8648592.2311595311983.8648976.2311175311599.8649360.2310755311215.8649744.2310335310831.8650128.2309915310447.8650512.2309495310131650829309075309831651129308655309531651429308235309

28、231651729307815308931652029307395308631652329306975308331652629306555308031652929306135307731653229305715307431653529305295307131653829304875306831654129304455306531654429304035306231654729303615305931655029303195305631655329302775305331655629302355305031655929301935304731656229301515304431656529301

29、095304131656829300675303831657129300255303531657429299835303231657729299415302931658029298995302631658329298575302331658629298155302031658929297735301731659229297315301431659529296895301227659733296475301047659913296055300867660093295635300687660273295215300507660453294795300327660633294375300147660

30、813293955299967660993293535299787661173293115299607661353292695299427661533292275299247661713291855299067661893291435298887662073291015298707662253290595298527662433290175298347662613289755298167662793289335297987662973288915297807663153288495297627663333288075297447663513287655297267663693287235297

31、087663873286815296907664053286395296727664233285975296547664413285555296367664593285135296187664773284715296007664953284295295827665133283875295647665313283455295467665493283035295287665673282615295107665853282195294927666033281775294747666213281355294567666393280935294387666573280515294207666753280

32、095294027666933279675293847667113279255293667667293278835293487667473278415293307667653277995293175667785277575293055667905277155292935668025276735292815668145276315292695668265275895292575668385275475292455668505275055292335668625274635292215668745274215292095668865273795291975668985273375291855669

33、105272955291735669225272535291615669345272115291495669465271695291375669585271275291255669705270855291135669825270435291015669945270015290895670065269595290775670185269175290655670305268755290535670425268335290415670545267915290295670665267495290175670785267075290055670905266655289935671025266235289

34、815671145265815289695671265265395289575671385264975289455671505264555289335671625264135289215671745263715289095671865263295288975671985262875288855672105262455288735672225262035288615672345261615288495672465261195288375672585260775288255672705260355288135672825259935288015672945259515287895673065259

35、095287775673185258675287655673305258255287535673425257835287415673545257415287295673665256995287175673785256575287055673905256155286935674025255735286815674145255315286695674265254895286575674385254475286455674505254055286335674625253635286215674745253215286095674865252795285975674985252375285855675

36、105251955285735675225251535285615675345251115285495675465250695285375675585250275285255675705249855285135675825249435285015675945249015284895676065248595284775676185248175284655676305247755284535676425247335284415676545246915284295676665246495284175676785244395283575677385242295282975677985240195282

37、375678585238095281775679185235995281175679785233895280575680385231795279975680985229695279375681585227595278775682185195245247925713035193445247625713335191645247325713635189845247025713935188045246725714235186245246425714535184445246125714835182645245825715135180845245525715435179045245225715735177245244925716035175445244625716335173645244325716635171845244025716935170045243725717235168245243425717535166445243125717835164645242825718135162845242525718435161045242225718735159245241925719035157445241625719335155645241325719635153845241025719935152045240725720235150245240425720535