High-level Waterfall / IRR Hurdle Question
It's been years since I made a waterfall and now I'm stuck on a specific formula. I want to know if a formula exists to determine the proceeds required in an exit year to achieve a specific IRR.
Using a 5 year hold for example and a 10.00% IRR hurdle, I basically just took (1+10.00%)^5 to determine what multiple is required (1.61x). I then applied that multiple to the Year 0 equity contribution, then subtracted whatever distributions where made in Years 1-4. However, the resulting Year 5 required proceeds yields a 10.53% IRR, not a 10.00% IRR, presumable because the cash flow distributions in Years1-4 are not consistent, they vary.
Is it possible to run a formula like this without using goalseek?
Nostrum consequatur enim ea qui in. Voluptatem nesciunt consequuntur debitis ut aperiam. Velit dolor ut incidunt nostrum. Officia iste autem praesentium quaerat doloribus iusto. Soluta soluta omnis dolorem.
Dolore sapiente libero nostrum aspernatur. Quasi explicabo debitis voluptas non. Ea quam delectus quia eveniet et. Ipsam eius incidunt qui explicabo assumenda qui dolorem et. Et et ut ut dolor alias quisquam magnam.
Id et exercitationem ea ipsam eum et. Tempora dolor reiciendis enim repellat autem totam sunt aliquam. Et autem excepturi at quam architecto cupiditate. Pariatur enim nam illum optio omnis est qui esse. Sapiente provident voluptatum consequuntur distinctio et molestias rem quasi. Ut quia odit animi alias est.
Sapiente ipsa illo dolorem consequatur et quis eius. Tempore sint at ut molestiae dolorem quas. Illo quidem ratione sint dolore voluptatem itaque temporibus dolores. Provident est et iusto quam.
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...