## 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 difference is that hotels are more operating intensive and typically contain other complimentary services […]

## 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 to the model that would enable a third party to easily understand what […]

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 expenses. They are items that ownership either needs to or decides to pay […]

## 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 used functions and return metrics in […]

## 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 can be a bit complex to understand for those of us […]

## 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 to solve for each scenario you are working in.  […]

## A.CRE 101: How To Use The Discounted Cash Flow (DCF) Method To Value Income Producing Property

The Discounted Cash Flow Method is a method to value a project by taking all future projected cash flows of the project and discounting them back to time zero (date of purchase) using a predetermined discount rate (the discount rate when used in a DCF to look at an investment can be looked at as […]

## 3 Tiered Waterfall Module Added to the Condo Development Model

After receiving a few requests, I’ve finally gotten around to adding an equity waterfall module to the Condominium Development Model. This module allows you to model partnership splits up to three tiers using either equity multiple hurdles or IRR hurdles. Additionally, you can model for a preferred return for the limited partner where either (1) […]

## The A.CRE MBA Real Estate Series

Spencer and I are excited to introduce the A.CRE MBA Real Estate Profile series. This series is intended to provide prospective MBA students with a glimpse into some of the world’s top MBA real estate programs and what they have to offer those who intend to focus on commercial real estate while pursuing their MBA. The […]

## San Francisco Development Explosion! – Interactive Map & Side Project

San Francisco’s downtown area is currently going through an unprecedented, skyline redefining transformation. So many incredible developers and architects are in the process of leaving their mark on this city and it’s all happening or will be happening within roughly one square mile south of Market St in the downtown areas known as the Transbay District, Rincon […]

## Understanding Taxes Series: Part 2 – Exceptions to The PAL Rules

The PAL Rules – A Brief Background The PAL Rules, or Passive Activity Loss Rules, were enacted in 1986 to curb rampant abuses from people using real estate and businesses to generate huge losses to offset income taxes. It used to be that you could take any losses generated from passive income and use them to […]

## Waterfall Model For Real Estate Joint Ventures with Catch Up

I’ve just wrapped up a new JV waterfall model with catch up clause that I am excited to share on the site. This model was built as an addition to my back-of-the envelope retail/industrial/office acquisitions model I posted a few weeks back. And like the acquisition model, I made an attempt to make this as intuitive as possible for […]

## Understanding Taxes Series: Part 1 – Depreciation

Investing in real estate provides some tremendous tax incentives in the USA compared to other investments and is an important component to understanding real estate investing. Given the positive response I’ve received to my Understanding Leases Series, I thought I’d begin a new series on taxes in real estate. Part 1 – Real Estate Depreciation There are […]

## Understanding Leases: Office Buildings – Part 2b

Grossing Up Reimbursable Expenses in ARGUS This post and video are a follow up to a post written back in late October discussing grossing up reimbursable expenses. If you haven’t gotten to read that yet, you can do so by clicking here: https://www.adventuresincre.com/understanding-leases-office-buildings-part-2/ The purpose of this video is to help clearly explain how to […]