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.
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:
- REVPAR (Revenue Per Available Room)
- Debt Yield
- Unlevered Equity Multiple
- Unlevered Internal Rate of Return (on a monthly and annual basis)
- Cash-on-Cash Return
- Debt Service Coverage Ratio
- Yield-on-Cost (Development Yield)
- Development Spread
- Base Year Stop
- Floor Area Ratio (“FAR”)
- Convert Monthly to Quarterly Periods
- Convert Monthly to Annual Periods
- Occupancy Cost Percentage (Health Ratio)
- Average Rate of Return
- Weighted Average Life
- Stochastic Analysis / Monte Carlo Simulations
- Present Value Factor
- Future Value Factor
- Yield Maintenance
- Weighted Average Lease Term (WALT, WAULT, WALE)
- Operating Expense Ratio
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.