We are a married couple filing jointly, mid 40s, zero dependents. Live in a inner NE Portland, OR single-family-housing neighborhood.
We currently live in a very small (700 sqft) house. With the COVIDs, we are WFH, and we have decided H is too small. We are either going to build an addition, or move. I am wondering what MMM community thinks of the economics of our addition.
I have built up a spreadsheet to calculate the "real expected cost" of living in various homes. Our current home (headed "current"), our addition ("addition"), and a few other homes. I am not very confident in my calculations. Basically, I added up the yearly costs of living in the home. I included utilities, opportunity cost of equity, expected future revenue from home appreciation, and the cost of selling the home after ten years (by which time we hope to be retired, and move out of the city.) I modeled the cost of selling as the sum of realtor fees, paying ourselves back for our down payment, paying the mortgage off, less the sale value of the home.
For some of the homes I have specifically entered our principal outstanding, since we have an actual mortgage on our current home and a rental home in Helena. The others assume a 20% down payment.
Summarizing, I think the addition will cost about $220k +/-$20k, and add about $150k-$250k in value to the house. We estimate the cost of moving at about $50k, of which $20k are realtor fees, $10k is anticipated inefficiency (e.g. overlapping mortgages, or temporary housing costs) and $20k is lost wages due to disruption. (E.g. if we spend 150 hours packing and moving, that is time we could have spent either working or otherwise living our lives.)
Does my spreadsheet look basically OK? (
https://docs.google.com/spreadsheets/d/1_kYzfHcS_PRk40_cZH7f9c48_u1cP8WaiAWAVSGaaGw/edit?usp=sharing, screenshot attached). If it looks OK, what do you think could be modeled better?
If you think the spreadsheet is basically accurate, do you think we should build the addition, or move?
I'm a little worried my post may not be up to par, so feedback welcome there too.