PeppyBiscuit
PeppyBiscuit

Salary calculation and negotiation

Hey folks!

Been seeing a lot of posts about salary negotiations and calculations, so I thought I'd share something that helped me out.

I made this salary breakdown & negotiation planner during one of my HR rounds—figured it might come in handy for you too! Feel free to copy & customize it:

https://docs.google.com/spreadsheets/d/1Uqxj0CVAvnOs5jFW8GjKuz36arb_MxkJOgGx0PXAB8g/edit?usp=drivesdk

P.S. Just update your fixed pay, change the % and values on components and living expenses tab, and the rest is all formula driven.

Hope this helps!

4mo ago
Talking product sense with Ridhi
9 min AI interview5 questions
Round 1 by Grapevine
ZoomyNarwhal
ZoomyNarwhal

Some issues here. Current income in F13 is inclusive of taxes? Because expected income in f18 is post taxes.

PeppyBiscuit
PeppyBiscuit

Yes current income both in F13 and F14 is post taxes. Some companies have a monthly variable component (for eg: performance based, % share of no. of successful sales etc), so the one in F13 is just your (monthly) fixed+variable.

SwirlyMarshmallow
SwirlyMarshmallow

You have missed 10% surcharge on income tax if the taxable income is above 50,00,000

Discover more
Curated from across
Personal Finance
by QuirkyPretzelSoftware Test - QA

CTC to In-Hand CheatSheet

Seems a valid calculation to me.

You can refer to it probably next time when you are discussing pay or pay raise.

The og author has calculated like this: 'This is almost the best-case scenario without the variable component.

12% PF de...

Post image
Top comments
user

Can you provide the same for 15cr, just wanted to check if I am negotiating right. Provided an offer of 14cr, need to...

user

1 cr pe 5 - 6 lakh hi aenge bss....

Misc
Misc18mo
by GoofyMochiFlipkart

First Milestone - Hope many more to go

Posting here not for bragging but to just let people like me know who look at extraordinary salaries and feel sad - it is possible just believe in yourself. I never thought I’d reach even this.

4.5 years of workex in a non-tech role, ...

Post image
Top comment
user

Very nice. It is great to see people post their investing stories. Tip: I feel a Google Sheets doc looks a little l...