Bite-Sized CRE Lessons – A.CRE 30 Second Video Tutorials
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.
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:
- 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
- Loss-to-Lease
- Loan-to-Value
- Loan-to-Cost
- 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.
Frequently Asked Questions about Bite-Sized CRE Lessons – A.CRE 30 Second Video Tutorials
What are the A.CRE 30-Second CRE Tutorials?
They are short (<30 second) video clips designed as “bite-sized lessons in real estate financial modeling,” primarily for beginners. Each includes a 5-second intro and a voiceless 15–25 second Excel screen recording with background music.
What kinds of tasks are shown in the tutorials?
The videos demonstrate “various CRE calculations and modeling tasks in Excel” such as calculating monthly IRR, forecasting the debt coverage ratio, converting monthly to annual periods, and more.
Where can I find the 30-second tutorials?
The tutorials are embedded in a YouTube playlist and also available through individual A.CRE glossary entries. A full list of covered terms is included at the end of the blog post.
Who are the tutorials designed for?
They are created “with the CRE beginner in mind,” offering fast, accessible instruction for those new to real estate financial modeling.
What CRE terms and concepts have been covered so far?
The tutorials cover a wide range of terms including:
Debt Yield
Loan-to-Value
Debt Service Coverage Ratio
Weighted Average Life
Internal Rate of Return
Operating Expense Ratio
Yield Maintenance
…and many more as listed in the blog post.
Can I suggest a term or concept for a future video?
Yes. The blog post encourages users to “shoot us a quick message” with suggestions for terms or concepts they would like to see added to the video series.
Who created the 30-second video series?
The series was created by Spencer Burton, Co-Founder and CEO of CRE Agents. He has over 20 years of CRE experience and co-founded Adventures in CRE. He holds a Master’s in Real Estate Finance from Cornell University.
