Thread: Good Real Estate Spreadsheets

I'm trying to make some spreadsheets that show an investment in numbers with return, expenses, etc that shows a sorta "sweet-spot" on when to sale. Anyone got any they can share or advice on factors other than the normal stuff that I should add to the sheet?

When to sell?

Your strategy should determine when to sell. When you purchase the property you are trying to fix it and sell it or you are trying to rent it. If you are renting then the upside is in the holding long term not selling it. If you are going to hold for a while and then sell just set a time frame and implement your strategy. Trying to time the market is just as hard in real estate as it is in stocks.

Obviously there are a lot of different possibilities and ways you can go but even if the spreadsheet says sell do you have people in there? If so you can't just sell out from under their lease. Unless you have that in the agreement with them and the new owner is aware of this etc etc. Which means just because the sheet says sell it could be a lot harder than that.

I prefer doing your figuring from the front end...ie what is the price I can pay and be able to make money on a sale or cash flow the property. XXXX is the profit I want minus repair cost and expenses = this is what I can pay. This way you are always good on the sale at any time.

i use this model for basic underwriting. these numbers are merely placeholders for reference.

I'd like something complex that takes in all kinds of factors like capital gains, rental income, a couple economy variations, occupancy variations, etc. I've seen them in the past that show a best case worst case scenario. I'm gonna start tinkering monday. Y'all let me know if you have any you can share.

it sounds like what you need is a model for your exists, which is a totally custom spreadsheet. If you aren't good with excel, just find an analyst or someone who is and explain to them your variables.

^ Is that model the one used in Fidelity Agent Pro?

You must be reading my mind, I need one as well.

Originally Posted by BogeyBoy82

I'm trying to make some spreadsheets that show an investment in numbers with return, expenses, etc that shows a sorta "sweet-spot" on when to sale. Anyone got any they can share or advice on factors other than the normal stuff that I should add to the sheet?

If y'all post up some samples of what y'all are using or provide editable copies it would be much appreciated. This is for personal stuff not going to be using this to make money for anyone but the fam.

Originally Posted by BogeyBoy82

I'm trying to make some spreadsheets that show an investment in numbers with return, expenses, etc that shows a sorta "sweet-spot" on when to sale. Anyone got any they can share or advice on factors other than the normal stuff that I should add to the sheet?

The one I am working on right now has 29 tabs, the longest of which has nearly 1,100 rows and about 90 columns. Don't you suppose you should be a little more specific about what you want?

Ok, am I missing something? Are you guys saying that a spreadsheet is going to be able to tell you when you should sell a property? Somebody help me out here....