, , ,

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

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

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

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

¿Qué son los GPTs personalizados? Y algunos breves ejemplos que hemos creado

En el mundo de rápida evolución de la inteligencia artificial y nuevos modelos avanzados de lenguaje generativo (IA generativa), mantenerse al día con los avances tecnológicos es crucial para los profesionales de todos los campos, especialmente…
, ,

Terminology Guide for Build-to-Rent Investment

We recently released a Build-to-Rent (BTR) Development model to help students and developers better analyze this emerging investment type in commercial real estate. As we explored this type of analysis, it became clear that terminology is often…
, , , ,

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

Glossary of Commercial Real Estate Terms (Updated Apr 2024)

Glossary of Commercial Real Estate Terms Welcome to the A.CRE Glossary of Commercial Real Estate Terms, a practitioner's guide to the most common terms in CRE. This is an ever-growing list of commercial real estate terms and definitions that…
, , , , , ,

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

Por Qué la Tasa Interna de Retorno (TIR) y la Tasa Interna de Retorno No Periódica (TIR.NO.PER) Dan Resultados Diferentes

La creación de este post se inspiró inicialmente desde una pregunta que recibimos en nuestro foro del Acelerador de modelización financiera inmobiliaria, al mismo tiempo que recibimos preguntas estamos en constate aprendizaje, las dudas que…
, , , ,

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

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…