Transaction close in LBO model
Hey,
If during a LBO case study interview I have 2 hours to build a full 3-statement model (no presentation, only constructing the model) with different scenarios etc - should I try to build in a "date selection"-option for when the transaction closes and integrate stub periods in this model even if the case study does not specify when the transaction closes? This takes a bit more time to integrate into the model so don't want to do any unnecessary things. It's just that it feels sort of unreasonable to assume that the transaction closes 2019-12-31 when it is October 2020 now (although this is not what the interviewer likely wants to test, they want to see that you can construct a model..)
No, building out different transaction closing dates is not necessary at all. I have never seen that tested and no one will care about that in a 2 hour modeling test. Use the most recent financials you are provided as the closing date and go from there (for example, if you are given 3/31 LTM, go from there and project forward)
Thanks. But if you get latest fiscal year and q2 and q1 2020 (FYE in Dec), would you recommend calculating LTM figures or just go with latest annual report even though it is 2019-12-31? It takes 10-15 minutes to put together LTM figures for the P&L and would rather go with annual report..
Calculate LTM.
Two follow-up questions: If I am given the 3/31 2020 LTM but closing and previous fiscal year end is in Dec 31 2020, should I "treat" the 3/31 LTM figures as per Dec 31 2020? Otherwise the projected years would have their fiscal year end in 3/31 and also a stub period would be needed. I assume what you are saying above is to take the latest available LTM figures and use that as the figures per the given closing date?
Second question: If I am not given a specific closing date, should I treat the LTM figures as it is the fiscal year end figures for the company (Dec 31) or project each year from 31/3 and have that as the year end?
Quaerat odit in tenetur ex. Qui pariatur qui aut explicabo dolore et.
Corrupti soluta asperiores ut inventore. Et modi aut ut quam accusantium animi. Quia aspernatur sapiente voluptatibus ratione.
Possimus sit ipsa nesciunt doloribus. Quia exercitationem id aspernatur eum voluptatum odio aut. Et qui corrupti veniam exercitationem cum quas. Eos ut voluptates dolorum ea facilis debitis excepturi.
Non error est aut ut. Quis aut nesciunt porro error et quod eaque odio. Atque et eos consectetur occaecati.
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...