Financial Statement Analysis
- Profitability Ratios
- Profitability Ratios Formula
- Common Size Income Statement
- Vertical Analysis of Income Statement
- Profit Margin
- Profit Margin Formula
- Profit Percentage Formula
- Profit Formula
- Gross Profit Margin Formula
- Gross Profit Percentage
- Operating Profit Margin Formula
- EBIT Margin Formula
- Operating Income Formula
- Net Profit Margin Formula
- EBITDA Margin
- Degree of Operating Leverage Formula (DOL)
- NOPAT Formula
- Earnings Per Share
- Basic EPS
- Diluted EPS
- Basic EPS vs Diluted EPS
- Return on Equity (ROE)
- Return on Equity Ratio
- Return on Capital Employed (ROCE)
- ROCE Formula (Return on Capital Employed)
- Return on Invested Capital (ROIC)
- Return On Investment (ROI)
- Rate of Return on Investment
- Return on Sales
- ROIC Formula (Return on Invested Capital)
- Return on Investment Formula (ROI)
- ROIC vs ROCE
- ROE vs ROA
- Cash on Cash Return
- Return on Total Assets (ROA)
- Return on Total Assets Formula
- Return on Average Capital Employed
- Capital employed Employed
- Return on Average Assets (ROAA)
- Return on Average Equity (ROAE)
- Return on Assets Formula
- Return on Equity Formula
- DuPont Formula
- Net Interest Margin Formula
- Earnings Per Share Formula
- Diluted EPS Formula
- Contribution Margin Formula
- Unit Contribution Margin
- Revenue Per Employee Ratio
- Operating Leverage
- EBIT vs EBITDA
- Capital Gains Yield
- Tax Equivalent Yield
- LTM Revenue
- Operating Expense Ratio Formula
- Overhead Ratio Formula
- Variable Costing Formula
- Capitalization Rate
- Cap Rate Formula
- Comparative Income Statement
- Capacity Utilization Rate Formula
- Total Expense Ratio Formula
- Markup Percentage Formula
- Ratio Analysis (17+)
- Liquidity Ratios (29+)
- Turnover Ratios (17+)
- Efficiency Ratios (7+)
- Dividend Ratios (9+)
- Debt Ratios (26+)
Contribution Margin Formula
The contribution is a significant concept every business owner should understand. To calculate the contribution margin, all we need to look at are the net sales and the total variable expenses. Here’s the contribution margin ratio formula –
Along with finding out the contribution, we can also calculate the contribution margin per unit formula and the contribution ratio.
Contribution Margin Formula Example
Let’s take a practical example which will illustrate this contribution margin formula.
Goodey Company has net sales of $300,000. It has sold 50,000 units of its products. The variable cost of each unit is $2 per unit. Find out the contribution, contribution margin per unit, and contribution ratio.
We will simply use the contribution margin ratio formula to find out the contribution margin per unit and contribution ratio.
- Company has net sales of $300,000.
- Number of units sold was 50,000 units.
- Selling price per unit would be = ($300,000 / 50,000) = $6 per unit.
- Variable cost per unit is $2 per unit.
- Contribution margin per unit formula would be = (Selling price per unit – Variable cost per unit) = ($6 – $2) = $4 per unit.
- Contribution would be = ($4 * 50,000) = $200,000.
- Contribution margin ratio formula would be = Contribution / Sales = $200,000 / $300,000 = 2/3 = 66.67%.
In this example, if we would have been given the fixed expenses, we could also be able to find out the net profit of the firm.
Explanation of Contribution Margin Formula
Contribution is a measurement through which we can understand how much a company’s net sales will contribute to the fixed expenses and the net profit after covering the variable expenses. So, while calculating the contribution, we deduct the total variable expenses from the net sales.
4.9 (1,067 ratings)
Doing that allows us to look at the fixed expenses and net profit. Contribution, thus, can be expressed in another way as well.
We can easily say that –
In situations, where there’s no way we can know the net sales, we can use the above contribution margin ratio formula to find out the contribution.
Use of Contribution Margin Formula
You may ask why we need contribution. We need contribution to find out the break-even point.
We will look at how contribution becomes useful in finding out the break-even point.
Let’s say that a firm’s fixed expenses are $100,000. The variable cost of the firm is $30,000. We need to find out the break-even point.
By using the concept of contribution, we will find out the break-even point.
Here, we can write –
Net Sales – Variable Cost = Fixed Cost + Net Profit
At the break-even point, the key assumption is that there will be no profit or no loss.
- Net Sales – Variable Cost = Fixed Cost + 0
- Or. Net Sales – $30,000 = $100,000
- Or, Net Sales = $100,000 + $30,000 = $130,000.
That means at $130,000 of net sales, the firm would be able to reach the break-even point.
Contribution Margin Calculator
You can use the following Contribution Margin Calculator
|Contribution Margin Formula =||Net Sales – Total Variable Expenses|
|0 – 0 =||0|
Contribution Margin in Excel (with excel template)
Let us now do the same example above in Excel. You must simply use the contribution margin ratio formula to find out the contribution margin per unit.
You can easily calculate the contribution margin ratio in the template provided.
The contribution margin ratio per unit formula would be = (Selling price per unit – Variable cost per unit)
The contribution would be = (Margin per Unit * Number of Units Sold)
The contribution margin ratio would be = margin / Sales
You can download this Contribution Margin Ratio template here – Contribution Margin Ratio Excel Template
Contribution Margin Video
This has been a guide to Contribution Margin formula, Contribution margin calculator, along with examples and excel templates. You may also look at the following articles to enhance your financial skills.
- Explanation of Income Statement Template
- Ratio Formula Excel
- Format of Contribution Margin Income Statement
- Time Value of Money Calculator
- Advantages of Variable Costing Income Statement
- What is Unit Contribution Margin?
- Calculate the Variable Costing Formula
- Income Statement Template
- Asset Turnover Ratio Formula
- Time Value of Money Formula
- Bid-Ask Spread Formula Template)