Our net worth spreadsheet gets updated on the 26th of every month. I chose this date because it's deep enough into the month that we've likely made most of our payments for the month, so that whatever remains is the accumulated surplus. I could inflate the numbers by doing the calculations right after my pay period, but that seems self-defeating to me.
For October 2018, our combined total net worth was $36,070.18 or €31,612.78.
Composition
Since this is the first of these posts, I should describe what makes up our net worth spreadsheet.
There's a U.S. dollar section and a euro part. Each one contains the following:
- Bank accounts, including checking and savings accounts.
- Credit card accounts.
- Investment accounts (currently USD only).
- Loans and other lump-sum liabilities.
- An "Other" sections, which includes rounded petty cash as well as the estimated value of loyalty programs.
These are added together, and along with the prevailing EURUSD exchange rate, I calculate the value in dollars and euros. Since this spreadsheet has data from 2013, some accounts are closed, but the rows remain in the spreadsheet in order to maintain their data. Some things that aren't there that may eventually make an appearance are:
- Physical Assets. We currently don't have any physical assets that are worth adding to the spreadsheet (cars, houses).
- Pensions et al. I haven't added my pension from my German job. I haven't figured out a good way to do it yet. Likewise Social Security or the German Rentenversicherung.
This is a complete net worth spreadsheet and not a true FIRE net worth spreadsheet, but it's easy enough to calculate those numbers with a few clicks in the spreadsheet. Just Control/Command click the necessary accounts, and I'm good to go.
Up top, I have a couple of interpretations of the data in discrete cells. Namely, what is 4% of our worth? If it's lower than $40k, then it's shaded red, and if it's higher, then it's shaded green. It's definitely shaded red. I also have a sheet that calculates the Millionaire Next Door categories "Average Accumulator of Wealth" and "Prodigious Accumulator of Wealth" values for us and how much we're below/above those amounts. If our wealth is below the "Average Accumulator", it's also shaded red, which it definitely is right now.
Those two items are purely reminders of long-term goals and reminders just how much needs to be saved rather than being explicit thresholds.
Factors Affecting Current Net Worth
The biggest factors that affected this month's net worth change is the stock market. I'm a long only investor, and October has been pretty rough on us. Additionally, most of my portfolio is value stocks, and those prices have been getting crushed. The "growth" stocks also suffered but not nearly as much. I also have some positions in German companies, and Germany's stock market has been lagging for about a year.
Because of this volatility, my tax deferred retirement accounts and my taxable brokerage account fell several percent. We saved a good amount of money this month, but the market mostly netted the change to zero.
Funnily enough though, because the euro fell against the dollar, the value of these accounts rose in value in euros, even as they fell in dollars. Silver lining?
This month, I began to calculate the estimated value of loyalty programs. I'm calculating the various points as being worth ¢1 a piece. It doesn't add a lot of value to net worth, but those points have some kind of value, so I'd might as well add them. I'm not sure if it's worth adding them in for past months, since it's such a small value (around $1k).
Regarding credit cards and loans, none of that costs us interest. We currently never carry a balance, and the one "loan" is an installment plan from a dentist that doesn't charge any interest. In the beginning of the spreadsheet, we did have interest-accumulating accounts due to student loans and the cost of moving abroad, but those are long gone.
So there's the first of hopefully many updates.
No comments:
Post a Comment