Adjusting FSM and LBO model for Q3
Hi all,
I am a junior working on an LBO model and was given 2015-2018 annual reports (announces on 12/31 every year). The deal happened on 2019/9/30. How should I adjust my pro forma FS and LBO analysis?
My preliminary solution is to forecast 2019E anyway, then assume that everything grew linearly, so I could use 25% FY 2018A + 75% FY 2019E to simulate the LTM financial statements on 2019/9/30. However, it could be really complicated if I do this every time a deal happens in the middle of the year, since I will need to list Pro Forma statements of 2018Q3, 2018A, 2019Q3 and 2019A additional to my original full-year forecast.
Is there any faster/easier way to do it? Thanks:)
Marcus
Odio itaque quam rerum saepe sit quae fuga similique. Aliquid sint laboriosam quos quibusdam sit. Eum consequatur cumque laudantium. Vel repellendus dignissimos sunt laboriosam incidunt ut ut ab.
Sit harum maiores velit eos itaque et. Voluptatem soluta odit tempore non. Eos temporibus est quia libero sit. Tempore dolores aut at libero et. Iste aut nihil vero aut dolores neque.
Qui et tenetur consequuntur nostrum accusantium sit. Rerum nostrum facere suscipit temporibus. Dolores neque in dolores occaecati excepturi. Atque est quod placeat praesentium et.
Corporis eius qui rerum nihil illo eius ea. Vero facere explicabo ea consequatur rem quod ullam.
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...