Hi everyone,
I was curious to know what are the line items encountered in a "Tax Schedule" in a financial model? How is it constructed?
Also, is it common to have this "Tax Schedule" tab in a financial model or not? Relevant for all circumstances???
Thanks for your help.
| +132 | Return Rates For Interns Are Falling? | 44 | 3h |
| +128 | UBS Americas IB: The Kids’ Table of Wall Street | 15 | 3d |
| +73 | London IB BB is a challenge | 40 | 2h |
| +70 | I am a drunk MD AMA | 33 | 3h |
| +61 | VP Lifestyle at Top BB Coverage Groups | 39 | 39m |
| +46 | SharePoint makes IB hours HELL | 15 | 1d |
| +46 | An Outsider’s View of RX Banking Out of College | 6 | 1d |
| +41 | momentum of Rx groups | 15 | 3h |
| +39 | Fired during interview | 8 | 7h |
| +28 | Most Technical Groups Ranked | 17 | 5h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
I work in M&A group and the purpose of the tax schedule is just to see the corp taxes after a merger/acquisition/divestiture. Many aspects of the new company change, including taxes.
In an lbo model you see it side by side with the GAAP tax calculation... Mainly used for the creation of deferred taxes and the carryover of net operating losses... we like to see the "cash taxes" not the hypothetical gaap effectve tax rate
But what are the items in a tax schedule???
MezzCat: what do you mean by "we like to see the "cash taxes" not the hypothetical gaap effectve tax rate", I didn't catch this one...
Thanks!
a company has two books... the GAAP taxes and the taxes paid to the IRS... The assets are depreciated at different rates for each, faster on the for the actual cash taxes paid to the IRS and straight line for GAAP purposes... This innately creates a deferred tax account...
for LBO's, we want to know what this actual cash tax rate is as you want to squeeze as much debt as possible before breaching covenants, and if you aggressively depreciate taxes for IRS purposes (cash taxes), you are able to squeeze more cash out of the company to meet debt obligations.... You GAAP taxes on the other hand maybe alot higher and give you the wrong impression about what you should actually be sending to the IRS in the mail..
deferred taxes, NOLs, cash/irs txes, exemptions, etc..
Tenetur sequi perferendis fugiat dignissimos non suscipit. Amet doloremque quae officia numquam. Repudiandae velit asperiores molestiae et. Reprehenderit ut doloremque nam dicta.
Totam impedit sit eaque quia. Error hic earum ut dolorem aut. Quibusdam ut esse ducimus nam asperiores quod.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...