Archive for the ‘Money’ Category:

How much do US households spend and how does it change with education level?

This visualization is one of a series of visualizations that present US household spending data from the US Bureau of Labor Statistics. This one looks at the education level of the primary resident.

• US Household spending by income group
• US Household spending by age of primary resident
• US Household spending by education level of primary resident
• US Household spending by household composition

This visualization focuses on the education level of the primary resident. This is defined in the BLS documentation as the person who is first mentioned when the survey respondent is asked who in the household rents or owns the home.

I obtained data from the US Bureau of Labor Statistics (BLS), based upon a survey of consumer households and their spending habits. This data breaks down spending and income into many categories that are aggregated and plotted in a Sankey graph.

One of the key factors in financial health of an individual or household is making sure that household spending is equal to or below household income. If your spending is higher than income, you will be drawing down your savings (if you have any) or borrowing money. If your spending is lower than your income, you will presumably be saving money which can provide flexibility in the future, fund your retirement (maybe even early) and generally give you peace of mind.

Instructions:

• Hover (or on mobile click) on a link to get more information on the definition of a particular spending or income category.
• Use the dropdown menu to look at averages for different groups of households based on the education level of the primary resident. This data breaks households into the following groups:
  • All
  • Less than HS graduate
  • High school graduate
  • HS grad + some college
  • Associate’s degree
  • Bachelor’s degree
  • Master’s, professional, doctoral degree

  The composition of households and income change as the education level of the primary resident changes, which in turn affects spending totals and individual categories.

As stated before, one of the keys to financial security is spending less than your income. We can see that on average, income tends to increase with education level. Those with the highest incomes and greatest spending have advanced degrees, but they also save the most money.

The group with the lowest education level (not finishing high school) have the lowest income and on average needs to borrow or draw down on savings to live their lifestyle.

How does your overall spending compare with those that have the same education level as you? How about spending in individual categories like housing, vehicles, food, clothing, etc…?

Probably one of the best things you can do from a financial perspective is to go through your spending and understand where your money is going. These sankey diagrams are one way to do it and see it visually, but of course, you can also make a table or pie chart (Honestly, whatever gets you to look at your income and expenses is a good thing).

The main thing is to understand where your money is going. Once you’ve done this you can be more conscious of what you are spending your money on, and then decide if you are spending too much (or too little) in certain categories. Having context of what other people spend money on is helpful as well, and why it is useful to compare to these averages, even though the income level, regional cost of living, and household composition won’t look exactly the same as your household.

**Click Here to view other financial-related tools and data visualizations from engaging-data**

Here is more information about the Consumer Expenditure Surveys from the BLS website:

The Consumer Expenditure Surveys (CE) collect information from the US households and families on their spending habits (expenditures), income, and household characteristics. The strength of the surveys is that it allows data users to relate the expenditures and income of consumers to the characteristics of those consumers. The surveys consist of two components, a quarterly Interview Survey and a weekly Diary Survey, each with its own questionnaire and sample.

Data and Tools:
Data on consumer spending was obtained from the BLS Consumer Expenditure Surveys, and aggregation and calculations were done using javascript and code modified from the Sankeymatic plotting website. I aggregated many of the survey output categories so as to make the graph legible, otherwise there’d be 4x as many spending categories and all very small and difficult to read.

Given that tax day has just passed, I thought it would be good to check out some data on taxes. The IRS provides a great resource on tax data that I’ve only just gotten into. I think I’ll be able to do more with this in the future. This one looks at how taxes paid varies by state and presents it as a choropleth map (coloring states based on certain categories of tax data).

• Mean Federal Tax Paid
• Mean Adjusted Gross Income
• Mean State/Local Tax
• Mean Combined (Fed/State/Local) Tax
• Percent Income from Dividends and Capital Gains
• Percent of Returns with Itemized Deductions
• Number of Tax Returns
• Mean Federal Tax Rate
• Mean State/Local Tax Rate
• Mean Combined (Fed/State/Local) Rate
• Total Federal Tax Liability

I may add more categories in the future, so if you have ideas of tax data you want to see visualized let me know and I’ll see what I can do.

For other tax-related tools and visualizations see my tax bracket calculator and visualization of marginal tax rates.

**Click Here to view other financial-related tools and data visualizations from engaging-data**

Data and Tools:

Data on tax returns by state is from the IRS website in an excel format. The map was made using the leaflet open source mapping library. Data was compiled in excel and calculations made using javascript.

How much do US households spend and how does it change with age?

This visualization is one of a series of visualizations that present US household spending data from the US Bureau of Labor Statistics. This one looks at the age of the primary resident.

• US Household spending by income group
• US Household spending by age of primary resident
• US Household spending by education level of primary resident
• US Household spending by household composition

This visualization focuses on the age of the primary resident. This is defined in the BLS documentation as the person who is first mentioned when the survey respondent is asked who in the household rents or owns the home.

I obtained data from the US Bureau of Labor Statistics (BLS), based upon a survey of consumer households and their spending habits. This data breaks down spending and income into many categories that are aggregated and plotted in a Sankey graph.

