Investor · Sarasota, FL · Member since 2008 · 17k+ posts · 17k+ votes
As another test of the new BP file vault, and to give back to the BP community, attached is the spreadsheet I use to evaluate single family house rentals.
In general, the red colored fields are the inputs you probably want to change, and everything is based on those parameters.
If you have any questions, feel free to post them in this thread, and I'll try to answer them...
Please consider this copyrighted by me, though you are free to use it in any way you wish as long as you don't try to profit from it...
I am new to the site and I apologize if it is right in front of me but I can not find the attachment with the spreadsheet. Can you please inform me of where to look?
Palm Harbor, FL · Member since 2015 · 49 posts · 3 votes
11y
I also had a similar question along the lines of depreciation. Do you include this "expense" in your NOI (I think the answer is no?) but do you include this in your CoC calculation as well as your "free cash flow" (your $/month/door true profit)?
also what about calculating federal and (if applicable) state income taxes - I assume this is not part of your NOI but should it be part of your CoC return or monthly free cash flow?
I am still learning so be kind if I am way off basis :)
I also had a similar question along the lines of depreciation. Do you include this "expense" in your NOI (I think the answer is no?) but do you include this in your CoC calculation as well as your "free cash flow" (your $/month/door true profit)?
also what about calculating federal and (if applicable) state income taxes - I assume this is not part of your NOI but should it be part of your CoC return or monthly free cash flow?
I am still learning so be kind if I am way off basis :)
Tax implications are typically not included in the cash flow number -- they are figured below the cash flow line. The reason being that everyone will have different tax implications on their cash flow, and even the same person may very well have different tax implications in different years.
Palm Harbor, FL · Member since 2015 · 49 posts · 3 votes
11y
OK sounds good on the income tax question.
What about depreciation? Should that influence NOI or free cashflow?
Also, why do some people include Vacancy in the Operating Expenses ? (in my mind, It is potential Income but you aren't having to "pay out" the same as when your utility bill comes every month)
What about depreciation? Should that influence NOI or free cashflow?
Also, why do some people include Vacancy in the Operating Expenses ? (in my mind, It is potential Income but you aren't having to "pay out" the same as when your utility bill comes every month)
Depreciation is a tax benefit...and it's recaptured at sale. So, it is not factored into the cash flow.
Vacancy is not an expense. Vacancy (including rent loss and concessions) is deducted from "Gross Income" to get "Gross Operating Income." Expenses are then deducted from Gross Operating Income to get "Net Operating Income". From there, you can subtract debt service and capex to get "Cash Flow" (or "Cash Flow Before Taxes" as some would call it).
That said, some people around here (myself included) will generally say "Expenses" when we mean "Vacancy/Rent Loss, Expenses and CapEx". From and accounting standpoint, this is incorrect (since neither vacancy nor capex are really expenses), but it makes some of the ratios (like the 50% Rule) easier to calculate.
do you treat them as income and then as an expense when (possibly partially) paid out?
If you're using Quickbooks or a similar accounting program, you'll categorize each of your transactions. Deposits of rent would be considered income. Payments for expenses would be categorized based on the type of expense -- for example, it might be categorized as "Expense" or it might be categorized as "Fixed Asset" (for anything that needs to be added to the basis and/or depreciated).
I'm sorry. I meant "Security Deposits" (separate from rent )
I record it as a General Journal Entry in Quickbooks, with one side of the transaction being a deposit to a bank account and the other side being a credit against an "Other Current Liability" account called "Security Deposits".
Accountant · Richboro - Philadelphia, PA · Member since 2008 · 901 posts · 246 votes
11y
In addition to answers:
-- Income is when you consider money received as revenue
-- Deposits received should be considered as a Other Current Liability
-- Money paid out could be Expenses, Cost of Goods Sold, Fixed Asset, Other Asset, Other Current Asset, Other Current Liability, Long Term Liability or an Equity Account
It all depends why you paid money, does it increase the value of your property, return a debt or .....
Investor · Humble, TX · Member since 2015 · 73 posts · 4 votes
11y
Hello, I am very new to this as I am here trying to evaluate properties. Can you please explain in detail what these mean ?
I see CF & ROI (Outsourced PM) and CF & ROI (Doing my own) What does these tell me ?
-Variable Cost PM
-Fixed Cost Pm
-What number do I input in these boxes ?
For Vacancy I am putting 8%
-For instance I see Insurance Annual ...on the RED do I put how much it will cost yearly for home insurance of property?
What are some Fixed numbers that I can leave on this spreadsheet that can provide me with somewhat accurate data ? I want to be able to see the total cash flow that each property I input in spreadsheet.
Hello, I am very new to this as I am here trying to evaluate properties. Can you please explain in detail what these mean ?
I see CF & ROI (Outsourced PM) and CF & ROI (Doing my own) What does these tell me ?
-Variable Cost PM
-Fixed Cost Pm
-What number do I input in these boxes ?
For Vacancy I am putting 8%
-For instance I see Insurance Annual ...on the RED do I put how much it will cost yearly for home insurance of property?
What are some Fixed numbers that I can leave on this spreadsheet that can provide me with somewhat accurate data ? I want to be able to see the total cash flow that each property I input in spreadsheet.
Investor · Humble, TX · Member since 2015 · 73 posts · 4 votes
11y
Thanks @Jscott
I knew some of the answers, but after doing some analysis on properties my number were wrong compared to others so I kept on questioning my numbers. I finally found the error. Thanks for the link. It helps very much !
Atlanta, GA · Member since 2015 · 2 posts · 0 votes
11y
HI all,
Sorry, I am new so this may certainly be my problem. I have gone back to the links reposted on pages 2 and 3 that seemed to work in the past and am not able to find the download location for this file. Would love to have this spreadsheet. If anyone has an active link to this spreadsheet can you repost? Sounds like just what I need. ..