This model has been updated numerous times since this original video, and much has changed. So I created a new walkthrough video for this model. You can find that video here: ua-cam.com/video/kVO3zJqbqP0/v-deo.html
Thank you for sharing the video, clear and clean. I wonder why there is no Broker fee in end of exit? the net sales value shall after broker fee, isn't it?
Hey Spencer I was wondering when you have a chance can you put up a video on how you built this model. Thanks for uploading your content is great, very informative.
could you upload the same video, but zoomed out so that we can see some of your formulas. Particularly interested in how the total contributions picked up the capital call etc.
Benjamin Russell Thanks for watching. You can download the Excel file, with all of the formulas here: www.adventuresincre.com/real-estate-acquisition-model-for-office-retail-or-industrial-properties/
I doubt you'll read this cause its not very recent, But I tried your file and the lag is just crazy. Do you have a more recent model that won't lag? I dont need the all in one, this is perfect for my current needs. thanks !
so is it always the case that exit cap rate is expected to increase the older your building gets? I see yours is increasing 5 bp every year from the market cap. Im guessing the older the building the bigger the risk when you sell. Please confirm.
It is partly this, it s also the uncertainty that you do not know what the market will be like 10 years from now or 20 years from now. The uncertainty creates more risk and thus a higher terminal cap rate. The age of the buildings plays a small factor but not as much as the market.
I downloaded the model template and I want to know how to create the drop down list that you made in the purchase price method to switch formula/indicating numbers of the entire excel sheet? What is the trick to do that? Thanks!
This model has been updated numerous times since this original video, and much has changed. So I created a new walkthrough video for this model. You can find that video here: ua-cam.com/video/kVO3zJqbqP0/v-deo.html
Thank you for sharing the video, clear and clean. I wonder why there is no Broker fee in end of exit? the net sales value shall after broker fee, isn't it?
thanks for the info and excel template. I have a brand new imac 27" loaded and its lagging like hell just to make one input. Beachball for 60 seconds.
Recent update, check it out online!
Hey Spencer I was wondering when you have a chance can you put up a video on how you built this model. Thanks for uploading your content is great, very informative.
Mr. Burton, can you elaborate about the unit (BPS) Exit Cap rate growth / year?
Can you do one with an escalation clause during only certain periods? like for e.g. a rent step up of 5% between years 5 and 6?
could you upload the same video, but zoomed out so that we can see some of your formulas. Particularly interested in how the total contributions picked up the capital call etc.
Benjamin Russell Thanks for watching. You can download the Excel file, with all of the formulas here: www.adventuresincre.com/real-estate-acquisition-model-for-office-retail-or-industrial-properties/
Dear Mr. Burton, How can I incorporate land appreciation value forecast into the terminal value?
what's the best book to buy in order to learn how to model for real estate?
What does "," mean in an excel formula? Thanks in advance!
I doubt you'll read this cause its not very recent, But I tried your file and the lag is just crazy. Do you have a more recent model that won't lag? I dont need the all in one, this is perfect for my current needs. thanks !
Recent update, check it out!
so is it always the case that exit cap rate is expected to increase the older your building gets? I see yours is increasing 5 bp every year from the market cap. Im guessing the older the building the bigger the risk when you sell. Please confirm.
It is partly this, it s also the uncertainty that you do not know what the market will be like 10 years from now or 20 years from now. The uncertainty creates more risk and thus a higher terminal cap rate. The age of the buildings plays a small factor but not as much as the market.
I downloaded the model template and I want to know how to create the drop down list that you made in the purchase price method to switch formula/indicating numbers of the entire excel sheet? What is the trick to do that? Thanks!
data validation, alt a v v
DCF - Discounted Cash Flow?
Kyle Christian - Correct
Bibliography?