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!
| +34 | latest on Shorenstein? | 9 | 5h |
| +20 | Probability of S2 recap returning equity | 9 | 1d |
| +20 | To the veterans: What was institutional dev actually like during the last bull run? | 8 | 2d |
| +16 | Development vs. REPE pay gap | 8 | 2d |
| +15 | PGIM Real Estate Equity Opinions? | 10 | 9h |
| +14 | How do I break into a family office role | 3 | 16h |
| +12 | MBA Pipelines for REPE | 10 | 11h |
| +12 | Reneging - What should I do? | 5 | 3d |
| +12 | Opportunistic Equity Acquisition Associate Role - Middle Market REPE | 1 | 14h |
| +11 | PRE MBA IB back to IB | 5 | 3d |
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
Ad voluptates iste voluptate. Quasi a ut beatae corrupti ea quos a dolor. Consequatur temporibus soluta ratione sit officiis autem aut.
Aut praesentium necessitatibus odit unde culpa qui. Et temporibus ad veniam et dolorum nobis quibusdam. Nihil ducimus esse recusandae veritatis. Voluptatem necessitatibus et doloremque ab inventore ullam. Rem et eos aliquid dolorem aut distinctio omnis magni.
Voluptas delectus optio magnam eos itaque et sint. Nostrum deleniti dolores reiciendis architecto velit. Ut debitis non rerum earum sed. Unde tempore dolorem odit possimus ut corporis sed. Cumque error non nostrum autem.
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...