Posts

, , ,

Real Estate Financial Modeling Accelerator (Updated Sep 2021)

Prior to launching the Accelerator program, Michael and I 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…
, , ,

A.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel (Updated Jul 2021)

The A.CRE Geocoding Excel Add-in uses the Google Geocoding API to automatically convert a given address to latitude and longitude coordinates, or to convert a given latitude and longitude coordinate to an address. The add-in makes auto-populating…
, , ,

Custom Function to Auto-Populate Latitude and Longitude in Excel (Updated 2021)

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…