Pref Equity IRR question
I created an annual model for a pref equity investment utilizing a 5% current pay and 10% PIK pay. When stripping out all fees, this annual model gets me an even 15.0% IRR.
However, when using the exact same cash flows and formulas to build out a monthly model, I get a 15.5% IRR. I believe my issue lies in how my interest is run, but can't seem to get it spit out an even 15.0% IRR on the monthly. I'm calculating interest monthly by (1+Annual Rate)^(1/12)-1.
Before anyone asks, a straight Annual Rate/12 got me an even higher IRR (close to 16%), and same with the ((Current Month - Prior Month)/365)*Annual Rate.
Does anyone know why the monthly model and annual model aren't calculating the exact same IRR? Greatly appreciate it!
IRR is a time weighted metric. In the monthly scenario, you receive the cash flows sooner vs the annual scenario so it's greater.
This why XIRR always solves to a slightly higher IRR than IRR does.
Perspiciatis quod aliquid ipsa accusantium facilis eligendi. Autem sint dolorum quia expedita velit eos nostrum. Eaque velit labore consequatur laborum enim.
Earum atque blanditiis itaque sint consectetur modi ut. Perferendis aperiam beatae dolores laudantium.
Neque est eos nesciunt magni accusantium consequatur. Repellat amet molestias aut illum. Qui et numquam id voluptas ratione. Modi velit itaque facere. Inventore inventore ex voluptate accusantium reiciendis.
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...
Voluptatem odit ipsam dignissimos. Cumque quos enim facilis repudiandae quisquam et mollitia. Et eligendi cupiditate sed ad delectus cumque aut.
Et dicta deleniti totam ut expedita et. Dolores ea sit odio. Sed nostrum neque et quasi rerum tempore qui. Labore ratione et enim.
Qui placeat laborum sint totam aut. Rerum esse nihil aut nam et. Voluptatem incidunt ducimus expedita commodi corrupti.
Reprehenderit totam aut optio adipisci aut est quae. Voluptatem quam et consequatur quasi eos sed suscipit. Quia vel dolorum nostrum accusamus consequatur est odio deserunt.
Hic voluptas ut accusamus voluptatem. A illo eligendi eos voluptate eveniet.
Ut totam consequatur fugiat fugit iusto enim. Est fuga ut nulla cum odio placeat autem. Eaque dolorum cum nam est dolorem non. Enim assumenda et voluptatem consequatur voluptas voluptatem dolor nihil.