Calculate your break-even point in units and revenue with contribution margin and sensitivity analysis
You are a financial analyst specializing in cost-volume-profit analysis for businesses across industries. You understand that break-even analysis is the foundation of sound pricing, investment, and operational decisions. Your role is to take raw cost and pricing data, compute the exact break-even point, and then push the analysis further with contribution margin ratios, margin of safety calculations, and sensitivity modeling that most simple calculators ignore. I need a complete break-even analysis for [PRODUCT_NAME] sold by [BUSINESS_NAME], which operates in the [INDUSTRY:select:Retail,E-commerce,Manufacturing,Food and Beverage,Professional Services,Healthcare,Technology,SaaS,Construction,Hospitality,Education,Other] sector. All figures should be presented in [CURRENCY:select:USD,EUR,GBP,CAD,AUD]. The total fixed costs for the [TIME_PERIOD:select:Monthly,Quarterly,Annual] period are [FIXED_COSTS]. These include rent, salaries, insurance, loan payments, depreciation, and any other costs that do not change with production volume. If specific fixed cost categories are available, itemize them for transparency. The variable cost to produce or deliver one unit is [VARIABLE_COST_PER_UNIT]. This covers raw materials, direct labor per unit, packaging, shipping per unit, and transaction or payment processing fees. The selling price per unit is [SELLING_PRICE_PER_UNIT]. Begin the analysis by calculating the contribution margin per unit, which is the selling price minus the variable cost. Then compute the contribution margin ratio by dividing the contribution margin per unit by the selling price. Use these to derive two core metrics: the break-even point in units (fixed costs divided by contribution margin per unit) and the break-even point in revenue (fixed costs divided by the contribution margin ratio). Present both figures clearly and explain what each number means in practical terms for the business. Next, if the business has a target profit goal of [TARGET_PROFIT?], calculate the number of units required to reach that profit. The formula is fixed costs plus target profit, divided by the contribution margin per unit. Show the corresponding revenue figure as well, so the business owner can see both the unit target and the dollar target needed. Perform a sensitivity analysis that tests how the break-even point shifts under different conditions. Model three pricing scenarios: current price, a 10% price increase, and a 10% price decrease. For each scenario, recalculate the break-even units and break-even revenue. Then model three cost scenarios: current variable cost, a 15% increase in variable costs, and a 10% reduction in variable costs. Present these in a clear table format so comparisons are immediate. If the business currently sells or expects to sell [EXPECTED_UNIT_SALES?] units in this period, calculate the margin of safety. Express it in three ways: the margin of safety in units (expected sales minus break-even units), the margin of safety in revenue (expected revenue minus break-even revenue), and the margin of safety percentage (margin of safety in units divided by expected sales, multiplied by 100). Explain what this percentage means for risk exposure. A margin of safety below 20% signals vulnerability to cost increases or demand drops, while a figure above 40% suggests a comfortable buffer. Include an operating power assessment. Calculate the degree of operating power at the expected sales volume using the formula: contribution margin divided by net operating income. Explain that a higher figure means profits grow faster when sales increase, but also decline faster when sales fall. Close with a plain-language summary translating the numbers into a clear action plan. State how many units must be sold each [TIME_PERIOD] to cover all costs and what revenue figure that translates to. If the break-even point is close to or above expected sales, flag this and suggest investigating supplier contracts, pricing adjustments, or fixed cost restructuring.
Use this prompt anywhere
10,000+ expert prompts for ChatGPT, Claude, Gemini, and wherever you use AI.
Get Early AccessEvery business reaches a point where total revenue exactly covers total costs, and knowing that number changes how you price products, plan inventory, and evaluate new ventures. A break-even analysis combines your fixed costs, variable cost per unit, and selling price to produce the exact unit count and revenue figure where profit begins. Most online calculators stop at that single number, but real decisions require more: contribution margin ratios, sensitivity tables showing how price or cost changes move the target, and margin of safety percentages that reveal how much room you have before losses start.
This break-even calculator template goes beyond the basic formula. Enter your [FIXED_COSTS], [VARIABLE_COST_PER_UNIT], and [SELLING_PRICE_PER_UNIT] to get a full financial picture that includes multi-scenario modeling and operating power analysis. Open it in the Dock Editor to generate your personalized report in seconds.
Pair the results with a profit and loss statement to see how break-even performance flows into overall profitability, or use a budget template to map break-even targets against your planned spending for the period. For deeper financial reporting, connect your analysis to a complete income statement that tracks revenue and expenses across your entire operation.
Enter your [PRODUCT_NAME], [BUSINESS_NAME], and select your [INDUSTRY] from the dropdown. Choose the [CURRENCY] so all outputs use the correct monetary format.
Provide your total [FIXED_COSTS] for the selected [TIME_PERIOD] and your [VARIABLE_COST_PER_UNIT]. Fixed costs include rent, salaries, and insurance. Variable costs cover materials, shipping, and per-unit labor.
Enter your [SELLING_PRICE_PER_UNIT]. Optionally add a [TARGET_PROFIT] goal and your [EXPECTED_UNIT_SALES] so the calculator can compute margin of safety and units needed to hit your profit target.
The output shows break-even units, break-even revenue, contribution margin, and a sensitivity table with six pricing and cost scenarios. Use these to stress-test your assumptions before committing to a strategy.
Check whether your margin of safety percentage is above 20% for a reasonable buffer. Review the operating power figure to understand how sensitive your profits are to volume changes.
Determine how many units of a new product must sell each month to cover all fixed and variable costs. Use the sensitivity analysis to decide whether a price increase or cost reduction is the faster path to profitability.
Model break-even timelines for investor pitches by combining unit economics with expected sales ramp. Show exactly when the business turns profitable under conservative, moderate, and aggressive growth scenarios.
Evaluate whether a new product line will reach break-even within an acceptable timeframe. Compare contribution margins across products to prioritize resources toward the highest-margin offerings.
Run cost-volume-profit analysis for quarterly business reviews. Present operating power metrics and margin of safety data to executive teams making pricing or expansion decisions.
Divide your total fixed costs by the contribution margin per unit (selling price minus variable cost). If fixed costs are $10,000 per month, selling price is $50, and variable cost is $30, the contribution margin is $20. The break-even point is 500 units ($10,000 divided by $20). Multiply by the selling price to get $25,000 in break-even revenue.
A bakery pays $3,000 monthly in rent, insurance, and salaries (fixed costs). Each cake costs $8 in ingredients (variable cost) and sells for $25. The contribution margin is $17 per cake. Break-even is 177 cakes per month ($3,000 divided by $17). At that volume the bakery covers all costs, and every cake beyond 177 generates profit.
Break even is the zero-profit point where total revenue equals total costs. Below that point the business operates at a loss. Above it, every additional unit sold generates profit equal to the contribution margin per unit. Knowing this threshold tells you the minimum sales volume needed before the business starts earning money.
The contribution margin ratio is contribution margin per unit divided by the selling price, expressed as a percentage. If your selling price is $100 and variable cost is $60, the ratio is 40%. That means 40 cents of every sales dollar covers fixed costs and generates profit. A higher ratio means the business reaches break even with less total revenue.
Margin of safety measures how far current or expected sales exceed the break-even point. If you sell 800 units and break even at 500, your margin of safety is 300 units or 37.5%. This buffer indicates how much sales could decline before the business starts losing money. Analysts generally consider a margin above 30% to be healthy for most industries.
Add total fixed costs to total variable costs, then divide by the number of units. If fixed costs are $5,000, variable cost per unit is $12, and you plan to sell 400 units, the breakeven price is ($5,000 plus $12 times 400) divided by 400, which equals $24.50. Any price above that figure produces profit on each unit sold.
Higher fixed costs push the break-even point up because you need more contribution margin dollars to cover the larger overhead. If fixed costs rise from $10,000 to $12,000 with the same $20 contribution margin, break-even jumps from 500 to 600 units. Reducing fixed costs through lease renegotiation or staffing changes directly lowers the volume needed to reach profitability.
Yes. Replace units with billable hours or client engagements. Fixed costs remain the same (office rent, software subscriptions, salaried staff). The variable cost per service unit includes contractor fees, travel expenses, or per-project materials. Use a financial statement to track how actual service revenue compares to your calculated break-even target each period.
Discover more prompts that could help with your workflow.
Track daily and monthly expenses with categorized spending logs, trend analysis, and budget alerts for personal or business finances
Generate pro forma financial statements with revenue projections, expense forecasts, and multi-scenario analysis
Project how your savings grow over time with compound interest, regular contributions, and inflation adjustments
10,000+ expert-curated prompts for ChatGPT, Claude, Gemini, and wherever you use AI. Our extension helps any prompt deliver better results.