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?
Pleasant Grove, UT · Member since 2015 · 2 posts · 0 votes
11y
I'm not able to access the file. Is there a link, file etc? I would love to use this information as a basis for getting started in analyzing some properties!
Investor · Sarasota, FL · Member since 2008 · 17k+ posts · 17k+ votes
11y
Hey folks - As I said above, I don't know what happened to the link. You can sign up for my Newsletter on my website as well to get access, and I'll talk to the BP folks and see if we can figure out the link issue...
Hey folks - As I said above, I don't know what happened to the link. You can sign up for my Newsletter on my website as well to get access, and I'll talk to the BP folks and see if we can figure out the link issue...
Jason - none of your fileplace content seems to be present at the time of this post; Google search using the following will show the various files that once were there :
Hey folks - As I said above, I don't know what happened to the link. You can sign up for my Newsletter on my website as well to get access, and I'll talk to the BP folks and see if we can figure out the link issue...
Jason - none of your fileplace content seems to be present at the time of this post; Google search using the following will show the various files that once were there :
site:biggerpockets.com/files/user/JasonScott/file
Wow, I didn't realize they all disappeared...
@Joshua D. - Probably not high priority for the development team, but maybe worth looking into?
I can re-upload, but then there will be a lot of dead links in older posts...
Thank you for the spreadsheet. It is one of the best resources I have found.
However, I'm having difficulty understanding why the Total Cash Flow row (row 41) is always expressed in a positive number. For negative total cash flow, it changes to a positive number for the rest of the calculations. Is there something I am missing?
Edit- from what I'm understanding the parenthesis indicate negative cash flow.
However, I am also wondering why CapEX is not included in these calculations?
Thank you for the spreadsheet. Is there a change that we could make that would enable us to calculate paying the mortgage on a biweekly basis to minimize interest and gain equity faster?
I know this is a relatively old discussion, but the spreadsheet is not available, so need assistance expediting so I can analyze a couple potential deals. Additionally, is this applicable to commercial deals(apartments of 5-10 units) as well? Thanks in advance.
Great Spreadsheet. It really helps to break the process down and make it more digestible. (By the way, you can find a link to it 3 posts up from this one!)
New to Real Estate · Acworth, GA · Member since 2016 · 8 posts · 1 vote
6y
J - I hope this thread is still alive. It has been around for a long time! With respect to your comment:
"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,"
If we wanted to accrue the Capex money, we would account for that in the expense category. Yes? It seems wise to me to do that to try and minimize (as much as possible) any surprises that may blindside us in the near or far future. And from an accounting perspective (I'm not a CPA), I see nothing wrong with it although I do understand how it could skew the 'pure' version of the 50% rule in a very small way. Thoughts?
Also, I notice that in your calculation for "Expenses as a % of Gross Income," you are subtracting the negative number on line 19; Vacancy/Loss Value. For example, in column F on line 34: =(F33-F19)/F17. Should not F19 be an addition in this formula so that you account for its singular value instead of possibly doubling its value by subtracting it twice?