Has anyone seen DTLs on an actual modelling test for a pe interview. I've seen them on a few practice models but it just seems like its not really something you see too much on the job and was wondering if its something that actually shows up on these tests. I think the creation of the DTL is pretty straightforward when it comes to write ups, but more so tracking the amortization and cash/book taxes
Trending Content
| +68 | Ex Apollo Associate Q&A (But I Actually Answer) | 112 | 3m | |
| +50 | Q&A - Anything about PE / MBA / Life | 61 | 2s | |
| +45 | How to Model SaaS Projections for Interviews | 49 | 1d | |
| +36 | [Technical doubt]: Cash sweep and mandatory amortization | 9 | 12h | |
| +23 | European Megafunds (based on PEI 2023) | 17 | 2d | |
| +22 | Is internal reporting at most funds really so Excel & PPT heavy still? | 8 | 6h | |
| +22 | Partners Group Long Term | 8 | 1d | |
| +18 | Advent NYC Culture/WLB - 2024 update | 9 | 2s | |
| +18 | How is your life in PE? | 12 | 27m | |
| +17 | Moving from PE Fund accounting to top 3 rating agency | 5 | 3d |
Career Resources
Yep have seen it on modeling tests under purchase price accounting. assume some % of net identifiables/tangible assets as write-ups, then document the associated DTL.
Use book-to-cash reconciliation schedule to amortize DTL over the period.
not too bad. it's just a 3-line book-to cash schedule + another line entry in CFO and BS. takes 3 minutes to implement.
Could you please elborate how to build this 3 line book to cash schedule
1) pull EBT line from income statement
2) add-back D&A that was not tax deductible (basically the annual amount from write-ups in stock purchase)
3) sum the above two lines and then apply the effective tax rate to get the cash tax
4) find difference between cash tax and income statement (book) tax. usually cash tax > book tax since you have the DTL. this will be a negative amount.
5) go to CFO and make a line for use of cash. Write amount as "Less: Unwind of DTL" and then sum through to yield a negative effect to your CFO.
6) go to balance sheet, under liabilities -> DTL: write next year's DTL = this year's DTL + Unwind of DTL, which will make DTL decrease year over year.
Balance sheet will balance because on liabilities side the DTL has gone down and on assets side the cash number has gone down.
LMK if this is unclear
Thank you guys this has been very helpful
How does this affect your EV to Equity bridge in an LBO? I would assume you don't include in entry bridge (or as a source/use) and then include in exit bridge if any DTA/DTL remains at end of investment period?
And what is your balancing item on the BS? Cash or RE?
you dont include in entry bridge. I do not include in exit bridge, can assume that the DTL /DTA remains on BS....
Dont get your second question
Ratione quos quam enim accusantium. Voluptas perspiciatis fugiat corrupti saepe eligendi quidem. Facere enim aut et tempora quidem. Aliquid soluta autem ut enim ipsam.
Deleniti deleniti voluptatibus ipsa voluptate et. Praesentium dignissimos eius sequi minus dolorum eum.
Consequatur perferendis hic suscipit repellendus. Officiis necessitatibus magni voluptas eaque quis. Rerum quaerat reprehenderit suscipit similique. Officiis eveniet aut vel et aut.
Ullam dolor non quo natus et non. Qui vitae neque voluptates nostrum. Quis aliquid laborum debitis veritatis dolorem tempore non. Rem corporis tempora earum dicta voluptas dolorem qui sit.
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...