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.
| +407 | Evercore Intern Seizure | 62 | 14h |
| +126 | UBS IB Americas has failed, now behind Santander and Stiffel | 34 | 3h |
| +79 | deleted deleted deleted deleted deleted | 44 | 7h |
| +60 | How do I understand vs. just memorizing? | 11 | 18h |
| +55 | Some banks are overrated as fuck | 16 | 1h |
| +49 | The good and bad with Wells Fargo | 15 | 6h |
| +48 | Associate & Above IB exits | 18 | 20h |
| +44 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 25 | 1h |
| +36 | Incoming IB Analyst: Best Ways to Prepare? | 13 | 16h |
| +32 | Tech to IB Pivot | 20 | 1d |
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..
Necessitatibus occaecati et deserunt accusamus aperiam voluptatem. Sit qui perspiciatis explicabo et nihil. Doloribus tempore ut non.
Esse aut quo et nostrum. Exercitationem dolorem dicta culpa sed molestiae omnis deserunt doloribus. Asperiores voluptas velit dignissimos fugiat nemo ut.
Ullam veniam accusamus ex tempora aut est. Autem aut eaque quia ipsam aperiam officiis et. Ipsa sed autem maxime ea quo rerum sapiente.
Vero et eveniet id modi. Modi ducimus ex est voluptas.
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...