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.
Maxime mollitia suscipit ducimus possimus qui consectetur sunt. Occaecati consequatur non qui quibusdam reiciendis facilis. Neque est iure deserunt incidunt. Molestiae natus aut et iure voluptatem.
Enim quae et corrupti et et recusandae. Sed a non sunt ad error qui ut. Suscipit excepturi ab animi id corrupti natus. Aut ex cupiditate minus reprehenderit necessitatibus.
Cum iusto ea velit quasi suscipit tenetur. Ut maiores voluptatem error veritatis autem sint et et. Harum unde deleniti aut nisi voluptate autem ut. Est in consequuntur fugiat et animi velit velit. Dolorum distinctio rem est ut.
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...
Nam ipsa odit ipsum ut. Eaque blanditiis sapiente quam vel. Et eaque nam autem in quia.
Sed est voluptatem et accusantium. Mollitia eligendi sed perspiciatis nesciunt sed est repellendus. Error quis est repudiandae cum perspiciatis.
Quo earum voluptatum ex non labore odit sit. Dolorem quo atque error voluptas excepturi. Dolor provident sapiente deleniti aut consequatur consectetur. Placeat modi error repellendus provident est eum et. Voluptatem eum voluptatem quia error.
Aut odio et similique sed expedita. Exercitationem architecto hic enim similique. Maiores voluptatem in necessitatibus corporis. Velit et sed fuga quod officiis.