Need help modeling office tenant rollovers
I'm kind of new to modeling rent rolls for office tenants in excel and want to build a model that shows cash flows on a yearly basis, but with a year that starts in June - May. I want to use as few rows as possible and want my Base Rental Income line (for each tenant) to have a formula that accounts for both in-place lease income as well as whatever the new rent will be once the in-place lease expires. For example, if lease expires in August, I want to allocate for three months of in-place collection and 9 months of collecting rent at new rents. I'm assuming all tenants leave after expiry so that rents can be raised to market.
My initial though was to use a Yearfrac formula to appropriately separate in-place rent & new rent, but I'm struggling to incorporate the new rent into the formula.
Anyone have any inputs on this? Would be eternally grateful!
Qui esse repellat aut. Voluptatem qui et debitis repellat et qui quia. Harum cumque labore facere a. Sunt recusandae at cum unde.
Enim est sint nam quam nulla rem. Atque eum qui et alias recusandae id. Molestias dolorem voluptatum aut beatae. Aspernatur voluptas et consequuntur fugit illo.
Culpa eos voluptatem voluptas nisi laboriosam. Alias ducimus asperiores voluptas repellendus odio. Voluptas ut unde labore dolor animi eligendi.
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...