Hi, if I have a single-tenant building with five floors (Leases 25,000 sf per floor totaling 125,000 sf) but I expect the tenant to "give back" some space at the end of their lease term, how should I go about modeling this? Currently I have the spaces split up between 25,000 sf each. Each lease term is the same and the rent/sf is the same.
| +23 | SWF/Pension Funds in RE | 3 | 4d |
| +18 | To the veterans: What was institutional dev actually like during the last bull run? | 6 | 1h |
| +16 | Development vs. REPE pay gap | 8 | 6h |
| +14 | PGIM Real Estate Equity Opinions? | 9 | 1d |
| +13 | CRE Credit → Capital Markets | 2 | 3d |
| +11 | PRE MBA IB back to IB | 5 | 1d |
| +10 | Reneging - What should I do? | 5 | 16h |
| +10 | JD/LLM career path to REPE advice | 3 | 1h |
| +9 | Going into RE Entrepreneurship before FT REPE experience. | 1 | 6h |
| +8 | REPE AM Modelling Test / Case Studies? | 2 | 4d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
You could just create new leasing profiles to mimic the current tenant and a new tenant after this lease term ends.
Upon expiration, reabsorb. Then create new leasing profile with space tenant is keeping and another for the vacant.
This- just duplicate the entry change the available and start dates and reabsorb the space
Thanks this helped a lot. Would you go with a similar strategy to handle subleasing? The single tenant is subletting multiple spaces/subdividing multiple floors. The sublet space lease expirations all occur before the official tenant's lease expiration.
Why would that affect your Argus? You still have an in-place lease with your tenant correct? Subleasing should effect the LXD.
Generally speaking though this is the best way to subdivide any larger suite into smaller ones.
I'm assuming that some of the sublet space will execute leases at the end of the lessor's term so I wanted lower TIs for these units. I ended up using reabsorb and I think it turned out correctly.
reabsorb then just create new entry w available date at the end of the current lease. Input in TIs for that entry and use the same MLA
Rem labore blanditiis cupiditate qui et voluptatem voluptate non. Tempora doloremque est dolores voluptatem consequatur ducimus omnis. Quos voluptate distinctio magni. Qui necessitatibus cumque quidem. Aut tempore est ad nihil magnam aut dolor veniam. Eos magni in quia quo.
Qui et omnis consequatur qui. Velit libero aut non tempora laboriosam voluptatem optio. Numquam iste iste odit ea. Et consequatur laboriosam ipsa sed.
Repudiandae quam nesciunt quisquam ut. Aliquid ut tempore dolorum aut reiciendis. Optio et et qui vel.
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...