Need Salary Calculation from Net Salary to Gross Calcuation

[gsuresh123]

Hi,
I'm looking for salary calculator which calculate Gross Salary if we input Net Salary. The Components bifurcation is as follows:
Basic Salary: 70% of Gross Salary
HRA: 30% of Basic Salary

ESIC: Gross Salary*0.25%(if Gross salary is Greater than 21,000, ESIC=0)
EPF:Basic Salary*12%(If Basic Salary is greater than 15,000, EPF=0)
PT:If Gross is Less than 15000 than PT =0, If Gross is Greater than 15,000 and Less Than 20,000 then PT=150 , If Gross is greater than 20,000, PT=200

Based on the above criteria, please help me in calculating Gross Salary if I Input Net Salary in Excel.

Thanks & Regards
Suresh
9959172919

 

[gsuresh123]

Book1
	F	G	H
6	Component Category	Per month	Per Annum
7	Enter Gross Here	15000
8	Basic Pay	10500	126000
9	HRA	4500	54000
10	Total Gross	15000	180000
11	Employee Contribution to PF	1260	15120
12	Employee Contribution to ESI	113	1356
13	Profession Tax	0	0
14	Net Take Home	13627	163524
15	Employer Contribution to PF	1260	15120
16	PF Admin charges	106
17	Employer Contribution to ESI	488	5856
18	Cost to Company	16748	200976
Sheet2

Cell Formulas
Range	Formula
H8:H15, H17:H18	H8	=G8*12
G8	G8	=ROUND(G7*0.7,0)
G9	G9	=G7-G8
G10	G10	=SUM(G8:G9)
G11	G11	=ROUND(IF(G8>15001.01,0,IF(G8<15000.01,G8*0.12,0)),0)
G12	G12	=ROUND(IF(G10<21000.01,G10*0.75/100,IF(G10>21000.01,0)),0)
G13	G13	=ROUND(IF(G10<15000.01,0,IF(G10<20000.01,150,IF(G10>20000.01,200))),0)
G14	G14	=G10-G11-G12-G13
G15	G15	=ROUND(IF(G8>15001.01,0,IF(G8<15000.01,G8*12%,0)),0)
G16	G16	=ROUND(IF(G8>15001.01,0,IF(G8<15000.01,G8*1.01%,0)),0)
G17	G17	=ROUND(IF(G10<21000.01,G10*3.25/100,IF(G10>21000.01,0)),0)
G18	G18	=G10+G15+G17

Dear Dave.

As you required, Please find the attached sheet. Now i need a reverse calculation, that i i give input for Net Salarsy, then I shoukd get Gross Salary.

Please do the needful.

Regards
Suresh

 

[Dave Patton]

The taxes that I have seen increase as the income increases; your situation seems to be the opposite.
Does your post represent the information that you require?
Previously
HRA was specified as 30% of Basic; that is not what the sheet shows.
Is HRA a deduction from income?
Esic was specified as 0.25%; that is not what the sheet shows.
What is the actual Net Income?

 

[gsuresh123]

Actual N

The taxes that I have seen increase as the income increases; your situation seems to be the opposite.
Does your post represent the information that you require?
Previously
HRA was specified as 30% of Basic; that is not what the sheet shows.
Is HRA a deduction from income?
Esic was specified as 0.25%; that is not what the sheet shows.
What is the actual Net Income?

Actual Net Income is as per the Sheet is: Gross Salary - ESIC-PF-PT
Calculation for ESIC, PF and PT were given according to slabs

 

[Dave Patton]

Based on the rates and information shown on your last post and the net income shown.
The Net divided by 0.9085 yields the Gross.

Book1
	F	G	H
21	Gross income required	15000	15000
3e

Cell Formulas
Range	Formula
G21	G21	=G14/(1-(0.7*0.12+0.0075))
H21	H21	=G14/0.9085

Previously
HRA was specified as 30% of Basic; that is not what the sheet shows.
Is HRA a deduction from income?
Esic was specified as 0.25%; that is not what the sheet shows.
What is the actual Net Income?