I last posted a spending update almost two years ago, so it seems like time to do another one. We're still living in Somerville, with housemates and tenants. At the beginning of this period we were out of our house for several months because we were adding dormers, which we finished a bit over a year ago. With the extra space, we're now able to have an au pair, plus Anna isn't sleeping in our bedroom anymore.

In terms of accounting, we've switched from tracking everything via spreadsheets to using a mix of spreadsheets and Mint. Mint can pull transactions directly from our bank account and credit cards, which means we're much less likely to accidentally skip something. On the other hand, it's easier for things to be incorrectly categorized and harder to annotate transactions carefully or write custom logic. Now we're categorizing every transaction in Mint, and then additionally using spreadsheets as needed. Currently that's keeping track of allowance spending, where we want to keep to a specific budget that accumulates if unspent, and keeping track of things for taxes (house spending, contra dance musicianing).

We started using Mint on 2017-05-01, so I'll look at things on a one year basis from there, and then correct in places where this isn't accurate. For housing I'll use a completely different approach, where I amoritize all large expenses over 30 years and treat them as if we'd financed them along side our mortgage. [1]

• Housing: $2,750/month
  • One time expenses (all time)
    • Purchase and all one-time expenses included last time: $915k
    • Adding dormers: $110k
    • Replacing front porch: $18k
    • Ceiling soundproofing: $1.8k
    • Partitioning home office: $900
    • Replacing garden wall: $700
    • Installing sump: $300
    • Other: $10k
  • Ongoing expenses, all whole-house (including tenants' unit):
    • Other: $550/month
    • Electricity: $300/month
    • Water/Sewer: $150/month
    • Gas (Heat): $150/month
  • Rent income: $4.2k/month
• Kids:
  • Childcare: $20.4k ($81/day; $41/kid-day)
    • Most of this is an au pair, with occasional payments to other people for babysitting.
  • Gear/nursery: $0.5k ($20/kid-month)
  • Other: $210 ($9/kid-month)
  • Clothes: $103 ($4/kid-month, but some kid clothes were hand-me-downs and some came out of Julia's allowance)
• Taxes
  • Income tax: $1.4k/month
  • State tax: $1.1k/month
  • Social Security tax: $1.3k/month
  • Medicare tax: $350/month
• Retirement: $1.5k/month (401k)
• Personal: $480/month ($55/week each, for entertainment, clothes, etc)
• Medical: $950/month (excludes portion work paid)
• Donations: $11.8k/month (50% of 2017 income)
• Loan Interest: $160/month (pulling some donations ahead a year)
• Food: $750/month ($250/adult, $150/person)
• Transportation: $77/month
  • Some MBTA, some Uber, some car rental, some gas for borrowed cars. I have a T-pass covered by my work, which would cost $89/month if we paid for it.
• Vacation: $3k (we went to Puerto Rico in March with Julia's family)
• Other: $83/month

In simple form, monthly numbers:

Donations	$11,800
Taxes	$4,150
Housing	$2,750
Childcare	$1,700
Retirement	$1,500
Medical	$950
Food	$750
Personal	$480
Vacation	$250
Interest	$160
Other	$230

And as a chart:

Comparing with last time, still all monthly numbers:

Donations $12,200 → $11,800

Still 50% of income, but I earned less because I spent part of the year at a startup and part of the year unemployed

Taxes $4,140 → $4,150

Taxes went up slightly because more of our rental income is taxable, because with the dormers more of our house is occupied by us instead of people who pay us rent.

Housing $2,230 → $2,750

Most of this increase is the cost of adding dormers, porch, etc, which I'm amortizing over 30 years. [2] Some of it is also that in the previous period I didn't yet have good estimates for utilities and lowballed all of them significantly. Our utilities are slightly lower than they were in 2016. We also take in more in rent than we did then, which makes this increase smaller than it would be.

Childcare $3,470 → $1,700

The big decrease here comes from switching to an au pair. But some of that is offset by higher housing and food costs. Say they're 25% of our spending here (one of four bedrooms, one of four people eating if you count the kids as halves) then $1,700 becomes $2,500, which is still very good for two kids in this area.

Retirement $1,500 → $1,500

Still taking the full pre-tax allowed amount.

Medical $370 → $950

My employer's costs have gone up, and we're paying a perecentage of that. Plus we had some months where we paid full price for private insurance when I was unemployed.

Food $230 → $750

Some of this is an extra adult (au pair), some is that the kids are eating more, and some is that Mint is probably doing a better job keeping us from excluding things accidentally, but I also think we've shifted to somewhat more expensive food.

Personal $390 → $480

We raised our allowance budgets from $45/week to $55/week.

Vacation $0 → $250

Previously we'd generally paid for vacations out of our personal spending budgets, and done pretty cheap things. We decided that this was something we wanted to spend a bit more on as a family, and not trade it off explicitly against day to day self-spending.

[1] This is the same thing I did (last time): treat one-time expenses as if we had financed them as part of the same 30-year fixed rate mortgage we used to buy the house, add in ongoing expenses, and subtract rent payments from tenants and housemates. The idea is, the house cost $800k with a $600k mortgage, and our mortgage payment is $3,600/month. The mortgage payment includes $700/month of property taxes and insurance, so set that aside and we have $2,900/month. Comparing the mortgage amount to the monthly payment, for every $1000 of one-time expense you can think of there as being a $4.83 monthly payment. The down payment ($200k) and other one-time expenses ($255k) bring this imaginary mortgage from $600k to $1M and would give a mortgage payment of $5,100 for the whole house. Add back in the insurance and property taxes ($700), and $1,150 in other monthly expenses: heat, water, electricity, repairs, etc, and you have $7000 as the monthly cost of the house. Then subtract $4,200 in rent income, leaving $2,750/month.

When I did this last time I didn't subtract off the escrow portion of our mortgage payment and put it back. Doing that instead brings last time's numbers up by $360/month, from $1,870 to $2,230.

[2] As before, not all of this is "real" spending: some of it is effectively investment, since the house will still have value at the end. If you "mark to market" and consider that the area has become much more valuable while we're living here there's a sense in which our housing has actually been nearly free.