The topic of ground leases has come up several times in the past few weeks. Numerous A.CRE readers have emailed to ask for a purpose-built Ground Lease Valuation Model. And I’m in the process of creating an Advanced Concepts Module for our real estate financial modeling Accelerator program covering the mechanics of modeling ground leases. […]
Ver y leer nuevo contenido en español. Este contenido ha sido creado por el equipo A.CRE para profesionales en la inversion inmobiliaria. Tutoriales, modelos financieros, educación, y mucho más.
When building a real estate financial model, managing income and expense growth is rarely as simple as applying a fixed growth rate year over year. In real estate investment analysis, growth assumptions need to be flexible, dynamic, and reflective of real-world realities. One common challenge is modeling irregular growth rates, where: Growth occurs annually but […]
Today, we’re thrilled to share with the A.CRE community a new timesaving (and free) Excel tool: the ‘Excel 4 CRE’ Add-in! Over the past few years, we at A.CRE (together with our new favorite companion, ChatGPT!) have been developing and sharing this Excel add-in. The goal? To make real estate financial modeling faster and more […]
If you haven’t noticed, we’ve been exploring use cases, training, and tools related to AI in commercial real estate a lot lately! The reason is that Artificial intelligence (AI) is poised to revolutionize the commercial real estate industry by transforming the way acquisitions, development, management, advisory, and marketing teams in the industry operate. AI tools […]
Build-to-rent (BTR) has become more and more common in CRE and now accounts for a meaningful share of development. In the past, we’ve recommended A.CRE readers use our Apartment Development Model for BTR analysis. However, as we’ve received numerous requests over the few years for a purpose-built BTR model – including an inquiry in a […]
I’m often asked to share models centered around residential development and home building. This is an area of real estate I’m completely comfortable in, since I spent the first 10 years of my career in new residential development. Not surprisingly, I’ve assembled a decent size library of Excel pro formas for land developers and home […]
As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016 I released the first beta-version of the model – my All-in-One (Ai1) […]
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 topics in our blog, published hours of video, and shared 70+ real estate Excel models in our Library. Nonetheless, no matter how many posts […]
In 2018, Michael and I designed and built the A.CRE Accelerator program. Our goal was to create the preeminent tool for mastering real estate financial modeling—a program that would provide a clear path to expertise and give Accelerator Graduates a significant edge in the industry. Now, as we celebrate the Accelerator’s evolution and its impact […]
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 honesty, I wasn’t qualified for the title. In fact, I had little to no actual experience […]
A few years back, on a sleepy Saturday afternoon while my kids were busy eating Halloween candy, I decided to create a simple real estate acquisition model in Excel for office, retail, and industrial deals. Since then, I’ve made various updates, including error fixes and functional improvements. The model calculates returns at the property and […]
Why use COUNTIFS, SUMIFS, and AVERAGEIFS functions in real estate? When real estate analysts first start their careers, they’re often required to work with large data sets and to transpose property and portfolio information from one format to another in Excel. At first, being unfamiliar with many of Excel’s functions, they manually perform these operations. […]