Posts

, , ,

Real Estate Financial Modeling Accelerator (Updated November 2019)

Since starting A.CRE, Michael and I have fielded email after email requesting a more structured real estate financial modeling training program on the site. Important Note: We're updating and adding to the Accelerator every week. Since launch,…
, , ,

Real Estate Equity Waterfall Model - IRR and Equity Multiple Hurdles (Updated 9.14.2019)

Over the years, my real estate equity waterfall with annual periods and the [glossary_exclude]option[/glossary_exclude] of using either IRR or Equity Multiple Hurdles has been one of the most popular models download at Adventures in CRE. I've…
, , ,

The Limitations of IRR When Evaluating Real Estate Investments

The internal rate of return is one of the most commonly used return metrics to value real estate investment opportunities. Simply put, the IRR is the anticipated project determined discount rate an investor is expected to earn over the life…
, , , , ,

Deep Dive: The IRR and XIRR - Fully and Simply Explained (Part 2)

Part 2: The XIRR (Click here for Part 1 where we cover the IRR) This is Part 2 of our A.CRE Deep Dive - 2-part mini-series on the IRR and XIRR return metrics and functions in Excel. As stated in Part 1, these are some of the most commonly…
, , , , ,

Deep Dive: The IRR and XIRR - Fully and Simply Explained

For my next post, I thought I would bring it back to some fundamentals and review the IRR and XIRR return metrics and functions in Excel. These are some of the most commonly used functions and return metrics in commercial real estate and they…
, , , , ,

Using an IRR Matrix to Determine Hold Period

When building a real estate financial pro forma, it's important to model for and include a summary of various return and risk metrics. Among the different return metrics, the internal rate of return (IRR) - both on an unlevered and levered…
Real Estate IRR Partitioning
, , , , , ,

IRR Partitioning in Excel

In this post, I'd like to show you how to partition the internal rate of return of your real estate investment in Excel. I also throw in a quick equity multiple partition, to highlight how the time value of money affects your returns. I've recorded…
, , , ,

Could You Be Exiting Too Early? Don’t Forget to Analyze Your Reinvestment Rate

When attempting to maximize the value of your money invested in real estate, the timing of your exit is key to maximize your return. As an example, let’s take a look at the base case from my Multifamily Model posted earlier for 123 Fake…