# Break-Even Analysis Example A single-product break-even pack: contribution margin per unit and percent, break-even units and revenue, margin of safety, target-profit volume, operating leverage on the expected volume, and two 7x7 sensitivity grids that flex price against variable cost and return break-even units and break-even revenue. - Canonical: https://finamodel.com/examples/break-even - Excel download: https://finamodel.com/templates/break-even.xlsx - Category: Corporate Finance - Model type: Operating model - Difficulty: Beginner - Audiences: CFOs & FP&A, Founders & operators, CFOs, FP&A teams, Founders, Operators - Tags: break-even, contribution margin, unit economics, sensitivity, operating leverage ## Overview A break-even analysis computes the unit volume and revenue at which total contribution margin exactly covers total fixed cost - the threshold beyond which an operating business starts generating profit. This template lays the full mechanic on six sheets: an Assumptions sheet that holds price, five variable-cost components, seven fixed-cost categories, expected volume, target profit, sensitivity step widths, and traffic-light thresholds as named-range inputs; a Cost Structure sheet that rolls variable-cost-per-unit and monthly fixed-cost totals with internal consistency checks; a Break-Even sheet that derives contribution margin per unit and percent, break-even units and revenue, margin of safety in units / dollars / percent, target-profit volume, operating income, and operating leverage; a Sensitivity sheet with two 7x7 grids that flex price (rows) against variable cost per unit (columns) and return break-even units in the first grid and break-even revenue in the second; and a Dashboard sheet that surfaces every headline metric with direction-aware traffic-light status. The contribution margin block guards every division: if variable cost exceeds price, contribution margin goes negative and downstream calcs return the N/A string rather than a negative break-even number. The sensitivity grids inherit the same guard - cells where the row price minus the column variable cost is zero or negative print N/A so the surface stays readable across a wide flex band. Operating leverage is computed only when operating income is strictly positive; below break-even, the dashboard reads 'Below break-even' on margin of safety and 'N/A' on leverage, which is the honest answer. CFOs, FP&A teams, founders, and operating leaders use this template for pricing decisions (find the price floor that keeps break-even volume within sales-pipeline reach), cost-down planning (size the prize on a sourcing or vendor-renegotiation initiative by stepping the variable-cost axis), and operating-plan stress tests (read margin of safety and operating leverage straight off the dashboard to quantify downside risk before approving the plan). The sensitivity surface is the killer feature - one glance shows whether the business is robust to a five-dollar price cut or a two-dollar variable-cost hike, or whether the unit economics depend on hitting an exact set of operating assumptions. ## What's included - Variable cost per unit built from five components (materials, labour, packaging, shipping, payment processing) - Monthly fixed cost rolled up from seven categories with internal consistency checks - Contribution margin per unit and percent with divide-by-zero guard - Break-even units, break-even revenue, and N/A handling when variable cost exceeds price - Margin of safety in units, dollars, and percent against the expected monthly volume - Target-profit volume showing the units needed to hit a user-set monthly profit - Operating leverage on the expected volume with guard for non-positive operating income - 2-way sensitivity grids (7x7) on price and variable cost for break-even units and break-even revenue - Dashboard with margin-of-safety and operating-leverage status against user-set thresholds - Monthly fixed cost rolled up from seven categories (rent, salaries, utilities, marketing, insurance, depreciation, other) - Contribution margin per unit and percent, with divide-by-zero guard - Break-even units and revenue, with N/A handling when variable cost exceeds price - Operating leverage on the expected volume with guard for negative operating income - 2-way sensitivity grids (7x7) on price and variable cost returning break-even units and break-even revenue ## Using Break-Even Analysis to Model Contribution Margin, Safety, and Leverage This break-even analysis template explains how to determine the volume at which a product business covers its costs. It covers contribution margin, fixed-cost behaviour, cash versus accounting break-even, margin of safety, operating leverage, and time-to-break-even. Written for finance professionals evaluating the template, it outlines the calculation flow and practical use without promising live formulas or specific financial results. ### Operating Drivers: Price, Variable Costs, and Fixed Costs The model is driven by contribution margin, which depends on selling price and variable cost per unit. - Variable costs are split into a fixed dollar amount per unit, a percentage of price (such as payment processing), and a per-transaction fee, so the model adapts when price changes. - Fixed costs are not one lump: they include truly fixed items like rent, step-fixed items like added shifts that jump at trigger volumes, and semi-variable items like marketing that scale with revenue. - This split lets you see how cost structure responds as volume rises or falls. ### Calculation Flow: From Contribution Margin to Break-Even Break-even units are calculated by dividing total fixed costs by contribution margin per unit. The model then derives break-even revenue by multiplying those units by the selling price. - Two versions are produced: accounting break-even includes depreciation, while cash break-even excludes it to show the operating cash threshold. Margin of safety compares expected volume to break-even volume in both units and dollars. - Target-profit tiers extend the same formula by adding a target profit to fixed costs before dividing by contribution margin. ### Outputs: Sensitivity, Operating Leverage, and Time-to-Break-Even Outputs include two sensitivity grids that flex price against variable cost and return break-even units and revenue, plus additional grids for volume versus fixed cost and volume versus price. - A degree of operating leverage value shows how a percentage change in volume affects operating income, accompanied by a caveat that flags inflated leverage when operating income is a small share of contribution margin. - A time-to-break-even projection estimates the month when cumulative operating income turns positive, based on a volume ramp over 24 months. ### Practical Use and Limitations This template suits new product launches, pricing decisions, and cost-structure assessments, where the central question is how many units cover costs and how much cushion exists. - It intentionally excludes full profit-and-loss statements, working capital, and valuation, so it should not replace a three-statement or DCF model. - With the public download being a values-only preview of the underlying template, the logic described here reflects the modelled relationships rather than automatic recalculation. - Use it to frame operating economics, not as a standalone forecasting tool. ## Built for pricing and cost decisions When the question is "can we hold this price?" or "how much sourcing has to come out?", break-even is the unit-economics health check that gives the cleanest answer. This template lays the full mechanic on one set of sheets so a single input edit flips the whole picture. ## Designed for one-screen reading Every headline metric sits on a one-page Dashboard with traffic-light status, and the sensitivity surface is two 7x7 grids that fit on a single screen - no scrolling through a wall of formulas to find the answer. ## Audit-friendly mechanics Every input is a named range, every formula is one or two operations, divide-by-zero and negative-margin paths return N/A rather than meaningless numbers, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Built for pricing and cost decisions When the question is "can we hold this price?" or "how much sourcing has to come out?", break-even is the unit-economics health check that gives the cleanest answer. This template lays the full mechanic on one set of sheets so a single input edit flips the whole picture. ## Designed for one-screen reading Every headline metric sits on a one-page Dashboard with traffic-light status, and the sensitivity surface is two 7x7 grids that fit on a single screen - no scrolling through a wall of formulas to find the answer. ## Audit-friendly mechanics Every input is a named range, every formula is one or two operations, divide-by-zero and negative-margin paths return N/A rather than meaningless numbers, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: price, variable-cost components, fixed-cost categories, volume, target, sensitivity steps, thresholds. - Selling price per unit - Five variable-cost components (materials, labour, packaging, shipping, processing) - Seven fixed-cost categories (rent, salaries, utilities, marketing, insurance, depreciation, other) - Expected monthly volume and target monthly profit - Sensitivity step widths for price and variable cost - Margin-of-safety and operating-leverage thresholds (green / amber) ### Cost Structure Variable cost per unit and monthly fixed cost roll-up with internal checks. - Five variable-cost component rows summing to Total VC per unit - Seven fixed-cost category rows summing to Total monthly FC - Cost summary block exposing price and total VC to downstream sheets - Check rows that resolve to zero when components match totals ### Break-Even Contribution margin, break-even point, margin of safety, target profit, operating leverage. - CM per unit = Price − VC per unit; CM % = CM per unit / Price - BE units = Total FC / CM per unit; BE revenue = BE units × Price - Margin of safety in units, dollars, percent vs Expected_Volume - Target volume = (Total FC + Target_Profit) / CM per unit - Operating leverage = Total CM / Operating Income with N/A guard ### Sensitivity Two 7x7 grids on price (rows) and variable cost per unit (columns). - Grid 1: Break-even units across price ± three steps and VC ± three steps - Grid 2: Break-even revenue across the same axes - Axis values built from named-range step widths so a single edit reshapes the surface - N/A handling on cells where price ≤ variable cost ### Dashboard One-page rollup with traffic-light status on margin of safety and operating leverage. - CM per unit and CM % - Break-even units and revenue - Margin of safety % with Below break-even / Off track / Watch / On track status - Target volume and operating income - Operating leverage with On track / Watch / High risk status ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: price, variable-cost components, fixed-cost categories, volume, target, sensitivity steps, thresholds. - Selling price per unit - Five variable-cost components (materials, labour, packaging, shipping, processing) - Seven fixed-cost categories (rent, salaries, utilities, marketing, insurance, depreciation, other) - Expected monthly volume and target monthly profit - Sensitivity step widths for price and variable cost - Margin-of-safety and operating-leverage thresholds (green / amber) ### Cost Structure Variable cost per unit and monthly fixed cost roll-up with internal checks. - Five variable-cost component rows summing to Total VC per unit - Seven fixed-cost category rows summing to Total monthly FC - Cost summary block exposing price and total VC to downstream sheets - Check rows that resolve to zero when components match totals ### Break-Even Contribution margin, break-even point, margin of safety, target profit, operating leverage. - CM per unit = Price − VC per unit; CM % = CM per unit / Price - BE units = Total FC / CM per unit; BE revenue = BE units × Price - Margin of safety in units, dollars, percent vs Expected_Volume - Target volume = (Total FC + Target_Profit) / CM per unit - Operating leverage = Total CM / Operating Income with N/A guard ### Sensitivity Two 7x7 grids on price (rows) and variable cost per unit (columns). - Grid 1: Break-even units across price ± three steps and VC ± three steps - Grid 2: Break-even revenue across the same axes - Axis values built from named-range step widths so a single edit reshapes the surface - N/A handling on cells where price ≤ variable cost ### Dashboard One-page rollup with traffic-light status on margin of safety and operating leverage. - CM per unit and CM % - Break-even units and revenue - Margin of safety % with Below break-even / Off track / Watch / On track status - Target volume and operating income - Operating leverage with On track / Watch / High risk status ## Features - **Two-way sensitivity grid:** Two 7x7 grids let you flex price up or down in user-set dollar steps against variable cost up or down in user-set dollar steps. Cells where price falls below variable cost return N/A rather than a meaningless negative break-even number. - **Direction-aware status logic:** Margin-of-safety status reads 'On track / Watch / Off track / Below break-even' against user thresholds, while operating leverage flips so 'high risk' triggers when leverage exceeds the amber band. One mechanic, both directions. - **Single-cell input driving every output:** Every fixed-cost category, variable-cost component, price, volume, target, and sensitivity step is a named-range input. Flex any one and the contribution margin, break-even point, sensitivity surface, and dashboard recompute instantly. ## Use cases - **Pricing decision support:** Walk the sensitivity grid to find the price floor that keeps break-even volume within reach of the realistic sales pipeline, before committing to a price change. - **Cost-down planning:** Step the variable-cost axis down (lower materials, lower processing fee) and watch break-even units fall to size the prize on a sourcing or vendor-renegotiation initiative. - **Operating-plan stress test:** Set the expected volume to the budgeted run-rate and read the margin-of-safety percent and operating-leverage multiple straight off the dashboard to size downside risk before approving the plan. ## Frequently asked questions ### What is a break-even analysis? A break-even analysis computes the unit volume (and revenue) at which total contribution margin covers total fixed cost so operating income is exactly zero. It is the simplest unit-economics health check for any single-product business with a clean fixed / variable cost split. ### How do I plug in my own numbers? Edit the values on the Assumptions sheet: price, the five variable-cost components, the seven fixed-cost categories, the expected monthly volume, the target profit, and the two sensitivity step widths. Every downstream sheet (Cost Structure, Break-Even, Sensitivity, Dashboard) recalculates immediately. ### Why does the operating leverage row sometimes show N/A? Operating leverage is total contribution margin divided by operating income. If operating income is zero or negative (i.e. expected volume is at or below break-even), the ratio is undefined or negative, so the model returns N/A rather than a meaningless number. Raise expected volume above break-even to see a positive leverage multiple. ### Why do some sensitivity grid cells say N/A? Where the row price minus the column variable cost is zero or negative, there is no break-even - selling each unit destroys margin and no volume covers fixed costs. The grid prints N/A in those cells so the surface stays readable. ### Can I add more cost categories? Yes. Add a row to Assumptions, register a named range, add the matching component on Cost Structure inside the existing SUM range, and the Total_Fixed_Cost or VC_Per_Unit named range will pick it up automatically. The Break-Even and Sensitivity sheets reference the totals via named range, not row number. ## Related templates - [Unit Economics Dashboard](https://finamodel.com/templates/unit-economics-model) - [Budget vs Actuals Tracker](https://finamodel.com/templates/budget-vs-actuals) - [3 Statement Model](https://finamodel.com/templates/3-statement-model)