I made a few minor changes (Updated Mar 2020) and combined the pre-formatted template and completed file into one Workbook. You can find the Excel files, together with written instructions, here: www.adventuresincre.com/watch-build-tenant-rollover-analysis-model/. Happy modeling!
@@adventuresincre I think he means that it does not take into consideration the downtime. For example, Chow Chili has a lease downtime of 6 months, under the lease generation it has a 6-month gap between the 1st end and 2nd start, yet it doesn't show the gap in the 10-year chart on the right (only shows one month of downtime).
![[OLD] All-in-One Model Walkthrough #2 - Office/Retail/Industrial Rent Roll Tab [OLD]](http://i.ytimg.com/vi/1rrmi3AsJUg/mqdefault.jpg)
I made a few minor changes (Updated Mar 2020) and combined the pre-formatted template and completed file into one Workbook. You can find the Excel files, together with written instructions, here: www.adventuresincre.com/watch-build-tenant-rollover-analysis-model/. Happy modeling!
that adding "sf" in the number format is brilliant
Great video thanks! We only base the roll out on net rent and show a separate line for occupancy. Depends on the asset type I guess
Thanks Spencer,
The days vacant at rollover only counted only one month, seems to me it should be counting six months of vacancy at each lease roll?
Hi Stuart - thanks for watching! I'm not sure I follow, elaborate a little for me. Do you spot an error in how the downtime is calculated?
@@adventuresincre I think he means that it does not take into consideration the downtime. For example, Chow Chili has a lease downtime of 6 months, under the lease generation it has a 6-month gap between the 1st end and 2nd start, yet it doesn't show the gap in the 10-year chart on the right (only shows one month of downtime).