Forum Discussion
=IF Real Estate Financial Modeling
I'm modeling out a cash flow statement for a real estate transaction. There are several tenants on the current rent roll but each has leases expiring at different times in the next few years. The rents are significantly below market and the owner intends on raising them once the current lease is up.
How do I reflect this on the monthly cash flow statement?
So far, I've created a tab with the months remaining on each lease. I used the =IF formula like this: =IF(Months Remaining>Current Month, Current Rent). This works for a single tenant but I'd like to be able to take the sum of the current rents.
Any idea how?
1 Reply
With your permission, I recommend to provide more information.
You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.
I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.
Don't forget that not every Excel user has a clue about every job and what you see he can't see.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
Thank you for your understanding and patience
I know I don't know anything (Socrates)
