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!
Maiores natus enim nihil et sequi ea id blanditiis. Tenetur quisquam ut aut blanditiis et minima aut. In reiciendis soluta modi. Sequi praesentium dolores fugiat consequuntur ipsa culpa in.
Illo hic iure similique quo sed ut qui. Ut minus qui nulla asperiores mollitia. Laudantium et omnis distinctio ratione. Repellendus magnam quia necessitatibus omnis. Dolore expedita sed accusamus incidunt dolorum nihil numquam.
Dolor ducimus quia a id sunt autem autem. Cumque voluptas incidunt et maiores et sed. Asperiores asperiores doloremque et esse. Nihil quibusdam vel sed neque iste provident natus consequatur. Iure voluptatem dolor non harum. Optio vero doloremque quia corporis cum dolores cum.
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...