Posts

real estate professional using the income approach, a financial tool to value income producing property
, , , , ,

A.CRE 101: How to Use the Income Capitalization Approach to Value Income-Producing Property

In commercial real estate, there are a few generally accepted methods for appraising (or valuing) real property. The three most common are the Cost Approach, the Sales Comparison Method, and the Income Approach. The Income Approach includes…
, , , ,

The A.CRE Method for Doing Cap Rate Math in Your Head

In this post, I'd like to share a method, that with a little practice, will enable you to quickly do cap rate math in your head; whether it’s quickly figuring out what the sale or purchase price would be of a property based on the NOI and…
, , , , , ,

Watch Me Build a Multifamily Real Estate Model

One way to become a better real estate financial modeling professional, is to watch other professionals model. I know in my career being able to physically see how others tackle different modeling problems has shaped my methods and made me better…
, , , , ,

How to Use the Apartment Acquisition Model's Monte Carlo Simulation Module

You may recall that a couple of weeks ago, I began to explore Stochastic Modeling concepts, or the idea of adding probability into my models, to get a more complete picture of the risk-return metrics of an investment. I became interested in…
, , , ,

How to Use the Construction Draw and Interest Calculation Model

As promised, I've recorded a tutorial on how to use my construction draw and interest calculation model. The 20 minute tutorial walks you through how to use the model to forecast construction cash flows during your development period. The model…
Dynamic charts in Excel
, , ,

How to Create a Dynamic Chart in Excel

I recorded a tutorial over the weekend on how to create a dynamic chart in Excel. I typically build my models with functionality to adjust the analysis or hold period - you can find many examples in our library of real estate financial models.…
, , , ,

Apartment Valuation Tutorial Using the Real Estate Acquisition Model

I promised a how-to video for my real estate apartment acquisition model, and so I thought I'd use an actual property to do so. I grabbed a property from Loopnet that is currently for sale, and dropped the information from the listing into…
, , , ,

Scenario Analysis using the Equity Waterfall Model

I received a question this morning asking how to use scenario (or sensitivity) analysis with our Real Estate Equity Waterfall Model. I started to answer the question via email, decided to build an Excel file to go along with my answer, and ultimately…
, , , ,

How to Use My Real Estate Equity Waterfall Model

I took a few minutes this weekend, and created a video to help you use my real estate equity waterfall (IRR hurdle technique) model that I built in Excel. Again, keep in mind that the model is not standalone, but can be used with any of the…