Hi Joshua, thanks for the course, I am enjoying the videos very much! I have a question, when you calculated the absorption and turnover vacancy you only calculated it for the first 24 months (19 & 20) but what about the subsequent months and years? Looking forward to your answer, thanks a lot!
Hi Joshua, Thanks for the videos! They're extremely helpful. Quick question : why should the general vacancy be zeroed out if it's swamped by the absorption & turnover vacancy ? What does it mean exactly ?
You are adjusting the general vacancy by the turnover vacancy. So what we do is take the general vacancy and then adjust it by the 'Absorption and Turnover Vacancy' in this case minute 10:10 it is (-21,536) - (-38,453) this is a positive number meaning that there is no vacancy. So we build an IF statement in to say if that calculation is positive we should just take the Absorption and Turnover Vacancy, that way we do not double count vacancy.
In other words if the absorption turnover is so big it swamps the general vacancy so we don't do a general vacancy. If it partially swamps it we show the partial vacancy.
I'm planning to do just that. My current plan is to do a little more on the commercial piece and then I can layer in some stuff on residential. There's nothing stopping me from making it a mixed-use model. Invite your friends to subscribe. :)
Joshua Kahr kidding but I will be on the lookout for the multi family walkthrough.. I like the way you set things up. I need to keep it simple and easy to explain to anyone. Thanks.
Hi Joshua, thanks for the course, I am enjoying the videos very much!
I have a question, when you calculated the absorption and turnover vacancy you only calculated it for the first 24 months (19 & 20) but what about the subsequent months and years?
Looking forward to your answer, thanks a lot!
To download the Excel file I used in this video, go to: www.kahrrealestate.com/free-stuff/
I would be your biggest fan
Hi Joshua,
Thanks for the videos! They're extremely helpful.
Quick question : why should the general vacancy be zeroed out if it's swamped by the absorption & turnover vacancy ? What does it mean exactly ?
You are adjusting the general vacancy by the turnover vacancy. So what we do is take the general vacancy and then adjust it by the 'Absorption and Turnover Vacancy' in this case minute 10:10 it is (-21,536) - (-38,453) this is a positive number meaning that there is no vacancy. So we build an IF statement in to say if that calculation is positive we should just take the Absorption and Turnover Vacancy, that way we do not double count vacancy.
In other words if the absorption turnover is so big it swamps the general vacancy so we don't do a general vacancy. If it partially swamps it we show the partial vacancy.
Gotta do this for a value-add multifamily deal
I'm planning to do just that. My current plan is to do a little more on the commercial piece and then I can layer in some stuff on residential. There's nothing stopping me from making it a mixed-use model. Invite your friends to subscribe. :)
Joshua Kahr Awesome. How much would you charge for a model review? Lol
Joshua Kahr kidding but I will be on the lookout for the multi family walkthrough.. I like the way you set things up. I need to keep it simple and easy to explain to anyone. Thanks.