Deferred Tax Modeling
Hey this is probably a simple question but how can I model the deferred tax changes going from SLN to DDB? Thanks.
Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
9 Free Financial Modeling Lessons
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.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
Right now it is linked to sales in the WC schedule.
Why would it change? If you apply a multiple to the WC schedule, the dollar amount may change but not the percentage
Well going from SLN to DDB would increase the CFO in the first few years, correct? Due to the tax savings. Basically I want to know what I need to do to make CFO constant under both methods.
given the dividend payout rate is 0%
You add back the depreciation expense in the CFO. Sure your NI is going to be lower with DDB, but it doesnt matter because you are going to add back a greater portion of that in the cash flow statement.
As far as your taxes payables, you will be paying less taxes with DDB, but it doesnt matter as far as modeling goes because they will converge anyway. Here's another way to think about it -
EBITDA (same under both) DA (higher for DDB) EBIT (higher for SLN)(no effect on CFO) I (same for both) T (higher for SLN, use of cash) NI (higher for SLN)
Then on the CF statement,
NI (higher on SLN) add back D (lower than DBB) Taxes payable (bigger outflow than DBB - intially)
Point is, the non-cash nature of the depreciation has very minimal effects on the CFO, and is pretty irrelevant in modeling
Placeat adipisci consequatur consequuntur non rem. Laudantium id dolorem consequatur repellendus voluptatibus sapiente eligendi. Id consequatur minus vitae est. Doloribus et fugit quidem sit aut vitae. Magnam et accusantium adipisci iste veniam error aspernatur. Qui expedita et natus cupiditate.
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...