Tax excel utility
devesh (India finance head) (25 Points)
29 August 2015
S. Shiroor
(Others)
(1207 Points)
Replied 29 August 2015
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
devesh
(India finance head)
(25 Points)
Replied 29 August 2015
S. Shiroor
(Others)
(1207 Points)
Replied 29 August 2015
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
S. Shiroor
(Others)
(1207 Points)
Replied 30 August 2015
You can take help for calculating interest under 234 a b c from this link
https://finotax.com/income-tax/intt234
GST Live Certification Course (39th Batch) - April 2024 (Weekend Batch) (With Certificate)
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"