Surcharge calculation on income over 1 crore

I think you got your computation wrong.  you are right upto 2 lakhs...but thereafter you got it wrong.

See, the concept here in working is marginal relief. 

Please refer to attached file to understand the same.

Thanks dear, But I tried couple of online calculators including that of govt of India site as well. And all shows the same surcharge figures as I have stated earlier. Please see here - https://law.incometaxindia.gov.in/DIT/Xtras/taxcalc.aspx (see attached file).

Dear Friend,

I checked just now...the link you gave gives the same result as my file is giving. 

please check again.

For 1.04 Cr
 

Dear Nikhil, It seems the different calculators are giving different figures. Please see attached for 104 Lacs and 105 Lacs.  So confused now which is correct?

There is no confusion.  I did the computation for a company.  You are doing for an individual...thats the difference..

Ohh God, I am looking for individuals calculation Nikhil.  Do you have for individuals pls?

the computation for individuals is correct as these online calculators are giving.  The earlier question of why it is 2.98 lakhs at 1.05 cr.  that is because of the effect of marginal relief. 
 

Nikhil, what is the formula to calculate that marginal refief please?  If you give me an example in the s/sheet as you send earlier for companies would be helpful and appreciated.

the formula is there in the sheet provided in my last message...

OK, I thought the formula provided in the last sheet was for companies and not for individuals..