QUOTE(qwex @ 4-5-07, 11:33am)

I tried putting together a rent vs buy spreadsheet and ended up quite confused
Yep, there's a LOT to consider. Let's start off with some simplifying assumptions. I'm not saying these are realistic, but they'll help you get a handle on the problem, and then you can add things back in later:
- Assume you're paying cash for a house (no mortgage).
- Assume equivalent houses for renting/buying.
- Assume the house's value stays exactly the same for all time.
- Assume that utilities are in addition to any rent paid (ie - ignore utilities for comparison).
So if you buy the house...
- You pay $X for the house up-front.
- You get $X for the house when you sell it at the end.
- You pay roughly 3%-4% of $X in closing costs up front.
- You pay $TAX monthly property taxes.
And if you rent...
The cost to live somewhere for NUM_MONTHS months would be:
- Buying: (0.04)X + (NUM_MONTHS * TAX)
- Renting: (NUM_MONTHS * Y)