One of the key factors in financial health of an individual or household is making sure that household spending is equal to or below household income. If your spending is higher than income, you will be drawing down your savings (if you have any) or borrowing money. If your spending is lower than your income, you will presumably be saving money which can provide flexibility in the future, fund your retirement (maybe even early) and generally give you peace of mind.

Instructions:

• Hover (or on mobile click) on a link to get more information on the definition of a particular spending or income category.
• Use the dropdown menu to look at averages for different groups of households based on the age of the primary resident. This data breaks households into groups (under 25, 25-34, 35-44, 45-54, 55-64, 65-75 and over 75). The composition of households and income change as the age of the primary resident changes, which in turn affects spending totals and individual categories.

As stated before, one of the keys to financial security is spending less than your income. We can see that on average, income tends to increase with the household primary age up to the 45-54 group, then declines from there.

The youngest group (under 25) tends to borrow or draw down on savings to live their lifestyle, while the same is true of the over 75 age group. This is probably because seniors tend to draw down savings that were built up specifically for this purpose, and college students borrow to go to school. Social security also makes up a big portion of income for the older age groups.

How does your overall spending compare with those in your income group? How about spending in individual categories like housing, vehicles, food, clothing, etc…?

Probably one of the best things you can do from a financial perspective is to go through your spending and understand where your money is going. These sankey diagrams are one way to do it and see it visually, but of course, you can just make a table or pie chart or whatever.

The main thing is to understand where your money is going. Once you’ve done this you can be more conscious of what you are spending your money on, and then decide if you are spending too much (or too little) in certain categories. Having context of what other people spend money on is helpful as well, and why it is useful to compare to these averages, even though the income level, regional cost of living, and household composition won’t look exactly the same as your household.

**Click Here to view other financial-related tools and data visualizations from engaging-data**

Here is more information about the Consumer Expenditure Surveys from the BLS website:

The Consumer Expenditure Surveys (CE) collect information from the US households and families on their spending habits (expenditures), income, and household characteristics. The strength of the surveys is that it allows data users to relate the expenditures and income of consumers to the characteristics of those consumers. The surveys consist of two components, a quarterly Interview Survey and a weekly Diary Survey, each with its own questionnaire and sample.

Data and Tools:
Data on consumer spending was obtained from the BLS Consumer Expenditure Surveys, and aggregation and calculations were done using javascript and code modified from the Sankeymatic plotting website. I aggregated many of the survey output categories so as to make the graph legible, otherwise there’d be 4x as many spending categories and all very small and difficult to read.

California is one of the world’s largest economies (as measured by gross domestic product), currently ranking 5th in the world (if it were judged as it’s own country). This map divides the rest of the US economy into 6 more or less equal parts (each the size of California’s) and they are all within about 10% of each other.

Instructions:
You can hover over a state with your cursor to get more information about the GDP of that state and the group of states that equal California’s economy.

Gross domestic product is a measurement of the size of a region’s economy. It is the sum of gross value added from all entities in the region or state. It measures the monetary value of the goods produced and services provided in a year.

The main sectors of the California economy are agriculture, technology, tourism, media (movies and TV) and trade. Some of the world’s largest and most famous companies contribute to the California economy, like Apple, Google, Facebook, Disney, and Chevron.

Data and Tools:
Data for state level GDP is obtained from Wikipedia for the year 2017. The map data is processed in javascript and then plotted using the leaflet.js mapping library.

How much do US households spend?

This visualization is one of a series of visualizations that present US household spending data from the US Bureau of Labor Statistics. This one looks at the income of the household.

• US Household spending by income group
• US Household spending by age of primary resident
• US Household spending by education level of primary resident
• US Household spending by household composition

One of the key factors in financial health of an individual or household is making sure that household spending is equal to or below household income. If your spending is higher than income, you will be drawing down your savings (if you have any) or borrowing money. If your spending is lower than your income, you will presumably be saving money which can provide flexibility in the future, fund your retirement (maybe even early) and generally give you peace of mind.

I obtained data from the US Bureau of Labor Statistics (BLS), based upon a survey of consumer households and their spending habits. This data breaks down spending and income into many categories that are aggregated and plotted in a Sankey graph.

Instructions:

• Hover (or on mobile click) on a link to get more information on the definition of a particular spending or income category.
• Use the dropdown menu to look at averages for different groups of households based on income. This data breaks households into quintiles (groups of 20%) by income. The lowest quintile group is the group of 20% of households with the lowest income (and spend on average ~$25,500/yr).

As stated before, one of the keys to financial security is spending less than your income. We can see that on average, those in the lowest quintiles may be borrowing or drawing down on savings to live their lifestyle, while those in the highest quintiles are saving money and contributing to wealth. This fairly high level of borrowing/drawing on savings from the lowest quintile households may be deceptive because it includes seniors who are drawing down savings that were built up specifically for this purpose, and college students who are borrowing to go to school. These groups generally don’t have significant incomes.

