• 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: $9.0k/month ($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:

    More on the Deutschlandtakt

    The Deutschlandtakt plans are out now. They cover investment through 2040, but even beforehand, there’s a plan for something like a national integrated timetable by 2030, with trains connecting the major cities every 30 minutes rather than hourly. But the…

    via Pedestrian Observations July 1, 2020

    How do cars fare in crash tests they're not specifically optimized for?

    Any time you have a benchmark that gets taken seriously, some people will start gaming the benchmark. Some famous examples in computing are the CPU benchmark specfp and video game benchmarks. With specfp, Sun managed to increase its score on 179.art (a su…

    via Posts on Dan Luu June 30, 2020

    Quick note on the name of this blog

    When I was 21 a friend introduced me to a volume of poems by the 14th-century Persian poet Hafiz, translated by Daniel Ladinsky. I loved them, and eventually named this blog for one of my favorite ones. At some point I read more and found that Ladinsky’s …

    via The whole sky June 21, 2020

    more     (via openring)


  • Posts
  • RSS
  • ◂◂RSS
  • Contact