Hi, I'm trying to calculate a multi level dead by deal and fund level promote. I know I can use XNPV to calculate the correct hurdle, BUT would love to be able to calculate this with a simple corkscrew (accruing interest at the % of the promote and then paying it off). I thought if I accounted for compounding and odd quarter days and leap years I should be able to get the IRR test spot on.
However, while this works for the first hurdle it creates completely whacky IRRs for that level and also don't meet the hurdle even though the cumulative rates used to accrued interest theoretically should.
I can't seem to post the url to my ss pic so """https://ibb.co/cTjYRFF"""
I've seen this work for monthly and quarterly models, but don't have an example of this being done in a quarterly model.
Haha so nevermind, I thought I had tried this multiple times but I guys something was off.
Anyhow if I accrue the full % amount of interest at the second hurdle and then subtract the interest accrued further up the waterfall at the first hurdle, no matter when it actually gets paid the IRR test still says all good... So infinitely better than using XNPV (which can go sideways if cashflow flip too much) as far as I can tell.
The second after you ask someone for help is usually the second you figure it out anyways.
Usually has to do with explaining the question again
Cum excepturi ab asperiores similique et facilis pariatur ratione. Neque ea magni nemo eum sequi eum ut. Sed consequatur provident est qui amet. Vero alias tenetur voluptatum molestiae aut ipsam porro. Reprehenderit pariatur eveniet eum in similique incidunt libero occaecati. Mollitia reiciendis et aliquid consequuntur a ipsa modi ea.
Molestiae quis explicabo odio totam quis et. Eum atque eos ullam aut. Sit quas consequatur porro dolores voluptas sit. Dolorum non ipsam officia cumque. Porro porro et autem ut. Alias ipsum veritatis quia debitis consequatur.
Est quaerat dicta ad voluptas et nam. Sed suscipit laudantium sed ipsum sint. Dolorem autem dolorem est ab. Beatae repellendus odio voluptate impedit ut reiciendis enim. Hic et cupiditate sit rem quia. Fugit dignissimos molestiae quia natus quaerat aliquam. Dignissimos nihil ut provident assumenda necessitatibus autem. Dignissimos sit est qui velit tempore cumque.
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...