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 […]
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 $20.7 trillion. Yet, in spite of its impact and size, there is still a […]
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 […]
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 […]
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 – no previous coding experience is required to make this work. […]
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. And while that type of waterfall is extremely common, both in the […]
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. One such CRE-specific GPT that we recently built and that I’m particularly excited to share today is our first real estate analyst GPT: our Advanced […]
Microsoft Excel is the primary tool used by real estate financial modeling professionals. Even while numerous non-Excel alternatives have attempted to de-throne Excel, the 35+ year-old software has shown to be surprisingly resilient to competition. And thus, if you intend to work in real estate you must be proficient in Excel. So what does it […]
Consider this scenario: you have a 50 tenant rent roll, consisting of various tenant types (i.e. small inline, large inline, junior anchor, anchor, etc.), and you want to calculate the weighted average rent for each tenant type. If I asked you, what is the fastest and cleanest way to do this in Excel, what would […]
So you’ve made it past the HR screening interview. You have the education and experience the company is looking for, but now they want to be sure you possess the real estate financial modeling skills necessary to do the job. They’ve asked you to take part in a multi-hour real estate technical interview. In that interview, they’ll […]
In this Watch Me Build session, I’ll walk you through constructing a custom GPT that near-instantly sifts through Industrial Offering Memorandums to pinpoint whether an investment aligns with your criteria. At the heart of this build is a tailored GPT setup that efficiently processes and analyzes complex data sets found in these OMs. Custom GPTs […]
I’m excited to share my Retail Development Model in Excel. This pro forma analysis tool comes as I’ve continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model is an adaptation of my Office Development Model and Industrial Development Model. It’s specifically built to analyze both […]
I’m excited to share my Office Development Model in Excel. This pro forma analysis tool comes as I’ve continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model is an adaptation of my Industrial Development Model. It’s specifically built to analyze both merchant-build and build-to-core, ground-up […]
Over the years, I’ve received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans. Specifically, people have asked for a tool to calculate the loan amount (ie. loan sizing) based on a combination of tests – debt service coverage ratio, loan-to-value, and […]
I originally uploaded this equity/construction loan draw and interest calculation tool to our library of real estate financial analysis models in 2016. Over the years, I’ve continued to update it as suggestions, comments, and requests flowed in from our readers. The model is meant to be used to forecast construction budget cash flows (uses), and then model […]