Tax excel utility

375 views 4 replies
dear all . I need the tax calculation excel utility l. If someone has it please send me urgently . my email I'd is singhaniadevesh @ gmail.com best regards Devesh
Replies (4)

type in cell say d16

=IF(D15>=1000000,(D15-1000000)*0.3+125000,IF(D15>500000,(D15-500000)*0.2+25000,IF(D15>=250000,(D15-250000)*0.1-MIN((D15-250000)*0.1,2000),0)))

let D15 contain the taxable income 

87A is taken care off here

I hope this helps and this is what you want.

Happy tax calculating

Thanks Mr Shiroor, but I missed to mention that we need utility for calculating interest (234abc) specifially. Pls send if you have.

for calculating that just download the excel utility of ITR-1/2/4 - as relevant to you

Offline - calculate the interest due to 234 a,b,c

You can take help for calculating interest under 234 a b c from this link

https://finotax.com/income-tax/intt234


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register