, , ,

Auto-Populate Latitude and Longitude in Excel

When analyzing real estate investments in Excel, it's often necessary to include the latitude and longitude coordinates of the properties we're modeling. To do this, most of us open up Google Maps, or some other mapping tool, and find the…
, , , , , ,

How to Run Monte Carlo Simulations in Excel

So you want to run Monte Carlo simulations in Excel, but your project isn't large enough or you don't do this type of probabilistic analysis enough to warrant buying an expensive add-in. Well, you've come to the right place. Excel's built-in…
, , ,

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

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

Formulas I use to Create the Period and Date Rows at the Top of a Monthly Cash Flow Report

We've spent a lot of time here discussing and sharing different real estate models, and we've received a ton of feedback from our readers as a result. In some of that feedback we've received, several people have asked what period and date rows I…
, , , ,

Excel Tips: Creating Data Tables and Inserting Text into Numerical Cells

The Excel model attached to this post is to show modelers how to (1) create and use data tables and (2) insert words into numerical cells. The Data Table function is a great tool that allows you to show numerous results for various return…
, , ,

Wall St. Training - Free Excel Resources

Wall Street Training (WST) is a fantastic site for free and paid Excel training resources. According to their site, they are "The world's leading provider of live and online financial training, serving a wide variety of investment banks,…