Real Estate Investing Model CF NRR
- 04:36
Understand how to calculate the net rental revenues
Glossary
Net Rental Revenues Real Estate Cash FlowTranscript
We are now going to calculate the net rental revenues on the cashflow statement, which will consist of two steps. First, calculating the gross potential revenue from the three different tenants, followed by the adjustments to the gross potential revenue to factor in vacancy, credit loss, and any concessions or free rent. The first thing we will do is take the triple net rent per square foot per month and multiply that times the triple net leased area, which is the 192,000 from cell C9. And that's not going to copy across, so we're going to anchor that. And remember that these dollars per square foot are actual dollars. And the model in order to keep the numbers smaller is using thousands. So we actually have to divide by a thousand to get the proper triple net lease gross potential revenue. And it'll be the same thing for the single net lease. We will take the single net rent per square foot per month in dollars. We can divide that by a thousand first. That's pretty much the same thing. And then multiplying it by the single net leased area, which again is not gonna change since we don't expect the building to grow, and anchor that.
And same thing for the full service leases times the full service gross leased area anchored.
And the sum of those will equal the gross potential revenue, which we can then copy across to the right for six years.
And we should see again, that should increase after the 12th month. And it does. So we have confidence that this is actually working correctly. The next thing we need to do is factor in the vacancy credit loss, concessions and free rent. Now, in general, if we have three tenants as we do and there's no real turnover in these tenants because their leases are basically in place throughout the forecast period, we wouldn't expect really to see a vacancy happen. There also might not be credit loss happening if we have three, again, tenants that are already paying their rent, three large tenants. There also might not be concessions in free rent, which are generally given to new tenants. But because we're basically simplifying things for the purpose of teaching the model, we are just gonna assume that there are some general perhaps overall assumptions about the building that there will be some vacancies, some credit loss, and some concessions and free rent. And that's just, again, to add some realism and to understand how these things are modeled. So the first thing we're going to do is calculate our vacancy. And that's going to be equal to our operating assumption, which is on the operating assumptions tab in C26. And we'll anchor that so that the columns can't move, but the rows can. And this way we can copy this down because all three of these assumptions are based on GPR. So that will be 8% anchored for columns times the gross potential rent above. This is gonna show up as a negative 'cause it's a reduction in our gross potential rent. So I'm gonna flip that to a negative. I also want to, again, since I'm gonna copy down, I wanna anchor the row of my gross potential rent. So that's gonna be anchoring the row in that formula, and I should be able to copy that down. And that does in fact link to my next assumption, which is credit loss. And so I have confidence that that is correct. So my net rental revenue therefore is going to be the gross potential revenue plus the sum of my three adjustments. And I should be able to copy that across now with certainty. And it looks as though I am getting the correct adjustments in line with the gross potential rent adjustments above. So I have confidence, again, in that formula as well.