I am currently helping my VP populate an excel sheet to help him value the assets for an M&A transaction. I am reading through the F/S (hard copies) and putting the data in the correct places on the company's excel template. What is the general "lingo" for this? I want to at least mention this in phone interviews and when networking, but I don't want to sound dumb about it. Is this "scrubbing the data"? I will have the opportunity to do various analysis with the VP once I get all the data in, but for now, how should I go about talking about this?
Also, this is a mid-market company, about how long would you think this task would take? I have the F/S from the past 5 years that must all be inputted by line item.
back-filling historical data for an M&A transaction?
Oh okay, yeah I heard my boss use that term when he was first showing me last week. Is this even worth talking about in a call?
*spreading financial statistics?..
Data entry.
Line on your resume: "Compiled and revised merger model for updated financial metrics, market data, and extraordinary line items"
THIS
Can you describe some of the items that qualified as extraordinary line items? How did you make those determinations?
Where did you source the market data for your model? How did you incorporate that data into the model?
When you say you compiled the model, does this mean you were working from a template? If so, were you able to understand the mechanics of the template? Can you explain to me the treatment of Target Co. Goodwill on the pro-forma balance sheet?
Thanks for this advice!
Good point. I will be sure to not put stuff down that I can't explain easily. Though hopefully, I will learn more and be able to easily talk about it as I get further into the project.
Perfect time to ask your VP a ton of questions. You really are just doing data entry, but if you can understand what you are inputting, why you are doing it, and how the model works, you can put just about anything down on paper and bullshit your way right through the interview.
Material non-public, can't say. Because said material was material non-public, I can't disclose the exact rationale.
Market data was sourced directly from the company. Data was incorporated through said updating of financial metrics/model.
No I compiled it from scratch - I understand the mechanics of the template, but it's proprietary so I can't say. The deal is not public yet, so disclosing goodwill would violate my private investor duties.
There ya go, ez as pie.
Harum non corporis ut in impedit. Sit et sit eius. Minus veniam sit atque ab. Sint quisquam qui iste sed. Aliquid blanditiis amet veritatis quidem accusamus nesciunt et. Error provident omnis numquam quaerat eaque assumenda.
Minima ea sit dolor et consequuntur quia eveniet. Nihil nihil aut et sint hic odit non. Praesentium nemo aut quia natus molestiae sint ipsum modi. Eos dolorum veritatis rerum architecto quia. Earum cupiditate voluptatem et sequi repellat eos rem dolorem.
Qui laborum aut quia illum. Fugiat nihil quia voluptatem et voluptatibus expedita et. At cum nulla in a. Velit corporis atque impedit commodi repudiandae. Voluptas labore corporis impedit voluptas.
Blanditiis tempora eaque repudiandae dolor eveniet aut. Rerum aut eveniet quae et distinctio. Aliquid mollitia at veritatis sed aut sunt. Qui rerum enim ea excepturi facilis. Amet qui mollitia officiis quasi ut ullam. Alias totam est possimus accusamus dolore quia. Placeat voluptatem beatae quis similique alias est ut.
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...