Excel Tips

All | Argus | All-in-One | Excel Models | Excel Tips | Stochastic Modeling

real estate financial modeling courses

, , ,

The Real Estate Financial Modeling Accelerator

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. Over the years, we've covered hundreds of real estate modeling topics in our blog;…
Real Estate IRR Partitioning
, , , , , ,

IRR Partitioning in Excel

In this post, I'd like to show you how to partition the internal rate of return of your real estate investment in Excel. I also throw in a quick equity multiple partition, to highlight how the time value of money affects your returns. I've recorded…
, , ,

Supercharge Excel with the WST Macros Add-in

A year ago I wrote about Wall St. Training and their free Excel modeling resources. In that post, I mentioned the free WST Macros and how it is an indispensable add-in; one that I use in my professional life daily. Well, version 4.4 was recently…
, , , ,

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…
Circuit Breaker - Fix Circular References Errors in Excel
, , , ,

The Circuit Breaker - How to Fix Circular Reference Errors in Excel

If you've spent much time working with elaborate Excel workbooks that rely on iterative calculations to solve formulas with circular logic, you've undoubtedly come across a problem where if you accidently put an erroneous value in an input…
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.…
Normal Distribution in Real Estate Forecasting
, , , , , ,

S-Curve Forecasting in Real Estate Development

One of the reasons Mike and I blog, is to force ourselves to be continually learning. I built the first version of my real estate waterfall model, because I wanted to better understand the mechanics of modeling an equity waterfall with…
, , , ,

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

Disable Animations - Excel 2013 (and Presumably in Excel 2016)

If you recently upgraded from Excel 2007 or Excel 2010 to either Excel 2013 or Excel 2016 for Windows, you've probably noticed a change that can be quite distracting (and even annoying!). Microsoft Excel now animates certain actions as you work.…
, , , ,

Real Estate Modeling Tip: The Floating Summary Box

I learned a great new modeling tip this weekend that I wanted to share. As you may know, I'm in the process of building a beta version of a real estate DCF in Excel; albeit rather slowly given my limited spare time! The workbook has grown…