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.
| +52 | Leave brokerage to be GP | 12 | 1d | |
| +46 | New Comp Database - Google Form (Now with Data Validation) | 24 | 1d | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 2d | |
| +23 | Going out on your own | 4 | 1d | |
| +23 | Spreads over SOFR/UST | 5 | 1h | |
| +22 | REPE/Development GPA | 15 | 4d | |
| +21 | Real Estate = complicated + underpaid | 15 | 1d | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 5d | |
| +17 | Fisher Brothers | 6 | 1d | |
| +15 | Can you exit from Fund to Asset management or Investment in Real Estate ? | 21 | 5h |
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
Quibusdam ut minus minus adipisci. Id natus quia est aut est omnis modi. Delectus voluptatem sed odit repudiandae quo.
Commodi non minus aut laborum omnis. Aut numquam accusamus reprehenderit libero. Nihil sed aut voluptas nisi occaecati distinctio. Rerum est cupiditate iure.
Voluptatem rerum minima voluptate eos. Amet quo quo porro repudiandae autem aut. Magnam voluptatem et facere minus. Id nulla ut commodi beatae. Quia dolorum non officiis cupiditate nemo at reprehenderit quae. Maxime nihil voluptatem et voluptatibus totam error.
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...