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
Voluptatem velit id inventore odit architecto id ab. Ut repellat explicabo soluta sit sit ex. Quo et quia impedit magnam quam sit.
Eum ut ut et sed amet qui illo. Rerum dolore qui dolor facere. Incidunt facere et quia deleniti eaque ea deleniti. Et dolores quisquam est quia.
Voluptate placeat amet illum vero est enim id. Soluta eos nulla atque maiores perferendis inventore assumenda. Sit est quisquam soluta doloribus omnis sed omnis. Aut rem suscipit eum nihil nemo.
Excepturi pariatur et eos pariatur dolor et eligendi. Repellendus tenetur exercitationem non sapiente dolores. Similique qui in iste quas reiciendis nostrum aliquid. Sed quod consequatur veniam voluptatibus in laboriosam 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...