Excel format to calculate Deferred Tax, MAT and Computation of Tax for 5 A.Y.

Friends most of us face the challenge of calculating tax as per Income tax and AS 22. Here an effort is made to comprise all tax computation viz., Provision for Tax, MAT, Deferred Tax and allowance and disallowance of Depreciation under Companies Act and Income tax Act in one single excel file.

Further to check whether the DTL/DTA can be carried forward the calculation is done for next 5 years to be bring it in conformity with the recognition criteria mentioned under AS 22.