Free Stuff

Over the years, we’ve accumulated a lot of educational and supporting material in the fields of real estate finance. Some of this material is listed below.

Everything on this page is available for download. If you like what you see, and you want to see more, let us know.

Even more of our videos are available for viewing on youtube. If you’d like to subscribe to our YouTube channel and be notified whenever we post a new video, click the button below.

Timer Tester

Want to make your spreadsheets run faster? I’ve put together a simple Excel spreadsheet that you can use to time different pieces of your model so you can identify the slowdowns.

The file is here:

https://www.kahrrealestate.com/wp-content/uploads/2020/06/Timer-Tester.zip

Also, if you want to watch a little video that explains it, go here:

Challenge Cases

I started teaching real estate finance at Columbia University in its MS in Real Estate Development program back in 2005. For approximately 15 years, I have been asked by at least 10 students per year, the following question:

“I am applying for a job at <insert name of prestigious real estate private equity shop> as an Associate. I am going to have to take an Excel modeling exam when I get there. What should I expect?”

After being asked that question hundreds of times and having to dig around on my laptop to find one every time, I finally decided to pull a case book together.

Over the years, I have collected them from former students. The cases run the gamut across product types and strategies. I have taken those “real world” examples, cleaned them up for clarity, adjusted when needed, and have consolidated them into one text.

The PDF of the cases is available for free here:

Kahr’s Challenge Cases

If you want to watch all 9+ hours of videos of me solving the exams and also receive all of the Excel solutions, I have bundled that into a self-paced course. The price is $300. See here:

https://kahrrealestate.thinkific.com/courses/kahr’s-challenge-cases

Build a Real Estate Financial Model

I’ve been teaching real estate financial modeling for almost 20 years. In that time, I’ve only done live classes. I never wanted to do prerecorded content because who has the patience and focus to watch 15 hours of prerecorded material?

The solution is obvious. Don’t just record a class. Record something that people can watch in snippets.

I’ve started a YouTube channel where I am building a complex real estate financial model in roughly 10-minute increments. If you’re interested, the playlist is on YouTube. I’m at eight videos so far; I’m going to keep building this as long as people keep watching.

Of course, if you want to suggest ideas or have Excel problems you need to be solved, let me know, and I’ll try to work it in.

The first video is the series is below: