Hi,
I built a LBO model with 3-4 key variables that can influence return, and after I built the sensitivities around them, each of them show very limited variation. It's not the type of obvious error where they don't change at all (they do change), but varying a growth rate from -2% to 4% for example produce IRR that are very close to each other (think** 2% irr** for -2% input CAGR, 8% irr for 4% input CAGR)
I'm worried that there might be an error in my model but I don't know whats the best way to check it....any recommendations please?
Thanks!
Keeping all else equal, a 6% differential in growth rate should give you close to 6% variance in IRR so that does not sound wrong. The best check is to be familiar with how each lever (ebitda growth, leverage, multiple expansion) affects returns so you can look at the math quickly and tell if something is off.
Thank you so much, and really appreciate the insights!
When you say "The best check is to be familiar with how each lever (ebitda growth, leverage, multiple expansion) affects returns so you can look at the math quickly and tell if something is off." - how can I get familiar with these things please? I hope this is not a stupid question - do I keep building different models? but each model will see different sensitivities right? Thanks!
He is telling you to avoid "garbage in, garbage out" in a nice way. Meaning, if you understand what different EBITDA growth, leverage, and multiples expansion assumptions mean for the fundamental profile of free cash flow and enterprise value then you should be able to quickly tell if your return tables look accurate or not.
deleted
thank you all!
Aut nisi eligendi esse. In qui omnis debitis delectus. Dolore autem corporis dolores beatae sint quasi necessitatibus commodi.
Vel ut dignissimos sint quo explicabo. Consequatur aut dolor dicta corrupti in illo.
Saepe laborum dignissimos ut numquam ad eos. Qui fugiat corporis eius asperiores. Et iure est architecto atque aut vero. Temporibus nam amet consequatur sapiente exercitationem. Quae velit consequatur et.
Voluptatibus quod commodi pariatur. Magni voluptate sed aut expedita quod est fugit. Veniam sit quis at voluptatum ex illum cumque. Ut minima amet rerum libero nisi tempore. Perferendis quia facilis doloremque sit.
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...