XIRR vs (1+IRR)^12-1
Any thoughts/preferences on using the XIRR function vs Effective Rate IRR when modeling development projects?
Both account more time value - is one more accurate than another?
Any thoughts/preferences on using the XIRR function vs Effective Rate IRR when modeling development projects?
Both account more time value - is one more accurate than another?
+81 | LP coming into deal at higher land basis. How to model returns to GP? | 18 | 2h | |
+73 | Increasing RE Industry's Cash Compensation, Collectively | 43 | 4h | |
+72 | Major Decisions | 13 | 23h | |
+28 | Niche down to an operator or stay an allocator | 9 | 2d | |
+24 | Breaking into CRE late 20s | 7 | 3d | |
+22 | Thoughts on joining an early-stage REPE fund | 7 | 1h | |
+22 | Self Storage ECRI | 9 | 2d | |
+20 | Doom Loop or Creative Urban Reemergence? | 3 | 5d | |
+18 | Henderson Park London | 21 | 3h | |
+18 | How to get good at RE Modelling? | 15 | 10m |
Career Resources
Never heard of Effective Rate IRR (nor can I find a definition for it).
Presuming you mean the formula in your header, it looks clunky and is not commonly used in my experience. In the absence of a reason not too, just use XIRR.
Given the question, I think it would be worthwhile to invest some time into better understanding the mathematics behind and the functional purpose of calculating an IRR.
The more explicit answer to your question is, it depends on your cash flows. If you have a monthly model, (1+IRR())^12-1 is the more accurate function. Likewise, if you have a quarterly model, (1+IRR())^4-1 is the more accurate function.
XIRR is the most accurate when you have known dates, which generally isn't until the investment is substantially realized. Final returns are always ran on an XIRR basis, but underwriting and asset management returns are ran on a "Effective Rate IRR" basis.
At the end of the day, there's a minimal difference between the functions. But someone that always uses XIRR illustrates they don't fully understand the math and/or point of measuring an IRR.
Hey - Can you provide a simple explanation of the logic of that formula: (1+IRR())^12-1
What do you do 1 + IRR, to the power of 12, then subtract 1?
Thanks!
XIRR vs Effective Rate IRR (Originally Posted: 01/26/2018)
Any thoughts/preferences on using the XIRR function vs Effective Rate IRR when modeling development projects?
Both account more time value - is one more accurate than another?
If you XIRR for monthly, your returns are higher cause the money comes in sooner. But this can give you a false sense of huge upside. Lets say you got an IRR of 9, with a target return of 11 and an XIRR of 13, would you pull the trigger on the acquisition?
XIRR is good to look at, but it tends to inflate peoples perception of how good the deal is.
I have never encountered this. XIRR should return ~ same value as (1+IRR(values))^12-1 or however you are compounding. Should be within like 5 bps or less. XIRR can be finicky since the data series must start with a negative value, which in some cases doesn't happen (construction loan origination comes to mind where you receive a fee upfront but the loan doesn't start funding until borrower's equity is fully committed).
XIRR is the most accurate. If your proforma has time intervals that are spaced EXACTLY the same distance apart (monthly, annual, etc) then IRR with compounding is fine otherwise use XIRR.
Just had a partner send us a model where they were calculating returns using a nominal irr calc instead of an effective basis. Honestly didn’t even know there was a difference before then
Quia nihil perferendis non autem natus numquam placeat. Labore aut ut inventore aliquam et libero. Quam unde dolorum officiis consequatur aut eos in.
Vitae enim amet aliquam. Voluptas consequuntur vitae nisi amet. Commodi reprehenderit amet autem sit. Et rerum quae rerum reprehenderit fugit voluptas quia labore.
Doloremque animi magni aut ut quia occaecati. Dignissimos qui perspiciatis placeat aperiam. Aliquid iusto quasi magni architecto architecto consequatur aut. Tenetur qui ut enim saepe id.
Aliquid reprehenderit quod enim porro eveniet. Enim pariatur excepturi molestias vitae vero omnis. Illum possimus necessitatibus iure molestiae ipsa excepturi ut sed. Adipisci sunt voluptatem aut.
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...