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…
A.CRE 101 – Create Smart Drop-Down Menus in Real Estate Modeling
One Excel feature real estate financial modeling professionals use often is the data validation list. Where data validation is a method of limiting the possible inputs of a cell, the data validation list limits those inputs to a pre-defined…
Deep Dive: Understanding Acquisitions: The Letter of Intent (LOI)
The Letter of Intent - Legal Issues
The letter of intent is a critical document that is written up at the beginning of a potential real estate transaction between either a prospective buyer and seller or a prospective tenant and landlord.…
Graduate Real Estate Series: Columbia University MS.RED (Updated 2.2.2019)
The Columbia University Master of Science of Real Estate Development (MS.RED) program is an intensive, three term (one year) graduate program in real estate offered through Columbia University's highly ranked Graduate School of Architecture,…
Excel-Based Restaurant Selection Tool for the Overly Indecisive
We're celebrating some much deserved time off from work, and so what better way to spend the time than to make a completely unnecessary (but fun!) Excel model. I call this the indispensable Excel tool for the overly indecisive, and it's basically…
Hotel Proforma Basics – Hotel Cash Flow Projection
Hotels are a unique asset in the commercial real estate world and are underwritten differently as a result. Probably the most obvious difference is the duration of the 'lease term' of the tenant, which is usually daily to weekly. Another major…
Understanding Treatment of Time 0 in the All-in-One Model
I received a very astute question/concern from a user of our All-in-One(Ai1) model in our Ai1 Support Forum late last month. I initially set out to answer the question in writing, but the more I thought about my response, the more I concluded…
All About Cap Ex
In this post, we are going to take a deeper look into capital expenditures. What it is and how we account for it in cre underwriting.
Capital expenditures, commonly referred to as Cap Ex, are expenses that occur outside of normal operating…
Deep Dive: The IRR and XIRR – Fully and Simply Explained (Part 2)
Part 2: The XIRR
(Click here for Part 1 where we cover the IRR)
This is Part 2 of our A.CRE Deep Dive - 2-part mini-series on the IRR and XIRR return metrics and functions in Excel. As stated in Part 1, these are some of the most commonly…
Deep Dive: The IRR and XIRR – Fully and Simply Explained
For my next post, I thought I would bring it back to some fundamentals and review the IRR and XIRR return metrics and functions in Excel. These are some of the most commonly used functions and return metrics in commercial real estate and they…
A.CRE User Insights Survey
We need your help! As Adventures in CRE (A.CRE) has grown and evolved over the years, so have the needs of our readers. The challenge for Michael and I as we contemplate what new content to create, is knowing what resources will be most beneficial…
The A.CRE Method For Doing Cap Rate Mental Math – Practice Tool
At the bottom of this post is a downloadable practice tool for the A.CRE Method for doing cap rate mental math. The tool will generate an endless number of random cap rates and NOIs to practice with and will walk you step by step through how…
Book Review: Am I Being Too Subtle by Sam Zell
Why I liked “Am I Being Too Subtle"
This is a real estate book through and through and I had a great time reading it. Sam Zell had a long list of stories ranging from his trip to the spectacular Tepuis mountains (Google them if you’re…
The Latest Adventures in CRE Initiatives
As has been our habit since starting Adventures in CRE a few years back, we try to keep our readers updated on our progress and direction. Many of you have been with us since the start and we've personally communicated with hundreds of you.…
Book Review: Triumph of The City
Why I liked “Triumph of The City"
The central theme of this book focuses on cities and their ability to improve the way we live. Although the author made numerous interesting and compelling arguments, I found his writing style a…
Book Review: Superforecasting – The Art and Science of Prediction
Why I liked “Superforecasting - The Art and Science of Prediction”
I thoroughly enjoyed this book and highly recommend it to everyone in the real estate industry (particularly developers who would benefit significantly from being…