LBO Test Stub Year NWC
Hi!
For LBO modelling: if there is only a stub year BS given (e.g. 30-Jun-2021), and closing date is 30-Jun-2021 - how would one project the NWC for the closing BS 2021 (31-Dec-2021)?
- Would you simply set NWC components equal to stub year BS, thereby having Change NWC = 0? (which does not make sense to me for calculating cash flow for debt paydown in the stub etc)?
- Would you calculate NWC for the closing BS 31-Dec based on DSO, DIO etc. of stub BS?
Thank you!!
PUSH
Option B but if you did option A I don’t think people would hold it against you too hard on a timed test
Thank you.
To further clarify: You would calculate stub BS data (of 30-Jun21), based on the sales / COGS of this period (lower than full year) or based on LTM figures?
And Change in WC would then be change between WC on stub BS (dated 31-Dec-21) and stub year BS given (30-Jun-21)?
Assuming you have a 12/31/2020 balance sheet, take NWC drivers (DSO, DIO, etc) as of 12/31/2020 and apply them to 12/31/2021 sales, COGS, etc. to get NWC at 12/31/21. This is a better option than applying 6/30/21 drivers as they can be impacted by seasonality.
Then calc the change in NWC from 6/30/21 to 12/31/21 since you now have NWC balances for each period.
Above is ideal, but only if you have that info. Otherwise, option B is fine I would think (yes, to your clarifying comment). Depending on the test, can add a comment in your write up or in the excel that says you need to diligence seasonality as this may impact stub FCF
Well, to be fair, any discrete point in time, including 12/31 can be impacted by seasonality...
Eius officia dolorem sapiente. Occaecati sit enim distinctio esse. Ut ipsum quidem iste. Sequi vel vero repudiandae id. Magni et quo neque tenetur repellat in quod. Consequatur ad sint enim occaecati.
Earum tenetur rerum minima dolor natus consequatur. Nesciunt modi necessitatibus non ratione eos. Dolore aut enim omnis ut dignissimos. Consequatur dignissimos sed in maiores expedita.
Voluptates velit quibusdam delectus est error pariatur. Inventore voluptatibus qui minus facere voluptates assumenda sed excepturi.
Sint veritatis vero adipisci ut. Ea in et molestiae vel suscipit. Nobis qui velit et et corporis. Officia possimus voluptas nobis.
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...