by josh@kahrrealestate.com | Oct 24, 2023 | Uncategorized
After 20+ years of doing consulting work, I finally came to the conclusion that I should share some of the most interesting people that I’ve met along the way with everyone else. I’ve launched a podcast where I’m interviewing those people about their...
by josh@kahrrealestate.com | Mar 15, 2023 | Uncategorized
Slowly but surely, I will reach my target of 10,000 YouTube subscribers. On the one hand, it’s not a lot of people. On the other hand, I’m posting videos about Excel modeling for commercial real estate finance. When one considers the topic, it’s a...
by josh@kahrrealestate.com | Mar 15, 2023 | Uncategorized
I saw this at a client’s office last week. When you have a large pipe in the middle of your conference room, surround it with glass on three sides and make it decorative. My favorite detail was it was entirely sealed. You don’t have to dust it if dust...
by josh@kahrrealestate.com | Jun 9, 2022 | Uncategorized
Apparently, there are a lot of people that are interested in how to build an XLOOKUP. What an odd fellowship we have here.
by josh@kahrrealestate.com | May 10, 2022 | Uncategorized
After months of dropping them one at a time on youtube, there is now a complete collection of totally free video solutions to my case study book (“Kahr’s Challenge Cases”). To download the book, go here. To watch the videos, go here. And, of course,...
by josh@kahrrealestate.com | Mar 26, 2021 | Uncategorized
I first launched my YouTube channel back in 2015. For the first few years of its life, I really didn’t do anything with it. I figured it would be a good place to post some materials for a class I was teaching at Columbia; it’s a free video hosting service,...
by josh@kahrrealestate.com | Oct 5, 2020 | Uncategorized
The XLS format dates from Excel 2003. It was limited to no more than 65,000 rows. XLSX format solved this with the release of Excel 2007; it goes out to a little over 1,000,000 rows. I’ve often been asked what the difference is between XLS and XLSX, and when I...
by josh@kahrrealestate.com | Sep 15, 2020 | Uncategorized
Back in 2019, I wrote a post about the “Kahr Ratio”. It’s a calculation that is extremely useful when determining whether or not a rate of condominium sales will be able to pay off the outstanding construction loan balance. It’s a breakeven...
by josh@kahrrealestate.com | Sep 11, 2020 | Uncategorized
It only took four months, but I finally got the first answer key up to my “Challenge Cases”. See: Answer Key to Abacus Capital – https://www.kahrrealestate.com/wp-content/uploads/2020/09/Abacus-Capital.xlsx There is a direct correlation between my kids...
by josh@kahrrealestate.com | Aug 19, 2020 | Uncategorized
Sometimes things don’t work out. Not every deal is a home run. This is an email I received a while ago, but in the wake of the ongoing mess we’re in, it seemed apropos to bring it up. I can picture the scene. Vice President: “Here’s that...