, , ,

Real Estate Financial Modeling Accelerator (Updated March 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…
, , , ,

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…
,

Real Estate Salary and Benefits (United States 2018)

Several years ago, we published a careers in real estate series where we discussed the various job sectors, business fields, and job functions that exist in the real estate industry. Additionally, we broke down compensation in real estate (salary…
, , , , ,

Deep Dive – Sources of Capital: Real Estate Private Equity

Capital for commercial real estate investments is generally sourced from one or more of the following buckets: public equity, public debt, private equity, or private debt. In my experience, few people fully understand these four buckets of capital,…
, , , , , ,

Back-of-the-Envelope Office, Retail, Industrial Acquisition Model (Updated 10.1.2018)

I’ve built a new acquisition model that I am excited to share with our readers. This is a back-of-the-envelope (BOE) valuation model that can be used for retail, office, and industrial properties. The goal was to create a sleek and clean look…
,

Excel Speed Tip – Insert or Delete a Row or Column Without a Mouse

Using keyboard shortcuts is essential to improving the speed and efficiency at which you model real estate in Excel. One thing you'll learn early in your CRE career, the more proficient you become in using your keyboard without a mouse to navigate…
, , , ,

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…