Annual WALT Forcast
As part of my business plan while determining the feasibility of Office investments, I've been trying to come up with a formula/table/way of calculating what the annual WALT would look like during the hold period of the asset.
Does anyone know of a way or the best methodology to calculate these forecasted WALT values? I've been working on a workbook that calculates this, but it starts getting pretty complex once you start considering renewal probabilities and changes in lease terms.
I feel like there should be a way of doing this in Argus, but I haven't seen or heard of a way of doing so.
Thanks!
I've never seen anyone forecast WALT, but you can view your rent roll "as of" a specific date in Argus. Just copy that out and calculate WALT based on that.
If you want this to be dynamic it’s going to get pretty complicated pretty fast. I don’t have one in front of me but if the lease audit spits out expiration date that’s probably the easiest to drop in a model and build your calc off of that. Most likely you’ll need to drop a tenant summary into excel and will have to build off of that. But will get pretty complex.
Don't think you can. When a lease rolls, you don't have another lease that takes its place in ARGUS (you can if toggle it). Without a lease you cannot get a walt. What you have is an average estimated cash flow as soon as leases start rolling.
Although thinking about this maybe you can? if you get a tenant lines summary report. Or you could make your own forecast on the renewal and space metrics on a one-by one basis, NOT in ARGUS.
To my knowledge nobody forecasts WALT, they only view the metric on in-place data to know how much time remains before they can increase rents or have to go out for renewal tenants. It’s not a dynamic calculation you typically forecast
Culpa ea fuga sunt illo non architecto. Vel voluptatem eveniet neque nihil. Sed facilis sit temporibus.
Libero et blanditiis quibusdam est nobis in. Consectetur et pariatur id. Distinctio ratione sunt eum ut explicabo aut cumque. Saepe ut natus eius numquam est.
Sed quis quia atque pariatur nam et. Voluptas architecto quia nam aliquid.
Accusamus sit sed quos placeat totam dolore qui. Voluptatem aspernatur officiis illum qui corporis porro consequatur. Laboriosam in facere quis voluptatem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...