How does your overall spending compare with those in your income group? How about spending in individual categories like housing, vehicles, food, clothing, etc…?

Probably one of the best things you can do from a financial perspective is to go through your spending and understand where your money is going. These sankey diagrams are one way to do it and see it visually, but of course, you can just make a table or pie chart or whatever.

The main thing is to understand where your money is going. Once you’ve done this you can be more conscious of what you are spending your money on, and then decide if you are spending too much (or too little) in certain categories. Having context of what other people spend money on is helpful as well, and why it is useful to compare to these averages, even though the income level, regional cost of living, and household composition won’t look exactly the same as your household.

**Click Here to view other financial-related tools and data visualizations from engaging-data**

Here is more information about the Consumer Expenditure Surveys from the BLS website:

The Consumer Expenditure Surveys (CE) collect information from the US households and families on their spending habits (expenditures), income, and household characteristics. The strength of the surveys is that it allows data users to relate the expenditures and income of consumers to the characteristics of those consumers. The surveys consist of two components, a quarterly Interview Survey and a weekly Diary Survey, each with its own questionnaire and sample.

Data and Tools:
Data on consumer spending was obtained from the BLS Consumer Expenditure Surveys, and aggregation and calculations were done using javascript and code modified from the Sankeymatic plotting website. I aggregated many of the survey output categories so as to make the graph legible, otherwise there’d be 4x as many spending categories and all very small and difficult to read.

How is your income distributed across tax brackets?

I previously made a graphical visualization of income and marginal tax rates to show how tax brackets work. That graph tried to show alot of info on the same graph, i.e. the breakdown of income tax brackets for incomes ranging from $10,000 to $3,000,000. It was nice looking, but I think several people were confused about how to read the graph. This Sankey graph is a more detailed look at the tax breakdown for one specific income. You can enter your (or any other) profile and see how taxes are distributed across the different brackets. It can help (as the other tried) to better understand marginal and average tax rates. This tool only looks at US Federal Income taxes and ignores state, local and Social Security/Medicare taxes.

Generate URL – Use this button to generate a URL that you can share a specific set of inputs and graphs. Just copy the URL in the address bar at the top of your browser (after pressing the button).

• Select filing status: Single, Married Filing Jointly or Head of Household. For more info on these filing categories see the IRS website
• Enter your regular income and capital gains income. Regular income is wage or employment income and is taxed at a higher rate than capital gains income. Capital gains income is typically investment income from the sale of stocks or dividends and taxed at a lower rate than regular income.
• Move your cursor or click on the Sankey graph to select a specific link. This will give you more information about how income in a specific tax bracket is being taxed.

**Click Here to view other financial-related tools and data visualizations from engaging-data**

As seen with the marginal rates graph, there is a big difference in how regular income and capital gains are taxed. Capital gains are taxed at a lower rate and generally have larger bracket sizes. Generally, wealthier households earn a greater fraction of their income from capital gains and as a result of the lower tax rates on capital gains, these household pay a lower effective tax rate than those making an order of magnitude less in overall income.

2018 Tax Brackets

Here are two tables that lists the marginal tax brackets in the United States in 2018 that form the basis of the calculations in the calculator. 2019’s numbers are listed below.

 
You can see that tax rates are much lower for capital gains in the table below than for regular income (table above).

2019 Tax Brackets

Here are the numbers for 2019:

 
You can see that tax rates are much lower for capital gains in the table below than for regular income (table above).

2020 Tax Brackets

Here are the numbers for 2020:

 
You can see that tax rates are much lower for capital gains in the table below than for regular income (table above).

2021 Tax Brackets

Here are the numbers for 2021:

 
You can see that tax rates are much lower for capital gains in the table below than for regular income (table above).

• If you are single, all of your regular taxable income between 0 and $9,525 is taxed at a 10% rate. This means that your all of your gross income below $12,000 is not taxed and your gross income between $12,000 and $21,525 is taxed at 10%.
• If you have more income, you move up a marginal tax bracket. Any taxable income in excess of $9,525 but below $38,700 will be taxed at the 12% rate. It is important to note that not all of your income is taxed at the marginal rate, just the income between these amounts.
• Income between $38,700 and $82,500 is taxed at 24% and so on until you have income over $500,000 and are in the 37% marginal tax rate . . .
• Thus, different parts of your income are taxed at different rates and you can calculate an average or effective rate (which is shown in the summary table).
• Capital gains income complicates things slightly as it is taxed after regular income. Thus any amount of capital gains taxes you make are taxed at a rate that corresponds to starting after you regular income. If you made $100,000 in regular income, and only $100 in capital gains income, that $100 dollars would be taxed at the 15% rate and not at the 0% rate, because the $100,000 in regular income pushes you into the 2nd marginal tax bracket for capital gains (between $38,700 and $426,700).

 
Data and Tools:
Tax brackets and rates were obtained from the IRS website and calculations were made using javascript and code modified from the Sankeymatic plotting website.