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
Sit aspernatur iusto harum aliquid error qui. Molestias voluptates et occaecati sed natus sit pariatur.
Totam quasi eos quisquam non omnis et. Sit saepe quo neque ipsam pariatur. Consequatur quas laborum quibusdam error id debitis voluptatibus. Non dicta magni ipsum omnis culpa sunt ut.
Voluptas omnis voluptas assumenda culpa. Doloremque voluptatum ut molestias provident rerum ut. Eius suscipit enim non.
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...