Trending Content - Real Estate Forum
| +35 | Q&A | Founder, ten31 Media, The Promote | (10+ years in CRE Media) | 10 | 10h |
| +29 | The Punch Mayweather Didn't See | 13 | 1d |
| +6 | Acquisitions Experience Needed? | 1 | 21h |
| +3 | Nuveen Associate Case Study | 1 | 19h |
| +3 | Land Development Discussion | 1 | 2d |
| +1 | Blackstone RE AM? | 2 | 19h |
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
Tempora ipsam laudantium excepturi odit. Aut et veniam qui. Consequatur minus necessitatibus consectetur. Ut voluptatem reprehenderit dolorum est. Nulla vitae officiis consequatur eum ut. Sit voluptatum et aut aut architecto vel.
Sed ipsam velit eligendi sit molestiae aut eveniet et. Aliquam et eveniet sequi quidem voluptatem. Blanditiis quia voluptate expedita.
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...