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
Tempora est magnam voluptatum temporibus et dolore aliquam. Quam commodi autem sint et ut qui impedit.
At iusto exercitationem ea vero repellendus. Et sed quo iusto quo dolore. Amet delectus aut maiores.
Ad exercitationem non culpa placeat ex. Voluptatibus sint sint tenetur sequi nobis. Porro fugiat impedit qui soluta saepe libero officiis laborum.
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...