As we continue to build out our A.CRE 101 series and our Glossary of Commercial Real Estate terms, we’ve started to supplement these initiatives with short (<30 second) video clips on how to do various CRE calculations and modeling tasks in Excel.

You can think of these 30 second tutorials as bite-sized lessons in real estate financial modeling; with the CRE beginner in mind. Each video starts with a five second intro, followed by a 15-25 second voiceless screen recording of a simple modeling task being performed in Excel – all set to a catchy little tune. These lessons include us performing tasks in Excel such as calculating internal rate of return on a monthly basis or forecasting the debt coverage ratio of a leveraged investment.

bite-sized real estate tutorials

The perfect excuse to use bite-sized pizzas in a CRE post!

Where to Find the 30-Second CRE Tutorial Videos

You can find these videos under various terms in the A.CRE glossary (see an example) as well as in a playlist format embedded below. For a complete list of the terms and concepts that have had videos created for them, scroll to the end of this post.

Browse the 30-Second CRE Tutorials Playlist

Below I’ve embedded the YouTube playlist with all of the 30 second tutorials recorded to date. Either click the play button, and watch the videos in order of upload date, or click the hamburger button in the upper-left hand corner of the video frame and select the video you’d like to watch.

Terms and Concepts with 30-Second CRE Tutorials

Here is a complete list of terms and concepts that have been featured so far in one of our 30 second videos:

See all concepts and terms we’ve covered in our Glossary of Commercial Real Estate Terms.

Suggest Terms/Concepts to Add

If there is a term or concept that has yet to be addressed in this video series that you’d like us to add, please shoot us a quick message and I’ll be sure to add it to my list.

About the Author: Born and raised in the Northwest United States, Spencer Burton has over 20 years of residential and commercial real estate experience. Over his career, he has underwritten $30+ billion of commercial real estate at some of the largest institutional real estate firms in the world. He is currently President and member of the founding team at Stablewood. Spencer holds a BS in International Affairs from Florida State University and a Masters in Real Estate Finance from Cornell University.