Does anyone know how to convert book tax to cash tax using the financial statements? Would it be as follows:
Cash Tax = Book Tax + Inc in DTL - Inc in DTA
e.g. if you paid 500mm in book tax on your income statement, and your DTL increases by, say, 10mm from last year and your DTA increases by, say, 20mm, your Cash Tax would be equal to: 500 + 10 - 20 = 490
How To Calculate Cash Taxes
User @amufb1 offered the best response to this query:
If you wanted to get more in depth you would also take into effect the excess tax benefit of equity compensation, usually related to stock options, and the impact of the current taxes.
So taking your example again if we had;
(500) - Total Tax Provision Per Income Statement (20) - Deferred Tax Asset Increase 10 - Deferred Tax Liability Decrease 25 - Current Tax Provision - ( This Includes both current and long term accrued taxes on income) 15 - Excess tax benefit from stock-based compensation ( found under a company's financing activities in a statement of CF)
So to convert from book tax to cash - you would sum all of the follow to go from $500mm in book tax to $470mm cash tax. Kind of top-level let me know if you want more elaborate detail but figured this should be enough to convert from book to cash taxes.
Read More About Useful Calculations On WSO
- What Counts As "Debt" In An Enterprise Value Calculation?
- Calculation Of Goodwill In Acquisition?
- Why Subtract Cash When We Calculate Enterprise Value
Want to improve your financial modeling skills?
Check out WSO's side-by-side comparison of financial modeling courses and get a WSO discount.