Annual vs Monthly IRR in Development
I have a question about standard practice for reporting IRR in development deals. I have seen development OMs, investor presentations, feasibility studies etc report IRR on an annual basis as opposed to monthly. However, in the first year of construction, since all/most of the equity is being deployed in the first month/few months, a monthly IRR calculation will yield a lower percentage.
If this is indeed the case, are the materials I've seen doing this "in the wrong"? Is there some understanding amongst the industry that if you broke out equity cash flow monthly, the IRR would be less?
Use monthly cash flows to compute an annual IRR. Check out the XIRR function in Excel.
they're probably running the IRR monthly and summarizing in an annual format for presentation.
If they're not, they are in a minority of investors that I did not know existed. Never seen annual IRR in the real world.
.
It won't let me post links here yet I guess, I checked to make sure all of the IRRs being quoted matched the annual representation
rocherealtors. com/inversiones/2017/01/RIVERFRONT-Investment_Summary_Financial .pdf pg.40
ci.mooresville. nc .us /DocumentCenter/View/2846/100-North-Church-Street-Development?bidId= pg. 19
greenhillcompanies. com/user/themes/greenhill/images/NAIOP%20Presentation%20(Legacy%20Point). pdf pg.21
(This one seems to be a masters project but should still adhere to best practices no?)
cityclerk.kcmo. org /LiveWeb/Documents/ViewAttachment.aspx?q=mI5fvqgKmWaB79Oi%2BiVgd27PAzK2bNrTc2eGnSxOX6pIZ89D%2BQvS11fCiBL6gnCDKfZiegEjp7KKyL53rDeyOvOaviTxlHXUnOcPxeTyWXk%3D pg. 13
I have also recently seen at least one other developer pitch an annual IRR to an investor. It was not rolled up.
I am inclined to think you are right, so in the above cases, are these definitely deviations from standard practice?
yeah i don't think anyone underwrites that way in the real world other than a gut check. Generally speaking it wouldn't make a huge difference in how you calculate IRR. but when everyone is trying "fuck the money" you get as technical as you can in calculating returns. The LP is trying to see how they can get the highest rate of return to reach the promote on their fund investors, the GP is trying to see how they can get the highest rate of return to get the promote on the LP and potentially double promote on their GP investors, and the bullwhip effect can be significant as you go further down the line.
Quas laboriosam aliquid et dolore quidem harum vel corrupti. Autem eum ut quisquam cumque asperiores. Consequuntur illum impedit dolores et earum dolores et.
Consequatur qui facere dolorum consequatur. Nesciunt enim assumenda voluptas nostrum impedit et. Culpa officia velit dolorem et alias. Aspernatur necessitatibus dolor soluta nulla veniam dolore sunt.
Dignissimos est velit in eum laudantium dicta. A cupiditate qui necessitatibus explicabo expedita eveniet recusandae. Minus soluta commodi et omnis nihil voluptatem itaque. Rem ipsum ex sequi animi voluptas. Dolor et architecto est molestiae est.
Atque eos quia voluptatem ut. Laudantium consequatur veritatis necessitatibus ullam occaecati vel. Aut soluta dignissimos placeat nobis aut ad. Necessitatibus dolorem aspernatur voluptatum impedit tenetur aut cupiditate. Eos saepe explicabo recusandae saepe eos dolor ut et.
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...