9 ms·
Here, I made a spreadsheet of the whole thing. https://spreadsheets.google.com/ccc?key=0AnuVSPZl-I22dHBiRmxQSmVfdjNfUjR6WjBSXzR6TUE&hl=en&authkey=CJnWwvYK http
by dnautics 16y ago
Here, I made a spreadsheet of the whole thing.
https://spreadsheets.google.com/ccc?key=0AnuVSPZl-I22dHBiRmxQSmVfdjNfUjR6WjBSXzR6TUE&hl=en&authkey=CJnWwvYK https://spreadsheets.google.com/ccc?key=0AnuVSPZl-I22dHBiRmx...
In the deflation scenario, even though the house has lost nominal value from $200k to $27k, our family spent only a total of 8 years in debt and, amazingly, at the outset of 20 years accumulated 2 millions dollars in real (year 0) value.
In the inflation scenario, although the house has gained nominal value from $200k to $1M, our family spent all those years in debt. Towards the last 8 years, the appreciating nominal value of the home was no longer able to suffice as an investment to counter the loss of spending power, and the family wound up in the hole... 100k in (year 0) value. There was only one year that cashing out on the house would have made nominal sense (year 1) and even so, that represented a net real value loss.
Hell, I was a nice banker and didn't charge interest on the bank debt.
(update: I threw in wage inflation, too, lagged it behind half a year). Now things are looking a bit better for our scrappy family and they come out at the end with a real net worth that's only down about 9k in year zero dollars. But at least they're not in the hole! Of course, that 9k can also be thought as 54k, or probably better, a quarter of the the year's wage.