Nuevo Contenido en Español (Actualizado Abril 2024)
Ver y leer nuevo contenido en español. Este contenido ha sido creado por el equipo A.CRE para profesionales en la inversion inmobiliaria. Tutoriales, modelos financieros, educación, y mucho más.
Entries by Spencer Burton
The Conditional Weighted Average – SUMPRODUCT with SUMIF (Updated Apr 2024)
Consider this scenario: you have a 50 tenant rent roll, consisting of various tenant types (i.e. small inline, large inline, junior anchor, anchor, etc.), and you want to calculate the weighted average rent for each tenant type. If I asked you, what is the fastest and cleanest way to do this in Excel, what would […]
Real Estate Financial Modeling Accelerator (Updated April 2024)
Prior to launching the Accelerator program, Michael and I 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 60+ real estate Excel models in our Library. Nonetheless, no […]
Land Development Model – Multi-Scenario (Updated Apr 2024)
Over the years, we’ve shared eight development-focused real estate financial models and numerous development-specific tools to the A.CRE Library of Excel Models. Nevertheless, there’s been a hole in the development offerings in our library. The library has been missing a model to analyze general land development scenarios, such as master-planned residential and commercial developer opportunities […]
How to Prepare for the Real Estate Technical Interview (Updated Apr 2024)
So you’ve made it past the HR screening interview. You have the education and experience the company is looking for, but now they want to be sure you possess the real estate financial modeling skills necessary to do the job. They’ve asked you to take part in a multi-hour real estate technical interview. In that interview, they’ll […]
Excel Pro Forma for Flipping Houses (Updated Apr 2024)
Before moving to the principal side of the business, I began my career as a self-described real estate investment specialist, largely working as a land broker but dabbling in other areas including the popular “single-family flip” space. In all honesty, I wasn’t qualified for the title. In fact, I had little to no actual experience […]
A.CRE Build-to-Rent (BTR) Development Model
Build-to-rent (BTR) has become more and more common in CRE and now accounts for a meaningful share of development. In the past, we’ve recommended A.CRE readers use our Apartment Development Model for BTR analysis. However, as we’ve received numerous requests over the few years for a purpose-built BTR model – including an inquiry in a […]
A.CRE Apartment Development Model (Updated Apr 2024)
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. So a few […]
Watch Me Build – Industrial Offering Memorandum Analyzer Custom GPT
In this Watch Me Build session, I’ll walk you through constructing a custom GPT that near-instantly sifts through Industrial Offering Memorandums to pinpoint whether an investment aligns with your criteria. At the heart of this build is a tailored GPT setup that efficiently processes and analyzes complex data sets found in these OMs. Custom GPTs […]
Industrial Real Estate Development Model (Updated Apr 2024)
Allow me to share my Industrial Development Model in Excel. Over the past few years, I’ve been working to add more specialty real estate models to our library. While our All-in-One model certainly has its place, oftentimes really digging into the underwriting of a deal takes a hyper-focused tool. This model has spawned sister Office […]
Retail Real Estate Development Model (Updated Apr 2024)
I’m excited to share my Retail Development Model in Excel. This pro forma analysis tool comes as I’ve continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model is an adaptation of my Office Development Model and Industrial Development Model. It’s specifically built to analyze both […]
Office Real Estate Development Model (Updated Apr 2024)
I’m excited to share my Office Development Model in Excel. This pro forma analysis tool comes as I’ve continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model is an adaptation of my Industrial Development Model. It’s specifically built to analyze both merchant-build and build-to-core, ground-up […]
All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Mar 2024)
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) […]
Real Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated Mar 2024)
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 […]
Supercharge Excel with the ‘Excel 4 CRE’ Add-In (Updated Mar 2024)
Today, we’re thrilled to share with the A.CRE community a new timesaving (and free) Excel tool: the ‘Excel 4 CRE’ Add-in! Over the past year, we at A.CRE (together with our new favorite companion, ChatGPT!) have been developing and sharing this Excel add-in. This add-in seeks to save each one of us time by helping […]