Financial Modeling Tutorials

- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Present Value of an Annuity Formula
- Future Value of Annuity Due Formula
- Maturity Value
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- Advantages and Disadvantages of NPV
- Mutually Exclusive Projects
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Break Even Analysis
- Breakeven Analysis Examples
- Break Even Chart
- Benefit Cost Ratio
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Payback Period Advantages and Disadvantages
- Profitability Index
- Feasibility Study Examples
- Cash Burn Rate
- Interest Formula
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Growth Rate Formula
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Compounding
- Compounding Formula
- Compound Interest
- Compound Interest Examples
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Discounting Formula
- Rule of 72
- Geometric Mean Return
- Geometric Mean vs Arithmetic Mean
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- EWMA (Exponentially Weighted Moving Average)
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Relative Change
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- APR vs APY
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Correlation Examples
- Coefficient of Determination
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Standard Deviation Examples
- Effect Size
- Sample Size Formula
- Volatility Formula
- Binomial Distribution Formula
- Multicollinearity
- Hypergeometric Distribution
- Exponential Distribution
- Central Limit Theorem
- Poisson Distribution
- Central Tendency
- Hypothesis Testing
- Gini Coefficient
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- Z Score Formula
- Z Test vs T Test
- F-Test Formula
- Quantitative Research
- Histogram Examples

Related Courses

## Break Even Chart

A break-even chart shows the sale volume level where the total costs are equal to the total revenue of the company. The point where total costs are equal to total revenues is known as the break-even point. The company would be in profit above the breakeven point and would incur losses below this point.

On the vertical axis, the breakeven chart plots the revenue, variable cost and the fixed costs of the company and on the horizontal axis, the volume is being plotted. The chart helps in portraying the company’s ability to earn a profit with the present cost structure.

The following example of the break-even chart provides an outline of the most common type of break-even chart present. Each of the examples of breakeven chart states the topic, relevant reasons, and the additional comments wherever required.

### Break-Even Chart Analysis Example

Company Bag Ltd. produces and sales the bags in the market and wants to conduct the break-even analysis of its business. The accountant in charge of the company determined that the fixed cost of the company consisting of salaries of the employees, rent cost, property tax, etc will remain the same at $ 1,000,000. The variable cost which is associated with the production of one unit of the bag will come to $ 20. The bag is sold in the market at a premium price of $ 120. Prepare the break-even chart for Company Bag Ltd.

4.9 (1,067 ratings)

**Solution:**

Given,

- Fixed Cost: $ 1,000,000
- Variable Cost: $ 20 per unit
- Sales price: $ 120 per unit
- Contribution per unit = Sales price per unit – Variable cost per unit
- Contribution per unit = $ 120 – $ 20
- Contribution per unit = $ 100

Calculation of break-even quantity can be done as follows:

**Break-Even Quantity = (Fixed Cost / Contribution per Unit)**

Break Even quantity = ($ 1,000,000 / $ 100)

**Break Even Quantity = 10,000 units**

It shows that the company Bag Ltd. would be required to sell the 10,000 units of bags in order to achieve the break-even at the given fixed cost, selling price and the variable cost of the bag.

### Graphical Presentation of Break-Even Chart

Below is the Break even chart for the above example of bag ltd:

For the presentation of break-even chart total fixed costs, total variable costs, total costs, and the total revenue will be calculated at the particular unit sold as follows

**Calculation of Different Costs for Bag Ltd for Different Number of Units Sold**

#### Break-Even Chart

##### Details

- On the X-axis (horizontal), the number of units is shown and on the Y-axis (vertical), a dollar amount is presented.
- The blue line in the graph represents total fixed costs amounting $ 1000,000. The line of the fixed costs is straight as the fixed cost remains unchanged irrespective of the number of units sold by the company.
- The green line represents revenue from the products sold. For example, selling of 10,000 units of the bag would generate the revenue of $ 1,200,000 (10,000 x $ 120) for the company and selling of 8,000 units of the bag would generate the revenue of $ 960,000 (8,000 x $120).
- The red line represents the total costs i.e., the sum of the fixed costs and the variable costs. Like in the present case, if a company sells the 0 units, then the variable cost of the company would be $ 0 but the fixed costs will be incurred in that case also so the fixed cost would be $ 1000,000 making the total costs to $ 1000,000. Now if a company sells the 10,000 units, then the variable cost of the company would be $ 200,000 (10,000 x $20) and the fixed costs would be $ 1000,000 making the total costs to $ 1,200,000.
- As calculated above the breakeven point of the company is at the 10,000 units. At breakeven point, revenue of the company would be $ 1,200,000 (10,000 x $ 120), the variable costs would be $ 200,000 (10,000 x 2) and the fixed costs would be $ 1,000,000 making the total cost of $ 1,200,000 ($ 200,000 + $ 1,000,000).

##### Analysis

Now, when the number of units sold exceeds the breakeven point of 10,000 units than the company Bag Ltd. would be making profits on the goods sold. As per the chart when the green line of the revenue is greater than the total costs red line after the 10,000 units produced and sold then Bag Ltd. would be making profits on the goods sold. Likewise, in case the number of units sold is below 10,000 units, then the company Bag Ltd. would be in loss. As per the chart, 0-9,999 units produced and sold total costs red line is above the green total revenue line where the company Bag Ltd. would be in loss.

### Conclusion

The break-even chart, also known as the Cost volume profit graph, is a graphical representation of the sales units and the dollar sales required for the break-even. On the vertical axis, the chart plots the revenue, variable cost and the fixed costs of the company and on the horizontal axis, the volume is being plotted.

### Recommended Articles

This has been a guide to Break Even Chart. Here we discuss how to create break-even chart analysis along with practical examples, graphical presentation, and calculations. You can learn more about accounting from following articles –

- Semi Variable Cost | Definition | Example
- Breakeven Analysis Examples
- Accounting Break Even Point
- Unit Contribution Margin Calculation
- Incremental Costs Calculation
- Cost-Benefit Analysis Meaning

- 250+ Courses
- 40+ Projects
- 1000+ Hours
- Full Lifetime Access
- Certificate of Completion