Real Estate Investing Model CF Opex
- 05:35
Calculate the expense reimbursement in cash flow statement
Transcript
The next section of the cash flow statement are the expense reimbursements. These are actual income flows into the landlord or building owner. However, we can't calculate those until we have the operating expenditures calculated. So the next thing we will do is calculate the operating expenditures. We've already done some of the work on the calcs, so we will link to the common area maintenance expenditures on the Calcs page, and that is 31 cents per square foot. This is a monthly charge. However, it is again still in actual dollars and we need to put this in thousands of dollars. So we're gonna take the monthly expenditure and divide by 1,000 and then multiply by the net leaseable area, the total net leaseable area, and that's going to get anchored because it won't change. Once we have that, we can move on to the CAM utilities. The last thing I need to do here is actually flip this to the negative, so that my expenses show up as a negative because this is a cash flow statement and expenses do need to show up as a negative on cash flow statements. This formula is not copyable because we have the row in between each expense for the increase. So we're gonna have to do this the old-fashioned way, which is line by line. Next is the CAM utilities divided by 1,000 times the net leaseable area, and that's a cell we also might want to name perhaps in another model, so that we can just reference the named cell as opposed to having to absolute reference the linked cell. The insurance is going to be equal to the insurance cost per square foot divided by 1,000 times the net leaseable area, times negative one. And the same thing for repairs and maintenance divided by 1,000 times the net leaseable area anchored, going re-anchor this cell as well, times negative one. And now property taxes are going to be not driven by net leaseable area, but they're gonna be driven instead by the property value. So we have a monthly property tax assessment here of 2/10 of a percent. Technically, in terms of cash flows, property taxes are not paid every month. They're paid typically on a schedule, quarterly, semi-annually, perhaps annually. But in order to do this in the most easy way for demonstration purposes, we are going to essentially accrue them each month. So what we'll do here is we'll take the property tax as a monthly percentage and multiply it by the building value, which is on deal terms page. And that is effectively the purchase price and the taxes will go up a little bit each year based on that. And I'm gonna anchor the deal terms price. I know it's possible depending on the location that the building will be assessed every year or perhaps not. So that's just more of a function of where the asset is. And this, of course, is going to be also a negative. Property management fee is next. And this is the fee that is paid either to the owner or landlord if they're the property manager or perhaps it could be paid to a third party. And that's going to be based according to our assumptions on the gross potential rent. So this 1% is going to be applied to the gross potential rent. And this is actually gonna be copyable because the next assumption is also based on GPR. So what we wanna do is we want to let the rows float and anchor the column and then we wanna anchor that to the gross potential revenue where we wanna anchor the row and let the column float, multiplied by negative one. And then we should be able to copy that down correctly so that we pick up the other non-reimbursable expenses. And what I mean by that are that even for triple net leases, which do tend to cover all of the expenses, there are always going to be some expenses that are non-reimbursable. For example, if the building owner has to hire lawyers to handle a situation or the accountants to handle the audits, a lot of those expenses are not gonna be passed along because they're for the owner's purpose, meaning they're for the owner to present to the shareholders. So even in a triple net lease, fully triple net lease building, there are always gonna be some expenses that are non-reimbursable. We can add these up to get our total other income or expense in this situation. And that is now something we can copy across to the end of the model. And it looks as though everything has copied correctly and we'll just see if we're picking up our increases in month 13 and we are, so that gives me good reason to believe that we've done that correctly.