Net Worth Survey 2014 Interactive Dashboard
Net Worth Survey 2014 Interactive Dashboard
Hi, I decided to create a dashboard with the Boglehead Net Worth survey data. My main purpose was to find out where bogleheads in my age range fall and do some comparisons. I had a bit of fun with this; you can filter on age and educational attainment and see how many in your cohort consider themselves financially independent, and see what incomes were listed.
http://public.tableausoftware.com/views ... y_count=no
Let me know your thoughts, or if you have other things you'd like to see in the dashboard. Please be kind, it's my first time posting a dashboard so publicly.
http://public.tableausoftware.com/views ... y_count=no
Let me know your thoughts, or if you have other things you'd like to see in the dashboard. Please be kind, it's my first time posting a dashboard so publicly.
Re: Net Worth Survey 2014 Interactive Dashboard
That is kind of fun. Thanks for pulling it together in this format. It really goes to show what an abnormal group we really are.
Laura
Laura
The views presented are my own and not necessarily those of the Department of State or the U.S. Government.
Re: Net Worth Survey 2014 Interactive Dashboard
Thanks Laura, I had fun creating it... which is what makes me abnormal as well I suppose.
Re: Net Worth Survey 2014 Interactive Dashboard
I have to admit that as a survey respondent, it's a bit disconcerting to see the data hosted on yet another public server. I know the data is anonymized and I know I gave up control the moment I took the survey, but it makes me queasy nonetheless.
Re: Net Worth Survey 2014 Interactive Dashboard
Look's great.
Could you do one by age instead of education?
Could you do one by age instead of education?
52% TSM, 23% TISM, 24.5% TBM, 0.5% cash
Re: Net Worth Survey 2014 Interactive Dashboard
Thanks for putting this together
-
- Posts: 1405
- Joined: Tue Feb 14, 2012 11:31 am
Re: Net Worth Survey 2014 Interactive Dashboard
cool stuff.
thanks for posting
thanks for posting
- englishgirl
- Posts: 2508
- Joined: Thu Mar 01, 2007 4:34 pm
- Location: FL
Re: Net Worth Survey 2014 Interactive Dashboard
Lol. I am below Boglehead-average in every way.
Sarah
Re: Net Worth Survey 2014 Interactive Dashboard
Thanks mhc! You can filter on age using the drop down filter in the top right of the dashboard. You'll need to click on the link to get to the interactive dashboard though.mhc wrote:Look's great.
Could you do one by age instead of education?
Re: Net Worth Survey 2014 Interactive Dashboard
These surveys always remind me that, while I have earned a Ph.D. in a highly-desirable technical engineering discipline, I am a huge laggard behind the other doctoral and professional respondents. Ladies and gentleman, working in academia doesn't pay. Or, atleast not in dollar denominations.
It has provided with a relaxed and (usually) interesting working environment, and opportunity to travel the world, so it's not all bad.
It has provided with a relaxed and (usually) interesting working environment, and opportunity to travel the world, so it's not all bad.
Re: Net Worth Survey 2014 Interactive Dashboard
I might have missed it but how did you work SS into your net worth figure ?
Was it SS * Remaining Life Expectency ?
Was it SS * Remaining Life Expectency ?
Re: Net Worth Survey 2014 Interactive Dashboard
I suppose you could price an equivalent annuity but IMO it doesn't belong in net worth. You cannot re-balance it, it is not subject to estate tax, you can't give it away or spend it (in one lump sum) and it disappears when you kick the bucket (except surviving spouse).Hexdump wrote:I might have missed it but how did you work SS into your net worth figure ?
Was it SS * Remaining Life Expectency ?
Don't trust me, look it up. https://www.irs.gov/forms-instructions-and-publications
Re: Net Worth Survey 2014 Interactive Dashboard
Hmm, good point, I'll add an option tonight so you can select whether you want to see Net Worth either with or without SS.jebmke wrote:I suppose you could price an equivalent annuity but IMO it doesn't belong in net worth. You cannot re-balance it, it is not subject to estate tax, you can't give it away or spend it (in one lump sum) and it disappears when you kick the bucket (except surviving spouse).Hexdump wrote:I might have missed it but how did you work SS into your net worth figure ?
Was it SS * Remaining Life Expectency ?
-
- Posts: 1137
- Joined: Thu Apr 21, 2011 11:58 pm
Re: Net Worth Survey 2014 Interactive Dashboard
I didn't do the survey, but I'm curious as to what multiplier was used to assess the value of a pension with (and without) COLA.
Re: Net Worth Survey 2014 Interactive Dashboard
This is a neighborhood where I would be pleased just to be average!
Re: Net Worth Survey 2014 Interactive Dashboard
+1Novine wrote:This is a neighborhood where I would be pleased just to be average!
Re: Net Worth Survey 2014 Interactive Dashboard
This is a really cool output, and the driver behind it is an excel spreadsheet? How can I create a dashboard from an excel spreadsheet? I ask because I track my investments in excel and it would be cool to have an output page like this instead of rows and columns of numbers.
40% Extended Market | 40% S&P 500 | 10% REIT | 5% State Muni Bond | 5% Cash
Re: Net Worth Survey 2014 Interactive Dashboard
Thanks! I did this using Tableau using an excel input. It is pretty pricey software and I used to have a license at my old company. I used Tableau Public here, but your data will need to be uploaded publicly for you to save your work. You can create a dashboard in Excel using macros (http://chandoo.org/wp/excel-dashboards/), but it is a bit more tedious.Bogle101 wrote:This is a really cool output, and the driver behind it is an excel spreadsheet? How can I create a dashboard from an excel spreadsheet? I ask because I track my investments in excel and it would be cool to have an output page like this instead of rows and columns of numbers.
-
- Posts: 3
- Joined: Wed Jan 01, 2014 1:45 pm
Re: Net Worth Survey 2014 Interactive Dashboard
I was *just* about to ask folks for their % allocation to stocks, so that I could see where I'm at vs. the average Boglehead in my age range. No need to do that now. Thanks!
-
- Posts: 2892
- Joined: Tue Aug 12, 2008 5:52 pm
- Location: San Diego
- Go Blue 99
- Posts: 1119
- Joined: Thu Oct 09, 2008 3:42 pm
Re: Net Worth Survey 2014 Interactive Dashboard
Impressive work!
Re: Net Worth Survey 2014 Interactive Dashboard
Impressive. Glad someone has more time for this type of thing than others. Amazing site.
Tim
Tim
Re: Net Worth Survey 2014 Interactive Dashboard
Thanks a bunch. Good stuff.
... guess I gotta save more though
... guess I gotta save more though
Don't reach for yield.
Re: Net Worth Survey 2014 Interactive Dashboard
Cool, thanks for putting this together! Three single people in their 20s who are already FI, I've got some catching up to do!
I'd be really interested in seeing the net worth box-and-whiskers graphs without social security included, especially as for us younger folks approximating our future SS benefit involves a lot of assumptions/guesswork.
I'd be really interested in seeing the net worth box-and-whiskers graphs without social security included, especially as for us younger folks approximating our future SS benefit involves a lot of assumptions/guesswork.
Re: Net Worth Survey 2014 Interactive Dashboard
I don't think I would put too much weight on that; their net worths are 177K, 100K, and 90K. It is possible that some people in their 20s have a different definition of "financially independent."daave wrote:Cool, thanks for putting this together! Three single people in their 20s who are already FI, I've got some catching up to do!
Re: Net Worth Survey 2014 Interactive Dashboard
Ok, the default view now shows net worth without social security. You can use the filter in the top right to select the net worth calculation that includes social security. I also made it so that the net worth calculations within the tables are also dependent on the filter.daave wrote:Cool, thanks for putting this together! Three single people in their 20s who are already FI, I've got some catching up to do!
I'd be really interested in seeing the net worth box-and-whiskers graphs without social security included, especially as for us younger folks approximating our future SS benefit involves a lot of assumptions/guesswork.
http://public.tableausoftware.com/views ... y_count=no
Re: Net Worth Survey 2014 Interactive Dashboard
Just noticed that this thread has been updated, thanks very much for the updates, very cool.dlprop wrote:Ok, the default view now shows net worth without social security. You can use the filter in the top right to select the net worth calculation that includes social security. I also made it so that the net worth calculations within the tables are also dependent on the filter.
http://public.tableausoftware.com/views ... y_count=no
One interesting takeaway from this is that a lot of Bogleheads tend to purchase a home in their late-20s to early-30s. Median value of all residences is $0 for 20s and $300K for 30s.
As a group we also seem to have very high net_worth:income ratios (not that this should be a huge surprise).
- Random Musings
- Posts: 6772
- Joined: Thu Feb 22, 2007 3:24 pm
- Location: Pennsylvania
Re: Net Worth Survey 2014 Interactive Dashboard
For the working folk, one interesting aspect would be a function of net worth (ex-inheritance) as a function of net household income. Not to say that certain individuals have recently stepped up income, but this would better benchmark how one personally saves for retirement relative to similar household incomes.
RM
RM
I figure the odds be fifty-fifty I just might have something to say. FZ
Re: Net Worth Survey 2014 Interactive Dashboard
Chandoo's website (previously linked by the OP) contains lots of great information. If you want a more systematic overview, this is a fine introduction:Bogle101 wrote:This is a really cool output, and the driver behind it is an excel spreadsheet? How can I create a dashboard from an excel spreadsheet? I ask because I track my investments in excel and it would be cool to have an output page like this instead of rows and columns of numbers.
http://www.amazon.com/Excel-Dashboards- ... 1118842243
Re: Net Worth Survey 2014 Interactive Dashboard
Hello, is there a way to update this with more current survey data? This is so cool!
Re: Net Worth Survey 2014 Interactive Dashboard
So those with a master's degree had a higher net worth in all respects compared with a doctorate / professional degree? Very interesting. One question, what does the "Null" category represent exactly?