, , ,

Real Estate Financial Modeling Accelerator (Updated Nov 2022)

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

Emory University – Undergraduate Real Estate Profile

One of the qualities I value most is being open-minded. For this reason, as a 16-year-old beginning my college search, I was too afraid to go straight into a business program or business school within a university. I wanted to explore courses…
, , ,

Real Estate Equity Waterfall Model – Monthly Periods (Updated Jul 2021)

When I decided to share my real estate equity waterfall model in Excel, I never imagined it would be as popular as it has. The model has been downloaded thousands times and many of you have written to extend your thanks for sharing. It is gratifying…
, , , , , , , , ,

Watch Me Build – Custom Rent Schedule Module

In this Watch Me Build video I show you how to build a custom rent schedule module for long-term leases. The foundation of the module is a simple INDEX/MATCH combination that takes a rent schedule and models the rent cash flows across the entire…
, , ,

Case Study #8 – Walgreens vs. Walgreens – STNL Investor (Case + Solution)

This is the 8th real estate case study in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. The Walgreens vs. Walgreens - STNL Investor…
, , ,

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

The A.CRE Networking Reboot Cruise

One of our biggest goals here at A.CRE is building a community and engaging with our readers. Recently, you've likely seen our posts on the A.CRE Networking Reboot Cruise. This cruise we're putting together is another effort to bring that community…
, , ,

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…