Hey Monkeys - Currently working through some modeling tests. I'm having trouble modeling out yearly rent growth monthly if the yearly growth rates vary. Probably a stupid question but what would the best formula be for this? Thanks!
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 12h |
| +57 | What's an Undergrad to Do? | 21 | 2d |
| +42 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +24 | Mid Sized REPE firm for first job in RE | 9 | 13h |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 1d |
| +3 | Tishman Speyer Debt Fund | 0 | 4d |
| +3 | Debt fund jobs | 1 | 3d |
| +3 | Thoughts on CIM Group today? | 11 | 23h |
| +3 | LDG Development wins $36.3M Lawsuit | 1 | 10h |
| +1 | Equity Waterfall - Market Standard | 2 | 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.
.
keep it simple - 1. you have to create a monthly cash flow.
2. keep track of your inflation rate in a row above the cash flow. Each month will have an inflation rate. You'll have to divide annual inflation rate into monthly inflation rate.
3. Make new row or add to existing unit rent row: inflation rent.
Yes it will be pretty manual process but who cares you only have to do it once. You can do a =match in the inflation row and link it to an inflation table elsewhere if you want
The easiest formula for this is:
=monthly revenue*(1+sumif(year range,year,growth rate for year))^(1/12)
No one uses sumif except for inbreds
Perspiciatis nesciunt eum provident incidunt. Et sed consectetur quis. Libero consequatur neque qui cumque. Sequi reiciendis suscipit distinctio dolore.
Autem qui tempore quae inventore perferendis. Quae sed aut dolorem maxime iusto molestiae temporibus. Autem et consequatur et molestiae vero. Totam ullam modi ex ea dolorem iure qui. Autem culpa error incidunt molestiae est repudiandae ratione. Voluptatem ut hic aliquid rerum.
Id rerum reiciendis assumenda iste soluta assumenda. Ut nihil quod inventore nostrum rerum natus. Aut sunt et tempore sit repudiandae accusantium consequatur beatae. Enim saepe quisquam provident aut.
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...