How do I do it?

The concept of the four square analysis is to break up each section into the four squares. Complete each Square individually and specifically in order. Then you should be able to complete your 4 square cash flow analysis.

 

The four sections comprised of Income, expenses, cash flow, And cash on cash return on investment.

 

The intent is for a simple break down an overview of how to run the numbers to determine is this as a rental property that will meet your needs

Section 1: Income

In the first section, income, this is where you will include all of the areas in which you will make money. The first value, Rental income is a majority of where you will get your rental income and more than likely the only input that will be included. This field is for the amount of monthly rental income that your tenant is paying you.

 

You’ll notice the next options include laundry income, storage income, and miscellaneous income.  these types of income exist but are just generally not as widely used within the Baltimore City area.

 

Once you add it all of the  areas in which you will receive income for your rental property, you’ll notice at the very bottom of the section income, the sum total will be displayed:  Total Monthly Income.

 

This value represents the amount of total gross income you will receive each month Before removing  expenses, taxes, Etc.

 

You’ll notice the next options include laundry income, storage income, and miscellaneous income.  these types of income exist but are just generally not as widely used within the Baltimore City area.

 

Once you add it all of the  areas in which you will receive income for your rental property, you’ll notice at the very bottom of the section income, the sum total will be displayed:  Total Monthly Income.

 

This value represents the amount of total gross income you will receive each month Before removing  expenses, taxes, Etc.

Section 2: Expenses

Within the expenses section, this is quite literally where we add all of our expenses. Keep in mind our expenses are consistent  but not direct every single month. Consistently we will have each of these expenses that we need to track. These expenses while consistent, does not mean that they actually leave your account every single month.  I like to view these as indirectly, expenses that occur however do not  force you to pay every single month.


Consistent Direct Expenses:  Are the PITI expenses:  Principal, Interest, taxes and Insurance.  within the expenses section of this 4 squares machine, you’ll notice is broken up into three different fields:  Mortgage, Taxes and Insurance.  Mortgage being the combination of principal and interest.

The next fields are Water/Sewer and Garbage.  In our Market in Baltimore City, Maryland,  we like to have Standard Market Value rent  and state that utilities are not include.  this means that our tenants must pay for the utilities themselves.  Therefore if I were to use the spreadsheet, every single property  would have $0 in the field for Water/Sewer Expenses. 

There might be some landlords that decide to pay that separately. 

 

Similarly, Garbage  is not an expense we incur in Baltimore City, Maryland. They’re 4 Hour field contains the value $0  each month.

 

Consistent InDirect Expenses:  these are the expenses that may not occur every single month however you need to plan for when they occur. It will always be “when”, not “if”.  it is only a matter of time for these expenses to occur.  for example first on our list is vacancy. At some point,  whether we like it or not there will be some form of turnover. Turnover is when the tenant leaves and there is a gap in service while we search for another tenant.  whether that is a matter of days weeks or months, we need to make sure that we capture some form of reserves for vacancy.

 

Similarly both repairs and capital expenditures are indirect expenses that may not happen every single month. To ensure we have a safety net and a certain amount of disposable income for when that repair or capital expenditure occurs, we will be ready to pay the bill. There’s nothing more stressful than having a maintenance or capital expenditure expense without having the funds  required. 

 

 the market can go up and down, and it doesn’t matter if you’re underwater as long as  you have enough cash to be able to pay for all these expenses.  This is the most important thing when acquiring rental properties, ensuring that you accurately list  and value your expenses to ensure you have the appropriate cash flow and Reserves to pay in the darkest of times.

 

 the property management fee is another fee that may or may not occur every month. Consistently it should occur as you should have a tenant in your property. This be depending upon the property management company in your Market, will range from 8% – 10%.  this is a negotiable expense especially depending upon how many properties you have with the property management company. For example with our property management company, the moment you have three properties all being managed by the same property management company, they will decrease the monthly property management fee from 10% to 8%.

 

 there are probably management companies that do not require a fee if the property is vacant for a certain number of months. Be sure to connect with your property management company and ask them this question especially if you are in the interview case and determining which property management company you want to work with.

Section 3: Cash Flow

This section is fairly straightforward only cash flow.  We are literally taking Section 1 and section 2 and putting those numbers together.

 Section 1 includes your  total monthly income. We’ll take that value of your total monthly income and  included in the cash flow section. Well then do the same 4 section 2 which is your total monthly expenses and include that number in the cash flow section.

 once you subtract your total monthly expenses from your total monthly income, will then have your total monthly cash flow.

This is the estimated real monthly cash-flow that you receive  every single month.

 yeah, there will be months where your cash flow is greater than this amount this is because of those indirect expenses. Should you not have any vacancy, any repairs, or any Capital expenditures,  This means that that additional money that was allocated to that category oh, well therefore be added to your account. 

 I mentioned above real monthly cash-flow, because Dad is in net income that you are receiving.  The additional funds of your indirect expense should not be considered as real cash flow but as your Phantom cash flow. It’s there and in your account but it’s only a matter of time before it leaves  Your account.  as we mentioned above, if not now if not next month then in a few months time being, only a matter of time, will you have a repair that requires you to take funds in order to pay.

 

At the bottom of the cash flow section you’ll notice we have another field called: Total Annual Cash Flow.  this field here is the annual cash flow. You’ll notice that we took the monthly cash-flow and multiplied it by 12 to get to your Total Annual Cash Flow. This number we’ll be using in the next section.

Section 4: Cash on Cash (ROI)

Cash on cash return on investment is one of your two most important numbers. This amount tells us how hard I were money is working for us. After initial total investment ( total amount of money that we have in the deal),  what is the annual cash flow that we are receiving and then we get percentage. That percentage is our cash on cash return on investment.

 

 how do we get our cash on cash return on investment? Will need to follow the formula:

 

 annual cash flow

_______________

 total investment

 

Once we have that number then we multiply it by 100 to get our percentage.

 

To get our annual cash flow we simply take the number that we figure it out in the previous section: Total annual cash flow found in Section 3 Cash Flow. 

 

To caps your total investment will need some additional numbers. We’ll  need to compile the following:

  1. Down Payment 
  2. Closing Costs
  3. Rehab Budget
  4. Misc Other

 

Upon adding all of the above numbers together we’ll be left with our total investment to be able to input into the formula provided.

 

Once we have our cash on cash return on investments, we have successfully completed the Foursquare rental analysis spreadsheet and should be that much more comfortable and being able to make a data-driven decision.

Should I use this to analyze every property?

No, you should not!

This calculator is specifically for Rental Properties. If you plan to flip a property (buy and sell), then you should not be using this 

If you are attempting to analyze a rental property, consider the properties that don’t pass the 1% rule.

Properties that are outside your farm area or high in crime

Once they pass your initial criteria then you’re good to go!

Also keep in mind this is not a calculator for the BRRR process. This calculator is meant for simple TurnKey deals to calculate the necessary financials.



Similar Posts