Posts

, , , , , , , , ,

After Tax Analysis in Real Estate (Now Included in Ai1)

When modeling real estate investments, industry practice is generally to stop at before tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily…
, , , , , , , , ,

Create A Dynamic Revenue Row to Calculate Multiple Tenant Leases

I recently received an email from one of our readers asking how to create a dynamic revenue row for a pro forma that can capture rent changes for multiple tenants. I thought that this would make a great post for the site and would be a good…
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…
, , , ,

Scenario Analysis using the Equity Waterfall Model

I received a question this morning asking how to use scenario (or sensitivity) analysis with our Real Estate Equity Waterfall Model. I started to answer the question via email, decided to build an Excel file to go along with my answer, and ultimately…
, , , ,

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…