{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Start","MAT Computation","1. Net Profit","2. Income-tax","3. Reserve","4. Provision - unascertain liab","5. Exp. to earn exempt income","6. Provision for diminution","7. Withdrawal from reserve","8. Exempt Income","9. Depreciation v. Loss","10. MAT Credit"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"This utility works with Macro. You must enable it to use it."]
[]
[]
[null,null,"(I)",">> For Excel 2003"]
[]
[null,null,null,"Go to"]
[null,null,null,"Tools > Options > Security > Macro Security must be set to Medium or Low."]
[]
[null,null,null,"Then restart Excel."]
[]
[null,null,"(II)",">> Excel 2007"]
[]
[null,null,null,"File or Office Button > Excel Options > Trust Center > Trust Center Settings button > Macro Settings "]
[null,null,null,"must be set to something other than Disable All Macros Without Notification."]

{"sheet":"MAT Computation","index":1,"n_rows":69,"n_cols":45,"rows_kept":69,"cut":false,"hidden":true,"merged":[[4,1,5,1],[64,1,66,3]]}
[null,"© www.excelfinder.com"]
[]
[null,"MAT Computation Utility in Excel"]
[]
[null,"Excel utility for MAT computation","Assessment year"]
[null,null,"2013-14"]
[null,"Particulars*","Amount"]
[]
[null,"Status of company","Foreign Company",{"$f":"IF(C9=\"Foreign Company\",\">> Compute\",\"\")","v":">> Compute"}]
[]
[null,"Net profit as per Profit and Loss account (A)",0,">> Compute"]
[]
[null,"Add: Positive adjustments"]
[null,"1) Income-tax and provision thereof",0,">> Compute"]
[]
[null,"2) Reserve created during the year",0,">> Compute"]
[]
[null,"3) Provisions for unascertained liabilities",0,">> Compute"]
[]
[null,"4) Provision for losses of subsidiary companies",0,">> Compute"]
[]
[null,"5) Dividend paid or proposed",0,">> Compute"]
[]
[null,"6) Expenditure to earn income exempt under Sec. 10, 11 and 12",0,">> Compute"]
[]
[null,"7) Depreciation (including the depreciation on revalued amount)",0,">> Compute"]
[]
[null,"8) Deferred tax liability created during the year",0]
[]
[null,"9) Provision for diminution in the value of any asset",0,">> Compute"]
[]
[null,"10) Revaluation reserve relating to revalued asset on retirement or disposal of such asset",0,">> Compute"]
[null,"Total positive adjustments (B)",{"$f":"SUM(C14:C32)","v":0}]
[]
[null,"Less: Negative adjustments"]
[null,"1) Amount withdrawn from any reserve or provision",0,">> Compute"]
[]
[null,"2) Income exempt under Sec. 10, 11 and 12",0,">> Compute"]
[]
[null,"3) Depreciation (excluding depreciation on revalued amount)",0]
[]
[null,"4) Lower of brought forward book losses or book depreciation",0,">> Compute"]
[]
[null,"5) Profits of sick industrial company (if losses doesn't exceed net worth)",0,">> Compute",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"6) Deferred tax assets created during the year",0]
[]
[null,"7) Amount withdrawn from revaluation reserve and credited to the P&L account, to the extent it does not exceed amount of depreciation on account of revaluation of assets as referred above.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total negative adjustments (C)",{"$f":"SUM(C36:C48)","v":0}]
[]
[null,"Book profits for purpose of MAT (A + B - C)",{"$f":"C11+C33-C49","v":0}]
[]
[null,"Minimum Alternative Tax",{"$f":"C51*0.185","v":0}]
[null,"Add: Surcharge",{"$f":"IF(C51>10000000,C53*IF(C9=\"Domestic Company\",5%,2%),0)","v":0}]
[null,"Add: Education Cess",{"$f":"(C53+C54)*2%","v":0}]
[null,"Add: Secondary and Higher Education Cess",{"$f":"SUM(C53:C54)*1%","v":0}]
[null,"Total tax payable as per MAT",{"$f":"SUM(C53:C56)","v":0}]
[]
[null,"Tax payable as per normal provisions (including surcharge and cess)",0]
[null,"Less: MAT Credit",0,">> Compute"]
[]
[null,"Final tax payable during the year",{"$f":"MAX(C57,(C59-C60))","v":0}]
[]
[null,"Disclaimer:"]
[null,"The conclusions reached and views expressed in the above computation are matters of opinion. Our conclusion are based on our perception of the prevailing law and regulations. However, there can be no assurance that the authorities or regulators may not take a position contrary to our views. "]
[]
[]
[]
[null,"© excelfinder.com"]

{"sheet":"1. Net Profit","index":2,"n_rows":56,"n_cols":4,"rows_kept":56,"cut":false,"hidden":true,"merged":[[51,1,53,2],[13,1,14,1],[34,1,35,1],[37,1,38,1],[44,1,45,1]]}
[null,"© www.excelfinder.com",">> Back to Computation sheet"]
[]
[null,"(I) Net Profits as per profit and loss account"]
[]
[null,"Particulars*","Amount"]
[]
[null,"Net profit as per profit and loss account",0]
[]
[null,"Less: Following expenses may be allowed as deduction while computing book profit (reduce it here if they are earlier added back in above figure):"]
[null,"1) Prior Period expenses",0,">>Case laws"]
[]
[null,"2) Loss disallowed under Sec. 94 i.e. dividend stripping, etc.",0,">>Case laws"]
[]
[null,"3) Excess depreciation charged to P&L account due to change in method of depreciation",0,">>Case laws"]
[]
[]
[null,"4) Extra ordinary expenses",0,">>Case laws"]
[]
[null,"5) Loss on sale of fixed assets",0,">>Case laws"]
[]
[null,"6) Provision for gratuity expenses",0,">>Case laws"]
[]
[null,"7) Provision for site restoration expenses",0,">>Case laws"]
[]
[null,"8) Other expenses",0]
[]
[null,"Add: Following expenses may not be allowed as deduction while computing the book profit (add it back here if they are reduced earlier from above figure):"]
[null,"1) Interest on borrowing capitalised with cost of fixed assets",0,">>Case laws"]
[]
[null,"2) Other expenses",0]
[]
[null,"Add: Following income may be subject to MAT (add it back here if they are reduced earlier from above figure):"]
[null,"1) Extra-ordinary income",0,">>Case laws"]
[]
[null,"2) Capital gain even if  not chargeable to tax due to Sec. 54EC exemption",0,">>Case laws"]
[]
[]
[null,"3) Capital gain from sale to 100% subsidiary even if  exemption under Sec. 47(iv)",0,">>Case laws"]
[]
[]
[null,"4) Capital receipts not taxable as per Act",0,">>Case laws"]
[]
[null,"5) Deduction under Chapter VI-A i.e. Sec. 80C to Sec. 80U",0,">>Case laws"]
[]
[null,"6) Capital gains from sale of fixed assets even if credited to capital reserve",0,">>Case laws"]
[]
[]
[null,"7) Other income",0]
[]
[null,"Total",{"$f":"SUM(C6:C49)","v":0}]
[]
[null,"* Please leave the cell blank in case any of the above items have not been added back to or reduced from net profit for computation of book profits"]
[]
[]
[]
[null,"© www.excelfinder.com"]

{"sheet":"2. Income-tax","index":3,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":true,"merged":[[31,1,33,2],[9,3,10,4],[4,3,5,4]]}
[null,"© www.excelfinder.com",">> Back to Computation sheet"]
[]
[null,"(II) Income-tax Expenses"]
[]
[null,"Particulars*","Amount",">> Tax expenses not subject to MAT"]
[]
[null,"1) Income-tax expenses for the current year",0]
[]
[null,"2) Income-tax expenses for any previous year but debited to P/L account during the year",0]
[]
[null,"3) Dividend distribution tax under Sec. 115-O",0]
[]
[null,"4) Tax on income distributed to unit-holders under Sec. 115R",0]
[]
[null,"5) Any interest charged under this Act, namely:"]
[null,"a) Interest under Sec. 234A",0]
[null,"b) Interest under Sec. 234B",0]
[null,"c) Interest under Sec. 234C",0]
[null,"d) Interest under Sec. 234D",0]
[null,"e) Interest under Sec. 220",0]
[null,"f) Interest under Sec. 201(1A)",0]
[null,"g) Any other interest",0]
[]
[null,"6) Surcharge levied under the Act",0]
[]
[null,"7) Education cess or Secondary and Higher Education Cess",0]
[]
[null,"8) Income-tax paid in foreign tax jurisdiction",0,">>Case law"]
[]
[null,"Total",{"$f":"SUM(C6:C29)","v":0}]
[]
[null,"* Please leave the cell blank in case any of the above items have not been debited to profit and loss as no adjustment would be made in that case."]
[]
[]
[]
[null,"© www.excelfinder.com"]

{"sheet":"3. Reserve","index":4,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[[27,1,28,2],[6,1,7,1],[15,1,16,1],[20,1,21,1]]}
[null,"© www.excelfinder.com",">> Back to Computation sheet"]
[]
[null,"(III) Reserves created after debiting P&L A/c"]
[]
[null,"Particulars*","Amount"]
[]
[null,"Any reserve created during the year, if it is debited to profit and loss account",0]
[]
[]
[null,"Less: Following reserves may not be subject to MAT (reduce it here if they are not yet reduced from above figure)"]
[]
[null,"(1) Advance against depreciation in case of power generation co.",0,">> Case laws"]
[]
[null,"(2) Share Premium",0]
[]
[null,"(3) Debenture redemption reserve created up to outstanding debentures",0,">> Case laws"]
[]
[]
[null,"(4) Loan redemption reserve",0,">> Case laws"]
[]
[null,"(5) Capital gains credited to capital reserve. However, it shall be added back in net profit",0,">> Case laws"]
[]
[]
[null,"(6) Others",0]
[]
[null,"Total",{"$f":"SUM(C6:C25)","v":0}]
[]
[null,"* Please leave the cell blank in case any of the above items have not been debited to profit and loss as no adjustment would be made in that case."]
[]
[]
[null,"© www.excelfinder.com"]

{"sheet":"4. Provision - unascertain liab","index":5,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":true,"merged":[[37,1,39,2],[6,1,8,1],[14,1,15,1],[31,1,33,1]]}
[null,"© www.excelfinder.com",">> Back to Computation sheet"]
[]
[null,"(IV) Provision for unascertain liability"]
[]
[null,"Particulars*","Amount"]
[]
[null,"Any provision for unascertained liability\n(a provision for expense which is not certain or not capable of being estimated with reasonable certainity)",0]
[]
[]
[]
[null,"Add: Following provisions may not be allowed as deduction while computing the MAT (add it back here if they are not yet added back in above figure):"]
[]
[null,"(1) Contingent liability in accordance with AS 29",0,">> Case laws"]
[]
[null,"(2) Other provision for expenses\n[If condition precedent to its accural is not satisfied]",0]
[]
[]
[null,"Less: Following provisions may be allowed as deduction while computing the MAT (reduce it here if they are not yet reduced from above figure):"]
[]
[null,"(1) Provisions for warranties if estimated on scientific basis",0,">> Case laws"]
[]
[null,"(2) Provision for repair expenses assessed on scientific basis",0,">> Case laws"]
[]
[null,"(3) Provision for gratuity",0,">> Case laws"]
[]
[null,"(4) Provision for bonus",0,">> Case laws"]
[]
[null,"(5) Provision for employees' benefits",0,">> Case laws"]
[]
[null,"6) Provision for future losses or liquidated damages",0,">> Case laws"]
[]
[null,"(7) Other provisions for expenses\n[If condition precedent to its accrual is satisfied even if condition precedent to its discharge is not satisfied]",0]
[]
[]
[]
[null,"Total",{"$f":"SUM(C6:C35)","v":0}]
[]
[null,"* Please leave the cell blank in case any of the above items have not been debited to profit and loss as no adjustment would be made in that case."]
[]
[]
[]
[null,"© www.excelfinder.com"]

{"sheet":"5. Exp. to earn exempt income","index":6,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":true,"merged":[[31,1,32,2],[2,1,3,2],[13,1,15,1],[24,1,25,1]]}
[null,"© www.excelfinder.com",">> Back to Computation sheet"]
[]
[null,"(IV) the amount or amounts of expenditure relatable to any income to which sec. 10 [other than Sec. 10(38)] or sec. 11 or sec. 12 apply."]
[]
[]
[null,"Particulars*","Amount"]
[]
[null,"(1) Expenses relating to income exempt under Sec. 10",0]
[]
[null,"(2) Expenses relating to income exempt under Sec. 11 and Sec. 12",0]
[]
[null,"Less: Following expenses may be allowed as deduction while computing the book profit (reduce it here if they are not yet reduced from above figure):"]
[]
[null,"(A) Expenditure relating to long term capital gain arising from transfer of equity shares or unit through stock exchange and STT paid on it. [see Sec. 10(38)]",0]
[]
[]
[]
[null,"(B) Share of loss from a firm as it isn’t an expenditure",0,">> Case laws"]
[]
[null,"(D) Others",0]
[]
[null,"Add: Following expenses may not be allowed as deduction while computing the book profit (add it back here if they are not yet added back in above figure):"]
[null,"(A) Expenses which are disallowed under Sec. 14A read with Rule 8D",0,">> Case laws"]
[]
[null,"(B) Expenditure in relation to income which is not exempt but eligible for deduction under Sec. 10A, 10B, 80-IA, 80-IB, etc.",0]
[]
[]
[null,"(C) Other expenses",0]
[]
[null,"Total",{"$f":"SUM(C7:C29)","v":0}]
[]
[null,"* Please leave the cell blank in case any of the above items have not been debited to profit and loss as no adjustment would be made in that case."]
[]
[]
[null,"© www.excelfinder.com"]

{"sheet":"6. Provision for diminution","index":7,"n_rows":75,"n_cols":4,"rows_kept":75,"cut":false,"hidden":true,"merged":[[2,1,3,2],[21,1,22,1],[31,1,32,2],[24,1,25,1]]}
[null,"© www.excelfinder.com",">> Back to Computation sheet"]
[]
[null,"(IV) the amount or amounts set aside as provision for diminution in the value of any asset."]
[]
[]
[null,"Particulars*","Amount"]
[]
[null,"Any provision for diminution in value of any asset",0]
[]
[null,"Add: Following expenses may not be allowed as deduction while computing the MAT (add it back here if they are not yet added back in above figure):"]
[null,"(A) Provision for bad-debts (not debited to debtors account)",0,">> Case laws"]
[]
[null,"(B) Provision for diminution in value of investment",0,">> Case laws"]
[]
[null,"(C) Provision for impairment in value of fixed assets",0]
[]
[null,"(D) Any provision taken directly in balance sheet",0,">> Case laws"]
[]
[null,"(E) Other provisions",0]
[]
[null,"Less: Following expenses may be allowed as deduction while computing the book profit (reduce it here if they are not yet reduced from above figure):"]
[null,"(A) Actual bad-debts (if credited to debtors account and debited to P/L account)",0,">> Case laws"]
[]
[]
[null,"(B) Reversal of provision created in earlier years for diminution in value of assets (if added back in earlier years to book profit)",0]
[]
[]
[null,"(C) Others",0]
[]
[null,"Total",{"$f":"SUM(C7:C29)","v":0}]
[]
[null,"* Please leave the cell blank in case any of the above items have not been debited to profit and loss as no adjustment would be made in that case."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"© www.excelfinder.com"]

{"sheet":"7. Withdrawal from reserve","index":8,"n_rows":79,"n_cols":3,"rows_kept":79,"cut":false,"hidden":true,"merged":[[2,1,3,2],[12,1,13,1],[26,1,27,1],[28,1,29,1],[35,1,36,2]]}
[null,"© www.excelfinder.com",">> Back to Computation sheet"]
[]
[null,"(V) the amount withdrawn from any reserve or provision if any such amount is credited to the profit and loss account."]
[]
[]
[null,"Particulars*","Amount"]
[]
[null,"Amount withdrawn from reserves or provisions",0]
[null,"[It shall be reduced from book profits, if two conditions are satisfied:"]
[null,"a) the amount withdrawn has been credited to P/L account"]
[null,"b) book profit has been increased by such amount in year of creation]"]
[]
[null,"Less: Following withdrawals from reserves or reversals of provisions may be allowed as reduction while computing the book profit (reduce it here if they are not yet reduced from above figure):"]
[]
[null,"(A) Reversal of provision for income-tax",0]
[]
[null,"(B) Reversal of provision for bad debts",0]
[]
[null,"(C) Reversal of provision for contingent liability",0]
[]
[null,"(D) Reversal of provision of diminution in value of investment",0]
[]
[null,"(E) Reveral of provision of impairment in value of fixed assets",0]
[]
[null,"(F) Any other withdrawals from reverse or reversal of provision",0]
[]
[null,"Add: Following withdrawals from reserves or reversals of provisions may not be allowed as reduction while computing the book profit (add it back here if they are earlier reduced from above figure):"]
[]
[null,"(A) Recovery of bad-debts (if earlier credited to debtors account and debited to P/L account)",0]
[]
[]
[null,"(B) Others",0]
[]
[null,"Total",{"$f":"SUM(C7:C33)","v":0}]
[]
[null,"* Please leave the cell blank in case any of the above items have not been debited to profit and loss as no adjustment would be made in that case."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"© www.excelfinder.com"]

{"sheet":"8. Exempt Income","index":9,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":true,"merged":[[2,1,3,2],[33,1,34,2],[26,1,27,1]]}
[null,"© www.excelfinder.com",">> Back to Computation sheet"]
[]
[null,"(VI) the income to which sec. 10 [other than Sec. 10(38)] or sec. 11 or sec. 12 apply, if it is credited to the P/L account."]
[]
[]
[null,"Particulars*","Amount"]
[]
[null,"(1) Income exempt under Sec. 10",0]
[]
[null,"(2) Income exempt under Sec. 11 and Sec. 12",0]
[]
[null,"Add: Following income may be allowed as reduction while computing the MAT (add it back here if they are not yet added back in above figure):"]
[]
[null,"(A) Agriculture income",0,">> Case laws"]
[]
[null,"(B) Capital gain on sale of rural agriculture land",0,">> Case laws"]
[]
[null,"(C) Any other income",0]
[]
[null,"Less: Following income may not be allowed as reduction while computing the MAT (reduce it here if they are not reduced earlier from above figure):"]
[null,"(A) Income which is eligible for Chapter VI-A deduction",0,">> Case laws"]
[]
[null,"(B) Capital gain eligible for Sec. 54EC deductions",0,">> Case laws"]
[]
[null,"(C) Capital gain exempted under Sec. 47",0,">> Case laws"]
[]
[null,"(D) Long term capital gain arising from transfer of equity shares or unit through stock exchange and STT paid on it. [see Sec. 10(38)]",0]
[]
[]
[null,"(F) Any other income",0]
[]
[null,"Total",{"$f":"SUM(C7:C31)","v":0}]
[]
[null,"* Please leave the cell blank in case any of the above items have not been debited to profit and loss as no adjustment would be made in that case."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"© www.excelfinder.com"]

{"sheet":"9. Depreciation v. Loss","index":10,"n_rows":57,"n_cols":60,"rows_kept":57,"cut":false,"hidden":true,"merged":[[52,1,53,6],[10,48,10,49],[10,53,10,54],[10,58,10,59],[6,1,8,6],[10,2,10,3],[42,1,43,6],[44,1,45,6],[46,1,47,6],[48,1,49,6],[50,1,51,6]]}
[null,"© www.excelfinder.com",null,">> Back to Computation sheet"]
[]
[]
[null,">> Amount to be adjusted under this clause:",null,{"$f":"-IF(OR(H29>=0,G29>=0)=TRUE,0,MAX(H29,G29))","v":0}]
[]
[null,"(VII) the amount of loss brought forward or unabsorbed depreciation, whichever is less as per books of account."]
[null,"Explanation:\na) the loss shall not include depreciation;\nb) the provisions of this clause shall not apply if the amount of loss brought forward or unabsorbed depreciation is nil."]
[]
[]
[]
[null,null,"Enter amount as per books of accounts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consolidated",null,null,null,null,"After 1st adjustment",null,null,null,null,"After 2nd adjustment"]
[null,"Financial Year","Individual year's profit or (loss)\n[before depreciation]","Individual year's unabsorbed depreciation","Book profits for MAT [before adjustment under this clause]","Benefits claimed","Consolidated brought  forward loss\n[before depreciation]","Consolidated unabsorbed depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After depreciation","Profit","LWD","Dep","Loss","Dep","Lower of two","Adjustment","What","Loss","Dep","Lower of two","Adjustment","What","Loss","Dep"]
[]
[null,"Consolidated amount for the period prior to 2000",0,0,0,{"$f":"BE14","v":0},{"$f":"BG14","v":0},{"$f":"BH14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C14+D14","v":0},{"$f":"IF(AS14>0,AS14,0)","v":0},{"$f":"IF(AS14<0,IF(AS14<D14,C14,0),0)","v":0},{"$f":"IF(AS14>0,0,IF(AS14>D14,AS14,D14))","v":0},{"$f":"SUM($AU$14:AU14)","v":0},{"$f":"SUM($AV$14:AV14)","v":0},{"$f":"IF(AND(AW14=0,AX14=0)=TRUE,0,MAX(AW14,AX14))","v":0},{"$f":"IF(AT14>=0,IF(AT14>-AY14,AY14,-AT14),0)","v":0},{"$f":"IF(AZ14<0,IF(AY14=AW14,$BB$12,$BC$12),0)","v":0},{"$f":"IF(BA14=$BB$12,(AW14-AZ14),AW14)","v":0},{"$f":"IF(BA14=$BC$12,(AX14-AZ14),AX14)","v":0},{"$f":"IF(AND(BB14=0,BC14=0)=TRUE,0,MAX(BB14,BC14))","v":0},{"$f":"IF(E14>=0,IF(E14>-BD14,BD14,-E14),0)","v":0},{"$f":"IF(BE14<0,IF(BD14=BB14,$BB$12,$BC$12),0)","v":0},{"$f":"IF(BF14=$BB$12,(BB14-BE14),BB14)","v":0},{"$f":"IF(BF14=$BC$12,(BC14-BE14),BC14)","v":0}]
[null,"2000-03-31",0,0,0,{"$f":"BE15","v":0},{"$f":"BG15","v":0},{"$f":"BH15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C15+D15","v":0},{"$f":"IF(AS15>0,AS15,0)","v":0},{"$f":"IF(AS15<0,IF(AS15<D15,C15,0),0)","v":0},{"$f":"IF(AS15>0,0,IF(AS15>D15,AS15,D15))","v":0},{"$f":"SUM($AU$14:AU15)-SUMIF($BA$14:BA14,$BB$12,$AZ$14:AZ14)-SUMIF($BF$14:BF14,$BG$12,$BE$14:BE14)","v":0},{"$f":"SUM($AV$14:AV15)-SUMIF($BA$14:BA14,$BC$12,$AZ$14:AZ14)-SUMIF($BF$14:BF14,$BH$12,$BE$14:BE14)","v":0},{"$f":"IF(AND(AW15=0,AX15=0)=TRUE,0,MAX(AW15,AX15))","v":0},{"$f":"IF(AT15>=0,IF(AT15>-AY15,AY15,-AT15),0)","v":0},{"$f":"IF(AZ15<0,IF(AY15=AW15,$BB$12,$BC$12),0)","v":0},{"$f":"IF(BA15=$BB$12,(AW15-AZ15),AW15)","v":0},{"$f":"IF(BA15=$BC$12,(AX15-AZ15),AX15)","v":0},{"$f":"IF(AND(BB15=0,BC15=0)=TRUE,0,MAX(BB15,BC15))","v":0},{"$f":"IF(E15>=0,IF(E15>-BD15,BD15,-E15),0)","v":0},{"$f":"IF(BE15<0,IF(BD15=BB15,$BB$12,$BC$12),0)","v":0},{"$f":"IF(BF15=$BB$12,(BB15-BE15),BB15)","v":0},{"$f":"IF(BF15=$BC$12,(BC15-BE15),BC15)","v":0}]
[null,"2001-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AS16>0,AS16,0)","v":0},0,0,{"$f":"SUM($AU$14:AU16)-SUMIF($BA$14:BA15,$BB$12,$AZ$14:AZ15)-SUMIF($BF$14:BF15,$BG$12,$BE$14:BE15)","v":0},{"$f":"SUM($AV$14:AV16)-SUMIF($BA$14:BA15,$BC$12,$AZ$14:AZ15)-SUMIF($BF$14:BF15,$BH$12,$BE$14:BE15)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2002-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU17)-SUMIF($BA$14:BA16,$BB$12,$AZ$14:AZ16)-SUMIF($BF$14:BF16,$BG$12,$BE$14:BE16)","v":0},{"$f":"SUM($AV$14:AV17)-SUMIF($BA$14:BA16,$BC$12,$AZ$14:AZ16)-SUMIF($BF$14:BF16,$BH$12,$BE$14:BE16)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2003-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU18)-SUMIF($BA$14:BA17,$BB$12,$AZ$14:AZ17)-SUMIF($BF$14:BF17,$BG$12,$BE$14:BE17)","v":0},{"$f":"SUM($AV$14:AV18)-SUMIF($BA$14:BA17,$BC$12,$AZ$14:AZ17)-SUMIF($BF$14:BF17,$BH$12,$BE$14:BE17)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2004-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU19)-SUMIF($BA$14:BA18,$BB$12,$AZ$14:AZ18)-SUMIF($BF$14:BF18,$BG$12,$BE$14:BE18)","v":0},{"$f":"SUM($AV$14:AV19)-SUMIF($BA$14:BA18,$BC$12,$AZ$14:AZ18)-SUMIF($BF$14:BF18,$BH$12,$BE$14:BE18)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2005-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU20)-SUMIF($BA$14:BA19,$BB$12,$AZ$14:AZ19)-SUMIF($BF$14:BF19,$BG$12,$BE$14:BE19)","v":0},{"$f":"SUM($AV$14:AV20)-SUMIF($BA$14:BA19,$BC$12,$AZ$14:AZ19)-SUMIF($BF$14:BF19,$BH$12,$BE$14:BE19)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2006-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU21)-SUMIF($BA$14:BA20,$BB$12,$AZ$14:AZ20)-SUMIF($BF$14:BF20,$BG$12,$BE$14:BE20)","v":0},{"$f":"SUM($AV$14:AV21)-SUMIF($BA$14:BA20,$BC$12,$AZ$14:AZ20)-SUMIF($BF$14:BF20,$BH$12,$BE$14:BE20)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2007-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU22)-SUMIF($BA$14:BA21,$BB$12,$AZ$14:AZ21)-SUMIF($BF$14:BF21,$BG$12,$BE$14:BE21)","v":0},{"$f":"SUM($AV$14:AV22)-SUMIF($BA$14:BA21,$BC$12,$AZ$14:AZ21)-SUMIF($BF$14:BF21,$BH$12,$BE$14:BE21)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2008-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU23)-SUMIF($BA$14:BA22,$BB$12,$AZ$14:AZ22)-SUMIF($BF$14:BF22,$BG$12,$BE$14:BE22)","v":0},{"$f":"SUM($AV$14:AV23)-SUMIF($BA$14:BA22,$BC$12,$AZ$14:AZ22)-SUMIF($BF$14:BF22,$BH$12,$BE$14:BE22)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2009-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU24)-SUMIF($BA$14:BA23,$BB$12,$AZ$14:AZ23)-SUMIF($BF$14:BF23,$BG$12,$BE$14:BE23)","v":0},{"$f":"SUM($AV$14:AV24)-SUMIF($BA$14:BA23,$BC$12,$AZ$14:AZ23)-SUMIF($BF$14:BF23,$BH$12,$BE$14:BE23)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2010-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU25)-SUMIF($BA$14:BA24,$BB$12,$AZ$14:AZ24)-SUMIF($BF$14:BF24,$BG$12,$BE$14:BE24)","v":0},{"$f":"SUM($AV$14:AV25)-SUMIF($BA$14:BA24,$BC$12,$AZ$14:AZ24)-SUMIF($BF$14:BF24,$BH$12,$BE$14:BE24)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2011-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU26)-SUMIF($BA$14:BA25,$BB$12,$AZ$14:AZ25)-SUMIF($BF$14:BF25,$BG$12,$BE$14:BE25)","v":0},{"$f":"SUM($AV$14:AV26)-SUMIF($BA$14:BA25,$BC$12,$AZ$14:AZ25)-SUMIF($BF$14:BF25,$BH$12,$BE$14:BE25)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2012-03-31",0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AU$14:AU27)-SUMIF($BA$14:BA26,$BB$12,$AZ$14:AZ26)-SUMIF($BF$14:BF26,$BG$12,$BE$14:BE26)","v":0},{"$f":"SUM($AV$14:AV27)-SUMIF($BA$14:BA26,$BC$12,$AZ$14:AZ26)-SUMIF($BF$14:BF26,$BH$12,$BE$14:BE26)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,{"$f":"G27","v":0},{"$f":"H27","v":0}]
[]
[null,"Notes:"]
[null,"(1) The algorithms and set of instructions, as used in above computations, have been developed on basis following guidances available so far on this topic:"]
[null,"a) Explanation 1(iii) to Section 115JB of Income-tax Act, 1961"]
[null,"b) Section 205 of Companies Act"]
[null,"c) Circular 495 dated 22-09-1987"]
[null,"d) Amline Textiles (P.) Ltd. v. ITO [2009] 27 SOT 152 (Mum.)"]
[null,"e) CIT v. Sumi Motherson Innovative Engg. Ltd. [2010] 195 Taxman 353 (Delhi)"]
[null,"f) Rashtriya Ispat Nigam Ltd., In re [2006] 155 Taxman 60 (AAR)"]
[null,"g) Fascel Ltd. v. ITO [2008] 117 TTJ 891 (Ahd.)"]
[null,"h) Kirloskar Ferrous Industries Ltd. v. ACIT (IT Appeal No. 1044/PN/10)"]
[]
[null,"(2) Some points to remember:"]
[null,"a) The principles of set-off as prescribed in Section 70-79 shall not be applied to the accumulated losses as shown in the books of accounts [Susi Sea Foods (P.) Ltd. v. ACIT [2011] 15 taxmann.com 232 (Vish.)]"]
[]
[null,"b) One consolidated figure of brought forward losses and unabsorbed depreciation to be compared in totality and not on year to year basis [Amline Textiles (P.) Ltd. v. ITO [2009] 27 SOT 152]"]
[]
[null,"c) The lower of two (losses or depreciation) available for set off under this clause shall be reduced by the benefit, if any, claimed in earlier years under this clause. "]
[]
[null,"d) Lower of two to be considered notwithstanding the treatment given to them under any provision of the Income-tax Act [Fascel Ltd. v. ITO [2008] 117 TTJ 891 (Ahd.)]"]
[]
[null,"e) Nothing shall be adjusted under this clause if brought forward losses are nullified against general reserve or brought forward profits and nothing is left in brought forward losses"]
[]
[null,"f) Deduction under this clause can't be denied to a private company even if the provisions of Section 79 of Income-tax Act, 1961 are triggered i.e. due to change in shareholding by more than 51% [Fascel Ltd. v. ITO [2008] 117 TTJ 891 (Ahd.)]"]
[]
[]
[]
[null,"© www.excelfinder.com"]

{"sheet":"10. MAT Credit","index":11,"n_rows":30,"n_cols":57,"rows_kept":30,"cut":false,"hidden":true,"merged":[[23,1,24,4]]}
[null,"© www.excelfinder.com",null,">> Back to Computation sheet"]
[]
[]
[null,">> MAT Credit to be availed during the year",null,{"$f":"IF('MAT Computation'!C59<'MAT Computation'!C57,0,IF('10. MAT Credit'!E21<('MAT Computation'!C59-'MAT Computation'!C57),'10. MAT Credit'!E21,('MAT Computation'!C59-'MAT Computation'!C57)))","v":0}]
[]
[null,"(VIII) MAT Credit."]
[]
[null,"Financial Year","Tax as per normal provisions","Tax as per provisions of MAT","Available credit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After depreciation","Profit","LWD","Dep","Loss","Dep","Lower of two","Adjustment","What","Loss","Dep","Lower of two","Adjustment","What","Loss","Dep"]
[]
[null,"2011-12",0,0,{"$f":"IF((D10-C10)>0,(D10-C10),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C10+D10","v":0},{"$f":"IF(AP10>0,AP10,0)","v":0},{"$f":"IF(AP10<0,IF(AP10<D10,C10,0),0)","v":0},{"$f":"IF(AP10>0,0,IF(AP10>D10,AP10,D10))","v":0},{"$f":"SUM($AR$10:AR10)-SUMIF(#REF!,$AY$8,#REF!)-SUMIF(#REF!,$BD$8,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM($AS$10:AS10)-SUMIF(#REF!,$AZ$8,#REF!)-SUMIF(#REF!,$BE$8,#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(AND(AT10=0,AU10=0)=TRUE,0,MAX(AT10,AU10))","v":{"$error":"#REF!"}},{"$f":"IF(AQ10>=0,IF(AQ10>-AV10,AV10,-AQ10),0)","v":{"$error":"#REF!"}},{"$f":"IF(AW10<0,IF(AV10=AT10,$AY$8,$AZ$8),0)","v":{"$error":"#REF!"}},{"$f":"IF(AX10=$AY$8,(AT10-AW10),AT10)","v":{"$error":"#REF!"}},{"$f":"IF(AX10=$AZ$8,(AU10-AW10),AU10)","v":{"$error":"#REF!"}},{"$f":"IF(AND(AY10=0,AZ10=0)=TRUE,0,MAX(AY10,AZ10))","v":{"$error":"#REF!"}},{"$f":"IF(E10>=0,IF(E10>-BA10,BA10,-E10),0)","v":{"$error":"#REF!"}},{"$f":"IF(BB10<0,IF(BA10=AY10,$AY$8,$AZ$8),0)","v":{"$error":"#REF!"}},{"$f":"IF(BC10=$AY$8,(AY10-BB10),AY10)","v":{"$error":"#REF!"}},{"$f":"IF(BC10=$AZ$8,(AZ10-BB10),AZ10)","v":{"$error":"#REF!"}}]
[null,"2010-11",0,0,{"$f":"IF((D11-C11)>0,(D11-C11),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AP11>0,AP11,0)","v":0},0,0,{"$f":"SUM($AR$10:AR11)-SUMIF($AX$10:AX10,$AY$8,$AW$10:AW10)-SUMIF($BC$10:BC10,$BD$8,$BB$10:BB10)","v":0},{"$f":"SUM($AS$10:AS11)-SUMIF($AX$10:AX10,$AZ$8,$AW$10:AW10)-SUMIF($BC$10:BC10,$BE$8,$BB$10:BB10)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2009-10",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AR$10:AR12)-SUMIF($AX$10:AX11,$AY$8,$AW$10:AW11)-SUMIF($BC$10:BC11,$BD$8,$BB$10:BB11)","v":0},{"$f":"SUM($AS$10:AS12)-SUMIF($AX$10:AX11,$AZ$8,$AW$10:AW11)-SUMIF($BC$10:BC11,$BE$8,$BB$10:BB11)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2008-09",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AR$10:AR13)-SUMIF($AX$10:AX12,$AY$8,$AW$10:AW12)-SUMIF($BC$10:BC12,$BD$8,$BB$10:BB12)","v":0},{"$f":"SUM($AS$10:AS13)-SUMIF($AX$10:AX12,$AZ$8,$AW$10:AW12)-SUMIF($BC$10:BC12,$BE$8,$BB$10:BB12)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2007-08",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AR$10:AR14)-SUMIF($AX$10:AX13,$AY$8,$AW$10:AW13)-SUMIF($BC$10:BC13,$BD$8,$BB$10:BB13)","v":0},{"$f":"SUM($AS$10:AS14)-SUMIF($AX$10:AX13,$AZ$8,$AW$10:AW13)-SUMIF($BC$10:BC13,$BE$8,$BB$10:BB13)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2006-07",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AR$10:AR15)-SUMIF($AX$10:AX14,$AY$8,$AW$10:AW14)-SUMIF($BC$10:BC14,$BD$8,$BB$10:BB14)","v":0},{"$f":"SUM($AS$10:AS15)-SUMIF($AX$10:AX14,$AZ$8,$AW$10:AW14)-SUMIF($BC$10:BC14,$BE$8,$BB$10:BB14)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2005-06",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AR$10:AR16)-SUMIF($AX$10:AX15,$AY$8,$AW$10:AW15)-SUMIF($BC$10:BC15,$BD$8,$BB$10:BB15)","v":0},{"$f":"SUM($AS$10:AS16)-SUMIF($AX$10:AX15,$AZ$8,$AW$10:AW15)-SUMIF($BC$10:BC15,$BE$8,$BB$10:BB15)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2004-05",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AR$10:AR17)-SUMIF($AX$10:AX16,$AY$8,$AW$10:AW16)-SUMIF($BC$10:BC16,$BD$8,$BB$10:BB16)","v":0},{"$f":"SUM($AS$10:AS17)-SUMIF($AX$10:AX16,$AZ$8,$AW$10:AW16)-SUMIF($BC$10:BC16,$BE$8,$BB$10:BB16)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2003-04",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AR$10:AR18)-SUMIF($AX$10:AX17,$AY$8,$AW$10:AW17)-SUMIF($BC$10:BC17,$BD$8,$BB$10:BB17)","v":0},{"$f":"SUM($AS$10:AS18)-SUMIF($AX$10:AX17,$AZ$8,$AW$10:AW17)-SUMIF($BC$10:BC17,$BE$8,$BB$10:BB17)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"2002-03",0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"SUM($AR$10:AR19)-SUMIF($AX$10:AX18,$AY$8,$AW$10:AW18)-SUMIF($BC$10:BC18,$BD$8,$BB$10:BB18)","v":0},{"$f":"SUM($AS$10:AS19)-SUMIF($AX$10:AX18,$AZ$8,$AW$10:AW18)-SUMIF($BC$10:BC18,$BE$8,$BB$10:BB18)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,{"$f":"SUM(C10:C20)","v":0},{"$f":"SUM(D10:D20)","v":0},{"$f":"SUM(E10:E20)","v":0}]
[]
[null,"Notes:"]
[null,"1) MAT Credit can be availed in that year in which tax payable as per normal provision exceeds tax payable as per provisions of MAT"]
[]
[null,"2) MAT credit to be availed during the year shall be as following:"]
[null,"a) Tax payable as per normal provisions"]
[null,"b) Less: Tax payable as per provisions of MAT"]
[]
[null,"© www.excelfinder.com"]