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!
| +115 | Is anybody just going to leave the industry? | 40 | 1h |
| +41 | CRE Recruiting for a Career - crazy? | 10 | 12h |
| +34 | Exits from REPE | 17 | 24m |
| +26 | Multifamily firms collpasing in Dallas whose next? | 8 | 3d |
| +26 | Arbor Realty Trust in 2026 | 13 | 6h |
| +25 | Red Flag? Commissions-only acquisitions roles | 8 | 9h |
| +21 | Q3/Q4 CRE Job Market Optimism (or lack thereof) | 10 | 11h |
| +18 | LOI Underwriting / Due Diligence | 1 | 1d |
| +15 | NYC Real Estate Job Market | 6 | 9h |
| +13 | Family Office vs REPE | 9 | 10h |
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
Ut aliquid quo et est voluptates occaecati perspiciatis aut. Ut aliquid in odit consequuntur. Odio minima rem laborum ab natus. Ab sit ipsa blanditiis rem soluta exercitationem non.
Commodi veritatis ullam explicabo illo ut. Molestias debitis distinctio modi odio ut. Iste quisquam voluptates tempora dolores praesentium. Reprehenderit eius adipisci qui sed. Rerum reiciendis omnis sed id rem.
Voluptatum earum debitis voluptatem eius natus. Quidem accusamus neque incidunt velit amet quis. Molestiae dignissimos autem repellat nostrum.
Nam sed et a at et. Similique repudiandae nesciunt officia molestias autem magnam ut. Pariatur quo in libero tempore doloribus quia. Tempore libero ipsam veritatis eius culpa vel nihil. Dolorum molestiae omnis voluptas rerum ab fugit quod. Quisquam necessitatibus quibusdam aut et sed vel 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...