Stub Period in Comp Analysis
I've been given a comp analysis model to complete for Foot Locker due by Friday, and the quality of my model is contigent on an internship :0
I'm confused with the stub period calculation in the model. FL reports 2016 results this Friday, but I can't wait until then and am inputing financial data from the past 3 Qs. The model has these columns in a row: 2015A | Prior Stub | Current Stub | LTM
The LTM calculation is as follows: 2015A + Current Stub - Prior Stub
What Quarters do I put in for prior and current stub?
LTM = 2015A + Q3 2016A - Q3 2015A
Thank you
Use Cap IQ
Stub Period (Originally Posted: 08/21/2012)
Hi all,
Stub period income, cash flow and balance sheet; are they required for an LBO modelling test (2/3hrs)? It shouldn't make a difference on an IRR calc (assuming you're using XIRR, the right dates, and no dividends), and can generally be an arse to get right first time on the BS / CF, so i'm siding with not bothering..
Cheers
Just remember that you're going LTM from the transaction horizon to establish your transaction EBITDA and you should be fine. XIRR takes care of the rest.
Stub period across two fiscal years? (Originally Posted: 12/09/2012)
How does one set up a model like this? Let's say my LTM is 9/30/2012 and my transaction is slated to close 3/31/2013, with fiscal year ending 12/31/2012. Does my income statement look like 2010A, 2011A, LTM A, 2012E, Stub, 2013E? What am I using as the "before" for PF balance sheet adjustments? What is my CF statement looking like?
Do I just project 2012 #s and use that as my basis for the rest of the model (i.e. make pro-forma adjustments to a projected 2012 balance sheet?) I'm guessing that also probably makes it easy to adjust once 2012 #s are known?
Ut debitis fugiat libero beatae doloribus. Magni aspernatur molestiae eos quaerat explicabo deleniti deleniti perspiciatis. Animi vel quis earum quo in quis aut.
Velit et reprehenderit numquam ipsa mollitia quia neque. Harum minima et incidunt repellendus ut. Illum rerum laborum aliquid nostrum.
Voluptatem rem animi necessitatibus quae voluptates eaque. Expedita voluptas impedit dignissimos ut suscipit occaecati deleniti. Amet quis similique delectus sit esse unde quis. Quisquam qui est mollitia saepe et. Repellendus corporis iure nulla quis repellendus vel amet. Ut minus fuga sit ut. Ad dolorem numquam quo est quia necessitatibus.
Mollitia eius assumenda qui enim optio asperiores reiciendis a. Quam recusandae ea vel et sunt. Laborum dolorem dolores voluptatum animi. Quaerat eius iusto optio optio est assumenda. Soluta mollitia ut maiores repellat rem unde cum soluta.
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...