税后薪酬个税计算税后工资每月相同和不同Excel模板 用excel 计算税后工资，怎么算呀
\u77e5\u9053\u5e94\u7f34\u4e2a\u4eba\u6240\u5f97\u7a0e\u7a0e\u989d\u5012\u7b97\u5de5\u8d44 \uff0c\u6c42EXCEL\u516c\u5f0f\u3002\u7a0e\u540e\u5de5\u8d44\u5012\u63a8\u7a0e\u524d\u5de5\u8d44Excel\u8ba1\u7b97\u516c\u5f0f
\u5012\u63a8\u7a0e\u524d1=MAX((\u5b9e\u53d1-5000-{0,210,1410,2660,4410,7160,15160})/(1-{3,10,20,25,30,35,45}%)+5000,\u5b9e\u53d1)+SUM(\u6263\u9664\u7684\u51e0\u9669\u51e0\u91d1)
\u5012\u63a8\u7a0e\u524d2=MIN((\u7a0e\u91d1+{0,210,1410,2660,4410,7160,15160})/{3,10,20,25,30,35,45}%)+5000+SUM(\u793e\u4fdd)
\u5373\uff1a=MIN((\u7a0e\u91d1+{\u901f\u7b97\u6263\u9664\u6570})/{\u7a0e\u7387}%)+\u8d77\u5f81\u70b9+SUM(\u6309\u89c4\u5b9a\u6263\u9664\u7684\u51e0\u9669\u51e0\u91d1)
\u7a0e\u524d\u6536\u5165=(\u7a0e\u540e\u6536\u5165-\u6263\u9664\u8d39\u7528*\u7a0e\u7387-\u901f\u7b97\u6263\u9664\u6570)/ (1-\u7a0e\u7387)
\u7a0e\u524d\u6536\u5165=(\u7a0e\u540e\u6536\u5165-\u6263\u9664\u8d39\u7528*\u7a0e\u7387-\u901f\u7b97\u6263\u9664\u6570)/ (1-\u7a0e\u7387)
=(\u7a0e\u540e\u6536\u5165-\u6263\u9664\u8d39\u7528-\u901f\u7b97\u6263\u9664\u6570)/(1-\u7a0e\u7387)+\u6263\u9664\u8d39\u7528
=(\u7a0e\u540e\u6536\u5165-\u6263\u9664\u8d39\u7528-\u901f\u7b97\u6263\u9664\u6570)/(1-\u7a0e\u7387)+\u6263\u9664\u8d39\u7528 (1-\u7a0e\u7387)/ (1-\u7a0e\u7387)
=(\u7a0e\u540e\u6536\u5165-\u6263\u9664\u8d39\u7528-\u901f\u7b97\u6263\u9664\u6570+\u6263\u9664\u8d39\u7528-\u6263\u9664\u8d39\u7528*\u7a0e\u7387)/(1-\u7a0e\u7387)
=\u7a0e\u540e\u6536\u5165-\u6263\u9664\u8d39\u7528*\u7a0e\u7387-\u901f\u7b97\u6263\u9664\u6570)/ (1-\u7a0e\u7387)
\u6269\u5c55\u8d44\u6599\uff1a(2018\u5e7410\u67081\u65e5\u8d77\u5b9e\u65bd\u65b0\u89c4\uff0cExcel\u9002\u7528\uff0c\u5de5\u8d44\u6838\u7b97\u9002\u7528)
=ROUND(MAX((A1-5000)*0.01*{3,10,20,25,30,35,45}-{0,210,1410,2660,4410,7160,15160},0),2)
\u516c\u5f0f\u89e3\u91ca\uff1a
\u91ca\u2460\uff1a0.01*{3,10,20,25,30,35,45}\u4e3a\u7a0e\u7387\uff0c\u5206\u522b\u4e3a3%\u300110%\u300120%\u300125%\u300130%\u300135%\u300145%
\u91ca\u2461\uff1a{0,210,1410,2660,4410,7160,15160}\u4e3a\u901f\u7b97\u6263\u9664\u6570\uff0c\u5206\u522b\u4e3a0\u3001210\u30011410\u30012660\u30014410\u30017160\u300115160
\u91ca\u2462\uff1a\u53c2\u6570MAX\u610f\u4e3a\uff1a\u4e2a\u4eba\u5de5\u8d44\u51cf\u53bb\u8d77\u5f81\u70b95000\u7684\u514d\u5f81\u989d\u5206\u522b\u4e58\u4ee57\u4e2a\u7a0e\u7387\uff0c\u518d\u51cf\u53bb\u5bf9\u5e94\u7684\u901f\u7b97\u6263\u9664\u6570\uff0c\u5c06\u6700\u540e\u5f97\u5230\u7684\u6570\u636e\u53d6\u6700\u5927\u503c\u3002
\u91ca\u2463\uff1a\u53c2\u6570ROUND\u610f\u4e3a\uff1a\u5c06\u516c\u5f0f\u5185\u7684\u6570\u503c\u56db\u820d\u4e94\u5165\uff0c\u4fdd\u7559\u4e24\u4f4d\u5c0f\u6570\u3002
\u91ca\u2464\uff1aA1\uff0c\u6307\u5411\u7a0e\u524d\u5e94\u53d1-\u7a0e\u524d\u62b5\u6263\u9879\u76ee\u4e4b\u540e\u7684\u5e94\u7a0e\u91d1\u989d\u3002
\u53c2\u8003\u8d44\u6599\u6765\u6e90\uff1a\u767e\u5ea6\u767e\u79d1-\u4e2a\u4eba\u6240\u5f97\u7a0e\u7a0e\u7387\u8868
\u4e00\u3001\u663e\u793a\uff1a\u7a0e\u7387/\u901f\u7b97\u6263\u9664\u6570
=IF(AK5<=0,"0%"&" 0",IF(AK5<=1500,"3%"&" 0",IF(AK5<=4500,"10%"&" 105",IF(AK5<=9000,"20%"&" 555",IF(AK5<=35000,"25%"&" 1005",IF(AK5<=55000,"30%"&" 2755",IF(AK5<=80000,"35%"&" 5505",)))))))
\u4e8c\u3001\u7a0e\u7387\uff1a
=IF(AK4<=0,"0%",IF(AK4<=1500,"3%",IF(AK4<=4500,"10%",IF(AK4<=9000,"20%",IF(AK4<=35000,"25%",IF(AK4<=55000,"30%",IF(AK4<=80000,"35%",)))))))
\u4e09\u3001\u6263\u9664\u6570
=IF(AK5<=0,"0",IF(AK5<=1500,"0",IF(AK5<=4500,"105",IF(AK5<=9000,"555",IF(AK5<=35000,"1005",IF(AK5<=55000,"2755",IF(AK5<=80000,"5505",)))))))
\u56db\u3001\u8ba1\u7b97\u7a0e\u91d1
=ROUND((AK8*AQ8-AR8),2)
绛旓細鐢变簬鐜板湪灞呮皯涓汉缁煎悎鎵寰楋紙宸ヨ祫钖噾灞炰簬缁煎悎鎵寰楋級鏄寜骞村緛鏀躲鎸夋湀鎴栬呮寜娆￠缂淬佸勾搴︽眹绠楁竻缂寸殑銆傝岄鎵ｉ缂寸◣娆炬椂锛屽浜庡伐璧勮柂閲戞墍寰楋紝閲囩敤鐨勬槸绱棰勬墸娉曪紝鍗充互绾崇◣浜烘湰骞村害鎴嚦褰撳墠鏈堜唤鍙栧緱鐨勭疮璁℃敹鍏ュ噺闄ょ疮璁″厤绋庢敹鍏ャ佺疮璁″噺闄よ垂鐢ㄣ佺疮璁′笓椤规墸闄ゃ佺疮璁′笓椤归檮鍔犳墸闄ゅ拰绱渚濇硶纭畾鐨勫叾浠栨墸闄ゅ悗鐨勪綑棰濅负...
绛旓細鎵ｄ簲闄涓◣鍚鏈2涓囧噣宸ヨ祫銆璁＄畻鏂瑰紡锛氱◣棰濅负锛氬簲绾崇◣鎵寰楅=锛堟湀鏀跺叆-浜旈櫓涓閲-璧峰緛鐐-渚濇硶纭畾鐨勫叾浠栨墸闄-涓撻」闄勫姞鎵ｉ櫎锛*閫傜敤绋庣巼-閫熺畻鎵ｉ櫎鏁 鏈堟敹鍏25000鍏冦佷簲闄╀竴閲0鍏冦佽捣寰佺偣5000鍏冦佷緷娉曠‘瀹氱殑鍏朵粬鎵ｉ櫎0鍏冦佷笓椤归檮鍔犳墸闄0鍏冦侀傜敤绋庣巼20%銆侀熺畻鎵ｉ櫎鏁1410銆傜◣棰=(25000-0-5000-0-0)脳20...
绛旓細绋庡悗鏀跺叆=绋庡墠鏀跺叆-{(绋庡墠鏀跺叆-鎵ｉ櫎璐圭敤)*绋庣巼-閫熺畻鎵ｉ櫎鏁皚 绋庡墠鏀跺叆=(绋庡悗鏀跺叆-鎵ｉ櫎璐圭敤*绋庣巼-閫熺畻鎵ｉ櫎鏁)/(1-绋庣巼)鎵浠ワ紝绋庡悗涓涓囬傜敤鐨涓汉鎵寰楃◣搴斿綋涓25%锛岄熺畻鎵ｉ櫎鏁1005锛岄偅涔堝亣璁剧◣鍓嶄负X锛屽垯缂寸撼鐨涓◣涓篨*25%-1005锛屽彲鍒楁柟绋媂-锛圶*25%-1005锛=10000锛璁＄畻X=11993.33锛岀◣鍓宸ヨ祫涓1...
绛旓細19骞绋庡悗钖叕涓◣璁＄畻妯℃澘璇存槑1銆佹湀浠芥槸蹇呭綍椤广傝嫢涓骞翠腑閫旀崲宸ヤ綔锛岄偅涔堝湪鏂颁紒涓氱殑姣忔湀宸ヨ祫涓◣璁＄畻浼氫互鍦ㄨ亴鏈堟暟杩涜璁＄畻锛岃繖閲岃閫夋嫨鍦ㄨ亴鏈堟暟銆2銆佸鏋滃簲鍙戝伐璧勩佷簲闄╀竴閲戙佷笓椤归檮鍔犳墸闄ゆ瘡鏈堝潎鐩稿悓锛屼笉鐢ㄤ慨鏀瑰叕寮忥紝濡傛灉鏈変笉鍚屾妸涓婃湀绱鏍囩伆鑹插尯鍩熷鍒跺埌鏈〃涓婃湀绱缁胯壊鍖哄煙銆3銆佷簲闄╀竴閲戝拰涓撻」闄勫姞绛...
绛旓細绋庡墠宸ヨ祫=绋庡悗宸ヨ祫+鎵ｇ◣棰+鍏朵粬鎵ｆ 搴旂撼绋庨=锛堝伐璧勬婚-鍩烘暟2000-涓汉搴旇礋鎷呯殑绀句繚璐圭敤锛*閫傜敤鐨勭◣鐜囥
绛旓細6銆佸伐璧勮寖鍥村湪40001-60000鍏冪殑锛涓◣绋庣巼涓30%锛7銆佸伐璧勮寖鍥村湪60001-85000鍏冪殑锛屼釜绋庣◣鐜囦负35%锛8銆佸伐璧勮寖鍥村湪85001-鏃犻檺鐨勶紝涓◣绋庣巼涓45%銆備簩銆绋庡悗宸ヨ祫鎬庝箞绠 1銆佺◣鍚庡伐璧勬柊璁＄畻鏂规硶鏄牴鎹柊涓◣娉曡瀹氳屽緱鍑虹殑锛屽叿浣撳唴瀹规槸锛氫粠2018骞10鏈1鏃ヨ捣鎵ц锛宸ヨ祫钖噾閫傜敤涓冪骇瓒呴绱繘鍒讹紝鍏蜂綋濡備笅钖噾鎵...
绛旓細4銆佺敵鎶ユ垚鍔熷悗,鍦"涓汉鎵寰楃◣绾崇◣娓呭崟鏌ヨ鍜岀敵璇"涓笅杞藉弽棣堟枃浠跺苟瀵煎叆涓◣瀹㈡埛绔互瀹屾垚鐢虫姤涓氬姟.宸ヨ祫銆佽柂閲戞墍寰楀浣曠敵鎶ョ即绾充釜浜烘墍寰楃◣ 宸ヨ祫钖噾鎵寰,鎸夋湀璁＄畻寰佺即涓汉鎵寰楃◣,涓◣鐢辨墍鍦ㄥ崟浣嶄唬鎵ｄ唬缂,鎷垮埌鎵嬩腑鐨勫伐璧勯兘鏄绋庡悗宸ヨ祫.涓嬮潰缁欏ぇ瀹惰涓宸ヨ祫涓◣鐨勮绠楁柟娉,浠ュ強娉ㄦ剰浜嬮」,宸ヨ柂闃跺眰杈涜緵鑻﹁嫤璧氶挶,...
绛旓細鎶婁簲閲戣垂鐢ㄥ厛鎵ｉ櫎锛岀劧鍚璁＄畻绾崇◣璐圭敤锛屽墿涓嬪氨鏄绋庡悗宸ヨ祫銆
绛旓細鎵ｄ釜浜洪儴鍒嗭紳鍩烘暟*姣斾緥锛屽悇鍦板尯涓嶄竴鏍凤紝鎵浠ユ垜娌℃硶甯綘绠椼傚疄鍙宸ヨ祫璁＄畻鏂规硶锛1銆宸ヨ祫涓◣鐨勮绠楀叕寮忎负锛氬簲绾崇◣棰=锛宸ヨ祫钖噾鎵寰 锛嶁滀簲闄╀竴閲戔濓紞鎵ｉ櫎鏁帮級脳閫傜敤绋庣巼锛嶉熺畻鎵ｉ櫎鏁 涓◣鍏嶅緛棰濇槸3500锛屼娇鐢ㄨ秴棰濈疮杩涚◣鐜囩殑璁＄畻鏂规硶濡備笅锛氱即绋=鍏ㄦ湀搴旂撼绋庢墍寰楅*绋庣巼-閫熺畻鎵ｉ櫎鏁 2銆佸疄鍙戝伐璧=搴斿彂...
绛旓細濡傛灉浠ヤ綘鐨宸ヨ祫2240鍏冧负璁＄畻鍩烘暟鐨勮瘽锛屾瘡鏈堝湪浣犲伐璧勯噷杩樿鎵ｆ帀179.2鍏冿紙2240*8%锛夌殑鍏昏佷繚闄┿44.8鍏冿紙2240*2%锛夌殑鍖荤枟淇濋櫓銆22.4鍏冿紙2240*1%锛夌殑澶变笟淇濋櫓銆224鍏冿紙2240*10%锛夌殑浣忔埧鍏Н閲戯紝杩欐牱浣姣忎釜鏈瀹炲緱宸ヨ祫涓1769.6鍏冿紝涓嶇敤浜ょ◣銆1銆2銆4銆5銆7銆8銆10銆11鏈堟瘡鏈搴旂撼涓◣锛0 3銆6...
