# Proving that the corporations 32% in taxes, and employee costs are minimal (~10%)

Proving that the corporations 32% in taxes, and employee costs are minimal (~10%)
Today, I analyzed the 500 companies on the S&P 500 to quantify and
qualify the index's metrics. Moreover, I also wanted to discern the weighted average gross margins, the weighted average pretax margins, as well as the weighted post tax margins (i.e. weighted net profit margins). Finally, I would also like to calculate the tax rate of the average S&P 500 company based on the differential of the weighted average pretax margins and the weighted average profit margins.
Here are my abbreviations that I¡¦m using: S = Sales (i.e. Revenue) COGS = Cost of goods sold WAGM = Weighted Average Gross Margin CSGADAI = Cost of Selling, General Administrative, Depreciation, Amortization, and Interest -„³ Basically, this is all costs excluding the COGS and Taxes. All these costs are deducted from revenue, just like the COGS, to arrive at the Net Income (NI). WAPTM = Weighted Average Pre-Tax Margin COT = Cost of Taxes WANPM = Weighted Average Net Profit Margin NI = Net Income (i.e. Profit)
Regarding my liberal use of the term ¡§Weighted Average¡¨ for my calculations as opposed to the ¡§Arithmetic Average¡¨: To understand this distinction, let¡¦s analyze the WANPM. The WANPM is calculated by summing the entire column of MS Excel which has the earnings of the companies. Note that some of the values maybe negative indicating a loss. The Earnings for each company is in Column E, and the Sales figures for each company is in Column J. Therefore, the WANPM is:
=SUM(E2:E501)/SUM(J2:J501)
Also, this method is more robust than simply averaging all the individual profit margins. As a comparison, the WANPM and the Arithmetic NPM are: 0.04924734 and 0.074364, respectively.
Using this WA approach, I figured out that the WAGM of the companies are: WAGM - WeightedGrossMargin        0.2739 WAPTM - WeightedPreTaxMargin    0.0728 WANPM - WeightedNetProfitMargin    0.0492
Therefore, the Income Statement for a representative company on the S&P 500 can be recreated who nominal revenue is \$1. We have the following Income Statement, and at the end, we will solve the average tax rate for the representative company:
S                    1.0000 (COGS)                    (0.7261) WAGM ¡V WeightedAverageGrossMargin        0.2739 (CSGADAI)                (0.2011) WAPTM - WeightedAveragePreTaxMargin        0.0728 (COT)                    (0.0236) ---------------------------------------------------------------------------------------------- WANPM - WeightedAverageNetProfitMargin     0.0492
From a WAPTM of 0.0728, the company pays out 0.0236 in taxes. This implies that the average company pays 0.0236/0.0728=32.4% in corporate taxes.
Some insights that I¡¦d like to point out here is that the cost of the employees (i.e. the wages) is actually very small when compared to the other costs. The wages, which are a component of the CSGADAI, should only be about half of this entire figure, which would mean half of 0.2011, or about .10 the total revenues of a company. On the other hand, the COGS is .73. Therefore, it is not so valid to state that the wage costs or the tax costs are the biggest costs of a corporation.
Regarding taxes: The corporation only pays 2.4% of their total REVENUES, on average. This is still 32.4% of their Pre-Tax Income. I¡¦m not saying that this low tax rate is fair/unfair, but we should definitely think about this and make our own insights.
Regarding the average P/E, P/B, P/S, P/CF, and ROE on the S&P 500, here are the weighted averages:
P/E    14.59230769 P/B    1.449210896 P/CF    5.948592645 P/S    0.718632308 ROE    0.099313346
Note that the WANPM can be deduced from these figures as simply being the P/E / P/S = 0.0492. Similarly, the ROE can be deduced by P/B / P/ E = 0.0993, which is also in accordance with my values above. However, only 487 of the 500 companies have reported their book values, so this value only takes into account the 487 which have reported their book values. The 13 companies which didn¡¦t report these values are typically distressed.
Finally, from my experience in regressing and analyzing the S&P 500, I noticed that the WA ratios are: WA P/E ¡V 18 WA P/B ¡V 2.8 WA P/CF ¡V 10 WA P/S ¡V 1.5 WA ROE ¡V 16%
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Today, I analyzed the 500 companies on the S&P 500 to quantify and qualify the index's metrics. Moreover, I also wanted to discern the weighted average gross margins, the weighted average pretax margins, as well as the weighted post tax margins (i.e. weighted net profit margins). Finally, I would also like to calculate the tax rate of the average S&P 500 company based on the differential of the weighted average pretax margins and the weighted average profit margins.
Here are my abbreviations that I'm using: S = Sales (i.e. Revenue) COGS = Cost of goods sold WAGM = Weighted Average Gross Margin CSGADAI = Cost of Selling, General Administrative, Depreciation, Amortization, and Interest -„³ Basically, this is all costs excluding the COGS and Taxes. All these costs are deducted from revenue, just like the COGS, to arrive at the Net Income (NI). WAPTM = Weighted Average Pre-Tax Margin COT = Cost of Taxes WANPM = Weighted Average Net Profit Margin NI = Net Income (i.e. Profit)
Regarding my liberal use of the term "Weighted Average" for my calculations as opposed to the "Arithmetic Average": To understand this distinction, let's analyze the WANPM. The WANPM is calculated by summing the entire column of MS Excel which has the earnings of the companies. Note that some of the values maybe negative indicating a loss. The Earnings for each company is in Column E, and the Sales figures for each company is in Column J. Therefore, the WANPM is:
=SUM(E2:E501)/SUM(J2:J501)
Also, this method is more robust than simply averaging all the individual profit margins. As a comparison, the WANPM and the Arithmetic NPM are: 0.04924734 and 0.074364, respectively.
Using this WA approach, I figured out that the WAGM of the companies are: WAGM - WeightedGrossMargin 0.2739 WAPTM - WeightedPreTaxMargin 0.0728 WANPM - WeightedNetProfitMargin 0.0492
Therefore, the Income Statement for a representative company on the S&P 500 can be recreated who nominal revenue is \$1. We have the following Income Statement, and at the end, we will solve the average tax rate for the representative company:
S 1.0000 (COGS) (0.7261) WAGM - WeightedAverageGrossMargin 0.2739 (CSGADAI) (0.2011) WAPTM - WeightedAveragePreTaxMargin 0.0728 (COT) (0.0236) ----------------------------------------------------------------------------------------------- WANPM - WeightedAverageNetProfitMargin 0.0492
From a WAPTM of 0.0728, the company pays out 0.0236 in taxes. This implies that the average company pays 0.0236/0.0728=32.4% in corporate taxes.
Some insights that I'd like to point out here is that the cost of the employees (i.e. the wages) is actually very small when compared to the other costs. The wages, which are a component of the CSGADAI, should only be about half of this entire figure, which would mean half of 0.2011, or about .10 the total revenues of a company. On the other hand, the COGS is .73. Therefore, it is not so valid to state that the wage costs or the tax costs are the biggest costs of a corporation.
Regarding taxes: The corporation only pays 2.4% of their total REVENUES, on average. This is still 32.4% of their Pre-Tax Income. I'm not saying that this low tax rate is fair/unfair, but we should definitely think about this and make our own insights.
Regarding the average P/E, P/B, P/S, P/CF, and ROE on the S&P 500, here are the weighted averages:
P/E 14.59230769 P/B 1.449210896 P/CF 5.948592645 P/S 0.718632308 ROE 0.099313346
Note that the WANPM can be deduced from these figures as simply being the P/E / P/S = 0.0492. Similarly, the ROE can be deduced by P/B / P/ E = 0.0993, which is also in accordance with my values above. However, only 487 of the 500 companies have reported their book values, so this value only takes into account the 487 which have reported their book values. The 13 companies which didn't report these values are typically distressed.
Finally, from my experience in regressing and analyzing the S&P 500, I noticed that the WA ratios are: WA P/E - 18 WA P/B - 2.8 WA P/CF - 10 WA P/S - 1.5 WA ROE - 16%
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
wrote:
You are wrong.... Corporations have NEVER paid taxes!
What ever they submit to the Government was collected from the consumers.... It has ALWAYS been a slight-of-hand trick from the uberlib DemonCraps!
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

Right. And consumers have never paid taxes, since whatever they submit to government is paid for by corporation whose sales go down due to consumers not having those dollars to spend. So corporations end up paying all the taxes!
Or, we could just look at taxes as being money taken out of the system, and recognize that paragraphs like the two above are ludicrous.
--
Alex -- Replace "nospam" with "mail" to reply by email. Checked infrequently.

âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
On Nov 21, 12:53 pm, President Soetoro

You should look at the financial statements of the corporations. According to the financial statements, they, in fact, *DO* pay taxes. They pay out, on average, 32% of their pre-taxed income as taxes.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

You've missed the fundamental point that whatever they list in their financial statements as being taxes they pay, that money comes from the consumers who have bought the goods or services that the corp sells.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
message

If you had a clue about accounting you would know that the tax comes from the company's profit.
Sales tax is paid directly by customers. Corporate tax come out of profit
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

And that profit comes from what consumers pay for the goods and services they sell.

But still comes from what consumers pay for the goods and services that the corp sells.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
message

If you had a clue about accounting you would know that the tax comes from the company's profit.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
"President Soetoro"
message

Total ignorant nonsense. Same shit since Reagan started the destruction of America
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

Sid, is the alzheimer bothering you again.....
Let me explain this in simple terms....
Exxon collected \$35 Billion last quarter extra from the consumers to turn around and send it to the Government, Whatever corporations "pay" in taxes was already collected from the the person who bought the gasoline.
There's roughly 300 million people in this Country, they paid an extra \$116 a month to the Government in taxes via Exxon.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
On Nov 21, 1:18 pm, President Soetoro

Hey budd, you know you should'nt waste precious bandwidth trying to reason with poor old sidney. I mean the boy is an Obamunista which means he doesn't have the brain power to support a cough reflex. When old sid coughs I'm sure he soils his knickers. (cough-cough-ssppllaat!)
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
"President Soetoro"
message

Except that's not how it works. Learn something about accounting.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

Then HOW does it work? How does a company come up with the money to pay it's "taxes" if the money isn't collected from the consumer?
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
"Ayatollah Obama"
message

Corporate income tax comes from profit. No profit, no tax. Learn something about accounting.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

Sidney, you have some kind of impairment apparently.... Did I hear a DemonCrap uberlib mention the word "profit".... damn.... You're gonna get banished from the DemonCrap party using such necon buzzwords.
btw, where does the profit come from? Companies try and determine ahead of time what they want to make for the owners/shareholders of a company. If a company what's to return 8% to the investors they have to predetermine what the costs (including taces) will be and set the prices the consumer pays accordingly....
So the cost of the estimated taxes is included in the price of the product....
So going back to my original statement.... Exxon collects an extra \$110 per month per person to pay their taxes.... In other words, corporations have NEVER paid taxes.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
"Ayatollah Obama"
message

I am not impaired. I've had college level courses in accounting. Corporations pay income tax from PROFITS. No profit, no tax. Customers pay sales tax through corporations It doesn't matter if the corporation makes a profit or not, customers pay the tax nonetheless.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

message
You have an odd sense for how markets and supply and demand work.
--
Alex -- Replace "nospam" with "mail" to reply by email. Checked infrequently.

âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

They've been indoctrinated with this anti-tax mantra to the point that we wreck our government's finances. They follow the destructive advice of Grover Norquist. Reagan was the start of our country living on a credit card.
Now drastic unconventional things will need to be done to save our people from a repeat of the Great Depression
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

It was the policy of the DemonCraps that held a gun to the heads of the banks and told them... "If you don't make this loan, we'll pull this trigger". Either way the banks were dead, the only variable was time.
I agree that Bush has spent money like a sober DemonCrap, but now we have druken DemonCraps in control of the spending. How did Piglosi do last year? \$465B deficit.... what's the forecast for FY 2009? \$1 TRILLION deifict.
Sidney, I think you ought call your sister Nancy Piglosi and let her know the sum total of your fiscal knowledge. The call shouldn't take any longer than 15 seconds.
âœ–
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>

## Site Timeline

• ### How does Citibank "sell all or part of itself"?

• - next thread in General Accounting
• ### Owner's Contribution - Corporation

• - previous thread in General Accounting

• ### import investment transactions into quicken2016

• - the site's last updated thread. Posted in Quicken Personal Finance
• Share To

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.