Modeling Growth
How would you model rent growth to only hit specific years in a model? Or to say only have the growth hit every 2/3/5 years etc.....
Trending Content - Real Estate Forum
| +42 | CRE Recruiting for a Career - crazy? | 10 | 2d |
| +39 | Exits from REPE | 22 | 18m |
| +27 | Multifamily firms collpasing in Dallas whose next? | 8 | 4d |
| +27 | Arbor Realty Trust in 2026 | 13 | 1d |
| +26 | LOI Underwriting / Due Diligence | 6 | 19h |
| +26 | Red Flag? Commissions-only acquisitions roles | 8 | 1d |
| +15 | NYC Real Estate Job Market | 6 | 1d |
| +13 | Family Office vs REPE | 9 | 1d |
| +12 | Do REPE SA/VP/Dir expect base/bonus bump annually or is 'bump' inherent in carry? | 2 | 2d |
| +11 | Eastdil Coffee Chat Advise | 5 | 2h |
Career Resources
The answer to your question seems really obvious, so much so I'm pretty sure I'm missing your actual question.
Are you asking physically how do you put that formula in excel or Argus? Or something else?
Yes, sorry for oversimplifying the question. What would be the formula in excel to only apply growth to those specific years?
Look up function that corresponds to a growth table, better off just manually entering it.
Growth table useful for modeling different case years: bear, bull, zero
Depending on time/optionality I expect to need I would probably just hardcode a rent growth table and have new leases mark to that.
If you want a lot of optionality I've done if statements like: if(MOD, proforma year, rent growth years)=0,rent growth * old market rent,old market rent * 1)
You set up a rent growth table using that and it checks year proforma year to see if its a multiple of whatever period of time between rent growth you want (2/3/5 whatever). MOD returns the remainder of a/b so if its lease year 5 and you want to grow market rent every 5 years the remainder would be zero and the formula would return TRUE on years 5 and 10 but not any other year.
Sorry for shit explanation
If you're working with Argus you just go into Market Rent inflation table and manually enter inflation in the years you want it and zeros in the years you dont.
Nested IF( statement if,year1,x%growth, if year2,y% growth, if year 3, z%growth. then end with brackets
Et voluptates eius enim aliquid. Consequatur ipsum maiores distinctio. Molestiae ratione alias et nostrum architecto occaecati qui.
Consequatur aliquam eligendi at aut sapiente id provident. Accusantium et quos voluptatem voluptatibus eum expedita amet. Ex facilis est incidunt.
Soluta eligendi debitis mollitia non dolorem necessitatibus. Occaecati sequi animi nemo et et quo et. Asperiores quo perspiciatis eum qui. Ratione porro voluptatem voluptatem rerum repellendus excepturi ut. Qui ea ad quia et aut. Reiciendis et debitis adipisci voluptate et facilis totam non. Voluptatum cumque consectetur ut itaque sit.
Sed in explicabo et quam eum est odio. Blanditiis dolores et illo saepe quae nostrum natus laudantium. Voluptatem saepe perspiciatis sunt consectetur dicta iusto.
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...