2008年上海税前税后工资对照表

网上找来找去只找到2006年的.于是,自己研究了一下四金和个人所得税的计算方法,用EXCEL做了下面这张2008年上海税前税后工资对照表

税前	四金基数	养老保险金	医疗保险金	失业保险金	住房公积金	四金总和	缴税	税后到手收入
￥1,000.00	￥1,735.00	￥138.80	￥34.70	￥17.35	￥121.45	￥312.30	￥0.00	￥687.70
￥1,500.00	￥1,735.00	￥138.80	￥34.70	￥17.35	￥121.45	￥312.30	￥0.00	￥1,187.70
￥2,000.00	￥2,000.00	￥160.00	￥40.00	￥20.00	￥140.00	￥360.00	￥2.00	￥1,638.00
￥2,500.00	￥2,500.00	￥200.00	￥50.00	￥25.00	￥175.00	￥450.00	￥22.50	￥2,027.50
￥3,000.00	￥3,000.00	￥240.00	￥60.00	￥30.00	￥210.00	￥540.00	￥61.00	￥2,399.00
￥3,500.00	￥3,500.00	￥280.00	￥70.00	￥35.00	￥245.00	￥630.00	￥102.00	￥2,768.00
￥4,000.00	￥4,000.00	￥320.00	￥80.00	￥40.00	￥280.00	￥720.00	￥143.00	￥3,137.00
￥4,500.00	￥4,500.00	￥360.00	￥90.00	￥45.00	￥315.00	￥810.00	￥188.50	￥3,501.50
￥5,000.00	￥5,000.00	￥400.00	￥100.00	￥50.00	￥350.00	￥900.00	￥250.00	￥3,850.00
￥5,500.00	￥5,500.00	￥440.00	￥110.00	￥55.00	￥385.00	￥990.00	￥311.50	￥4,198.50
￥6,000.00	￥6,000.00	￥480.00	￥120.00	￥60.00	￥420.00	￥1,080.00	￥373.00	￥4,547.00
￥6,500.00	￥6,500.00	￥520.00	￥130.00	￥65.00	￥455.00	￥1,170.00	￥434.50	￥4,895.50
￥7,000.00	￥7,000.00	￥560.00	￥140.00	￥70.00	￥490.00	￥1,260.00	￥496.00	￥5,244.00
￥7,500.00	￥7,500.00	￥600.00	￥150.00	￥75.00	￥525.00	￥1,350.00	￥557.50	￥5,592.50
￥8,000.00	￥8,000.00	￥640.00	￥160.00	￥80.00	￥560.00	￥1,440.00	￥619.00	￥5,941.00
￥8,500.00	￥8,500.00	￥680.00	￥170.00	￥85.00	￥595.00	￥1,530.00	￥699.00	￥6,271.00
￥9,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥792.66	￥6,645.66
￥9,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥892.66	￥7,045.66
￥10,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥992.66	￥7,445.66
￥10,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,092.66	￥7,845.66
￥11,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,192.66	￥8,245.66
￥11,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,292.66	￥8,645.66
￥12,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,392.66	￥9,045.66
￥12,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,492.66	￥9,445.66
￥13,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,592.66	￥9,845.66
￥13,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,692.66	￥10,245.66
￥14,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,792.66	￥10,645.66
￥14,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,892.66	￥11,045.66
￥15,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥1,992.66	￥11,445.66
￥15,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,092.66	￥11,845.66
￥16,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,192.66	￥12,245.66
￥16,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,292.66	￥12,645.66
￥17,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,392.66	￥13,045.66
￥17,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,492.66	￥13,445.66
￥18,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,592.66	￥13,845.66
￥18,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,692.66	￥14,245.66
￥19,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,792.66	￥14,645.66
￥19,500.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,892.66	￥15,045.66
￥20,000.00	￥8,676.00	￥694.08	￥173.52	￥86.76	￥607.32	￥1,561.68	￥2,992.66	￥15,445.66