Does anyone know what goes in the FYE Transaction column and the Closing Column on the combined P&L?
There is a picture of the spreadsheet attached.
Thanks
| Attachment | Size |
|---|---|
| Untitled.jpg 209.97 KB | 209.97 KB |
| +333 | Return Rates For Interns Are Falling? | 141 | 3m |
| +148 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 5h |
| +139 | Evercore > Goldman and I don’t think it’s particularly close anymore | 55 | 2h |
| +123 | I am a drunk MD AMA | 40 | 1d |
| +86 | UBS Offer Day | 30 | 21h |
| +69 | Santander IB? | 10 | 3d |
| +68 | I hate Wells Fargo | 19 | 7h |
| +51 | No return offer - feeling like a failure is an understatement | 20 | 2h |
| +43 | WF Return offers | 28 | 2d |
| +41 | How cooked am I as an incoming WF IB SA 2027? | 13 | 7h |
Career Resources
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.
Where did you get that model? It looks terrible.
I'm guessing they are LTM based on the expected transaction announcement date and then transaction closing date.
It's an early draft and only a small part of the model but would the closing be the last year before the merger? So in this case 2012?
my guess is that closing is meant to be the acquirers LTM at that point in time and combined is meant to be pro forma LTM at that point in time (i.e. sum of acquirer LTM and the acquired company LTM).
but as peinvestor said, it's a pretty shitty way to show/model the transaction.
My professor provided us with the template I'm just trying to figure out what goes in those two columns lol This sheet is part of the combined P&L and if FYE transaction is the acquirers LTM at that point wouldn't that be the same as FYE 2012 numbers?
That is really confusing. I don't exactly understand what you are trying to show.
Prior to the transaction date, there is no pro forma P&L to model. So, you start the pro forma P&L at the transaction date. If the transaction date doesn't fall on the acquiror's fiscal year end, then you calendarize the numbers to show a full year of P&L as of the transaction date, then show each projected fiscal year end as usual. Just keep in mind that this will affect how you amortize things like deferred financing fees and project incremental D&A.
Yea that's why I was confused on why he has the transaction column and the pro forma year 1 column. Any idea on closing?
Fair enough, if that is what you were provided and told to work with, you'll have to make do.
Again, it was just an educated guess that those columns were for LTM @ transaction announcement and LTM close. LTM means if the transaction occurs in a specific month, you need to compute the LTM using a combination of the monthly or quarterly income statements (whichever you have access to).
I would assume 3 months following the transaction announcement would be the closing date, but it could go up to 6 months, and list out that assumption.
Ea quia voluptatum necessitatibus odit. Esse voluptatem aut velit magni et sapiente qui autem.
Ut ea delectus debitis vel voluptatem. Enim officiis dolor non fugiat iusto et voluptas. Eius ratione illo repudiandae dolorem quia velit. Occaecati nulla perferendis corrupti non impedit. Quia rerum eos dicta rerum.
Sit quo totam exercitationem natus. Sed rerum sunt sit sit facere error architecto. Est molestiae adipisci et repellendus cumque.
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...