Entries by

, , ,

Commercial Mortgage Loan Analysis Model (Updated Nov 2020)

Over the years, I’ve received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans. Specifically, people have asked for a tool to calculate the loan amount (ie. loan sizing) based on a combination of tests – debt service coverage ratio, loan-to-value, and […]

, , ,

Real Estate Financial Modeling Accelerator (Updated Nov 2020)

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. Over the years, we’ve covered hundreds of real estate modeling topics in our blog, published hours of video, and shared 50+ real estate Excel models in our Library. Nonetheless, no matter how […]

, , , , ,

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 basis – is one of the more important metrics to include in your analysis. One issue common to […]

, , ,

Bite-Sized CRE Lessons – A.CRE 30 Second Video Tutorials

As we continue to build out our A.CRE 101 series and our Glossary of Commercial Real Estate terms, we’ve started to supplement these initiatives with short (<30 second) video clips on how to do various CRE calculations and modeling tasks in Excel. You can think of these 30 second tutorials as bite-sized lessons in real […]

, , , ,

A.CRE Apartment Development Model (Updated Nov 2020)

For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it’s more a generalist tool than a specialized one. As a result, I’ve found it wanting when used to model developments. Update: In version […]

, , , , , , , , , , , ,

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Nov 2020)

As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016 I released the first beta-version of the model – my All-in-One (Ai1) […]

, , ,

Use the A.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel

The A.CRE Geocoding Excel Add-in uses the Google Geocoding API to automatically convert a given address to latitude and longitude coordinates, or to convert a given latitude and longitude coordinate to an address. The add-in makes auto-populating latitude and longitude (or address) in Excel easy. It includes various features to help add or change the […]

, , , , ,

A.CRE Value-Add Apartment Acquisition Model (Updated Oct 2020)

We’ve shared a handful of apartment models over the years. Several of those are capable of analyzing apartment acquisitions (e.g. All-in-One, Apartment Valuation Model), but none was built for the express purpose of modeling value-add apartment deals. As a result, each has its limitations in value-add scenarios. So today, I’m excited to share a new […]

, , , , ,

Tutorials for A.CRE Value-Add Apartment Acquisition Model

As promised, I’m following up the release of the A.CRE Value-Add Apartment Acquisition 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 […]

, , ,

Real Estate Equity Waterfall Model with Catch Up and Clawback (Updated Oct 2020)

A question came up recently in the A.CRE Accelerator’s real estate waterfall modeling course regarding how to model GP Catch Up (i.e. Sponsor Catch Up) and LP Clawback provisions. I put together a quick video tutorial in response to that question, and in doing so I realized I had never shared to A.CRE a real […]

, , , , , , , ,

Forecasting After-Tax Cash Flow in Real Estate Analysis

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 […]

, , ,

Real Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated Oct 2020)

Over the years, this real estate equity waterfall with annual periods and IRR or Equity Multiple hurdles has been one of the most popular models in our library of real estate Excel models. It’s been downloaded thousands of times and we’ve received dozens of suggestions for how to improve the model. As a result, we […]

, , , , ,

Residential Land Development Pro Forma (Updated Oct 2020)

As many of you know, I started my career in residential land development first as a broker and later as a principal. During that time I built my fair share of residential land development Excel pro formas, modeling returns and forecasting cash flows for my clients and investor partners. I’ve since transitioned into the institutional side […]

, , ,

Custom Function to Auto-Populate Latitude and Longitude in Excel (Updated 2020)

When analyzing real estate investments in Excel, it’s often necessary to include the latitude and longitude coordinates of the properties we’re modeling. To do this, most of us open up Google Maps, or some other mapping tool, and find the coordinates that way. Others use a latitude/longitude lookup tool such as latlong.net to find what they need. However, these tools require […]