I am underwriting a three tenant (each tenant is NN) medical office building deal (3 doctors) and want to calculate the Weighted Average Lease Term on the building accounting for the 3% annual rent bumps over each of their respective lease terms.
I know WALT is the sum of individual tenant rent (economic rent) divided by total rent multiplied by remaining lease term. How do I account for the year over year rent bumps? Thanks.
| +52 | Leave brokerage to be GP | 12 | 2d | |
| +49 | New Comp Database - Google Form (Now with Data Validation) | 24 | 2d | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 3d | |
| +23 | Spreads over SOFR/UST | 5 | 19h | |
| +23 | Going out on your own | 4 | 2d | |
| +22 | REPE/Development GPA | 15 | 4d | |
| +21 | Real Estate = complicated + underpaid | 15 | 2d | |
| +20 | High achiever that doesn’t want to work weekends | 12 | 3h | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 6d | |
| +17 | Fisher Brothers | 6 | 2d |
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.
This explains it nicely:
For example, if there is a 10,000 sf building with 3 tenants tenant A leases 5,000 square feet and pays $10.00 per square foot for 5 years, tenant B leases 3,000 square feet and pays $12.00 per square foot for 3 years and tenant C leases 2,000 square feet at $6.00 per square foot for 7 years. First compute total rent (5,000 x $10.00) + (3,000 x $12.00) + (2,000 x $6.00) = $98,000. Then compute the percentage of rent each tenant accounts for: A = 51.02%, B=36.73% and C=12.24%. Then multiple the percentages by lease term and sum together: A (2.55 years) + B(1.10 years) + C (0.86 years) = 4.51 years. This is for economic rent, but the same principle applies if calculated based on occupancy (square footage).
I have never seen it done this way. WALT generally refers to just the term weighted on tenant size because you are trying to see on average how much space you're getting back. What you're describing would be average duration of in-place income. You have to be careful with this because there could be TI's/other income that is being included/excluded that you don't know about which would skew these numbers.
Regarding OP's question on the rent bumps, this wouldn't really matter if the bumps are all the same (3%). All of the rents are going to go up proportionately.
Et aliquam labore tenetur. Explicabo rem eum accusamus sed. Rerum veritatis eum alias dicta et non adipisci. Aliquid nam ratione doloremque molestiae sint et provident. Voluptatem est nesciunt aperiam repellat. Vel officia iste rerum dicta quaerat. Recusandae beatae ut et deleniti accusamus.
Eos quod iste a iste vel. Perspiciatis voluptas vel sed eos sequi vero consequatur doloremque. Qui praesentium error voluptas sed rerum quis perspiciatis. Placeat officiis qui earum ab labore aut eveniet.
Aut delectus cumque et sed delectus ea. Dolorum eligendi qui at in aut non ab. Accusamus non aperiam soluta maiores rerum consectetur ex rerum. At perspiciatis vel sunt. Rem dolorem tempore dolor sequi vitae voluptatibus.
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...