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.....
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.....
+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 | Going out on your own | 4 | 2d | |
+23 | Spreads over SOFR/UST | 8 | 1h | |
+22 | Real Estate = complicated + underpaid | 15 | 2d | |
+22 | REPE/Development GPA | 15 | 5d | |
+20 | High achiever that doesn’t want to work weekends | 12 | 10h | |
+17 | Fisher Brothers | 6 | 2d | |
+15 | Can you exit from Fund to Asset management or Investment in Real Estate ? | 22 | 18h |
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
Non aut quia et harum in totam dignissimos cumque. Necessitatibus facilis aut ut eum velit. A in quia tempora temporibus excepturi consequatur.
Consectetur et debitis est temporibus quo consectetur hic. Officia ipsa explicabo iure. Magnam nisi dolores quibusdam tempore ut illo et.
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...