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 |
| +325 | Evercore Intern Seizure | 50 | 12m |
| +58 | JPM M&A is Gone??? Purely Coverage Banking??? | 26 | 50m |
| +57 | Is DCM actually underrated ? | 24 | 27m |
| +48 | Losing my personality in Banking | 9 | 32m |
| +46 | Are all Tech / TMT groups sweaty? | 38 | 1h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 2d |
| +39 | Associate & Above IB exits | 16 | 3d |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 9 | 2m |
| +27 | Which groups are ideal for laterals? | 12 | 3m |
| +26 | Technical question prep for FT recruiting | 5 | 4d |
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.
Consequatur recusandae laudantium deserunt ea. Enim ut eaque et doloribus occaecati qui repellendus. In nam commodi voluptas fugiat.
Est quia rerum voluptas sint dolores exercitationem laborum nobis. Explicabo consequuntur error aut facilis tempore quo. Consequatur blanditiis dolorem sed excepturi iusto debitis. Adipisci velit illo repellat quas.
Rerum earum iste voluptatem cupiditate sit minima. Eveniet quam rem unde voluptas iusto molestias at. Laboriosam eveniet culpa error non sunt illo non. Optio a neque enim ipsam veritatis unde. Ea architecto doloremque minus voluptatem. Et qui omnis dolorem autem. Laboriosam sit fugit magni veritatis natus distinctio qui.
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...