Entries by Spencer Burton

, , , , ,

Quick Thoughts on Evaluating Real Estate Investments Without Opening Excel

In our industry (commercial real estate), the ability to quickly evaluate investment opportunities is crucial for staying competitive. I know I’ve found in my professional career, that having a clear framework for evaluating – and then either passing or spending more time on – investments is crucial to managing an efficient pipeline. Thus, being able […]

, , , , , , , , , ,

Forecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2024)

When modeling real estate investments, industry practice is generally to stop at before-tax cash flow, rather than after-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily have the exact same tax treatment. So comparing the projected returns […]

, , , , ,

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, we’re working to build the world’s largest library of real estate analyst GPTs. A few weeks ago, […]

, , ,

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), monthly and annual periods, duration calculation, lender yield calculation, average life calculation, static and dynamic debt service payments, loan assumptions, and more. This module […]

, , ,

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 as the critical developments in AI and their practical applications to CRE. One such […]

, , , ,

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 by the requirement of prior experience? In this article, we’ll explore practical tips and real-world advice on overcoming the […]

, , , ,

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 role of an acquisitions professional needing to assess the viability of a value-add […]

, , , ,

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 distributed. In this blog post, I’ll share the response I gave him in order to help […]

, , , ,

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 to assess the viability of a value add apartment acquisition opportunity. Practice makes […]

, , , , , , , , , , ,

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 hold period. I also include an optional file that you can […]

, , , ,

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 as an intern and I took my fair share of asset management courses during my graduate real […]