• Posts
  • RSS
  • ◂◂RSS
  • Contact

  • Spending Update 2018

    May 14th, 2018
    money  [html]
    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.

    Comment via: google plus, facebook

    Recent posts on blogs I like:

    What I've been doing instead of writing

    I’ve been too busy with work to write much recently, but in lieu of that, here’s a batch of links to other stuff I’ve been doing elsewhere. The thing I’m most excited about: Wave raises $200m from Sequoia, Stripe, Founders Fund and Ribbit at a $1.7b valuati…

    via benkuhn.net September 11, 2021

    Some reasons to measure

    A question I get asked with some frequency is: why bother measuring X, why not build something instead? More bluntly, in a recent conversation with a newsletter author, his comment on some future measurement projects I wanted to do (in the same vein as ot…

    via Posts on Dan Luu August 27, 2021

    Songs about terrible relationships

    [Spoilers for several old musicals.] TV Tropes lists dozens of examples of the “I want” song (where the hero of a musical sings about their dream of escaping their small surroundings). After watching a bunch of musicals on maternity leave, I’m wondering h…

    via The whole sky July 17, 2021

    more     (via openring)

  • Posts
  • RSS
  • ◂◂RSS
  • Contact