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 […]
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 […]
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 also play a vital role in drafting, reviewing, and negotiating contracts, conducting due diligence, and providing legal advice […]
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 and is depended on by a host of stakeholders to insure the outcome of the project is a […]
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 how the industry underwrites single-tenant net lease investments. The model is […]
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 analyzing the feasibility of purchasing a retail sale-leaseback from a […]
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 […]
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 […]
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 me some time ago to come up with a more robust option, and this debt […]
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 […]
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. […]