, , ,

Real Estate Financial Modeling Accelerator (Updated September 2019)

Since starting A.CRE, Michael and I have fielded email after email requesting a more structured real estate financial modeling training program on the site. Important Note: We're updating and adding to the Accelerator every week. Since launch,…
, , , ,

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

MBA or MRE? Why I Chose to Get Both and Some Considerations for What Might Be Right For You

Ever since Spencer wrote his post about why he chose to do an MRE as opposed to an MBA or a dual Master’s degree, I have been asked a lot by our readers about why I chose to go for both an MBA and MRE. Below I will discuss my rationale and…
, , , ,

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

A.CRE 101: CRE Risk Profiles

In this post we will go into detail about the four CRE risk profiles commonly ascribed to commercial real estate opportunities. In order of least risky to most risky, they are as follows:Core Core Plus Value Add OpportunisticThis…
, , , , ,

Deep Dive: The IRR and XIRR - Fully and Simply Explained (Part 1)

Part 1: The IRR For my next two posts 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…
, , ,

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

Watch Me Build: Construction Draw Schedule

The video below and corresponding downloadable templates will walk you through how to build a basic construction draw schedule.Basic Construction Financing & Draw schedules: A Conceptual Overview A standard draw schedule with a basic…
, ,

Keyboard Shortcuts I Use Constantly When Modeling in Excel (Formatting)

The more you model real estate in Microsoft Excel, the faster and more accurate you become - and hopefully as a consequence the more valuable you become to real estate employers and investors. Part of the process of mastering real estate financial…
, , , , , , , , , , ,

Development Draw Schedule - Visually Customize Each Line Item

Working a lot with development draw schedules, I have always been looking for a catch all solution as to how one could easily model all the unique ways cash actually flows over time during the process. The norm for many is to model cash flows…
, , ,

Using the Cash-on-Cash Return in Real Estate Investment Analysis

I’ve fielded a handful of Cash-on-Cash (CoC) return questions of late. So, I thought it would be worthwhile to write a post on what the Cash-on-Cash return metric tells me about a potential real estate investment. This article is a primer,…
, , , , , , , ,

4-Tier Equity Multiple Waterfall - Download and Watch Me Build

Here is a simple, yet very powerful, 4-tier equity multiple waterfall module. This post contains both a completed version of the module ready to plug into a real estate financial model as well as a 'Watch Me Build' template and companion video…
, , ,

1031 Exchange - Introduction, Overview, and Analysis Tool

A 1031 Exchange, or Like-kind Exchange, is a strategy in which a real estate investor can defer both capital gains tax and depreciation recapture tax upon the sale of a property and use that money, which has not been taxed, to purchase a like-kind…
, ,

McDonough School of Business - Georgetown University - MBA Real Estate Profile

 Coming out of undergrad as an engineer I knew in the future I would need a generalist business education to achieve my goals. After I had garnered some professional experience and had a better idea of my career path, it was time…
, ,

McCombs School of Business - University of Texas - MBA Real Estate Profile

The McCombs School of Business at The University of Texas at Austin offers a robust Real Estate MBA experience for students looking to springboard their career in the commercial real estate industry. While the program is renowned for its…