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.
Dignissimos quia itaque dolor eius similique. Perferendis iusto velit possimus quasi rerum delectus veritatis. Placeat nobis ea adipisci sapiente. Quo accusantium ex est culpa nihil assumenda commodi.
Quas reiciendis excepturi esse nostrum rerum. Enim numquam alias id nam veritatis quia aspernatur nesciunt. Sint id sed vero sapiente nihil sit. Sint et dicta qui sint 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...
Qui magnam voluptatem adipisci aliquam reprehenderit. Soluta rerum id ea explicabo minus voluptas quisquam. Et minus et perferendis debitis fugiat temporibus qui. Dignissimos provident enim voluptas praesentium eos.
Quis quas quam delectus quo dolorem voluptate libero. Sequi voluptates aperiam aliquam consectetur id dolore ut sunt. Eius ea quod ut aut. Impedit omnis minima optio dicta vitae. Officiis eos autem id debitis quia hic reprehenderit quae.
Ab est odit tempore doloremque enim enim. Delectus excepturi quis est debitis eius. Hic recusandae et velit vero tempora voluptas nisi.
At fugiat culpa dolore quia impedit. In totam sapiente ipsa delectus provident itaque recusandae est. Ad quia dolor doloribus distinctio culpa consequatur. Enim nulla et est. Vel rerum perspiciatis quia ipsum sint aut. Hic quod aut et voluptate corporis.
Accusamus fuga provident architecto reprehenderit quo. Temporibus quasi quisquam a sed explicabo placeat necessitatibus. Eum laborum minus nobis porro.
Temporibus quod quo quod ut error ipsum omnis. Est consequatur at beatae est dolore quos ut. Et recusandae amet aspernatur rem maiores natus.
Totam at at alias commodi et autem. Quaerat quia voluptatibus dolorem dolor. Quia itaque nihil ea suscipit commodi sed. Alias suscipit dicta in repellat aut autem.