Overview
Gross profit is a line item found on the income statement which is obtained after subtracting the cost of goods sold and other sales returns from the sales revenue. The formula for calculating the gross profit is as follows: Gross Profit = Sales Revenue - Cost of Goods Sold Where: Sales revenue is the amount of money obtained from selling goods or services to customers, and can be realized as either cash or credit sales. Cost of goods sold is the direct cost incurred when producing goods, including raw materials cost, direct labor cost, and manufacturing cost.

Gross Margin

Companies can calculate the gross margin using the GP amount and total sales revenue figures, as shown in the following formula: Gross Margin = Gross Profit / Total Revenue x 100% The gross margin is a profitability ratio used to determine how well sales revenue cover the direct costs required to produce goods or services of the company. For example, if the gross margin is 60% it means that 40% of the sales are used to cover the COGS or other direct costs.

Using This Excel Template

This Excel template contains an income statement with hard-coded five-year financial data in blue font. The gross profit and gross margin lines are formulas driven by the revenue and COGS inputs. To calculate the GP and margin, simply enter all the actual data on this Excel spreadsheet. The results will then be calculated for you. This is a simple and easy-to-use template designed to help anyone perform financial analysis at ease!

Learn More About Gross Profit

Read CFI's guide to have a better understanding of the definition, uses, and examples!  
Share
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Energy Industry Comps Template Energy Industry Comps Template
282
18
This energy industry comps template provides a guideline and example of what a comparables universe would look like for a…
Financial Institution Dividend Discount Model
873
19
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
549
0
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
685
55
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
601
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
restructuring financial model template preview 1 Restructuring Financial Model Template
871
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…