Best Spreadsheet to Analyze the Properties You Own

[Thomas Matthew]

I have four properties: three single family homes and a five plex.

The single family properties have first and second mortgages due to past financial necessities. Therefore they only cash flow a few hundred dollars a month.

The properties have doubled in value over the years. I am thinking of selling the single family homes and paying off the mortgage on the five plex to create a large cash flow.

Is there a spreadsheet or software that can help guide me.

I welcome any thoughts on this.

Thank you

[John Cardinale]

Quote from @Thomas Matthew:

Great questions:

1. First Mortgages 4% fixed 30 years. Second mortgages 9% floating HELOCS

2. I would like to stay in real estate if it makes sense. What could I 1031 exchange into that would do better than having a paid off five plex?

3. I would like to slow down in 5 years. But probably not consider stopping for 10 years.

1) I would be hesitant to pay down mortgages at 4 percent if I knew I would need new mortgages in the near future because the new loans will have higher interest rates.
2) 1031 exchange would allow you to delay payment of capital gains tax indefinitely. It involves you buying a new property to replace what you sold though. DYOR on the details...
3) If you're going to keep going in real estate, maybe it makes sense to sell 1 of your SFH's to pay down on the 9% heloc but not close it out so you still have the flexibility to use it..., but then hold on to the 4 % mortgages where possible since those low rates are now rarities. Any new loans you get will likely be several % higher.

I guess if you sleep better at night with zero debt on your 5plex then maybe that's the best move for your personally. Also, to your point, strike while the iron is hot. If you can double your money on the SFH's then maybe that's your best move. Sounds like you have some good options to pick from.