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 have the exact same tax treatment. So comparing the projected returns of two properties on an […]
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 concluded that a video would be the easiest way to walk you through […]
I thought I’d share the real estate debt module I built for the ARGUS alternative in Excel that I’ve been working on over the last few months. Most debt modules I’ve seen in real estate financial models only include the ability to model fully amortizing senior debt. Mike challenged me some time ago to come […]
When downloading and opening an Excel model from A.CRE, some users may get the ominous message: “Microsoft has blocked macros from running because the source of this file is untrusted.” If you’ve received this message, you’re probably asking, “Why did this message appear, and can I use the file without macros?” In this tutorial, I’ll […]
As many of you know, I’m in the midst of moving my family from Milwaukee to Dallas, and quite frankly I’m getting sick of eating out and sleeping in hotel rooms. So what better way to unwind from hours of whining kids and tiresome travel, than to build a quick real estate Excel model for calculating the monthly physical […]
We’ve spent a lot of time here discussing and sharing different real estate models, and we’ve received a ton of feedback from our readers as a result. In some of that feedback we’ve received, several people have asked what period and date rows I prefer to use and how I setup a brand new model. […]
In commercial real estate, there are a few generally accepted methods for appraising (or valuing) real property. The three most common are the Cost Approach, the Sales Comparison Method, and the Income Approach. The Income Approach includes two methods, the simpler of the two is the Direct Capitalization method, which this post will cover. The […]
Over the past few years, I’ve been working to build an ARGUS DCF alternative in Excel – or otherwise known here as the A.CRE All-in-One (Ai1) Model. As I’ve worked on that model, I’ve been jotting down modeling techniques I use and think would be helpful to share with our readers. Today I’d like to show […]
Recently, we had an A.CRE reader ask us about the mechanics of Preferred Return distributions in our equity waterfall models with IRR hurdles. Specifically, he questioned the timing of when and how Preferred Return vs Return of Capital were distributed. In this blog post, I’ll share the response I gave him in order to help […]
Recently, we had an Accelerator member ask a question about how to accurately determine a credit rating and spec income discount rate for a private tenant in a single tenant net lease deal. While the scenario specifically involved a medical office tenant (a doctor’s practice), the application could easily be applied to a number of […]
As promised, I’m following up the release of the A.CRE Apartment Development model with a series of walk-throughs and tutorials to help you better understand the various elements of the model. The tutorials start with the basics – a guide to getting started, and then get progressively more advanced. If you’ve already visited the model’s […]
In 2018, Michael and I designed and built the A.CRE Accelerator program. We sought to build the preeminent tool for learning and mastering real estate financial modeling. It was intended to provide a clear path to real estate financial modeling mastery, and ultimately give Accelerator Graduates a significant advantage in the industry. Now as we […]
What better way to spend some free time over the Thanksgiving holiday, than to record myself completing a real estate private equity technical interview exercise! While I’ve offered help with the real estate technical interview in the past, I’ve never just grabbed an actual technical interview case study and walked our readers through how I […]
This is the 9th real estate case study in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice mastering real estate financial modeling. In this case study, you play the role of a job candidate interviewing for a Capital Markets Associate role at a […]
One of the reasons Michael and I blog, is to force ourselves to be continually learning. I built the first version of my real estate waterfall model, because I wanted to better understand the mechanics of modeling an equity waterfall with IRR hurdles. Michael started his Understanding Leases Series, because there were nuances of modeling […]