MichaelBluejay
MichaelBluejay
  • Threads: 87
  • Posts: 1706
Joined: Sep 17, 2010
April 22nd, 2023 at 1:17:59 AM permalink
(Not sure whether this category or "Off-Topic" was more appropriate. I mean, this is math-related, Math is also under "Q&A", so I'm not sure if this qualifies.)

Anyway, I made a Google Spreadsheet to compare the return on renting out a property vs. selling it and investing the proceeds.

I won't be surprised if there are some errors. I'm posting to invite peer-review.
I run Easy Vegas ( https://easy.vegas )
ThatDonGuy
ThatDonGuy
  • Threads: 123
  • Posts: 6747
Joined: Jun 22, 2011
April 22nd, 2023 at 7:56:54 AM permalink
This may not work as intended in California, for two reasons:
One, base property tax is 1%, not 2%, and does not include whatever local taxes might also apply.
Two, the tax cannot exceed 1% of the "tax base value," which is set to the assessed value when the house is sold (I think there is an exception if the house is sold to the owner's children or grandchildren) and goes up 2% per year. I am pretty sure the tax is on the lower of the tax base value and the actual assessed value, but the base value will still go up by 2% of the initial base value.
May I suggest adding a user-entered "property tax rate" column? (You may need two; I have both percentage-based and fixed-value taxes on my property.)
MichaelBluejay
MichaelBluejay
  • Threads: 87
  • Posts: 1706
Joined: Sep 17, 2010
April 22nd, 2023 at 10:09:12 AM permalink
ThatDonGuy, you're always helpful in checking my work about anything I post. I greatly appreciate that.

In this case, you're already able to change the tax amount. The 2% is just a suggestion. The way the calc works, you can change the green items (like property tax), and the blue items are the results. You can actually change the blue items too if you really need to, you'll just get a warning first.
I run Easy Vegas ( https://easy.vegas )
  • Jump to: