Calculate Gross Margin

In the article “Calculate Profit Margin” and “Calculate Operating Margin”, we showed how to calculate the profit margin and operating margin from the company’s net income statement. In this article, we are going to discuss the gross margin and show the equation and steps how to calculate operating margin from company’s net income statement. Also we are going to explain the difference between gross margin and markup. We are going to use net income statement from MSN Money website as an example to show the calculation
 

What is Gross Margin

Similar to Profit Margin and Operating Margin, Gross Margin is also one of the ratios to measure business’s profitability. The basic idea behind gross margin is to measure how profitable for every one unit of product the business sold before accounting other expenses. For example, if you own a coffee shop and for each coffee you sold for $3. In order to make a cup of coffee, you have to purchase coffee beans, coffee machines, paper cup… with total cost $0.3 in average. That means you earn the gross profit of $2.7 for each cup of coffee you sold. From the example about, we can see the gross profit calculation doesn’t include any expenses other than cost directly related to the product itself, such as rent for space, general administration…
=>Gross Margin = Gross Profit / Revenue
Where Gross Profit = Revenue – COGS (Cost of Goods Sold)
COGS (Cost of Goods Sold) is a general term to refer to the inventory cost. From the above example, COGS would mean the cost to purchase coffee beans, paper cup…
 

Difference between Gross Margin and Markup

Many people get confused with gross margin and markup. Basically these are two methods to describe the same thing, but with different purpose. The reason why some retailers prefer gross margin and some prefer markup is because gross margin is easier to calculate the profit from the sales revenue, while markup is easier to calculate sales price from the cost. We can always derive one another from following relation relations:
Markup = Revenue / COGS -1
=> Gross Margin = Markup/ (1+Markup).
=> Markup = Gross Margin / (1-Gross Margin)
 

Calculate Gross Margin from Net Income Statement

We are going to use income statement from company Caterpillar (CAT) to show how to calculate Caterpillar’s operating margin. You can access Caterpillar’s income statement here or you can use or product, Stock Financial Statements Download, to download and export Caterpillar’s income statement.

 


 
From its income statement, Caterpillar has total operating income $18820M and total revenue $65875M in 2012. Because Gross Margin = Gross Profit / Revenue
=> Caterpillar’s gross margin in 2012 = 18820/65875 = 28.57%
Notice that gross profit ($18820M) is derived by total revenue ($65875M) – cost of revenue ($47055M). Instead of calling it COGS (cost of goods sold), MSN Money website called it cost of revenue.
 

Commentary

In the article “Calculate Profit Margin” and “Calculate Operating Margin”, we calculated Caterpillar’s profit margin and operating margin in 2012 as 8.62% and 13.01% respectively. Caterpillar’s gross margin, 28.57%, is higher than its operating margin. It is no surprise that in general a company’s gross margin > operating margin > profit margin because gross profit calculation only includes production related costs and operation profit calculation includes production related costs and other operation costs, while net profit includes all costs

Calculate Operating Margin

In the article “Calculate Profit Margin”, we showed how to calculate the profit margin from business’s financial statement. In this article, we are going to discuss the operating margin and show the equation and steps how to calculate operating margin from company’s net income statement. We are going to use net income statement from MSN Money website as an example to show the calculation
 

What is Operating Margin

Similar to Profit Margin, Operating Margin is also one of the ratios to measure business’s profitability. The only difference is that instead of using net income, operating margin uses operating income to calculate the ratio
=>Operating Margin = Operating Income / Revenue
 

Difference between Operating Income and Net Income

As the name suggested, operating income is income generated solely from operating activity. Take the net income statement of Caterpillar Inc. (CAT) downloaded by Stock Financial Statements Download (SFSD) for example. It is obvious that
Operating Income = gross profit – operating expenses
Where operating expenses = Gross profit - selling general and administrative – research and development – special income/charges – interest income/expense
As for net income, it is derived from operating income minus nonoperation expense
=> Net income = operating income – nonoperation expense
= operating income – net interest income – other income – pretax income – provision for income tax – minority interest

 


 
 

Calculate Operating Margin from Financial Statement

We are going to use income statement from company Caterpillar (CAT) to show how to calculate Caterpillar’s operating margin. You can access Caterpillar’s income statement here or you can use or product, Stock Financial Statements Download, to download and export Caterpillar’s income statement.

Calculate Profit Margin

In the article “Calculate Financial Leverage”, we showed how to calculate the financial leverage from business’s financial statement and debt equity ratio. In this article, we are going to discuss the profit margin and show the equation and steps how to calculate profit margin from company’s financial statement, basically net income statement.

What is Profit Margin

Profit Margin is one of the ratios to measure business’s profitability. The basic idea behind this measurement is to see how efficient the business generates revenue based on cost accrued. If the business can generate more revenue based on less cost, it is more efficient, and hence has higher profit margin
=> Profit Margin = (Revenue – Cost)/Revenue
Because Revenue – Cost is simply Net Income
=>Profit Margin = Net Income / Revenue

Calculate Profit Margin from Financial Statement

We are going to use income statement from company Caterpillar (CAT) to show how to calculate Caterpillar’s profit margin. You can access Caterpillar’s income statement here or you can use or product, Stock Financial Statements Download, to download and export Caterpillar’s income statement.
Following is screenshot how it looks like using Stock Financial Statements Download to export it into local PC



From its income statement, Caterpillar has total revenue $65875M and net income $5681M in 2012. Because Profit Margin = Net Income / Revenue
=> Caterpillar’s profit margin in 2012 = 5681/65875 = 8.62%

Commentary

Profit Margin is used to measure business’s profitability. Higher profit margin generally indicates the company has higher profitability. However, from investors’ point of view, high profit margin doesn’t mean it will have high return on equity, which is the major ratio investors are looking for. It is possible that a company can have high profit margin yet its return on equity is low. Besides that, profit margin may vary among different industries. However, it is still a valuable indicator because investors can calculate the profit margin year by year based on the company’s historical financial statement for internal comparison

Stock Financial Statements Download V 1.0 Available

 
We are pleased to announce that the Stock Financial Statements Download(SFSD) version 1.0 is released! ! Stock Financial Statements Download is the software that can asynchronously download the business’s financial statement, such as net income statement, balance sheet statement, and cash flow statement, from MSN Money website. If you are an investor that make investment decision by company’s fundamental value, it is a must have tool. Stock Financial Statements Download can bulk download net income, balance sheet, and cash flow statement from a list of symbols defined by you. With raw data at hand, you can perform various ratio analysis among stocks and identify those that meet your investment requirement. The download period can be yearly or quarterly and up to most recent 5 periods.
 

Main Features

· Only one time purchase fee, no further subscription fee
· Batch downloads the symbol lists defined by you.
· Support the financial statements of stocks traded in US and Canadian markets
· Support data source from MSN Money (money.msn.com)
· Asynchronous download
· Financial statements supported net income, balance sheet, and cash flow statement
· Provide the flexibility to only download net income, balance sheet, or cash flow statement, or download all of them at once
· Provide the flexibility to download yearly or quarterly statement
· download period can be up to 5 periods back
You can download the lite version here with absolutely no cost