, , ,

Real Estate Financial Modeling Accelerator (Updated May 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…
, , , , , ,

Advanced Mortgage Amortization Schedule – Custom GPT by A.CRE

At A.CRE, we've built dozens of custom GPTs for internal and external purposes. Some of the GPTs have general application, while others are custom GPTs specifically for commercial real estate. One such CRE-specific GPT that we recently built…
, ,

What are Custom GPTs? Plus a few examples we’ve built. (Updated Apr 2024)

In the fast-moving world of generative AI (gen AI), staying up-to-date on the latest advancements in AI is crucial for professionals in every field, but especially in commercial real estate. At A.CRE, we're committed to sharing what we view…
, , , , ,

The Definitive Guide to Microsoft Excel for Real Estate (Updated Apr 2024)

Microsoft Excel is the primary tool used by real estate financial modeling professionals. Even while numerous non-Excel alternatives have attempted to de-throne Excel, the 35+ year-old software has shown to be surprisingly resilient to competition.…
, , , , , ,

Optimizando Espacios: Modelo de Cálculo Para la Ocupación Física de Inmuebles

Comprender y optimizar la ocupación física y económica de tus inmuebles es crucial para maximizar el retorno de inversión y mejorar la gestión de propiedades. El desarrollo de un modelo efectivo para el cálculo de la ocupación no solo…
, , ,

The Advanced Mortgage Amortization Module (Updated Apr 2024)

In recent months, I've been working on an advanced real estate investment amortization table with interest-only capability, fixed and variable interest rates, multiple interest calculation methods (i.e. 30/360, Actual/Actual, Actual/365, Actual/360),…
,

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,…
, , ,

Modelo de Desarrollo de Apartamento en Excel (Actualizado Abril 2024)

Antes y después de ser economista, siempre me he visto involucrado en distintos proyectos personales que me han servido para crecer profesionalmente, este camino me ha llevado desde el alquiler de locales comerciales minoristas y de oficinas…
, ,

Insights from Spencer’s Cornell Real Estate Distinguished Speaker Series Interview

Recently, our own Spencer Burton was invited to participate in the Cornell Real Estate Distinguished Speaker Series, a platform renowned for hosting leading voices in the real estate industry. During this prestigious event, Spencer had the opportunity…
, , , , ,

Real Estate Case Studies Creator Assistant – Custom GPT by A.CRE

If you've spent any time following us here at A.CRE you know that AI applications in real estate financial modeling is a topic we are fascinated (and excited) about! As a consequence, we're underway with several initiatives to explore AI in…
, , , , ,

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.…
, , , ,

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…
, , , , , ,

Multifamily Development Model (Updated April 2024)

Not to be confused with Spencer's masterpiece, The A.CRE Apartment Development Model, I decided to build a second option on our website for multifamily development with a different feel. For us true modeling nerds out there, we know that financial…
, , ,

Cómo Utilizar el Rendimiento de la Deuda y el Índice de Cobertura del Servicio de la Deuda Para Calcular el Importe de un Préstamo

En nuestro glosario de términos inmobiliarios comerciales, encontraremos 2 conceptos bastante interesantes, que a su vez son métricas y vías para evaluar la factibilidad de un proyecto inmobiliario en última instancia. Por su parte, la…
, ,

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…
, , ,

Como Analizar Inversiones Inmobiliarias de Valor Agregado Mediante el Rendimiento Sobre el Costo

El rendimiento sobre costo en los bienes raíces comerciales es un indicador financiero crítico que mide la rentabilidad de una inversión inmobiliaria comparando los ingresos operativos netos que genera una propiedad con el costo total de…