, , ,

Real Estate Financial Modeling Accelerator (Updated Jan 2025)

Before launching the Accelerator program, Michael and I received countless emails requesting a more structured, step-by-step real estate financial modeling training program. Over the years, we've covered hundreds of real estate modeling…
, , , ,

Loan Payment Schedule and Balance Tracking Tool (Updated Aug 2024)

A childhood friend called me this week and asked for a favor. He is the lender on a private real estate loan and was wanting a way to personally service the loan. Namely, he needed a tool to issue monthly invoices, track the principal vs interest…
, ,

A.CRE Presente en el Gran Salón Inmobiliario — Bogotá 2024

Del 8 al 11 de agosto se llevará a cabo “El Gran Salón Inmobiliario 2024” en la ciudad capital de Bogotá, Colombia.  Pero, ¿qué representa el gran salón inmobiliario? El evento es una especie de feria inmobiliaria que reúne a…
, , , ,

Analyzing Value-Add Investments in Real Estate Using Yield-on-Cost (Updated Aug 2024)

So a question recently came in around why a commercial real estate investor would use the Yield-on-Cost metric to assess a value-add real estate investment. This question came on the heals of several other questions also related to development…
Wordsmithing your Commercial Real Estate Resume
, , , ,

Wordsmithing your Commercial Real Estate Resume (Updated Aug 2024)

Are you questioning what’s on your commercial real estate resume? Don't overlook the tip I discuss below to help land the interview. The goal of your resume is to get an interview. So, if you are sending a bunch of resumes out, but not…
SUMPRODUCT Weighted Average
, ,

Using SUMPRODUCT to Calculate Weighted Average in Real Estate (Updated Aug 2024)

In my experience, using the SUMPRODUCT function in Excel to calculate weighted average is one of the most oft-used Excel techniques in real estate financial modeling. I learned this technique on day one of my first real estate internship and…
Using the Cash-on-Cash Return in Real Estate Investment Analysis
, , ,

Using the Cash-on-Cash Return in Real Estate Investment Analysis (Updated Aug 2024)

I’ve fielded a handful of Cash-on-Cash (CoC) return questions of late. So, I thought it would be worthwhile to write a post on what the Cash-on-Cash return metric tells me about a potential real estate investment. This article is a primer,…
, , , ,

LinkedIn Job Search 101 for CRE Professionals (Updated Aug 2024)

Our goal with this post is to help you use LinkedIn most effectively in your job search. It's the first post in a series of a LinkedIn 101 networking series to help you get the most out of this resource. Because commercial real estate is such…
UNDERWRITING CAPITAL RESERVES
, , , ,

Camino Hacia un NOI Estabilizado – Reservas de Capital en la Suscripción de Propiedades Inmobiliarias (Caso de Estudio)

Lograr un NOI estabilizado en bienes raíces requiere una planificación cuidadosa y una ejecución sólida. La “Reserva de Capital” es un ítem en el camino hacia un NOI estabilizado que puede causar confusión. Te has preguntado si ¿debe…
UNDERWRITING CAPITAL RESERVES
, , ,

The Road To A Stabilized NOI – Underwriting Real Estate Capital Reserves (Case Study – Case Only)

Achieving a stabilized Net Operating Income (NOI) in real estate requires careful planning and sound execution. One element that can cause confusion is when underwriting capital reserves. Should they go above the line (i.e., as an Operating…
adventures in cre real estate modeler creating cash-on-cash return equity waterfall
, , ,

Real Estate Equity Waterfall Model With Cash-on-Cash Return Hurdle (Updated Jul 2024)

Over the years, Michael and I have built and shared numerous real estate equity waterfall models, all multi-tiered and most with internal rate of return (IRR) hurdles. And as our readers have downloaded those models, I've received dozens of…
, ,

Analyzing a Real Estate Investment from the Perspective of an LP

We received a question from an A.CRE reader this week that I thought warranted a thorough response. The question was, and I paraphrase, "I am an LP looking for models to help vet syndication deals. Do you have any models that can be used to…
, , ,

Linear Mortgage Payment Schedule Tool (Updated July 2024)

We recently shared a new modeling test to our library of real estate case studies entitled UK Debt Advisory Firm Modeling Test. In that case study, the test asked the real estate professional to analyze the returns of three different debt options.…
, , ,

Proforma de Alquiler de Vivienda Unifamiliar

Desde mi experiencia como economista y analista financiero en A.CRE, he observado cómo el mercado de alquiler de viviendas particulares ha ganado popularidad, especialmente en América Latina. En este contexto, es esencial contar con herramientas…
, ,

Tips to Nail Your Next Commercial Real Estate Interview (Updated July 2024)

Recently, our team partnered with the Graduate Real Estate Council at Cornell University where we worked with their students in providing mock interviews with Cornell alumni. Our goal in this effort was to help these students at the beginning…
STNL Sales Comp Analysis Tool Thumbnail
, , , , ,

STNL Sales Comp Analysis Tool – 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. And among those custom GPTs specifically for CRE,…