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
restructuring financial model template preview 1 Restructuring Financial Model Template
175
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
255
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
bank financial model template preview 1 Bank Financial Model Template
268
0
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Synthetic Call Chart Option Profit/Loss Graph Maker
841
235
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
668
0
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
388
105
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…