, , ,

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

Watch Me Solve a REPE Technical Interview Modeling Test (Updated May 2024)

What better way to spend some free time over the Thanksgiving holiday, than to record myself completing a real estate private equity technical interview exercise! While I've offered help with the real estate technical interview in the past,…
, ,

A.CRE Jobs of the Week (Updated 5.13.2024)

We regularly post commercial real estate job openings to our A.CRE Job site section of Adventures in CRE. These jobs are largely openings at top commercial real estate companies, although some hiring professionals at smaller CRE firms also post…
iming of Preferred Return vs Return of Capital
, , , ,

Timing of Preferred Return vs Return of Capital in an Equity Waterfall with IRR Hurdles (Updated May 2024)

Recently, we had an A.CRE reader ask us about the mechanics of Preferred Return distributions in our equity waterfall models with IRR hurdles. Specifically, he questioned the timing of when and how Preferred Return vs Return of Capital were…
, , , ,

Creating a Strong Relationship with Brokers

Building a strong relationship with brokers is essential for anyone looking to succeed in the commercial real estate market. These professionals provide a wealth of information that is often not accessible through public records, including market…
, , , ,

Case Study #1 – Presidio (Case + Solution, Updated May 2024)

This is the first in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. Presidio puts you in the role of an acquisitions professional needing…
, , , ,

Modelo De Desarrollo De Centros Comerciales en Excel (Actualizado Mayo 2024)

A medida continuo mi carrera dentro de los bienes raíces comerciales, sigo descubriendo su relación y todo lo que rodea el fascinante mundo de los modelos financieros inmobiliarios, en esta oportunidad me aventure en la elaboración de un…
, , , , , , ,

Deep Dive: Careers in Commercial Real Estate (Updated May 2024)

The real estate industry is enormous. In the United States alone, over 2.9 million jobs are tied to commercial real estate, 17% of GDP comes from the real estate industry, and the aggregate value of U.S. commercial real estate is approximately…
, , , , ,

La Guía Definitiva de Microsoft Excel Para Bienes Inmuebles (Actualizado Mayo 2024)

Microsoft Excel es la principal herramienta utilizada por los profesionales del modelado financiero inmobiliario. Aunque numerosas alternativas que no son Excel han intentado destronarlo, este programa de más de 35 años de antigüedad ha demostrado…
,

Ask Me Anything with A.CRE (Next Host – Chloe Heiligenstein)

Join us for an engaging session with Chloe Heiligenstein, a seasoned Business Development Manager at InLight Real Estate Partners, based in Charleston, SC. Specializing in building relationships with a diverse range of clients including corporate…
, , , , , , , , , , ,

Watch Me Build – Modeling a Rent Schedule in Both Excel and Using AI (Updated May 2024)

In this Watch Me Build video I show you how to build a custom rent schedule module for long-term leases. The foundation of the module is a simple INDEX/MATCH combination that takes a rent schedule and models the rent cash flows across the entire…
, ,

Asistente Creador de Casos de Estudio Inmobiliarios – GPT Personalizado Por A.CRE

Si has pasado algún tiempo siguiéndonos aquí en A.CRE, sabrás que las aplicaciones de inteligencia artificial (IA) en la modelización financiera inmobiliaria es un tema que nos fascina (¡y nos emociona!). En ese sentido, estamos en marcha…
, , , ,

Real Estate Capital Account Tracking Tool (Updated Apr 2024)

I'll be the first to admit that real estate asset management doesn't get the attention it deserves on AdventuresinCRE.com. The real reason for this is that we're not necessarily asset management experts. I spent some time working in asset management…
, , ,

Modelo Financiero Inmobiliario Para el Desarrollo de Oficinas en Excel (Actualizado Abril 2024)

Desde que inicié mi travesía en el mundo financiero de los bienes raíces, he tenido la oportunidad de recrear dos modelos financieros de desarrollo inmobiliario: uno para edificios y otro para centros comerciales. Estas experiencias no solo…
, , ,

Hide and Unhide Tabs using Drop-down Menus in Excel (Updated Apr 2024)

I'd like to share a handy little trick I learned this week for hiding and unhiding tabs in Excel using drop-down menus. Now this method requires you to use some basic VBA code and to save the Workbook as a Macro-Enabled file but don't be intimidated…
, , , ,

Watch Me Build – American-Style Real Estate Equity Waterfall (Updated Apr 2024)

A few years ago, I recorded my screen as I built a 3-tier real estate equity waterfall model. What I didn't mention in that Watch Me Build video, is that the kind of waterfall I built is colloquially called a European-style equity waterfall.…