, , ,

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

Single Tenant Net Lease Valuation Model – 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,…
, , ,

Advanced Mortgage Amortization Module (Updated May 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),…
, , ,

What are Custom GPTs? Plus a few examples we’ve built. (Updated May 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…
, ,

How to Hire Your Next Commercial Real Estate Attorney

Choosing the right commercial real estate attorney is crucial for the success of any real estate transaction. The right attorney can help you navigate the complexities of real estate law, ensure compliance, and protect your interests. Attorneys…
, , ,

Using Geometric Mean (or CAGR) as an Alternative to IRR (Updated May 2024)

The internal rate of return (IRR) and compound annual growth rate (CAGR) are both metrics used to analyze investment returns. They're both commonly used in commercial real estate financial modeling, but what's the difference? When should you…
, ,

All About Careers in Real Estate Development (Updated May 2024)

Professionals in real estate development jobs, either working for themselves or their employer, create new places for people to live, work, shop, and play. This person typically is involved with the transaction from land sourcing through lease-up…
, , , , , , , , ,

Single Tenant NNN Lease Valuation Model (Updated May 2024)

I originally built this single tenant net lease (NNN) valuation Excel model back in 2016. Based on some feedback from a few of our readers, I've since made quite a few updates (see v2.0 updates video below). This model is an attempt to re-think…
, , , ,

Case Study #3 – Just the Facts – Retail Sale-Leaseback – Case Only (Updated May 2024)

This is the third 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. Just the Facts puts you in the role of a direct real estate investor…
, , ,

All About Careers in Real Estate Acquisitions (Updated May 2024)

In acquisitions jobs, professionals typically source, analyze, conduct due diligence on, and negotiate the purchase of new equity investments for their real estate investment firms. It's important to note that acquisitions professionals generally…
, , , ,

Entry-Level Position in Real Estate: Breaking Through the No Experience Barrier

Recruiting for an entry-level position in real estate can be daunting, particularly for those entering this highly competitive field where experience is often prized above all. How does one 'break through' when traditional pathways seem blocked…
, , , ,

Case Study #2 – Renovo Tower Office Acquisition (Case + Solution, Updated May 2024)

This is the second 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. The Renovo Tower Office Acquisition Case Study puts you in the…
, , ,

Utilizando el Rendimiento de Efectivo Sobre Efectivo en el Análisis de una Inversión Inmobiliaria

A la hora de abordar nuestros proyectos inmobiliarios, hay un sinfín de métricas que podemos tener en consideración, todas ellas, en última instancia, dependerán tanto del tipo de proyecto que queremos llevar a cabo, así como del mercado…
, , ,

Case Study #11 – Residential Development Business Model: Build And Sell (Case + Solution)

This residential development case study explores the strategic planning and execution of Pinkstone Group's latest project, Serene Homes, amidst the backdrop of the COVID-19 pandemic. As remote working becomes the norm and the demand for quality…
, , , , ,

Real Estate Debt Module in Excel (Updated May 2024)

I thought I'd share the real estate debt module I originally built for the ARGUS alternative in Excel. Most debt modules I've seen in real estate financial models only include the ability to model fully amortizing senior debt. Mike challenged…
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…